names

14 rows where place_id = 605988

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename

id ▼ case_id role surname forename occupation place_id raw_segment seq
3663601 1914546 1914546 defendant Irby John clerk 605988 605988 Irby, John, of Aspatria, clerk 0
3664156 1914741 1914741 plaintiff Batie John   605988 605988 Batie, John, of Aspatria, vicar 3
5461551 2493399 2493399 defendant Hatter Robert   605988 605988 Hatter, Robert, of Aspatria 21
5461552 2493399 2493399 defendant Elisson John   605988 605988 Elisson, John, of Aspatria 22
5461553 2493399 2493399 defendant Belle Wiliam   605988 605988 Belle, Wiliam, of Aspatria 23
5461554 2493399 2493399 defendant Yonghusbond William   605988 605988 Yonghusbond, William, of Aspatria 24
5461555 2493399 2493399 defendant Morthyng William   605988 605988 Morthyng, William, of Aspatria 25
5461556 2493399 2493399 defendant Camerton William   605988 605988 Camerton, William, of Aspatria 26
5461557 2493399 2493399 defendant Martyndale Robert gent 605988 605988 Martyndale, Robert, of Aspatria, gent 27
5461558 2493399 2493399 defendant Festayn William   605988 605988 Festayn, William, of Aspatria 28
5461559 2493399 2493399 defendant Deyson Thomas   605988 605988 Deyson, Thomas, of Aspatria 29
5461560 2493399 2493399 defendant Kyrssey John   605988 605988 Kyrssey, John, of Aspatria 30
5461564 2493399 2493399 defendant Sympyll Thomas   605988 605988 Sympyll, Thomas, of Aspatria 34
5461566 2493399 2493399 defendant Martyndale John   605988 605988 Martyndale, John, of Aspatria 36

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