names

28 rows where place_id = 756289

✎ 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
4436356 2176106 2176106 defendant Plech John   756289 756289 Plech, John, of Enefeld 2
4552962 2216872 2216872 plaintiff Bailly John   756289 756289 Bailly, John, of Enefeld 1
4552963 2216872 2216872 defendant Ace Thomas   756289 756289 Ace, Thomas, of Enefeld 0
4563153 2220043 2220043 defendant Grymbesby John   756289 756289 Grymbesby, John, of Enefeld 0
4574043 2223404 2223404 defendant Philip John   756289 756289 Philip, John, of Enefeld 3
4627103 2239429 2239429 plaintiff Reshanger John   756289 756289 Reshanger, John, of Enefeld 0
4632753 2241129 2241129 defendant Mordemore Richard   756289 756289 Mordemore, Richard, of Enefeld 0
4632754 2241129 2241129 defendant Dame John   756289 756289 Dame, John, of Enefeld 1
4646087 2244929 2244929 defendant Felawe Thomas   756289 756289 Felawe, Thomas, of Enefeld 2
4779561 2289591 2289591 defendant Stacy Peter butcher 756289 756289 Stacy, Peter, of Enefeld, butcher 1
4789122 2292650 2292650 defendant Dane John butcher 756289 756289 Dane, John, of Enefeld, butcher 0
4789124 2292651 2292651 defendant Dane John butcher 756289 756289 Dane, John, of Enefeld, butcher 0
4792569 2293767 2293767 defendant Frank Thomas   756289 756289 Frank, Thomas, of Enefeld 0
4802773 2297053 2297053 defendant Hoghton William   756289 756289 Hoghton, William, of Enefeld, idredel laborer or holy water stoup laborer 0
4822164 2303010 2303010 defendant Hugthon William laborer 756289 756289 Hugthon, William, of Enefeld, laborer 0
4835625 2307134 2307134 defendant Crompeloke John husbandman 756289 756289 Crompeloke, John, of Enefeld, husbandman 1
4878275 2320157 2320157 defendant Bedford John husbandman 756289 756289 Bedford, John, of Enefeld, husbandman 3
4919576 2332624 2332624 plaintiff Hogge Thomas   756289 756289 Hogge, Thomas, of Enefeld 0
4934084 2337044 2337044 defendant Hoo Thomas husbandman 756289 756289 Hoo, Thomas, of Enefeld, husbandman 0
4934085 2337044 2337044 defendant Hoo Richard yeoman 756289 756289 Hoo, Richard, of Enefeld, yeoman 1
4945473 2340562 2340562 defendant Typtoft John   756289 756289 Typtoft, John, of Enefeld, knight 0
4993097 2354818 2354818 defendant Hogyn Edmund maltman 756289 756289 Hogyn, Edmund, of Enefeld, maltman 3
5051325 2372008 2372008 defendant Gerveys Thomas maltman 756289 756289 Gerveys, Thomas, of Enefeld, maltman 0
5074051 2378729 2378729 defendant Gerveys Thomas maltman 756289 756289 Gerveys, Thomas, of Enefeld, maltman 0
5092453 2384170 2384170 defendant Bristowe John, junior yeoman 756289 756289 Bristowe, John, junior, of Enefeld, yeoman 0
5292340 2442760 2442760 defendant Trotte John maltman 756289 756289 Trotte, John, of Enefeld, maltman 0
5394212 2473406 2473406 defendant (illegible) William brewer 756289 756289 _, William, of Enefeld, brewer 0
5407390 2477178 2477178 defendant Hamond William brewer 756289 756289 Hamond, William, of Enefeld, brewer 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);