names

24 rows where case_id = 2513414

✎ 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
5528333 2513414 2513414 plaintiff Mordaunt William     Mordaunt, William 0
5528334 2513414 2513414 defendant Darcy Thomas   896656 896656 Darcy, Thomas, of Temple Newsam, knight 0
5528335 2513414 2513414 defendant Ward Christopher   689017 689017 Ward, Christopher, of Gevendale, knight 1
5528336 2513414 2513414 defendant Constable Marmaduke Flaynburgh, knight   Constable, Marmaduke, Flaynburgh, knight 2
5528337 2513414 2513414 defendant Griffith Walter   623918 623918 Griffith, Walter, of Annesburton, knight 3
5528338 2513414 2513414 defendant Ingilby William   590494 590494 Ingilby, William, of Ripley, knight 4
5528339 2513414 2513414 defendant Gascoigne William   896658 896658 Gascoigne, William, of Gankthorp, knight 5
5528340 2513414 2513414 defendant Layngton Thomas esq 799422 799422 Layngton, Thomas, of Hodilston, esq 6
5528341 2513414 2513414 defendant Hopton Roger   758773 758773 Hopton, Roger, of Akworth, knight 7
5528342 2513414 2513414 defendant Dyneley Roger gent 779244 779244 Dyneley, Roger, of Ansthorp, gent 8
5528343 2513414 2513414 defendant Skargill William   896659 896659 Skargill, William, of Thorp juxta Rothewell, knight 9
5528344 2513414 2513414 defendant Rokley Thomas gent 856238 856238 Rokley, Thomas, of Alworth, gent 10
5528345 2513414 2513414 defendant Clapham Christopher gent 853140 853140 Clapham, Christopher, of Temple Newsom, gent 11
5528346 2513414 2513414 defendant Wentworth Thomas gent 595133 595133 Wentworth, Thomas, of North Elmsall, gent 12
5528347 2513414 2513414 defendant FitzHugh Edward esq 602977 602977 FitzHugh, Edward, of Camerton, esq 13
5528348 2513414 2513414 defendant Nevyle John   882276 882276 Nevyle, John, of Leversege, knight 14
5528349 2513414 2513414 defendant Everyngham John gent 641850 641850 Everyngham, John, of Birkyn, gent 15
5528350 2513414 2513414 defendant Everyngham Thomas gent 641850 641850 Everyngham, Thomas, of Birkyn, gent 16
5528351 2513414 2513414 defendant Preston Christopher gent 896660 896660 Preston, Christopher, of Hekilton, gent 17
5528352 2513414 2513414 defendant Bestwik John yeoman 586240 586240 Bestwik, John, of Pountfret, yeoman 18
5528353 2513414 2513414 defendant Wentworth Philip esq 586240 586240 Wentworth, Philip, of Pountfret, esq 19
5528354 2513414 2513414 defendant Burton John gent 595243 595243 Burton, John, of Kynnesley, gent 20
5528355 2513414 2513414 defendant Meryng Thomas esq 597500 597500 Meryng, Thomas, of Wheldale, esq 21
5528356 2513414 2513414 defendant Saynell or Sayvell John   602513 602513 Saynell or Sayvell , John, of Thornhill, knight 22

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