names

15 rows where case_id = 2343820

✎ 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
4956204 2343820 2343820 plaintiff Tudenham Thomas knight   Tudenham, Thomas, knight 0
4956205 2343820 2343820 plaintiff Hevenyngham John knight   Hevenyngham, John, knight 1
4956206 2343820 2343820 plaintiff Chaumberleyn Roger knight   Chaumberleyn, Roger, knight 2
4956207 2343820 2343820 plaintiff Drury Henry esq   Drury, Henry, esq 3
4956208 2343820 2343820 plaintiff Rookwode William esq 599281 599281 Rookwode, William, of Thelnetham, esq 4
4956209 2343820 2343820 plaintiff Wodirton Richard esq   Wodirton, Richard, esq 5
4956210 2343820 2343820 plaintiff Astle John esq   Astle, John, esq 6
4956211 2343820 2343820 plaintiff Geddyng Thomas esq   Geddyng, Thomas, esq 7
4956212 2343820 2343820 plaintiff Heigham John clerk   Heigham, John, clerk 8
4956213 2343820 2343820 plaintiff Westhorp Thomas clerk   Westhorp, Thomas, clerk 9
4956214 2343820 2343820 plaintiff Heydon John     Heydon, John 10
4956215 2343820 2343820 plaintiff Heigham Thomas     Heigham, Thomas 11
4956216 2343820 2343820 defendant Skarlet William gent 642031 642031 Skarlet, William, of Iklyngham, Suff, gent 0
4956217 2343820 2343820 defendant Bakhoot Nicholas clerk 642031 642031 Bakhoot, Nicholas, of Iklyngham, Suff, clerk 1
4956218 2343820 2343820 defendant Chercheman Ralph ostler 602494 602494 Chercheman, Ralph, of Iklyngton, ostler 2

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