names

24 rows where case_id = 2521872

✎ 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
5556527 2521872 2521872 plaintiff Lovell Thomas knight   Lovell, Thomas, knight 0
5556528 2521872 2521872 plaintiff Hobart James knight   Hobart, James, knight 1
5556529 2521872 2521872 plaintiff Empson Richard knight   Empson, Richard, knight 2
5556530 2521872 2521872 plaintiff Lucas Thomas     Lucas, Thomas 3
5556531 2521872 2521872 defendant Layborne Thomas esq 899748 899748 Layborne, Thomas, of Cunyswyk, Westmor, esq 0
5556532 2521872 2521872 defendant Bellyngham Roger   899756 899756 Bellyngham, Roger, of Nurmeshede, Westmor, knight 1
5556533 2521872 2521872 defendant Metcalf James esq 654629 654629 Metcalf, James, of Nappay, Yorks, esq 2
5556534 2521872 2521872 defendant Darell Edward   864982 864982 Darell, Edward, of Lytelcote, Wilts, knight 3
5556535 2521872 2521872 defendant Blount Thomas   899750 899750 Blount, Thomas, of Kenlot, Salop, knight 4
5556536 2521872 2521872 defendant Throgmarton Christopher esq 588814 588814 Throgmarton, Christopher, of Trylley, Glos, esq 5
5556537 2521872 2521872 defendant Blount John esq 723024 723024 Blount, John, of Grendon, Herefs, esq 6
5556538 2521872 2521872 defendant Savell John   813133 813133 Savell, John, of Thornell, Yorks, knight 7
5556539 2521872 2521872 defendant Calverley William   602366 602366 Calverley, William, of Calverley, knight 8
5556540 2521872 2521872 defendant Wentworth Thomas esq 899752 899752 Wentworth, Thomas, of Helmesall, Yorks, esq 9
5556541 2521872 2521872 defendant GargraveThomas of Wakefeld Yorks, esq   GargraveThomas, of Wakefeld, Yorks, esq 10
5556542 2521872 2521872 defendant Turton Richard gent 586887 586887 Turton, Richard, of Wakefeld, gent 11
5556543 2521872 2521872 defendant Turton William gent 586887 586887 Turton, William, of Wakefeld, gent 12
5556544 2521872 2521872 defendant Burgh John gent 586887 586887 Burgh, John, of Wakefeld, gent 13
5556545 2521872 2521872 defendant Willughby Henry   899753 899753 Willughby, Henry, of Wollerton, Notts, knight 14
5556546 2521872 2521872 defendant Gardyner John gent 585869 585869 Gardyner, John, of London, gent 15
5556547 2521872 2521872 defendant Cornewaill Thomas   597898 597898 Cornewaill, Thomas, of Burford, Salop, knight 16
5556548 2521872 2521872 defendant Butler Thomas   618734 618734 Butler, Thomas, of Bensey, Lancs, knight 17
5556549 2521872 2521872 defendant Thromarton Christopher esq 899754 899754 Thromarton, Christopher, of Crosselaund, Glos, esq 18
5556550 2521872 2521872 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);