names

5 rows where case_id = 2350584

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4978710 2350584 2350584 plaintiff Rowe Richard draper 612100 612100 Rowe, Richard, of Barnestapell, draper 0
4978711 2350584 2350584 defendant Bonde Thomasine widow of Bonde, Thomas, , of Wolferthisworthy   Bonde, Thomasine, widow of Bonde, Thomas, ,of Wolferthisworthy 0
4978712 2350584 2350584 defendant Weke atte Mille Joan widow of Weke atte Mille, Richard, of South Tauton, widow of Merser, Ralph, of South Molton   Weke atte Mille, Joan, widow of Weke atte Mille, Richard, of South Tauton, widow of Merser, Ralph, of South Molton 1
4978713 2350584 2350584 defendant Harry William clerk 827642 827642 Harry, William, of Charles, clerk 2
4978714 2350584 2350584 defendant Elys John husbandman 655467 655467 Elys, John, of Ilfardcombe, husbandman 3

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