names

9 rows where case_id = 1962665

✎ 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
3815169 1962665 1962665 plaintiff Gun John (legal representative) 585869 585869 Gun, John, of London, merchant tailor, executors of 0
3815170 1962665 1962665 plaintiff Gun Elizabeth widow   (Gun, Elizabeth, widow 1
3815171 1962665 1962665 plaintiff Huse John chamberlain of London   Huse, John, chamberlain of London 2
3815172 1962665 1962665 plaintiff Jenour Robert gent   Jenour, Robert, gent 3
3815173 1962665 1962665 defendant Lenham Thomas prior of Dover Priory, Kent   Lenham, Thomas, prior of Dover Priory, Kent 0
3815174 1962665 1962665 defendant Prestlond Edward clerk 613390 613390 Prestlond, Edward, of Sandersted, Surrey, clerk 1
3815175 1962665 1962665 defendant Averey John gent 633848 633848 Averey, John, of Iselden, Middx, gent 2
3815176 1962665 1962665 defendant Segwyke Nicholas yeoman 597548 597548 Segwyke, Nicholas, of Rumsey, Hants, yeoman 3
3815177 1962665 1962665 defendant Thomas Samson merchant 586254 586254 Thomas, Samson, of Southampton, merchant 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);