names

6 rows where case_id = 2359458

✎ 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
5008777 2359458 2359458 plaintiff Thetford John prior of the canons of the church of St Sepulchre, in   Thetford, John, prior of the canons of the church of St Sepulchre, in 0
5008778 2359458 2359458 defendant Onty John husbandman 592862 592862 Onty, John, of Holbeche, Lincs, husbandman 0
5008779 2359458 2359458 defendant Callowe Henry gent 587309 587309 Callowe, Henry, of Holbeche, gent 1
5008780 2359458 2359458 defendant Blytte William yeoman 587309 587309 Blytte, William, of Holbeche, yeoman 2
5008781 2359458 2359458 defendant Bradhowe John gent 587309 587309 Bradhowe, John, of Holbeche, gent 3
5008782 2359458 2359458 defendant Passhlewe John yeoman 829627 829627 Passhlewe, John, of Gayesle, Suff, yeoman 4

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