names

158 rows where place_id = 599856

✎ 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
3638552 1906874 1906874 defendant Skynner John shoemaker 599856 599856 Skynner, John, of Beccles, Suff, shoemaker 4
3654605 1911702 1911702 defendant Freid (illegible) husbandman 599856 599856 Freid, ---, of Beccles, Suff, husbandman 2
3661097 1913746 1913746 defendant Wylde Thomas butcher 599856 599856 Wylde, Thomas, of Beccles, Suff, butcher 0
3663377 1914469 1914469 defendant Cove Robert gent & attorney in the Court of the Bench 599856 599856 Cove, Robert, of Beccles, Suff, gent & attorney in the Court of the Bench 0
3678005 1919163 1919163 defendant Fraunceys Gregory husbandman 599856 599856 Fraunceys, Gregory, of Beccles, Suff, husbandman 4
3703290 1927302 1927302 defendant Burnham Thomas   599856 599856 Burnham, Thomas, of Beccles, Suff, vestment maker 0
3831352 1967693 1967693 defendant Peke Robert tanner 599856 599856 Peke, Robert, of Beccles, Suff, tanner 0
3839654 1970327 1970327 defendant Chapleyn Thomas husbandman 599856 599856 Chapleyn, Thomas, of Beccles, Suff, husbandman 0
3844812 1971921 1971921 defendant Shrybbys Thomas butcher 599856 599856 Shrybbys, Thomas, of Beccles, Suff, butcher 3
3857831 1976087 1976087 defendant Burman John clerk 599856 599856 Burman, John, of Beccles, Suff, clerk 0
3890469 1987068 1987068 defendant Broun Thomas merchant 599856 599856 Broun, Thomas, of Beccles, Suff, merchant 3
3911787 1994267 1994267 defendant Sherman Gilbert gent 599856 599856 Sherman, Gilbert, of Beccles, Suff, gent 1
3927576 1999564 1999564 defendant Platfote William gent 599856 599856 Platfote, William, of Beccles, Suff, gent 0
3927610 1999577 1999577 defendant Harman John esq 599856 599856 Harman, John, of Beccles, Suff, esq 0
3927644 1999585 1999585 defendant Yaxley Thomas chapman 599856 599856 Yaxley, Thomas, of Beccles, Suff, chapman 1
3938094 2003075 2003075 defendant Grene Robert yeoman 599856 599856 Grene, Robert, of Beccles, Suff, yeoman 0
3938097 2003076 2003076 defendant Grene Robert yeoman 599856 599856 Grene, Robert, of Beccles, Suff, yeoman 0
3938930 2003354 2003354 defendant Rede Thomas merchant 599856 599856 Rede, Thomas, of Beccles, Suff, merchant 0
3938941 2003357 2003357 defendant Rede Thomas merchant 599856 599856 Rede, Thomas, of Beccles, Suff, merchant 0
3940315 2003779 2003779 defendant Sherman Gilbert gent 599856 599856 Sherman, Gilbert, of Beccles, Suff, gent 0
3942319 2004443 2004443 defendant Rede Thomas merchant 599856 599856 Rede, Thomas, of Beccles, Suff, merchant 0
3943878 2004967 2004967 defendant Can John mercer 599856 599856 Can, John, of Beccles, Suff, mercer 0
3966630 2012964 2012964 defendant Cowper William keelman 599856 599856 Cowper, William, of Beccles, Suff, keelman 0
3966651 2012971 2012971 defendant Cowper William keelman 599856 599856 Cowper, William, of Beccles, Suff, keelman 0
3970948 2014397 2014397 plaintiff Downyng Nicholas mercer 599856 599856 Downyng, Nicholas, of Beccles, Suff, mercer 0
3972459 2014945 2014945 defendant Downinge Nicholas   599856 599856 Downinge, Nicholas, of Beccles, Suff, linen draper 0
3991084 2021575 2021575 defendant Thurston Simon yeoman 599856 599856 (Thurston, Simon, of Beccles, Suff, yeoman 1
3992450 2022064 2022064 defendant Button Edward chapman 599856 599856 Button, Edward, of Beccles, Suff, chapman 4
3994366 2022738 2022738 defendant Thurston Simon yeoman 599856 599856 (Thurston, Simon, of Beccles, Suff, yeoman 1
4011707 2028922 2028922 defendant Thurston Simon beer brewer 599856 599856 Thurston, Simon, of Beccles, Suff, beer brewer 0
4012281 2029111 2029111 defendant Note Richard joiner 599856 599856 Note, Richard, of Beccles, Suff, joiner 3
4014980 2030071 2030071 defendant Rede Francis gent 599856 599856 Rede, Francis, of Beccles, Suff, gent 6
4045824 2040952 2040952 defendant Tebold William (legal representative) 599856 599856 Tebold, William, of Beccles, Suff, yeoman, administratrix of 3
4045831 2040953 2040953 defendant Tebold Philippa widow 599856 599856 Tebold, Philippa, of Beccles, Suff, widow 4
4047641 2041604 2041604 defendant Lawrence John glover 599856 599856 Lawrence, John, of Beccles, Suff, glover 3
4047646 2041605 2041605 defendant Lawrens John glover 599856 599856 Lawrens, John, of Beccles, Suff, glover 3
4049007 2042089 2042089 defendant Thurston Simon yeoman 599856 599856 Thurston, Simon, of Beccles, Suff, yeoman 0
4049010 2042090 2042090 defendant Cooke John barber 599856 599856 Cooke, John, of Beccles, Suff, barber 0
4049022 2042094 2042094 defendant Styward Thomas gent 599856 599856 Styward, Thomas, of Beccles, Suff, gent 0
4049025 2042095 2042095 defendant Windriche Henry yeoman 599856 599856 Windriche, Henry, of Beccles, Suff, yeoman 0
4062693 2046954 2046954 defendant Downyng Nicholas mercer 599856 599856 Downyng, Nicholas, of Beccles, Suff, mercer 0
4064144 2047453 2047453 defendant Calber Robert yeoman 599856 599856 Calber, Robert, of Beccles, Suff, yeoman 0
4064166 2047457 2047457 defendant Harsent Michael gent 599856 599856 Harsent, Michael, of Beccles, Suff, gent 0
4064996 2047765 2047765 defendant Downynge Thomas chapman 599856 599856 Downynge, Thomas, of Beccles, Suff, chapman 1
4067093 2048529 2048529 defendant Mynnes Richard saddler 599856 599856 Mynnes, Richard, of Beccles, Suff, saddler 2
4069177 2049269 2049269 defendant Goldspynke David cordwainer 599856 599856 Goldspynke, David, of Beccles, Suff, cordwainer 0
4071260 2050027 2050027 defendant Browne Jerome yeoman 599856 599856 Browne, Jerome, of Beccles, Suff, yeoman 0
4073708 2050888 2050888 defendant Cowper John baker 599856 599856 Cowper, John, of Beccles, Suff, baker 0
4115543 2065846 2065846 defendant Graye John keelman 599856 599856 Graye, John, of Beccles, Suff, keelman 0
4129181 2070738 2070738 defendant Downynge William singleman 599856 599856 Downynge, William, of Beccles, Suff, yeoman, singleman 1
4131875 2071713 2071713 defendant Sewell Robert chapman 599856 599856 Sewell, Robert, of Beccles, Suff, chapman 0
4137516 2073769 2073769 defendant Rede Francis gent 599856 599856 Rede, Francis, of Beccles, Suff, gent 0
4138444 2074114 2074114 defendant Downynge William singleman 599856 599856 Downynge, William, of Beccles, Suff, yeoman, singleman 1
4140140 2074719 2074719 defendant Downynge Barnabas merchant 599856 599856 Downynge, Barnabas, of Beccles, Suff, merchant 0
4144363 2076188 2076188 defendant Sewell Robert merchant 599856 599856 Sewell, Robert, of Beccles, Suff, merchant 0
4167758 2084213 2084213 defendant Russell John yeoman 599856 599856 Russell, John, of Beccles, Suff, yeoman 2
4172626 2085884 2085884 defendant Hersant Michael yeoman 599856 599856 Hersant, Michael, of Beccles, Suff, yeoman 0
4183753 2089806 2089806 defendant Call John grocer 599856 599856 Call, John, of Beccles, Suff, grocer 0
4195819 2094092 2094092 defendant Harsant Michael   599856 599856 Harsant, Michael, of Beccles, Suff, yeoman, court holder 0
4209491 2098868 2098868 defendant Heblethwayte Robert tanner 599856 599856 Heblethwayte, Robert, of Beccles, Suff, tanner 0
4216158 2101142 2101142 defendant Horning Thomas beer brewer 599856 599856 Horning, Thomas, of Beccles, Suff, beer brewer 0
4224880 2104168 2104168 defendant Farror Henry vintner 599856 599856 Farror, Henry, of Beccles, Suff, vintner 0
4226478 2104732 2104732 defendant Farror Henry innholder vintner 599856 599856 Farror, Henry, of Beccles, Suff, innholder vintner 0
4231069 2106366 2106366 defendant Farror Henry vintner 599856 599856 Farror, Henry, of Beccles, Suff, innholder, vintner 0
4244403 2111102 2111102 defendant Thurston Simon yeoman 599856 599856 Thurston, Simon, of Beccles, Suff, yeoman 1
4244690 2111207 2111207 defendant Ferror Henry vintner 599856 599856 Ferror, Henry, of Beccles, Suff, vintner 2
4244695 2111208 2111208 defendant Ferror Henry vintner 599856 599856 Ferror, Henry, of Beccles, Suff, vintner 3
4251145 2113360 2113360 defendant Shreve Richard yeoman 599856 599856 Shreve, Richard, of Beccles, Suff, yeoman 0
4253265 2114088 2114088 defendant Maysterson John husbandman 599856 599856 Maysterson, John, of Beccles, Suff, husbandman 3
4254788 2114595 2114595 defendant Farrer Henry chapman 599856 599856 Farrer, Henry, of Beccles, Suff, yeoman, chapman 2
4265080 2117956 2117956 defendant Shreve Richard yeoman 599856 599856 Shreve, Richard, of Beccles, Suff, yeoman 1
4267407 2118734 2118734 defendant Farrer Henry chapman 599856 599856 Farrer, Henry, of Beccles, Suff, yeoman, chapman 2
4280070 2122938 2122938 defendant Chapman Robert currier 599856 599856 Chapman, Robert, of Beccles, Suff, currier 3
4315817 2135640 2135640 defendant Baker William tanner 599856 599856 Baker,William, of Beccles, Suff, tanner 2
4319532 2136944 2136944 defendant Lyngey John yeoman 599856 599856 Lyngey, John, of Beccles, Suff, yeoman 0
4327938 2139668 2139668 defendant Dowsing alias Smyth John yeoman 599856 599856 Dowsing alias Smyth, John, of Beccles, Suff, yeoman 2
4328921 2139986 2139986 defendant Baker William tanner 599856 599856 Baker, William, of Beccles, Suff, tanner 2
4341056 2144145 2144145 defendant Call John grocer 599856 599856 Call, John, of Beccles, Suff, grocer 0
4345223 2145606 2145606 defendant Hill Ralph husbandman 599856 599856 Hill, Ralph, of Beccles, Suff, husbandman 0
4398426 2164054 2164054 defendant Brend John husbandman 599856 599856 Brend, John, of Beccles, Suff, husbandman 2
4665977 2250834 2250834 defendant Strode Robert   599856 599856 Strode, Robert, of Beccles, Suff, mason 0
4670614 2256489 2256489 defendant Rode Walter dyer 599856 599856 Rode, Walter, of Beccles, Suff, dyer 0
4673312 2257290 2257290 defendant Haldeyn John fuller 599856 599856 Haldeyn, John, of Beccles, Suff, fuller 0
4674066 2257498 2257498 defendant Caudeler William yeoman 599856 599856 Caudeler, William, of Beccles, Suff, yeoman 1
4681673 2259878 2259878 defendant Rode Walter yeoman 599856 599856 Rode, Walter, of Beccles, Suff, yeoman 1
4682205 2260056 2260056 defendant Roo Walter yeoman 599856 599856 Roo, Walter, of Beccles, Suff, yeoman 1
4682207 2260056 2260056 defendant Waynflete John dyer 599856 599856 Waynflete, John, of Beccles, Suff, dyer 3
4687818 2261759 2261759 defendant Bernard John yeoman 599856 599856 Bernard, John, of Beccles, Suff, yeoman 5
4687821 2261760 2261760 defendant Rode Walter yeoman 599856 599856 Rode, Walter, of Beccles, Suff, yeoman 0
4737677 2276890 2276890 defendant Feke Alan yeoman 599856 599856 Feke, Alan, of Beccles, Suff, yeoman 3
4743702 2278687 2278687 defendant Waynglet John dyer 599856 599856 Waynglet, John, of Beccles, Suff, dyer 3
4744089 2278797 2278797 defendant Jonesson James chandler 599856 599856 Jonesson, James, of Beccles, Suff, chandler 1
4744867 2279016 2279016 defendant Wynferthyng William yeoman 599856 599856 Wynferthyng, William, of Beccles, Suff, yeoman 0
4752038 2281087 2281087 defendant Bernard John husbandman 599856 599856 Bernard, John, of Beccles, Suff, husbandman 1
4760742 2283700 2283700 defendant Wynferthyng William husbandman 599856 599856 Wynferthyng, William, of Beccles, Suff, husbandman 0
4802312 2296912 2296912 defendant Wynneferthyng William gent 599856 599856 Wynneferthyng, William, of Beccles, Suff, gent 0
4803130 2297169 2297169 defendant Garveys Peter esq 599856 599856 Garveys, Peter, of Beccles, Suff, esq 0
4811564 2299726 2299726 plaintiff Garveys Peter esq 599856 599856 Garveys, Peter, of Beccles, Suff, esq 0
4816244 2301164 2301164 defendant Garveys Peter esq 599856 599856 Garveys, Peter, of Beccles, Suff, esq 0
4828582 2304981 2304981 defendant Hakton John baker 599856 599856 Hakton, John, of Beccles, Suff, baker 3

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