names

405 rows where place_id = 594218

✎ 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
3615135 1872379 1872379 defendant Barleman Thomas roper 594218 594218 Barleman, Thomas, of St Neots, roper 0
3617400 1873061 1873061 defendant Thlewelyn David yeoman 594218 594218 Thlewelyn, David, of St Neots, yeoman 0
3620633 1874032 1874032 defendant Basse William chapman 594218 594218 Basse, William, of St Neots, or of Godmanchester, Hunts, chapman 0
3648638 1909961 1909961 defendant Canon Walter fuller 594218 594218 Canon, Walter, of St Neots, fuller 2
3650561 1910543 1910543 defendant Canon Walter fuller 594218 594218 Canon, Walter, of St Neots, fuller 0
3651355 1910789 1910789 defendant Woderuff Thomas husbandman 594218 594218 Woderuff, Thomas, of St Neots, husbandman 0
3664064 1914711 1914711 plaintiff (not given) John prior of Raundes 594218 594218 Raundes, John, of St Neots, prior of the Monastery & rector of St Andrew's church in Barton Bendysh, Norf 0
3669271 1916327 1916327 defendant Clerk Richard baker 594218 594218 Clerk, Richard, of St Neots, baker 1
3674403 1918039 1918039 defendant Alyngham Thomas butcher 594218 594218 Alyngham, Thomas, of St Neots, butcher 0
3678765 1919427 1919427 plaintiff Norton John (legal representative) 594218 594218 Norton, John, of St Neots, yeoman, executors of 0
3678769 1919428 1919428 plaintiff Norton John (legal representative) 594218 594218 Norton, John, of St Neots, yeoman, executors of 0
3680137 1919857 1919857 defendant Hebden Robert miller 594218 594218 Hebden, Robert, of St Neots, miller 0
3682530 1920639 1920639 defendant Eyre Robert husbandman 594218 594218 Eyre, Robert, of St Neots, husbandman 0
3684688 1921342 1921342 defendant Gold Thomas gent 594218 594218 Gold, Thomas, of St Neots, gent 3
3684817 1921388 1921388 defendant Foster John glover 594218 594218 Foster, John, of St Neots, glover 0
3695658 1924873 1924873 defendant Wolley Edward miller 594218 594218 Wolley, Edward, of St Neots, miller 0
3696815 1925228 1925228 defendant Eyer Robert husbandman 594218 594218 Eyer, Robert, of St Neots, husbandman 2
3709121 1929151 1929151 defendant Gylmyn Thomas (legal representative) 594218 594218 Gylmyn, Thomas, of St Neots, gent, executor of 0
3711902 1930038 1930038 defendant Payn Robert shoemaker 594218 594218 Payn, Robert, of St Neots, shoemaker 3
3725274 1934195 1934195 defendant Fyssh John laborer 594218 594218 Fyssh, John, of St Neots, laborer 0
3727083 1934737 1934737 defendant Geffrey Gilbert mercer 594218 594218 Geffrey, Gilbert, of St Neots, mercer 1
3727084 1934737 1934737 defendant Payne Robert shoemaker 594218 594218 Payne, Robert, of St Neots, shoemaker 2
3735495 1937340 1937340 defendant Alyngham Thomas butcher 594218 594218 Alyngham, Thomas, of St Neots, butcher 0
3743517 1939848 1939848 defendant Awode Richard baker 594218 594218 Awode, Richard, of St Neots, baker 2
3756179 1943892 1943892 defendant Pecke William husbandman 594218 594218 Pecke, William, of St Neots, husbandman 0
3756180 1943892 1943892 defendant Freman Henry pewterer 594218 594218 Freman, Henry, of St Neots, pewterer 1
3775655 1950134 1950134 defendant Scotte Richard husbandman 594218 594218 Scotte, Richard, of St Neots, husbandman 0
3790170 1954745 1954745 plaintiff Walbot William, senior yeoman 594218 594218 Walbot, William, senior, of St Neots, yeoman 0
3815358 1962719 1962719 defendant Chamberleyn Thomas yeoman 594218 594218 Chamberleyn, Thomas, of St Neots, yeoman 0
3815359 1962719 1962719 defendant Foster John (legal representative) 594218 594218 Foster, John, of St Neots, glover, executor of 1
3824271 1965465 1965465 defendant Norton Richard yeoman 594218 594218 Norton, Richard, of St Neots, yeoman 0
3853490 1974717 1974717 defendant Sympson William haberdasher 594218 594218 Sympson, William, of St Neots, haberdasher 0
3853493 1974718 1974718 defendant Sympson William habersdasher 594218 594218 Sympson, William, of St Neots, habersdasher 0
3859914 1976821 1976821 defendant Chamberleyne Thomas yeoman 594218 594218 Chamberleyne, Thomas, of St Neots, yeoman 0
3862036 1977490 1977490 defendant Lamkyn John husbandman 594218 594218 Lamkyn, John, of St Neots, husbandman 0
3865024 1978502 1978502 defendant Bettys William butcher 594218 594218 Bettys, William, of St Neots, butcher 1
3868700 1979774 1979774 defendant Dyxy Martin butcher 594218 594218 Dyxy, Martin, of St Neots, butcher 1
3868701 1979774 1979774 defendant Clenton Roger butcher 594218 594218 Clenton, Roger, of St Neots, butcher 2
3886505 1985741 1985741 defendant Tony alias Tunney Thomas gent 594218 594218 Tony alias Tunney, Thomas, of St Neots, gent 1
3895164 1988590 1988590 defendant Peyn Robert yeoman 594218 594218 Peyn, Robert, of St Neots, yeoman 3
3895167 1988591 1988591 defendant Payne Robert yeoman 594218 594218 Payne, Robert, of St Neots, yeoman 0
3896522 1989044 1989044 defendant Thornton William glover 594218 594218 Thornton, William, of St Neots, glover 1
3897884 1989497 1989497 defendant Mercer Francis   594218 594218 Mercer, Francis, of St Neots, Hunts, fletcher, son of Mercer, John 0
3935922 2002330 2002330 defendant Dyxsye Martin chapman 594218 594218 Dyxsye, Martin, of St Neots, chapman 1
3945466 2005491 2005491 defendant Carpynter Francis glover 594218 594218 Carpynter, Francis, of St Neots, glover 1
3945467 2005491 2005491 defendant Hatley Joan gentlewoman 594218 594218 Hatley, Joan, of St Neots, widow, gentlewoman 2
3953345 2008238 2008238 defendant Chapman Thomas husbandman 594218 594218 Chapman, Thomas, of St Neots, husbandman 1
3960693 2010839 2010839 defendant Newman Thomas yeoman 594218 594218 Newman, Thomas, of St Neots, yeoman 1
3960694 2010839 2010839 defendant Newman Hugh fisherman 594218 594218 Newman, Hugh, of St Neots, fisherman 2
3965199 2012439 2012439 defendant Goode Robert husbandman 594218 594218 Goode, Robert, of St Neots, husbandman 1
3994776 2022882 2022882 defendant Newman Thomas, senior chapman 594218 594218 Newman, Thomas, senior, of St Neots, chapman 1
4096601 2059112 2059112 defendant Bye John dyer 594218 594218 Bye, John, of St Neots, dyer 0
4096602 2059112 2059112 defendant Thomas Lewis yeoman 594218 594218 Thomas, Lewis, of St Neots, yeoman 1
4098055 2059632 2059632 defendant Ibbat William chapman 594218 594218 Ibbat, William, of St Neots, chapman 1
4120256 2067526 2067526 defendant Cobbe Thomas yeoman 594218 594218 Cobbe, Thomas, of St Neots, yeoman 1
4122540 2068365 2068365 defendant Newman George mercer 594218 594218 Newman, George, of St Neots, mercer 1
4122541 2068365 2068365 defendant Corvett Robert pewterer 594218 594218 Corvett, Robert, of St Neots, pewterer 2
4128951 2070653 2070653 defendant Crappe John husbandman 594218 594218 Crappe, John, of St Neots, husbandman 0
4170981 2085332 2085332 defendant Newman Hugh yeoman 594218 594218 Newman, Hugh, of St Neots, yeoman 0
4176715 2087327 2087327 defendant Charter William whitawer 594218 594218 Charter, William, of St Neots, laborer, whitawer 0
4176717 2087328 2087328 defendant Charter William baker 594218 594218 Charter, William, of St Neots, baker 0
4177846 2087725 2087725 defendant Carter or Charter William baker 594218 594218 Carter or Charter, William, of St Neots, baker 0
4198791 2095138 2095138 defendant Newman Hugh   594218 594218 Newman, Hugh, of St Neots, Hunts yeoman 0
4271412 2120016 2120016 defendant Gyttyns John yeoman 594218 594218 Gyttyns, John, of St Neots, yeoman 0
4291878 2127171 2127171 defendant Ibbett Thomas chapman 594218 594218 Ibbett, Thomas, of St Neots, chapman 1
4295477 2128469 2128469 defendant Elles Robert butcher 594218 594218 Elles, Robert, of St Neots, butcher 0
4304939 2131865 2131865 defendant Ibbotte Thomas   594218 594218 Ibbotte, Thomas, of St Neots, linen draper 1
4307543 2132775 2132775 defendant Gyles Edward yeoman 594218 594218 Gyles, Edward, of St Neots, yeoman 1
4334938 2141948 2141948 defendant Backster Henry scrivener 594218 594218 Backster, Henry, of St Neots, scrivener 2
4336993 2142666 2142666 defendant Dixie William butcher 594218 594218 Dixie, William, of St Neots, butcher 0
4340994 2144128 2144128 defendant Ibbott William haberdasher 594218 594218 Ibbott, William, of St Neots, haberdasher 0
4342215 2144560 2144560 defendant Hatley Richard weaver 594218 594218 Hatley, Richard, of St Neots, weaver 0
4342216 2144560 2144560 defendant Marshe Martin tailor 594218 594218 Marshe, Martin, of St Neots, tailor 1
4345880 2145822 2145822 defendant Everell William husbandman 594218 594218 Everell, William, of St Neots, husbandman 0
4345882 2145822 2145822 defendant Marsh Martin husbandman 594218 594218 Marsh, Martin, of St Neots, husbandman 2
4347903 2146519 2146519 defendant Smyth Edward gent 594218 594218 Smyth, Edward, of St Neots, gent 0
4348262 2146642 2146642 defendant Hatley John yeoman 594218 594218 Hatley, John, of St Neots, yeoman 0
4352321 2148048 2148048 defendant Stype Edward yeoman 594218 594218 Stype, Edward, of St Neots, yeoman 0
4352590 2148141 2148141 defendant Ebbatt or Ibatt William mercer 594218 594218 Ebbatt or Ibatt, William, of St Neots, mercer 0
4371788 2154970 2154970 defendant Smyth Edward gent 594218 594218 Smyth, Edward, of St Neots, gent 0
4372927 2155393 2155393 defendant Corbytt Francis draper 594218 594218 Corbytt, Francis, of St Neots, draper 2
4372931 2155394 2155394 defendant Hybbyttes Thomas draper 594218 594218 Hybbyttes, Thomas, of St Neots, draper 2
4372932 2155394 2155394 defendant Newman Edward draper 594218 594218 Newman, Edward, of St Neots, draper 3
4406262 2166658 2166658 defendant Mayer Walter glover 594218 594218 Mayer, Walter, of St Neots, glover 0
4407821 2167182 2167182 defendant Mason Alexander butcher 594218 594218 Mason, Alexander, of St Neots, butcher 0
4410973 2168261 2168261 defendant Newman Thomas yeoman 594218 594218 Newman, Thomas, of St Neots, yeoman 2
4418103 2170542 2170542 plaintiff Ubston William de clerk 594218 594218 Ubston, William de, of St Neots, clerk 0
4422112 2171788 2171788 defendant Bele John   594218 594218 Bele, John, of St Neots 3
4422192 2171811 2171811 defendant Kirketon Agnes de   594218 594218 Kirketon, Agnes de, of St Neots, wife of John, who vouched Dyggeby, Robert de 0
4464905 2189695 2189695 defendant Lombe John   594218 594218 Lombe, John, of St Neots 0
4479354 2194194 2194194 defendant Whelwryght John chaplain 594218 594218 Whelwryght, John, of St Neots, chaplain 0
4494463 2198967 2198967 defendant Spycer William   594218 594218 Spycer, William, of St Neots 3
4498971 2200317 2200317 defendant Bret John   594218 594218 Bret, John, of St Neots 0
4499449 2200479 2200479 defendant Bryde William   594218 594218 Bryde, William, of St Neots 2
4513032 2204510 2204510 plaintiff Bret John   594218 594218 Bret, John, of St Neots 1
4525587 2208323 2208323 defendant Goldsmyth Robert   594218 594218 Goldsmyth, Robert, of St Neots 0
4531861 2210227 2210227 defendant Bryt William   594218 594218 Bryt, William, of St Neots 1
4544919 2214329 2214329 defendant Bocher William   594218 594218 Bocher, William, of St Neots 1
4548672 2215527 2215527 defendant Broughton Thomas   594218 594218 Broughton, Thomas, of St Neots 1
4554015 2217176 2217176 plaintiff Goldsmyth Robert   594218 594218 Goldsmyth, Robert, of St Neots 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);