names

5 rows where case_id = 2074679

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4140031 2074679 2074679 plaintiff Walmysley Thomas     Walmysley, Thomas 0
4140032 2074679 2074679 defendant Thorneton William yeoman 701792 701792 Thorneton, William, of Ellyswyck, Lancs, yeoman 0
4140033 2074679 2074679 defendant Gaunt Roger yeoman 701793 701793 Gaunt, Roger, of Lyscowe, Rawclyff, Lancs, yeoman 1
4140034 2074679 2074679 defendant Thomson John yeoman 701794 701794 Thomson, John, of Crosmer, Lancs, yeoman 2
4140035 2074679 2074679 defendant Houghton George gent 682512 682512 Houghton, George, of Rybchester, Lancs, gent 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);