names

13 rows where case_id = 1904018

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3629266 1904018 1904018 plaintiff Courtenay Katherine Countess of Devon   Courtenay, Katherine, Countess of Devon 0
3629267 1904018 1904018 defendant Speare Thomas singleman 597166 597166 Speare, Thomas, of Brodwodkelly, singleman 0
3629268 1904018 1904018 defendant Bobysshe John husbandman 597166 597166 Bobysshe, John, of Brodwodkelly, husbandman 1
3629269 1904018 1904018 defendant Bobysshe John yeoman 597166 597166 Bobysshe, John, of Brodwodkelly, yeoman 2
3629270 1904018 1904018 defendant Bobysshe William singleman 597166 597166 Bobysshe, William, of Brodwodkelly, singleman 3
3629271 1904018 1904018 defendant Batyn Humphrey gent 597166 597166 Batyn, Humphrey, of Brodwodkelly, gent 4
3629272 1904018 1904018 defendant Byset Hugh husbandman 597638 597638 Byset, Hugh, of Innewardlegh, husbandman 5
3629273 1904018 1904018 defendant Hale Richard husbandman 597639 597639 Hale, Richard, of Southanton, husbandman 6
3629274 1904018 1904018 defendant Hale Simon husbandman 597640 597640 Hale, Simon, of Stekylpath, husbandman 7
3629275 1904018 1904018 defendant Newecombe William yeoman 597638 597638 Newecombe, William, of Innewardlegh, husbandman Horwell, John, of Lydford, yeoman 8
3629276 1904018 1904018 defendant Draper John yeoman 597628 597628 Draper, John, of Bridstowe, yeoman 9
3629277 1904018 1904018 defendant Wrey Walter gent 587380 587380 Wrey, Walter, of Sourton, gent 10
3629278 1904018 1904018 defendant Draper John yeoman 597166 597166 Draper, John, of Brodwodkelly, yeoman 11

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