names

4 rows where place_id = 837312

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename

id ▼ case_id role surname forename occupation place_id raw_segment seq
4953421 2342989 2342989 defendant Shores Henry   837312 837312 Shores, Henry, of Brunley, Lancs, "nowte dryver" 0
5031222 2366003 2366003 defendant Tounley Miles gent 837312 837312 Tounley, Miles, of Brunley, Lancs, gent 26
5076343 2379427 2379427 defendant Tayllour John walker 837312 837312 Tayllour, John, of Brunley, Lancs, walker 2
5144027 2399399 2399399 defendant Taillour John husbandman 837312 837312 Taillour, John, of Brunley, Lancs, 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);