names

15 rows where place_id = 683396

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3945448 2005489 2005489 defendant Dalyson Edward   683396 683396 Dalyson, Edward, of Cranesley, Nhants, genty 12
3951594 2007613 2007613 defendant Dalyson Edward gent 683396 683396 Dalyson, Edward, of Cranesley, Nhants, gent, son of Thomas Dallyson, gent 0
3951596 2007614 2007614 defendant Dalison Edward gent 683396 683396 Dalison, Edward, of Cranesley, Nhants, gent, son of Thomas Dalison, of Cranesley, gent 0
4053787 2043730 2043730 defendant Chamberlyn Leonard gent 683396 683396 Chamberlyn, Leonard, of Cranesley, Nhants, gent 0
4053789 2043731 2043731 defendant Chamberlyn Leonard gent 683396 683396 Chamberlyn, Leonard, of Cranesley, Nhants, gent 0
4136368 2073352 2073352 defendant Fallison Robert gent 683396 683396 Fallison, Robert, of Cranesley, Nhants, gent 1
4173402 2086155 2086155 defendant Dallison Edward gent 683396 683396 Dallison, Edward, of Cranesley, Nhants, gent 0
5061293 2374963 2374963 defendant Merbury John esq 683396 683396 (Merbury, John, of Cranesley, Nhants, esq 1
5062769 2375413 2375413 defendant Merbury John esq 683396 683396 Merbury, John, of Cranesley, Nhants, esq 2
5062810 2375417 2375417 defendant Merbury John esq 683396 683396 Merbury, John, of Cranesley, Nhants, esq 2
5069715 2377440 2377440 defendant Merbury John esq 683396 683396 Merbury, John, of Cranesley, Nhants, esq 3
5069721 2377441 2377441 defendant Merbury John esq 683396 683396 Merbury, John, of Cranesley, Nhants, esq 3
5189890 2412786 2412786 defendant Merbery John esq 683396 683396 Merbery, John, of Cranesley, Nhants, esq 0
5274320 2437570 2437570 defendant (illegible) Henry husbandman 683396 683396 ---, Henry, of Cranesley, Nhants, husbandman 2
5291350 2442473 2442473 defendant Knyghton Henry husbandman 683396 683396 Knyghton, Henry, of Cranesley, Nhants, husbandman 2

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