names

5 rows where case_id = 2398203

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5140097 2398203 2398203 plaintiff Stawnton or Stanton William   851991 851991 Stawnton or Stanton, William, of Nutley or Nottele or Crendon Park, Bucks, abbot of the Monstery of the BM 0
5140098 2398203 2398203 defendant Colyns John, senior esq 831910 831910 Colyns, John, senior, of Princes Rysburgh, Bucks, esq 0
5140099 2398203 2398203 defendant Bryan Richard yeoman 802912 802912 Bryan, Richard, of Bledelowe, Bucks, yeoman 1
5140100 2398203 2398203 defendant Kempston Thomas (legal representative) 586079 586079 Kempston, Thomas, of Bedford, executrix of 2
5140101 2398203 2398203 defendant Kempston Alice   585869 585869 Kempston, Alice, of London, widow, formerly wife of Testator 3

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