names

10 rows where case_id = 2242807

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4638521 2242807 2242807 plaintiff Castell John   585936 585936 Castell, John, of Norwich 0
4638522 2242807 2242807 defendant Boston Thomas   590408 590408 Boston,Thomas, of Shipden 0
4638523 2242807 2242807 defendant Love Richard   776857 776857 Love, Richard, of Wodebrig 1
4638524 2242807 2242807 defendant Gateman John   652592 652592 Gateman, John, of Skeyton 2
4638525 2242807 2242807 defendant Gateman Beatrice     Beatrice, his wife 3
4638526 2242807 2242807 defendant Quylter Richard     Quylter, Richard 4
4638527 2242807 2242807 defendant Dalton John pedlar   Dalton, John, pedlar 5
4638528 2242807 2242807 defendant Kede Richard (legal representative) 772321 772321 Kede, Richard, of Fornsete, administratrix of 6
4638529 2242807 2242807 defendant Kede Katherine   772321 772321 Kede, Katherine, of Fornsete, formerly wife of Richard Kede 7
4638530 2242807 2242807 defendant Sloleye Bartholomew   585933 585933 Sloleye, Bartholomew, of Great Yarmouth 8

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