names

166 rows where place_id = 587719

✎ 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
3592212 1865181 1865181 defendant Bedford Walter yeoman 587719 587719 Bedford, Walter, of St Ives, Hunts, yeoman 0
3592216 1865182 1865182 defendant Bedford Walter yeoman 587719 587719 Bedford, Walter, of St Ives, Hunts, yeoman 0
3633850 1905397 1905397 defendant Grey William yeoman 587719 587719 Grey, William, of St Ives, Hunts, yeoman 0
3663497 1914509 1914509 defendant Sterlyng Richard dyer 587719 587719 Sterlyng, Richard, of St Ives, Hunts, dyer 0
3663499 1914510 1914510 defendant Sterlyng Richard dyer 587719 587719 Sterlyng, Richard, of St Ives, Hunts, dyer 0
3668720 1916151 1916151 defendant Clerk Michael yeoman 587719 587719 Clerk, Michael, of St Ives, Hunts, yeoman 1
3683223 1920872 1920872 defendant Starlyng Richard dyer 587719 587719 Starlyng, Richard, of St Ives, Hunts, dyer 0
3685823 1921723 1921723 defendant Calvered John clerk 587719 587719 Calvered, John, of St Ives, Hunts, clerk 0
3686173 1921839 1921839 defendant Marten John yeoman 587719 587719 Marten, John, of St Ives, Hunts, yeoman 1
3696250 1925049 1925049 defendant Olyver Richard dyer 587719 587719 Olyver, Richard, of St Ives, Hunts, dyer 0
3765661 1946925 1946925 defendant Olyver Richard dyer 587719 587719 Olyver, Richard, of St Ives, Hunts, dyer 1
3765665 1946926 1946926 defendant Olyver Richard dyer 587719 587719 Olyver, Richard, of St Ives, Hunts, dyer 1
3806466 1959935 1959935 defendant Sterlyng Richard dyer 587719 587719 Sterlyng, Richard, of St Ives, Hunts, dyer 1
3807419 1960224 1960224 defendant Bull Robert chapman 587719 587719 Bull, Robert, of St Ives, Hunts, chapman 0
3807425 1960226 1960226 defendant Bull Robert chapman 587719 587719 Bull, Robert, of St Ives, Hunts, chapman 2
3817853 1963498 1963498 defendant Marten John yeoman 587719 587719 Marten, John, of St Ives, Hunts, yeoman 0
3822093 1964803 1964803 defendant Heddyngley Thomas   587719 587719 Heddyngley, Thomas, of St Ives, Hunts, horse courser 0
3822095 1964804 1964804 defendant Heddyngley Thomas   587719 587719 Heddyngley, Thomas, of St Ives, Hunts, horse courser 0
3824760 1965617 1965617 defendant Bull Robert, junior husbandman 587719 587719 Bull, Robert, junior, of St Ives, Hunts, husbandman 0
3840911 1970725 1970725 defendant Reyner John tanner 587719 587719 Reyner, John, of St Ives, Hunts, tanner 0
3840917 1970726 1970726 defendant Reyner John tanner 587719 587719 Reyner, John, of St Ives, Hunts, tanner 0
3857392 1975947 1975947 defendant Marten John yeoman 587719 587719 Marten, John, of St Ives, Hunts, yeoman 1
3860838 1977117 1977117 defendant Martyn John yeoman 587719 587719 Martyn, John, of St Ives, Hunts, yeoman 0
3875106 1981908 1981908 defendant Martyn John yeoman 587719 587719 Martyn, John, of St Ives, Hunts, yeoman 0
3885681 1985469 1985469 defendant Marten John yeoman 587719 587719 Marten, John, of St Ives, Hunts, yeoman 1
3900999 1990561 1990561 defendant Shorte John butcher 587719 587719 Shorte, John, of St Ives, Hunts, butcher 0
3928584 1999901 1999901 defendant Syston Thomas tanner 587719 587719 Syston, Thomas, of St Ives, Hunts, tanner 0
3940123 2003714 2003714 defendant Jones Johh yeoman 587719 587719 Jones, Johh, of St Ives, Hunts, yeoman 0
3940126 2003715 2003715 defendant Jones John yeoman 587719 587719 Jones, John, of St Ives, Hunts, yeoman 0
3958009 2009866 2009866 defendant Jones John yeoman 587719 587719 Jones, John, of St Ives, Hunts, yeoman 0
3973141 2015177 2015177 defendant Johns John yeoman 587719 587719 Johns, John, of St Ives, Hunts, yeoman 0
3999404 2024549 2024549 plaintiff Fylbye Thomas (legal representative) 587719 587719 Fylbye, Thomas, of St Ives, Hunts, baker, executrix of 0
3999409 2024550 2024550 plaintiff Fylbye Thomas (legal representative) 587719 587719 Fylbye, Thomas, of St Ives, Hunts, baker, executrix of 0
4014374 2029860 2029860 plaintiff Scysson Robert yeoman 587719 587719 Scysson, Robert, of St Ives, Hunts, yeoman 0
4014393 2029868 2029868 plaintiff Sedgewick Roger yeoman 587719 587719 Sedgewick, Roger, of St Ives, Hunts, yeoman 0
4014395 2029869 2029869 plaintiff Sedgewicke Roger yeoman 587719 587719 Sedgewicke, Roger, of St Ives, Hunts, yeoman 0
4027082 2034331 2034331 defendant Dolphyn Humphrey fishmonger 587719 587719 Dolphyn, Humphrey, of St Ives, Hunts, fishmonger 0
4027086 2034332 2034332 defendant Dolphyn Humphrey fishmonger 587719 587719 Dolphyn, Humphrey, of St Ives, Hunts, fishmonger 0
4027525 2034489 2034489 defendant Gibson Thomas chapman 587719 587719 Gibson, Thomas, of St Ives, Hunts, chapman 2
4055435 2044337 2044337 defendant Downes George yeoman 587719 587719 Downes, George, of St Ives, Hunts, yeoman 1
4055438 2044338 2044338 defendant Downes George yeoman 587719 587719 Downes, George, of St Ives, Hunts, yeoman 1
4063287 2047164 2047164 defendant Blande John grocer 587719 587719 Blande, John, of St Ives, Hunts, grocer 0
4064967 2047754 2047754 defendant Perry Richard yeoman 587719 587719 Perry, Richard, of St Ives, Hunts, yeoman 5
4066616 2048355 2048355 defendant Gybson Thomas vintner 587719 587719 Gybson, Thomas, of St Ives, Hunts, vintner 0
4070177 2049624 2049624 defendant Atkynson Robert draper 587719 587719 Atkynson, Robert, of St Ives, Hunts, draper 0
4078165 2052492 2052492 defendant Cordall Thomas haberdasher 587719 587719 Cordall, Thomas, of St Ives, Hunts, haberdasher 11
4079083 2052819 2052819 defendant Chune John laborer or waterman 587719 587719 Chune, John, of St Ives, Hunts, laborer or waterman 0
4081571 2053714 2053714 defendant Burgis John chapman 587719 587719 Burgis, John, of St Ives, Hunts, chapman 2
4091815 2057366 2057366 defendant Burges John chapman 587719 587719 Burges, John, of St Ives, Hunts, chapman 0
4094031 2058194 2058194 defendant Tayler Thomas innkeeper 587719 587719 Tayler, Thomas, of St Ives, Hunts, innkeeper 1
4098127 2059657 2059657 plaintiff Hewar Margery widow 587719 587719 Margery his wife, alias Margery Lawrence, of St Ives, Hunts, widow 1
4103265 2061448 2061448 defendant Francklyne alias Wright Thomas yeoman 587719 587719 Francklyne alias Wright, Thomas, of St Ives, Hunts, yeoman 0
4127029 2069956 2069956 defendant Mason William husbandman 587719 587719 Mason, William, of St Ives, Hunts, husbandman 1
4173637 2086234 2086234 defendant Weston Henry tanner 587719 587719 Weston, Henry, of St Ives, Hunts, tanner 0
4173639 2086235 2086235 defendant Weston Henry tanner 587719 587719 Weston, Henry, of St Ives, Hunts, tanner 0
4177040 2087443 2087443 defendant Sissym or Sysson Robert yeoman 587719 587719 Sissym or Sysson, Robert, of St Ives, Hunts, yeoman 0
4184877 2090219 2090219 defendant Towers John chapman 587719 587719 Towers, John, of St Ives, Hunts, chapman 0
4190454 2092212 2092212 defendant Sissun Robert merchant 587719 587719 Sissun, Robert, of St Ives, Hunts, merchant 0
4196742 2094406 2094406 defendant Curles Thomas tanner 587719 587719 Curles, Thomas, of St Ives, Hunts, tanner 4
4200178 2095616 2095616 defendant Syssym or Sysson Robert yeoman 587719 587719 Syssym or Sysson, Robert, of St Ives, Hunts, yeoman 0
4206784 2097915 2097915 defendant Gybson Thomas yeoman 587719 587719 Gybson, Thomas, of St Ives, Hunts, yeoman 3
4230897 2106305 2106305 defendant Sedgwicke Roger yeoman 587719 587719 Sedgwicke, Roger, of St Ives, Hunts, yeoman 0
4236455 2108324 2108324 defendant Atkinson Robert vintner 587719 587719 Atkinson, Robert, of St Ives, Hunts, vintner 0
4260128 2116351 2116351 defendant Palmer Robert yeoman 587719 587719 Palmer, Robert, of St Ives, Hunts, yeoman 0
4265832 2118213 2118213 defendant Scisson John yeoman 587719 587719 Scisson, John, of St Ives, Hunts, yeoman 0
4276123 2121595 2121595 defendant Gardner Humphrey gent 587719 587719 Gardner, Humphrey, of St Ives, Hunts, gent 0
4279375 2122711 2122711 defendant Nicoles Henry yeoman 587719 587719 Nicoles, Henry, of St Ives, Hunts, yeoman 2
4281539 2123448 2123448 defendant Mowntayn Henry butcher 587719 587719 Mowntayn, Henry, of St Ives, Hunts, butcher 0
4289462 2126289 2126289 defendant Beeton Edward salter 587719 587719 Beeton, Edward, of St Ives, Hunts, or of London, salter 0
4297365 2129162 2129162 defendant Durant Giles tanner 587719 587719 Durant, Giles, of St Ives, Hunts, yeoman, tanner 0
4300522 2130279 2130279 defendant Scisson Robert gent 587719 587719 Scisson, Robert, of St Ives, Hunts, gent 0
4305484 2132054 2132054 defendant Jennyng Michael yeoman 587719 587719 Jennyng, Michael, of St Ives, Hunts, yeoman 3
4307019 2132596 2132596 defendant Atkynson Robert yeoman 587719 587719 Atkynson, Robert, of St Ives, Hunts, yeoman 1
4309180 2133366 2133366 defendant Sedgewicke Roger yeoman 587719 587719 (Sedgewicke, Roger, of St Ives, Hunts, yeoman 1
4328588 2139878 2139878 defendant Sedgewicke Roger yeoman 587719 587719 Sedgewicke, Roger, of St Ives, Hunts, yeoman 0
4329477 2140164 2140164 defendant Sedgewicke Roger yeoman 587719 587719 (Sedgewicke, Roger, of St Ives, Hunts, yeoman 1
4330256 2140423 2140423 defendant Durant Giles tanner 587719 587719 Durant, Giles, of St Ives, Hunts, tanner 0
4337820 2142979 2142979 defendant Gardner Humphrey gent 587719 587719 Gardner, Humphrey, of St Ives, Hunts, gent 0
4341754 2144391 2144391 defendant Downes George yeoman 587719 587719 Downes, George, of St Ives, Hunts, yeoman 1
4342549 2144668 2144668 defendant Hormyole William yeoman 587719 587719 Hormyole, William, of St Ives, Hunts, yeoman 0
4343592 2145038 2145038 defendant Geyton Thomas yeoman 587719 587719 Geyton, Thomas, of St Ives, Hunts, yeoman 2
4355506 2149147 2149147 defendant Kowelston Edward yeoman 587719 587719 Kowelston, Edward, of St Ives, Hunts, yeoman 0
4356106 2149357 2149357 defendant Atkins Robert vintner 587719 587719 Atkins, Robert, of St Ives, Hunts, vintner 3
4379577 2157786 2157786 defendant Knowleston Edward yeoman 587719 587719 Knowleston, Edward, of St Ives, Hunts, yeoman 0
4385905 2159980 2159980 defendant Atkinson Robert vintner 587719 587719 Atkinson, Robert, of St Ives, Hunts, vintner 0
4386724 2160235 2160235 defendant Denye William chapman 587719 587719 Denye, William, of St Ives, Hunts, yeoman, or of St Edes , chapman 0
4410210 2168016 2168016 defendant Gunnell Robert chapman 587719 587719 Gunnell, Robert, of St Ives, Hunts, chapman 0
4520761 2206834 2206834 defendant Draper Thomas   587719 587719 Draper, Thomas, of St Ives, Hunts 0
4651016 2246318 2246318 defendant Clerk John chapman 587719 587719 Clerk, John, of St Ives, Hunts, chapman 0
4653881 2247122 2247122 defendant Halywelle William maltman 587719 587719 Halywelle, William, of St Ives, Hunts, maltman 0
4680917 2259656 2259656 defendant Bocher John butcher 587719 587719 Bocher, John, of St Ives, Hunts, butcher 1
4690790 2262656 2262656 defendant Barker John dyer 587719 587719 Barker, John, of St Ives, Hunts, dyer 0
4692905 2263289 2263289 defendant Baker Richard water man 587719 587719 Baker, Richard, of St Ives, Hunts, water man 0
4698273 2264942 2264942 defendant Baker Richard chapman 587719 587719 Baker, Richard, of St Ives, Hunts, chapman 3
4698405 2264978 2264978 defendant Baker Richard chapman 587719 587719 Baker, Richard, of St Ives, Hunts, chapman 2
4707461 2267710 2267710 defendant Chesteyn John chapman 587719 587719 Chesteyn, John, of St Ives, Hunts, chapman 1
4710488 2268639 2268639 defendant Clerk Richard yeoman 587719 587719 Clerk, Richard, of St Ives, Hunts, yeoman 0
4756779 2282485 2282485 defendant Tylere Henry   587719 587719 Tylere, Henry, of St Ives, Hunts, spice seller 0
4757647 2282768 2282768 defendant Lokwode William chapman 587719 587719 Lokwode, William, of St ives, Hunts, chapman 1
4775077 2288197 2288197 defendant Makesey John merchant 587719 587719 Makesey, John, of St Ives, Hunts, merchant 2

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