names

39 rows where place_id = 602896

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3652201 1911029 1911029 defendant Geffrey Thomas husbandman 602896 602896 Geffrey, Thomas, of Ashewell, husbandman 1
3652202 1911029 1911029 defendant Raynard Thomas husbandman 602896 602896 Raynard, Thomas, of Ashewell, husbandman 2
3652203 1911029 1911029 defendant Auncell William husbandman 602896 602896 Auncell, William, of Ashewell, husbandman 3
3899014 1989877 1989877 defendant Rotherham James gent 602896 602896 Rotherham, James, of Ashewell, gent 0
3927866 1999658 1999658 plaintiff Barley John   602896 602896 Barley, John, of Ashewell 0
3944883 2005305 2005305 defendant Rooke Thomas husbandman 602896 602896 Rooke, Thomas, of Ashewell, husbandman 1
3992004 2021905 2021905 defendant Barley John yeoman 602896 602896 Barley, John, of Ashewell, yeoman 0
3992006 2021906 2021906 defendant Nicoll George maltster 602896 602896 Nicoll, George, of Ashewell, maltster 0
4001431 2025288 2025288 defendant Gayler William yeoman 602896 602896 Gayler, William, of Ashewell, yeoman 2
4006290 2027028 2027028 defendant Nicoll Hamon husbandman 602896 602896 Nicoll, Hamon, of Ashewell, husbandman 1
4018662 2031408 2031408 defendant Chapman Joseph chapman 602896 602896 Chapman, Joseph, of Ashewell, chapman 1
4047049 2041394 2041394 defendant Lee Robert husbandman 602896 602896 Lee, Robert, of Ashewell, husbandman 0
4063685 2047303 2047303 defendant Gayler William yeoman 602896 602896 Gayler, William, of Ashewell, yeoman 0
4072108 2050324 2050324 defendant Jentell William butcher 602896 602896 Jentell, William, of Ashewell, butcher 0
4072109 2050324 2050324 defendant Lame or Laine John butcher 602896 602896 Lame or Laine, John, of Ashewell, butcher 1
4074220 2051079 2051079 plaintiff Pygg John fuller 602896 602896 Pygg, John, of Ashewell, fuller 0
4074221 2051079 2051079 defendant Turner Edward maltster 602896 602896 Turner, Edward, of Ashewell, maltster 0
4096518 2059081 2059081 defendant Bygrave Robert miller 602896 602896 Bygrave, Robert, of Ashewell, miller 2
4105501 2062246 2062246 plaintiff Nicholl Hamond maltster 602896 602896 Nicholl, Hamond, of Ashewell, maltster 0
4109782 2063757 2063757 defendant Wrange Thomas laborer 602896 602896 Wrange, Thomas, of Ashewell, laborer 3
4185400 2090406 2090406 defendant Trigg Henry (legal representative) 602896 602896 Trigg, Henry, of Ashewell, yeoman, executrix of 0
4185401 2090406 2090406 defendant Trigg Agnes widow 602896 602896 Trigg, Agnes, of Ashewell, widow 1
4185570 2090459 2090459 defendant Trigg Agnes widow 602896 602896 Trigg, Agnes, of Ashewell, widow 1
4187681 2091194 2091194 defendant Tunnick Thomas husbandman 602896 602896 Tunnick, Thomas, of Ashewell, husbandman 0
4190296 2092114 2092114 defendant Gyrton Thomas mealman 602896 602896 Gyrton, Thomas, of Ashewell, mealman 2
4190297 2092114 2092114 defendant Wynche William butcher 602896 602896 Wynche, William, of Ashewell, butcher 3
4215399 2100882 2100882 defendant Kettring Robert husbandman 602896 602896 Kettring, Robert, of Ashewell, husbandman 0
4238015 2108901 2108901 defendant Bygrave Robert   602896 602896 Bygrave, Robert, of Ashewell, mason 0
4276461 2121710 2121710 defendant Davyes John husbandman 602896 602896 Davyes, John, of Ashewell, husbandman 0
4277226 2121967 2121967 defendant Browne John (legal representative) 602896 602896 Browne, John, of Ashewell, yeoman, administratrix of 2
4277227 2121967 2121967 defendant Browne Elizabeth widow 602896 602896 Browne, Elizabeth, of Ashewell, widow 3
4277654 2122109 2122109 defendant Barley John, junior yeoman 602896 602896 Barley, John, junior, of Ashewell, yeoman 0
4277655 2122109 2122109 defendant Barley John, senior husbandman 602896 602896 Barley, John, senior, of Ashewell, husbandman 1
4277656 2122109 2122109 defendant Baldocke Jerome carrier 602896 602896 Baldocke, Jerome, of Ashewell, carrier 2
4278898 2122554 2122554 defendant Barley John husbandman 602896 602896 Barley, John, of Ashewell, husbandman 1
4279803 2122854 2122854 defendant Blewytt Nicholas tailor 602896 602896 Blewytt, Nicholas, of Ashewell, tailor 1
4284376 2124461 2124461 defendant Good Robert maltster 602896 602896 Good, Robert, of Ashewell, maltster 1
5370911 2466490 2466490 plaintiff Hanley William draper 602896 602896 Hanley, William, of Ashewell, draper 0
5402371 2475752 2475752 defendant Feers John fuller 602896 602896 Feers, John, of Ashewell, fuller 2

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