names

13 rows where place_id = 804768

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4661825 2249544 2249544 defendant Arundell John esq 804768 804768 Arundell, John, of Trerys, Cornw, esq 0
4661827 2249545 2249545 defendant Arundell John esq 804768 804768 Arundell, John, of Trerys, Cornw, esq 0
4661829 2249546 2249546 defendant Arundell John esq 804768 804768 Arundell, John, of Trerys, Cornw, esq 0
4724471 2272948 2272948 defendant Trerys Ralph (legal representative) 804768 804768 Trerys, Ralph, of Trerys, Cornw, executors of 0
4805288 2297855 2297855 defendant Arundell Trerys John   804768 804768 Arundell Trerys, John, of Trerys, Cornw, knight 0
4812241 2299945 2299945 defendant Arundell Trerys John   804768 804768 Arundell Trerys, John, of Trerys, Cornw, knight 0
4825205 2303924 2303924 defendant Arundell John   804768 804768 Arundell, John, of Trerys, Cornw, knight 0
4903488 2327699 2327699 defendant Arundell John   804768 804768 Arundell, John, of Trerys, Cornw, knight 0
4926919 2334848 2334848 defendant Arundell Richard gent 804768 804768 Arundell, Richard, of Trerys, Cornw, gent 2
4976520 2349937 2349937 defendant Arundell John   804768 804768 Arundell, John, of Trerys, Cornw, knight 0
4976527 2349939 2349939 defendant Arundell John   804768 804768 Arundell, John, of Trerys, Cornw, knight 0
4979285 2350763 2350763 defendant Arundell John   804768 804768 Arundell, John, of Trerys, Cornw, knight 1
5074807 2378969 2378969 defendant Arundell John (legal representative) 804768 804768 Arundell, John, of Trerys, Cornw, knight, executrix of 0

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