names

1,092 rows where place_id = 586953

✎ 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
3590075 1864537 1864537 defendant Gooche Thomas clerk 586953 586953 Gooche, Thomas, of Sudbury, clerk 0
3590077 1864538 1864538 defendant Roget Hugh glover 586953 586953 Roget, Hugh, of Sudbury, glover 0
3590082 1864539 1864539 defendant Scalder John grocer 586953 586953 Scalder, John, of Sudbury, grocer 0
3593376 1865561 1865561 defendant Venour John butcher 586953 586953 Venour, John, of Sudbury, butcher 0
3593377 1865561 1865561 defendant Reynold William butcher 586953 586953 Reynold, William, of Sudbury, butcher 1
3594058 1865783 1865783 defendant Wode John yeoman 586953 586953 Wode, John, of Sudbury, yeoman 0
3594148 1865812 1865812 defendant Parke William yeoman 586953 586953 Parke, William, of Sudbury, yeoman 0
3594149 1865812 1865812 defendant Myst John yeoman 586953 586953 Myst, John, of Sudbury, yeoman 1
3594864 1866024 1866024 defendant Reynold William butcher 586953 586953 Reynold, William, of Sudbury, butcher 0
3594865 1866024 1866024 defendant Dalton Thomas glover 586953 586953 Dalton, Thomas, of Sudbury, glover 1
3594866 1866024 1866024 defendant Buk John barker 586953 586953 Buk, John, of Sudbury, barker 2
3594867 1866024 1866024 defendant Renet or Revet William sherman 586953 586953 Renet or Revet, William, of Sudbury, sherman 3
3598178 1867060 1867060 defendant Edward Edmund   586953 586953 Edward, Edmund, of Sudbury, surgeon 0
3598288 1867096 1867096 defendant Penny John glover 586953 586953 Penny, John, of Sudbury, glover 0
3598976 1867309 1867309 defendant Reynold William butcher 586953 586953 Reynold, William, of Sudbury, butcher 2
3602828 1868554 1868554 defendant Revet William fuller 586953 586953 Revet, William, of Sudbury, fuller 3
3602847 1868561 1868561 defendant Scalder John grocer 586953 586953 Scalder, John, of Sudbury, grocer 0
3603174 1868658 1868658 defendant Hatche John clothmaker 586953 586953 Hatche, John, of Sudbury, clothmaker 0
3603176 1868659 1868659 defendant Atche John clothmaker 586953 586953 Atche, John, of Sudbury, clothmaker 0
3603616 1868798 1868798 defendant Reynold William butcher 586953 586953 Reynold, William, of Sudbury, butcher 1
3604088 1868946 1868946 plaintiff Fullour John mercer 586953 586953 Fullour, John, of Sudbury, mercer 0
3604089 1868946 1868946 defendant Over Edmund dyer 586953 586953 Over, Edmund, of Sudbury, dyer 0
3604090 1868946 1868946 defendant Sumpter Stephen weaver 586953 586953 Sumpter, Stephen, of Sudbury, weaver 1
3604094 1868947 1868947 plaintiff Fullour John mercer 586953 586953 Fullour, John, of Sudbury, mercer 0
3604296 1869007 1869007 defendant Cutteler William furbisher 586953 586953 Cutteler, William, of Sudbury, furbisher 0
3605369 1869347 1869347 defendant Scalder John grocer 586953 586953 Scalder, John, of Sudbury, grocer 0
3605429 1869364 1869364 defendant Welles John yeoman 586953 586953 Welles, John, of Sudbury, yeoman 1
3606313 1869643 1869643 defendant Scalder John husbandman 586953 586953 Scalder, John, of Sudbury, husbandman 1
3606314 1869643 1869643 defendant Dasshe John husbandman 586953 586953 Dasshe, John, of Sudbury, husbandman 2
3606735 1869782 1869782 defendant Machon John grocer 586953 586953 Machon, John, of Sudbury, grocer 4
3607197 1869917 1869917 defendant Scalder John grocer 586953 586953 Scalder, John, of Sudbury, grocer 0
3608881 1870434 1870434 plaintiff Wareyn Matilda widow 586953 586953 Wareyn, Matilda, of Sudbury, widow 0
3608882 1870434 1870434 plaintiff Ayloff Thomas   586953 586953 Ayloff, Thomas, of Sudbury 1
3608938 1870454 1870454 plaintiff Wellys alias Partrych Matilda widow 586953 586953 Wellys alias Partrych, Matilda, of Sudbury, widow 0
3608944 1870454 1870454 plaintiff Wateyn William grocer 586953 586953 Wateyn, William, of Sudbury, grocer 6
3611727 1871329 1871329 defendant Frem or Fremer John, senior mercer 586953 586953 Frem or Fremer, John, senior, of Sudbury, mercer 0
3611749 1871338 1871338 defendant Lenyng or Levyng John, senior mercer 586953 586953 Lenyng or Levyng, John, senior, of Sudbury, mercer 0
3617210 1873007 1873007 plaintiff Fitches Eleanor widow 586953 586953 Fitches, Eleanor, of Sudbury, widow 0
3622288 1874505 1874505 defendant Machon Thomas grocer 586953 586953 Machon, Thomas, of Sudbury, grocer 2
3624322 1875141 1875141 defendant Waryn Thomas pedder 586953 586953 Waryn, Thomas, of Sudbury, pedder 0
3625514 1875519 1875519 defendant Crouchon William mercer 586953 586953 Crouchon, William, of Sudbury, mercer 1
3625968 1902979 1902979 defendant Dawys or Dallys John husbandman 586953 586953 Dawys or Dallys, John, of Sudbury, husbandman 2
3626536 1903151 1903151 defendant Ennold or Gunold Thomas weaver 586953 586953 Ennold or Gunold, Thomas, of Sudbury, weaver 0
3626537 1903151 1903151 defendant Sanwell William   586953 586953 Sanwell, William, of Sudbury, tallow chandler 1
3626538 1903151 1903151 defendant Avys Richard carpenter 586953 586953 Avys, Richard, of Sudbury, carpenter 2
3628442 1903763 1903763 defendant Robardys John mercer 586953 586953 Robardys, John, of Sudbury, mercer 1
3631046 1904532 1904532 defendant Lenyng or Levyng Cecily widow 586953 586953 Lenyng or Levyng, Cecily, of Sudbury, widow 0
3631444 1904646 1904646 defendant Wolston Robert grocer 586953 586953 Wolston, Robert, of Sudbury, grocer 0
3632907 1905108 1905108 defendant Parke Robert chaplain 586953 586953 Parke, Robert, of Sudbury, chaplain 0
3634344 1905538 1905538 defendant Thurston John (legal representative) 586953 586953 Thurston, John, of Sudbury, chandler, executor of 4
3634345 1905538 1905538 defendant Thurston John carpenter 586953 586953 Thurston, John, of Sudbury, carpenter 5
3635950 1906038 1906038 defendant Jakson Christopher husbandman 586953 586953 Jakson, Christopher, of Sudbury, husbandman 0
3637752 1906623 1906623 defendant Gybbon William clothmaker 586953 586953 Gybbon, William, of Sudbury, clothmaker 0
3640082 1907344 1907344 defendant Bankys John innkeeper 586953 586953 Bankys, John, of Sudbury, innkeeper 0
3640083 1907344 1907344 defendant Roberd John mercer 586953 586953 Roberd, John, of Sudbury, mercer 1
3642493 1908095 1908095 defendant Robardys John mercer 586953 586953 Robardys, John, of Sudbury, mercer 2
3643094 1908282 1908282 defendant Waryn alias Baker John grocer 586953 586953 Waryn alias Baker, John, of Sudbury, grocer 0
3644840 1908793 1908793 defendant Fytches John weaver 586953 586953 Fytches, John, of Sudbury, weaver 0
3644842 1908794 1908794 defendant Fytches John weaver 586953 586953 Fytches, John, of Sudbury, weaver 0
3644965 1908834 1908834 defendant Samwell William   586953 586953 Samwell, William, of Sudbury, tallow chandler 0
3647936 1909751 1909751 defendant Shypley Thomas pedder 586953 586953 Shypley, Thomas, of Sudbury, pedder 5
3650205 1910434 1910434 defendant Downys Ralph tailor 586953 586953 Downys, Ralph, of Sudbury, tailor 3
3652252 1911043 1911043 defendant Hervy or Herny John gent 586953 586953 Hervy or Herny, John, of Sudbury, gent 3
3654502 1911667 1911667 defendant Kerver alias Goche Thomas mercer 586953 586953 Kerver alias Goche, Thomas, of Sudbury, mercer 0
3654935 1911805 1911805 defendant Garrard John writer 586953 586953 Garrard, John, of Sudbury, writer 0
3655135 1911867 1911867 defendant Stevynson Thomas tailor 586953 586953 Stevynson, Thomas, of Sudbury, tailor 0
3655843 1912082 1912082 defendant Carver alias Goche Thomas mercer 586953 586953 Carver alias Goche, Thomas, of Sudbury, mercer 0
3655845 1912083 1912083 defendant Kerver alias Goche Thomas mercer 586953 586953 Kerver alias Goche, Thomas, of Sudbury, mercer 0
3656563 1912305 1912305 defendant Heron William merchant 586953 586953 Heron, William, of Sudbury, merchant 0
3657065 1912472 1912472 defendant Manwod William mercer 586953 586953 Manwod, William, of Sudbury, mercer 0
3657069 1912473 1912473 defendant Manwod William mercer 586953 586953 Manwod, William, of Sudbury, mercer 2
3662064 1914065 1914065 defendant Skalder John grocer 586953 586953 Skalder, John, of Sudbury, grocer 6
3662068 1914065 1914065 defendant Syday Walter barber 586953 586953 Syday, Walter, of Sudbury, barber 10
3662084 1914066 1914066 defendant Skalder John grocer 586953 586953 Skalder, John, of Sudbury, grocer 7
3662088 1914066 1914066 defendant Syday Walter barber 586953 586953 Syday, Walter, of Sudbury, barber 11
3666790 1915557 1915557 plaintiff Waren alias Baker John grocer 586953 586953 Waren alias Baker, John, of sudbury, grocer 0
3666792 1915557 1915557 defendant Hardy Richard tailor 586953 586953 Hardy, Richard, of Sudbury, tailor 1
3667927 1915909 1915909 defendant Myst Thomas clothman 586953 586953 Myst, Thomas, of Sudbury, clothman 4
3667933 1915910 1915910 defendant Myst Thomas clothman 586953 586953 Myst, Thomas, of Sudbury, clothman 4
3672126 1917281 1917281 defendant Johnson Richard tanner 586953 586953 Johnson, Richard, of Sudbury, tanner 0
3672127 1917281 1917281 defendant Campeon John shoemaker 586953 586953 Campeon, John, of Sudbury, shoemaker 1
3672128 1917281 1917281 defendant Rande Richard weaver 586953 586953 Rande, Richard, of Sudbury, weaver 2
3672129 1917281 1917281 defendant Gybbon John carpenter 586953 586953 Gybbon, John, of Sudbury, carpenter 3
3674039 1917921 1917921 defendant Coley Roger weaver 586953 586953 Coley, Roger, of Sudbury, weaver 0
3675581 1918399 1918399 defendant Fycches John weaver 586953 586953 Fycches, John, of Sudbury, weaver 0
3678039 1919175 1919175 defendant Reynold John (legal representative) 586953 586953 Reynold, John, of Sudbury, baker, executors of 0
3678123 1919208 1919208 defendant Mason Thomas capper 586953 586953 Mason, Thomas, of Sudbury, capper 0
3678124 1919208 1919208 defendant Becon Thomas husbandman 586953 586953 Becon, Thomas, of Sudbury, husbandman 1
3678552 1919350 1919350 defendant Gowty William husbandman 586953 586953 Gowty, William, of Sudbury, husbandman 1
3678842 1919450 1919450 defendant Reynold Thomas miller 586953 586953 Reynold, Thomas, of Sudbury, miller 0
3678843 1919450 1919450 defendant Plomer John shoemaker 586953 586953 Plomer, John, of Sudbury, shoemaker 1
3679058 1919519 1919519 defendant Fytchys John weaver 586953 586953 Fytchys, John, of Sudbury, weaver 0
3679310 1919590 1919590 defendant Fytchys John weaver 586953 586953 Fytchys, John, of Sudbury, weaver 0
3680418 1919957 1919957 defendant Strachy Edward clothmaker 586953 586953 Strachy, Edward, of Sudbury, clothmaker 2
3683515 1920976 1920976 plaintiff Waryn alias Baker John grocer 586953 586953 Waryn alias Baker, John, of Sudbury, grocer 0
3683517 1920976 1920976 defendant Chepe Henry haberdasher 586953 586953 Chepe, Henry, of Sudbury, haberdasher 1
3683918 1921104 1921104 defendant Merelles Nicholas clothmaker 586953 586953 (Merelles, Nicholas, of Sudbury, clothmaker 1
3685359 1921575 1921575 defendant Carver Thomas chapman 586953 586953 Carver, Thomas, of Sudbury, chapman 1
3686138 1921825 1921825 defendant Wynkoll Roger clothier 586953 586953 Wynkoll, Roger, of Sudbury, clothier 0
3686139 1921825 1921825 defendant Myste Thomas clothier 586953 586953 Myste, Thomas, of Sudbury, clothier 1

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