names

8 rows where place_id = 628558

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3783014 1952438 1952438 defendant Prootte Stephen husbandman 628558 628558 Prootte, Stephen, of Warpestowe, husbandman 0
4023574 2033140 2033140 defendant Rowsse John husbandman 628558 628558 Rowsse, John, of Warpestowe, husbandman 0
4028056 2034685 2034685 defendant Denbold Michael   628558 628558 Denbold, Michael, of Warpestowe clerk 0
4032042 2036128 2036128 defendant Denbold Michael clerk 628558 628558 Denbold, Michael, of Warpestowe, clerk 0
4032043 2036128 2036128 defendant Hayne Edmund cordwainer 628558 628558 Hayne, Edmund, of Warpestowe, cordwainer 1
4043807 2040238 2040238 defendant Harrys John husbandman 628558 628558 Harrys, John, of Warpestowe, husbandman 10
4060595 2046191 2046191 defendant Strowte John, senior husbandman 628558 628558 Strowte, John, senior, of Warpestowe, husbandman 0
4060596 2046191 2046191 defendant Strowte John, junior husbandman 628558 628558 Strowte, John, junior, of Warpestowe, husbandman 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);