names

13 rows where case_id = 1976516

✎ 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
3859037 1976516 1976516 plaintiff Bury Edward gent   Bury, Edward, gent 0
3859038 1976516 1976516 defendant Brugge Anthony gent 615897 615897 Brugge, Anthony, of Bulfanne, gent 0
3859039 1976516 1976516 defendant Brigges John husbandman 641037 641037 Brigges, John, of South Okyngdon, husbandman 1
3859040 1976516 1976516 defendant Theyer William husbandman 615897 615897 Theyer, William, of Bulfanne, husbandman 2
3859041 1976516 1976516 defendant Lyncoln John husbandman 615897 615897 Lyncoln, John, of Bulfanne, husbandman 3
3859042 1976516 1976516 defendant Coltherst Ralph laborer 615897 615897 Coltherst, Ralph, of Bulfanne, laborer 4
3859043 1976516 1976516 defendant Tyrell Humphrey gent 610826 610826 Tyrell, Humphrey, of Shenfeld, gent 5
3859044 1976516 1976516 defendant Stretys Henry yeoman 610826 610826 Stretys, Henry, of Shenfeld, yeoman 6
3859045 1976516 1976516 defendant Reynold John husbandman 615897 615897 Reynold, John, of Bulfanne, husbandman 7
3859046 1976516 1976516 defendant Latham Robert gent 615897 615897 Latham, Robert, of Bulfanne, gent 8
3859047 1976516 1976516 defendant Grene Thomas laborer 615897 615897 Grene, Thomas, of Bulfanne, laborer 9
3859048 1976516 1976516 defendant Woodward John yeoman 615897 615897 Woodward, John, of Bulfanne, yeoman 10
3859049 1976516 1976516 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);