names

21 rows where case_id = 2513415

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5528357 2513415 2513415 plaintiff Mordaunt William     Mordaunt, William 0
5528358 2513415 2513415 defendant Darcy Thomas   896661 896661 Darcy, Thomas, of Temple Newsam, Yorks, knight 0
5528359 2513415 2513415 defendant Creswell Robert laborer 589829 589829 Creswell, Robert, of Tikhill, Yorks, laborer 1
5528360 2513415 2513415 defendant Pikburn Margaret     Pikburn, Margaret 2
5528361 2513415 2513415 defendant Bollyng Reynburd     Bollyng, Reynburd 3
5528362 2513415 2513415 defendant Denys Richard     Denys, Richard 4
5528363 2513415 2513415 defendant Paget Thomas     Paget, Thomas 5
5528364 2513415 2513415 defendant Coghull Thomas     Coghull, Thomas 6
5528365 2513415 2513415 defendant Aldeburgh Richard     Aldeburgh, Richard 7
5528366 2513415 2513415 defendant Clerk Thomas     Clerk, Thomas 8
5528367 2513415 2513415 defendant Percy Leo     Percy, Leo 9
5528368 2513415 2513415 defendant Hastynges Roger     Hastynges, Roger 10
5528369 2513415 2513415 defendant Cholmeley Richard     Cholmeley, Richard 11
5528370 2513415 2513415 defendant Carre Robert     Carre, Robert 12
5528371 2513415 2513415 defendant Tiler William     Tiler, William 13
5528372 2513415 2513415 defendant Busby Andrew     Busby, Andrew 14
5528373 2513415 2513415 defendant Brabon Thomas     Brabon, Thomas 15
5528374 2513415 2513415 defendant Savage Humphrey     Savage, Humphrey 16
5528375 2513415 2513415 defendant Grace Robert     Grace, Robert 17
5528376 2513415 2513415 defendant Bardesley James     Bardesley, James 18
5528377 2513415 2513415 defendant Kelyng William     Kelyng, William 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);