names

8 rows where case_id = 2551487

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5624102 2551487 2551487 plaintiff Lambe Thomas   754560 754560 Lambe, Thomas, of Smerdale 0
5624103 2551487 2551487 defendant Taran William yeoman 758649 758649 Taran, William, of Kirkeby Stephan, yeoman 0
5624104 2551487 2551487 defendant Bradbelt John laborer 758649 758649 Bradbelt, John, of Kirkeby Stephan, laborer 1
5624105 2551487 2551487 defendant Paton William husbandman 616409 616409 Paton, William, of Ormeshede, husbandman 2
5624106 2551487 2551487 defendant de Wilton John miller 754559 754559 de Wilton, John, of Wateby, miller 3
5624107 2551487 2551487 defendant Warcopman Henry husbandman 754560 754560 Warcopman, Henry, of Smerdale, husbandman 4
5624108 2551487 2551487 defendant Sponer Thomas husbandman 764530 764530 Sponer, Thomas, of Nateby, husbandman 5
5624109 2551487 2551487 defendant del Yate Thomas husbandman 616409 616409 del Yate, Thomas, of Ormeshede, husbandman 6

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