names

26 rows where place_id = 620322

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3735008 1937185 1937185 defendant Mordocke Robert husbandman 620322 620322 Mordocke, Robert, of Laystofte, husbandman 1
3751816 1942488 1942488 defendant Mordok Robert (legal representative) 620322 620322 Mordok, Robert, of Laystofte, yeoman, executrix of 0
3751821 1942488 1942488 defendant Everard John fisherman 620322 620322 Everard, John, of Laystofte, fisherman 5
3947804 2006294 2006294 defendant Mayes Thomas shoemaker 620322 620322 Mayes, Thomas, of Laystofte, shoemaker 1
3947805 2006294 2006294 defendant Branson William laborer 620322 620322 Branson, William, of Laystofte, laborer 2
3952359 2007896 2007896 defendant Godderd John merchant 620322 620322 Godderd, John, of Laystofte, merchant 0
3959915 2010563 2010563 defendant Cocke Robert butcher 620322 620322 Cocke, Robert, of Laystofte, butcher 0
3967095 2013116 2013116 defendant Rawdye John butcher 620322 620322 Rawdye, John, of Laystofte, butcher 3
3985674 2019638 2019638 defendant Neslinge Nicholas butcher 620322 620322 Neslinge, Nicholas, of Laystofte, butcher 1
3995482 2023129 2023129 defendant Grudgefeld John merchant 620322 620322 Grudgefeld, John, of Laystofte, merchant 0
4023074 2032970 2032970 plaintiff Bamford William mercer 620322 620322 Bamford, William, of Laystofte, mercer 0
4056979 2044878 2044878 defendant Woodruff Thomas yeoman 620322 620322 Woodruff, Thomas, of Laystofte, yeoman 0
4056982 2044879 2044879 defendant Woodruff Thomas yeoman 620322 620322 Woodruff, Thomas, of Laystofte, yeoman 0
4107962 2063121 2063121 defendant Davy Richard chandler or "raffeman" 620322 620322 Davy, Richard, of Laystofte, chandler or "raffeman" 0
4110895 2064150 2064150 defendant Yongman Elizabeth   620322 620322 Yongman, Elizabeth, of Laystofte, widow, sisters of John Clarke 3
4125228 2069309 2069309 defendant Branche John tailor 620322 620322 Branche, John, of Laystofte, tailor 1
4140483 2074839 2074839 defendant Wels William   620322 620322 Wels, William, of Laystofte, Suff, sailor 0
4212405 2099887 2099887 defendant Adryd or Oldryd Robert yeoman 620322 620322 Adryd or Oldryd, Robert, of Laystofte, yeoman 2
4212461 2099906 2099906 defendant Shardloe Stephen baker 620322 620322 Shardloe, Stephen, of Laystofte, baker 0
4212463 2099907 2099907 defendant Shardloe Stephen baker 620322 620322 Shardloe, Stephen, of Laystofte, baker 0
4212464 2099907 2099907 defendant Yongman John husbandman 620322 620322 Yongman, John, of Laystofte, husbandman 1
4241082 2110003 2110003 defendant Ryve John   620322 620322 Ryve, John, of Laystofte, linen draper 1
4245519 2111476 2111476 defendant Charnell William fisherman 620322 620322 Charnell, William, of Laystofte, fisherman 0
4261117 2116688 2116688 defendant Cawdwell William   620322 620322 Cawdwell, William, of Laystofte merchant 0
4337962 2143021 2143021 defendant Doe George gent 620322 620322 Doe, George, of Laystofte, or of Catfeild, Norf, gent 0
4407028 2166907 2166907 defendant Welhowse John yeoman 620322 620322 Welhowse, John, of Laystofte, yeoman 1

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);