names

12 rows where place_id = 761841

✎ 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
4482348 2195183 2195183 defendant atte Gate Thomas   761841 761841 atte Gate, Thomas, of Canewedon 0
4670684 2256513 2256513 defendant (illegible)   Essex, husbandman 761841 761841 -----, of Canewedon, Essex, husbandman 0
4722994 2272501 2272501 defendant Pykerell Walter husbandman 761841 761841 Pykerell, Walter, of Canewedon, husbandman 0
4725380 2273230 2273230 defendant Wille Richard husbandman 761841 761841 Wille, Richard, of Canewedon, husbandman 0
4811439 2299688 2299688 defendant atte Gate Robert couper 761841 761841 atte Gate, Robert, of Canewedon, couper 0
4867602 2316838 2316838 defendant Anderkyn John, senior husbandman 761841 761841 Anderkyn, John, senior, of Canewedon, husbandman 0
5027874 2365034 2365034 plaintiff Merchaunt John   761841 761841 Merchaunt, John, of Canewedon 0
5083458 2381550 2381550 defendant Hall John yeoman 761841 761841 Hall, John, of Canewedon, yeoman 0
5083460 2381551 2381551 defendant Hall John yeoman 761841 761841 Hall, John, of Canewedon, yeoman 0
5092042 2384050 2384050 defendant Coupere James fuller 761841 761841 Coupere, James, of Canewedon, fuller 0
5117610 2391585 2391585 defendant Thurrok John butcher 761841 761841 Thurrok, John, of Canewedon, butcher 1
5225848 2423234 2423234 defendant Wyncent John   761841 761841 Wyncent, John, of Canewedon, "herd" 1

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