names

19 rows where place_id = 666271

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3980372 2017749 2017749 defendant Goughe William husbandman 666271 666271 Goughe, William, of Allensmore, husbandman 3
3990347 2021301 2021301 defendant Prytfote John yeoman 666271 666271 Prytfote, John, of Allensmore, yeoman 2
4071237 2050018 2050018 defendant Peryn Thomas husbandman 666271 666271 Peryn, Thomas, of Allensmore, husbandman 0
4071238 2050018 2050018 defendant Wellyngton Thomas husbandman 666271 666271 Wellyngton, Thomas, of Allensmore, husbandman 1
4071239 2050018 2050018 defendant Gwellowe John laborer 666271 666271 together with Gwellowe, John, of Allensmore, laborer 2
4071257 2050026 2050026 defendant Gynon or Eynon Triamore yeoman 666271 666271 Gynon or Eynon, Triamore, of Allensmore, yeoman 0
4071258 2050026 2050026 defendant Whitcombe Walter husbandman 666271 666271 Whitcombe, Walter, of Allensmore, husbandman 1
4150367 2078260 2078260 defendant Wendland John yeoman 666271 666271 Wendland, John, of Allensmore, yeoman 1
4180988 2088829 2088829 defendant Cathemey or Catchemaye Henry, junior gent 666271 666271 Cathemey or Catchemaye, Henry, junior, of Allensmore, gent 0
4180989 2088829 2088829 defendant Catchemaye Henry yeoman 666271 666271 Catchemaye, Henry, of Allensmore, yeoman 1
4188207 2091379 2091379 defendant Catchemaye Henry gent 666271 666271 Catchemaye, Henry, of Allensmore, gent 0
4201364 2096029 2096029 defendant Wynhall John yeoman 666271 666271 Wynhall, John, of Allensmore, yeoman 4
4221405 2102984 2102984 defendant Beale John yeoman 666271 666271 Beale, John, of Allensmore, yeoman 2
4230107 2106019 2106019 defendant Beale John yeoman 666271 666271 Beale, John, of Allensmore, yeoman 2
4292860 2127510 2127510 defendant Smyth Henry yeoman 666271 666271 Smyth, Henry, of Allensmore, yeoman 2
4380069 2157975 2157975 defendant Wynnall John yeoman 666271 666271 Wynnall, John, of Allensmore, yeoman 1
4381492 2158486 2158486 defendant Price Richard yeoman 666271 666271 Price, Richard, of Allensmore, yeoman 0
4386152 2160050 2160050 defendant Symond Thomas yeoman 666271 666271 Symond, Thomas, of Allensmore, yeoman 0
4386157 2160051 2160051 defendant Simond Thomas yeoman 666271 666271 Simond, Thomas, of Allensmore, yeoman 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);