names

8 rows where case_id = 2550131

✎ 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
5620039 2550131 2550131 plaintiff Reyner John     Reyner, John 0
5620040 2550131 2550131 defendant Melteby Adam     Melteby, Adam 0
5620041 2550131 2550131 defendant Broun John   774110 774110 Broun, John, of Trippelowe 1
5620042 2550131 2550131 defendant Myntemore Thomas   591175 591175 with Myntemore, Thomas, of Foxton, vicar, who vouches 2
5620043 2550131 2550131 defendant Lote Thomas   591175 591175 Lote, Thomas, of Foxton 3
5620044 2550131 2550131 defendant Umfray Thomas who vouches   with Umfray, Thomas, who vouches 4
5620045 2550131 2550131 defendant Myntemore Thomas   591175 591175 Myntemore, Thomas, of Foxton 5
5620046 2550131 2550131 defendant John Bocher who vouches     with John Bocher, who vouches 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);