names

14 rows where case_id = 2211233

✎ 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
4535017 2211233 2211233 plaintiff Shepeye John   767068 767068 Shepeye, John, of Lincoln, dean of the cathedral church of the BM 0
4535018 2211233 2211233 defendant (not given) Henry bishop of Lincoln   Lincoln, Henry, bishop of 0
4535019 2211233 2211233 defendant Carleton John clerk   Carleton, John, clerk 1
4535020 2211233 2211233 defendant Neuport John clerk   Neuport, John, clerk 2
4535021 2211233 2211233 defendant Hunteman John clerk   Hunteman, John, clerk 3
4535022 2211233 2211233 defendant Dalton Peter clerk   Dalton, Peter, clerk 4
4535023 2211233 2211233 defendant Aston Thomas clerk   Aston, Thomas, clerk 5
4535024 2211233 2211233 defendant Wynnewyk Richard clerk   Wynnewyk, Richard, clerk 6
4535025 2211233 2211233 defendant Chesterfeld Richard clerk   Chesterfeld, Richard, clerk 7
4535026 2211233 2211233 defendant Welbourne William clerk   Welbourne, William, clerk 8
4535027 2211233 2211233 defendant Waynflete John clerk   Waynflete, John, clerk 9
4535028 2211233 2211233 defendant Southam John clerk   Southam, John, clerk 10
4535029 2211233 2211233 defendant Kele John clerk   Kele, John, clerk 11
4535030 2211233 2211233 defendant Humberston Alan clerk   Humberston, Alan, clerk 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);