names

8 rows where place_id = 867565

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation

id ▼ case_id role surname forename occupation place_id raw_segment seq
5276214 2438113 2438113 defendant Cokke John husbandman 867565 867565 Cokke, John, of Uhurst, husbandman 19
5276215 2438113 2438113 defendant Dandy William husbandman 867565 867565 Dandy, William, of Uhurst, husbandman 20
5276216 2438113 2438113 defendant Dandy John laborer 867565 867565 Dandy, John, of Uhurst, laborer 21
5276217 2438113 2438113 defendant Eylone William husbandman 867565 867565 Eylone, William, of Uhurst, husbandman 22
5276218 2438113 2438113 defendant Pratte John laborer 867565 867565 Pratte, John, of Uhurst, laborer 23
5276219 2438113 2438113 defendant Chambyr George tailor 867565 867565 Chambyr, George, of Uhurst, tailor 24
5276220 2438113 2438113 defendant Lynne John cooper 867565 867565 Lynne, John, of Uhurst, cooper 25
5276221 2438113 2438113 defendant Boteler Walter husbandman 867565 867565 Boteler, Walter, of Uhurst, husbandman 26

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);