names

16 rows where place_id = 596619

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3625524 1875521 1875521 defendant Trenhale Richard tinner 596619 596619 Trenhale, Richard, of Redruthe, tinner 3
3714260 1930757 1930757 defendant Robert John tinner 596619 596619 Robert, John, of Redruthe, tinner 0
3754614 1943401 1943401 defendant Trehare alias Richard Udy tailor 596619 596619 Trehare alias Richard, Udy, of Redruthe, tailor 2
3759319 1944905 1944905 defendant Hervy John husbandman 596619 596619 Hervy, John, of Redruthe, husbandman 0
3764915 1946692 1946692 defendant Treowyth John husbandman 596619 596619 Treowyth, John, of Redruthe, husbandman 0
3764919 1946692 1946692 defendant Smythe Nicholas smith 596619 596619 Smythe, Nicholas, of Redruthe, smith 4
3764920 1946692 1946692 defendant Roger William husbandman 596619 596619 Roger, William, of Redruthe, husbandman 5
3838483 1969960 1969960 defendant Jackealyn John Hamly tinner 596619 596619 Jackealyn, John Hamly, of Redruthe, tinner 0
3849335 1973390 1973390 defendant Wattys Humphrey husbandman 596619 596619 Wattys, Humphrey, of Redruthe, husbandman 0
3854696 1975115 1975115 defendant Jakealyn John Hanley tinner 596619 596619 Jakealyn, John Hanley, of Redruthe, tinner 0
3866208 1978926 1978926 defendant Andrew John husbandman 596619 596619 Andrew, John, of Redruthe, husbandman 0
3866213 1978927 1978927 defendant Watte Ramfry John husbandman 596619 596619 Watte, Ramfry John, of Redruthe, husbandman 0
3866214 1978927 1978927 defendant Fore Thomas husbandman 596619 596619 Fore, Thomas, of Redruthe, husbandman 1
3965762 2012641 2012641 defendant Remfre Henry tinner 596619 596619 Remfre, Henry, of Redruthe, tinner 5
3982957 2018684 2018684 defendant Polkynhorne Richard gent 596619 596619 Polkynhorne, Richard, of Redruthe, gent 0
5570738 2526001 2526001 defendant Jenkyn Reginald tailor 596619 596619 Jenkyn, Reginald, of Redruthe, tailor 0

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