names

76 rows where place_id = 589158

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596716 1866607 1866607 defendant Gylham Richard husbandman 589158 589158 Gylham, Richard, of Wyllyngdon, husbandman 4
3622843 1874674 1874674 defendant Norman Thomas laborer 589158 589158 Norman, Thomas, of Wyllyngdon, laborer 0
3622844 1874674 1874674 defendant bregger Geoffrey laborer 589158 589158 bregger, Geoffrey, of Wyllyngdon, laborer 1
3622845 1874674 1874674 defendant Baker Thomas laborer 589158 589158 Baker, Thomas, of Wyllyngdon, laborer 2
3622846 1874674 1874674 defendant William John laborer 589158 589158 William, John, of Wyllyngdon, laborer 3
3622847 1874674 1874674 defendant Bend John laborer 589158 589158 Bend, John, of Wyllyngdon, laborer 4
3622848 1874674 1874674 defendant Leme or Leine John laborer 589158 589158 Leme or Leine, John, of Wyllyngdon, laborer 5
3622849 1874674 1874674 defendant Sillunston John laborer 589158 589158 Sillunston, John, of Wyllyngdon, laborer 6
3622850 1874674 1874674 defendant Jope John husbandman 589158 589158 Jope, John, of Wyllyngdon, husbandman 7
3622851 1874674 1874674 defendant Hogge John laborer 589158 589158 Hogge, John, of Wyllyngdon, laborer 8
3678710 1919407 1919407 defendant Russell John husbandman 589158 589158 Russell, John, of Wyllyngdon, husbandman 0
3678958 1919487 1919487 defendant Peers John yeoman 589158 589158 Peers, John, of Wyllyngdon, yeoman 1
3708627 1928996 1928996 defendant Peers John yeoman 589158 589158 Peers, John, of Wyllyngdon, yeoman 1
3715500 1931135 1931135 defendant Nicolas John yeoman 589158 589158 Nicolas, John, of Wyllyngdon, yeoman 2
3716553 1931473 1931473 defendant Davye William tailor 589158 589158 Davye, William, of Wyllyngdon, tailor 1
3725041 1934116 1934116 defendant Parker John gent 589158 589158 Parker, John, of Wyllyngdon, gent 0
3725044 1934117 1934117 defendant Parker John gent 589158 589158 Parker, John, of Wyllyngdon, gent 0
3726806 1934651 1934651 defendant Russell John yeoman 589158 589158 Russell, John, of Wyllyngdon, yeoman 0
3740933 1939025 1939025 defendant Parker John gent 589158 589158 Parker, John, of Wyllyngdon, gent 0
3750910 1942207 1942207 defendant Parker John gent 589158 589158 Parker, John,of Wyllyngdon, gent 0
3751749 1942464 1942464 defendant Hethfeld Thomas husbandman 589158 589158 Hethfeld, Thomas, of Wyllyngdon, husbandman 0
3751751 1942465 1942465 defendant Hethfeld Thomas husbandman 589158 589158 Hethfeld, Thomas, of Wyllyngdon, husbandman 0
3759419 1944935 1944935 defendant Colfeld William husbandman 589158 589158 Colfeld, William, of Wyllyngdon, husbandman 0
3772761 1949172 1949172 defendant A Leme John husbandman 589158 589158 A Leme, John, of Wyllyngdon, husbandman 0
3821417 1964593 1964593 plaintiff Parker John gent 589158 589158 Parker, John, of Wyllyngdon, gent 3
3853060 1974577 1974577 defendant Nycholas John husbandman 589158 589158 Nycholas, John, of Wyllyngdon, husbandman 0
3865446 1978660 1978660 defendant Dockyng John husbandman 589158 589158 Dockyng, John, of Wyllyngdon, husbandman 0
3888619 1986449 1986449 defendant Hobye Peter husbandman 589158 589158 Hobye, Peter, of Wyllyngdon, husbandman 0
3917059 1996063 1996063 defendant Osborn John   589158 589158 Osborn, John, of Wyllyngdon, mill wright 0
3995000 2022957 2022957 defendant Bagge John clerk 589158 589158 Bagge, John, of Wyllyngdon, clerk 0
4066252 2048219 2048219 defendant Turner William butcher 589158 589158 Turner, William, of Wyllyngdon, butcher 0
4074754 2051270 2051270 defendant Akeherst Richard husbandman 589158 589158 Akeherst, Richard, of Wyllyngdon, husbandman 2
4074755 2051270 2051270 defendant Colvyle Thomas husbandman 589158 589158 Colvyle, Thomas, of Wyllyngdon, husbandman 3
4094036 2058196 2058196 defendant Pudland Thomas yeoman 589158 589158 Pudland, Thomas, of Wyllyngdon, yeoman 0
4094037 2058196 2058196 defendant Colvyle Thomas yeoman 589158 589158 Colvyle, Thomas, of Wyllyngdon, yeoman 1
4094038 2058196 2058196 defendant Draper Richard husbandman 589158 589158 Draper, Richard, of Wyllyngdon, husbandman 2
4112671 2064791 2064791 defendant Colvyle Thomas husbandman 589158 589158 Colvyle, Thomas, of Wyllyngdon, husbandman 0
4112673 2064792 2064792 defendant Colvyle Thomas yeoman or husbandman 589158 589158 Colvyle, Thomas, of Wyllyngdon, yeoman or husbandman 0
4115087 2065684 2065684 defendant Colvyle Thomas yeoman 589158 589158 Colvyle, Thomas, of Wyllyngdon, yeoman 0
4381793 2158592 2158592 defendant Putland Thomas yeoman 589158 589158 Putland, Thomas, of Wyllyngdon, yeoman 0
4381794 2158592 2158592 defendant Howell Edward yeoman 589158 589158 Howell, Edward, of Wyllyngdon, yeoman 1
4381797 2158593 2158593 defendant Putland Thomas yeoman 589158 589158 Putland, Thomas, of Wyllyngdon, yeoman 0
4543439 2213838 2213838 defendant Ponte William   589158 589158 Ponte, William, of Wyllyngdon 0
4614925 2235679 2235679 defendant Fenell Robert   589158 589158 Fenell, Robert, of Wyllyngdon 0
4770073 2286610 2286610 defendant Grenehill John husbandman 589158 589158 Grenehill, John, of Wyllyngdon, husbandman 4
4794714 2294485 2294485 defendant Grenehill John husbandman 589158 589158 Grenehill, John, of Wyllyngdon, husbandman 3
4835311 2307042 2307042 defendant Slade William husbandman 589158 589158 Slade, William, of Wyllyngdon, husbandman 0
4843051 2309360 2309360 defendant Pyers John husbandman 589158 589158 Pyers, John, of Wyllyngdon, husbandman 2
4934437 2337163 2337163 defendant Fermour William carpenter 589158 589158 Fermour, William, of Wyllyngdon, carpenter 2
4979208 2350740 2350740 defendant atte Forde Richard husbandman 589158 589158 atte Forde, Richard, of Wyllyngdon, husbandman 1
4979209 2350740 2350740 defendant Alman Simon husbandman 589158 589158 Alman, Simon, of Wyllyngdon, husbandman 2
4979210 2350740 2350740 defendant atte Drove Richard husbandman 589158 589158 atte Drove, Richard, of Wyllyngdon, husbandman 3
4979211 2350740 2350740 defendant Pers John husbandman 589158 589158 Pers, John, of Wyllyngdon, husbandman 4
5004758 2358296 2358296 defendant Gillam Thomas husbandman 589158 589158 Gillam, Thomas, of Wyllyngdon, husbandman 1
5004759 2358296 2358296 defendant Eytacre Thomas husbandman 589158 589158 Eytacre, Thomas, of Wyllyngdon, husbandman 2
5025253 2364279 2364279 defendant Sparowe William husbandman 589158 589158 Sparowe, William, of Wyllyngdon, husbandman 0
5025254 2364279 2364279 defendant Nicholas John husbandman 589158 589158 Nicholas, John, of Wyllyngdon, husbandman 1
5030798 2365876 2365876 defendant Tyman Richard weaver 589158 589158 Tyman, Richard, of Wyllyngdon, weaver 0
5125165 2393837 2393837 defendant Lecchelade John husbandman 589158 589158 Lecchelade, John, of Wyllyngdon, husbandman 0
5125166 2393837 2393837 defendant tutte Simon husbandman 589158 589158 tutte, Simon, of Wyllyngdon, husbandman 1
5143778 2399315 2399315 defendant Lecchelade John husbandman 589158 589158 Lecchelade, John, of Wyllyngdon, husbandman 0
5143779 2399315 2399315 defendant Tutte Simon husbandman 589158 589158 Tutte, Simon, of Wyllyngdon, husbandman 1
5450364 2489996 2489996 defendant Lechelad John   589158 589158 Lechelad, John, of Wyllyngdon 0
5462513 2493696 2493696 defendant Lethelad John husbandman 589158 589158 Lethelad, John, of Wyllyngdon, husbandman 0
5515504 2509693 2509693 defendant Perchyng John husbandman 589158 589158 Perchyng, John, of Wyllyngdon, husbandman 0
5515505 2509693 2509693 defendant Perchyng Richard husbandman 589158 589158 Perchyng, Richard, of Wyllyngdon, husbandman 1
5530480 2514051 2514051 defendant Norman Thomas laborer 589158 589158 Norman, Thomas, of Wyllyngdon, laborer 0
5530481 2514051 2514051 defendant Bregger Geoffrey laborer 589158 589158 Bregger, Geoffrey, of Wyllyngdon, laborer 1
5530482 2514051 2514051 defendant Baker Thomas laborer 589158 589158 Baker, Thomas, of Wyllyngdon, laborer 2
5530483 2514051 2514051 defendant William John laborer 589158 589158 William, John, of Wyllyngdon, laborer 3
5530484 2514051 2514051 defendant Bend John laborer 589158 589158 Bend, John, of Wyllyngdon, laborer 4
5530485 2514051 2514051 defendant Leme John laborer 589158 589158 Leme, John, of Wyllyngdon, laborer 5
5530486 2514051 2514051 defendant Sillunston John laborer 589158 589158 Sillunston, John, of Wyllyngdon, laborer 6
5530487 2514051 2514051 defendant Jope John laborer 589158 589158 Jope, John, of Wyllyngdon, laborer 7
5530488 2514051 2514051 defendant Hogge John laborer 589158 589158 Hogge, John, of Wyllyngdon, laborer 8
5601993 2535520 2535520 defendant Godere John laborer 589158 589158 Godere, John, of Wyllyngdon, laborer 2

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