names

517 rows where place_id = 596220

✎ 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
3623729 1874955 1874955 plaintiff Wryght John   596220 596220 Wryght, John, of Ely 1
3628845 1903897 1903897 defendant Woderove Richard   596220 596220 Woderove, Richard, of Ely, parish clerk 0
3637150 1906419 1906419 plaintiff Sempell William yeoman 596220 596220 Sempell, William, of Ely, yeoman 0
3637862 1906659 1906659 defendant Duket Thomas gent 596220 596220 Duket, Thomas, of Ely, gent 0
3637863 1906659 1906659 defendant Duket John gent 596220 596220 Duket, John, of Ely, gent 1
3637865 1906660 1906660 defendant Duket Thomas gent 596220 596220 Duket, Thomas, of Ely, gent 0
3637866 1906660 1906660 defendant Duket John gent 596220 596220 Duket, John, of Ely, gent 1
3639008 1907023 1907023 plaintiff Wake Agnes widow 596220 596220 Wake, Agnes, of Ely, widow 0
3647554 1909627 1909627 defendant Talbot Robert (legal representative) 596220 596220 Talbot, Robert, of Ely, executor of 1
3649498 1910230 1910230 defendant Makerowe Robert waterman 596220 596220 Makerowe, Robert, of Ely, waterman 5
3650562 1910544 1910544 plaintiff Sempoll William yeoman 596220 596220 Sempoll, William, of Ely, yeoman 0
3650564 1910544 1910544 defendant Tyler Nicholas yeoman 596220 596220 Tyler, Nicholas, of Ely, yeoman 1
3650565 1910544 1910544 defendant Buk William sherman 596220 596220 Buk, William, of Ely, sherman 2
3661474 1913860 1913860 defendant Bryon John baker 596220 596220 Bryon, John, of Ely, baker 0
3668776 1916171 1916171 defendant Cok William   596220 596220 Cok, William, of Ely, parchment maker 0
3700403 1926361 1926361 defendant Slowe James brewer 596220 596220 Slowe, James, of Ely, brewer 0
3700404 1926361 1926361 defendant Bugge John husbandman 596220 596220 Bugge, John, of Ely, husbandman 1
3700405 1926361 1926361 defendant Hansten or Hausten Thomas husbandman 596220 596220 Hansten or Hausten, Thomas, of Ely, husbandman 2
3705553 1928019 1928019 plaintiff Hardyng William   596220 596220 Hardyng, William, of Ely 0
3706114 1928205 1928205 defendant Jerves Henry husbandman 596220 596220 Jerves, Henry, of Ely, husbandman 0
3706116 1928205 1928205 defendant Homfrey alias Fyssher Edmund yeoman 596220 596220 Homfrey alias Fyssher, Edmund, of Ely, yeoman 2
3708549 1928972 1928972 defendant Kynrey John tanner 596220 596220 Kynrey, John, of Ely, tanner 0
3710303 1929539 1929539 defendant Charlys John   596220 596220 Charlys, John, of Ely, tallow chandler 0
3732439 1936379 1936379 defendant Goldsmyth William yeoman 596220 596220 Goldsmyth, William, of Ely, yeoman 1
3740513 1938892 1938892 defendant Rose John yeoman 596220 596220 Rose, John, of Ely, yeoman 0
3740655 1938938 1938938 defendant Mays or Maye Thomas husbandman 596220 596220 Mays or Maye, Thomas, of Ely, husbandman 0
3740660 1938940 1938940 defendant Maye Thomas husbandman 596220 596220 Maye, Thomas, of Ely, or of Graundecester, husbandman 0
3766569 1947205 1947205 defendant Nuttall Thomas   596220 596220 Nuttall, Thomas, of Ely, surgeon 0
3783272 1952520 1952520 defendant Wodcrofte Robert yeoman 596220 596220 Wodcrofte, Robert, of Ely, yeoman 1
3792342 1955466 1955466 defendant Cooke Robert   596220 596220 Cooke, Robert, of Ely, parchment maker 1
3802140 1958565 1958565 defendant Kynrey John (legal representative) 596220 596220 Kynrey, John, of Ely, tanner, executors of 0
3823665 1965299 1965299 defendant Tuk John fisher 596220 596220 Tuk, John, of Ely, fisher 1
3827021 1966305 1966305 defendant Sylvertofte William yeoman 596220 596220 Sylvertofte, William, of Ely, yeoman 0
3847456 1972766 1972766 defendant Twyfford Edward gent 596220 596220 Twyfford, Edward, of Ely, gent 4
3847630 1972828 1972828 defendant Twyford Edward gent 596220 596220 Twyford, Edward, of Ely, gent 4
3858123 1976196 1976196 defendant Aschewe John gent 596220 596220 Aschewe, John, of Ely, gent 1
3868114 1979570 1979570 defendant Thorpe William waterman 596220 596220 Thorpe, William, of Ely, waterman 0
3886522 1985744 1985744 defendant Godbedde John husbandman 596220 596220 Godbedde, John, of Ely, husbandman 2
3886523 1985744 1985744 defendant Slough John husbandman 596220 596220 Slough, John, of Ely, husbandman 3
3886529 1985745 1985745 defendant Goodbedde John husbandman 596220 596220 Goodbedde, John, of Ely, husbandman 2
3886530 1985745 1985745 defendant Slough John husbandman 596220 596220 Slough, John, of Ely, husbandman 3
3888134 1986288 1986288 defendant Daye William husbandman 596220 596220 Daye, William, of Ely, husbandman 0
3888812 1986511 1986511 defendant Gotobed Thomas husbandman 596220 596220 Gotobed, Thomas, of Ely, husbandman 0
3890373 1987032 1987032 plaintiff Hodylowe Robert waterman 596220 596220 Hodylowe, Robert, of Ely, waterman 0
3895693 1988764 1988764 plaintiff Steward Nicholas   596220 596220 Steward, Nicholas, of Ely 0
3928702 1999936 1999936 defendant Bennett John   596220 596220 Bennett, John, of Ely, shoe maker 1
3928703 1999936 1999936 defendant Craynford John   596220 596220 Craynford, John, of Ely, shoe maker 2
3941737 2004251 2004251 defendant Crysten John tailor 596220 596220 Crysten, John, of Ely, tailor 1
3952536 2007955 2007955 plaintiff Hoddylowe Thomas beer brewer 596220 596220 Hoddylowe, Thomas, of Ely, beer brewer 0
3959301 2010332 2010332 defendant Assheton Willam clerk 596220 596220 Assheton, Willam, of Ely, clerk 0
3983066 2018718 2018718 defendant Welles John gaoler or Barton gaol 596220 596220 Welles, John, of Ely, yeoman, gaoler or Barton gaol 2
4011320 2028825 2028825 defendant Burton John yeoman 596220 596220 Burton, John, of Ely, yeoman 1
4035495 2037368 2037368 defendant More Robert husbandman 596220 596220 More, Robert, of Ely, or of Lakinghethe, Suff, husbandman 0
4035500 2037370 2037370 defendant More Robert husbandman 596220 596220 More, Robert, of Ely, or of Lakingheth, Suff, husbandman 0
4062991 2047067 2047067 defendant Archer Thomas fisher 596220 596220 Archer, Thomas, of Ely, fisher 1
4062992 2047067 2047067 defendant Harvye John tailor 596220 596220 Harvye, John, of Ely, tailor 2
4093997 2058181 2058181 defendant Kellett Lancelot husbandman 596220 596220 Kellett, Lancelot, of Ely, husbandman 1
4112184 2064614 2064614 defendant Anger Robert yeoman 596220 596220 Anger, Robert, of Ely, yeoman 1
4122521 2068361 2068361 defendant Darnell Thomas, junior chapman 596220 596220 Darnell, Thomas, junior, of Ely, chapman 1
4127513 2070134 2070134 defendant Aunger Robert gent 596220 596220 Aunger, Robert, of Ely, gent 0
4127514 2070134 2070134 defendant Hamont Robert yeoman 596220 596220 Hamont, Robert, of Ely, yeoman 1
4133698 2072387 2072387 defendant Daynes John drover 596220 596220 Daynes, John, of Ely, drover 0
4136790 2073508 2073508 defendant Sayer Henry yeoman 596220 596220 Sayer, Henry, of Ely, yeoman 1
4138218 2074038 2074038 defendant Kyrbye Richard husbandman 596220 596220 Kyrbye, Richard, of Ely, husbandman 0
4138219 2074038 2074038 defendant Robert Formandus husbandman 596220 596220 Robert, Formandus, of Ely, husbandman 1
4140293 2074771 2074771 defendant Gidney William innholder 596220 596220 Gidney, William, of Ely, innholder 0
4147122 2077136 2077136 defendant Flower Lancelot gent 596220 596220 Flower, Lancelot, of Ely, gent 1
4147123 2077136 2077136 defendant Flower Richard gent 596220 596220 Flower, Richard, of Ely, gent 2
4147125 2077136 2077136 defendant Golston Roman yeoman 596220 596220 Golston, Roman, of Ely, yeoman 4
4147126 2077136 2077136 defendant Malden Andrew yeoman 596220 596220 Malden, Andrew, of Ely, yeoman 5
4147130 2077137 2077137 defendant Maldyn or Mawlyn Andrew yeoman 596220 596220 Maldyn or Mawlyn, Andrew, of Ely, yeoman 1
4147131 2077137 2077137 defendant Kysky Richard yeoman 596220 596220 Kysky, Richard, of Ely, yeoman 2
4176270 2087177 2087177 defendant Salmon John husbandman 596220 596220 Salmon, John, of Ely, husbandman 0
4197132 2094549 2094549 defendant Wright John yeoman 596220 596220 Wright, John, of Ely, or of Braine , Isle of Ely, yeoman 1
4209999 2099061 2099061 defendant Anger Robert yeoman 596220 596220 Anger, Robert, of Ely, yeoman 0
4210000 2099061 2099061 defendant Anger William   596220 596220 Anger, William, of Ely, yeoman, his son 1
4210003 2099062 2099062 defendant Austen Thomas husbandman 596220 596220 Austen, Thomas, of Ely, husbandman 1
4245807 2111577 2111577 defendant Crumwell alias Willyams Robert gent 596220 596220 (Crumwell alias Willyams, Robert, of Ely, gent 2
4248409 2112457 2112457 defendant Thorrolde John yeoman 596220 596220 Thorrolde, John, of Ely, yeoman 3
4250177 2113040 2113040 defendant East William innholder 596220 596220 East, William, of Ely, innholder 2
4258032 2115657 2115657 defendant Cromwell alias Willyams Robert gent 596220 596220 (Cromwell alias Willyams, Robert, of Ely, gent 2
4265365 2118057 2118057 defendant East William innholder 596220 596220 East, William, of Ely, innholder 2
4267372 2118723 2118723 defendant Mason Edward blacksmith 596220 596220 Mason, Edward, of Ely, blacksmith 2
4273546 2120706 2120706 defendant Thorrold John clerk 596220 596220 Thorrold, John, of Ely, clerk 3
4278187 2122306 2122306 defendant Piggott Michael gent 596220 596220 Piggott, Michael, of Ely, gent 1
4283985 2124315 2124315 defendant Mathewe Thomas husbandman 596220 596220 Mathewe, Thomas, of Ely, husbandman 1
4283986 2124315 2124315 defendant Baytman William husbandman 596220 596220 Baytman, William, of Ely, husbandman 2
4283987 2124315 2124315 defendant Lewis Clement (legal representative) 596220 596220 Lewis, Clement, of Ely, gent, administratrix of 3
4283988 2124315 2124315 defendant Lewys Dorothy widow 596220 596220 Lewys, Dorothy, of Ely, widow 4
4287162 2125466 2125466 defendant Lewis Dorothy widow 596220 596220 Lewis, Dorothy, of Ely, widow 1
4287310 2125517 2125517 defendant Yarrowe Henry laborer 596220 596220 Yarrowe, Henry, of Ely, laborer 2
4288102 2125793 2125793 defendant Stoneham William fisherman 596220 596220 Stoneham, William, of Ely, fisherman 0
4290650 2126714 2126714 defendant Lewys Clement (legal representative) 596220 596220 Lewys, Clement, of Ely, gent, administratrix of 0
4290653 2126715 2126715 defendant Lewys Clement (legal representative) 596220 596220 Lewys, Clement, of Ely, gent, administratrix of 0
4293407 2127705 2127705 defendant Goodricke Daniel gent 596220 596220 Goodricke, Daniel, of Ely, gent 0
4293409 2127706 2127706 defendant Raymond Lawrence butcher 596220 596220 Raymond, Lawrence, of Ely, butcher 0
4295120 2128338 2128338 defendant Blake Thomas draper 596220 596220 Blake, Thomas, of Ely, draper 1
4296628 2128894 2128894 defendant Brakyn Richard esq 596220 596220 Brakyn, Richard, of Ely, esq 0
4298272 2129482 2129482 defendant Hornygould Richard tanner 596220 596220 Hornygould, Richard, of Ely, tanner 3
4303959 2131519 2131519 defendant Watt John tailor 596220 596220 Watt, John, of Ely, tailor 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);