names

11 rows where place_id = 813310

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4855324 2313017 2313017 defendant Punchardon Richard gent 813310 813310 (Punchardon, Richard, of Elyngham, Hants, gent 1
4855328 2313018 2313018 defendant Punchardon Richard gent 813310 813310 (Punchardon, Richard, of Elyngham, Hants, gent 1
4855331 2313019 2313019 defendant Punchardon Richard gent 813310 813310 Punchardon, Richard, of Elyngham, Hants, gent 0
4855333 2313020 2313020 defendant Punchardon Richard gent 813310 813310 Punchardon, Richard, of Elyngham, Hants, gent 0
4880136 2320698 2320698 defendant Punchardon Richard gent 813310 813310 Punchardon, Richard, of Elyngham, Hants, gent 1
4888878 2323307 2323307 defendant Laurence Thomas husbandman 813310 813310 Laurence, Thomas, of Elyngham, Hants, husbandman 2
4896364 2325527 2325527 defendant Laurence Thomas husbandman 813310 813310 Laurence, Thomas, of Elyngham, Hants, husbandman 2
4919017 2332460 2332460 defendant Punchardon Richard gent 813310 813310 Punchardon, Richard, of Elyngham, Hants, gent 1
5069827 2377470 2377470 defendant Poncherdon Richard gent 813310 813310 Poncherdon, Richard, of Elyngham, Hants, gent 0
5600120 2534923 2534923 defendant Erneley John husbandman 813310 813310 Erneley, John, of Elyngham, Hants, husbandman 0
5600122 2534924 2534924 defendant Ernley John   813310 813310 Ernley, John, of Elyngham, Hants, gent, son of Ernley, Edmund 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);