names

274 rows where place_id = 586638

✎ 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
3589276 1864285 1864285 defendant Couper William cooper 586638 586638 Couper, William, of Southwold, cooper 4
3596567 1866560 1866560 defendant Couper David husbandman 586638 586638 Couper, David, of Southwold, husbandman 5
3619273 1873630 1873630 defendant Cootis John mariner 586638 586638 Cootis, John, of Southwold, mariner 1
3628261 1903700 1903700 defendant Barker Robert draper or tailor 586638 586638 Barker, Robert, of Southwold, draper or tailor 0
3628262 1903700 1903700 defendant Strangwysse Henry mariner 586638 586638 Strangwysse, Henry, of Southwold, mariner 1
3646790 1909405 1909405 plaintiff Joye Henry mariner 586638 586638 Joye, Henry, of Southwold, mariner 0
3649024 1910084 1910084 plaintiff Pays Henry (legal representative) 586638 586638 Pays, Henry, of Southwold, freemason, executrix of 0
3657801 1912691 1912691 defendant Sutton Thomas yeoman 586638 586638 Sutton, Thomas, of Southwold, yeoman 0
3659233 1913144 1913144 plaintiff Joye Henry   586638 586638 (Joye, Henry, of Southwold 1
3665886 1915266 1915266 defendant Lyall William smith 586638 586638 Lyall, William, of Southwold, smith 0
3705016 1927861 1927861 defendant Fyske Robert laborer 586638 586638 Fyske, Robert, of Southwold, laborer 0
3717890 1931896 1931896 defendant Maydewell Edward cordwainer 586638 586638 Maydewell, Edward, of Southwold, cordwainer 0
3717891 1931896 1931896 defendant Burnam Robert merchant 586638 586638 Burnam, Robert, of Southwold, merchant 1
3731062 1935942 1935942 defendant Byrche Robert cooper 586638 586638 Byrche, Robert, of Southwold, cooper 0
3745246 1940421 1940421 defendant Josse Richard shoemaker 586638 586638 Josse, Richard, of Southwold, shoemaker 0
3747493 1941132 1941132 defendant Maydewell Edward cordwainer 586638 586638 Maydewell, Edward, of Southwold, cordwainer 0
3747494 1941132 1941132 defendant Burman Robert merchant 586638 586638 Burman, Robert, of Southwold, merchant 1
3768427 1947773 1947773 defendant Hollys Thomas baker 586638 586638 Hollys, Thomas, of Southwold, baker 0
3786158 1953463 1953463 defendant Blake John mariner 586638 586638 Blake, John, of Southwold, mariner 1
3792718 1955575 1955575 defendant Blake John mariner 586638 586638 Blake, John, of Southwold, mariner 0
3811625 1961533 1961533 defendant Walpole John husbandman 586638 586638 Walpole, John, of Southwold, husbandman 1
3812734 1961876 1961876 defendant Fowcher William mariner 586638 586638 Fowcher, William, of Southwold, mariner 0
3818258 1963625 1963625 plaintiff Bemond Robert, senior   586638 586638 (Bemond, Robert, senior, of Southwold 1
3826924 1966272 1966272 plaintiff Bemond Robert, junior merchant 586638 586638 Bemond, Robert, junior, of Southwold, merchant 0
3826925 1966272 1966272 plaintiff Byrde William   586638 586638 Byrde, William, of Southwold 1
3837309 1969578 1969578 defendant Sharpyng William roper 586638 586638 Sharpyng, William, of Southwold, roper 0
3840579 1970617 1970617 defendant Holburn Thomas merchant 586638 586638 Holburn, Thomas, of Southwold, merchant 0
3840581 1970618 1970618 defendant Holburn Thomas merchant 586638 586638 Holburn, Thomas, of Southwold, merchant 0
3856759 1975739 1975739 defendant Beamond Robert merchant 586638 586638 Beamond, Robert, of Southwold, merchant 0
3857771 1976068 1976068 plaintiff Barker William merchant 586638 586638 Barker, William, of Southwold, merchant 0
3858054 1976170 1976170 plaintiff Bemond Robert merchant 586638 586638 Bemond, Robert, of Southwold, merchant 0
3875931 1982204 1982204 defendant Howlett John, junior mariner 586638 586638 Howlett, John, junior, of Southwold, mariner 0
3885542 1985418 1985418 defendant Thomson Richard baker 586638 586638 Thomson, Richard, of Southwold, baker 1
3887951 1986220 1986220 plaintiff Rypyng James   586638 586638 Rypyng, James, of Southwold 1
3890172 1986952 1986952 defendant Browne Richard mariner 586638 586638 Browne, Richard, of Southwold, mariner 0
3890173 1986952 1986952 defendant Person Christopher mariner 586638 586638 Person, Christopher, of Southwold, mariner 1
3894062 1988231 1988231 defendant Spanton Thomas miller 586638 586638 Spanton, Thomas, of Southwold, miller 0
3894087 1988239 1988239 defendant Thompson Richard merchant 586638 586638 Thompson, Richard, of Southwold, merchant 0
3894090 1988240 1988240 defendant Blake John mariner 586638 586638 Blake, John, of Southwold, mariner 1
3898365 1989665 1989665 defendant Bemond Robert, junior (legal representative) 586638 586638 Bemond, Robert, junior, of Southwold, merchant, executor of 0
3898366 1989665 1989665 defendant Bemond Richard mariner 586638 586638 Bemond, Richard, of Southwold, mariner 1
3903567 1991422 1991422 plaintiff Goodwarn Richard (legal representative) 586638 586638 Goodwarn, Richard, of Southwold, mariner, executors of 0
3918256 1996440 1996440 plaintiff Hobard William   586638 586638 Hobard, William, of Southwold 0
3935258 2002104 2002104 plaintiff Joye William merchant 586638 586638 Joye, William, of Southwold, merchant 0
3941823 2004278 2004278 defendant Stanton Simon mariner 586638 586638 Stanton, Simon, of Southwold, mariner 1
3943552 2004863 2004863 defendant Thompson Richard mariner 586638 586638 Thompson, Richard, of Southwold, mariner 0
3945841 2005620 2005620 plaintiff Broune Robert mariner 586638 586638 Broune, Robert, of Southwold, mariner 0
3957963 2009848 2009848 defendant Blake John mariner 586638 586638 Blake, John, of Southwold, mariner 3
3957964 2009848 2009848 defendant Buckenham Richard tailor 586638 586638 Buckenham, Richard, of Southwold, tailor 4
3959395 2010369 2010369 defendant Gryndlyng Thomas yeoman 586638 586638 Gryndlyng, Thomas, of Southwold, yeoman 0
3962093 2011322 2011322 defendant Jentylman Thomas merchant 586638 586638 Jentylman, Thomas, of Southwold, merchant 1
3976868 2016481 2016481 defendant Beamount John merchant 586638 586638 Beamount, John, of Southwold, merchant 0
3976870 2016482 2016482 defendant Beamounte John merchant 586638 586638 Beamounte, John, of Southwold, merchant 0
4030051 2035394 2035394 defendant Broun Robert merchant 586638 586638 Broun, Robert, of Southwold, merchant 0
4065907 2048096 2048096 defendant Jentylman or Gentilman Thomas merchant 586638 586638 Jentylman or Gentilman, Thomas, of Southwold, merchant 0
4088692 2056256 2056256 defendant Rypynge James   586638 586638 Rypynge, James, of Southwold, Suff, sailor 2
4122733 2068423 2068423 defendant Richardson Thomas   586638 586638 Richardson, Thomas, of Southwold, shipwright 3
4146543 2076941 2076941 defendant Holbecke Humphrey mercer 586638 586638 Holbecke, Humphrey, of Southwold, mercer 1
4146544 2076941 2076941 defendant Cook Edward yeoman 586638 586638 Cook, Edward, of Southwold, yeoman 2
4193630 2093339 2093339 defendant Perye Edward yeoman 586638 586638 Perye, Edward, of Southwold, yeoman 0
4197138 2094551 2094551 defendant Perye Edward yeoman 586638 586638 Perye, Edward, of Southwold, yeoman 0
4206246 2097732 2097732 defendant Brystowe or Bryscowe Thomas   586638 586638 Brystowe or Bryscowe, Thomas, of Southwold, sailor 0
4208712 2098598 2098598 plaintiff Sellynge Richard   586638 586638 Sellynge, Richard, of Southwold 0
4215409 2100885 2100885 defendant Hallifild William mariner 586638 586638 Hallifild, William, of Southwold, mariner 0
4234541 2107626 2107626 defendant Rowland alias Vincent Robert   586638 586638 Rowland alias Vincent, Robert, of Southwold, sailor 0
4236302 2108268 2108268 defendant Garrard John merchant 586638 586638 Garrard, John, of Southwold, merchant 0
4241608 2110179 2110179 defendant Hallyfeld William mariner 586638 586638 Hallyfeld, William, of Southwold, mariner 0
4243598 2110845 2110845 defendant Gyrling Richard   586638 586638 Gyrling, Richard, of Southwold, Suff, sailor 0
4244834 2111262 2111262 defendant Garrard John merchant 586638 586638 Garrard, John, of Southwold, merchant 0
4274030 2120860 2120860 defendant Cruckling Robert yeoman 586638 586638 Cruckling, Robert, of Southwold, yeoman 0
4275254 2121281 2121281 defendant Waters William   586638 586638 Waters, William, of Southwold, sailor 3
4275269 2121286 2121286 defendant Gentleman John gent 586638 586638 Gentleman, John, of Southwold, gent 0
4275270 2121286 2121286 defendant Gentleman William gent 586638 586638 Gentleman, William, of Southwold, gent 1
4279235 2122668 2122668 defendant Wright Thomas yeoman 586638 586638 Wright, Thomas, of Southwold, yeoman 1
4280436 2123065 2123065 defendant Herington Stephen   586638 586638 Herington, Stephen, of Southwold, sailor 0
4289686 2126376 2126376 defendant Rooke Thomas   586638 586638 Rooke, Thomas, of Southwold, sailor 1
4291686 2127101 2127101 defendant Hodd John mariner 586638 586638 Hodd, John, of Southwold, mariner 0
4301731 2130727 2130727 defendant Crucklinge Robert yeoman 586638 586638 Crucklinge, Robert, of Southwold, yeoman 0
4303340 2131295 2131295 defendant Goodwyn Robert tailor 586638 586638 Goodwyn, Robert, of Southwold, tailor 0
4304539 2131724 2131724 defendant Turner Abselon innholder 586638 586638 Turner, Abselon, of Southwold, innholder 1
4307627 2132807 2132807 defendant Garrard John mercer 586638 586638 Garrard, John, of Southwold, mercer 1
4311727 2134243 2134243 defendant Jentilman John merchant 586638 586638 Jentilman, John, of Southwold, merchant 2
4331835 2140939 2140939 defendant Holbecke Thomas gent 586638 586638 Holbecke, Thomas, of Southwold, gent 0
4354245 2148715 2148715 defendant Crookelinge Robert yeoman 586638 586638 Crookelinge, Robert, of Southwold, yeoman 2
4373339 2155531 2155531 defendant Lonnys os Lunnis Thomas beer brewer 586638 586638 Lonnys os Lunnis, Thomas, of Southwold, beer brewer 0
4389793 2161210 2161210 defendant Fyrthe John, junior   586638 586638 Fyrthe, John, junior, of Southwold, sailor 0
4400263 2164680 2164680 defendant Jentillman Richard merchant 586638 586638 Jentillman, Richard, of Southwold, merchant 0
4411880 2168567 2168567 defendant Slath Robert   586638 586638 Slath Robert, of Southwold tailor 1
4411888 2168569 2168569 defendant Slath Robert   586638 586638 Slath Robert, of Southwold tailor 1
4474004 2192521 2192521 defendant Waynflete Henry   586638 586638 Waynflete, Henry, of Southwold 0
4476743 2193387 2193387 defendant Lyon Michael   586638 586638 Lyon, Michael, of Southwold 0
4637339 2242473 2242473 defendant Millere William   586638 586638 Millere, William, of Southwold 0
4747691 2279833 2279833 plaintiff Lavymer or Lanymer Richard (legal representative) 586638 586638 Lavymer or Lanymer, Richard, of Southwold, executors of 0
4747693 2279833 2279833 plaintiff Bysshop John   586638 586638 Bysshop, John, of Southwold 2
4797055 2295245 2295245 plaintiff Skylman Richard   586638 586638 Skylman, Richard, of Southwold 0
4839062 2308146 2308146 defendant Rowe Robert shipman 586638 586638 Rowe, Robert, of Southwold, shipman 0
4839063 2308146 2308146 defendant Lowan William shipman 586638 586638 Lowan, William, of Southwold, shipman 1
4846264 2310334 2310334 defendant Buschop John shipman 586638 586638 Buschop, John, of Southwold, shipman 1
4857383 2313698 2313698 defendant Chaunterell William shipman 586638 586638 Chaunterell, William, of Southwold, shipman 1
4857384 2313698 2313698 defendant Neweman Stephen shipman 586638 586638 Neweman, Stephen, of Southwold, shipman 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);