names

12 rows where place_id = 619068

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3727934 1935001 1935001 defendant Ayger William woolman 619068 619068 Ayger, William, of Heyworth, woolman 0
4470341 2191372 2191372 defendant Foulere Thomas   619068 619068 Foulere, Thomas, of Heyworth 4
4473536 2192382 2192382 defendant bocher John   619068 619068 bocher, John, of Heyworth 1
4537592 2212030 2212030 defendant Lenyng John   619068 619068 Lenyng, John, of Heyworth 3
4545537 2214527 2214527 plaintiff Bocher John   619068 619068 Bocher, John, of Heyworth 0
4559452 2218904 2218904 defendant Smyth Peter   619068 619068 Smyth, Peter, of Heyworth 0
4667444 2255538 2255538 defendant Brygge John husbandman 619068 619068 Brygge, John, of Heyworth, husbandman 0
4751908 2281052 2281052 plaintiff Stone John   619068 619068 Stone, John, of Heyworth, vicar 0
4958179 2344413 2344413 defendant Waryn Christopher clerk 619068 619068 Waryn, Christopher, of Heyworth, clerk 0
4971258 2348341 2348341 defendant Byde Henry loader 619068 619068 Byde, Henry, of Heyworth, loader 4
5152039 2401731 2401731 defendant Forster John mercer 619068 619068 Forster, John, of Heyworth, mercer 0
5614337 2548274 2548274 plaintiff Elyot William   619068 619068 Elyot, William, of Heyworth 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);