names

14 rows where case_id = 2421566

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5220013 2421566 2421566 plaintiff Horbury Christopher     Horbury, Christopher 0
5220014 2421566 2421566 defendant Barnby alias Mar John husbandman 759748 759748 Barnby alias Mar, John, of Mar, husbandman 0
5220015 2421566 2421566 defendant Bergh Richard husbandman 860734 860734 Bergh, Richard, of Fedyrston, husbandman 1
5220016 2421566 2421566 defendant Wright Edmund husbandman 860735 860735 Wright, Edmund, of Whitwede, husbandman 2
5220017 2421566 2421566 defendant Baker Edmund husbandman 604178 604178 Baker, Edmund, of Warmefeld, husbandman 3
5220018 2421566 2421566 defendant Robard Peter   586093 586093 Robard, Peter, of Selby, wright 4
5220019 2421566 2421566 defendant Hill Robert sawyer 586093 586093 Hill, Robert, of Selby, sawyer 5
5220020 2421566 2421566 defendant Halyday William husbandman 587499 587499 Halyday, William, of Hardwyk, husbandman 6
5220021 2421566 2421566 defendant Bentley John yeoman 860736 860736 Bentley, John, of Hyppron Mere, yeoman 7
5220022 2421566 2421566 defendant Randon William yeoman 860737 860737 Randon, William, of Lunde, Hemyngburgh, yeoman 8
5220023 2421566 2421566 defendant Chapman Thomas (legal representative) 586887 586887 Chapman, Thomas, of Wakefeld, walker, executor of 9
5220024 2421566 2421566 defendant Chapman Nicholas vicar of Corngham, Lincs   Chapman, Nicholas, vicar of Corngham, Lincs 10
5220025 2421566 2421566 defendant Bryan Richard (legal representative)   Bryan, Richard, executrix of 11
5220026 2421566 2421566 defendant Bryan Alice widow 587379 587379 Bryan, Alice, of Doncastre, widow 12

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