names

13 rows where case_id = 2471893

✎ 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
5388915 2471893 2471893 plaintiff Hert William     Hert, William, on his own account 0
5388916 2471893 2471893 defendant Bardefeld John, senior fuller 880723 880723 Bardefeld, John, senior, of Colchester Hythe, fuller 0
5388917 2471893 2471893 defendant Bouke John husbandman 881779 881779 Bouke, John, of Byrcheanger, husbandman 1
5388918 2471893 2471893 defendant Herd John husbandman 591820 591820 Herd, John, of Harlowe, husbandman 2
5388919 2471893 2471893 defendant White John clothier 881780 881780 White, John, of Great Belfeld, clothier 3
5388920 2471893 2471893 defendant Elyot Robert yeoman 881781 881781 Elyot, Robert, of Great Cokfeld, yeoman 4
5388921 2471893 2471893 defendant Bode William carrier 881781 881781 Bode, William, of Great Cokfeld, carrier 5
5388922 2471893 2471893 defendant Smyth William husbandman   Smyth, William, husbandman 6
5388923 2471893 2471893 defendant Inewe Thomas chapman 753386 753386 Inewe, Thomas, of Branketre, chapman 7
5388924 2471893 2471893 defendant Symond Richard skinner   Symond, Richard, skinner 8
5388925 2471893 2471893 defendant Hervy John butcher 593169 593169 Hervy, John, of Haveryng at Boure, butcher 9
5388926 2471893 2471893 defendant Pert William gent 591721 591721 Pert, William, of Alvetheley, gent 10
5388927 2471893 2471893 defendant Ketylton William   586724 586724 Ketylton, William, of Waltham 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);