names

10 rows where place_id = 830518

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4983756 2352068 2352068 defendant West Robert husbandman 830518 830518 West, Robert, of Claxby juxta Wylughby, husbandman 0
4983757 2352068 2352068 defendant West John husbandman 830518 830518 West, John, of Claxby juxta Wylughby, husbandman 1
5022186 2363379 2363379 defendant Bryton Philip bellmaker 830518 830518 Bryton, Philip, of Claxby juxta Wylughby, bellmaker 3
5062632 2375383 2375383 defendant Sybsey John husbandman 830518 830518 Sybsey, John, of Claxby juxta Wylughby, husbandman 0
5073611 2378591 2378591 defendant Bretayn Philip   830518 830518 Bretayn, Philip, of Claxby juxta Wylughby, bell maker 0
5088429 2382990 2382990 defendant Deye Robert husbandman 830518 830518 Deye, Robert, of Claxby juxta Wylughby, husbandman 4
5113271 2390276 2390276 defendant Deye Robert husbandman 830518 830518 Deye, Robert, of Claxby juxta Wylughby, husbandman 1
5236441 2426249 2426249 defendant Deye Robert husbandman 830518 830518 Deye, Robert, of Claxby juxta Wylughby, husbandman 10
5242411 2427994 2427994 defendant Day Robert husbandman 830518 830518 Day, Robert, of Claxby juxta Wylughby, husbandman 0
5293723 2443125 2443125 defendant Dey Robert butcher 830518 830518 Dey, Robert, of Claxby juxta Wylughby, butcher 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);