names

17 rows where case_id = 2304185

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4826060 2304185 2304185 plaintiff Walweyn Edmund     Walweyn, Edmund 0
4826061 2304185 2304185 defendant Parker Roger parker 789519 789519 Parker, Roger, of Tyso, Warws, parker 0
4826062 2304185 2304185 defendant all the rest are husbandman: Middilton William   618894 618894 all the rest are husbandman: Middilton, William, of Tyso 1
4826063 2304185 2304185 defendant Daylesford Peter   793554 793554 Daylesford, Peter, of Great Wolford 2
4826064 2304185 2304185 defendant Rose Thomas   793554 793554 Rose, Thomas, of Great Wolford 3
4826065 2304185 2304185 defendant Rose William   606465 606465 Rose, William, of Little Wolford 4
4826066 2304185 2304185 defendant Nicholas William   606465 606465 Nicholas, William, of Little Wolford 5
4826067 2304185 2304185 defendant Williams John   808439 808439 Williams, John, of Burmynton 6
4826068 2304185 2304185 defendant William Nicholas   808439 808439 William, Nicholas, of Burmynton 7
4826069 2304185 2304185 defendant Blakwell Nicholas   808439 808439 Blakwell, Nicholas, of Burmynton 8
4826070 2304185 2304185 defendant Gibbes Nicholas   808439 808439 Gibbes, Nicholas, of Burmynton 9
4826071 2304185 2304185 defendant Holdere Robert   808439 808439 Holdere, Robert, of Burmynton 10
4826072 2304185 2304185 defendant Hondes Thomas   808439 808439 Hondes, Thomas, of Burmynton 11
4826073 2304185 2304185 defendant Deke John   808439 808439 Deke, John, of Burmynton 12
4826074 2304185 2304185 defendant Carpernter William   594018 594018 Carpernter, William, of Berston 13
4826075 2304185 2304185 defendant Freman John   586442 586442 Freman, John, of Honyton 14
4826076 2304185 2304185 defendant Bradele John   586442 586442 Bradele, John, of Honyton 15

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