names

16 rows where case_id = 2053296

✎ 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
4080374 2053296 2053296 plaintiff Warde Francis     Warde, Francis 0
4080375 2053296 2053296 defendant Altham James esq 600424 600424 Altham, James, of Latton, esq 0
4080376 2053296 2053296 defendant Altham Edward gent 600424 600424 Altham, Edward, of Latton, gent 1
4080377 2053296 2053296 defendant Dowdale Henry yeoman 600424 600424 Dowdale, Henry, of Latton, yeoman 2
4080378 2053296 2053296 defendant Kendall Henry yeoman 600424 600424 Kendall, Henry, of Latton, yeoman 3
4080379 2053296 2053296 defendant Baker Thomas yeoman 600424 600424 Baker, Thomas, of Latton, yeoman 4
4080380 2053296 2053296 defendant Hatche Thomas yeoman 600424 600424 Hatche, Thomas, of Latton, yeoman 5
4080381 2053296 2053296 defendant Waddyngton Andrew gent 600424 600424 Waddyngton, Andrew, of Latton, gent 6
4080382 2053296 2053296 defendant Godderd William yeoman 600424 600424 Godderd, William, of Latton, yeoman 7
4080383 2053296 2053296 defendant Abbat Nicholas yeoman 600424 600424 Abbat, Nicholas, of Latton, yeoman 8
4080384 2053296 2053296 defendant Gullefer Henry laborer 600424 600424 Gullefer, Henry, of Latton, laborer 9
4080385 2053296 2053296 defendant Clarke John husbandman 600424 600424 Clarke, John, of Latton, husbandman 10
4080386 2053296 2053296 defendant Godfrey Walter yeoman 600424 600424 Godfrey, Walter, of Latton, yeoman 11
4080387 2053296 2053296 defendant Sparrowe William yeoman 689425 689425 Sparrowe, William, of Parnedon, yeoman 12
4080388 2053296 2053296 defendant Jaxson Barnabe husbandman 591820 591820 Jaxson, Barnabe, of Harlowe, husbandman 13
4080389 2053296 2053296 defendant Kente John yeoman 600424 600424 Kente, John, of Latton, yeoman 14

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