names

47 rows where place_id = 590485

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601368 1868091 1868091 defendant Halys John yeoman 590485 590485 Halys, John, of Hoveton St John, yeoman 0
3672695 1917463 1917463 defendant Rose John   590485 590485 Rose, John, of Hoveton St John, worsted weaver 0
3672696 1917463 1917463 defendant Balle William   590485 590485 Balle, William, of Hoveton St John, worsted weaver 1
3672697 1917463 1917463 defendant Hynde Robert   590485 590485 Hynde, Robert, of Hoveton St John, worsted weaver 2
3672737 1917479 1917479 defendant Becker Thomas butcher 590485 590485 Becker, Thomas, of Hoveton St John, butcher 1
3672738 1917479 1917479 defendant Baker John butcher 590485 590485 Baker, John, of Hoveton St John, butcher 2
3725993 1934403 1934403 defendant Rose John   590485 590485 Rose, John, of Hoveton St John, worsted weaver 0
3868741 1979784 1979784 defendant Bekker John butcher 590485 590485 Bekker, John, of Hoveton St John, butcher 3
3927669 1999591 1999591 defendant Doughty John yeoman 590485 590485 Doughty, John, of Hoveton St John, yeoman 1
3963423 2011811 2011811 plaintiff Wynter Erasmus gent 590485 590485 Wynter, Erasmus, of Hoveton St John, gent 0
3987463 2020262 2020262 defendant Foxe Thomas tailor 590485 590485 Foxe, Thomas, of Hoveton St John, tailor 0
3987465 2020263 2020263 defendant Foxe Thomas tailor 590485 590485 Foxe, Thomas, of Hoveton St John, tailor 0
3987467 2020264 2020264 defendant Foxe Thomas tailor 590485 590485 Foxe, Thomas, of Hoveton St John, tailor 0
3987469 2020265 2020265 defendant Foxe Thomas tailor 590485 590485 Foxe, Thomas, of Hoveton St John, tailor 0
4069502 2049372 2049372 defendant Gybbes Edmund husbandman 590485 590485 Gybbes, Edmund, of Hoveton St John, husbandman 0
4084948 2054895 2054895 defendant Palmer Robert gent 590485 590485 Palmer, Robert, of Hoveton St John, gent 0
4085727 2055167 2055167 defendant Wynter Erasmus husbandman 590485 590485 Wynter, Erasmus, of Hoveton St John, husbandman 0
4085728 2055167 2055167 defendant Palmer Robert gent 590485 590485 Palmer, Robert, of Hoveton St John, gent 1
4093991 2058179 2058179 defendant Hubberd Agnes widow 590485 590485 Hubberd, Agnes, of Hoveton St John, widow 0
4093992 2058179 2058179 defendant Bowman John husbandman 590485 590485 Bowman, John, of Hoveton St John, husbandman 1
4099123 2060012 2060012 defendant Gyles Robert husbandman 590485 590485 Gyles, Robert, of Hoveton St John, husbandman 1
4111286 2064285 2064285 defendant Gyles Robert husbandman 590485 590485 Gyles, Robert, of Hoveton St John, husbandman 3
4114478 2065464 2065464 defendant Wynter Erasmus gent 590485 590485 Wynter, Erasmus, of Hoveton St John, gent 0
4128144 2070355 2070355 defendant Boweman John husbandman 590485 590485 Boweman, John, of Hoveton St John, husbandman 1
4139632 2074538 2074538 defendant Palmer Robert gent 590485 590485 Palmer, Robert, of Hoveton St John, gent 0
4162022 2082273 2082273 defendant Wynter Erasmus gent 590485 590485 Wynter, Erasmus, of Hoveton St John, gent 0
4164431 2083078 2083078 defendant Palmer Robert gent 590485 590485 Palmer, Robert, of Hoveton St John, gent 0
4179353 2088250 2088250 defendant Watson William cordwainer 590485 590485 Watson, William, of Hoveton St John, cordwainer 2
4244539 2111154 2111154 defendant Smyth Edmund gent 590485 590485 Smyth, Edmund, of Hoveton St John, gent 0
4279267 2122678 2122678 defendant Palmer Robert gent 590485 590485 Palmer, Robert, of Hoveton St John, gent 1
4371154 2154742 2154742 defendant Palmer Robert gent 590485 590485 Palmer, Robert, of Hoveton St John, gent 0
4479294 2194175 2194175 defendant atte More William   590485 590485 atte More, William, of Hoveton St John 0
4746967 2279616 2279616 defendant Dewe William husbandman 590485 590485 Dewe, William, of Hoveton St John, husbandman 0
4928463 2335325 2335325 defendant Bery John husbandman 590485 590485 Bery, John, of Hoveton St John, husbandman 0
4933368 2336823 2336823 defendant Cirdyng Geoffrey   590485 590485 Cirdyng, Geoffrey, of Hoveton St John 0
4945710 2340640 2340640 defendant Miller John husbandman 590485 590485 Miller, John, of Hoveton St John, husbandman 0
4960167 2345013 2345013 defendant Gyrdyng Geoffrey yeoman 590485 590485 Gyrdyng, Geoffrey, of Hoveton St John, yeoman 0
4969547 2347840 2347840 defendant Wattes William husbandman 590485 590485 Wattes, William, of Hoveton St John, husbandman 4
4985248 2352515 2352515 defendant Wattes William husbandman 590485 590485 Wattes, William, of Hoveton St John, husbandman 0
5045331 2370231 2370231 defendant Tunstede John yeoman 590485 590485 Tunstede, John, of Hoveton St John, yeoman 0
5253244 2431112 2431112 defendant Swan William, junior (legal representative) 590485 590485 Swan, William, junior, of Hoveton St John, husbandman, executrix of 2
5253245 2431112 2431112 defendant Swan Joan widow 590485 590485 Swan, Joan, of Hoveton St John, widow 3
5286612 2441095 2441095 defendant Botheman or Bocheman Robert husbandman 590485 590485 Botheman or Bocheman, Robert, of Hoveton St John, husbandman 1
5497437 2504172 2504172 defendant Boweman Robert butcher 590485 590485 Boweman, Robert, of Hoveton St John, butcher 4
5513453 2509053 2509053 defendant Brimley Richard husbandman 590485 590485 Brimley, Richard, of Hoveton St John, husbandman 0
5599508 2534738 2534738 defendant Pekke William husbandman 590485 590485 Pekke, William, of Hoveton St John, husbandman 1
5606048 2536780 2536780 defendant Rose John   590485 590485 Rose, John, of Hoveton St John, worsted weaver 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);