names

166 rows where place_id = 590995

✎ 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
3602952 1868587 1868587 defendant Payn John butcher 590995 590995 Payn, John, of Wortham, butcher 4
3620474 1873980 1873980 defendant FitzJon John yeoman 590995 590995 FitzJon, John, of Wortham, yeoman 0
3633788 1905382 1905382 defendant Leeke Reginald husbandman 590995 590995 Leeke, Reginald, of Wortham, husbandman 1
3635521 1905909 1905909 defendant Boole William laborer 590995 590995 Boole, William, of Wortham, laborer 0
3635522 1905909 1905909 defendant Godyng William laborer 590995 590995 Godyng, William, of Wortham, laborer 1
3666987 1915618 1915618 defendant Walpole William husbandman 590995 590995 Walpole, William, of Wortham, husbandman 0
3667002 1915623 1915623 defendant Walpole William husbandman 590995 590995 Walpole, William, of Wortham, husbandman 1
3728510 1935166 1935166 defendant Pope John husbandman 590995 590995 Pope, John, of Wortham, husbandman 0
3747049 1940993 1940993 defendant Bokenham George yeoman 590995 590995 Bokenham, George, of Wortham, yeoman 1
3771734 1948862 1948862 defendant Page William yeoman 590995 590995 Page, William, of Wortham, yeoman 0
3785831 1953357 1953357 plaintiff Page William   590995 590995 Page, William, of Wortham 0
3794630 1956198 1956198 defendant Barker Robert husbandman 590995 590995 Barker, Robert, of Wortham, husbandman 0
3872443 1981007 1981007 plaintiff Bokenham Thomas   590995 590995 Bokenham, Thomas, of Wortham 0
3875176 1981936 1981936 defendant Pope John husbandman 590995 590995 Pope, John, of Wortham, husbandman 0
3890381 1987035 1987035 defendant Hogge Robert husbandman 590995 590995 Hogge, Robert, of Wortham, husbandman 0
3899458 1990032 1990032 defendant Nune Walter yeoman 590995 590995 Nune, Walter, of Wortham, yeoman 0
3913552 1994872 1994872 defendant Colman John yeoman 590995 590995 Colman, John, of Wortham, yeoman 0
3944999 2005344 2005344 defendant Bucknam Thomas (legal representative) 590995 590995 Bucknam, Thomas, of Wortham, yeoman, executors of 0
3945000 2005344 2005344 defendant Bucknam Anne widow 590995 590995 (Bucknam, Anne, of Wortham, widow 1
3961902 2011257 2011257 defendant Bett Alice widow 590995 590995 Bett, Alice, of Wortham, widow 0
3961903 2011257 2011257 defendant Bett George husbandman 590995 590995 Bett, George, of Wortham, husbandman 1
4015604 2030278 2030278 defendant Wete John yeoman 590995 590995 Wete, John, of Wortham, yeoman 1
4019241 2031616 2031616 defendant Hogge John husbandman 590995 590995 Hogge, John, of Wortham, husbandman 0
4027957 2034648 2034648 defendant Bettes George yeoman 590995 590995 Bettes, George, of Wortham, yeoman 1
4060172 2046037 2046037 defendant Wood Robert husbandman 590995 590995 Wood, Robert, of Wortham, husbandman 3
4078975 2052780 2052780 plaintiff Toftewoode John   590995 590995 Toftewoode, John, of Wortham 0
4078976 2052780 2052780 defendant Perseley John clerk 590995 590995 Perseley, John, of Wortham, clerk 0
4080228 2053239 2053239 defendant Corbolde William yeoman 590995 590995 Corbolde, William, of Wortham, yeoman 0
4080229 2053239 2053239 defendant Wase Edmund husbandman 590995 590995 Wase, Edmund, of Wortham, husbandman 1
4080230 2053239 2053239 defendant Fuller Robert husbandman 590995 590995 Fuller, Robert, of Wortham, husbandman 2
4107578 2062995 2062995 defendant Parsley John clerk 590995 590995 Parsley, John, of Wortham, clerk 0
4109223 2063556 2063556 defendant Chittocke Thomas yeoman 590995 590995 Chittocke, Thomas, of Wortham, yeoman 0
4109690 2063723 2063723 defendant Parsley John yeoman 590995 590995 Parsley, John, of Wortham, clerk, or of Burgatt, yeoman 0
4127608 2070166 2070166 defendant Parsley John clerk 590995 590995 Parsley, John, of Wortham, clerk 0
4134410 2072636 2072636 defendant Benton John yeoman 590995 590995 Benton, John, of Wortham, yeoman 2
4137308 2073692 2073692 defendant Barkwaye Robert husbandman 590995 590995 Barkwaye, Robert, of Wortham, husbandman 0
4137309 2073692 2073692 defendant Wytte John husbandman 590995 590995 Wytte, John, of Wortham, husbandman 1
4152955 2079139 2079139 defendant Gosse John carpenter 590995 590995 Gosse, John, of Wortham, carpenter 0
4155953 2080156 2080156 defendant Parseley John clerk 590995 590995 Parseley, John, of Wortham, clerk 0
4155954 2080156 2080156 defendant Barkewaye Robert yeoman 590995 590995 Barkewaye, Robert, of Wortham, yeoman 1
4171918 2085639 2085639 defendant Barkeway Robert husbandman 590995 590995 Barkeway, Robert, of Wortham, husbandman 2
4189893 2091966 2091966 defendant Hooge Robert husbandman 590995 590995 Hooge, Robert, of Wortham, husbandman 0
4194569 2093656 2093656 defendant Wete John husbandman 590995 590995 Wete, John, of Wortham, husbandman 0
4201086 2095933 2095933 defendant Hogg Robert husbandman 590995 590995 Hogg, Robert, of Wortham, husbandman 0
4204755 2097209 2097209 defendant Hogg Robert husbandman 590995 590995 Hogg, Robert, of Wortham, husbandman 1
4206167 2097706 2097706 defendant Alpe John tanner 590995 590995 Alpe, John, of Wortham, tanner 0
4209578 2098901 2098901 defendant Wace John husbandman 590995 590995 Wace, John, of Wortham, husbandman 0
4209581 2098901 2098901 defendant Bryce Walter shoemaker 590995 590995 Bryce, Walter, of Wortham, shoemaker 3
4210357 2099179 2099179 defendant Gosse John carpenter 590995 590995 Gosse, John, of Wortham, carpenter 1
4210358 2099179 2099179 defendant Parseley John clerk 590995 590995 Parseley, John, of Wortham, clerk 2
4218786 2102069 2102069 defendant Barkwaye Robert husbandman 590995 590995 Barkwaye, Robert, of Wortham, husbandman 0
4223480 2103701 2103701 defendant Thurloe William husbandman 590995 590995 Thurloe, William, of Wortham, husbandman 3
4238113 2108935 2108935 defendant Bett George yeoman 590995 590995 Bett, George, of Wortham, yeoman 0
4240911 2109946 2109946 defendant Shene Nicholas sherman 590995 590995 Shene, Nicholas, of Wortham, sherman 0
4243232 2110728 2110728 defendant Sheene Nicholas husbandman 590995 590995 Sheene, Nicholas, of Wortham, husbandman 0
4244784 2111243 2111243 defendant Grubbe William husbandman 590995 590995 Grubbe, William, of Wortham, husbandman 0
4244871 2111272 2111272 defendant Barkewaye Robert husbandman 590995 590995 Barkewaye, Robert, of Wortham, husbandman 0
4248775 2112578 2112578 defendant Parslye John clerk 590995 590995 Parslye, John, of Wortham, clerk 0
4248776 2112578 2112578 defendant Thurlo William husbandman 590995 590995 Thurlo, William, of Wortham, husbandman 1
4281645 2123487 2123487 defendant Blomefyld William yeoman 590995 590995 Blomefyld, William, of Wortham, yeoman 0
4325176 2138800 2138800 defendant Gosse John carpenter 590995 590995 Gosse, John, of Wortham, carpenter 1
4339867 2143716 2143716 defendant Spaldinge Robert yeoman 590995 590995 Spaldinge, Robert, of Wortham, yeoman 0
4346995 2146202 2146202 defendant Parsley John clerk 590995 590995 Parsley, John, of Wortham, clerk 0
4367928 2153579 2153579 defendant Barkway Robert husbandman 590995 590995 Barkway, Robert, of Wortham,husbandman 0
4376618 2156707 2156707 defendant Strutt Roger husbandman 590995 590995 Strutt, Roger, of Wortham, husbandman 1
4387247 2160382 2160382 defendant Fordom Benedict cordwainer 590995 590995 Fordom, Benedict, of Wortham, cordwainer 1
4389385 2161074 2161074 defendant Parsley John clerk 590995 590995 Parsley, John, of Wortham, clerk 0
4389530 2161125 2161125 defendant Spaldinge Robert yeoman 590995 590995 Spaldinge, Robert, of Wortham, yeoman 0
4396685 2163456 2163456 defendant Parsley John clerk 590995 590995 Parsley, John, of Wortham, clerk 2
4404051 2165926 2165926 defendant Thurlowe William husbandman 590995 590995 Thurlowe, William, of Wortham, husbandman 0
4405785 2166503 2166503 defendant Strutt Roger husbandman 590995 590995 Strutt, Roger, of Wortham, husbandman 1
4425695 2172849 2172849 defendant Cole William   590995 590995 Cole, William, of Wortham 1
4448843 2184578 2184578 defendant Dersham John   590995 590995 Dersham, John, of Wortham 8
4505383 2202216 2202216 plaintiff Sparwe Osbous   590995 590995 Sparwe, Osbous, of Wortham 0
4529767 2209595 2209595 plaintiff Muriell John (legal representative) 590995 590995 Muriell, John, of Wortham, parson, executors of 0
4549915 2215906 2215906 defendant Symor John   590995 590995 Symor, John, of Wortham 2
4559998 2219076 2219076 defendant Lulpek John   590995 590995 Lulpek, John, of Wortham 2
4560002 2219077 2219077 defendant Lulpek John   590995 590995 Lulpek, John, of Wortham 2
4566153 2220976 2220976 defendant Wymere Roger   590995 590995 Wymere, Roger, of Wortham 0
4571209 2222562 2222562 defendant Baret William   590995 590995 Baret, William, of Wortham, parson 0
4571791 2222763 2222763 defendant Kebenham William   590995 590995 Kebenham, William, of Wortham, plough man 0
4571793 2222763 2222763 defendant Spryng Richard   590995 590995 Spryng, Richard, of Wortham 2
4579865 2225188 2225188 defendant Wymere Roger   590995 590995 Wymere, Roger, of Wortham 0
4598999 2230910 2230910 defendant Snowhit Henry   590995 590995 Snowhit, Henry, of Wortham 0
4639782 2243140 2243140 defendant Wymer Roger   590995 590995 Wymer, Roger, of Wortham 2
4645838 2244851 2244851 defendant Baret William   590995 590995 Baret, William, of Wortham, parson of half the church 0
4659326 2248781 2248781 defendant Hulwode alias Bokenhamys John, junior yeoman 590995 590995 Hulwode alias Bokenhamys, John, junior, of Wortham, yeoman 1
4659327 2248781 2248781 defendant Lord John yeoman 590995 590995 Lord, John, of Wortham, yeoman 2
4659328 2248781 2248781 defendant Holwode John, junior sawyer 590995 590995 Holwode, John, junior, of Wortham, sawyer 3
4659329 2248781 2248781 defendant Holwode Roger sawyer 590995 590995 Holwode, Roger, of Wortham, sawyer 4
4719261 2271370 2271370 defendant Pollard John yeoman 590995 590995 Pollard, John, of Wortham, yeoman 2
4739339 2277391 2277391 defendant Tabberd John yeoman 590995 590995 Tabberd, John, of Wortham, yeoman 1
4742245 2278220 2278220 defendant Colman Thomas yeoman 590995 590995 Colman, Thomas, of Wortham, yeoman 4
4791466 2293424 2293424 defendant Man Richard   590995 590995 Man, Richard, of Wortham, "wiltmaker" 2
4792558 2293763 2293763 defendant Filbrigge Simon clerk 590995 590995 Filbrigge, Simon, of Wortham, clerk 0
4844894 2309923 2309923 defendant Bowe John   590995 590995 Bowe, John, of Wortham, parson 0
4933870 2336975 2336975 defendant Ode William chaplain 590995 590995 Ode, William, of Wortham, chaplain 0
4937072 2337965 2337965 defendant Payn Richard cordwainer 590995 590995 Payn, Richard, of Wortham, cordwainer 5
4961037 2345262 2345262 defendant Crane Walter smith 590995 590995 Crane, Walter, of Wortham, smith 0
4961038 2345262 2345262 defendant Hervy John husbandman 590995 590995 Hervy, John, of Wortham, husbandman 1

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