names

140 rows where place_id = 597337

✎ 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
3602821 1868553 1868553 plaintiff Clerk Thomas   597337 597337 Clerk, Thomas, of Potton tallow chandler 0
3602837 1868557 1868557 plaintiff Clerke Thomas   597337 597337 Clerke, Thomas, of Potton, tallow chandler 0
3628182 1903669 1903669 defendant Maye Richard husbandman 597337 597337 Maye, Richard, of Potton, husbandman 2
3630368 1904335 1904335 defendant Pery Nicholas yeoman 597337 597337 Pery, Nicholas, of Potton, yeoman 1
3662513 1914191 1914191 defendant Cowper Thomas yeoman 597337 597337 Cowper, Thomas, of Potton, yeoman 2
3678982 1919496 1919496 defendant Cowper Thomas husbandman 597337 597337 Cowper, Thomas, of Potton, husbandman 2
3695347 1924769 1924769 defendant Jon William husbandman 597337 597337 Jon, William, of Potton, husbandman 0
3695348 1924769 1924769 defendant Harper Thomas laborer 597337 597337 Harper, Thomas, of Potton, laborer 1
3712861 1930342 1930342 defendant Yon William husbandman 597337 597337 Yon, William, of Potton, husbandman 0
3712862 1930342 1930342 defendant Yon Richard husbandman 597337 597337 Yon, Richard, of Potton, husbandman 1
3732005 1936240 1936240 defendant Lyon John courser 597337 597337 Lyon, John, of Potton, courser 1
3743576 1939865 1939865 defendant Watson William tailor 597337 597337 Watson, William, of Potton, tailor 0
3748506 1941468 1941468 defendant Harbard alias Barker Edward yeoman 597337 597337 Harbard alias Barker, Edward, of Potton, yeoman 1
3750375 1942037 1942037 defendant Couper Thomas woolman 597337 597337 Couper, Thomas, of Potton, woolman 1
3762909 1946033 1946033 defendant Harvard Edward husbandman 597337 597337 Harvard, Edward, of Potton, husbandman 1
3774420 1949722 1949722 defendant Jarberd Edmund yeoman 597337 597337 Jarberd, Edmund, of Potton, yeoman 0
3774807 1949848 1949848 defendant Manley Richard mercer 597337 597337 Manley, Richard, of Potton, mercer 0
3786275 1953504 1953504 defendant Butler John husbandman 597337 597337 Butler, John, of Potton, husbandman 0
3786279 1953504 1953504 defendant Herper Thomas husbandman 597337 597337 Herper, Thomas, of Potton, husbandman 4
3795410 1956436 1956436 defendant Harper Thomas fisher 597337 597337 Harper, Thomas, of Potton, fisher 0
3798895 1957570 1957570 defendant Manley Richard mercer 597337 597337 Manley, Richard, of Potton, mercer 0
3809038 1960708 1960708 defendant Manley Richard mercer 597337 597337 Manley, Richard, of Potton, mercer 0
3862001 1977475 1977475 defendant Knott John wheeler 597337 597337 Knott, John, of Potton, wheeler 0
3873494 1981350 1981350 defendant Carleton Ralph laborer 597337 597337 Carleton, Ralph, of Potton, laborer 1
3878630 1983098 1983098 defendant Ducke John butcher 597337 597337 Ducke, John, of Potton, butcher 2
3949318 2006831 2006831 defendant Pennyfather Thomas yeoman 597337 597337 Pennyfather, Thomas, of Potton, yeoman 0
3951630 2007624 2007624 defendant Penyfather Thomas yeoman 597337 597337 Penyfather, Thomas, of Potton, husbandman, or of Gransdon Parva, Cams, yeoman 0
3959423 2010380 2010380 defendant Elis William carrier 597337 597337 Elis, William, of Potton, carrier 1
4063874 2047362 2047362 defendant Izard John maltster 597337 597337 Izard, John, of Potton, maltster 0
4106158 2062498 2062498 defendant Walker Robert chapman 597337 597337 Walker, Robert, of Potton, chapman 0
4123394 2068670 2068670 defendant Reynold George yeoman 597337 597337 Reynold, George, of Potton, yeoman 0
4169028 2084662 2084662 defendant Perrett John yeoman 597337 597337 Perrett, John, of Potton, yeoman 0
4185732 2090512 2090512 defendant Maise or Mayse Peter yeoman 597337 597337 Maise or Mayse, Peter, of Potton, yeoman 1
4192429 2092908 2092908 defendant Perrett John yeoman 597337 597337 Perrett, John, of Potton, yeoman 0
4262559 2117143 2117143 defendant Bramfeild James gent 597337 597337 Bramfeild, James, of Potton, or of Eyworth, Beds, gent 3
4283183 2124018 2124018 defendant Zouch Richard gent 597337 597337 Zouch, Richard, of Potton, gent 0
4348533 2146739 2146739 defendant Forrest John, senior butcher 597337 597337 Forrest, John, senior, of Potton, yeoman, butcher 0
4348534 2146739 2146739 defendant Forrest John, junior butcher 597337 597337 Forrest, John, junior, of Potton, yeoman, butcher 1
4356604 2149543 2149543 defendant Bonest alias Abraham Richard yeoman 597337 597337 Bonest alias Abraham, Richard, of Potton, yeoman 0
4369071 2154004 2154004 defendant Hopkyns alias Searle Thomas husbandman 597337 597337 Hopkyns alias Searle, Thomas, of Potton, husbandman 0
4461864 2188777 2188777 plaintiff Stratton Richard de   597337 597337 Stratton, Richard de, of Potton, parson 0
4461866 2188778 2188778 plaintiff Stratton Richard   597337 597337 Stratton, Richard, of Potton, parson 0
4497426 2199842 2199842 plaintiff Doole William   597337 597337 Doole, William, of Potton, on his own account 0
4524623 2208035 2208035 defendant Juel John   597337 597337 Juel, John, of Potton, son of Richard 0
4563350 2220109 2220109 defendant Warner William   597337 597337 Warner, William, of Potton 2
4563354 2220110 2220110 defendant Warner William   597337 597337 Warner, William, of Potton 2
4628851 2239953 2239953 defendant Catour Nicholas   597337 597337 Catour, Nicholas, of Potton 3
4643362 2244164 2244164 defendant Gurnare Richard   597337 597337 Gurnare, Richard, of Potton 0
4645378 2244719 2244719 defendant Catour Nicholas butcher 597337 597337 Catour, Nicholas, of Potton, butcher 1
4647508 2245332 2245332 defendant Catur Nicholas   597337 597337 Catur, Nicholas, of Potton 0
4663977 2250219 2250219 plaintiff Gurnard Richard   597337 597337 Gurnard, Richard, of Potton 0
4672160 2256940 2256940 plaintiff Clement Walter   597337 597337 Clement, Walter, of Potton 0
4677425 2258556 2258556 defendant Heyne Richard yeoman 597337 597337 Heyne, Richard, of Potton, yeoman 0
4686579 2261412 2261412 plaintiff Smyth Robert butcher 597337 597337 Smyth, Robert, of Potton, butcher 0
4703518 2266482 2266482 defendant Smyth Robert butcher 597337 597337 Smyth, Robert, of Potton, butcher 1
4704579 2266809 2266809 defendant Gurnard Richard husbandman 597337 597337 Gurnard, Richard, of Potton, husbandman 0
4704655 2266836 2266836 plaintiff Smyth Robert   597337 597337 Smyth, Robert, of Potton 1
4742678 2278367 2278367 defendant Bocher Robert yeoman 597337 597337 Bocher, Robert, of Potton, yeoman 2
4748135 2279966 2279966 defendant Heynes Richard yeoman 597337 597337 Heynes, Richard, of potton, yeoman 0
4748136 2279966 2279966 defendant Launce William husbandman 597337 597337 Launce, William, of Potton, husbandman 1
4755572 2282122 2282122 defendant Bocher Robert butcher 597337 597337 Bocher, Robert, of Potton, butcher 0
4791723 2293507 2293507 defendant Pekkeworth John husbandman 597337 597337 Pekkeworth, John, of Potton, husbandman 0
4797162 2295285 2295285 defendant Bocher Robert butcher 597337 597337 Bocher, Robert, of Potton, butcher 0
4817380 2301521 2301521 defendant Bocher Robert butcher 597337 597337 Bocher, Robert, of Potton, butcher 0
4838264 2307886 2307886 defendant Fayreman William husbandman 597337 597337 Fayreman, William, of Potton, husbandman 1
4838269 2307887 2307887 defendant Fayreman William husbandman 597337 597337 Fayreman, William, of Potton, husbandman 1
4839808 2308362 2308362 defendant Gurnard John husbandman 597337 597337 Gurnard, John, of Potton, husbandman 2
4849133 2311203 2311203 defendant Flemyng Simon mercer 597337 597337 Flemyng, Simon, of Potton, mercer 0
4853227 2312427 2312427 defendant Bocher Robert butcher 597337 597337 Bocher, Robert, of Potton, butcher 0
4855905 2313220 2313220 defendant Bocher Robert butcher 597337 597337 Bocher, Robert, of Potton, butcher 0
4865516 2316178 2316178 defendant Fayreman William husbandman 597337 597337 Fayreman, William, of Potton, husbandman 1
4874554 2318986 2318986 defendant Gurnard Richard husbandman 597337 597337 Gurnard, Richard, of Potton, husbandman 1
4876799 2319715 2319715 defendant Flemyng Simon mercer 597337 597337 Flemyng, Simon, of Potton, mercer 0
4919915 2332739 2332739 plaintiff Horle Thomas   597337 597337 Horle, Thomas, of Potton 0
4919916 2332739 2332739 defendant Mangles Bowus husbandman 597337 597337 Mangles, Bowus, of Potton, husbandman 0
4934621 2337221 2337221 defendant Bocher Robert butcher 597337 597337 Bocher, Robert, of Potton, butcher 1
4934839 2337296 2337296 defendant Grenefeld Richard courser 597337 597337 Grenefeld, Richard, of Potton, courser 0
4944938 2340405 2340405 defendant Halle Richard   597337 597337 Halle, Richard, of Potton, bailiff 4
4974800 2349434 2349434 defendant Bocher Robert husbandman 597337 597337 Bocher, Robert, of Potton, husbandman 1
4982963 2351819 2351819 defendant Horle Thomas husbandman 597337 597337 Horle, Thomas, of Potton, husbandman 1
4986522 2352897 2352897 defendant Bocher Robert husbandman 597337 597337 Bocher, Robert, of Potton, husbandman 0
4986523 2352897 2352897 defendant Whyte Thomas husbandman 597337 597337 Whyte, Thomas, of Potton, husbandman 1
5013841 2360899 2360899 defendant Ferne John barber 597337 597337 Ferne, John, of Potton, barber 0
5015733 2361486 2361486 defendant Whyte Thomas husbandman 597337 597337 Whyte, Thomas, of Potton, husbandman 1
5023268 2363709 2363709 defendant Whytede Thomas husbandman 597337 597337 Whytede, Thomas, of Potton, husbandman 1
5023861 2363891 2363891 defendant Bocher Robert butcher 597337 597337 Bocher, Robert, of Potton, butcher 1
5055317 2373174 2373174 defendant Pekworth John husbandman 597337 597337 (Pekworth, John, of Potton, husbandman 3
5093761 2384574 2384574 defendant Warner Thomas husbandman 597337 597337 Warner, Thomas, of Potton, husbandman 3
5093765 2384574 2384574 defendant Rotour Henry husbandman 597337 597337 Rotour, Henry, of Potton, husbandman 7
5094542 2384815 2384815 defendant Grenefeld John sherman 597337 597337 Grenefeld, John, of Potton, sherman 0
5171672 2407434 2407434 defendant Clerk Robert yeoman 597337 597337 Clerk, Robert, of Potton, yeoman 1
5190344 2412918 2412918 defendant Worlyche William yeoman 597337 597337 Worlyche, William, of Potton, yeoman 0
5190345 2412918 2412918 defendant Clerk Robert yeoman 597337 597337 Clerk, Robert, of Potton, yeoman 1
5190936 2413097 2413097 defendant Atwode John carpenter 597337 597337 Atwode, John, of Potton, carpenter 0
5190946 2413099 2413099 defendant Atwode John carpenter 597337 597337 Atwode, John, of Potton, carpenter 2
5207165 2417836 2417836 defendant Atwode John carpenter 597337 597337 Atwode, John, of Potton, carpenter 2
5214078 2419846 2419846 defendant Pekworth John husbandman 597337 597337 Pekworth, John, of Potton, husbandman 3
5217956 2420986 2420986 defendant Pekworth Thomas chaplain 597337 597337 Pekworth, Thomas, of Potton, chaplain 0
5227252 2423600 2423600 defendant Rotour Henry yeoman 597337 597337 Rotour, Henry, of Potton, yeoman 0
5234251 2425605 2425605 defendant Kylworth John husbandman 597337 597337 Kylworth, John, of Potton, 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);