names

34 rows where place_id = 594299

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3615493 1872487 1872487 defendant Miller Stephen carpenter 594299 594299 Miller, Stephen, of Stapulherst, carpenter 5
3639922 1907301 1907301 defendant Grene John husbandman 594299 594299 Grene, John, of Stapulherst, husbandman 0
3704414 1927677 1927677 defendant Colyer Stephen husbandman 594299 594299 Colyer, Stephen, of Stapulherst, husbandman 3
3820033 1964145 1964145 defendant Pavyer Walter summoner 594299 594299 Pavyer, Walter, of Stapulherst, summoner 2
4546787 2214921 2214921 defendant Lillesden William   594299 594299 Lillesden, William, of Stapulherst 2
4546791 2214922 2214922 defendant Lillesden William   594299 594299 Lillesden, William, of Stapulherst 2
4724516 2272966 2272966 defendant Chirche John gent 594299 594299 Chirche, John, of Stapulherst, gent 0
4726655 2273609 2273609 defendant Chirche John gent 594299 594299 Chirche, John, of Stapulherst, gent 0
4861820 2315073 2315073 plaintiff Hernden Stephen   594299 594299 Hernden, Stephen, of Stapulherst 2
4861825 2315074 2315074 plaintiff Herynden Stephen   594299 594299 Herynden, Stephen, of Stapulherst 2
4964114 2346176 2346176 defendant Luk John butcher 594299 594299 Luk, John, of Stapulherst, butcher 0
4964115 2346176 2346176 defendant Badcok John husbandman 594299 594299 Badcok, John, of Stapulherst, husbandman 1
5233554 2425406 2425406 defendant atte Forde John laborer 594299 594299 atte Forde, John, of Stapulherst, laborer 4
5264311 2434593 2434593 defendant Sharpe Richard yeoman 594299 594299 Sharpe, Richard, of Stapulherst, yeoman 0
5379451 2469164 2469164 defendant Goldham John husbandman 594299 594299 Goldham, John, of Stapulherst, husbandman 0
5379454 2469165 2469165 defendant Goldham John husbandman 594299 594299 Goldham, John, of Stapulherst, husbandman 0
5399273 2474865 2474865 defendant Atcok William   594299 594299 Atcok, William, of Stapulherst, cloth maker 0
5422137 2481565 2481565 defendant Webbe William husbandman 594299 594299 Webbe, William, of Stapulherst, husbandman 2
5484570 2500305 2500305 defendant Goldham John husbandman 594299 594299 Goldham, John, of Stapulherst, husbandman 0
5519057 2510806 2510806 defendant Lambard Thomas weaver 594299 594299 Lambard, Thomas, of Stapulherst, weaver 1
5525813 2512664 2512664 plaintiff Herenden Richard gent 594299 594299 Herenden, Richard, of Stapulherst, gent 0
5526803 2512951 2512951 defendant Elverygge John weaver 594299 594299 Elverygge, John, of Stapulherst, weaver 1
5526804 2512951 2512951 defendant Goldham Robert husbandman 594299 594299 Goldham, Robert, of Stapulherst, husbandman 2
5526807 2512952 2512952 defendant Elverygge John weaver 594299 594299 Elverygge, John, of Stapulherst, weaver 1
5526808 2512952 2512952 defendant Goldham Robert husbandman 594299 594299 Goldham, Robert, of Stapulherst, husbandman 2
5543517 2518085 2518085 defendant Goldham Robert laborer 594299 594299 Goldham, Robert, of Stapulherst, laborer 3
5547773 2519364 2519364 defendant Atcok William clothier 594299 594299 Atcok, William, of Stapulherst, clothier 1
5577088 2527882 2527882 defendant Cotyng John laborer 594299 594299 Cotyng, John, of Stapulherst, laborer 1
5577090 2527882 2527882 defendant Harold John (legal representative) 594299 594299 Harold, John, of Stapulherst, executors of 3
5596406 2533787 2533787 defendant Badcok John husbandman 594299 594299 Badcok, John, of Stapulherst, husbandman 3
5596409 2533788 2533788 defendant Robert Thomas butcher 594299 594299 Robert, Thomas, of Stapulherst, butcher 1
5602207 2535588 2535588 defendant Goldham William husbandman 594299 594299 Goldham, William, of Stapulherst, husbandman 3
5602465 2535664 2535664 defendant Wastell Roger yeoman 594299 594299 Wastell, Roger, of Stapulherst, yeoman 3
5616354 2548908 2548908 plaintiff Herynden John   594299 594299 Herynden, John, of Stapulherst 0

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