names

6 rows where case_id = 1920258

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3681356 1920258 1920258 plaintiff Skevyngton William knight, master of Guild of St Barbara, St Katherine by the Tower   Skevyngton, William, knight, master of Guild of St Barbara, St Katherine by the Tower 0
3681357 1920258 1920258 plaintiff Harte Thomas     Harte, Thomas 1
3681358 1920258 1920258 plaintiff Huxley William     Huxley, William 2
3681359 1920258 1920258 plaintiff Horne Geoffrey     Horne, Geoffrey 3
3681360 1920258 1920258 plaintiff Varbayte William guild wardens   Varbayte, William, guild wardens 4
3681361 1920258 1920258 defendant Frenche Hugh yeoman 609983 609983 Frenche, Hugh, of St Mary Alter, Devon, yeoman 0

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