names

16 rows where case_id = 2026853

✎ 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
4005812 2026853 2026853 plaintiff Lakyn Miles gent, of Ardley, Essex, attorney of the bench   Lakyn, Miles, gent, of Ardley, Essex, attorney of the bench 0
4005813 2026853 2026853 defendant Rolt Richard   676236 676236 Rolt, Richard, of Earls Colne, Essex, pale maker 0
4005814 2026853 2026853 defendant Sygg Richard butcher 591323 591323 Sygg, Richard, of Earls Colne, butcher 1
4005815 2026853 2026853 defendant Catt William husbandman 591323 591323 Catt, William, of Earls Colne, husbandman 2
4005816 2026853 2026853 defendant Polly Adam yeoman 591323 591323 Polly, Adam, of Earls Colne, yeoman 3
4005817 2026853 2026853 defendant Beryff William gent 608033 608033 Beryff, William, of Aldham, Essex, gent 4
4005818 2026853 2026853 defendant Gylbert Jerome gent 586470 586470 Gylbert, Jerome, of Colchester, gent 5
4005819 2026853 2026853 defendant Franke John yeoman 627115 627115 Franke, John, of Danbury, Essex, yeoman 6
4005820 2026853 2026853 defendant Malle Thomas clothier 671389 671389 Malle, Thomas, of Thorpe, Essex, clothier 7
4005821 2026853 2026853 defendant Meawtys Henry esq 586347 586347 Meawtys, Henry, of West Ham, Essex, esq 8
4005822 2026853 2026853 defendant Peers William yeoman 672476 672476 Peers, William, of Chawreth, Essex, yeoman 9
4005823 2026853 2026853 defendant Ryvett John yeoman 672477 672477 Ryvett, John, of Parva Ocley, Essex, yeoman 10
4005824 2026853 2026853 defendant Smyth John yeoman 659908 659908 Smyth, John, of Reddeswell, Essex, yeoman 11
4005825 2026853 2026853 defendant Wylsmer James yeoman 654095 654095 Wylsmer, James, of Thunderley, Essex, yeoman 12
4005826 2026853 2026853 defendant Jenkyn Richard draper 586470 586470 Jenkyn, Richard, of Colchester, draper 13
4005827 2026853 2026853 defendant Clarke Adam gent 586470 586470 Clarke, Adam, of Colchester, gent 14

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