names

16 rows where case_id = 2168971

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4413100 2168971 2168971 plaintiff atte Doune Roger     atte Doune, Roger 0
4413101 2168971 2168971 plaintiff atte Doune Julia     Julia, his wife 1
4413102 2168971 2168971 defendant Stowe William de   753381 753381 Stowe, William de, of Sabrighesworth, parson 0
4413103 2168971 2168971 defendant Goldman Hugh     Goldman, Hugh 1
4413104 2168971 2168971 defendant Bromleye William     Bromleye, William 2
4413105 2168971 2168971 defendant Bromleye John, junior     Bromleye, John, junior 3
4413106 2168971 2168971 defendant atte Hyde Geoffrey     atte Hyde, Geoffrey 4
4413107 2168971 2168971 defendant Frere William     Frere, William 5
4413108 2168971 2168971 defendant atte Brok Robert     atte Brok, Robert 6
4413109 2168971 2168971 defendant atte Brok Randolf     atte Brok, Randolf 7
4413110 2168971 2168971 defendant atte Brok Joan     Joan, his wife 8
4413111 2168971 2168971 defendant Atton John de     Atton, John de 9
4413112 2168971 2168971 defendant (not given) John abbot of St Edmunds   St Edmunds, John, abbot of 10
4413113 2168971 2168971 defendant Martyn John     Martyn, John 11
4413114 2168971 2168971 defendant Matham Sampson     Matham, Sampson 12
4413115 2168971 2168971 defendant Matham Margaret     Margaret, his wife 13

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