names

17 rows where case_id = 2004879

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3943605 2004879 2004879 plaintiff Arundell Elizabeth widow   Arundell, Elizabeth, widow 0
3943606 2004879 2004879 defendant Stephyn Thomas yeoman 657263 657263 Stephyn, Thomas, of Pelynt, yeoman 0
3943607 2004879 2004879 defendant Cornysh John husbandman 657263 657263 Cornysh, John, of Pelynt, husbandman 1
3943608 2004879 2004879 defendant Hodge Robert husbandman 657263 657263 Hodge, Robert, of Pelynt, husbandman 2
3943609 2004879 2004879 defendant Ewstys John husbandman 657263 657263 Ewstys, John, of Pelynt, husbandman 3
3943610 2004879 2004879 defendant Dyer John husbandman 657263 657263 Dyer, John, of Pelynt, husbandman 4
3943611 2004879 2004879 defendant Lyle John husbandman 657263 657263 Lyle, John, of Pelynt, husbandman 5
3943612 2004879 2004879 defendant Boorne Robert husbandman 657263 657263 Boorne, Robert, of Pelynt, husbandman 6
3943613 2004879 2004879 defendant Cowche John husbandman 657263 657263 Cowche, John, of Pelynt, husbandman 7
3943614 2004879 2004879 defendant Boony Thomas husbandman 657263 657263 Boony, Thomas, of Pelynt, husbandman 8
3943615 2004879 2004879 defendant Lawry William husbandman 657263 657263 Lawry, William, of Pelynt, husbandman 9
3943616 2004879 2004879 defendant Waye Robert husbandman 657263 657263 Waye, Robert, of Pelynt, husbandman 10
3943617 2004879 2004879 defendant Thomas Nicholas husbandman 657263 657263 Thomas, Nicholas, of Pelynt, husbandman 11
3943618 2004879 2004879 defendant Jane Dina widow 657263 657263 Jane, Dina, of Pelynt, widow 12
3943619 2004879 2004879 defendant Growse Richard husbandman 657263 657263 Growse, Richard, of Pelynt, husbandman 13
3943620 2004879 2004879 defendant Lobbe John husbandman 657263 657263 Lobbe, John, of Pelynt, husbandman 14
3943621 2004879 2004879 defendant Jane Thomas husbandman 657263 657263 Jane, Thomas, of Pelynt, husbandman 15

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