names

175 rows where place_id = 590539

✎ 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
3601535 1868136 1868136 defendant Malenger Richard husbandman 590539 590539 Malenger, Richard, of Hethersett, husbandman 1
3603351 1868720 1868720 defendant Miller Robert husbandman 590539 590539 Miller, Robert, of Hethersett, husbandman 4
3633448 1905274 1905274 defendant Marchaunt John yeoman 590539 590539 Marchaunt, John, of Hethersett, yeoman 0
3700754 1926488 1926488 defendant Frosdyke William husbandman 590539 590539 Frosdyke, William, of Hethersett, husbandman 1
3700757 1926489 1926489 defendant Fosdyk William husbandman 590539 590539 Fosdyk, William, of Hethersett, husbandman 1
3701820 1926821 1926821 defendant Brother Robert husbandman 590539 590539 Brother, Robert, of Hethersett, husbandman 0
3712868 1930343 1930343 defendant Wylkynson John husbandman 590539 590539 Wylkynson, John, of Hethersett, husbandman 2
3780974 1951782 1951782 defendant Thomson Gerard husbandman 590539 590539 Thomson, Gerard, of Hethersett, husbandman 0
3780975 1951782 1951782 defendant rede William husbandman 590539 590539 rede, William, of Hethersett, husbandman 1
3780976 1951782 1951782 defendant Ivery Henry husbandman 590539 590539 Ivery, Henry, of Hethersett, husbandman 2
3833827 1968511 1968511 defendant Brother Henry husbandman 590539 590539 Brother, Henry, of Hethersett, husbandman 1
3840669 1970645 1970645 defendant Wylkynson John husbandman 590539 590539 Wylkynson, John, of Hethersett, husbandman 0
3842173 1971101 1971101 defendant Deynys William husbandman 590539 590539 Deynys, William, of Hethersett, husbandman 0
3852311 1974323 1974323 defendant Quyntrell Robert husbandman 590539 590539 Quyntrell, Robert, of Hethersett, husbandman 1
3863410 1977956 1977956 defendant Greyne Thomas husbandman 590539 590539 Greyne, Thomas, of Hethersett, husbandman 2
3878151 1982941 1982941 defendant Brytyff John husbandman 590539 590539 Brytyff, John, of Hethersett, husbandman 3
3879779 1983492 1983492 defendant Rowland Christopher   590539 590539 Rowland, Christopher, of Hethersett, brick burner 4
3881028 1983924 1983924 defendant Atmere John husbandman 590539 590539 Atmere, John, of Hethersett, husbandman 0
3908328 1993084 1993084 defendant Goldspynk Thomas, senior husbandman 590539 590539 Goldspynk, Thomas, senior, of Hethersett, husbandman 0
3908331 1993085 1993085 defendant Goldspynks Thomas, senior husbandman 590539 590539 Goldspynks, Thomas, senior, of Hethersett, husbandman 0
3910981 1993997 1993997 defendant Goldspynk Thomas husbandman 590539 590539 Goldspynk, Thomas, of Hethersett, husbandman 1
3918391 1996479 1996479 defendant Rouland Christopher   590539 590539 Rouland, Christopher, of Hethersett, brick maker 0
3918392 1996479 1996479 defendant Bredyeve John   590539 590539 Bredyeve, John, of Hethersett, brick maker 1
3918394 1996480 1996480 defendant Rowland Christopher   590539 590539 Rowland, Christopher, of Hethersett, tile burner 0
3918395 1996480 1996480 defendant Brytyff John   590539 590539 Brytyff, John, of Hethersett, tile burner 1
3925578 1998867 1998867 defendant Brytyff John   590539 590539 Brytyff, John, of Hethersett, brick maker 2
3925729 1998921 1998921 defendant Hadenham George husbandman 590539 590539 Hadenham, George, of Hethersett, husbandman 2
3925730 1998921 1998921 defendant Rede Thomas smith 590539 590539 Rede, Thomas, of Hethersett, smith 3
3932279 2001100 2001100 plaintiff Flowerdewe John (legal representative) 590539 590539 Flowerdewe, John, of Hethersett, yeoman, executor of 0
3946842 2005964 2005964 defendant Bryghtwyse Thomas brickburner 590539 590539 Bryghtwyse, Thomas, of Hethersett, brickburner 1
3958190 2009936 2009936 defendant Wood James husbandman 590539 590539 Wood, James, of Hethersett, husbandman 2
3962982 2011650 2011650 plaintiff Woode Richard (legal representative) 590539 590539 Woode, Richard, of Hethersett, administratrix of 0
3968282 2013535 2013535 defendant Pell George yeoman 590539 590539 Pell, George, of Hethersett, yeoman 1
3970038 2014116 2014116 defendant Deynes Thomas, junior husbandman 590539 590539 Deynes, Thomas, junior, of Hethersett, husbandman 0
3970039 2014116 2014116 defendant Lewes James laborer 590539 590539 Lewes, James, of Hethersett, laborer 1
3972944 2015111 2015111 defendant Sadde John blacksmith 590539 590539 Sadde, John, of Hethersett, blacksmith 3
3973257 2015221 2015221 defendant Flowerdewe Christopher gent 590539 590539 Flowerdewe, Christopher, of Hethersett, gent 2
3978656 2017112 2017112 defendant Hadnam George   590539 590539 Hadnam, George, of Hethersett, brick maker 0
4000237 2024855 2024855 plaintiff Goodred Florence   590539 590539 Goodred, Florence, of Hethersett 0
4003578 2026043 2026043 defendant Woode Thomas yeoman 590539 590539 Woode, Thomas, of Hethersett, yeoman 0
4018174 2031222 2031222 defendant Wood Thomas yeoman 590539 590539 Wood, Thomas, of Hethersett, yeoman 0
4027196 2034373 2034373 defendant Rede Thomas blacksmith 590539 590539 Rede, Thomas, of Hethersett, or of Wymondham, blacksmith 0
4030027 2035384 2035384 defendant Rowlond Christopher   590539 590539 Rowlond, Christopher, of Hethersett, brick burner 1
4031542 2035946 2035946 plaintiff Flowerdewe Christopher gent 590539 590539 Flowerdewe, Christopher, of Hethersett, gent 0
4035239 2037282 2037282 defendant Garthe Joseph gent 590539 590539 Garthe, Joseph, of Hethersett, gent 0
4037104 2037934 2037934 defendant Woode Thomas husbandman 590539 590539 Woode, Thomas, of Hethersett, husbandman 1
4040263 2039021 2039021 defendant Mychell Edmund yeoman or baker 590539 590539 Mychell, Edmund, of Hethersett, yeoman or baker 1
4045032 2040678 2040678 defendant Taylor Richard laborer 590539 590539 Taylor, Richard, of Hethersett, laborer 1
4053278 2043550 2043550 defendant Lyghtwyn John husbandman 590539 590539 Lyghtwyn, John, of Hethersett, husbandman 3
4059251 2045702 2045702 defendant Sammon George husbandman 590539 590539 Sammon, George, of Hethersett, husbandman 1
4059252 2045702 2045702 defendant Wood Thomas husbandman 590539 590539 Wood, Thomas, of Hethersett, husbandman 2
4059266 2045708 2045708 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of Hethersett, gent 0
4060512 2046162 2046162 defendant Godfrey John smith 590539 590539 Godfrey, John, of Hethersett, smith 0
4061245 2046429 2046429 defendant Flowerdewe John husbandman 590539 590539 Flowerdewe, John, of Hethersett, husbandman 0
4062761 2046982 2046982 defendant Mallett John husbandman 590539 590539 Mallett, John, of Hethersett, husbandman 1
4065796 2048061 2048061 defendant Payne Thomas cordwainer 590539 590539 Payne, Thomas, of Hethersett, cordwainer 3
4067697 2048759 2048759 defendant Wood Thomas husbandman 590539 590539 Wood, Thomas, of Hethersett, husbandman 0
4069024 2049212 2049212 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of Hethersett, or of Wymondham, Norf, gent 0
4072988 2050637 2050637 defendant Rowland Christopher   590539 590539 Rowland, Christopher, of Hethersett, brick maker 1
4077200 2052131 2052131 defendant Sothall Margaret   590539 590539 Sothall, Margaret, of Hethersett, "yeoman" 1
4081469 2053682 2053682 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of hethersett, gent 0
4081945 2053844 2053844 defendant Lyghtwyn John husbandman 590539 590539 Lyghtwyn, John, of Hethersett, husbandman 0
4081948 2053844 2053844 defendant Rowland Christopher brickmaker 590539 590539 Rowland, Christopher, of Hethersett, brickmaker 3
4087472 2055815 2055815 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of Hethersett, gent 0
4090506 2056887 2056887 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of Hethersett, gent 0
4090510 2056888 2056888 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of Hethersett, gent 0
4091370 2057203 2057203 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of Hethersett, gent 0
4095207 2058608 2058608 defendant Brother Thomas husbandman 590539 590539 Brother, Thomas, of Hethersett, husbandman 3
4095881 2058860 2058860 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of Hethersett, gent 1
4098653 2059849 2059849 defendant Flowerdewe Thomas yeoman 590539 590539 Flowerdewe, Thomas, of Hethersett, yeoman 2
4101199 2060739 2060739 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of Hethersett, gent 1
4101200 2060739 2060739 defendant Hamant Henry husbandman 590539 590539 Hamant, Henry, of Hethersett, husbandman 2
4105268 2062163 2062163 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of Hethersett, gent 0
4110641 2064062 2064062 defendant Flowerdewe John, junior yeoman 590539 590539 Flowerdewe, John, junior, of Hethersett, yeoman 0
4110643 2064063 2064063 defendant Flowerdewe John husbandman 590539 590539 Flowerdewe, John, of Hethersett, husbandman 0
4110645 2064064 2064064 defendant Flowerdewe William husbandman 590539 590539 Flowerdewe, William, of Hethersett, husbandman 0
4113436 2065080 2065080 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of Hethersett, gent 0
4115156 2065710 2065710 defendant Flowerdewe John yeoman 590539 590539 Flowerdewe, John, of Hethersett, yeoman 0
4115159 2065710 2065710 defendant Flowerdewe William yeoman 590539 590539 Flowerdewe, William, of Hethersett, yeoman 3
4116220 2066090 2066090 defendant Flowerdewe John yeoman 590539 590539 Flowerdewe, John, of Hethersett, yeoman 3
4124921 2069203 2069203 defendant Flowerdewe John husbandman 590539 590539 Flowerdewe, John, of Hethersett, husbandman 2
4131192 2071476 2071476 defendant Flowerdewe Thomas yeoman 590539 590539 Flowerdewe, Thomas, of Hethersett, yeoman 0
4136201 2073293 2073293 defendant Hune Miles clerk 590539 590539 Hune, Miles, of Hethersett, clerk 0
4136632 2073445 2073445 defendant Hunne Miles clerk 590539 590539 Hunne, Miles, of Hethersett, clerk 0
4149629 2077995 2077995 defendant Sheres Edmund gent 590539 590539 Sheres, Edmund, of Hethersett, gent 0
4149632 2077996 2077996 defendant Sheres Edmund gent 590539 590539 Sheres, Edmund, of Hethersett, gent 0
4152625 2079033 2079033 defendant Garth Joseph gent 590539 590539 Garth, Joseph, of Hethersett, gent 0
4152626 2079033 2079033 defendant Flowerdewe Humphrey gent 590539 590539 Flowerdewe, Humphrey, of Hethersett, gent 1
4164879 2083227 2083227 defendant Flowerdewe John yeoman 590539 590539 Flowerdewe, John, of Hethersett, yeoman 3
4176230 2087163 2087163 plaintiff Hadnam Robert yeoman 590539 590539 Hadnam, Robert, of Hethersett, yeoman 0
4176233 2087163 2087163 defendant Daynes Thomas yeoman 590539 590539 Daynes, Thomas, of Hethersett, yeoman 2
4179881 2088439 2088439 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of Hethersett, gent 0
4180736 2088743 2088743 defendant Canne Ralph yeoman 590539 590539 Canne, Ralph, of Hethersett, yeoman 3
4180884 2088793 2088793 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of Hethersett, gent 0
4190145 2092059 2092059 defendant Brother William   590539 590539 Brother, William, of Hethersett, brick burner 0
4190146 2092059 2092059 defendant Pyle Ralph yeoman 590539 590539 Pyle, Ralph, of Hethersett, yeoman 1
4190147 2092059 2092059 defendant Brother Robert husbandman 590539 590539 Brother, Robert, of Hethersett, husbandman 2
4191519 2092596 2092596 defendant Overton Nicholas yeoman 590539 590539 Overton, Nicholas, of Hethersett, yeoman 1
4192202 2092836 2092836 defendant Hun Anne widow 590539 590539 Hun, Anne, of Hethersett, widow 1
4203327 2096711 2096711 defendant Flowerdewe Anthony gent 590539 590539 Flowerdewe, Anthony, of Hethersett, 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);