names

20 rows where case_id = 2515666

✎ 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
5535615 2515666 2515666 plaintiff Bray Reginald knight   Bray, Reginald, knight 0
5535616 2515666 2515666 plaintiff Hobart James     Hobart, James 1
5535617 2515666 2515666 plaintiff Emson Richard     Emson, Richard 2
5535618 2515666 2515666 plaintiff Lucas Thomas     Lucas, Thomas 3
5535619 2515666 2515666 defendant Chaloner John gent 585869 585869 Chaloner, John, of London, gent 0
5535620 2515666 2515666 defendant Gargrave William gent 585869 585869 Gargrave, William, of London, gent 1
5535621 2515666 2515666 defendant Clyfford Henry Lord Clyfford, of London, knight   Clyfford, Henry, Lord Clyfford, of London, knight 2
5535622 2515666 2515666 defendant Eltoftes Christopher gent 897416 897416 Eltoftes, Christopher, of Fornall, Yorks, gent 3
5535623 2515666 2515666 defendant Popeley Henry gent 897417 897417 Popeley, Henry, of Hamelthorp, Yorks, gent 4
5535624 2515666 2515666 defendant Chewe Richard gent 897418 897418 Chewe, Richard, of Staunford, Yorks, gent 5
5535625 2515666 2515666 defendant Tyrell James   618885 618885 Tyrell, James, of Gyppyng, Suff, knight 6
5535626 2515666 2515666 defendant Calthorp Philip   585869 585869 Calthorp, Philip, of London, knight 7
5535627 2515666 2515666 defendant Wentworth Richard esq 585869 585869 Wentworth, Richard, of London, esq 8
5535628 2515666 2515666 defendant Clopton William esq 585869 585869 Clopton, William, of London, esq 9
5535629 2515666 2515666 defendant Russhe Thomas gent 594354 594354 Russhe, Thomas, of Orford, Suff, gent 10
5535630 2515666 2515666 defendant Bohun John gent 897419 897419 Bohun, John, of Russemer, Suff, gent 11
5535631 2515666 2515666 defendant Dacre Thomas Lord Dacres, knight   Dacre, Thomas, Lord Dacres, knight 12
5535632 2515666 2515666 defendant Strykland Walter gent 585869 585869 Strykland, Walter, of London, gent 13
5535633 2515666 2515666 defendant Lee John gent 809450 809450 Lee, John, of Isale, Cumber, gent 14
5535634 2515666 2515666 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);