names

5 rows where case_id = 2030959

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4017492 2030959 2030959 plaintiff Thorpe Francis (legal representative) 670405 670405 Thorpe, Francis, of Burton Stather, Lincs, merchant or yeoman or gent, administrator of 0
4017493 2030959 2030959 plaintiff Thorpe Robert     Thorpe, Robert 1
4017494 2030959 2030959 defendant Stephenson William yeoman 675199 675199 Stephenson, William, of Redenes, yeoman 0
4017495 2030959 2030959 defendant Stephenson Robert yeoman 602199 602199 Stephenson, Robert, of Whitgift, yeoman 1
4017496 2030959 2030959 defendant Ellis William senior, vicar of Horstowe, Lincs   Ellis, William, senior, vicar of Horstowe, Lincs 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);