names

22 rows where place_id = 638308

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3841794 1971016 1971016 defendant Jackwilliam Roger merchant 638308 638308 Jackwilliam, Roger, of St Agnes, merchant 2
3872758 1981103 1981103 defendant Jekwilliam Roger merchant 638308 638308 Jekwilliam, Roger, of St Agnes, merchant 2
3890905 1987221 1987221 defendant Reynold John husbandman 638308 638308 Reynold, John, of St Agnes, husbandman 6
3890906 1987221 1987221 defendant Trevissa Richard husbandman 638308 638308 Trevissa, Richard, of St Agnes, husbandman 7
3890907 1987221 1987221 defendant Brytten Christopher husbandman 638308 638308 Brytten, Christopher, of St Agnes, husbandman 8
3890908 1987221 1987221 defendant Brytten Vincent husbandman 638308 638308 Brytten, Vincent, of St Agnes, husbandman 9
3893420 1988030 1988030 defendant Stephyn Paul husbandman 638308 638308 Stephyn, Paul, of St Agnes, husbandman 0
3893421 1988030 1988030 defendant Nowall John husbandman 638308 638308 Nowall, John, of St Agnes, husbandman 1
3893422 1988030 1988030 defendant Nowall Thomas husbandman 638308 638308 Nowall, Thomas, of St Agnes, husbandman 2
3893423 1988030 1988030 defendant Nowall Richard husbandman 638308 638308 Nowall, Richard, of St Agnes, husbandman 3
3924488 1998504 1998504 defendant Chyton Nicholas yeoman 638308 638308 Chyton, Nicholas, of St Agnes, yeoman 1
3960141 2010651 2010651 defendant Beauechamp alias Chyton Nicholas gent 638308 638308 Beauechamp alias Chyton, Nicholas, of St Agnes, gent 0
3960142 2010651 2010651 defendant Beauchamp alias Chyton Roger yeoman 638308 638308 Beauchamp alias Chyton, Roger, of St Agnes, yeoman 1
3962624 2011517 2011517 defendant Webbe Richard husbandman 638308 638308 Webbe, Richard, of St Agnes, husbandman 8
3962625 2011517 2011517 defendant Webbe Jenet spinster 638308 638308 Webbe, Jenet, of St Agnes, spinster 9
3962626 2011517 2011517 defendant Webbe Katherine spinster 638308 638308 Webbe, Katherine, of St Agnes, spinster 10
3969300 2013866 2013866 defendant Beachamppe Roger gent 638308 638308 Beachamppe, Roger, of St Agnes, or of Chyton, gent 0
3969301 2013866 2013866 defendant Nore Richard tinner or yeoman 638308 638308 Nore, Richard, of St Agnes, tinner or yeoman 1
4119832 2067382 2067382 defendant Lannyn John gent 638308 638308 Lannyn, John, of St Agnes, gent 0
4122991 2068520 2068520 defendant Cottye Robert yeoman 638308 638308 Cottye, Robert, of St Agnes, yeoman 0
4157415 2080665 2080665 defendant Foxe William yeoman 638308 638308 Foxe, William, of St Agnes, yeoman 0
4168693 2084538 2084538 defendant Palpera Paul husbandman 638308 638308 Palpera, Paul, of St Agnes, husbandman 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);