names

16 rows where place_id = 600726

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3642265 1908030 1908030 defendant Denys William esq 600726 600726 Denys, William, of Durham, Glos, esq 0
3642267 1908031 1908031 defendant Denys William esq 600726 600726 Denys, William, of Durham, Glos, esq 0
3887939 1986215 1986215 defendant Denys Walter   600726 600726 Denys, Walter, of Durham, Glos, knight 0
3916893 1996015 1996015 defendant Denys Walter   600726 600726 Denys, Walter, of Durham, Glos, knight 1
3956114 2009209 2009209 defendant Westley Anne widow 600726 600726 Westley, Anne, of Glos, widow 1
3970516 2014286 2014286 defendant Denys Walter   600726 600726 Denys, Walter, of Durham, Glos, knight 0
3991575 2021747 2021747 defendant Brayne Robert yeoman 600726 600726 Brayne, Robert, of Durham, Glos, yeoman 1
3991577 2021748 2021748 defendant Brayne Robert yeoman 600726 600726 Brayne, Robert, of Durham, Glos, yeoman 0
4039155 2038631 2038631 defendant Denys Walter clerk 600726 600726 Denys, Walter, of Durham, Glos, clerk 3
4039160 2038632 2038632 defendant Denys Walter clerk 600726 600726 Denys, Walter, of Durham, Glos, clerk 3
4979270 2350758 2350758 defendant Solers John esq 600726 600726 Solers, John, of Glos, or of London, esq 0
4979272 2350759 2350759 defendant Solers John esq or gent 600726 600726 Solers, John, of Glos, or of London, esq or gent 0
5060505 2374720 2374720 defendant Heyward John husbandman 600726 600726 Heyward, John, of Glos, husbandman 0
5080962 2380803 2380803 defendant Mody John gent 600726 600726 Mody, John, of Glos, gent 0
5104604 2387782 2387782 plaintiff Carsy John esq 600726 600726 Carsy, John, of Glos, esq 0
5292542 2442818 2442818 defendant Cokk Lawrence chapman 600726 600726 Cokk, Lawrence, of Monmouth, Glos, chapman 0

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