names

20 rows where case_id = 2515665

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5535595 2515665 2515665 plaintiff Bray Reginald knight   Bray, Reginald, knight 0
5535596 2515665 2515665 plaintiff Hobart James     Hobart, James 1
5535597 2515665 2515665 plaintiff Empson Richard     Empson, Richard 2
5535598 2515665 2515665 plaintiff Lucas Thomas     Lucas, Thomas 3
5535599 2515665 2515665 defendant Chaloner John gent 585869 585869 Chaloner, John, of London, gent 0
5535600 2515665 2515665 defendant Gargrave William gent 585869 585869 Gargrave, William, of London, gent 1
5535601 2515665 2515665 defendant Clyfford Henry Lord Clyfford, of London, knight   Clyfford, Henry, Lord Clyfford, of London, knight 2
5535602 2515665 2515665 defendant Eltoftes Christopher gent 897416 897416 Eltoftes, Christopher, of Fornall, Yorks, gent 3
5535603 2515665 2515665 defendant Popeley Henry gent 897417 897417 Popeley, Henry, of Hamelthorp, Yorks, gent 4
5535604 2515665 2515665 defendant Chewe Richard gent 897418 897418 Chewe, Richard, of Staunford, Yorks, gent 5
5535605 2515665 2515665 defendant Tyrell James   618885 618885 Tyrell, James, of Gyppyng, Suff, knight 6
5535606 2515665 2515665 defendant Calthorp Philip   585869 585869 Calthorp, Philip, of London, knight 7
5535607 2515665 2515665 defendant Wentworth Richard esq 585869 585869 Wentworth, Richard, of London, esq 8
5535608 2515665 2515665 defendant Clopton William esq 585869 585869 Clopton, William, of London, esq 9
5535609 2515665 2515665 defendant Russhe Thomas gent 594354 594354 Russhe, Thomas, of Orford, Suff, gent 10
5535610 2515665 2515665 defendant Bohun John gent 897419 897419 Bohun, John, of Russemer, Suff, gent 11
5535611 2515665 2515665 defendant Dacre Thomas Lord Dacres, knight   Dacre, Thomas, Lord Dacres, knight 12
5535612 2515665 2515665 defendant Strykland Walter gent 585869 585869 Strykland, Walter, of London, gent 13
5535613 2515665 2515665 defendant Lee John gent 809450 809450 Lee, John, of Isale, Cumber, gent 14
5535614 2515665 2515665 defendant Musgrave Gilbert gent 674025 674025 Musgrave, Gilbert, of Crokedale, Cumber, gent 15

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