names

308 rows where place_id = 588641

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595133 1866109 1866109 defendant Merssh George husbandman 588641 588641 Merssh, George, of Denton, husbandman 0
3597172 1866741 1866741 defendant Whykeley Robert yeoman 588641 588641 Whykeley, Robert, of Denton, yeoman 0
3597173 1866741 1866741 defendant Whykeley Thomas laborer 588641 588641 Whykeley, Thomas, of Denton, laborer 1
3597174 1866741 1866741 defendant Smegergyll John yeoman 588641 588641 Smegergyll, John, of Denton, yeoman 2
3597177 1866742 1866742 defendant Wikeley Robert yeoman 588641 588641 Wikeley, Robert, of Denton, yeoman 0
3597178 1866742 1866742 defendant Wikeley Thomas laborer 588641 588641 Wikeley, Thomas, of Denton, laborer 1
3597179 1866742 1866742 defendant Smegergill John yeoman 588641 588641 Smegergill, John, of Denton, yeoman 2
3597182 1866743 1866743 defendant Wykeley Robert yeoman 588641 588641 Wykeley, Robert, of Denton, yeoman 0
3597183 1866743 1866743 defendant Wykeley Thomas laborer 588641 588641 Wykeley, Thomas, of Denton, laborer 1
3597184 1866743 1866743 defendant Smegergyll John yeoman 588641 588641 Smegergyll, John, of Denton, yeoman 2
3599473 1867476 1867476 defendant Veysy alias Reysy John husbandman 588641 588641 Veysy alias Reysy, John, of Denton, husbandman 1
3639951 1907308 1907308 defendant Mynskyp Thomas chaplain 588641 588641 Mynskyp, Thomas, of Denton, chaplain 0
3640878 1907591 1907591 defendant Mortymer John husbandman 588641 588641 Mortymer, John, of Denton, husbandman 0
3672207 1917308 1917308 defendant Graunt William yeoman 588641 588641 Graunt, William, of Denton, yeoman 0
3684696 1921346 1921346 plaintiff Aldrych John   588641 588641 Aldrych, John, of Denton 0
3685511 1921620 1921620 defendant Orston William husbandman 588641 588641 Orston, William, of Denton, husbandman 1
3686737 1922007 1922007 defendant Bunnyng Thomas   588641 588641 Bunnyng, Thomas, of Denton, yeoman, son of Bunnyng, John, senior 0
3697669 1925494 1925494 defendant Dyxson Robert husbandman 588641 588641 Dyxson, Robert, of Denton, husbandman 0
3715918 1931265 1931265 plaintiff Catton Nicholas   588641 588641 Catton, Nicholas, of Denton 0
3731396 1936042 1936042 defendant Arnold Richard husbandman 588641 588641 Arnold, Richard, of Denton, husbandman 0
3731397 1936042 1936042 defendant Arnold John husbandman 588641 588641 Arnold, John, of Denton, husbandman 1
3734889 1937151 1937151 defendant Leman William husbandman 588641 588641 Leman, William, of Denton, husbandman 3
3743057 1939676 1939676 defendant Bracebrig Edmund gent 588641 588641 Bracebrig, Edmund, of Denton, gent 1
3746058 1940671 1940671 defendant Fox Richard yeoman 588641 588641 Fox, Richard, of Denton, yeoman 0
3746633 1940862 1940862 defendant Heyd Robert husbandman 588641 588641 Heyd, Robert, of Denton, husbandman 2
3746637 1940863 1940863 defendant Hedde Robert yeoman 588641 588641 Hedde, Robert, of Denton, yeoman 2
3759161 1944853 1944853 defendant Fox Richard yeoman 588641 588641 Fox, Richard, of Denton, yeoman 0
3759163 1944854 1944854 defendant Fox Richard yeoman 588641 588641 Fox, Richard, of Denton, yeoman 0
3765232 1946791 1946791 defendant Bracebrig Edmund gent 588641 588641 Bracebrig, Edmund, of Denton, gent 2
3775152 1949961 1949961 defendant Frytter John husbandman 588641 588641 Frytter, John, of Denton, husbandman 3
3818529 1963696 1963696 defendant Dawson William smith 588641 588641 Dawson, William, of Denton, smith 4
3818536 1963698 1963698 defendant Dawson William smith 588641 588641 Dawson, William, of Denton, smith 3
3850656 1973794 1973794 defendant Stevyn Thomas husbandman 588641 588641 Stevyn, Thomas, of Denton, husbandman 1
3905817 1992227 1992227 defendant Graunger Thomas yeoman 588641 588641 Graunger, Thomas, of Denton, yeoman 0
3908334 1993086 1993086 defendant Thomson Richard husbandman 588641 588641 Thomson, Richard, of Denton, husbandman 0
3908339 1993087 1993087 defendant Tomson Richard husbandman 588641 588641 Tomson, Richard, of Denton, husbandman 0
3909578 1993508 1993508 plaintiff Smyth William   588641 588641 Smyth, William, of Denton 0
3940393 2003805 2003805 defendant Roone Francis husbandman 588641 588641 Roone, Francis, of Denton, husbandman 2
3956090 2009199 2009199 defendant Poyton or Poynton John glover 588641 588641 Poyton or Poynton, John, of Denton, glover 1
3966512 2012922 2012922 defendant Edsdene Edward husbandman 588641 588641 Edsdene, Edward, of Denton, husbandman 1
3967100 2013117 2013117 defendant Garrold Thomas yeoman 588641 588641 Garrold, Thomas, of Denton, yeoman 3
3983840 2018991 2018991 defendant Bunnyng Thomas yeoman 588641 588641 Bunnyng, Thomas, of Denton, yeoman 2
3984839 2019333 2019333 defendant Porter John clerk 588641 588641 Porter, John, of Denton, clerk 0
3999016 2024407 2024407 plaintiff Fox Nicholas yeoman 588641 588641 Fox, Nicholas, of Denton, yeoman 0
4003940 2026178 2026178 defendant Bonyng Thomas yeoman 588641 588641 Bonyng, Thomas, of Denton, yeoman 0
4003942 2026179 2026179 defendant Kypping John yeoman 588641 588641 Kypping, John, of Denton, yeoman 0
4004201 2026278 2026278 defendant Bonyng Richard yeoman 588641 588641 Bonyng, Richard, of Denton, yeoman 0
4008542 2027819 2027819 defendant Bonyng or Bunyng Richard yeoman 588641 588641 Bonyng or Bunyng, Richard, of Denton, yeoman 1
4008543 2027819 2027819 defendant Tyte Robert yeoman 588641 588641 Tyte, Robert, of Denton, yeoman 2
4011525 2028876 2028876 plaintiff Polkyns William   588641 588641 Polkyns, William, of Denton 0
4011526 2028876 2028876 defendant Monte Joan widow 588641 588641 Monte, Joan, of Denton, widow 0
4012629 2029241 2029241 defendant Bunyng Richard yeoman 588641 588641 Bunyng, Richard, of Denton, yeoman 0
4012631 2029242 2029242 defendant Bunyng Thomas yeoman 588641 588641 Bunyng, Thomas, of Denton, yeoman 0
4012633 2029243 2029243 defendant Tyte Robert, senior yeoman 588641 588641 Tyte, Robert, senior, of Denton, yeoman 0
4014457 2029895 2029895 defendant Warner Thomas husbandman 588641 588641 Warner, Thomas, of Denton, husbandman 0
4014765 2029992 2029992 defendant Bunyng Richard yeoman 588641 588641 Bunyng, Richard, of Denton, yeoman 0
4014767 2029993 2029993 defendant Bunyng Thomas yeoman 588641 588641 Bunyng, Thomas, of Denton, yeoman 0
4026806 2034234 2034234 defendant Bunnynge Thomas yeoman 588641 588641 Bunnynge, Thomas, of Denton, yeoman 0
4047387 2041522 2041522 plaintiff Staynforthe Thomas husbandman 588641 588641 Staynforthe, Thomas, of Denton, husbandman 0
4055288 2044290 2044290 plaintiff Bennett Robert yeoman 588641 588641 Bennett, Robert, of Denton, yeoman 0
4062122 2046739 2046739 plaintiff Fairefaxe Thomas esq 588641 588641 Fairefaxe, Thomas, of Denton, esq 0
4065782 2048056 2048056 defendant Whitehed Anthony yeoman 588641 588641 Whitehed, Anthony, of Denton, yeoman 1
4082538 2054061 2054061 defendant Bumyng or Binnyng Thomas yeoman 588641 588641 Bumyng or Binnyng, Thomas, of Denton, yeoman 0
4083411 2054349 2054349 defendant Famlyn alias Fountane Joseph yeoman 588641 588641 Famlyn alias Fountane, Joseph, of Denton, yeoman 0
4083412 2054349 2054349 defendant Dawson Roger yeoman 588641 588641 Dawson, Roger, of Denton, yeoman 1
4086381 2055406 2055406 plaintiff Boyeo William   588641 588641 Boyeo, William, of Denton esq 0
4124781 2069156 2069156 defendant Awood Robert yeoman 588641 588641 Awood, Robert, of Denton, yeoman 0
4125887 2069542 2069542 defendant Awoodd Robert yeoman 588641 588641 Awoodd, Robert, of Denton, yeoman 0
4127804 2070233 2070233 defendant Borne Michael husbandman 588641 588641 Borne, Michael, of Denton, husbandman 0
4127807 2070233 2070233 defendant Julle John yeroman 588641 588641 Julle, John, of Denton, yeroman 3
4128709 2070563 2070563 defendant Awoodd Robert yeoman 588641 588641 Awoodd, Robert, of Denton, yeoman 0
4141556 2075211 2075211 defendant Newton Thomas husbandman 588641 588641 Newton, Thomas, of Denton, husbandman 0
4141557 2075211 2075211 defendant Newton Edmund clothier 588641 588641 Newton, Edmund, of Denton, or of Est Barfold, Suff, clothier 1
4141809 2075298 2075298 defendant Barbor Philip yeoman 588641 588641 Barbor, Philip, of Denton, yeoman 0
4154895 2079807 2079807 defendant Muschampe Cuthbert gent 588641 588641 Muschampe, Cuthbert, of Denton, gent 1
4157671 2080757 2080757 defendant Newton Thomas yeoman 588641 588641 Newton, Thomas, of Denton, yeoman 0
4171422 2085469 2085469 defendant Warner Arthur yeoman 588641 588641 Warner, Arthur, of Denton, yeoman 0
4174129 2086405 2086405 defendant Harrison Anthony glover 588641 588641 Harrison, Anthony, of Denton, glover 0
4174130 2086405 2086405 defendant Smythe Robert husbandman 588641 588641 Smythe, Robert, of Denton, husbandman 1
4191094 2092449 2092449 defendant Brode Ruben husbandman 588641 588641 Brode, Ruben, of Denton, husbandman 0
4193639 2093343 2093343 defendant Snell or Suell Robert carpenter 588641 588641 Snell or Suell, Robert, of Denton, carpenter 0
4193902 2093430 2093430 defendant Warner Arthur yeoman 588641 588641 Warner, Arthur, of Denton, yeoman 0
4235323 2107917 2107917 defendant Bredon John husbandman 588641 588641 Bredon, John, of Denton, husbandman 1
4238560 2109101 2109101 defendant Harrison Robert husbandman 588641 588641 Harrison, Robert, of Denton, husbandman 0
4238561 2109101 2109101 defendant Brothwell William husbandman 588641 588641 Brothwell, William, of Denton, husbandman 1
4243875 2110932 2110932 defendant Fayrfax Thomas   588641 588641 Fayrfax, Thomas, of Denton, knight 0
4261916 2116937 2116937 defendant Bunnynge Robert husbandman 588641 588641 Bunnynge, Robert, of Denton, husbandman 2
4262121 2117006 2117006 defendant Potter Thomas yeoman 588641 588641 Potter, Thomas, of Denton, yeoman 0
4262122 2117006 2117006 defendant Dey Robert butcher 588641 588641 Dey, Robert, of Denton, butcher 1
4276021 2121559 2121559 defendant Dashe Julian miller 588641 588641 Dashe, Julian, of Denton, miller 3
4287081 2125433 2125433 defendant Warner Arthur yeoman 588641 588641 Warner, Arthur, of Denton, yeoman 0
4320512 2137269 2137269 defendant Dey Robert butcher 588641 588641 Dey, Robert, of Denton, butcher 0
4320513 2137269 2137269 defendant Dennye Robert butcher 588641 588641 Dennye, Robert, of Denton, butcher 1
4320541 2137278 2137278 defendant Parson James husbandman 588641 588641 Parson, James, of Denton, husbandman 0
4320542 2137278 2137278 defendant Parson Hugh tailor 588641 588641 Parson, Hugh, of Denton, tailor 1
4322366 2137894 2137894 defendant Sparham Richard husbandman 588641 588641 together with Sparham, Richard, of Denton, husbandman 1
4322367 2137894 2137894 defendant Wigg John husbandman 588641 588641 Wigg, John, of Denton, husbandman 2
4323287 2138206 2138206 defendant Parson Hugh yeoman 588641 588641 Parson, Hugh, of Denton, husbandman, assign of John Parson, of Denton, yeoman 0
4371257 2154782 2154782 defendant Newton Thomas yeoman 588641 588641 Newton, Thomas, of Denton, yeoman 3
4387383 2160425 2160425 defendant Tyte John, junior yeoman 588641 588641 Tyte, John, junior, of Denton, yeoman 0

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