names

335 rows where place_id = 587360

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591189 1864867 1864867 defendant Belle John yeoman 587360 587360 Belle, John, of Gedney, yeoman 0
3601194 1868037 1868037 defendant Pye Robert (legal representative) 587360 587360 Pye, Robert, of Gedney, executors of 3
3601196 1868037 1868037 defendant Baldeware Richard husbandman 587360 587360 Baldeware, Richard, of Gedney, husbandman 5
3604543 1869086 1869086 defendant Luffedon Thomas husbandman 587360 587360 Luffedon, Thomas, of Gedney, husbandman 0
3604544 1869086 1869086 defendant Hogeson Geoffrey husbandman 587360 587360 Hogeson, Geoffrey, of Gedney, husbandman 1
3609187 1870534 1870534 defendant Baldware Lawrence husbandman 587360 587360 Baldware, Lawrence, of Gedney, husbandman 0
3612131 1871435 1871435 defendant Male Walter yeoman 587360 587360 Male, Walter, of Gedney, yeoman 0
3615304 1872432 1872432 defendant Dobyn Richard husbandman 587360 587360 Dobyn, Richard, of Gedney, husbandman 1
3616459 1872787 1872787 plaintiff Dobyn Robert (legal representative) 587360 587360 Dobyn, Robert, of Gedney, executor of 0
3616461 1872787 1872787 defendant Loveden or Loneden Thomas husbandman 587360 587360 Loveden or Loneden, Thomas, of Gedney, husbandman 0
3621795 1874355 1874355 defendant Thirkyll Simon fisher 587360 587360 Thirkyll, Simon, of Gedney, fisher 2
3628681 1903845 1903845 defendant Caloe Richard husbandman 587360 587360 Caloe, Richard, of Gedney, husbandman 0
3628682 1903845 1903845 defendant Clerke William laborer 587360 587360 Clerke, William, of Gedney, laborer 1
3628683 1903845 1903845 defendant Clerke Simon laborer 587360 587360 Clerke, Simon, of Gedney, laborer 2
3642221 1908014 1908014 defendant Luffeden William husbandman 587360 587360 Luffeden, William, of Gedney, husbandman 1
3652724 1911173 1911173 defendant Welby Richard gent 587360 587360 Welby, Richard, of Gedney, gent 0
3652725 1911173 1911173 defendant Bucle William yeoman 587360 587360 Bucle, William, of Gedney, yeoman 1
3657526 1912614 1912614 plaintiff Dakyn William   587360 587360 Dakyn, William, of Gedney 0
3676554 1918709 1918709 defendant Wylson Thomas husbandman 587360 587360 Wylson, Thomas, of Gedney, husbandman 2
3676578 1918712 1918712 defendant Kalcroft William tailor 587360 587360 Kalcroft, William, of Gedney, tailor 4
3683697 1921033 1921033 defendant Robertson Lawrence husbandman 587360 587360 Robertson, Lawrence, of Gedney, husbandman 0
3695470 1924806 1924806 defendant Davers Thomas carver 587360 587360 Davers, Thomas, of Gedney, carver 0
3703569 1927393 1927393 plaintiff Dobyn William yeoman 587360 587360 Dobyn, William, of Gedney, yeoman 0
3713042 1930404 1930404 defendant Peretre Robert husbandman 587360 587360 Peretre, Robert, of Gedney, husbandman 2
3717411 1931728 1931728 plaintiff Dobyn William yeoman 587360 587360 Dobyn, William, of Gedney, yeoman 0
3727574 1934905 1934905 defendant Dobyn William yeoman 587360 587360 Dobyn, William, of Gedney, yeoman 0
3737315 1937907 1937907 defendant Fyssher Thomas husbandman 587360 587360 Fyssher, Thomas, of Gedney, husbandman 2
3739290 1938505 1938505 plaintiff Patryk John (legal representative) 587360 587360 Patryk, John, of Gedney, executors of 0
3740728 1938965 1938965 defendant Baldwar Robert yeoman 587360 587360 Baldwar, Robert, of Gedney, yeoman 0
3748721 1941531 1941531 plaintiff Halhed Anne widow 587360 587360 Halhed, Anne, of Gedney, widow 0
3758318 1944596 1944596 defendant Thorne John husbandman 587360 587360 Thorne, John, of Gedney, husbandman 0
3758722 1944722 1944722 defendant Calowe Richard husbandman 587360 587360 Calowe, Richard, of Gedney, husbandman 0
3758744 1944724 1944724 defendant Pye Robert husbandman 587360 587360 Pye, Robert, of Gedney, husbandman 0
3758747 1944724 1944724 defendant Clerk Simon husbandman 587360 587360 Clerk, Simon, of Gedney, husbandman 3
3763195 1946125 1946125 plaintiff Halhed Henry (legal representative) 587360 587360 Halhed, Henry, of Gedney, alderman of Cambridge, executors of 0
3763263 1946145 1946145 plaintiff Halled Henrt (legal representative) 587360 587360 Halled, Henrt, of Gedney, executors of 0
3766629 1947223 1947223 defendant Thorne John husbandman 587360 587360 Thorne, John, of Gedney, husbandman 0
3768254 1947711 1947711 defendant Jakson Alexander husbandman 587360 587360 Jakson, Alexander, of Gedney, husbandman 0
3768255 1947711 1947711 defendant Nelse William husbandman 587360 587360 Nelse, William, of Gedney, husbandman 1
3768256 1947711 1947711 defendant Caty John tiler 587360 587360 Caty, John, of Gedney, tiler 2
3768257 1947711 1947711 defendant Davers Thomas carver 587360 587360 Davers, Thomas, of Gedney, carver 3
3778727 1951062 1951062 defendant Partrych John gent 587360 587360 Partrych, John, of Gedney, gent 0
3778729 1951063 1951063 defendant Thuyrkyll Robert carter 587360 587360 Thuyrkyll, Robert, of Gedney, carter 0
3779369 1951269 1951269 defendant Thorne John husbandman 587360 587360 Thorne, John, of Gedney, husbandman 0
3785983 1953412 1953412 defendant Kyrton Thomas tailor 587360 587360 Kyrton, Thomas, of Gedney, tailor 0
3787328 1953828 1953828 defendant Spendlove Simon husbandman 587360 587360 Spendlove, Simon, of Gedney, husbandman 0
3789035 1954382 1954382 defendant Scarlet John butcher 587360 587360 Scarlet, John, of Gedney, butcher 4
3806251 1959875 1959875 defendant Goonell alias Goonwell John carpenter 587360 587360 Goonell alias Goonwell, John, of Gedney, carpenter 0
3812709 1961869 1961869 defendant Pye Thomas husbandman 587360 587360 Pye, Thomas, of Gedney, husbandman 0
3825659 1965878 1965878 defendant Baldeware Thomas (legal representative) 587360 587360 Baldeware, Thomas, of Gedney, executors of 0
3825660 1965878 1965878 defendant Dyxson John husbandman 587360 587360 (Dyxson, John, of Gedney, husbandman 1
3826920 1966270 1966270 defendant Spendlove Simon husbandman 587360 587360 Spendlove, Simon, of Gedney, husbandman 0
3828413 1966758 1966758 defendant Sleight Henry laborer 587360 587360 Sleight, Henry, of Gedney, laborer 1
3834002 1968576 1968576 defendant Cokke John husbandman 587360 587360 Cokke, John, of Gedney, husbandman 0
3852564 1974411 1974411 defendant Maryott John husbandman 587360 587360 Maryott, John, of Gedney, husbandman 0
3854908 1975179 1975179 defendant Halhede Henry (legal representative) 587360 587360 Halhede, Henry, of Gedney, gent, executors of 0
3879378 1983356 1983356 defendant Fissher Thomas fisher 587360 587360 Fissher, Thomas, of Gedney, fisher 0
3914389 1995156 1995156 plaintiff Callow John yeoman 587360 587360 Callow, John, of Gedney, yeoman 0
3914391 1995157 1995157 plaintiff Callow John yeoman 587360 587360 Callow, John, of Gedney, yeoman 0
3914393 1995158 1995158 plaintiff Callow John yeoman 587360 587360 Callow, John, of Gedney, yeoman 0
3936485 2002526 2002526 defendant Clerkson Richard husbandman 587360 587360 Clerkson, Richard, of Gedney, husbandman 0
3936486 2002526 2002526 defendant Jakson George husbandman 587360 587360 Jakson, George, of Gedney, husbandman 1
3958382 2010004 2010004 defendant Conye Thomas husbandman 587360 587360 Conye, Thomas, of Gedney, husbandman 0
3980107 2017647 2017647 defendant Huttofte John butcher 587360 587360 Huttofte, John, of Gedney, butcher 0
3980108 2017647 2017647 defendant Huttofte Thomas husbandman 587360 587360 Huttofte, Thomas, of Gedney, husbandman 1
4004523 2026391 2026391 defendant Newland John clerk 587360 587360 (Newland, John, of Gedney, clerk 2
4010650 2028579 2028579 defendant Watson John   587360 587360 Watson, John, of Gedney, salt weller 2
4084690 2054796 2054796 defendant Watson John, senior yeoman 587360 587360 Watson, John, senior, of Gedney, yeoman 0
4110276 2063938 2063938 defendant Jaxson John husbandman 587360 587360 Jaxson, John, of Gedney, husbandman 0
4110277 2063938 2063938 defendant Claxson Richard yeoman 587360 587360 Claxson, Richard, of Gedney, yeoman 1
4135700 2073094 2073094 defendant Craxtone William yeoman 587360 587360 Craxtone, William, of Gedney, yeoman 0
4173436 2086166 2086166 defendant Pye William husbandman 587360 587360 Pye, William, of Gedney, husbandman 0
4173940 2086342 2086342 defendant Cony Thomas husbandman 587360 587360 Cony, Thomas, of Gedney, husbandman 0
4178251 2087865 2087865 defendant Pye William husbandman 587360 587360 Pye, William, of Gedney, husbandman 1
4213004 2100073 2100073 defendant Wrighte Richard yeoman 587360 587360 Wrighte, Richard, of Gedney, yeoman 0
4213005 2100073 2100073 defendant Trowtinge Gilbert yeoman 587360 587360 Trowtinge, Gilbert, of Gedney, yeoman 1
4213006 2100073 2100073 defendant Grome Lawrence yeoman 587360 587360 Grome, Lawrence, of Gedney, yeoman 2
4233089 2107080 2107080 defendant Bowne Thomas husbandman 587360 587360 Bowne, Thomas, of Gedney, husbandman 0
4233670 2107299 2107299 defendant White Henry husbandman 587360 587360 White, Henry, of Gedney, husbandman 0
4235004 2107793 2107793 defendant Cramper Katherine spinster 587360 587360 Cramper, Katherine, of Gedney, spinster 0
4277350 2122002 2122002 defendant Sherman Robert husbandman 587360 587360 Sherman, Robert, of Gedney, husbandman 0
4280300 2123012 2123012 defendant Harrison Edmund husbandman 587360 587360 Harrison, Edmund, of Gedney, husbandman 0
4282253 2123692 2123692 defendant Marshall Simon yeoman 587360 587360 Marshall, Simon, of Gedney, yeoman 0
4349787 2147185 2147185 defendant Harrison Edmund laborer 587360 587360 Harrison, Edmund, of Gedney, laborer 0
4361920 2151421 2151421 defendant Ogle Adlard gent 587360 587360 Ogle, Adlard, of Gedney, gent 0
4361924 2151422 2151422 defendant Ogle Adlerd gent 587360 587360 Ogle, Adlerd, of Gedney, gent 0
4474824 2192800 2192800 defendant Rawelote John   587360 587360 Rawelote, John, of Gedney 0
4505903 2202357 2202357 defendant Spells William   587360 587360 Spells, William, of Gedney 0
4508324 2203091 2203091 defendant Hylyard Joan   587360 587360 Hylyard, Joan, of Gedney 1
4509223 2203363 2203363 defendant Spylman Robert   587360 587360 Spylman, Robert, of Gedney 0
4524544 2208009 2208009 defendant Pypere Thomas   587360 587360 Pypere, Thomas, of Gedney 0
4533682 2210804 2210804 defendant Myntelyng William   587360 587360 Myntelyng, William, of Gedney 0
4554474 2217332 2217332 defendant Spelkes William   587360 587360 Spelkes, William, of Gedney 0
4558400 2218572 2218572 defendant Stevyn John   587360 587360 Stevyn, John, of Gedney 0
4580763 2225464 2225464 defendant Blome John   587360 587360 Blome, John, of Gedney 0
4580765 2225465 2225465 defendant Glome John   587360 587360 Glome, John, of Gedney 0
4586019 2227050 2227050 plaintiff Haynes Richard   587360 587360 Haynes, Richard, of Gedney 0
4613851 2235349 2235349 defendant Tomson John   587360 587360 Tomson, John, of Gedney 0
4616887 2236285 2236285 defendant Bullok John, sen   587360 587360 Bullok, John, sen, of Gedney 0
4617653 2236526 2236526 defendant Bullok John   587360 587360 Bullok, John, of Gedney, son of John 5

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);