names

49 rows where place_id = 801185

✎ 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
4437672 2176540 2176540 plaintiff Wyndon John de   801185 801185 Wyndon, John de, of East Grenstede, parson 0
4437697 2176547 2176547 plaintiff Wytton John   801185 801185 Wytton, John, of East Grenstede 0
4494668 2199025 2199025 defendant Coupere Thomas   801185 801185 Coupere, Thomas, of East Grenstede 0
4507312 2202750 2202750 defendant Brookes John   801185 801185 Brookes, John, of East Grenstede 0
4513483 2204640 2204640 defendant Couper Thomas   801185 801185 Couper, Thomas, of East Grenstede 0
4763346 2284524 2284524 defendant Joop Nicholas gent 801185 801185 Joop, Nicholas, of East Grenstede, gent 0
4778414 2289228 2289228 defendant Dene Thomas clerk 801185 801185 Dene, Thomas, of Est Grenstede, clerk 0
4785511 2291490 2291490 defendant Dyn John butcher 801185 801185 Dyn, John, of Est Grenstede, butcher 1
4785635 2291535 2291535 defendant Malle Thomas, junior   801185 801185 Malle, Thomas, junior, of Est Grenstede, groom 0
4788992 2292611 2292611 defendant Loder William husbandman 801185 801185 Loder, William, of Est Grenstede, husbandman 0
4788993 2292611 2292611 defendant Loder John laborer 801185 801185 Loder, John, of Est Grenstede, laborer 1
4801458 2296637 2296637 defendant Model John carpenter 801185 801185 Model, John, of Est Grenstede, carpenter 0
4805508 2297935 2297935 defendant Shawe John husbandman 801185 801185 Shawe, John, of East Grenstede, husbandman 0
4805512 2297935 2297935 defendant Couper Thomas husbandman 801185 801185 Couper, Thomas, of East Grenstede, husbandman 4
4805515 2297936 2297936 defendant Couper Thomas husbandman 801185 801185 Couper, Thomas, of East Grenstede, husbandman 1
4839585 2308300 2308300 defendant Icop Nicholas gent 801185 801185 Icop, Nicholas, of East Grenstede, gent 0
4865703 2316238 2316238 defendant Joop Nicholas gent 801185 801185 Joop, Nicholas, of Est Grenstede, gent 0
4866787 2316575 2316575 defendant Wogher John husbandman 801185 801185 Wogher, John, of Est Grenstede, husbandman 0
4869840 2317538 2317538 defendant Hunte Robert butcher 801185 801185 Hunte, Robert, of Est Grenstede, butcher 1
4869914 2317563 2317563 defendant Joop Nicholas gent 801185 801185 Joop, Nicholas, of Est Grenstede, gent 0
4873423 2318646 2318646 defendant Man Thomas laborer 801185 801185 Man, Thomas, of Est Grenstede, laborer 0
4901586 2327097 2327097 defendant Coper Richard yeoman 801185 801185 Coper, Richard, of Est Grenstede, yeoman 0
4952672 2342755 2342755 defendant Nicoll Walter husbandman 801185 801185 Nicoll, Walter, of Est Grenstede, husbandman 0
4961767 2345482 2345482 defendant Broket Richard husbandman 801185 801185 Broket, Richard, of Est Grenstede, husbandman 0
4976953 2350062 2350062 defendant Waleys Walter husbandman 801185 801185 Waleys, Walter, of Est Grenstede, husbandman 0
5148584 2400711 2400711 defendant Nycoll Thomas baker 801185 801185 Nycoll, Thomas, of East Grenstede, baker 0
5167843 2406306 2406306 defendant Nycoll Thomas baker 801185 801185 Nycoll, Thomas, of East Grenstede, baker 0
5183449 2410899 2410899 defendant Nycoll Thomas baker 801185 801185 Nycoll, Thomas, of East Grenstede, baker 0
5240245 2427353 2427353 defendant Michell John tanner 801185 801185 Michell, John, of Est Grenstede, tanner 0
5241452 2427699 2427699 defendant Wotton Peter yeoman 801185 801185 Wotton, Peter, of Est Grenstede, yeoman 0
5241456 2427700 2427700 defendant Wotton Peter yeoman 801185 801185 Wotton, Peter, of Est Grenstede, yeoman 0
5255130 2431717 2431717 defendant Hasylden Andrew yeoman 801185 801185 Hasylden, Andrew, of Est Grenstede, yeoman 1
5255131 2431717 2431717 defendant Boteler John weaver 801185 801185 Boteler, John, of Est Grenstede, weaver 2
5269678 2436243 2436243 defendant Hasylden Andrew yeoman 801185 801185 Hasylden, Andrew, of East Grenstede, yeoman 1
5317604 2450353 2450353 defendant Marchall John tanner 801185 801185 Marchall, John, of Est Grenstede, tanner 0
5324860 2452510 2452510 defendant Knostob Roger yeoman 801185 801185 Knostob, Roger, of Est Grenstede, yeoman 0
5324862 2452511 2452511 defendant Knostok Roger yeoman 801185 801185 Knostok, Roger, of Est Grenstede, yeoman 0
5338583 2456638 2456638 defendant Boteler John husbandman 801185 801185 Boteler, John, of Est Grenstede, husbandman 0
5338584 2456638 2456638 defendant Knostubbe Roger husbandman 801185 801185 Knostubbe, Roger, of Est Grenstede, husbandman 1
5339125 2456814 2456814 defendant Nycoll Thomas husbandman 801185 801185 Nycoll, Thomas, of Est Grenstede, husbandman 0
5342039 2457701 2457701 defendant Knestob Roger yeoman 801185 801185 Knestob, Roger, of Est Grenstede, yeoman 0
5355168 2461687 2461687 defendant Thomas William (legal representative) 801185 801185 Thomas, William, of Est Grenstede, administrator of 2
5460617 2493121 2493121 defendant Peryman Thomas yeoman 801185 801185 Peryman, Thomas, of East Grenstede, yeoman 0
5485094 2500462 2500462 defendant Langrygge Robert mercer 801185 801185 Langrygge, Robert, of Est Grenstede, mercer 0
5511911 2508583 2508583 defendant Gunter Edmund gent 801185 801185 Gunter, Edmund, of Est Grenstede, gent 0
5511912 2508583 2508583 defendant Langrych Thomas yeoman 801185 801185 Langrych, Thomas, of Est Grenstede, yeoman 1
5511913 2508583 2508583 defendant Leverich Robert yeoman 801185 801185 Leverich, Robert, of Est Grenstede, yeoman 2
5511914 2508583 2508583 defendant Wower Richard husbandman 801185 801185 Wower, Richard, of Est Grenstede, husbandman 3
5543770 2518157 2518157 defendant Mill William husbandman 801185 801185 Mill, William, of Est Grenstede, husbandman 3

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