names

17 rows where place_id = 597442

✎ 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
3628593 1903816 1903816 defendant Benteley John yeoman 597442 597442 Benteley, John, of Bassyngborne, Cams, yeoman 2
3685094 1921482 1921482 plaintiff Asshewell Giles (legal representative) 597442 597442 Asshewell, Giles, of Bassyngborne, Cams, yeoman, executrix of 0
3763233 1946137 1946137 defendant Gode John husbandman 597442 597442 Gode, John, of Bassyngborne, Cams, husbandman 2
3904064 1991601 1991601 defendant Kyng Thomas husbandman 597442 597442 Kyng, Thomas, of Bassyngborne, Cams, husbandman 1
3910808 1993937 1993937 defendant Lyn Thomas esq 597442 597442 Lyn, Thomas, of Bassyngborne, Cams, esq 0
3920072 1997048 1997048 defendant Pynke Margaret widow 597442 597442 Pynke, Margaret, of Bassyngborne, Cams, widow 5
3921209 1997445 1997445 defendant Thomas William husbandman 597442 597442 Thomas, William, of Bassyngborne, Cams, husbandman 0
3924583 1998536 1998536 defendant Lyn Thomas esq 597442 597442 Lyn, Thomas, of Bassyngborne, Cams, esq 0
3924585 1998537 1998537 defendant Lyn Thomas esq 597442 597442 Lyn, Thomas, of Bassyngborne, Cams, esq 0
3924587 1998538 1998538 defendant Lyn Thomas esq 597442 597442 Lyn, Thomas, of Bassyngborne, Cams, esq 0
3959813 2010524 2010524 defendant Lyme John esq 597442 597442 Lyme, John, of Bassyngborne, Cams, esq 1
4860580 2314666 2314666 defendant Chirche John gent 597442 597442 Chirche, John, of Bassyngborne, Cams, gent 2
4985120 2352476 2352476 defendant Cawdrey Richard clerk 597442 597442 Cawdrey, Richard, of Bassyngborne, Cams, clerk 2
5260321 2433355 2433355 defendant Soole William gent 597442 597442 Soole, William, of Bassyngborne, Cams, gent 1
5505405 2506605 2506605 plaintiff Bolnest Robert maltman 597442 597442 Bolnest, Robert, of Bassyngborne, Cams, maltman 0
5632822 2554277 2554277 defendant Gamyn Margaret widow 597442 597442 Gamyn, Margaret, of Bassyngborne, Cams, widow 3
5632881 2554291 2554291 defendant Gamyn Margaret widow 597442 597442 Gamyn, Margaret, of Bassyngborne, Cams, widow 1

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