names

5 rows where place_id = 589132

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596638 1866583 1866583 defendant Kyrsacres Thomas chaplain 589132 589132 Kyrsacres, Thomas, of Wharrom in le Strete, chaplain 0
3627201 1903357 1903357 defendant Marshall John husbandman 589132 589132 Marshall, John, of Wharrom in le Strete, husbandman 14
4880850 2320918 2320918 plaintiff Carter William   589132 589132 Carter, William, of Wharrom in le Strete 1
5354569 2461507 2461507 defendant Acclom William husbandman 589132 589132 Acclom, William, of Wharrom in le Strete, husbandman 0
5513926 2509204 2509204 defendant Gyrsacre Thomas clerk 589132 589132 Gyrsacre, Thomas, of Wharrom in le Strete, clerk 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);