names

10 rows where case_id = 2422143

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5222015 2422143 2422143 plaintiff Lyndley Richard esq   Lyndley, Richard, esq 0
5222016 2422143 2422143 defendant Henryson Richard husbandman 860957 860957 Henryson, Richard, of Throsdonby in Pykerynglith, husbandman 0
5222017 2422143 2422143 defendant Sustyrson William husbandman 860958 860958 Sustyrson, William, of Throsdonby, husbandman 1
5222018 2422143 2422143 defendant Gamyll Thomas husbandman 860958 860958 Gamyll, Thomas, of Throsdonby, husbandman 2
5222019 2422143 2422143 defendant Perrey John husbandman 860958 860958 Perrey, John, of Throsdonby, husbandman 3
5222020 2422143 2422143 defendant Colyn William husbandman 860958 860958 Colyn, William, of Throsdonby, husbandman 4
5222021 2422143 2422143 defendant Emondson Thomas yeoman 589401 589401 Emondson, Thomas, of Scardeburgh, yeoman 5
5222022 2422143 2422143 defendant Degeon Walter yeoman 589401 589401 Degeon, Walter, of Scardeburgh, yeoman 6
5222023 2422143 2422143 defendant Forster John yeoman 589401 589401 Forster, John, of Scardeburgh, yeoman 7
5222024 2422143 2422143 defendant Coweper John husbandman 795102 795102 Coweper, John, of Aton in Pykerynglith, husbandman 8

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