names

13 rows where case_id = 2200675

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4500091 2200675 2200675 plaintiff Hothome John de knight   Hothome, John de, knight 0
4500092 2200675 2200675 defendant Alman John   611613 611613 Alman, John, of Lund 0
4500093 2200675 2200675 defendant Bard John     Bard, John 1
4500094 2200675 2200675 defendant Teryngton John, senior     Teryngton, John, senior 2
4500095 2200675 2200675 defendant Teryngton John, junior     Teryngton, John, junior 3
4500096 2200675 2200675 defendant Teryngton Richard     Teryngton, Richard 4
4500097 2200675 2200675 defendant Clyffe Mathew de     Clyffe, Mathew de 5
4500098 2200675 2200675 defendant Seton Robert     Seton, Robert 6
4500099 2200675 2200675 defendant Nyaunce Peter     Nyaunce, Peter 7
4500100 2200675 2200675 defendant Wodhous John de     Wodhous, John de 8
4500101 2200675 2200675 defendant Aleynson John     Aleynson, John 9
4500102 2200675 2200675 defendant Seton William de     Seton, William de 10
4500103 2200675 2200675 defendant Marschall John     Marschall, John 11

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