names

13 rows where case_id = 2360973

✎ 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
5014084 2360973 2360973 plaintiff Basset Ralph esq   Basset, Ralph, esq 0
5014085 2360973 2360973 defendant Meverell Sampson   835224 835224 Meverell, Sampson, of Throweley, knight 0
5014086 2360973 2360973 defendant Meverell Thomas esq 835225 835225 Meverell, Thomas, of Throwele, esq 1
5014087 2360973 2360973 defendant Dycon John shingler 594946 594946 Dycon, John, of Abbots Bromley, shingler 2
5014088 2360973 2360973 defendant Bolton Thomas   588371 588371 Bolton, Thomas, of Stone, mason 3
5014089 2360973 2360973 defendant Stathous John yeoman 587136 587136 Stathous, John, of Derby, yeoman 4
5014090 2360973 2360973 defendant Staly Reginald yeoman 622198 622198 Staly, Reginald, of Tyddeswall, Derbs, yeoman 5
5014091 2360973 2360973 defendant Staly Roger laborer 604645 604645 Staly, Roger, of Tyddeswall, laborer 6
5014092 2360973 2360973 defendant Staley John yeoman 604645 604645 Staley, John, of Tyddeswall, yeoman 7
5014093 2360973 2360973 defendant Prynce Henry chaplain 588089 588089 Prynce, Henry, of Bakewell, chaplain 8
5014094 2360973 2360973 defendant Hobbesson William husbandman 835227 835227 Hobbesson, William, of Prestclyf, Derbs, Derbs, husbandman 9
5014095 2360973 2360973 defendant Leche Richard husbandman 604645 604645 Leche, Richard, of Tyddeswall, husbandman 10
5014096 2360973 2360973 defendant Pursegloves Thomas butcher 604645 604645 Pursegloves, Thomas, of Tyddeswall, butcher 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);