names

17 rows where case_id = 2276722

✎ 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
4737077 2276722 2276722 plaintiff Treveswethen John     Treveswethen, John 0
4737078 2276722 2276722 defendant Trevelen Lawrence husbandman 793714 793714 Trevelen, Lawrence, of Trevelen, husbandman 0
4737079 2276722 2276722 defendant Kellehellan Mary   793717 793717 Kellehellan, Mary, of Treuranewe, widow, formerly wife of James 1
4737080 2276722 2276722 defendant Pennans Richard gent 790469 790469 Pennans, Richard, of Pennans, gent 2
4737081 2276722 2276722 defendant Hyrnans Andrew yeoman 793713 793713 together with Hyrnans, Andrew, of Hyrnans, yeoman 3
4737082 2276722 2276722 defendant Lobba Mark tailor 793705 793705 Lobba, Mark, of Egglosureke, tailor 4
4737083 2276722 2276722 defendant Hanosewe John husbandman 793718 793718 Hanosewe, John, of Hanosewe, husbandman 5
4737084 2276722 2276722 defendant Menke Nicholas husbandman 789694 789694 Menke, Nicholas, of Menke, husbandman 6
4737085 2276722 2276722 defendant Menke Richard   789694 789694 Menke, Richard, of Menke, groom 7
4737086 2276722 2276722 defendant Felypp John husbandman 793708 793708 Felypp, John, of Trenerth, husbandman 8
4737087 2276722 2276722 defendant Pennans William yeoman 790469 790469 Pennans, William, of Pennans, yeoman 9
4737088 2276722 2276722 defendant Monke Drew tinner 620497 620497 Monke, Drew, of Monke, tinner 10
4737089 2276722 2276722 defendant Treger John tailor 602867 602867 Treger, John, of St Kenwyn, tailor 11
4737090 2276722 2276722 defendant Menethdowe Drew laborer 793713 793713 Menethdowe, Drew, of Hyrnans, laborer 12
4737091 2276722 2276722 defendant Hyrvans Andrew yeoman 793720 793720 together with Hyrvans, Andrew, of Hyurvans, yeoman 13
4737092 2276722 2276722 defendant Bone William yeoman 607496 607496 Bone, William, of Helston Burgh, yeoman 14
4737093 2276722 2276722 defendant Pennans Walter yeoman 790469 790469 Pennans, Walter, of Pennans, yeoman 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);