names

612 rows where place_id = 598666

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628919 1903922 1903922 defendant Richardson John mercer 598666 598666 Richardson, John, of Newcastle, mercer 0
3628920 1903922 1903922 defendant Bagnold Ralph husbandman 598666 598666 Bagnold, Ralph, of Newcastle, husbandman 1
3628922 1903923 1903923 defendant Roker John smith 598666 598666 Roker, John, of Newcastle, smith 0
3633472 1905282 1905282 defendant Henley John mercer 598666 598666 Henley, John, of Newcastle under Lyme, mercer 0
3634563 1905613 1905613 defendant Bewyk John merchant 598666 598666 Bewyk, John, of Newcastle, merchant 0
3638019 1906707 1906707 defendant Badnald Ralph butcher 598666 598666 Badnald, Ralph, of Newcastle under Lyme, butcher 2
3638021 1906708 1906708 defendant Smyth Robert butcher 598666 598666 Smyth, Robert, of Newcastle under Lyme, butcher 0
3638023 1906709 1906709 defendant Smyth Robert butcher 598666 598666 Smyth, Robert, of Newcastle under Lyme, butcher 0
3641527 1907807 1907807 defendant Leighton John tanner 598666 598666 Leighton, John, of Newcastle under Lyme, tanner 1
3651419 1910808 1910808 defendant Boghey Richard butcher 598666 598666 Boghey, Richard, of Newcastle under Lyme, butcher 3
3655502 1911980 1911980 defendant Telryk Randolf   598666 598666 Telryk, Randolf, of Newcastle under Lyme 0
3655503 1911980 1911980 defendant Apoynton Randolf capper 598666 598666 Apoynton, Randolf, of Newcastle under Lyme, capper 1
3655504 1911980 1911980 defendant Rawne John sheerman 598666 598666 Rawne, John, of Newcastle under Lyme, sheerman 2
3655505 1911980 1911980 defendant Herreson William sadler 598666 598666 Herreson, William, of Newcastle under Lyme, sadler 3
3656733 1912360 1912360 defendant Bret William sheerman 598666 598666 Bret, William, of Newcastle under Lyme, sheerman 1
3656734 1912360 1912360 defendant Robyns John yeoman 598666 598666 Robyns, John, of Newcastle under Lyme, yeoman 2
3656735 1912360 1912360 defendant Robyns Richard   598666 598666 Robyns, Richard, of Newcastle 3
3658220 1912826 1912826 defendant Beyle Ralph butcher 598666 598666 Beyle, Ralph, of Newcastle under Lyme, butcher 0
3658221 1912826 1912826 defendant Beyle Thomas butcher 598666 598666 Beyle, Thomas, of Newcastle under Lyme, butcher 1
3658222 1912826 1912826 defendant Beyle Stephen butcher 598666 598666 Beyle, Stephen, of Newcastle under Lyme, butcher 2
3658223 1912826 1912826 defendant Rane John sheerman 598666 598666 Rane, John, of Newcastle under Lyme, sheerman 3
3658224 1912826 1912826 defendant Annon William glover 598666 598666 Annon, William, of Newcastle under Lyme, glover 4
3658228 1912828 1912828 defendant Beyle Ralph butcher 598666 598666 Beyle, Ralph, of Newcastle under Lyme, butcher 0
3658229 1912828 1912828 defendant Beyle Thomas butcher 598666 598666 Beyle, Thomas, of Newcastle under Lyme, butcher 1
3658230 1912828 1912828 defendant Beyle Stephen butcher 598666 598666 Beyle, Stephen, of Newcastle under Lyme, butcher 2
3658231 1912828 1912828 defendant Rane John sheer man 598666 598666 Rane, John, of of Newcastle under Lyme, sheer man 3
3658232 1912828 1912828 defendant Anyon William glover 598666 598666 Anyon, William, of of Newcastle under Lyme, glover 4
3658371 1912867 1912867 defendant Hynley John mercer 598666 598666 Hynley, John, of Newcastle under Lyme, mercer 0
3659951 1913370 1913370 defendant Bayly Ralph butcher 598666 598666 Bayly, Ralph, of Newcastle under Lyme, butcher 3
3660123 1913428 1913428 defendant Proctour John mercer 598666 598666 Proctour, John, of Newcastle under Lyme, mercer 1
3660125 1913429 1913429 defendant Smyth John yeoman 598666 598666 Smyth, John, of Newcastle under Lyme, yeoman 0
3660131 1913430 1913430 defendant Smyth John yeoman 598666 598666 Smyth, John, of Newcastle under Lyme, yeoman 0
3660135 1913430 1913430 defendant Smyth George tanner 598666 598666 Smyth, George, of Newcastle under Lyme, tanner 4
3666349 1915425 1915425 defendant Proctur John yeoman 598666 598666 Proctur, John, of Newcastle under Lyme, yeoman 0
3666350 1915425 1915425 defendant Cleyton John yeoman 598666 598666 Cleyton, John, of Newcastle under Lyme, yeoman 1
3666351 1915425 1915425 defendant Telryg Randolf glover 598666 598666 Telryg, Randolf, of Newcastle under Lyme, glover 2
3666352 1915425 1915425 defendant Ryggys Richard cordwainer 598666 598666 Ryggys, Richard, of Newcastle under Lyme, cordwainer 3
3668280 1916024 1916024 defendant Chatter Peter merchant 598666 598666 Chatter, Peter, of Newcastle, merchant 2
3668281 1916024 1916024 defendant Anderson Henry merchant 598666 598666 Anderson, Henry, of Newcastle, merchant 3
3672902 1917538 1917538 defendant Wardhawgh John walker 598666 598666 (Wardhawgh, John, of Newcastle, walker 2
3672903 1917538 1917538 defendant Stykney Thomas   598666 598666 Stykney, Thomas, of Newcastle, mason 3
3673106 1917598 1917598 defendant Bayly Ralph butcher 598666 598666 Bayly, Ralph, of Newcastle under Lyme, butcher 0
3675318 1918322 1918322 defendant Robyns John yeoman 598666 598666 Robyns, John, of Newcastle under Lyme, yeoman 0
3675490 1918374 1918374 plaintiff Helme Nicholas yeoman 598666 598666 Helme, Nicholas, of Newcastle, yeoman 0
3682142 1920523 1920523 defendant Smyth George tanner 598666 598666 Smyth, George, of Newcastle under Lyme, tanner 3
3682143 1920523 1920523 defendant Thikkyns Thomas capper 598666 598666 Thikkyns, Thomas, of Newcastle under Lyme, capper 4
3684754 1921368 1921368 defendant Amyon William glover 598666 598666 Amyon, William, of Newcastle under Lyme, glover 2
3695251 1924733 1924733 defendant Grevys William dyer 598666 598666 Grevys, William, of Newcastle under Lyme, dyer 0
3695256 1924735 1924735 defendant Harreson William saddler 598666 598666 Harreson, William, of Newcastle under Lyme, saddler 1
3695257 1924735 1924735 defendant Hendeley John mercer 598666 598666 Hendeley, John, of Newcastle under Lyme, mercer 2
3695260 1924736 1924736 defendant Harreson William saddler 598666 598666 Harreson, William, of Newcastle under Lyme, saddler 1
3695261 1924736 1924736 defendant Hendeley John mercer 598666 598666 Hendeley, John, of Newcastle under Lyme, mercer 2
3695369 1924777 1924777 defendant Poynton Ralph capper 598666 598666 Poynton, Ralph, of Newcastle under Lyme, capper 0
3699992 1926231 1926231 defendant Amyon William glover 598666 598666 Amyon, William, of Newcastle under Lyme, glover 2
3700514 1926403 1926403 defendant Smyth George yeoman 598666 598666 Smyth, George, of Newcastle under Lyme, yeoman 0
3700515 1926403 1926403 defendant Robyns Thomas innholder 598666 598666 Robyns, Thomas, of Newcastle under Lyme, innholder 1
3700516 1926403 1926403 defendant Thikons Thomas capper 598666 598666 Thikons, Thomas, of Newcastle under Lyme, capper 2
3713977 1930670 1930670 defendant Bagnold John yeoman 598666 598666 Bagnold John, of Newcastle under Lyme, yeoman 0
3714526 1930840 1930840 defendant Kelyng Richard capper 598666 598666 Kelyng, Richard, of Newcastle under Lyme, capper 0
3714988 1930985 1930985 plaintiff Brandelyng John (legal representative) 598666 598666 Brandelyng, John, of Newcastle, merchant, executor of 0
3714992 1930986 1930986 plaintiff Brandelyng John (legal representative) 598666 598666 Brandelyng, John, of Newcastle, merchant, executor of 0
3717959 1931918 1931918 defendant Creswell Robert gent 598666 598666 Creswell, Robert, of Newcastle, gent 0
3717978 1931919 1931919 defendant Lawson James merchant 598666 598666 Lawson, James, of Newcastle, merchant 0
3721896 1933115 1933115 defendant Birde George gent 598666 598666 Birde, George, of Newcastle, gent 4
3722573 1933320 1933320 defendant Bagnall John yeoman 598666 598666 Bagnall, John, of Newcastle under Lyme, yeoman 0
3726737 1934627 1934627 defendant Hyndley John mercer 598666 598666 Hyndley, John, of Newcastle under Lyme, mercer 0
3726738 1934627 1934627 defendant Felkyns Hugh husbandman 598666 598666 Felkyns, Hugh, of Newcastle under Lyme, husbandman 1
3733609 1936757 1936757 defendant Trymmell Roger yeoman 598666 598666 Trymmell, Roger, of Newcastle under Lyme, yeoman 1
3733901 1936849 1936849 defendant Thropp John nailer 598666 598666 Thropp, John, of Newcastle under Lyme, nailer 4
3744400 1940149 1940149 defendant Greyves William dyer 598666 598666 Greyves, William, of Newcastle under Lyme, dyer 0
3744402 1940150 1940150 defendant Pateson John yeoman 598666 598666 Pateson, John, of Newcastle under Lyme, yeoman 0
3758836 1944751 1944751 defendant Burgh John scrivener 598666 598666 Burgh, John, of Newcastle, scrivener 0
3759461 1944952 1944952 defendant Poynton Randolph capper 598666 598666 Poynton, Randolph, of Newcastle under Lyme, capper 2
3764900 1946687 1946687 defendant Bradshagh Thomas yeoman 598666 598666 Bradshagh, Thomas, of Newcastle under Lyme, yeoman 1
3767233 1947391 1947391 defendant Smyth George tanner 598666 598666 Smyth, George, of Newcastle under Lyme, tanner 0
3774607 1949784 1949784 defendant Pateson John yeoman 598666 598666 Pateson, John, of Newcastle under Lyme, yeoman 0
3783816 1952708 1952708 defendant Leyghton Ralph tanner 598666 598666 Leyghton, Ralph, of Newcastle under Lyne, tanner 0
3783817 1952708 1952708 defendant Telreke Ralph tanner or glover 598666 598666 Telreke, Ralph, of Newcastle under Lyne, tanner or glover 1
3788952 1954357 1954357 defendant Alen Roger butcher 598666 598666 Alen, Roger, of Newcastle under Lyne, butcher 0
3788953 1954357 1954357 defendant Bl- John draper 598666 598666 Bl-, John, of Newcastle under Lyne, draper 1
3790400 1954816 1954816 defendant Alen Roger butcher 598666 598666 Alen, Roger, of Newcastle under Lyne, butcher 0
3791417 1955152 1955152 defendant Rychardson Thomas mercer 598666 598666 Rychardson, Thomas, of Newcastle under Lyme, mercer 1
3792289 1955443 1955443 defendant Pateson John yeoman 598666 598666 Pateson, John, of Newcastle under Lyne, yeoman 0
3810219 1961090 1961090 defendant Pateson John yeoman 598666 598666 Pateson, John, of Newcastle under Lyme, yeoman 0
3813044 1961985 1961985 defendant Daweson William tailor 598666 598666 Daweson, William, of Newcastle under Lyme, tailor 2
3816169 1962962 1962962 defendant Dawson David cordwainer 598666 598666 Dawson, David, of Newcastle, cordwainer 0
3816170 1962962 1962962 defendant Amberye John merchant 598666 598666 Amberye, John, of Newcastle, merchant 1
3816171 1962962 1962962 defendant Amberye Robert chaplain 598666 598666 Amberye, Robert, of Newcastle, chaplain 2
3816172 1962962 1962962 defendant Folberye Lawrence merchant 598666 598666 Folberye, Lawrence, of Newcastle, merchant 3
3819925 1964112 1964112 defendant Pateson James mercer 598666 598666 Pateson, James, of Newcastle under Lyme, mercer 0
3821382 1964582 1964582 defendant Bayly Stephen butcher 598666 598666 Bayly, Stephen, of Newcastle under Lyme, butcher 3
3825781 1965909 1965909 defendant Rane John sherman 598666 598666 Rane, John, of Newcastle under Lyme, sherman 0
3830354 1967388 1967388 defendant Turnour Roger   598666 598666 Turnour, Roger, of Newcastle 2
3840160 1970494 1970494 defendant Tane John sherman 598666 598666 Tane, John, of Newcastle under Lyne, sherman 0
3841715 1970993 1970993 defendant Beche John tailor 598666 598666 Beche, John, of Newcastle under Lyne, tailor 0
3843273 1971429 1971429 defendant Roker John husbandman 598666 598666 Roker, John, of Newcastle under Lyne, husbandman 3
3848216 1973009 1973009 defendant Kelyng Ralph tanner 598666 598666 Kelyng, Ralph, of Newcastle under Lyne, tanner 0
3854393 1975011 1975011 defendant Roker John, junior smith 598666 598666 Roker, John, junior, of Newcastle under Lyne, smith 3
3856942 1975801 1975801 defendant Rane John sherman 598666 598666 Rane, John, of Newcastle under Lyme, sherman 0
3857060 1975840 1975840 defendant Bayle Stephen butcher 598666 598666 Bayle, Stephen, of Newcastle under Lyme, butcher 3

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);