names

15 rows where case_id = 2013386

✎ 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
3967847 2013386 2013386 plaintiff Calverley Edward   600449 600449 Calverley, Edward, of Boston, Lincs, administrators of 0
3967848 2013386 2013386 plaintiff Kyme Anthony gent   (Kyme, Anthony, gent 1
3967849 2013386 2013386 plaintiff Kyme Elizabeth widow of Edward   Elizabeth his wife, widow of Edward 2
3967850 2013386 2013386 defendant Howse Jenette formerly Joan Prydgyan   Howse, Jenette, formerly Joan Prydgyan, executrix of George House, executor of 0
3967851 2013386 2013386 defendant Prydgyan Henry yeoman 621036 621036 Prydgyan, Henry, of Swynshed, Lincs, yeoman 1
3967852 2013386 2013386 defendant Foster Nicholas (legal representative) 606750 606750 Foster, Nicholas, of Holbyche, executors of 2
3967853 2013386 2013386 defendant Foster Gilbert yeoman 655665 655665 (Foster, Gilbert, of Holbyche, Lincs, yeoman 3
3967854 2013386 2013386 defendant Stowe William husbandman 606750 606750 Stowe, William, of Holbyche, husbandman 4
3967855 2013386 2013386 defendant Deathe John yeoman 658572 658572 Deathe, John, of Gosbertowne, Lincs, yeoman 5
3967856 2013386 2013386 defendant Lymme Thomas yeoman 663185 663185 Lymme, Thomas, of Leverton, Lincs, yeoman 6
3967857 2013386 2013386 defendant Burnett William yeoman 606750 606750 Burnett, William, of Holbyche, yeoman 7
3967858 2013386 2013386 defendant Crompe William yeoman 606750 606750 Crompe, William, of Holbyche, yeoman 8
3967859 2013386 2013386 defendant Myddelton William husbandman 663186 663186 Myddelton, William, of Swayton, Lincs, husbandman 9
3967860 2013386 2013386 defendant Gyll Thomas   638957 638957 Gyll, Thomas, of Borne, Lincs 10
3967861 2013386 2013386 defendant Thomas Edward husbandman 603017 603017 Thomas, Edward, of Flete, Lincs, husbandman 11

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