names

112 rows where place_id = 586308

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588397 1864019 1864019 defendant Alysaunder Katherine spinster 586308 586308 Alysaunder, Katherine, of Walsham, spinster 4
3592230 1865186 1865186 defendant Berne Thomas, senior husbandman 586308 586308 Berne, Thomas, senior, of Walsham, husbandman 0
3592231 1865186 1865186 defendant Berne Thomas, junior husbandman 586308 586308 Berne, Thomas, junior, of Walsham, husbandman 1
3592234 1865187 1865187 defendant Berne Thomas, senior husbandman 586308 586308 Berne, Thomas, senior, of Walsham, husbandman 0
3592235 1865187 1865187 defendant Berne Thomas, junior husbandman 586308 586308 Berne, Thomas, junior, of Walsham, husbandman 1
3592239 1865188 1865188 defendant Berne Thomas, senior husbandman 586308 586308 Berne, Thomas, senior, of Walsham, husbandman 0
3592240 1865188 1865188 defendant Berne Thomas, junior husbandman 586308 586308 Berne, Thomas, junior, of Walsham, husbandman 1
3598284 1867095 1867095 plaintiff Smyth Thomas   586308 586308 Smyth, Thomas, of Walsham 0
3604246 1868992 1868992 defendant Robhood Stephen husbandman 586308 586308 Robhood, Stephen, of Walsham, husbandman 1
3606638 1869750 1869750 plaintiff Pakke Robert (legal representative) 586308 586308 Pakke, Robert, of Walsham, executors of 0
3616177 1872698 1872698 defendant Rychman John tailor 586308 586308 Rychman, John, of Walsham, tailor 2
3620743 1874063 1874063 defendant Fraunces George husbandman 586308 586308 Fraunces, George, of Walsham, husbandman 1
3620747 1874064 1874064 defendant Fraunces George husbandman 586308 586308 Fraunces, George, of Walsham, husbandman 1
3622853 1874675 1874675 defendant Fraunceys George husbandman 586308 586308 Fraunceys, George, of Walsham, husbandman 0
3622855 1874675 1874675 defendant Ebell or Evell Thomas husbandman 586308 586308 Ebell or Evell, Thomas, of Walsham, husbandman 2
3633170 1905186 1905186 defendant Fuller William tailor 586308 586308 Fuller, William, of Walsham, tailor 3
3657844 1912703 1912703 defendant Reve George husbandman 586308 586308 Reve, George, of Walsham, husbandman 2
3673532 1917748 1917748 defendant Gylmyn Edmund laborer 586308 586308 Gylmyn, Edmund, of Walsham, laborer 2
3688532 1922573 1922573 defendant Smeth John pardoner 586308 586308 Smeth, John, of Walsham, pardoner 0
3688533 1922573 1922573 defendant Sheppard John yeoman 586308 586308 Sheppard, John, of Walsham, yeoman 1
3690388 1923156 1923156 defendant Smeth John yeoman 586308 586308 Smeth, John, of Walsham, yeoman 2
3694205 1924391 1924391 defendant Hawys John yeoman 586308 586308 Hawys, John, of Walsham, yeoman 3
3702301 1926977 1926977 defendant Margery Thomas   586308 586308 Margery, Thomas, of Walsham, collar maker 1
3703232 1927282 1927282 defendant Cubytt George husbandman 586308 586308 Cubytt, George, of Walsham, husbandman 0
3718833 1932170 1932170 defendant Smethe John yeoman 586308 586308 Smethe, John, of Walsham, yeoman 1
3718836 1932171 1932171 defendant Smethe John yeoman 586308 586308 Smethe, John, of Walsham, yeoman 1
3726690 1934609 1934609 defendant Smyth John husbandman 586308 586308 Smyth, John, of Walsham, husbandman 5
3731335 1936022 1936022 plaintiff Carman Robert   586308 586308 Carman, Robert, of Walsham 0
3732665 1936448 1936448 defendant Smyth John (legal representative) 586308 586308 Smyth, John, of Walsham, administrator of 2
3732666 1936448 1936448 defendant Smyth Robert husbandman 586308 586308 Smyth, Robert, of Walsham, husbandman 3
3732736 1936469 1936469 defendant Cubytt George husbandman 586308 586308 Cubytt, George, of Walsham, husbandman 0
3732739 1936470 1936470 defendant Cubytt George husbandman 586308 586308 Cubytt, George, of Walsham, husbandman 0
3732941 1936526 1936526 defendant Sheppard John yeoman 586308 586308 Sheppard, John, of Walsham, yeoman 2
3739067 1938427 1938427 defendant Gylmyn Edmund   586308 586308 Gylmyn, Edmund, of Walsham, tile maker 0
3745883 1940618 1940618 plaintiff Carman Robert   586308 586308 Carman, Robert, of Walsham 0
3747048 1940993 1940993 defendant Smethe Robert weaver 586308 586308 Smethe, Robert, of Walsham, weaver 0
3767672 1947526 1947526 defendant Tye John tailor 586308 586308 Tye, John, of Walsham, tailor 3
3776942 1950532 1950532 plaintiff Carman Robert   586308 586308 Carman, Robert, of Walsham 0
3821995 1964769 1964769 defendant Fraunces Thomas butcher 586308 586308 Fraunces, Thomas, of Walsham, butcher 0
3828081 1966651 1966651 plaintiff Smyth John, junior butcher 586308 586308 Smyth, John, junior, of Walsham, butcher 2
3848547 1973127 1973127 defendant Shepherd John husbandman 586308 586308 Shepherd, John, of Walsham, husbandman 2
3849490 1973441 1973441 plaintiff Smyth John butcher 586308 586308 Smyth, John, of Walsham, butcher 1
3882375 1984368 1984368 defendant Shephard John husbandman 586308 586308 Shephard, John, of Walsham, husbandman 0
3885255 1985321 1985321 defendant Nunne John chapman 586308 586308 Nunne, John, of Walsham, chapman 4
3891306 1987360 1987360 plaintiff Lacy Thomas   586308 586308 Lacy, Thomas, of Walsham 0
3917885 1996343 1996343 defendant Hawes Thomas yeoman 586308 586308 Hawes, Thomas, of Walsham, yeoman 0
3929281 2000137 2000137 plaintiff Smyth John butcher 586308 586308 Smyth, John, of Walsham, butcher 1
3958243 2009956 2009956 plaintiff Reve John   586308 586308 Reve, John, of Walsham, "lanista" 0
3958244 2009956 2009956 defendant Cowper William yeoman 586308 586308 Cowper, William, of Walsham, yeoman 0
3975318 2015936 2015936 plaintiff Howell alias Smyth Robert   586308 586308 Howell alias Smyth, Robert, of Walsham 0
3981339 2018095 2018095 plaintiff Rampley Richard (legal representative) 586308 586308 Rampley, Richard, of Walsham, yeoman, executors of 0
4106067 2062461 2062461 defendant Robwood John yeoman 586308 586308 Robwood, John, of Walsham, yeoman 0
4136754 2073495 2073495 defendant Robwood George yeoman 586308 586308 Robwood, George, of Walsham, yeoman 1
4203051 2096616 2096616 defendant Waters Anthony turner 586308 586308 Waters, Anthony, of Walsham, turner 3
4207449 2098159 2098159 defendant Martyn Nicholas yeoman 586308 586308 Martyn, Nicholas, of Walsham, yeoman 0
4249243 2112731 2112731 defendant Smyth Thomas yeoman 586308 586308 Smyth, Thomas, of Walsham, yeoman 0
4346254 2145944 2145944 defendant Hawes John yeoman 586308 586308 Hawes, John, of Walsham, yeoman 0
4387065 2160329 2160329 defendant Granger Benedict husbandman 586308 586308 Granger, Benedict, of Walsham, husbandman 1
4402306 2165354 2165354 defendant Hawys John yeoman 586308 586308 Hawys, John, of Walsham,yeoman 2
4553160 2216922 2216922 defendant Ray Clarice   586308 586308 Ray, Clarice, of Walsham, formerly wife of Bartholomew 0
4553458 2217010 2217010 defendant Smyth Walter   586308 586308 Smyth, Walter, of Walsham 0
4556537 2217979 2217979 defendant Moyr_ John   586308 586308 Moyr_, John, of Walsham 1
4615943 2235982 2235982 defendant Margery alais Poye Robert   586308 586308 Margery alais Poye, Robert, of Walsham 4
4675144 2257839 2257839 defendant Gravour John yeoman 586308 586308 Gravour, John, of Walsham, yeoman 2
4753011 2281330 2281330 plaintiff Turnour William   586308 586308 Turnour, William, of Walsham, on his own account 0
4762102 2284129 2284129 defendant Poye Peter husbandman 586308 586308 Poye, Peter, of Walsham, husbandman 11
4774596 2288041 2288041 defendant Takon Adam husbandman 586308 586308 Takon, Adam, of Walsham, husbandman 1
4799585 2296050 2296050 plaintiff Fraunceys Robert   586308 586308 Fraunceys, Robert, of Walsham 4
4857492 2313732 2313732 defendant Bekker Ralph, junior husbandman 586308 586308 Bekker, Ralph, junior, of Walsham, or of Banyngham, husbandman 2
5007151 2358980 2358980 plaintiff Smyth William   586308 586308 Smyth, William, of Walsham 0
5007153 2358981 2358981 plaintiff Smyth William   586308 586308 Smyth, William, of Walsham 0
5031740 2366156 2366156 plaintiff Robhood John   586308 586308 Robhood, John, of Walsham 0
5253150 2431087 2431087 defendant Potager Roger husbandman 586308 586308 Potager, Roger, of Walsham, husbandman 0
5258738 2432851 2432851 defendant Ermyte Thomas husbandman 586308 586308 Ermyte, Thomas, of Walsham, husbandman 0
5279324 2439045 2439045 defendant Ebell Adam laborer 586308 586308 Ebell, Adam, of Walsham, laborer 4
5305672 2446703 2446703 defendant Page Edmund chandler 586308 586308 Page, Edmund, of Walsham, chandler 0
5305673 2446703 2446703 defendant Berne Thomas tailor 586308 586308 Berne, Thomas, of Walsham, tailor 1
5305674 2446703 2446703 defendant Highwode John barber 586308 586308 Highwode, John, of Walsham, barber 2
5369973 2466198 2466198 defendant Berne Thomas   586308 586308 Berne, Thomas, of Walsham, minstrel 3
5382787 2470141 2470141 defendant Rose Edmund husbandman 586308 586308 Rose, Edmund, of Walsham, husbandman 5
5386098 2471094 2471094 defendant Berne Thomas tailor 586308 586308 Berne, Thomas, of Walsham, tailor 0
5386591 2471229 2471229 defendant Vyncent Robert chaplain 586308 586308 Vyncent, Robert, of Walsham, chaplain 14
5393352 2473155 2473155 defendant Rose Edmund husbandman 586308 586308 Rose, Edmund, of Walsham, husbandman 2
5398268 2474575 2474575 defendant Berne Thomas tailor 586308 586308 Berne, Thomas, of Walsham, tailor 0
5406540 2476940 2476940 defendant Rose Edmunds husbandman 586308 586308 Rose, Edmunds, of Walsham, husbandman 2
5411494 2478395 2478395 defendant Berne Thomas tailor 586308 586308 Berne, Thomas, of Walsham, tailor 0
5435815 2485655 2485655 defendant Rampley John husbandman 586308 586308 Rampley, John, of Walsham, husbandman 0
5463014 2493848 2493848 defendant Deye Richard   586308 586308 Deye, Richard, of Walsham, cooper, son of John Dey, of Bury St Edmunds 1
5486086 2500722 2500722 defendant Say John yeoman 586308 586308 Say, John, of Walsham, yeoman 0
5488037 2501312 2501312 defendant Say John yeoman 586308 586308 Say, John, of Walsham, yeoman 0
5489441 2501728 2501728 defendant Godale John butcher 586308 586308 Godale, John, of Walsham, butcher 0
5496894 2504001 2504001 defendant Robwode Stephen husbandman 586308 586308 Robwode, Stephen, of Walsham, husbandman 0
5500168 2505002 2505002 defendant Roser Edmund butcher 586308 586308 Roser, Edmund, of Walsham, butcher 2
5505252 2506552 2506552 defendant Margery Simon chandler 586308 586308 Margery, Simon, of Walsham, chandler 0
5512796 2508854 2508854 defendant Rycheman John tailor 586308 586308 Rycheman, John, of Walsham, tailor 2
5530493 2514054 2514054 plaintiff Robhood Thomas   586308 586308 Robhood, Thomas, of Walsham, single man 0
5530494 2514054 2514054 plaintiff Robhood Stephen yeoman 586308 586308 Robhood, Stephen, of Walsham, yeoman 1
5536353 2515858 2515858 defendant Robhood Stephen husbandman 586308 586308 Robhood, Stephen, of Walsham, husbandman 1
5536378 2515864 2515864 defendant Robhoode Stephen yeoman 586308 586308 Robhoode, Stephen, of Walsham, yeoman 0
5539695 2516895 2516895 defendant Dowenyng William   586308 586308 Dowenyng, William, of Walsham carpenter 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);