names

239 rows where place_id = 598258

✎ 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
3631753 1904739 1904739 defendant Carew John husbandman 598258 598258 Carew, John, of Bury St Edmunds, Suff, husbandman 1
3654642 1911711 1911711 defendant Ordue Robert draper 598258 598258 Ordue, Robert, of Bury St Edmunds, Suff, draper 0
3654734 1911738 1911738 defendant Watson John yeoman 598258 598258 Watson, John, of Bury St Edmunds, Suff, yeoman 0
3654753 1911744 1911744 defendant Watson John yeoman 598258 598258 Watson, John, of Bury St Edmunds, Suff, yeoman 0
3655286 1911912 1911912 defendant Lucas Jasper gent 598258 598258 Lucas, Jasper, of Bury St Edmunds, Suff, gent 0
3656065 1912150 1912150 defendant Hyll John   598258 598258 Hyll, John, of Bury St Edmunds, Suff, boke maker 1
3660303 1913483 1913483 defendant Rede John yeoman 598258 598258 Rede, John, of Bury St Edmunds, Suff, yeoman 0
3663406 1914479 1914479 defendant Dogered William   598258 598258 Dogered, William, of Bury St Edmunds, Suff, inn holder 0
3663431 1914489 1914489 defendant Dogered William   598258 598258 Dogered, William, of Bury St Edmunds, Suff, inn holder 1
3664122 1914730 1914730 defendant Barker John mercer 598258 598258 Barker, John, of Bury St Edmunds, Suff, mercer 1
3665624 1915199 1915199 defendant Rede John yeoman 598258 598258 Rede, John, of Bury St Edmunds, Suff, yeoman 0
3665958 1915287 1915287 defendant Coke John yeoman 598258 598258 Coke, John, of Bury St Edmunds, Suff, yeoman 0
3665968 1915289 1915289 defendant Fermyn John sadler 598258 598258 Fermyn, John, of Bury St Edmunds, Suff, sadler 0
3667116 1915647 1915647 defendant Blakman Robert mercer 598258 598258 Blakman, Robert, of Bury St Edmunds, Suff, mercer 2
3762752 1945990 1945990 defendant Reede Reginald roper 598258 598258 Reede, Reginald, of Bury St Edmunds, Suff, roper 1
3848713 1973184 1973184 defendant Sewell John merchant and hardwareman 598258 598258 Sewell, John, of Bury St Edmunds, Suff, merchant and hardwareman 2
3889239 1986638 1986638 defendant Denton William cordwainer 598258 598258 Denton, William, of Bury St Edmunds, Suff, cordwainer 2
3928481 1999864 1999864 defendant Cotton William yeoman 598258 598258 Cotton, William, of Bury St Edmunds, Suff, yeoman 1
3928530 1999881 1999881 defendant Yarforth Anthony yeoman 598258 598258 Yarforth, Anthony, of Bury St Edmunds, Suff, yeoman 0
3928896 2000003 2000003 defendant Platt Nicholas merchant 598258 598258 Platt, Nicholas, of Bury St Edmunds, Suff, merchant 0
3929165 2000095 2000095 defendant Platt Nicholas merchant 598258 598258 Platt, Nicholas, of Bury St Edmunds, Suff, merchant 0
3929387 2000175 2000175 defendant Sharpe Henry mercer 598258 598258 Sharpe, Henry, of Bury St Edmunds, Suff, mercer 1
3932743 2001252 2001252 defendant Smythe William chapman 598258 598258 Smythe, William, of Bury St Edmunds, Suff, chapman 0
3936639 2002581 2002581 defendant Bryght John chapman 598258 598258 Bryght, John, of Bury St Edmunds, Suff, chapman 0
3937899 2003008 2003008 defendant Whytehande alias Pratt Edward baker 598258 598258 Whytehande alias Pratt, Edward, of Bury St Edmunds, Suff, baker 0
3941920 2004309 2004309 defendant Rede Joan widow 598258 598258 Rede, Joan, of Bury St Edmunds, Suff, widow 0
3941923 2004310 2004310 defendant Rede Joan widow 598258 598258 Rede, Joan, of Bury St Edmunds, Suff, widow 0
3942193 2004408 2004408 defendant Evans William gent 598258 598258 Evans, William, of Bury St Edmunds, Suff, gent 1
3942512 2004503 2004503 defendant Wood William gent 598258 598258 Wood, William, of Bury St Edmunds, Suff, gent 0
3945107 2005383 2005383 defendant Smyth William chapman 598258 598258 Smyth, William, of Bury St Edmunds, Suff, chapman 0
3986148 2019816 2019816 defendant Heasyll Henry butcher 598258 598258 Heasyll, Henry, of Bury St Edmunds, Suff, butcher 0
4306025 2132245 2132245 defendant Cage Margaret widow 598258 598258 Cage, Margaret, of Bury St Edmunds, Suff, widow 3
4668405 2255830 2255830 defendant Salle Geoffrey chapman 598258 598258 Salle, Geoffrey, of Bury St Edmunds, Suff, chapman 1
4671995 2256885 2256885 defendant Gisill Thomas mercer 598258 598258 Gisill, Thomas, of Bury St Edmunds, Suff, mercer 0
4672441 2257033 2257033 defendant Warner John dyer 598258 598258 Warner, John, of Bury St Edmunds, Suff, dyer 1
4672812 2257138 2257138 defendant Snethe William chapman 598258 598258 Snethe, William, of Bury St Edmunds, Suff, chapman 0
4672940 2257177 2257177 defendant Bryncheley John tailor 598258 598258 Bryncheley, John, of Bury St Edmunds, Suff, tailor 2
4672944 2257178 2257178 defendant Bryncheley John tailor 598258 598258 Bryncheley, John, of Bury St Edmunds, Suff, tailor 2
4673774 2257420 2257420 defendant Godard Robert taverner 598258 598258 Godard, Robert, of Bury St Edmunds, Suff, taverner 0
4676709 2258335 2258335 defendant Deken Thomas taverner 598258 598258 Deken, Thomas, of Bury St Edmunds, Suff, taverner 0
4676896 2258393 2258393 defendant Orefrior Thomas   598258 598258 Orefrior, Thomas, of Bury St Edmunds, Suff, vestment maker 1
4685268 2260989 2260989 defendant Damat John taverner 598258 598258 Damat, John, of Bury St Edmunds, Suff, taverner 0
4685537 2261070 2261070 defendant Toot John tailor 598258 598258 Toot, John, of Bury St Edmunds, Suff, tailor 2
4693727 2263539 2263539 defendant Godard Robert taverner 598258 598258 Godard, Robert, of Bury St Edmunds, Suff, taverner 0
4696934 2264518 2264518 defendant Parmounter William tanner 598258 598258 Parmounter, William, of Bury St Edmunds, Suff, tanner 3
4702825 2266281 2266281 defendant Toppesfeld William gent 598258 598258 Toppesfeld, William, of Bury St Edmunds, Suff, gent 3
4702832 2266282 2266282 defendant Toppesfeld William gent 598258 598258 Toppesfeld, William, of Bury St Edmunds, Suff, gent 2
4704613 2266819 2266819 defendant Crabbe John yeoman 598258 598258 Crabbe, John, of Bury St Edmunds, Suff, yeoman 0
4707125 2267611 2267611 defendant Bote Thomas husbandman 598258 598258 Bote, Thomas, of Bury St Edmunds, Suff, husbandman 1
4712753 2269302 2269302 defendant Brynkeley thomas tailor 598258 598258 Brynkeley, thomas, of Bury St Edmunds, Suff, tailor 1
4719267 2271373 2271373 defendant Crabbe John summoner 598258 598258 Crabbe, John, of Bury St Edmunds, Suff, summoner 0
4725328 2273214 2273214 defendant Gardenere Simon chapman 598258 598258 Gardenere, Simon, of Bury St Edmunds, Suff, chapman 0
4730950 2274878 2274878 defendant Damat John taverner 598258 598258 Damat, John, of Bury St Edmunds, Suff, taverner 0
4733580 2275679 2275679 defendant Damat John taverner 598258 598258 Damat, John, of Bury St Edmunds, Suff, taverner 0
4733866 2275775 2275775 defendant Damat John taverner 598258 598258 Damat, John, of Bury St Edmunds, Suff, taverner 0
4742472 2278298 2278298 defendant Palmere John baker 598258 598258 Palmere, John, of Bury St Edmunds, Suff, baker 0
4743436 2278610 2278610 defendant Toft John   598258 598258 Toft, John, of Bury St Edmunds, Suff, text writer 0
4745404 2279162 2279162 defendant Willyngholme John draper 598258 598258 Willyngholme, John, of Bury St Edmunds, Suff, draper 0
4745406 2279163 2279163 defendant Wylyngholme John draper 598258 598258 Wylyngholme, John, of Bury St Edmunds, Suff, draper 0
4748361 2280027 2280027 defendant Methewold Robert chapman 598258 598258 Methewold, Robert, of Bury St Edmunds, Suff, chapman 3
4748367 2280028 2280028 defendant Methewold Robert chapman 598258 598258 Methewold, Robert, of Bury St Edmunds, Suff, chapman 3
4752163 2281111 2281111 defendant Lystere Walter   598258 598258 Lystere, Walter, of Bury St Edmunds, Suff 0
4754419 2281762 2281762 defendant Hethe Richard esq 598258 598258 Hethe, Richard, of Bury St Edmunds, suff, esq 0
4757327 2282663 2282663 defendant Carleton Katherine widow 598258 598258 Carleton, Katherine, of Bury St Edmunds, Suff, widow 0
4760279 2283568 2283568 defendant Salle Geoffrey gent 598258 598258 Salle, Geoffrey, of Bury St Edmunds, Suff, gent 0
4802954 2297110 2297110 defendant Odom John draper 598258 598258 Odom, John, of Bury St Edmunds, Suff, draper 0
4805432 2297907 2297907 defendant Ermyte John dyer 598258 598258 Ermyte, John, of Bury St Edmunds, Suff, dyer 0
4805869 2298043 2298043 defendant Brook William yeoman 598258 598258 Brook, William, of Bury St Edmunds, Suff, yeoman 0
4808291 2298771 2298771 defendant Hog John yeoman 598258 598258 Hog, John, of Bury St Edmunds, Suff, yeoman 1
4810996 2299554 2299554 defendant Bryd William (legal representative) 598258 598258 Bryd, William, of Bury St Edmunds, Suff, executors of 1
4815779 2301039 2301039 defendant Denston Clement clerk 598258 598258 Denston, Clement, of Bury St Edmunds, Suff, clerk 0
4834381 2306760 2306760 defendant Tytenale William mercer 598258 598258 Tytenale, William, of Bury St Edmunds, Suff, mercer 0
4834388 2306762 2306762 defendant Tytenale William mercer 598258 598258 Tytenale, William, of Bury St Edmunds, Suff, mercer 0
4836758 2307464 2307464 defendant Porter John tailor 598258 598258 Porter, John, of Bury St Edmunds, Suff, tailor 0
4836806 2307474 2307474 defendant Porter John tailor 598258 598258 Porter, John, of Bury St Edmunds, Suff, tailor 0
4838566 2307982 2307982 defendant Lardyner John yeoman 598258 598258 Lardyner, John, of Bury St Edmunds, Suff, yeoman 1
4844418 2309766 2309766 defendant Acton Robert yeoman 598258 598258 Acton, Robert, of Bury St Edmunds, Suff, yeoman 1
4853671 2312564 2312564 defendant Draweswerd John chapman 598258 598258 Draweswerd, John, of Bury St Edmunds, Suff, chapman 0
4892553 2324399 2324399 defendant Clerke William woolman 598258 598258 Clerke, William, of Bury St Edmunds, Suff, woolman 3
4914695 2331113 2331113 defendant Shardelewe John gent 598258 598258 Shardelewe, John, of Bury St Edmunds, Suff, gent 0
4914706 2331114 2331114 defendant Shardelowe John gent 598258 598258 Shardelowe, John, of Bury St Edmunds, Suff, gent 0
4920289 2332859 2332859 defendant Vale Thomas dyer 598258 598258 Vale, Thomas, of Bury St Edmunds, Suff, dyer 0
4920293 2332860 2332860 defendant Vale Thomas dyer 598258 598258 Vale, Thomas, of Bury St Edmunds, Suff, dyer 0
4929945 2335776 2335776 defendant Fletcher Simon yeoman 598258 598258 Fletcher, Simon, of Bury St Edmunds, Suff, yeoman 1
4930374 2335899 2335899 defendant Fotyng William yeoman 598258 598258 Fotyng, William, of Bury St Edmunds, Suff, yeoman 1
4988896 2353630 2353630 defendant Pekhare William yeoman 598258 598258 Pekhare, William, of Bury St Edmunds, Suff, yeoman 5
4988905 2353631 2353631 defendant Norman Henry plumber 598258 598258 Norman, Henry, of Bury St Edmunds, Suff, plumber 1
4989483 2353789 2353789 defendant Barley Simon chapman 598258 598258 Barley, Simon, of Bury St Edmunds, Suff, chapman 0
4989499 2353794 2353794 defendant Barley Simon chapman 598258 598258 Barley, Simon, of Bury St Edmunds, Suff, chapman 0
4991085 2354223 2354223 defendant Symmes John fuller 598258 598258 Symmes, John, of Bury St Edmunds, Suff, fuller 0
4998255 2356347 2356347 defendant Sylom John tailor 598258 598258 Sylom, John, of Bury St Edmunds, Suff, tailor 0
4998258 2356348 2356348 defendant Sylom John tailor 598258 598258 Sylom, John, of Bury St Edmunds, Suff, tailor 0
4999129 2356616 2356616 defendant Barowe James   598258 598258 Barowe, James, of Bury St Edmunds, Suff, text writer 0
5001903 2357455 2357455 defendant Bertram John gent 598258 598258 Bertram, John, of Bury St Edmunds, Suff, gent 2
5002057 2357503 2357503 defendant Stevenes William draper 598258 598258 Stevenes, William, of Bury St Edmunds, Suff, draper 3
5005092 2358389 2358389 defendant Jaye John armourer 598258 598258 Jaye, John, of Bury St Edmunds, Suff, armourer 0
5039120 2368347 2368347 defendant Brigge John woolman 598258 598258 Brigge, John, of Bury St Edmunds, Suff, woolman 0
5039122 2368347 2368347 defendant Wode Thomas brewer 598258 598258 Wode, Thomas, of Bury St Edmunds, Suff, brewer 2
5039904 2368578 2368578 defendant Harpour John weaver 598258 598258 Harpour, John, of Bury St Edmunds, Suff, weaver 0
5040171 2368660 2368660 defendant Ardern John gent 598258 598258 Ardern, John, of Bury St Edmunds, Suff, gent 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);