names

271 rows where place_id = 588833

✎ 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
3595734 1866296 1866296 defendant Walker William husbandman 588833 588833 Walker, William, of Stratton, husbandman 1
3596459 1866520 1866520 defendant Hore Robert yeoman 588833 588833 Hore, Robert, of Stratton, yeoman 0
3612139 1871438 1871438 defendant Hore John husbandman 588833 588833 Hore, John, of Stratton, husbandman 0
3612140 1871438 1871438 defendant Baudyn or Bandyn William husbandman 588833 588833 Baudyn or Bandyn, William, of Stratton, husbandman 1
3633883 1905406 1905406 defendant Curteys John yeoman 588833 588833 Curteys, John, of Stratton, yeoman 1
3635863 1906015 1906015 defendant Kemsall Thomas husbandman 588833 588833 Kemsall, Thomas, of Stratton, husbandman 1
3639295 1907100 1907100 defendant Grentowe Thomas clerk 588833 588833 Grentowe, Thomas, of Stratton, clerk 3
3648689 1909977 1909977 defendant Dey William laborer 588833 588833 Dey, William, of Stratton, laborer 0
3673511 1917740 1917740 defendant Smyth John laborer 588833 588833 Smyth, John, of Stratton, laborer 0
3682865 1920750 1920750 defendant Hykett Thomas husbandman 588833 588833 Hykett, Thomas, of Stratton, husbandman 0
3727485 1934873 1934873 plaintiff Wawen Richard tailor 588833 588833 Wawen, Richard, of Stratton, tailor 0
3751137 1942280 1942280 defendant Uxlowe Robert cordwainer 588833 588833 Uxlowe, Robert, of Stratton, cordwainer 0
3751139 1942280 1942280 defendant Ede John laborer 588833 588833 Ede, John, of Stratton, laborer 2
3756203 1943897 1943897 defendant Gardener John husbandman 588833 588833 Gardener, John, of Stratton, husbandman 3
3759703 1945026 1945026 defendant Smale Stephen weaver 588833 588833 Smale, Stephen, of Stratton, weaver 0
3772524 1949097 1949097 defendant Nicoll Thomas yeoman 588833 588833 Nicoll, Thomas, of Stratton, yeoman 3
3780155 1951515 1951515 defendant Colman William husbandman 588833 588833 Colman, William, of Stratton St Peter, husbandman 1
3796796 1956882 1956882 defendant Glynton Thomas gent 588833 588833 Glynton, Thomas, of Stratton, gent 0
3808597 1960568 1960568 plaintiff Armygerd John   588833 588833 Armygerd, John, of Stratton, wheel wright 0
3827496 1966465 1966465 defendant Wolmer Robert husbandman 588833 588833 Wolmer, Robert, of Stratton, husbandman 0
3842190 1971104 1971104 defendant Wolmer Robert husbandman 588833 588833 Wolmer, Robert, of Stratton, husbandman 0
3842917 1971318 1971318 defendant Meryffeld Joan widow 588833 588833 Meryffeld, Joan, of Stratton, widow 0
3842918 1971318 1971318 defendant Gayre Ralph husbandman 588833 588833 Gayre, Ralph, of Stratton, husbandman 1
3849925 1973563 1973563 defendant Hekytt John smith 588833 588833 Hekytt, John, of Stratton, smith 1
3850214 1973659 1973659 defendant Hollond John draper 588833 588833 Hollond, John, of Stratton, draper 0
3869344 1979989 1979989 defendant Carwithan John gent 588833 588833 Carwithan, John, of Stratton, gent 2
3884775 1985183 1985183 plaintiff Armysyerd John yeoman 588833 588833 Armysyerd, John, of Stratton, yeoman 0
3891368 1987378 1987378 defendant Tayler Thomas tailor 588833 588833 Tayler, Thomas, of Stratton, tailor 0
3922196 1997731 1997731 defendant Sexten Stephen husbandman 588833 588833 Sexten, Stephen, of Stratton, husbandman 3
3923599 1998202 1998202 defendant Corry Richard mercer 588833 588833 Corry, Richard, of Stratton, mercer 0
3929822 2000313 2000313 defendant Jule or Inle Walter   588833 588833 Jule or Inle, Walter, of Stratton husbandman 1
3946979 2006007 2006007 defendant Salmon Thomas yeoman 588833 588833 Salmon, Thomas, of Stratton, yeoman 0
3955363 2008941 2008941 defendant Mark Richard glover 588833 588833 Mark, Richard, of Stratton, glover 0
3958429 2010019 2010019 defendant Judde John husbandman 588833 588833 Judde, John, of Stratton, husbandman 2
3958430 2010019 2010019 defendant Hore Christopher husbandman 588833 588833 Hore, Christopher, of Stratton, husbandman 3
3958431 2010019 2010019 defendant Wyll Nicholas laborer 588833 588833 Wyll, Nicholas, of Stratton, laborer 4
3971631 2014639 2014639 defendant Cloppam Edmund yeoman 588833 588833 Cloppam, Edmund, of Stratton, yeoman 1
3971632 2014639 2014639 defendant Harryson John yeoman 588833 588833 Harryson, John, of Stratton, yeoman 2
3971736 2014676 2014676 defendant Lyncoln Thomas butcher 588833 588833 Lyncoln, Thomas, of Stratton, butcher 0
3999948 2024751 2024751 defendant Marsham Henry gent 588833 588833 Marsham, Henry, of Stratton, gent 0
4004726 2026466 2026466 defendant Manaring alias Hawkyns Henry miller 588833 588833 Manaring alias Hawkyns, Henry, of Stratton, miller 0
4015013 2030073 2030073 defendant Seman Robert husbandman 588833 588833 Seman, Robert, of Stratton, husbandman 5
4019491 2031700 2031700 defendant Jule Justinian cordwainer 588833 588833 Jule, Justinian, of Stratton, cordwainer 0
4039754 2038832 2038832 plaintiff Marsham Henry, senior   588833 588833 Marsham, Henry, senior, of Stratton 0
4052052 2043158 2043158 defendant Murcocke Valentine yeoman 588833 588833 Murcocke, Valentine, of Stratton, yeoman 0
4052056 2043159 2043159 defendant Murcocke Valentine yeoman 588833 588833 Murcocke, Valentine, of Stratton, yeoman 0
4054011 2043815 2043815 defendant Grave Edmund husbandman 588833 588833 Grave, Edmund, of Stratton, husbandman 0
4054188 2043884 2043884 defendant Bonde John husbandman 588833 588833 Bonde, John, of Stratton, husbandman 5
4054678 2044063 2044063 defendant Uglowe John husbandman 588833 588833 Uglowe, John, of Stratton, husbandman 0
4054679 2044063 2044063 defendant Browne John husbandman 588833 588833 Browne, John, of Stratton, husbandman 1
4054680 2044063 2044063 defendant Uglowe John, junior   588833 588833 Uglowe, John, junior, of Stratton, groom 2
4055914 2044495 2044495 defendant Remett Simon cooper 588833 588833 Remett, Simon, of Stratton, cooper 2
4059168 2045678 2045678 defendant Kechyn Thomas cordwainer 588833 588833 Kechyn, Thomas, of Stratton, cordwainer 0
4068035 2048873 2048873 defendant Wyll alias Taheyle William, senior husbandman 588833 588833 Wyll alias Taheyle, William, senior, of Stratton, husbandman 1
4074391 2051145 2051145 defendant Hore Christopher husbandman 588833 588833 Hore, Christopher, of Stratton, husbandman 0
4074392 2051145 2051145 defendant Jule John miller 588833 588833 Jule, John, of Stratton, miller 1
4076682 2051944 2051944 defendant Seman Robert husbandman 588833 588833 Seman, Robert, of Stratton, husbandman 8
4077754 2052336 2052336 defendant Smyth Angelus or Angel yeoman 588833 588833 Smyth, Angelus or Angel, of Stratton, yeoman 0
4087771 2055919 2055919 defendant Holt John knacker 588833 588833 Holt, John, of Stratton, knacker 1
4088727 2056270 2056270 defendant Will William husbandman 588833 588833 Will, William, of Stratton, husbandman 0
4088728 2056270 2056270 defendant Willes Nicholas husbandman 588833 588833 Willes, Nicholas, of Stratton, husbandman 1
4088729 2056270 2056270 defendant Hore Christopher husbandman 588833 588833 Hore, Christopher, of Stratton, husbandman 2
4088730 2056270 2056270 defendant Meager William husbandman 588833 588833 Meager, William, of Stratton, husbandman 3
4100509 2060509 2060509 defendant Pygott Michael gent 588833 588833 Pygott, Michael, of Stratton, or of Felsted, Essex, gent 0
4100510 2060509 2060509 defendant Pygott Francis gent 588833 588833 Pygott, Francis, of Stratton, gent 1
4127537 2070139 2070139 defendant Lyn James innkeeper 588833 588833 Lyn, James, of Stratton, innkeeper 3
4146201 2076822 2076822 defendant Marham Ralph or Randolph clerk 588833 588833 Marham, Ralph or Randolph, of Stratton, clerk 0
4146203 2076823 2076823 defendant Marham Ralph clerk 588833 588833 Marham, Ralph, of Stratton, clerk 0
4158706 2081119 2081119 defendant Chinge John, senior tailor 588833 588833 Chinge, John, senior, of Stratton, tailor 0
4166373 2083733 2083733 defendant Towneshend Edmund gent 588833 588833 Towneshend, Edmund, of Stratton, gent 2
4203746 2096867 2096867 defendant Randall John chapman 588833 588833 Randall, John, of Stratton, chapman 1
4220427 2102647 2102647 defendant Hore Christopher husbandman 588833 588833 Hore, Christopher, of Stratton, husbandman 2
4234227 2107507 2107507 defendant Babstocke John yeoman 588833 588833 Babstocke, John, of Stratton, yeoman 1
4245384 2111431 2111431 defendant Gillett John husbandman 588833 588833 Gillett, John, of Stratton, husbandman 2
4245819 2111582 2111582 defendant Togood   tailor 588833 588833 Togood, , of Stratton, tailor 2
4245823 2111583 2111583 defendant Togood Edward tailor 588833 588833 Togood, Edward, of Stratton, tailor 2
4252700 2113889 2113889 defendant Babstocke John husbandman 588833 588833 Babstocke, John, of Stratton, husbandman 0
4257348 2115432 2115432 defendant Gillett John husbandman 588833 588833 Gillett, John, of Stratton, husbandman 2
4299482 2129905 2129905 defendant Hawkyns Thomas miller 588833 588833 Hawkyns, Thomas, of Stratton, miller 1
4305092 2131922 2131922 defendant Harrys alias Childe Maurice saddler 588833 588833 Harrys alias Childe, Maurice, of Stratton, saddler 1
4307968 2132929 2132929 defendant Babstocke John husbandman 588833 588833 Babstocke, John, of Stratton, husbandman 1
4329398 2140142 2140142 defendant Johnson Robert thatcher 588833 588833 Johnson, Robert, of Stratton, thatcher 3
4331723 2140907 2140907 defendant Hodge John cordwainer 588833 588833 Hodge, John, of Stratton, cordwainer 1
4335797 2142250 2142250 defendant Butler Robert yeoman 588833 588833 Butler, Robert, of Stratton, yeoman 0
4352405 2148079 2148079 defendant Hodge John cordwainer 588833 588833 Hodge, John, of Stratton, cordwainer 1
4387604 2160492 2160492 defendant Webster Richard husbandman 588833 588833 Webster, Richard, of Stratton, husbandman 2
4387609 2160493 2160493 defendant Webster Richard husbandman 588833 588833 Webster, Richard, of Stratton, husbandman 2
4388261 2160703 2160703 defendant Radd George tailor 588833 588833 Radd, George, of Stratton, tailor 1
4389634 2161163 2161163 defendant Jule Thomas, junior cordwainer 588833 588833 Jule, Thomas, junior, of Stratton, cordwainer 0
4390470 2161431 2161431 defendant Manneringe or Mannery alias Hawkyns Thomas miller 588833 588833 Manneringe or Mannery alias Hawkyns, Thomas, of Stratton, miller 0
4395821 2163183 2163183 defendant Gaynesborough Robert yeoman 588833 588833 Gaynesborough, Robert, of Stratton, yeoman 2
4397701 2163807 2163807 defendant Manner alias Hawkyns Thomas miller 588833 588833 Manner alias Hawkyns, Thomas, of Stratton, miller 0
4404590 2166106 2166106 defendant Radde John, senior husbandman 588833 588833 Radde, John, senior, of Stratton, husbandman 0
4410277 2168035 2168035 defendant Stanton Nicholas yeoman 588833 588833 Stanton, Nicholas, of Stratton, yeoman 2
4448330 2184403 2184403 defendant Wyghtman Thomas   588833 588833 Wyghtman, Thomas, of Stratton 0
4448332 2184404 2184404 defendant Wyghtman Thomas   588833 588833 Wyghtman, Thomas, of Stratton 0
4462017 2188818 2188818 defendant Craunce Geoffrey   588833 588833 Craunce, Geoffrey, of Stratton 0
4490515 2197725 2197725 defendant Kyngeman William   588833 588833 Kyngeman, William, of Stratton 9
4497873 2199975 2199975 defendant Crass John   588833 588833 Crass, John, of Stratton 0
4509804 2203552 2203552 defendant Turkeys Simon   588833 588833 Turkeys, Simon, of Stratton 0

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