names

19 rows where place_id = 596484

✎ 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
3624964 1875340 1875340 defendant Greynfeld Thomas esq 596484 596484 Greynfeld, Thomas, of Kylkehampton, Cornw, esq 1
3624971 1875341 1875341 defendant Greynfeld Thomas esq 596484 596484 Greynfeld, Thomas, of Kylkehampton, Cornw, esq 1
3640151 1907366 1907366 defendant Brownyng Henry husbandman 596484 596484 Brownyng, Henry, of Kylkehampton, Cornw, husbandman 2
3752386 1942669 1942669 defendant Grenefeld Digory gent 596484 596484 Grenefeld, Digory, of Kylkehampton, Cornw, gent 0
4050789 2042719 2042719 defendant Barratt John yeoman 596484 596484 Barratt, John, of Kylkehampton, Cornw, yeoman 0
4060527 2046166 2046166 defendant Barrett John gent 596484 596484 Barrett, John, of Kylkehampton, Cornw, gent 0
4061675 2046575 2046575 defendant Bordfyld John gent 596484 596484 Bordfyld, John, of Kylkehampton, Cornw, gent 0
4064347 2047526 2047526 defendant Bate James clerk 596484 596484 Bate, James, of Kylkehampton, Cornw, clerk 2
4069951 2049536 2049536 defendant Bordfield John gent 596484 596484 Bordfield, John, of Kylkehampton, Cornw, gent 0
4069953 2049537 2049537 defendant Barrett John yeoman 596484 596484 Barrett, John, of Kylkehampton, Cornw, yeoman 0
4160665 2081804 2081804 defendant Bordefylde John gent 596484 596484 Bordefylde, John, of Kylkehampton, Cornw, gent 0
4165247 2083353 2083353 defendant Bordfylde John gent 596484 596484 Bordfylde, John, of Kylkehampton, Cornw, gent 0
4867000 2316642 2316642 defendant Scottescombe John husbandman 596484 596484 Scottescombe, John, of Kylkehampton, Cornw, husbandman 1
5396539 2474099 2474099 defendant Gough John gent 596484 596484 Gough, John, of Kylkehampton, Cornw, gent 6
5409821 2477905 2477905 defendant Gough John gent 596484 596484 Gough, John, of Kylkehampton, Cornw, gent 6
5427300 2483109 2483109 defendant White John clerk 596484 596484 White, John, of Kylkehampton, Cornw, clerk 0
5440764 2487148 2487148 defendant Greynfeld Thomas esq 596484 596484 Greynfeld, Thomas, of Kylkehampton, Cornw, esq 0
5504257 2506246 2506246 defendant Gogh Richard gent 596484 596484 Gogh, Richard, of Kylkehampton, Cornw, gent 0
5512904 2508892 2508892 defendant Graynfyld Thomas esq 596484 596484 Graynfyld, Thomas, of Kylkehampton, Cornw, esq 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);