names

30 rows where place_id = 641833

✎ 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
3864146 1978195 1978195 defendant Hyllyng William merchant 641833 641833 Hyllyng, William, of Northam, Devon, merchant 0
3955580 2009021 2009021 defendant Hache Thomas gent 641833 641833 Hache, Thomas, of Northam, Devon, gent 0
4011590 2028896 2028896 defendant Bery Christopher gent 641833 641833 Bery, Christopher, of Northam, Devon, gent 1
4011598 2028897 2028897 defendant Blackemore Margery widow 641833 641833 Blackemore, Margery, of Northam, Devon, widow 3
4027396 2034445 2034445 defendant Brawnton John husbandman 641833 641833 Brawnton, John, of Northam, Devon, husbandman 1
4088851 2056313 2056313 defendant Colemore Thomas yeoman 641833 641833 Colemore, Thomas, of Northam, Devon, yeoman, son of Thomas Colemore, of Northam, yeoman 0
4088855 2056314 2056314 defendant Colemore Thomas yeoman 641833 641833 Colemore, Thomas, of Northam, Devon, yeoman, son of Thomas Colemore, of Northam, yeoman 0
4122214 2068249 2068249 defendant Burgh Anne widow 641833 641833 Burgh, Anne, of Northam, Devon, widow 1
4182956 2089519 2089519 defendant Phillippes alias Philpe Thomas   641833 641833 Phillippes alias Philpe, Thomas, of Northam, Devon, shipwright 0
4199857 2095500 2095500 defendant Frenche William (legal representative) 641833 641833 Frenche, William, of Northam, Devon, ship master, administrator of 0
4252282 2113756 2113756 defendant Fortescue Faithful gent 641833 641833 Fortescue, Faithful, of Northam, Devon, gent 0
4331325 2140774 2140774 defendant Fortescue Faith gent 641833 641833 Fortescue, Faith, of Northam, Devon, gent 0
4396427 2163380 2163380 defendant Sampson Richard carpenter 641833 641833 Sampson, Richard, of Northam, Devon, carpenter 0
4668370 2255819 2255819 defendant Puddyng John chaplain & son of Henry Puddyng 641833 641833 Puddyng, John, of Northam, Devon, chaplain & son of Henry Puddyng 0
4849163 2311214 2311214 defendant Cradok Richard merchant 641833 641833 Cradok, Richard, of Northam, Devon, merchant 0
4886432 2322616 2322616 defendant Podyngton Robert husbandman 641833 641833 Podyngton, Robert, of Northam, Devon, husbandman 1
4901958 2327216 2327216 defendant Podyngton Robert husbandman 641833 641833 Podyngton, Robert, of Northam, Devon, husbandman 1
4914241 2330969 2330969 defendant Dodecote John tailor 641833 641833 Dodecote, John, of Northam, Devon, tailor 0
4920741 2333002 2333002 defendant Wheston Walter husbandman 641833 641833 Wheston, Walter, of Northam, Devon, husbandman 2
4924217 2334019 2334019 defendant Port John merchant 641833 641833 Port, John, of Northam, Devon, merchant 2
4937588 2338132 2338132 defendant Craddok Richard merchant 641833 641833 Craddok, Richard, of Northam, Devon, merchant 0
4949514 2341844 2341844 defendant Dytamay Richard merchant 641833 641833 Dytamay, Richard, of Northam, Devon, merchant 0
4977200 2350139 2350139 defendant Craddok Richard merchant 641833 641833 Craddok, Richard, of Northam, Devon, merchant 0
4977205 2350140 2350140 defendant Craddok Richard merchant 641833 641833 Craddok, Richard, of Northam, Devon, merchant 0
4984232 2352215 2352215 defendant Craddok Richard merchant 641833 641833 Craddok, Richard, of Northam, Devon, merchant 4
4984238 2352216 2352216 defendant Craddok Richard merchant 641833 641833 Craddok, Richard, of Northam, Devon, merchant 4
5267639 2435637 2435637 defendant Wooford alias Overd or Onerd John merchant or husbandman 641833 641833 Wooford alias Overd or Onerd, John, of Northam, Devon, merchant or husbandman 1
5267642 2435638 2435638 defendant Wooford alias Overd or Onerd John merchant or husbandman 641833 641833 Wooford alias Overd or Onerd, John, of Northam, Devon, merchant or husbandman 1
5285320 2440727 2440727 defendant Phelip Denis merchant 641833 641833 Phelip, Denis, of Northam, Devon, merchant 0
5541828 2517557 2517557 defendant Wolston John merchant 641833 641833 Wolston, John, of Northam, Devon, merchant 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);