names

264 rows where place_id = 589367

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597395 1866807 1866807 defendant Touke or Tonke John, senior gent 589367 589367 Touke or Tonke, John, senior, of Wylton, gent 0
3597396 1866807 1866807 defendant Touke or Tonke William gent 589367 589367 Touke or Tonke, William, of Wylton, gent 1
3597397 1866807 1866807 defendant Touke or Tonke John, junior gent 589367 589367 Touke or Tonke, John, junior, of Wylton, gent 2
3608247 1870234 1870234 defendant Bulmer William, senior esq 589367 589367 Bulmer, William, senior, of Wylton, esq 0
3637869 1906661 1906661 defendant Hert William husbandman 589367 589367 Hert, William, of Wylton, husbandman 1
3637878 1906662 1906662 defendant Hert William husbandman 589367 589367 Hert, William, of Wylton, husbandman 1
3648547 1909939 1909939 defendant Vaugham James clerk 589367 589367 Vaugham, James, of Wylton, clerk 0
3650513 1910529 1910529 defendant Hotheny William tailor 589367 589367 Hotheny, William, of Wylton, tailor 2
3650514 1910529 1910529 defendant Baker John husbandman 589367 589367 Baker, John, of Wylton, husbandman 3
3661012 1913718 1913718 defendant Heylot Reginald   589367 589367 Heylot, Reginald, of Wylton, shepherd 2
3690317 1923133 1923133 defendant Clement William clothier 589367 589367 Clement, William, of Wylton, clothier 0
3712049 1930089 1930089 defendant Vaughan William yeoman 589367 589367 Vaughan, William, of Wylton, yeoman 1
3714436 1930810 1930810 defendant Glasyer Henry glasier 589367 589367 Glasyer, Henry, of Wylton, glasier 0
3714437 1930810 1930810 defendant Lovell John tailor 589367 589367 Lovell, John, of Wylton, tailor 1
3721153 1932913 1932913 defendant Dewe John yeoman 589367 589367 Dewe, John, of Wylton, yeoman 0
3723118 1933496 1933496 defendant Grene Roger miller 589367 589367 Grene, Roger, of Wylton, miller 0
3726622 1934586 1934586 defendant Fyrre William carrier 589367 589367 Fyrre, William, of Wylton, carrier 0
3727855 1934982 1934982 defendant Sharpe William brewer 589367 589367 Sharpe, William, of Wylton, brewer 0
3731542 1936091 1936091 defendant Mackys John yeoman 589367 589367 Mackys, John, of Wylton, yeoman 0
3732585 1936421 1936421 defendant Hawarden William clerk 589367 589367 Hawarden, William, of Wylton, clerk 0
3732587 1936422 1936422 defendant Payn Nicholas weaver 589367 589367 Payn, Nicholas, of Wylton, weaver 0
3733995 1936879 1936879 defendant Davye William smith 589367 589367 Davye, William, of Wylton, smith 0
3733996 1936879 1936879 defendant Jefferye Henry glasier 589367 589367 Jefferye, Henry, of Wylton, glasier 1
3738293 1938193 1938193 defendant Jeffery Henry glasier 589367 589367 Jeffery, Henry, of Wylton, glasier 0
3744267 1940104 1940104 defendant Dale Reginald husbandman 589367 589367 Dale, Reginald, of Wylton, husbandman 1
3755354 1943628 1943628 defendant Clement William clothier 589367 589367 Clement, William, of Wylton, clothier 0
3755355 1943628 1943628 defendant Helfton Richard yeoman 589367 589367 Helfton, Richard, of Wylton, yeoman 1
3756527 1944018 1944018 defendant Cotes Ralph husbandman 589367 589367 Cotes, Ralph, of Wylton, husbandman 0
3756534 1944020 1944020 defendant Dale Reginald husbandman 589367 589367 Dale, Reginald, of Wylton, husbandman 1
3758349 1944607 1944607 defendant Bulle William carpenter 589367 589367 Bulle, William, of Wylton, carpenter 1
3766254 1947098 1947098 defendant Hychill Lambert dyer 589367 589367 Hychill, Lambert, of Wylton, dyer 0
3766255 1947098 1947098 defendant Hychill Richard   589367 589367 Hychill, Richard, of Wylton, groom 1
3766256 1947098 1947098 defendant Hychill Margaret spinster 589367 589367 Hychill, Margaret, of Wylton, spinster 2
3766257 1947098 1947098 defendant Dere Richard carpenter 589367 589367 Dere, Richard, of Wylton, carpenter 3
3780434 1951615 1951615 defendant Fyssher Alexander husbandman 589367 589367 Fyssher, Alexander, of Wylton, husbandman 0
3792222 1955420 1955420 defendant Mackys John clothman 589367 589367 Mackys, John, of Wylton, clothman 3
3818505 1963688 1963688 defendant Maxe John yeoman 589367 589367 Maxe, John, of Wylton, yeoman 1
3841655 1970974 1970974 defendant Dystonyns John yeoman 589367 589367 Dystonyns, John, of Wylton, yeoman 0
3863437 1977963 1977963 defendant Mody alias Nye Richard yeoman 589367 589367 Mody alias Nye, Richard, of Wylton, yeoman 0
3863445 1977966 1977966 defendant Mody alias Nye Richard yeoman 589367 589367 Mody alias Nye, Richard, of Wylton, yeoman 0
3878168 1982943 1982943 defendant Apye Richard gent 589367 589367 Apye, Richard, of Wylton, gent 1
3878171 1982944 1982944 defendant Apye Richard gent 589367 589367 Apye, Richard, of Wylton, gent 0
3878279 1982982 1982982 defendant Frend John husbandman 589367 589367 Frend, John, of Wylton, husbandman 7
3883496 1984751 1984751 defendant Baker John laborer 589367 589367 Baker, John, of Wylton, laborer 0
3898611 1989743 1989743 defendant Crede John clothier 589367 589367 Crede, John, of Wylton, clothier 2
3898612 1989743 1989743 defendant Tew William clothier 589367 589367 Tew, William, of Wylton, clothier 3
3899776 1990138 1990138 defendant Jenyns Thomas laborer 589367 589367 Jenyns, Thomas, of Wylton, laborer 2
3901063 1990582 1990582 plaintiff Clement William (legal representative) 589367 589367 Clement, William, of Wylton, gent, executors of 0
3906491 1992463 1992463 defendant Gregory Roger weaver 589367 589367 Gregory, Roger, of Wylton, weaver 0
3906493 1992463 1992463 defendant Lambard alias Hachell Richard tucker 589367 589367 Lambard alias Hachell, Richard, of Wylton, tucker 2
3908669 1993194 1993194 defendant Frynde Edmund yeoman 589367 589367 Frynde, Edmund, of Wylton, yeoman 0
3918304 1996458 1996458 defendant Parker Mathew husbandman 589367 589367 Parker, Mathew, of Wylton, husbandman 1
3918305 1996458 1996458 defendant Drynkmylke John husbandman 589367 589367 Drynkmylke, John, of Wylton, husbandman 2
3933350 2001452 2001452 defendant Baker William tailor 589367 589367 Baker, William, of Wylton, tailor 0
3939651 2003569 2003569 plaintiff Sedley Martin gent 589367 589367 Sedley, Martin, of Wylton, gent 0
3939653 2003569 2003569 defendant Chapman John warner 589367 589367 Chapman, John, of Wylton, warner 1
3940411 2003811 2003811 defendant Cooke Robert husbandman 589367 589367 Cooke, Robert, of Wylton, husbandman 0
3949050 2006733 2006733 defendant Draper Richard husbandman 589367 589367 Draper, Richard, of Wylton, husbandman 1
3949053 2006734 2006734 defendant Draper Richard husbandman 589367 589367 Draper, Richard, of Wylton, husbandman 1
3949056 2006735 2006735 defendant Draper Richard husbandman 589367 589367 Draper, Richard, of Wylton, husbandman 1
3959853 2010538 2010538 defendant Ryngwood Thomas gent 589367 589367 Ryngwood, Thomas, of Wylton, gent 0
4000650 2025006 2025006 defendant Clackston William yeoman 589367 589367 Clackston, William, of Wylton, yeoman 1
4000651 2025006 2025006 defendant Sparke Henry yeoman 589367 589367 Sparke, Henry, of Wylton, yeoman 2
4011937 2028998 2028998 defendant Palmer John laborer 589367 589367 Palmer, John, of Wylton, laborer 0
4011938 2028998 2028998 defendant Butter Thomas husbandman 589367 589367 Butter, Thomas, of Wylton, husbandman 1
4011939 2028998 2028998 defendant Walker Christopher husbandman 589367 589367 Walker, Christopher, of Wylton, husbandman 2
4011940 2028998 2028998 defendant Wheateheade Thomas weaver 589367 589367 Wheateheade, Thomas, of Wylton, weaver 3
4011943 2028999 2028999 defendant Cuckowe Robert husbandman 589367 589367 Cuckowe, Robert, of Wylton, husbandman 1
4011944 2028999 2028999 defendant Cuckowe Thomas husbandman 589367 589367 Cuckowe, Thomas, of Wylton, husbandman 2
4011946 2029000 2029000 defendant Clarke Thomas husbandman 589367 589367 Clarke, Thomas, of Wylton, husbandman 0
4023260 2033026 2033026 defendant Zouche Francis gent 589367 589367 Zouche, Francis, of Wylton, gent 0
4028930 2034990 2034990 defendant Hall Thomas gent 589367 589367 Hall, Thomas, of Wylton, gent 0
4033812 2036742 2036742 defendant Baker William husbandman 589367 589367 Baker, William, of Wylton, husbandman 0
4033813 2036742 2036742 defendant Andrewes John husbandman 589367 589367 together with Andrewes, John, of Wylton, husbandman 1
4043723 2040207 2040207 defendant Puntyng Thomas yeoman 589367 589367 Puntyng, Thomas, of Wylton, yeoman 1
4059038 2045631 2045631 plaintiff Cokkoo Thomas yeoman 589367 589367 Cokkoo, Thomas, of Wylton, yeoman 0
4072156 2050342 2050342 defendant Jenyng John, junior yeoman 589367 589367 Jenyng, John, junior, of Wylton, yeoman 0
4090045 2056723 2056723 defendant Dearynge William gent 589367 589367 Dearynge, William, of Wylton, or of Wydleye, Hants, gent 0
4101657 2060899 2060899 defendant Coles Alexander gent 589367 589367 Coles, Alexander, of Wylton, or of Staunforde Ryvers, gent 0
4108995 2063473 2063473 defendant Harvey Alexander husbandman 589367 589367 Harvey, Alexander, of Wylton, or of Rode, Soms, husbandman 1
4116517 2066196 2066196 defendant Sturges John gent 589367 589367 Sturges, John, of Wylton, gent 0
4123779 2068802 2068802 defendant Rowswell John gent 589367 589367 Rowswell, John, of Wylton, or of Inglescombe, gent 0
4141872 2075325 2075325 defendant Webbe Anthony gent 589367 589367 Webbe, Anthony, of Wylton, or of Bradford, gent 0
4143477 2075878 2075878 defendant Umphyre Thomas husbandman 589367 589367 Umphyre, Thomas, of Wylton, or of Buston Deverell, husbandman 0
4143522 2075893 2075893 defendant Pyrrymon John yeoman 589367 589367 Pyrrymon, John, of Wylton, yeoman 1
4144603 2076272 2076272 defendant Maricke Richard yeoman 589367 589367 Maricke, Richard, of Wylton, yeoman 3
4158318 2080979 2080979 defendant Myles John husbandman 589367 589367 Myles, John, of Wylton, or of Urshant, husbandman 0
4177580 2087634 2087634 defendant Codrington Simon esq 589367 589367 Codrington, Simon, of Wylton, or of Didmerton, Glos, esq 0
4188007 2091305 2091305 defendant West Henry yeoman 589367 589367 West, Henry, of Wylton, or of Mydsomer Nortone, Soms, yeoman 0
4197173 2094562 2094562 defendant Tendall William gent 589367 589367 Tendall, William, of Wylton, gent 0
4212047 2099763 2099763 defendant Tendall William gent 589367 589367 Tendall, William, of Wylton, gent 0
4212049 2099763 2099763 defendant Dennys John   589367 589367 Dennys, John, of Wylton, ploughwright 2
4234364 2107556 2107556 defendant Pagett James esq 589367 589367 Pagett, James, of Wylton, or of Grove Place, Hants, esq 0
4251374 2113442 2113442 defendant Butler Henry husbandman 589367 589367 Butler, Henry, of Wylton, husbandman 0
4251375 2113442 2113442 defendant Stallon Thomas husbandman 589367 589367 Stallon, Thomas, of Wylton, husbandman 1
4253207 2114069 2114069 defendant Pyttman Thomas gent 589367 589367 Pyttman, Thomas, of Wylton, or of Salisbury, gent 0
4257402 2115452 2115452 defendant Waller Geoffrey husbandman 589367 589367 Waller, Geoffrey, of Wylton, husbandman 0
4257403 2115452 2115452 defendant Cowper Thomas husbandman 589367 589367 Cowper, Thomas, of Wylton, husbandman 1
4282091 2123637 2123637 defendant Soulde William   589367 589367 Soulde, William, of Wylton, fisherman, administrators of 1
4288650 2125996 2125996 defendant Rutter John, senior gent 589367 589367 Rutter, John, senior, of Wylton, or of Porton, Wilts, gent 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);