names

16 rows where case_id = 2304184

✎ 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
4826044 2304184 2304184 plaintiff Walweyn Edmund     Walweyn, Edmund 0
4826045 2304184 2304184 defendant Parker Roger parker 808438 808438 Parker, Roger, of Tyso, Warrws, parker 0
4826046 2304184 2304184 defendant Middilton William husbandman 618894 618894 Middilton, William, of Tyso, husbandman 1
4826047 2304184 2304184 defendant Daylesford Peter husbandman 793554 793554 Daylesford, Peter, of Great Wolford, husbandman 2
4826048 2304184 2304184 defendant Rose Thomas husbandman 793554 793554 Rose, Thomas, of Great Wolford, husbandman 3
4826049 2304184 2304184 defendant Rose William husbandman 606465 606465 Rose, William, of Little Wolford, husbandman 4
4826050 2304184 2304184 defendant Nicholas William husbandman 606465 606465 Nicholas, William, of Little Wolford, husbandman 5
4826051 2304184 2304184 defendant William Nicholas     William, Nicholas 6
4826052 2304184 2304184 defendant Blakewell NIcholas Gibbes, Nicholas   Blakewell, NIcholas, Gibbes, Nicholas 7
4826053 2304184 2304184 defendant Holdere Robert     Holdere, Robert 8
4826054 2304184 2304184 defendant Hones Thomas     Hones, Thomas 9
4826055 2304184 2304184 defendant Dekon John     Dekon, John 10
4826056 2304184 2304184 defendant Carpenter William husbandman 594018 594018 Carpenter, William, of Berston, husbandman 11
4826057 2304184 2304184 defendant Freman John husbandman 586442 586442 Freman, John, of Honyton, husbandman 12
4826058 2304184 2304184 defendant Bradele John husbandman 586442 586442 Bradele, John, of Honyton, husbandman 13
4826059 2304184 2304184 defendant each of Burmynton   except where given otherwise   each of Burmynton, husbandman, except where given otherwise 14

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