names

16 rows where case_id = 1941672

✎ 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
3749177 1941672 1941672 plaintiff Hewes Thomas     Hewes, Thomas 0
3749178 1941672 1941672 defendant Lewes Edward laborer 622835 622835 Lewes, Edward, of Newmyll, laborer 0
3749179 1941672 1941672 defendant Cristofer William husbandman 622836 622836 Cristofer, William, of Trethrife, husbandman 1
3749180 1941672 1941672 defendant Genyberyn Richard husbandman 606006 606006 Genyberyn, Richard, of St Tenyder, husbandman 2
3749181 1941672 1941672 defendant Maiblean John husbandman 622838 622838 Maiblean, John, of Burthey, husbandman 3
3749182 1941672 1941672 defendant Norrey Richard husbandman 622839 622839 Norrey, Richard, of St Brede, husbandman 4
3749183 1941672 1941672 defendant Swete Ralph Davy husbandman 622840 622840 Swete, Ralph Davy, of Trendell, husbandman 5
3749184 1941672 1941672 defendant Swete James Davy husbandman 622840 622840 Swete, James Davy, of Trendell, husbandman 6
3749185 1941672 1941672 defendant Harrye Thomas Jenkyn husbandman 622841 622841 Harrye, Thomas Jenkyn, of Nansouthe, husbandman 7
3749186 1941672 1941672 defendant Gillygonel Richard husbandman 622842 622842 Gillygonel, Richard, of Trethirfe, husbandman 8
3749187 1941672 1941672 defendant Breton Oliver husbandman 622842 622842 Breton, Oliver, of Trethirfe, husbandman 9
3749188 1941672 1941672 defendant Manne Pastas laborer 622842 622842 Manne, Pastas, of Trethirfe, laborer 10
3749189 1941672 1941672 defendant Pascowe John husbandman 622843 622843 Pascowe, John, of Forgewe, husbandman 11
3749190 1941672 1941672 defendant Nycholas Thomas husbandman 622843 622843 Nycholas, Thomas, of Forgewe, husbandman 12
3749191 1941672 1941672 defendant Mayowe John husbandman 595682 595682 Mayowe, John, of St Probus, husbandman 13
3749192 1941672 1941672 defendant Ronell John husbandman 622844 622844 Ronell, John, of Helgoose, husbandman 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);