names

21 rows where case_id = 2212856

✎ 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
4540261 2212856 2212856 plaintiff Wedenesley Thomas knight   Wedenesley, Thomas, knight 0
4540262 2212856 2212856 defendant Smth Richard   625044 625044 Smth, Richard, of Bankewell 0
4540263 2212856 2212856 defendant Smythson Robert   625044 625044 Smythson, Robert, of Bankewell 1
4540264 2212856 2212856 defendant Chapman John   625044 625044 Chapman, John, of Bankewell 2
4540265 2212856 2212856 defendant Aldeport John de     Aldeport, John de 3
4540266 2212856 2212856 defendant Smythson Richard   625044 625044 Smythson, Richard, of Bankewell 4
4540267 2212856 2212856 defendant Spenser John     Spenser, John 5
4540268 2212856 2212856 defendant Padley Roger de     Padley, Roger de 6
4540269 2212856 2212856 defendant Almine John     Almine, John 7
4540270 2212856 2212856 defendant Sheffeld Robert de     Sheffeld, Robert de 8
4540271 2212856 2212856 defendant Whichull John de     Whichull, John de 9
4540272 2212856 2212856 defendant Heyne John     Heyne, John 10
4540273 2212856 2212856 defendant Crabull William     Crabull, William 11
4540274 2212856 2212856 defendant Swynsto Thomas de     Swynsto, Thomas de 12
4540275 2212856 2212856 defendant Padley Thomas     Padley, Thomas 13
4540276 2212856 2212856 defendant Fybury William Taillour John, of Bankewell   Fybury, William Taillour, John, of Bankewell 14
4540277 2212856 2212856 defendant Bretoner Robert     Bretoner, Robert 15
4540278 2212856 2212856 defendant Porter Henry     Porter, Henry 16
4540279 2212856 2212856 defendant Webster Hugh     Webster, Hugh 17
4540280 2212856 2212856 defendant Gere Edward     Gere, Edward 18
4540281 2212856 2212856 defendant Hublyn Thomas     Hublyn, Thomas 19

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