names

5 rows where case_id = 2359173

✎ 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
5007787 2359173 2359173 plaintiff Steven Henry     Steven, Henry 0
5007788 2359173 2359173 defendant Exeter John prior of the church of St John Baptist, within the Eastgate of the city, of   Exeter, John, prior of the church of St John Baptist, within the Eastgate of the city, of 0
5007789 2359173 2359173 defendant Undesdon Thomas brother of John Colyford 598601 598601 Undesdon, Thomas, of Columpton, gent, brother of John Colyford 1
5007790 2359173 2359173 defendant Lemyngton John husbandman 635463 635463 Lemyngton, John, of Holcombe Rogus, husbandman 2
5007791 2359173 2359173 defendant Tomas Robert husbandman 635463 635463 Tomas, Robert, of Holcombe Rogus, 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);