names

14 rows where case_id = 2276720

✎ 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
4737058 2276720 2276720 plaintiff Treveswethen John     Treveswethen, John 0
4737059 2276720 2276720 defendant Pennans Walter yeoman 790469 790469 Pennans, Walter, of Pennans, yeoman 0
4737060 2276720 2276720 defendant Greher John tailor 602867 602867 Greher, John, of St Kenwyn, tailor 1
4737061 2276720 2276720 defendant Menethdewe Drew laborer 793713 793713 Menethdewe, Drew, of Hyrnans, laborer 2
4737062 2276720 2276720 defendant Trevelen Lawrence husbandman 793714 793714 together with Trevelen, Lawrence, of Trevelen, husbandman 3
4737063 2276720 2276720 defendant Killehellan Mary formerly wife of James Killehellan, of Trevranowe, widow   Killehellan, Mary, formerly wife of James Killehellan, of Trevranowe, widow 4
4737064 2276720 2276720 defendant Pennans Richard gent 790469 790469 Pennans, Richard, of Pennans, gent 5
4737065 2276720 2276720 defendant Hurnans Andrew yeoman 793713 793713 Hurnans, Andrew, of Hyrnans, yeoman 6
4737066 2276720 2276720 defendant Lobba Martin tailor 793715 793715 Lobba, Martin, of Egglesureke, tailor 7
4737067 2276720 2276720 defendant Hanosowe John husbandman 793706 793706 Hanosowe, John, of Hanosowe, husbandman 8
4737068 2276720 2276720 defendant Menk Nicholas husbandman 789694 789694 Menk, Nicholas, of Menke, husbandman 9
4737069 2276720 2276720 defendant Menke Richard   789694 789694 Menke, Richard, of Menke, groom 10
4737070 2276720 2276720 defendant Felypp John husbandman 793708 793708 Felypp, John, of Trenerth, husbandman 11
4737071 2276720 2276720 defendant Menke Drew tinner 789694 789694 Menke, Drew, of Menke, tinner 12

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