names

14 rows where place_id = 817213

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4884915 2322179 2322179 plaintiff Thornton John gent 817213 817213 Thornton, John, of Melton juxta Gravesende, gent 0
4969324 2347784 2347784 defendant Seman Robert husbandman 817213 817213 Seman, Robert, of Melton juxta Gravesende, husbandman 1
5076225 2379391 2379391 defendant Hammys John barber 817213 817213 Hammys, John, of Melton juxta Gravesende, barber 0
5227836 2423756 2423756 defendant Polman John husbandman 817213 817213 Polman, John, of Melton juxta Gravesende, husbandman 1
5254232 2431446 2431446 defendant Broke Robert ostler 817213 817213 Broke, Robert, of Melton juxta Gravesende, ostler 0
5256777 2432242 2432242 defendant Rotlond William yeoman 817213 817213 Rotlond, William, of Melton juxta Gravesende, yeoman 0
5279025 2438974 2438974 defendant Doget John mercer 817213 817213 Doget, John, of Melton juxta Gravesende, mercer 0
5279026 2438974 2438974 defendant Hokeregge Joan widow 817213 817213 Hokeregge, Joan, of Melton juxta Gravesende, widow 1
5279032 2438976 2438976 defendant Hokeregge John (legal representative) 817213 817213 Hokeregge, John, of Melton juxta Gravesende, husbandman, executors of 1
5279033 2438976 2438976 defendant Hokeregge Joan widow 817213 817213 (Hokeregge, Joan, of Melton juxta Gravesende, widow 2
5319732 2450997 2450997 plaintiff Doget John   817213 817213 Doget, John, of Melton juxta Gravesende 1
5335274 2455618 2455618 defendant Rutlond William husbandman 817213 817213 Rutlond, William, of Melton juxta Gravesende, husbandman 0
5335275 2455618 2455618 defendant Elys William husbandman 817213 817213 Elys, William, of Melton juxta Gravesende, husbandman 1
5337896 2456419 2456419 defendant Hillys William yeoman 817213 817213 Hillys, William, of Melton juxta Gravesende, yeoman 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);