names

126 rows where place_id = 591175

✎ 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
3603591 1868791 1868791 defendant Chapman Thomas husbandman 591175 591175 Chapman, Thomas, of Foxton, husbandman 3
3619812 1873770 1873770 defendant Colman John husbandman 591175 591175 Colman, John, of Foxton, husbandman 0
3639532 1907172 1907172 defendant Chapman John yeoman 591175 591175 Chapman, John, of Foxton, yeoman 0
3639533 1907172 1907172 defendant Chapman Thomas yeoman 591175 591175 Chapman, Thomas, of Foxton, yeoman 1
3661515 1913873 1913873 defendant Purser John husbandman 591175 591175 Purser, John, of Foxton, husbandman 0
3663490 1914506 1914506 defendant Uyrle Robert butcher 591175 591175 Uyrle, Robert, of Foxton, butcher 1
3665494 1915158 1915158 defendant Virley William husbandman 591175 591175 Virley, William, of Foxton, husbandman 3
3717138 1931645 1931645 defendant Wille Thomas husbandman 591175 591175 Wille, Thomas, of Foxton, husbandman 1
3717139 1931645 1931645 defendant Sprigge Robert husbandman 591175 591175 Sprigge, Robert, of Foxton, husbandman 2
3760448 1945272 1945272 defendant Jordan Roger husbandman 591175 591175 Jordan, Roger, of Foxton, husbandman 0
3761057 1945460 1945460 defendant Chapman Thomas husbandman 591175 591175 Chapman, Thomas, of Foxton, husbandman 0
3794189 1956054 1956054 defendant Rayner William yeoman 591175 591175 Rayner, William, of Foxton, yeoman 0
3813628 1962177 1962177 defendant Chapman Thomas yeoman 591175 591175 Chapman, Thomas, of Foxton, yeoman 0
3847339 1972727 1972727 defendant Sherpe John husbandman 591175 591175 Sherpe, John, of Foxton, husbandman 3
3883137 1984622 1984622 defendant Richardys Robert husbandman 591175 591175 Richardys, Robert, of Foxton, husbandman 0
3962178 2011354 2011354 defendant Hall Alan tailor 591175 591175 Hall, Alan, of Foxton, tailor 0
4227916 2105246 2105246 defendant Fulthroppe Francis gent 591175 591175 Fulthroppe, Francis, of Foxton, gent 0
4429313 2173974 2173974 defendant Alice Mayhous   591175 591175 Alice, Mayhous, of Foxton, formerly wife of William 1
4446545 2183831 2183831 defendant Godelok William   591175 591175 Godelok, William, of Foxton 0
4446547 2183831 2183831 defendant Bocher John   591175 591175 Bocher, John, of Foxton 2
4446549 2183831 2183831 defendant Smyth William   591175 591175 Smyth, William, of Foxton 4
4446550 2183831 2183831 defendant Dagay John   591175 591175 Dagay, John, of Foxton 5
4446553 2183831 2183831 defendant Lawe Hugh   591175 591175 Lawe, Hugh, of Foxton 8
4478732 2194014 2194014 defendant Toukere John   591175 591175 Toukere, John, of Foxton 3
4503093 2201537 2201537 defendant Peyntour Richard   591175 591175 Peyntour, Richard, of Foxton 1
4631750 2240814 2240814 defendant Ormesby Thomas   591175 591175 Ormesby, Thomas, of Foxton 3
4636947 2242365 2242365 defendant Sweyn William   591175 591175 Sweyn, William, of Foxton 0
4643151 2244105 2244105 defendant Paton Roger weaver 591175 591175 Paton, Roger, of Foxton, weaver 0
4644837 2244557 2244557 defendant atte Welle John   591175 591175 atte Welle, John, of Foxton 0
4652246 2246648 2246648 defendant Caye William husbandman 591175 591175 Caye, William, of Foxton, husbandman 3
4652248 2246648 2246648 defendant Ormesby Thomas husbandman 591175 591175 Ormesby, Thomas, of Foxton, husbandman 5
4653141 2246919 2246919 defendant Ormysby John yeoman 591175 591175 Ormysby, John, of Foxton, yeoman 0
4654265 2247214 2247214 defendant Kay John ploughman 591175 591175 Kay, John, of Foxton, ploughman 0
4654266 2247214 2247214 defendant Lowe John ploughman 591175 591175 Lowe, John, of Foxton, ploughman 1
4654267 2247214 2247214 defendant Calffe Richard ploughman 591175 591175 Calffe, Richard, of Foxton, ploughman 2
4654268 2247214 2247214 defendant Raymund Robert ploughman 591175 591175 Raymund, Robert, of Foxton, ploughman 3
4654269 2247214 2247214 defendant Ormesby Thomas ploughman 591175 591175 Ormesby, Thomas, of Foxton, ploughman 4
4654270 2247214 2247214 defendant Kay William ploughman 591175 591175 Kay, William, of Foxton, ploughman 5
4654271 2247214 2247214 defendant Kyng William ploughman 591175 591175 Kyng, William, of Foxton, ploughman 6
4654337 2247231 2247231 defendant Rayner Robert thatcher 591175 591175 Rayner, Robert, of Foxton, thatcher 0
4654338 2247231 2247231 defendant Graveley John ploughman 591175 591175 Graveley, John, of Foxton, ploughman 1
4654339 2247231 2247231 defendant Baker John husbandman 591175 591175 Baker, John, of Foxton, husbandman 2
4654344 2247231 2247231 defendant Shepherd William husbandman 591175 591175 Shepherd, William, of Foxton, husbandman 7
4666648 2251051 2251051 defendant Annes or Aunes John tailor 591175 591175 Annes or Aunes, John, of Foxton, tailor 0
4666649 2251051 2251051 defendant Turgys Thomas husbandman 591175 591175 Turgys, Thomas, of Foxton, husbandman 1
4667337 2255511 2255511 defendant Smeton John husbandman 591175 591175 Smeton, John, of Foxton, husbandman 1
4667623 2255586 2255586 plaintiff atte Well John   591175 591175 atte Well, John, of Foxton 0
4667626 2255586 2255586 defendant Rogerson Roger husbandman 591175 591175 Rogerson, Roger, of Foxton, husbandman 2
4667627 2255586 2255586 defendant William Roger husbandman 591175 591175 William, Roger, of Foxton, husbandman 3
4667628 2255586 2255586 defendant Lambard Thomas husbandman 591175 591175 Lambard, Thomas, of Foxton, husbandman 4
4667629 2255586 2255586 defendant Lambard Roger husbandman 591175 591175 Lambard, Roger, of Foxton, husbandman 5
4667630 2255587 2255587 plaintiff atte Well John   591175 591175 atte Well, John, of Foxton 0
4667631 2255587 2255587 defendant del Grene Roger husbandman 591175 591175 del Grene, Roger, of Foxton, husbandman 0
4669959 2256301 2256301 defendant Kaye William husbandman 591175 591175 Kaye, William, of Foxton, husbandman 1
4679540 2259217 2259217 defendant Dokefeld George smith 591175 591175 Dokefeld, George, of Foxton, smith 1
4687933 2261791 2261791 defendant Deynes John yeoman 591175 591175 Deynes, John, of Foxton, yeoman 3
4692661 2263219 2263219 plaintiff atte Well John   591175 591175 atte Well, John, of Foxton 0
4692664 2263219 2263219 defendant Roggerson Roger husbandman 591175 591175 together with Roggerson, Roger, of Foxton, husbandman 2
4692665 2263219 2263219 defendant William Roger husbandman 591175 591175 William, Roger, of Foxton, husbandman 3
4692666 2263219 2263219 defendant Lambard Thomas husbandman 591175 591175 Lambard, Thomas, of Foxton, husbandman 4
4692667 2263219 2263219 defendant Lambard Roger husbandman 591175 591175 Lambard, Roger, of Foxton, husbandman 5
4692765 2263249 2263249 defendant Kaye William husbandman 591175 591175 Kaye, William, of Foxton, husbandman 0
4694083 2263651 2263651 defendant Kaye William husbandman 591175 591175 Kaye, William, of Foxton, husbandman 0
4694084 2263651 2263651 defendant Kaye John husbandman 591175 591175 Kaye, John, of Foxton, brother of William, husbandman 1
4704850 2266895 2266895 plaintiff Kay William   591175 591175 Kay, William, of Foxton 0
4704898 2266908 2266908 defendant Amys John husbandman 591175 591175 Amys, John, of Foxton, husbandman 2
4704899 2266908 2266908 defendant Wryght John husbandman 591175 591175 Wryght, John, of Foxton, husbandman 3
4705185 2266991 2266991 defendant Smyth George smith 591175 591175 Smyth, George, of Foxton, smith 2
4717484 2270804 2270804 defendant Shepherd William husbandman 591175 591175 Shepherd, William, of Foxton, husbandman 0
4718045 2270984 2270984 defendant Shephert William husbandman 591175 591175 Shephert, William, of Foxton, husbandman 0
4718128 2271010 2271010 defendant del Grene Roger husbandman 591175 591175 del Grene, Roger, of Foxton, husbandman 0
4733005 2275502 2275502 defendant atte Welle John husbandman 591175 591175 atte Welle, John, of Foxton, husbandman 0
4739259 2277367 2277367 defendant atte Welle John husbandman 591175 591175 atte Welle, John, of Foxton, husbandman 0
4740196 2277645 2277645 defendant Sadyngton John husbandman 591175 591175 Sadyngton, John, of Foxton, husbandman 1
4769708 2286499 2286499 defendant Wryght John husbandman 591175 591175 Wryght, John, of Foxton, husbandman 3
4789695 2292845 2292845 defendant Shepherd William husbandman 591175 591175 Shepherd, William, of Foxton, husbandman 0
4795205 2294648 2294648 defendant Kaye John husbandman 591175 591175 Kaye, John, of Foxton, husbandman 4
4801246 2296575 2296575 defendant atte Welle John husbandman 591175 591175 atte Welle, John, of Foxton, husbandman 0
4803975 2297426 2297426 defendant Wrotham John laborer 591175 591175 Wrotham, John, of Foxton, laborer 0
4829578 2305292 2305292 defendant Carter Richard farmer 591175 591175 Carter, Richard, of Foxton, farmer 0
4874418 2318942 2318942 defendant Carter Richard husbandman 591175 591175 Carter, Richard, of Foxton, husbandman 0
4884479 2322048 2322048 defendant Ormysby William laborer 591175 591175 Ormysby, William, of Foxton, laborer 0
4884480 2322048 2322048 defendant Spenser John laborer 591175 591175 Spenser, John, of Foxton, laborer 1
4906119 2328506 2328506 defendant Kaye John husbandman 591175 591175 Kaye, John, of Foxton, husbandman 3
4908991 2329357 2329357 plaintiff Baker John   591175 591175 Baker, John, of Foxton, administrators of 0
4918370 2332263 2332263 defendant Wrotheham John husbandman 591175 591175 Wrotheham, John, of Foxton, husbandman 0
4929655 2335691 2335691 defendant Malet James husbandman 591175 591175 Malet, James, of Foxton, husbandman 1
4983358 2351928 2351928 defendant Ilyff John husbandman 591175 591175 Ilyff, John, of Foxton, husbandman 2
4985075 2352464 2352464 defendant Umfray John husbandman 591175 591175 Umfray, John, of Foxton, husbandman 2
5002551 2357658 2357658 defendant Wytyng Thomas husbandman 591175 591175 Wytyng, Thomas, of Foxton, husbandman 4
5004991 2358357 2358357 defendant Harecourte Roger husbandman 591175 591175 Harecourte, Roger, of Foxton, husbandman 0
5004992 2358357 2358357 defendant Broke John husbandman 591175 591175 Broke, John, of Foxton, husbandman 1
5055125 2373106 2373106 defendant Wrathm John weaver 591175 591175 Wrathm, John, of Foxton, weaver 1
5064729 2375990 2375990 defendant Hunne Richard husbandman 591175 591175 Hunne, Richard, of Foxton, husbandman 3
5093829 2384595 2384595 defendant Broke John husbandman 591175 591175 Broke, John, of Foxton, husbandman 0
5093830 2384595 2384595 defendant Roo John husbandman 591175 591175 Roo, John, of Foxton, husbandman 1
5116576 2391280 2391280 defendant Dere Thomas husbandman 591175 591175 Dere, Thomas, of Foxton, husbandman 5
5116577 2391280 2391280 defendant Dere Joan singlewoman 591175 591175 Dere, Joan, of Foxton, singlewoman 6
5116578 2391280 2391280 defendant Welles John husbandman 591175 591175 Welles, John, of Foxton, husbandman 7
5118797 2391929 2391929 defendant A Grene Richard husbandman 591175 591175 A Grene, Richard, of Foxton, husbandman 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);