names

162 rows where place_id = 595915

✎ 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
3622388 1874540 1874540 defendant Forest Richard butcher 595915 595915 Forest, Richard, of Hungerford, butcher 0
3622389 1874540 1874540 defendant Clyfford Robert tailor 595915 595915 Clyfford, Robert, of Hungerford, tailor 1
3622390 1874540 1874540 defendant Hogges Walter husbandman 595915 595915 Hogges, Walter, of Hungerford, husbandman 2
3653657 1911407 1911407 defendant Jenyns Alice widow 595915 595915 Jenyns, Alice, of Hungerford, widow 5
3656904 1912417 1912417 defendant Kyrton Jemferus butcher 595915 595915 Kyrton, Jemferus, of Hungerford, butcher 0
3656905 1912417 1912417 defendant Kyrton William butcher 595915 595915 Kyrton, William, of Hungerford, butcher 1
3680877 1920102 1920102 defendant Halle John yeoman 595915 595915 Halle, John, of Hungerford, yeoman 0
3681671 1920362 1920362 defendant Lovele George chapman 595915 595915 Lovele, George, of Hungerford, chapman 0
3681675 1920364 1920364 defendant Lovele or Lonele George chapman 595915 595915 Lovele or Lonele, George, of Hungerford, chapman 0
3681676 1920364 1920364 defendant Hayms Alice widow 595915 595915 Hayms, Alice, of Hungerford, widow 1
3717548 1931778 1931778 defendant Gliddesdale alias Edon John yeoman 595915 595915 Gliddesdale alias Edon, John, of Hungerford, yeoman 0
3728831 1935264 1935264 defendant Mason Thomas mercer 595915 595915 Mason, Thomas, of Hungerford, mercer 0
3743208 1939739 1939739 defendant Cok Edward clothman 595915 595915 Cok, Edward, of Hungerford, clothman 1
3743327 1939785 1939785 defendant Curre Ralph husbandman 595915 595915 Curre, Ralph, of Hungerford, husbandman 1
3760741 1945360 1945360 defendant Kyrton Janever yeoman 595915 595915 Kyrton, Janever, of Hungerford, yeoman 0
3796376 1956732 1956732 defendant Eden John yeoman 595915 595915 Eden, John, of Hungerford, yeoman 4
3802595 1958705 1958705 defendant Lovelake William yeoman 595915 595915 Lovelake, William, of Hungerford, yeoman 0
3928469 1999860 1999860 plaintiff Blownte Robert gent 595915 595915 Blownte, Robert, of Hungerford, gent 0
3946637 2005888 2005888 defendant Curre John yeoman 595915 595915 Curre, John, of Hungerford, yeoman 1
3947599 2006223 2006223 plaintiff Collyns or Collenge John mercer 595915 595915 Collyns or Collenge, John, of Hungerford, mercer 0
3949588 2006931 2006931 defendant Togy Roger mercer, administrators of 595915 595915 Roger Togy, of Hungerford, mercer, administrators of 0
3951334 2007533 2007533 defendant Jenynges Thomas yeoman 595915 595915 Jenynges, Thomas, of Hungerford, yeoman 0
3951417 2007558 2007558 defendant Waytt Robert cooper 595915 595915 Waytt, Robert, of Hungerford, cooper 1
3967019 2013090 2013090 defendant Browker Edward clerk 595915 595915 Browker, Edward, of Hungerford, clerk 2
3967020 2013090 2013090 defendant Passion Nicholas clothier 595915 595915 Passion, Nicholas, of Hungerford, clothier 3
3979701 2017493 2017493 defendant Collens John yeoman 595915 595915 Collens, John, of Hungerford, yeoman 0
4028012 2034671 2034671 plaintiff Collens Edward   595915 595915 Collens, Edward, of Hungerford 0
4028014 2034672 2034672 plaintiff Collens Edward   595915 595915 Collens, Edward, of Hungerford 0
4085917 2055240 2055240 defendant Curre or Cure Gilbert yeoman 595915 595915 Curre or Cure, Gilbert, of Hungerford, yeoman 0
4085918 2055240 2055240 defendant Cannon William yeoman 595915 595915 Cannon, William, of Hungerford, yeoman 1
4140387 2074808 2074808 defendant Penye Thomas   595915 595915 Penye, Thomas, of Hungerford, tallow chandler 0
4261910 2116935 2116935 defendant Pynnock John innholder 595915 595915 Pynnock, John, of Hungerford, innholder 0
4302165 2130876 2130876 defendant Collyns Edward yeoman 595915 595915 Collyns, Edward, of Hungerford, yeoman 1
4327987 2139681 2139681 defendant Churchman Roger yeoman 595915 595915 Churchman, Roger, of Hungerford, yeoman 0
4327988 2139681 2139681 defendant Churchman William yeoman 595915 595915 Churchman, William, of Hungerford, yeoman 1
4414199 2169349 2169349 defendant Multon John de shoemaker 595915 595915 Multon, John de, of Hungerford, shoemaker 0
4439931 2181769 2181769 defendant Pudde Geoffrey   595915 595915 Pudde, Geoffrey, of Hungerford 0
4440617 2181975 2181975 defendant Coterle Walter   595915 595915 Coterle, Walter, of Hungerford 2
4463996 2189411 2189411 defendant Staunton Robert   595915 595915 Staunton, Robert, of Hungerford 0
4464005 2189413 2189413 defendant Pod Geoffrey   595915 595915 Pod, Geoffrey, of Hungerford 0
4476205 2193220 2193220 defendant Dyer William dyer 595915 595915 Dyer, William, of Hungerford, dyer 1
4494713 2199041 2199041 defendant dyer William   595915 595915 dyer, William, of Hungerford 2
4502415 2201338 2201338 defendant Ropere William   595915 595915 Ropere, William, of Hungerford 0
4503251 2201582 2201582 defendant Knolle Thomas mercer 595915 595915 Knolle, Thomas, of Hungerford, mercer 0
4510571 2203769 2203769 defendant Courteour John   595915 595915 Courteour, John, of Hungerford 1
4519771 2206541 2206541 defendant Webbe Robert   595915 595915 Webbe, Robert, of Hungerford 4
4530991 2209987 2209987 defendant Knolle Thomas   595915 595915 Knolle, Thomas, of Hungerford 0
4537558 2212021 2212021 defendant Ferrour William   595915 595915 Ferrour, William, of Hungerford 0
4546101 2214725 2214725 defendant Dyere Alice   595915 595915 Dyere, Alice, of Hungerford 0
4549596 2215817 2215817 defendant Baker William   595915 595915 Baker, William, of Hungerford 3
4549642 2215820 2215820 defendant Breton Henry de   595915 595915 Breton, Henry de, of Hungerford 0
4549643 2215820 2215820 defendant Dyere William   595915 595915 Dyere, William, of Hungerford 1
4553616 2217057 2217057 defendant Paunchefote John   595915 595915 Paunchefote, John, of Hungerford 0
4556482 2217968 2217968 defendant Spencer William   595915 595915 Spencer, William, of Hungerford, servant of the vicar 2
4563296 2220092 2220092 defendant West Thomas   595915 595915 West, Thomas, of Hungerford 1
4568525 2221730 2221730 defendant Redhed John   595915 595915 Redhed, John, of Hungerford 0
4570298 2222284 2222284 defendant Diere John   595915 595915 Diere, John, of Hungerford 0
4588504 2227774 2227774 defendant Kolle Thomas   595915 595915 Kolle, Thomas, of Hungerford 0
4589822 2228183 2228183 defendant Charleford William   595915 595915 Charleford, William, of Hungerford 0
4591369 2228655 2228655 defendant Dyer Hugh   595915 595915 Dyer, Hugh, of Hungerford 0
4599237 2230974 2230974 defendant Dyer Simon   595915 595915 Dyer, Simon, of Hungerford 2
4601987 2231841 2231841 defendant Maldon Henry   595915 595915 Maldon, Henry, of Hungerford 0
4640166 2243237 2243237 defendant Warnewell Thomas   595915 595915 Warnewell, Thomas, of Hungerford 3
4641925 2243745 2243745 defendant Bocher Roger   595915 595915 Bocher, Roger, of Hungerford 4
4641929 2243745 2243745 defendant Oyghton John   595915 595915 Oyghton, John, of Hungerford 8
4644622 2244517 2244517 defendant Carpenter Richard   595915 595915 Carpenter, Richard, of Hungerford 2
4653743 2247093 2247093 defendant Devenyssh Robert tailor 595915 595915 Devenyssh, Robert, of Hungerford, tailor 5
4653753 2247093 2247093 defendant Welshe Robert tailor 595915 595915 together with Welshe, Robert, of Hungerford, tailor 15
4653764 2247096 2247096 defendant Clerk William   595915 595915 Clerk, William, of Hungerford, holy water clerk 0
4653766 2247096 2247096 defendant Devenyssh Robert tailor 595915 595915 Devenyssh, Robert, of Hungerford, tailor 2
4653782 2247096 2247096 defendant Wolshe Robert tailor 595915 595915 Wolshe, Robert, of Hungerford, tailor 18
4654150 2247180 2247180 defendant Ferrour or Smith William ostler 595915 595915 Ferrour or Smith, William, of Hungerford, ostler 2
4662052 2249607 2249607 defendant Pynell John ploughman 595915 595915 Pynell, John, of Hungerford, ploughman 0
4691159 2262754 2262754 defendant Smyth John husbandman 595915 595915 Smyth, John, of Hungerford, husbandman 5
4693737 2263542 2263542 defendant Kember John weaver 595915 595915 Kember, John, of Hungerford, weaver 1
4725966 2273407 2273407 defendant Frye John   595915 595915 Frye, John, of Hungerford, rope maker 1
4725969 2273408 2273408 defendant Dyghton John ploughman 595915 595915 Dyghton, John, of Hungerford, ploughman 0
4738494 2277131 2277131 defendant Boorde John carpenter 595915 595915 Boorde, John, of Hungerford, carpenter 0
4751762 2281005 2281005 defendant Napper Robert   595915 595915 Napper, Robert, of Hungerford, vicar 0
4765076 2285054 2285054 plaintiff Horshull William   595915 595915 Horshull, William, of Hungerford 0
4766124 2285395 2285395 defendant Peramour Roger husbandman 595915 595915 Peramour, Roger, of Hungerford, husbandman 1
4766125 2285395 2285395 defendant Peramour John husbandman 595915 595915 Peramour, John, of Hungerford, husbandman 2
4769065 2286305 2286305 defendant Napper Robert   595915 595915 Napper, Robert, of Hungerford, vicar 0
4781362 2290180 2290180 defendant Hasulden John husbandman 595915 595915 Hasulden, John, of Hungerford, husbandman 0
4790524 2293130 2293130 defendant Peramour Roger husbandman 595915 595915 Peramour, Roger, of Hungerford, husbandman 1
4790525 2293130 2293130 defendant Peramour John husbandman 595915 595915 Peramour, John, of Hungerford, husbandman 2
4798880 2295824 2295824 defendant Dyer John husbandman 595915 595915 Dyer, John, of Hungerford, husbandman 0
4798881 2295824 2295824 defendant Ferrour or Smith William husbandman 595915 595915 Ferrour or Smith, William, of Hungerford, husbandman 1
4824893 2303823 2303823 defendant Bocher William butcher 595915 595915 Bocher, William, of Hungerford, butcher 0
4836052 2307257 2307257 plaintiff Dyve Thomas   595915 595915 Dyve, Thomas, of Hungerford 0
4851066 2311782 2311782 defendant Toweker Henry fuller 595915 595915 Toweker, Henry, of Hungerford, fuller 0
4875049 2319147 2319147 defendant Bodycote John ostler 595915 595915 Bodycote, John, of Hungerford, ostler 0
4885798 2322429 2322429 defendant Gorewey John dyer 595915 595915 Gorewey, John, of Hungerford, dyer 0
4946431 2340877 2340877 defendant Jenyn John husbandman 595915 595915 Jenyn, John, of Hungerford, husbandman 0
4963895 2346111 2346111 defendant Canon John husbandman 595915 595915 Canon, John, of Hungerford, husbandman 0
4963897 2346112 2346112 defendant Canon John husbandman 595915 595915 Canon, John, of Hungerford, husbandman 0
4976625 2349966 2349966 defendant Peryn John fuller 595915 595915 Peryn, John, of Hungerford, fuller 0
4981782 2351468 2351468 defendant Feweterell Thomas husbandman 595915 595915 Feweterell, Thomas, of Hungerford, husbandman 3
4997875 2356223 2356223 defendant Hull Thomas fuller 595915 595915 Hull, Thomas, of Hungerford, fuller 0
5015479 2361409 2361409 defendant Payntour John scrivener 595915 595915 Payntour, John, of Hungerford, scrivener 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);