names

61 rows where place_id = 586637

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589275 1864285 1864285 defendant Chapleyn William husbandman 586637 586637 Chapleyn, William, of Hensted, husbandman 3
3611922 1871389 1871389 defendant Joye Richard yeoman 586637 586637 Joye, Richard, of Hensted, yeoman 0
3676588 1918716 1918716 defendant Chambre Thomas yeoman 586637 586637 Chambre, Thomas, of Hensted, yeoman 2
3686937 1922081 1922081 defendant Hobson Walter butcher 586637 586637 Hobson, Walter, of Hensted, butcher 0
3706313 1928261 1928261 defendant Damme Thomas yeoman 586637 586637 Damme, Thomas, of Hensted, yeoman 1
3708903 1929076 1929076 defendant Grenlyng John husbandman 586637 586637 Grenlyng, John, of Hensted, husbandman 0
3731886 1936204 1936204 defendant Dunne Thomas yeoman 586637 586637 Dunne, Thomas, of Hensted, yeoman 0
3731887 1936204 1936204 defendant Grenlyng William yeoman 586637 586637 Grenlyng, William, of Hensted, yeoman 1
3749508 1941757 1941757 defendant Dunne Thomas husbandman 586637 586637 Dunne, Thomas, of Hensted, husbandman 1
3848236 1973016 1973016 defendant Dunn Thomas yeoman 586637 586637 Dunn, Thomas, of Hensted, yeoman 1
3867795 1979460 1979460 defendant Lynde Robert husbandman 586637 586637 Lynde, Robert, of Hensted, husbandman 0
3909992 1993649 1993649 defendant Coker John   586637 586637 Coker, John, of Hensted, administrators of 1
3922329 1997782 1997782 defendant Newman John blacksmith 586637 586637 Newman, John, of Hensted, blacksmith 0
3934830 2001949 2001949 defendant Newman John smith 586637 586637 Newman, John, of Hensted, smith 0
3934831 2001949 2001949 defendant Tredescant alias Luske Thomas husbandman 586637 586637 Tredescant alias Luske, Thomas, of Hensted, husbandman 1
3950683 2007312 2007312 defendant Cuddon Robert gent 586637 586637 Cuddon, Robert, of Hensted, gent 0
3999904 2024735 2024735 defendant Chaplyn Christopher husbandman 586637 586637 Chaplyn, Christopher, of Hensted, husbandman 1
4001077 2025163 2025163 defendant Dadde Theobald cordewainer 586637 586637 Dadde, Theobald, of Hensted, cordewainer 0
4087414 2055792 2055792 defendant Bonnett Roger tanner 586637 586637 Bonnett, Roger, of Hensted, or of Sibton, tanner 0
4098843 2059916 2059916 defendant Bennett Roger tanner 586637 586637 Bennett, Roger, of Hensted, tanner 0
4129154 2070731 2070731 defendant Spylman Geoffrey husbandman 586637 586637 Spylman, Geoffrey, of Hensted, husbandman 2
4133533 2072323 2072323 defendant Spylman Godfrey husbandman 586637 586637 Spylman, Godfrey, of Hensted, husbandman 0
4181483 2089002 2089002 defendant Spilman Godfrey husbandman 586637 586637 Spilman, Godfrey, of Hensted, husbandman 0
4275249 2121280 2121280 defendant Cranefilde Bartholomew husbandman 586637 586637 Cranefilde, Bartholomew, of Hensted, husbandman 3
4275252 2121281 2121281 defendant Fairewether Simon husbandman 586637 586637 Fairewether, Simon, of Hensted, husbandman 1
4447170 2184021 2184021 defendant Dalby John   586637 586637 Dalby, John, of Hensted 1
4454657 2186475 2186475 defendant Sattely Walter   586637 586637 Sattely, Walter, of Hensted 0
4616755 2236240 2236240 defendant Battok William   586637 586637 Battok, William, of Hensted 1
4831803 2305966 2305966 defendant Clement John   586637 586637 Clement, John, of Hensted, groom 0
4871187 2317965 2317965 defendant Davy John yeoman 586637 586637 Davy, John, of Hensted, yeoman 0
4884104 2321939 2321939 defendant Oldryng Richard husbandman 586637 586637 Oldryng, Richard, of Hensted, husbandman 0
4893718 2324730 2324730 defendant Clement William yeoman 586637 586637 Clement, William, of Hensted, yeoman 0
4894999 2325102 2325102 defendant Clement William yeoman 586637 586637 Clement, William, of Hensted, yeoman 0
5212455 2419386 2419386 defendant Bondys or Bond William gent 586637 586637 Bondys or Bond, William, of Hensted, gent 1
5230260 2424469 2424469 plaintiff Bondys William   586637 586637 Bondys, William, of Hensted 1
5234982 2425811 2425811 defendant Herryson John husbandman 586637 586637 Herryson, John, of Hensted, husbandman 3
5329334 2453857 2453857 defendant Chapeleyn John husbandman 586637 586637 Chapeleyn, John, of Hensted, husbandman 3
5349149 2459862 2459862 defendant Bryssyngham John husbandman 586637 586637 Bryssyngham, John, of Hensted, husbandman 2
5365915 2464994 2464994 defendant Bresyngham William husbandman 586637 586637 Bresyngham, William, of Hensted, husbandman 0
5365916 2464994 2464994 defendant Suffeyn William husbandman 586637 586637 Suffeyn, William, of Hensted, husbandman 1
5365917 2464994 2464994 defendant Chapelyn William husbandman 586637 586637 Chapelyn, William, of Hensted, husbandman 2
5365918 2464994 2464994 defendant Leftlyn or Lestlyn John husbandman 586637 586637 Leftlyn or Lestlyn, John, of Hensted, husbandman 3
5423384 2481955 2481955 plaintiff Bondes Henry (legal representative) 586637 586637 Bondes, Henry, of Hensted, gent, executor of William Bondes, of Hensted, gent, executors of 0
5431227 2484284 2484284 defendant Chapelyn William husbandman 586637 586637 Chapelyn, William, of Hensted, husbandman 0
5442697 2487729 2487729 plaintiff Bondes Henry (legal representative) 586637 586637 Bondes, Henry, of Hensted, gent, executors of 0
5450485 2490030 2490030 defendant Gyldern Thomas husbandman 586637 586637 Gyldern, Thomas, of Hensted, husbandman 0
5455381 2491525 2491525 plaintiff Bondes Henry (legal representative) 586637 586637 Bondes, Henry, of Hensted, gent, executor of William Bondes, of Hensted, gent, executors of 0
5455388 2491526 2491526 plaintiff Bondes Henry (legal representative) 586637 586637 Bondes, Henry, of Hensted, gent, formerly executor of William Bondes, of Hensted, gent, executors of 0
5462622 2493732 2493732 defendant Gyldern Thomas husbandman 586637 586637 Gyldern, Thomas, of Hensted, husbandman 0
5462625 2493733 2493733 defendant Gyldern Thomas husbandman 586637 586637 Gyldern, Thomas, of Hensted, husbandman 0
5481241 2499336 2499336 defendant Chapleyn William husbandman 586637 586637 Chapleyn, William, of Hensted, husbandman 8
5482698 2499769 2499769 defendant Penkney Benedict smith 586637 586637 Penkney, Benedict, of Hensted, smith 2
5485320 2500527 2500527 defendant Brouster Robert husbandman 586637 586637 Brouster, Robert, of Hensted, husbandman 1
5486372 2500810 2500810 defendant Chapelyn Robert husbandman 586637 586637 Chapelyn, Robert, of Hensted, husbandman 1
5486778 2500945 2500945 defendant Gelderne Thomas husbandman 586637 586637 Gelderne, Thomas, of Hensted, husbandman 1
5508257 2507465 2507465 defendant Breuster Robert husbandman 586637 586637 Breuster, Robert, of Hensted, husbandman 0
5508259 2507466 2507466 defendant Geldern Thomas husbandman 586637 586637 Geldern, Thomas, of Hensted, husbandman 0
5554096 2521239 2521239 defendant Gildern Thomas, senior husbandman 586637 586637 Gildern, Thomas, senior, of Hensted, husbandman 0
5554097 2521239 2521239 defendant Gildern John husbandman 586637 586637 Gildern, John, of Hensted, husbandman 1
5554100 2521240 2521240 defendant Gildern Thomas, senior husbandman 586637 586637 Gildern, Thomas, senior, of Hensted, husbandman 0
5554101 2521240 2521240 defendant Gildern John husbandman 586637 586637 Gildern, John, of Hensted, husbandman 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);