names

24 rows where case_id = 2521871

✎ 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
5556503 2521871 2521871 plaintiff Lovell Thomas knight   Lovell, Thomas, knight 0
5556504 2521871 2521871 plaintiff Hobart James knight   Hobart, James, knight 1
5556505 2521871 2521871 plaintiff Empson Richard knight   Empson, Richard, knight 2
5556506 2521871 2521871 plaintiff Lucas Thomas     Lucas, Thomas 3
5556507 2521871 2521871 defendant Layborne Thomas esq 899748 899748 Layborne, Thomas, of Cunyswyk, Westmor, esq 0
5556508 2521871 2521871 defendant Bellyngham Roger   899749 899749 Bellyngham, Roger, of Burmeshede, Westmor, knight 1
5556509 2521871 2521871 defendant Metcalf James esq 654629 654629 Metcalf, James, of Nappay, Yorks, esq 2
5556510 2521871 2521871 defendant Darell Edward   864982 864982 Darell, Edward, of Lytelcote, Wilts, knight 3
5556511 2521871 2521871 defendant Blount Thomas   899750 899750 Blount, Thomas, of Kenlot, Salop, knight 4
5556512 2521871 2521871 defendant Throgmarton Christopher esq 588814 588814 Throgmarton, Christopher, of Trylley, Glos, esq 5
5556513 2521871 2521871 defendant Blount John esq 723024 723024 Blount, John, of Grendon, Herefs, esq 6
5556514 2521871 2521871 defendant Savell John   813133 813133 Savell, John, of Thornell, Yorks, knight 7
5556515 2521871 2521871 defendant Calverley William   602366 602366 Calverley, William, of Calverley, knight 8
5556516 2521871 2521871 defendant Wentworth Thomas esq 899752 899752 Wentworth, Thomas, of Helmesall, Yorks, esq 9
5556517 2521871 2521871 defendant Gargrave Thomas esq 586731 586731 Gargrave, Thomas, of Wakefeld, Yorks, esq 10
5556518 2521871 2521871 defendant Turton Richard gent 586887 586887 Turton, Richard, of Wakefeld, gent 11
5556519 2521871 2521871 defendant Turton William gent 586887 586887 Turton, William, of Wakefeld, gent 12
5556520 2521871 2521871 defendant Burgh John gent 586887 586887 Burgh, John, of Wakefeld, gent 13
5556521 2521871 2521871 defendant Willughby Henry   899753 899753 Willughby, Henry, of Wollerton, Notts, knight 14
5556522 2521871 2521871 defendant Gardyner John gent 585869 585869 Gardyner, John, of London, gent 15
5556523 2521871 2521871 defendant Cornewaill Thomas   597898 597898 Cornewaill, Thomas, of Burford, Salop, knight 16
5556524 2521871 2521871 defendant Butler Thomas   618734 618734 Butler, Thomas, of Bensey, Lancs, knight 17
5556525 2521871 2521871 defendant Thromarton Christopher esq 899754 899754 Thromarton, Christopher, of Crosselaund, Glos, esq 18
5556526 2521871 2521871 defendant Cornewall Richard esq 899755 899755 Cornewall, Richard, of Bereton, Herefs, esq 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);