names

27 rows where case_id = 2526471

✎ 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
5572373 2526471 2526471 plaintiff Mordaunt William     Mordaunt, William 0
5572374 2526471 2526471 defendant Workesley Robert esq 605914 605914 Workesley, Robert, of Bothes, Lancs, esq 0
5572375 2526471 2526471 defendant Molyneux James clerk 613268 613268 Molyneux, James, of Seston, Lancs, clerk 1
5572376 2526471 2526471 defendant Hothom John   592440 592440 Hothom, John, of Scorburgh, Yorks, knight 2
5572377 2526471 2526471 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 3
5572378 2526471 2526471 defendant Everyngham John   737908 737908 Everyngham, John, of Birkyn, Yorks, knight 4
5572379 2526471 2526471 defendant Broun John yeoman 901512 901512 Broun, John, of Toxford, Notts, yeoman 5
5572380 2526471 2526471 defendant Lithell Robert     Lithell, Robert 6
5572381 2526471 2526471 defendant Louther Ralph     Louther, Ralph 7
5572382 2526471 2526471 defendant Musgrave John     Musgrave, John 8
5572383 2526471 2526471 defendant Curson Robert     Curson, Robert 9
5572384 2526471 2526471 defendant Osney Bartholomew     Osney, Bartholomew 10
5572385 2526471 2526471 defendant Forman Robert     Forman, Robert 11
5572386 2526471 2526471 defendant Barker John, senior     Barker, John, senior 12
5572387 2526471 2526471 defendant Barker John, junior     Barker, John, junior 13
5572388 2526471 2526471 defendant Catour John, junior     Catour, John, junior 14
5572389 2526471 2526471 defendant Catour John, senior     Catour, John, senior 15
5572390 2526471 2526471 defendant Couper John     Couper, John 16
5572391 2526471 2526471 defendant Cokke Nicholas     Cokke, Nicholas 17
5572392 2526471 2526471 defendant Broxham Robert     Broxham, Robert 18
5572393 2526471 2526471 defendant Herryson John     Herryson, John 19
5572394 2526471 2526471 defendant Huetson Robert     Huetson, Robert 20
5572395 2526471 2526471 defendant Robynson William     Robynson, William 21
5572396 2526471 2526471 defendant Dawnet Robert     Dawnet, Robert 22
5572397 2526471 2526471 defendant Home Thomas     Home, Thomas 23
5572398 2526471 2526471 defendant Wesby homas     Wesby, homas 24
5572399 2526471 2526471 defendant Stok Thomas et al   Stok, Thomas, et al 25

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