names

149 rows where place_id = 596893

✎ 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
3626545 1903153 1903153 defendant Tespyn William chaplain 596893 596893 Tespyn, William, of Reydon, chaplain 0
3631599 1904698 1904698 plaintiff Grene William husbandman 596893 596893 Grene, William, of Reydon, husbandman 0
3635233 1905810 1905810 defendant Quarles Thomas clerk 596893 596893 Quarles, Thomas, of Reydon, clerk 0
3635234 1905810 1905810 defendant Thordon alias Chambre Thomas husbandman 596893 596893 Thordon alias Chambre, Thomas, of Reydon, husbandman 1
3635235 1905810 1905810 defendant Wodde John husbandman 596893 596893 Wodde, John, of Reydon, husbandman 2
3635236 1905810 1905810 defendant Bronde John husbandman 596893 596893 Bronde, John, of Reydon, husbandman 3
3638338 1906808 1906808 defendant Balle Thomas sawyer 596893 596893 Balle, Thomas, of Reydon, sawyer 1
3670929 1916875 1916875 defendant Grene William husbandman 596893 596893 Grene, William, of Reydon, husbandman 0
3675297 1918314 1918314 defendant Ketylburgh John butcher 596893 596893 Ketylburgh, John, of Reydon, butcher 0
3675303 1918317 1918317 defendant Waynforth Walter husbandman 596893 596893 Waynforth, Walter, of Reydon, husbandman 0
3676796 1918778 1918778 defendant Mortemer Walter weaver 596893 596893 Mortemer, Walter, of Reydon, weaver 0
3692802 1923940 1923940 plaintiff Lane Thomas clerk 596893 596893 Lane, Thomas, of Reydon, clerk 0
3692803 1923940 1923940 defendant Waryn Robert yeoman 596893 596893 Waryn, Robert, of Reydon, yeoman 0
3696168 1925022 1925022 defendant Jamys William husbandman 596893 596893 Jamys, William, of Reydon, husbandman 3
3705676 1928057 1928057 defendant Maydewell Edward pardoner 596893 596893 Maydewell, Edward, of Reydon, pardoner 1
3714559 1930852 1930852 defendant Glanfeld Robert weaver 596893 596893 Glanfeld, Robert, of Reydon, weaver 0
3737087 1937840 1937840 defendant Wace John husbandman 596893 596893 Wace, John, of Reydon, husbandman 1
3746094 1940686 1940686 plaintiff Chele John   596893 596893 Chele, John, of Reydon 0
3752709 1942775 1942775 defendant Wace John husbandman 596893 596893 Wace, John, of Reydon, husbandman 2
3766236 1947093 1947093 defendant Payn Geoffrey husbandman 596893 596893 Payn, Geoffrey, of Reydon, husbandman 1
3791384 1955140 1955140 defendant Awood John husbandman 596893 596893 Awood, John, of Reydon, husbandman 3
3791385 1955140 1955140 defendant Awood Henry laborer 596893 596893 Awood, Henry, of Reydon, laborer 4
3795007 1956302 1956302 defendant Blosse Thomas husbandman 596893 596893 Blosse, Thomas, of Reydon, husbandman 3
3799495 1957761 1957761 defendant Wykeham John brickmaker 596893 596893 Wykeham, John, of Reydon, brickmaker 0
3800524 1958089 1958089 defendant Long Robert yeoman 596893 596893 Long, Robert, of Reydon, yeoman 0
3809561 1960875 1960875 defendant Barker William husbandman 596893 596893 Barker, William, of Reydon, husbandman 1
3816178 1962964 1962964 defendant Wace John husbandman 596893 596893 Wace, John, of Reydon, husbandman 1
3825557 1965846 1965846 defendant Dokerell John husbandman 596893 596893 Dokerell, John, of Reydon, husbandman 4
3828634 1966834 1966834 defendant Aldred William husbandman 596893 596893 Aldred, William, of Reydon, husbandman 1
3831005 1967580 1967580 defendant Wytwood William husbandman 596893 596893 Wytwood, William, of Reydon, husbandman 2
3835308 1968982 1968982 defendant Walby Thomas husbandman 596893 596893 Walby, Thomas, of Reydon, husbandman 0
3837497 1969634 1969634 defendant Wace John husbandman 596893 596893 Wace, John, of Reydon, husbandman 0
3838801 1970063 1970063 defendant Lawter Robert husbandman 596893 596893 Lawter, Robert, of Reydon, husbandman 0
3838802 1970063 1970063 defendant Harman John, junior husbandman 596893 596893 Harman, John, junior, of Reydon, husbandman 1
3853525 1974727 1974727 defendant Waynstrong William yeoman 596893 596893 Waynstrong, William, of Reydon, yeoman 1
3855163 1975249 1975249 defendant Lyste or Lyfte William husbandman 596893 596893 Lyste or Lyfte, William, of Reydon, husbandman 0
3855164 1975249 1975249 defendant Lanter or Lauter Robert laborer 596893 596893 Lanter or Lauter, Robert, of Reydon, laborer 1
3855165 1975249 1975249 defendant Harman John husbandman 596893 596893 Harman, John, of Reydon, husbandman 2
3856242 1975572 1975572 defendant Sturges Henry clerk 596893 596893 Sturges, Henry, of Reydon, clerk 3
3859610 1976707 1976707 defendant Glamfeld Robert weaver 596893 596893 Glamfeld, Robert, of Reydon, weaver 3
3864010 1978144 1978144 defendant Penyng William roper 596893 596893 Penyng, William, of Reydon, roper 0
3864011 1978145 1978145 plaintiff Ketylbergh John   596893 596893 Ketylbergh, John, of Reydon 0
3866898 1979167 1979167 defendant Botman John   596893 596893 Botman, John, of Reydon, wheelwright 0
3869516 1980047 1980047 defendant Aldred William husbandman 596893 596893 Aldred, William, of Reydon, husbandman 1
3869569 1980062 1980062 defendant Webster John weaver 596893 596893 Webster, John, of Reydon, weaver 3
3873411 1981321 1981321 defendant Wace John husbandman 596893 596893 Wace, John, of Reydon, husbandman 1
3878319 1982995 1982995 defendant Ballys Richard husbandman 596893 596893 Ballys, Richard, of Reydon, husbandman 0
3904319 1991692 1991692 defendant Grey William husbandman 596893 596893 Grey, William, of reydon, husbandman 5
3963912 2011983 2011983 defendant Knyght Julian husbandman 596893 596893 Knyght, Julian, of Reydon, husbandman 0
3963914 2011984 2011984 defendant Knyght Julian husbandman or yeoman 596893 596893 Knyght, Julian, of Reydon, husbandman or yeoman 0
3968502 2013616 2013616 defendant Myddeldyche John husbandman 596893 596893 Myddeldyche, John, of Reydon, husbandman 1
3980208 2017687 2017687 defendant Warne John husbandman 596893 596893 Warne, John, of Reydon, husbandman 0
4007301 2027392 2027392 defendant Blythe William husbandman 596893 596893 Blythe, William, of Reydon, husbandman 0
4058412 2045394 2045394 defendant Codde alias Dade Geoffrey weaver 596893 596893 Codde alias Dade, Geoffrey, of Reydon, weaver 0
4063575 2047262 2047262 plaintiff Godderd Thomas   596893 596893 Godderd, Thomas, of Reydon 0
4063578 2047263 2047263 plaintiff Godderd Thomas   596893 596893 Godderd, Thomas, of Reydon 0
4218065 2101815 2101815 defendant Feaste Thomas butcher 596893 596893 Feaste, Thomas, of Reydon, butcher 0
4358505 2150210 2150210 defendant Sickerlyn John husbandman 596893 596893 Sickerlyn, John, of Reydon, husbandman 0
4383319 2159134 2159134 defendant Artys Nicholas carpenter 596893 596893 Artys, Nicholas, of Reydon, carpenter 2
4384139 2159387 2159387 defendant Laneham Henry husbandman 596893 596893 Laneham, Henry, of Reydon, husbandman 2
4439091 2181510 2181510 defendant Kervyle Richard   596893 596893 Kervyle, Richard, of Reydon 0
4440937 2182088 2182088 defendant Petyt John   596893 596893 Petyt, John, of Reydon 0
4447833 2184252 2184252 defendant Rowe William   596893 596893 Rowe, William, of Reydon 0
4450026 2184967 2184967 defendant Ballard Richard   596893 596893 Ballard, Richard, of Reydon 0
4450027 2184967 2184967 defendant Waleys Robert   596893 596893 Waleys, Robert, of Reydon 1
4450029 2184968 2184968 defendant Ballard Richard   596893 596893 Ballard, Richard, of Reydon 0
4450030 2184968 2184968 defendant Waleys Robert   596893 596893 Waleys, Robert, of Reydon 1
4497880 2199978 2199978 defendant Kyrton William   596893 596893 Kyrton, William, of Reydon 0
4543014 2213706 2213706 plaintiff Smyth Thomas   596893 596893 Smyth, Thomas, of Reydon 2
4543983 2214027 2214027 plaintiff Baldewyn John   596893 596893 Baldewyn, John, of Reydon 0
4543985 2214028 2214028 plaintiff Baldewyn John   596893 596893 Baldewyn, John, of Reydon 0
4567079 2221260 2221260 defendant Baldewyne John   596893 596893 Baldewyne, John, of Reydon 0
4567080 2221260 2221260 defendant Meryweder John   596893 596893 Meryweder, John, of Reydon 1
4567081 2221260 2221260 defendant Fyssher John   596893 596893 Fyssher, John, of Reydon 2
4567084 2221261 2221261 defendant Baldewyne John   596893 596893 Baldewyne, John, of Reydon 0
4567085 2221261 2221261 defendant Meryweder John   596893 596893 Meryweder, John, of Reydon 1
4567086 2221261 2221261 defendant Fyssher John   596893 596893 Fyssher, John, of Reydon 2
4591050 2228556 2228556 defendant Lavenham John   596893 596893 Lavenham, John, of Reydon 0
4591051 2228556 2228556 defendant atte Lee Thomas   596893 596893 atte Lee, Thomas, of Reydon 1
4591052 2228556 2228556 defendant Baldewyne John   596893 596893 Baldewyne, John, of Reydon 2
4591067 2228561 2228561 defendant atte Lee Thomas   596893 596893 atte Lee, Thomas, of Reydon 1
4591068 2228561 2228561 defendant Baldewyne John   596893 596893 Baldewyne, John, of Reydon 2
4616199 2236068 2236068 defendant Baldewyn John butcher 596893 596893 Baldewyn, John, of Reydon, butcher 0
4636452 2242233 2242233 plaintiff Barnewell John   596893 596893 Barnewell, John, of Reydon 0
4670159 2256372 2256372 defendant Bale John   596893 596893 Bale, John, of Reydon, parson 0
4675668 2258000 2258000 defendant Cramphorne Hugh husbandman 596893 596893 Cramphorne, Hugh, of Reydon, husbandman 1
4675670 2258000 2258000 defendant Gybbe John husbandman 596893 596893 Gybbe, John, of Reydon, husbandman 3
4679394 2259171 2259171 defendant Stannere John husbandman 596893 596893 Stannere, John, of Reydon, husbandman 0
4696561 2264399 2264399 defendant Ropere John   596893 596893 Ropere, John, of Reydon, rope maker 2
4721394 2272025 2272025 defendant Thorne Henry husbandman 596893 596893 Thorne, Henry, of Reydon, husbandman 1
4724307 2272899 2272899 defendant Payn Geoffrey yeoman 596893 596893 Payn, Geoffrey, of Reydon, yeoman 0
4747692 2279833 2279833 plaintiff Brasier William   596893 596893 (Brasier, William, of Reydon, vicar 1
4765193 2285095 2285095 defendant Bauwe John barber 596893 596893 Bauwe, John, of Reydon, barber 0
4783552 2290874 2290874 defendant Brampton John laborer 596893 596893 Brampton, John, of Reydon, laborer 0
4789362 2292736 2292736 defendant Cawe John barber 596893 596893 Cawe, John, of Reydon, barber 0
4801482 2296644 2296644 defendant Ducheman John weaver 596893 596893 Ducheman, John, of Reydon, weaver 2
4807622 2298575 2298575 defendant Pyntyng Thomas husbandman 596893 596893 Pyntyng, Thomas, of Reydon, husbandman 1
4811382 2299669 2299669 defendant Terry John chapman 596893 596893 Terry, John, of Reydon, chapman 0
4819160 2302071 2302071 defendant Ingram Thomas yeoman 596893 596893 Ingram, Thomas, of Reydon, yeoman 0
4819890 2302296 2302296 defendant Thorn Henry husbandman 596893 596893 Thorn, Henry, of Reydon, husbandman 1

Next page

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