names

320 rows where place_id = 585978

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587617 1863772 1863772 defendant Croukarn Edward butcher 585978 585978 Croukarn, Edward, of St Neots, Hunts, butcher 0
3592736 1865341 1865341 defendant Clerke Henry butcher 585978 585978 Clerke, Henry, of St Neots, Hunts, or of Hatfeld Brodeoke, butcher 0
3609013 1870474 1870474 defendant Basse William chapman 585978 585978 Basse, William, of St Neots, Hunts, chapman 3
3609019 1870475 1870475 defendant Basse William chapman 585978 585978 Basse, William, of St Neots, Hunts, chapman 3
3609311 1870570 1870570 defendant Blok William   585978 585978 Blok, William, of St Neots, Hunts 1
3626123 1903031 1903031 defendant Colvyle William fishmonger 585978 585978 Colvyle, William, of St Neots, Hunts, fishmonger 0
3630702 1904430 1904430 defendant Tetworth Edward yeoman 585978 585978 Tetworth, Edward, of St Neots, Hunts, yeoman 3
3636300 1906144 1906144 defendant Lane John yeoman 585978 585978 Lane, John, of St Neots, Hunts, yeoman 0
3638540 1906870 1906870 defendant Selby Stephen yeoman 585978 585978 Selby, Stephen, of St Neots, Hunts, yeoman 0
3638542 1906871 1906871 defendant Selby Stephen yeoman 585978 585978 Selby, Stephen, of St Neots, Hunts, yeoman 0
3670689 1916796 1916796 defendant Corbett William husbandman 585978 585978 Corbett, William, of St Neots, Hunts, husbandman 0
3670711 1916799 1916799 defendant Tetworthe Edward gent 585978 585978 Tetworthe, Edward, of St Neots, Hunts, gent 2
3686174 1921839 1921839 defendant Foster John glover 585978 585978 Foster, John, of St Neots, Hunts, glover 2
3709122 1929151 1929151 defendant Lynde Thomas yeoman 585978 585978 Lynde, Thomas, of St Neots, Hunts, yeoman 1
3711899 1930038 1930038 defendant Adams Thomas husbandman 585978 585978 Adams, Thomas, of St Neots, Hunts, husbandman 0
3718069 1931946 1931946 defendant Corbett William yeoman 585978 585978 Corbett, William, of St Neots, Hunts, yeoman 0
3718071 1931947 1931947 defendant Corbett William yeoman 585978 585978 Corbett, William, of St Neots, Hunts, yeoman 0
3727082 1934737 1934737 defendant Adams Thomas husbandman 585978 585978 Adams, Thomas, of St Neots, Hunts, husbandman 0
3733746 1936805 1936805 defendant Corbet William yeoman 585978 585978 Corbet, William, of St Neots, Hunts, yeoman 0
3754458 1943352 1943352 defendant Haryson John merchant 585978 585978 Haryson, John, of St Neots, Hunts, merchant 0
3776139 1950280 1950280 defendant Stowell Thomas yeoman 585978 585978 Stowell, Thomas, of St Neots, Hunts, yeoman 1
3814251 1962364 1962364 defendant Corbet William husbandman 585978 585978 Corbet, William, of St Neots, Hunts, husbandman 0
3816830 1963171 1963171 defendant Devereux Walter gent 585978 585978 Devereux, Walter, of St Neots, Hunts, gent 0
3847884 1972915 1972915 defendant Lamkyn John glover 585978 585978 Lamkyn, John, of St Neots, Hunts, or of Stondon, glover 1
3850870 1973865 1973865 defendant Symson William chapman 585978 585978 Symson, William, of St Neots, Hunts, chapman 3
3853267 1974641 1974641 defendant Chamberleyn Robert yeoman 585978 585978 Chamberleyn, Robert, of St Neots, Hunts, yeoman 0
3854008 1974889 1974889 defendant Thetford Edward gent 585978 585978 (Thetford, Edward, of St Neots, Hunts, gent 2
3854012 1974890 1974890 defendant Tetford Edward gent 585978 585978 (Tetford, Edward, of St Neots, Hunts, gent 2
3855648 1975405 1975405 defendant Tetworth Edward gent 585978 585978 (Tetworth, Edward, of St Neots, Hunts, gent 1
3865583 1978707 1978707 defendant Symson William chapman 585978 585978 Symson, William, of St Neots, Hunts, chapman 3
3874009 1981530 1981530 defendant Hart John barber 585978 585978 Hart, John, of St Neots, Hunts, barber 0
3880193 1983628 1983628 defendant Norton Richard yeoman 585978 585978 Norton, Richard, of St Neots, Hunts, yeoman 0
3891265 1987346 1987346 defendant Corbett Ellen widow 585978 585978 Corbett, Ellen, of St Neots, Hunts, widow 0
3896822 1989148 1989148 defendant Fegett Richard yeoman 585978 585978 Fegett, Richard, of St Neots, Hunts, yeoman 1
3925669 1998899 1998899 defendant Punsbye or Pimsbye John draper 585978 585978 Punsbye or Pimsbye, John, of St Neots, Hunts, draper 0
3929340 2000157 2000157 defendant Dennye Gabriel chapman 585978 585978 Dennye, Gabriel, of St Neots, Hunts, chapman 0
3930033 2000390 2000390 defendant Good Robert yeoman & inn holder 585978 585978 Good, Robert, of St Neots, Hunts, yeoman & inn holder 0
3935228 2002092 2002092 defendant Hawkyns Walter mercer 585978 585978 Hawkyns, Walter, of St Neots, Hunts, mercer 0
3935382 2002146 2002146 defendant Hawkyns Walter mercer 585978 585978 Hawkyns, Walter, of St Neots, Hunts, mercer 0
3940374 2003801 2003801 defendant Newman Hugh mercer 585978 585978 Newman, Hugh, of St Neots, Hunts, mercer 0
3940950 2003982 2003982 defendant Hawkyns Walter mercer 585978 585978 Hawkyns, Walter, of St Neots, Hunts, mercer 1
3945276 2005433 2005433 defendant Kynge William   585978 585978 Kynge, William, of St Neots, Hunts, wool packer 0
3945465 2005491 2005491 defendant Kyng William yeoman 585978 585978 Kyng, William, of St Neots, Hunts, yeoman 0
3945667 2005559 2005559 defendant Goode Robert innholder 585978 585978 Goode, Robert, of St Neots, Hunts, yeoman, innholder 0
3960692 2010839 2010839 defendant Payne Robert gent 585978 585978 Payne, Robert, of St Neots, Hunts, gent 0
3964467 2012175 2012175 defendant Hatley Richard gent 585978 585978 Hatley, Richard, of St Neots, Hunts, gent 0
3964469 2012176 2012176 defendant Hatley Richard gent 585978 585978 Hatley, Richard, of St Neots, Hunts, gent 0
3971625 2014637 2014637 defendant Goode Robert yeoman 585978 585978 Goode, Robert, of St Neots, Hunts, yeoman 0
3990353 2021304 2021304 defendant Frunt Edmund butcher 585978 585978 Frunt, Edmund, of St Neots, Hunts, butcher 0
3994291 2022711 2022711 defendant Good Robert innkeeper 585978 585978 Good, Robert, of St Neots, Hunts, innkeeper 1
3994775 2022882 2022882 defendant Newman Hugh chapman 585978 585978 Newman, Hugh, of St Neots, Hunts, chapman 0
3996290 2023422 2023422 defendant Hatley Richard grocer 585978 585978 Hatley, Richard, of St Neots, Hunts, grocer 0
3997549 2023873 2023873 defendant Carpynter Francis glover 585978 585978 Carpynter, Francis, of St Neots, Hunts, glover 0
4000630 2024998 2024998 defendant Goodes Robert innholder 585978 585978 Goodes, Robert, of St Neots, Hunts, innholder 0
4001302 2025244 2025244 defendant Newman Hugh chapman 585978 585978 Newman, Hugh, of St Neots, Hunts, chapman 0
4012465 2029181 2029181 defendant Carpynter Francis glover 585978 585978 Carpynter, Francis, of St Neots, Hunts, glover 0
4012468 2029182 2029182 defendant Carpynter Francis glover 585978 585978 Carpynter, Francis, of St Neots, Hunts, glover 0
4030924 2035725 2035725 defendant Thomas Lewis yeoman 585978 585978 Thomas, Lewis, of St Neots, Hunts, yeoman 0
4032834 2036397 2036397 defendant Chamberlyn Thomas yeoman 585978 585978 Chamberlyn, Thomas, of St Neots, Hunts, yeoman 2
4041010 2039275 2039275 defendant Newman Hugh fishmonger 585978 585978 Newman, Hugh, of St Neots, Hunts, fishmonger 0
4041853 2039568 2039568 defendant Goodes Robert yeoman 585978 585978 Goodes, Robert, of St Neots, Hunts, yeoman 0
4041855 2039569 2039569 defendant Hatle William yeoman 585978 585978 Hatle, William, of St Neots, Hunts, yeoman 0
4043587 2040168 2040168 defendant Newman Hugh innholder 585978 585978 Newman, Hugh, of St Neots, Hunts, yeoman, innholder 0
4062426 2046849 2046849 defendant Newman George chapman 585978 585978 Newman, George, of St Neots, Hunts, chapman 0
4069131 2049251 2049251 defendant Haddenham alias Steven Thomas   585978 585978 Haddenham alias Steven, Thomas, of St Neots, Hunts 1
4070416 2049718 2049718 defendant Elytt William chapman 585978 585978 Elytt, William, of St Neots, Hunts, chapman 2
4072869 2050592 2050592 defendant Newman Hugh yeoman 585978 585978 Newman, Hugh, of St Neots, Hunts, yeoman 0
4074523 2051190 2051190 defendant Newman Gregory innholder 585978 585978 Newman, Gregory, of St neots, Hunts, innholder 2
4075101 2051398 2051398 defendant Nycolson Thomas   585978 585978 Nycolson, Thomas, of St Neots, Hunts, clerk, Bachelor of Arts 0
4096205 2058970 2058970 defendant Woodstocke John grocer 585978 585978 Woodstocke, John, of St Neots, Hunts, grocer 0
4098054 2059632 2059632 defendant Ibbat Edmund chapman 585978 585978 Ibbat, Edmund, of St Neots, Hunts, chapman 0
4113411 2065068 2065068 defendant Ibatt William chapman 585978 585978 Ibatt, William, of St Neots, Hunts, chapman 0
4114008 2065291 2065291 defendant Penifathe Randolph laborer 585978 585978 Penifathe, Randolph, of St Neots, Hunts, laborer 1
4120246 2067524 2067524 defendant Baxter Thomas scrivener 585978 585978 Baxter, Thomas, of St Neots, Hunts, scrivener 0
4120255 2067526 2067526 defendant Newman Hugh, senior yeoman 585978 585978 Newman, Hugh, senior, of St Neots, Hunts, yeoman 0
4120263 2067527 2067527 defendant Hawkins Walter   585978 585978 Hawkins, Walter, of St Neots, Hunts, yeoman, apothecary 3
4120265 2067528 2067528 defendant Wolle Richard yeoman 585978 585978 Wolle, Richard, of St Neots, Hunts, yeoman 0
4122539 2068365 2068365 defendant Newman Robert mercer 585978 585978 Newman, Robert, of St Neots, Hunts, mercer 0
4135601 2073057 2073057 defendant Ibbat Edmund chapman 585978 585978 Ibbat, Edmund, of St Neots, Hunts, chapman 1
4155257 2079932 2079932 defendant Babbeat William chapman 585978 585978 Babbeat, William, of St Neots, Hunts, chapman 1
4161395 2082065 2082065 defendant Skagges Henry gent 585978 585978 Skagges, Henry, of St Neots, Hunts, gent 1
4232777 2106971 2106971 defendant Deny William chapman 585978 585978 Deny, William, of St Neots, Hunts, chapman 0
4248823 2112595 2112595 defendant Ibitt Thomas mercer 585978 585978 Ibitt, Thomas, of St Neots, Hunts, mercer 1
4250872 2113271 2113271 defendant Newman Thomas innholder 585978 585978 Newman, Thomas, of St Neots, Hunts, innholder 0
4250876 2113272 2113272 defendant Newman Thomas innholder 585978 585978 Newman, Thomas, of St Neots, Hunts, innholder 1
4258382 2115771 2115771 defendant Gitting John innholder 585978 585978 Gitting, John, of St Neots, Hunts, innholder 2
4263462 2117442 2117442 defendant Ibitt or Juitt Thomas mercer 585978 585978 Ibitt or Juitt, Thomas, of St Neots, Hunts, mercer 2
4264816 2117870 2117870 defendant Deny William chapman 585978 585978 Deny, William, of St Neots, Hunts, chapman 0
4264930 2117906 2117906 defendant Newman Thomas innholder 585978 585978 Newman, Thomas, of St Neots, Hunts, innholder 0
4264934 2117907 2117907 defendant Newman Thomas innholder 585978 585978 Newman, Thomas, of St Neots, Hunts, innholder 1
4270350 2119663 2119663 defendant Gitting John innholder 585978 585978 Gitting, John, of St Neots, Hunts, innholder 2
4276023 2121560 2121560 defendant Ellys Robert butcher 585978 585978 Ellys, Robert, of St Neots, Hunts, butcher 0
4284697 2124576 2124576 defendant Ibbott Thomas   585978 585978 Ibbott, Thomas, of St Neots, Hunts, linen draper 0
4292002 2127215 2127215 defendant Ibitt Thomas chapman 585978 585978 Ibitt, Thomas, of St Neots, Hunts, chapman 1
4307020 2132596 2132596 defendant Newman Hugh vintner 585978 585978 Newman, Hugh, of St Neots, Hunts, vintner 2
4307542 2132775 2132775 defendant Stones or Stynes William yeoman 585978 585978 Stones or Stynes, William, of St Neots, Hunts, yeoman 0
4312690 2134570 2134570 defendant Newman Thomas yeoman 585978 585978 Newman, Thomas, of St Neots, Hunts, yeoman 3
4332271 2141084 2141084 defendant Denye William chapman 585978 585978 Denye, William, of St Neots, Hunts, chapman 0
4334937 2141948 2141948 defendant Ibott William mercer 585978 585978 Ibott, William, of St Neots, Hunts, mercer 1
4336098 2142358 2142358 defendant Lord Mathew   585978 585978 Lord, Mathew, of St Neots, Hunts, linen draper 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);