names

15 rows where case_id = 2471688

✎ 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
5388238 2471688 2471688 plaintiff Gower Thomas pensioner of the Hospice of Lions   Gower, Thomas, pensioner of the Hospice of Lions 0
5388239 2471688 2471688 defendant Taverner John gent 881014 881014 Taverner, John, of St Clement Danes outside the New Temple Bars, Middx, gent 0
5388240 2471688 2471688 defendant Gybbes John gent 585929 585929 Gybbes, John, of St Clement Danes, gent 1
5388241 2471688 2471688 defendant Arnold John gent 585929 585929 Arnold John, of St Clement Danes, gent 2
5388242 2471688 2471688 defendant Straccheleigh William gent 585929 585929 Straccheleigh, William, of St Clement Danes, gent 3
5388243 2471688 2471688 defendant Willesford William gent   Willesford, William, gent 4
5388244 2471688 2471688 defendant Smyth John gent   Smyth, John, gent 5
5388245 2471688 2471688 defendant Mountendy John gent   Mountendy, John, gent 6
5388246 2471688 2471688 defendant Floyer William gent   Floyer, William, gent 7
5388247 2471688 2471688 defendant Trevenour John gent   Trevenour, John, gent 8
5388248 2471688 2471688 defendant Owen Richard gent   Owen, Richard, gent 9
5388249 2471688 2471688 defendant Drury John gent   Drury, John, gent 10
5388250 2471688 2471688 defendant Payne John gent   Payne, John, gent 11
5388251 2471688 2471688 defendant Walcote William gent   Walcote, William, gent 12
5388252 2471688 2471688 defendant Daynes Edward gent   Daynes, Edward, gent 13

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