names

13 rows where case_id = 1946863

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3765459 1946863 1946863 plaintiff Lambart John, junior     Lambart, John, junior 0
3765460 1946863 1946863 defendant Heyber Thomas clothier 598382 598382 Heyber, Thomas, of Skypton, Craven, Yorks, clothier 0
3765461 1946863 1946863 defendant Lambart Christopher yeoman 598403 598403 Lambart, Christopher, of Skypton, yeoman 1
3765462 1946863 1946863 defendant Kytchyn Thomas yeoman 598403 598403 Kytchyn, Thomas, of Skypton, yeoman 2
3765463 1946863 1946863 defendant Bulcok Richard gent 585869 585869 Bulcok, Richard, of London, gent 3
3765464 1946863 1946863 defendant Hawte Alan gent 585869 585869 Hawte, Alan, of London, gent 4
3765465 1946863 1946863 defendant Stable Edmund yeoman 625651 625651 Stable, Edmund, of Wygglesworth, Craven, Yorks, yeoman 5
3765466 1946863 1946863 defendant Power Edward gent 625652 625652 Power, Edward, of Brawell, Yorks, gent 6
3765467 1946863 1946863 defendant Gilliot William clerk 585869 585869 Gilliot, William, of London, clerk 7
3765468 1946863 1946863 defendant Hamlyn Christopher yeoman 625653 625653 Hamlyn, Christopher, of Sethyll, Yorks, yeoman 8
3765469 1946863 1946863 defendant Pennyngton William   654384 654384 Pennyngton, William, of Costesey, Norf, knight 9
3765470 1946863 1946863 defendant Wycombe Thomas (legal representative) 585869 585869 Wycombe, Thomas, of London, gent, executrix of 10
3765471 1946863 1946863 defendant Wycombe Brigit widow 586202 586202 Wycombe, Brigit, of Westminister, widow 11

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