names

8 rows where case_id = 2498719

✎ 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
5478925 2498719 2498719 plaintiff Bronnescombe William     Bronnescombe, William 0
5478926 2498719 2498719 defendant Bellegh Roger husbandman 677352 677352 Bellegh, Roger, of Whitstone, husbandman 0
5478927 2498719 2498719 defendant Wakeham Robert yeoman 602252 602252 Wakeham, Robert, of Ponderham, yeoman 1
5478928 2498719 2498719 defendant Grenewode Robert yeoman 586036 586036 Grenewode, Robert, of Exeter, yeoman 2
5478929 2498719 2498719 defendant Jacob John husbandman 591028 591028 Jacob, John, of Crediton, husbandman 3
5478930 2498719 2498719 defendant Jacob Thomas weaver 591028 591028 Jacob, Thomas, of Crediton, weaver 4
5478931 2498719 2498719 defendant Basse Thomas laborer 591028 591028 Basse, Thomas, of Crediton, laborer 5
5478932 2498719 2498719 defendant Wodelegh Roger husbandman 891638 891638 Wodelegh, Roger, of tetteborn, husbandman 6

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