names

13 rows where place_id = 677471

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4027092 2034334 2034334 defendant Grave Thomas yeoman 677471 677471 Grave, Thomas, of Magna Hadham, Herts, yeoman 1
4080551 2053358 2053358 defendant Grimesdyche Thomas esq 677471 677471 Grimesdyche, Thomas, of Magna Hadham, Herts, esq 0
4083718 2054448 2054448 defendant Grymesdyche Thomas gent 677471 677471 Grymesdyche, Thomas, of Magna Hadham, Herts, gent 0
4378642 2157430 2157430 defendant Haynes John yeoman 677471 677471 Haynes, John, of Magna Hadham, Herts, yeoman 0
4660309 2249054 2249054 defendant Deynes Richard husbandman 677471 677471 Deynes, Richard, of Magna Hadham, Herts, husbandman 4
4664008 2250229 2250229 defendant Grymbaud John husbandman 677471 677471 Grymbaud, John, of Magna Hadham, Herts, husbandman 0
4889475 2323504 2323504 defendant Dawe John barber 677471 677471 Dawe, John, of Magna Hadham, Herts, barber 1
5029415 2365479 2365479 defendant Spencer Thomas yeoman 677471 677471 Spencer, Thomas, of Magna Hadham, Herts, yeoman 0
5029421 2365480 2365480 defendant Spenser Thomas yeoman 677471 677471 Spenser, Thomas, of Magna Hadham, Herts, yeoman 0
5103571 2387471 2387471 defendant Hunt John husbandman 677471 677471 Hunt, John, of Magna Hadham, Herts, husbandman 0
5260851 2433516 2433516 defendant Denny Richard yeoman 677471 677471 Denny, Richard, of Magna Hadham, Herts, yeoman 0
5482591 2499733 2499733 defendant Bawede Ralph (legal representative) 677471 677471 Bawede, Ralph, of Magna Hadham, Herts, esq, executors of 8
5513389 2509039 2509039 defendant Pryklove Thomas husbandman 677471 677471 Pryklove, Thomas, of Magna Hadham, Herts, husbandman 3

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