names

13 rows where case_id = 1981246

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3873177 1981246 1981246 plaintiff Bury Edward gent   Bury, Edward, gent 0
3873178 1981246 1981246 defendant Brigge Anthony gent 615897 615897 Brigge, Anthony, of Bulfanne, gent 0
3873179 1981246 1981246 defendant Brigges John husbandman 643370 643370 Brigges, John, of Wokyngdon, husbandman 1
3873180 1981246 1981246 defendant Theyer William husbandman 615897 615897 Theyer, William, of Bulfanne, husbandman 2
3873181 1981246 1981246 defendant Lyncoln John husbandman 615897 615897 Lyncoln, John, of Bulfanne, husbandman 3
3873182 1981246 1981246 defendant Coltherst Ralph laborer 615897 615897 Coltherst, Ralph, of Bulfanne, laborer 4
3873183 1981246 1981246 defendant Tyrell Humphrey gent 610826 610826 Tyrell, Humphrey, of Shenfeld, gent 5
3873184 1981246 1981246 defendant Stretys Henry yeoman 610826 610826 Stretys, Henry, of SHenfeld, yeoman 6
3873185 1981246 1981246 defendant Reynold John husbandman 615897 615897 Reynold, John, of Bulfanne, husbandman 7
3873186 1981246 1981246 defendant Lathom Robert gent 615897 615897 Lathom, Robert, of Bulfanne, gent 8
3873187 1981246 1981246 defendant Grene Thomas laborer 615897 615897 Grene, Thomas, of Bulfanne, laborer 9
3873188 1981246 1981246 defendant Woodward John gent 615897 615897 Woodward, John, of Bulfanne, gent 10
3873189 1981246 1981246 defendant Norres John gent 591469 591469 Norres, John, of Dagnam, gent 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);