names

19 rows where place_id = 696077

✎ 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
4112680 2064795 2064795 defendant Hurst Robert yeoman 696077 696077 Hurst, Robert, of Assheton, Lancs, yeoman 0
4660019 2248981 2248981 defendant de Glassen John husbandman 696077 696077 de Glassen, John, of Assheton, Lancs, husbandman 0
4690071 2262445 2262445 defendant Assheton John   696077 696077 Assheton, John, of Assheton, Lancs, knight 0
4766789 2285607 2285607 defendant Vernon Christopher yeoman 696077 696077 Vernon, Christopher, of Assheton, Lancs, yeoman 1
4778508 2289256 2289256 defendant Claydon Thomas gent 696077 696077 Claydon, Thomas, of Assheton, Lancs, gent 0
4802668 2297022 2297022 defendant Assheton Ralph esq 696077 696077 Assheton, Ralph, of Assheton, Lancs, esq 0
4803592 2297310 2297310 defendant Chadirton Ellis gent 696077 696077 Chadirton, Ellis, of Assheton, Lancs, gent 0
4824918 2303831 2303831 defendant Laurens Robert esq 696077 696077 Laurens, Robert, of Assheton, Lancs, esq 2
5136843 2397298 2397298 defendant Laurence Robert (legal representative) 696077 696077 Laurence, Robert, of Assheton, Lancs, esq, executrix of 0
5218435 2421122 2421122 defendant Laurence James esq 696077 696077 Laurence, James, of Assheton, Lancs, esq 0
5322637 2451850 2451850 defendant Molyneux James gent 696077 696077 Molyneux, James, of Assheton, Lancs, gent 1
5322698 2451864 2451864 defendant Molyneux James gent 696077 696077 Molyneux, James, of Assheton, Lancs, gent 1
5322701 2451865 2451865 defendant Molyneux James gent 696077 696077 Molyneux, James, of Assheton, Lancs, gent 1
5327616 2453336 2453336 defendant Asheton John   696077 696077 Asheton, John, of Assheton, Lancs, knight 0
5383098 2470237 2470237 defendant Assheton John   696077 696077 Assheton, John, of Assheton, Lancs, knight 1
5409855 2477914 2477914 defendant Assheton Thomas esq 696077 696077 Assheton, Thomas, of Assheton, Lancs, esq 1
5421451 2481351 2481351 defendant Assheton John   696077 696077 Assheton, John, of Assheton, Lancs, knight 1
5423504 2481991 2481991 defendant Assheton Thomas esq 696077 696077 Assheton, Thomas, of Assheton, Lancs, esq 1
5629696 2553279 2553279 defendant de Glassen John husbandman 696077 696077 de Glassen, John, of Assheton, Lancs, husbandman 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);