names

16 rows where place_id = 652538

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3924346 1998451 1998451 defendant Frye John husbandman 652538 652538 Frye, John, of Otterton, Devon, husbandman 0
4011648 2028904 2028904 defendant Hucchyns William gent 652538 652538 Hucchyns, William, of Otterton, Devon, gent 10
4039813 2038854 2038854 defendant Duke Joan widow 652538 652538 Duke, Joan, of Otterton, Devon, widow 0
4039816 2038855 2038855 defendant Sprynte Gregory gent 652538 652538 Sprynte, Gregory, of Otterton, Devon, gent 0
4039818 2038856 2038856 defendant Sprynte Gregory gent 652538 652538 Sprynte, Gregory, of Otterton, Devon, gent 0
4039820 2038857 2038857 defendant Sprynte Gregory gent 652538 652538 Sprynte, Gregory, of Otterton, Devon, gent 0
4092341 2057560 2057560 defendant Atwyll George husbandman 652538 652538 Atwyll, George, of Otterton, Devon, husbandman 0
4104797 2061992 2061992 defendant Wescott Thomas husbandman 652538 652538 Wescott, Thomas, of Otterton, Devon, husbandman 1
4118675 2066973 2066973 defendant Reade Alice widow 652538 652538 Reade, Alice, of Otterton, Devon, widow 1
4136648 2073449 2073449 defendant Atwyll George vintner 652538 652538 Atwyll, George, of Otterton, Devon, vintner 1
4144196 2076129 2076129 defendant Slaughter Andrew yeoman 652538 652538 Slaughter, Andrew, of Otterton, Devon, yeoman 2
4178195 2087846 2087846 defendant Rugge Richard yeoman 652538 652538 Rugge, Richard, of Otterton, Devon, yeoman 1
4205091 2097328 2097328 defendant Atwill George yeoman 652538 652538 Atwill, George, of Otterton, Devon, yeoman 0
4209672 2098935 2098935 defendant Sprynte Gregory esq 652538 652538 Sprynte, Gregory, of Otterton, Devon, esq 0
4330017 2140343 2140343 defendant Wychehalse Thomas yeoman 652538 652538 Wychehalse, Thomas, of Otterton, Devon, yeoman 0
4408252 2167329 2167329 defendant Bagbeare Lewis gent 652538 652538 Bagbeare, Lewis, of Otterton, Devon, gent 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);