names

13 rows where case_id = 1913185

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3659346 1913185 1913185 plaintiff Godye William     Godye, William 0
3659347 1913185 1913185 defendant Cadley John husbandman 604809 604809 Cadley, John, of Pollesant, husbandman 0
3659348 1913185 1913185 defendant Lowys John husbandman 604810 604810 Lowys, John, of pollefant, husbandman 1
3659349 1913185 1913185 defendant Wydecombe John husbandman 604811 604811 Wydecombe, John, of Lawamek, husbandman 2
3659350 1913185 1913185 defendant Pymton John husbandman 604812 604812 Pymton, John, of Lawanek, husbandman 3
3659351 1913185 1913185 defendant Stevyn John husbandman 604813 604813 Stevyn, John, of Trethowe by Tregodek, husbandman 4
3659352 1913185 1913185 defendant Ugger William husbandman 604814 604814 Ugger, William, of Trevynnowe, husbandman 5
3659353 1913185 1913185 defendant Colyn Richard laborer 604815 604815 Colyn, Richard, of Trethewye by Tregodek, laborer 6
3659354 1913185 1913185 defendant Bennowe John laborer 590233 590233 Bennowe, John, of South Pederwyn, laborer 7
3659355 1913185 1913185 defendant tyllman William husbandman 604816 604816 tyllman, William, of Trelynnowe, husbandman 8
3659356 1913185 1913185 defendant Goodman John husbandman 604817 604817 Goodman, John, of Olyvagge,, husbandman 9
3659357 1913185 1913185 defendant Drewe John laborer 604818 604818 Drewe, John, of Trewynna in Lawacok, laborer 10
3659358 1913185 1913185 defendant Rooke John laborer 604819 604819 Rooke, John, of Nederton in Lawanek, laborer 11

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