names

48 rows where place_id = 604535

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3658328 1912858 1912858 plaintiff Emson Thomas esq 604535 604535 Emson, Thomas, of Eston, Nhants, esq 0
3659837 1913331 1913331 defendant Emson Thomas esq 604535 604535 Emson, Thomas, of Eston, Nhants, esq 0
3681068 1920155 1920155 defendant Empson Thomas esq 604535 604535 Empson, Thomas, of Eston, Nhants, esq 0
3681070 1920156 1920156 defendant Emson Thomas esq 604535 604535 Emson, Thomas, of Eston, Nhants, esq 0
3688617 1922597 1922597 defendant Empson Thomas esq 604535 604535 Empson, Thomas, of Eston, Nhants, esq 0
3688620 1922598 1922598 defendant Empson Thomas esq 604535 604535 Empson, Thomas, of Eston, Nhants, esq 0
3689866 1922988 1922988 defendant Empson Thomas esq 604535 604535 Empson, Thomas, of Eston, Nhants, esq 0
3694031 1924337 1924337 defendant Empson Thomas esq 604535 604535 Empson, Thomas, of Eston, Nhants, esq 0
3696143 1925017 1925017 defendant Emson Thomas esq 604535 604535 Emson, Thomas, of Eston, Nhants, esq 0
3699617 1926106 1926106 defendant Empson John esq 604535 604535 Empson, John, of Eston, Nhants, esq 0
3704336 1927657 1927657 defendant Empson Thomas esq 604535 604535 Empson, Thomas, of Eston, Nhants, esq 0
3710331 1929548 1929548 defendant Emson Thomas esq 604535 604535 Emson, Thomas, of Eston, Nhants, esq 0
3715022 1930993 1930993 defendant Brayllesford John   604535 604535 Brayllesford, John, of Eston, Nhants, yeoman, administrators of 0
3722681 1933358 1933358 defendant Empson Thomas esq 604535 604535 Empson, Thomas, of Eston, Nhants, esq 0
3726026 1934413 1934413 defendant Empson Thomas gent 604535 604535 Empson, Thomas, of Eston, Nhants, gent 0
3727270 1934804 1934804 defendant Empson Thomas gent 604535 604535 Empson, Thomas, of Eston, Nhants, gent 0
3739973 1938722 1938722 defendant Cordall John yeoman 604535 604535 Cordall, John, of Eston, Nhants, yeoman 0
3745997 1940653 1940653 defendant Empson Thomas esq 604535 604535 Empson, Thomas, of Eston, Nhants, esq 0
3753161 1942928 1942928 defendant Empson Thomas gent 604535 604535 Empson, Thomas, of Eston, Nhants, gent 0
3759026 1944810 1944810 defendant Empson Thomas esq 604535 604535 Empson, Thomas, of Eston, Nhants, esq 0
3811565 1961512 1961512 defendant Sleford Richard gent 604535 604535 Sleford, Richard, of Eston, Nhants, gent 0
3811567 1961513 1961513 defendant Sleford Richard gent 604535 604535 Sleford, Richard, of Eston, Nhants, gent 0
3817383 1963348 1963348 defendant Ranton Thomas slater 604535 604535 Ranton, Thomas, of Eston, Nhants, slater 2
3956670 2009398 2009398 defendant Fermer John   604535 604535 Fermer, John, of Eston, Nhants, knight 0
3961914 2011262 2011262 defendant Devanck John clerk 604535 604535 Devanck, John, of Eston, Nhants, clerk 0
4020128 2031921 2031921 defendant Farmer George esq 604535 604535 Farmer, George, of Eston, Nhants, esq 2
4112656 2064784 2064784 defendant Fermer George esq 604535 604535 Fermer, George, of Eston, Nhants, esq 0
4246385 2111769 2111769 defendant Farmar George   604535 604535 Farmar, George, of Eston, Nhants, knight 0
4270912 2119846 2119846 defendant Farmar George   604535 604535 Farmar, George, of Eston, Nhants, knight 0
4700458 2265557 2265557 defendant Bacon Laurence   604535 604535 Bacon, Laurence, of Eston, Nhants, franklin 0
4700460 2265558 2265558 defendant Bacon Laurence   604535 604535 Bacon, Laurence, of Eston, Nhants, franklin 0
4722805 2272447 2272447 defendant Grubbe Robert tailor 604535 604535 Grubbe, Robert, of Eston, Nhants, tailor 0
4722806 2272447 2272447 defendant Stephen Thomas tiler 604535 604535 Stephen, Thomas, of Eston, Nhants, tiler 1
4722807 2272447 2272447 defendant Lane William in the husbandman 604535 604535 Lane, William in the, of Eston, Nhants, husbandman 2
4742486 2278302 2278302 defendant Bachiler Thomas laborer 604535 604535 Bachiler, Thomas, of Eston, Nhants, laborer 3
4891461 2324062 2324062 defendant Geldsowe Alexander   604535 604535 Geldsowe, Alexander, of Eston, Nhants, "geldsowe" 1
4939443 2338718 2338718 defendant Hoggekyn Thomas yeoman 604535 604535 Hoggekyn, Thomas, of Eston, Nhants, yeoman 2
4956280 2343839 2343839 defendant Steynesmore William husbandman 604535 604535 Steynesmore, William, of Eston, Nhants, husbandman 1
4962711 2345753 2345753 defendant Hoggekyns Thomas yeoman 604535 604535 Hoggekyns, Thomas, of Eston, Nhants, yeoman 1
4964515 2346293 2346293 defendant Fysshey William slater 604535 604535 Fysshey, William, of Eston, Nhants, slater 0
4996827 2355907 2355907 defendant Tr_ Thomas esq 604535 604535 Tr_, Thomas, of Eston, Nhants, esq 2
5067324 2376735 2376735 defendant Trussell Thomas esq 604535 604535 Trussell, Thomas, of Eston, Nhants, esq 0
5115910 2391081 2391081 defendant Trussell John   604535 604535 Trussell, John, of Eston, Nhants 4
5228253 2423871 2423871 defendant Wytmore Henry yeoman 604535 604535 Wytmore, Henry, of Eston, Nhants, yeoman 0
5228255 2423872 2423872 defendant Wytmore Henry yeoman 604535 604535 Wytmore, Henry, of Eston, Nhants, yeoman 0
5243283 2428236 2428236 defendant Trussell Thomas   604535 604535 Trussell, Thomas, of Eston, Nhants, knight 3
5262331 2433968 2433968 defendant Varnam John clerk 604535 604535 Varnam, John, of Eston, Nhants, clerk 0
5273913 2437450 2437450 defendant Trussell Thomas   604535 604535 Trussell, Thomas, of Eston, Nhants, knight 4

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);