names

11 rows where case_id = 2370813

✎ 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
5047295 2370813 2370813 plaintiff Ormond James   839727 839727 Ormond, James, of Wiltshire, Earl 0
5047296 2370813 2370813 plaintiff Tyrell Thomas knight   Tyrell, Thomas, knight 1
5047297 2370813 2370813 plaintiff Fylongley Henry esq   Fylongley, Henry, esq 2
5047298 2370813 2370813 plaintiff Darcy Robert esq   Darcy, Robert, esq 3
5047299 2370813 2370813 plaintiff Tyrell William esq   Tyrell, William, esq 4
5047300 2370813 2370813 defendant Bury William gent 586470 586470 Bury, William, of Colchester, gent 0
5047301 2370813 2370813 defendant Hygham John yeoman 620516 620516 Hygham, John, of Raylegh, Essex, yeoman 1
5047302 2370813 2370813 defendant Redman Roger yeoman 588012 588012 Redman, Roger, of Stratford atte Bowe, yeoman 2
5047303 2370813 2370813 defendant Knyston John gent 594378 594378 Knyston, John, of Hadley, Essex, gent 3
5047304 2370813 2370813 defendant Stoughton John esq 831168 831168 Stoughton, John, of Hakenby, Lincs, esq 4
5047305 2370813 2370813 defendant Arnold Alice   839729 839729 Arnold, Alice, of Morton by Brun, Lincs, wido 5

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