names

18 rows where case_id = 2016418

✎ 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
3976685 2016418 2016418 plaintiff Kyme William gent   Kyme, William, gent 0
3976686 2016418 2016418 defendant Pylocke William yeoman 586286 586286 Pylocke, William, of Boston, yeoman 0
3976687 2016418 2016418 defendant Gyrlyngton Nicholas esq 665383 665383 Gyrlyngton, Nicholas, of Frothingham, Lincs, esq 1
3976688 2016418 2016418 defendant Gobert Peter hosier 585869 585869 Gobert, Peter, of London, hosier 2
3976689 2016418 2016418 defendant Hynde Thomas clothworker 585869 585869 Hynde, Thomas, of London, clothworker 3
3976690 2016418 2016418 defendant Coke Richard grocer 585869 585869 Coke, Richard, of London, grocer 4
3976691 2016418 2016418 defendant Plane John gent 585869 585869 Plane, John, of London, gent 5
3976692 2016418 2016418 defendant Coser John   585869 585869 Coser, John, of London, gent, servant of Lord Pembroke 6
3976693 2016418 2016418 defendant Cornewallys William   585869 585869 Cornewallys, William, of London, gent, servant of Henry Sydney, knight 7
3976694 2016418 2016418 defendant Mychell Edward clerk 665386 665386 Mychell, Edward, of Baynton, Northumb, clerk 8
3976695 2016418 2016418 defendant Wake Thomas esq 665387 665387 Wake, Thomas, of Bytham, Lincs, esq 9
3976696 2016418 2016418 defendant Rocke Thomas yeoman 586134 586134 Rocke, Thomas, of Ipswich, yeoman 10
3976697 2016418 2016418 defendant Langley Ralph gent 644638 644638 Langley, Ralph, of Rotheley, Leics, gent 11
3976698 2016418 2016418 defendant Sandon William exq   Sandon, William, exq, executors of 12
3976699 2016418 2016418 defendant Meares Lawrence esq 617865 617865 (Meares, Lawrence, of Assheby, Lincs, esq 13
3976700 2016418 2016418 defendant Craycroft Richard esq 665388 665388 Craycroft, Richard, of Hogesthorp, Lincs, esq 14
3976701 2016418 2016418 defendant Skipwyth John (legal representative) 614280 614280 Skipwyth, John, of Utterby, esq, executrix of 15
3976702 2016418 2016418 defendant Skipwyth Eleanor widow 611836 611836 Skipwyth, Eleanor, of Utterby, Lincs, widow 16

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