names

13 rows where place_id = 670319

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3996531 2023520 2023520 defendant Granger Robert husbandman 670319 670319 Granger, Robert, of Holnest, husbandman 0
3996532 2023520 2023520 defendant Marten John husbandman 670319 670319 Marten, John, of Holnest, husbandman 1
4065589 2047983 2047983 defendant Bond John yeoman 670319 670319 Bond, John, of Holnest, yeoman 0
4080105 2053193 2053193 defendant Whyttell Robert husbandman 670319 670319 Whyttell, Robert, of Holnest, husbandman 0
4135142 2072886 2072886 defendant Bolyn William husbandman 670319 670319 Bolyn, William, of Holnest, husbandman 0
4135143 2072886 2072886 defendant Moore William   670319 670319 Moore, William, of Holnest, coal carrier 1
4192345 2092880 2092880 defendant Kerom William yeoman 670319 670319 Kerom, William, of Holnest, yeoman 0
4198042 2094863 2094863 defendant Gregorye Aldred yeoman 670319 670319 Gregorye, Aldred, of Holnest, yeoman 1
4313740 2134913 2134913 defendant Palmer Robert husbandman 670319 670319 Palmer, Robert, of Holnest, husbandman 0
4313741 2134913 2134913 defendant Durraunt John husbandman 670319 670319 Durraunt, John, of Holnest, husbandman 1
4567820 2221507 2221507 defendant Bason Thomas   670319 670319 Bason, Thomas, of Holnest 0
4692449 2263156 2263156 defendant Deene John the husbandman 670319 670319 Deene, John the, of Holnest, husbandman 0
5512888 2508885 2508885 defendant Frenshe Thomas husbandman 670319 670319 Frenshe, Thomas, of Holnest, 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);