names

131 rows where place_id = 593816

✎ 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
3613439 1871850 1871850 defendant Fythe or Fyche John, junior clothmaker 593816 593816 Fythe or Fyche, John, junior, of Sudbery, clothmaker 3
3613440 1871850 1871850 defendant Fythe or Fyche John, senior clothmaker 593816 593816 Fythe or Fyche, John, senior, of Sudbery, clothmaker 4
3676007 1918534 1918534 plaintiff How Stephen (legal representative) 593816 593816 How, Stephen, of Sudbery, executors of 0
3698568 1925770 1925770 defendant Dixson John fuller 593816 593816 Dixson, John, of Sudbery, fuller 2
3712142 1930115 1930115 plaintiff Waren alias Baker John grocer 593816 593816 Waren alias Baker, John, of Sudbery, grocer 0
3712144 1930116 1930116 plaintiff Waren alias Baker John grocer 593816 593816 Waren alias Baker, John, of Sudbery, grocer 0
4020034 2031895 2031895 defendant Hyll John clothier 593816 593816 Hyll, John, of Sudbery, clothier 0
4249353 2112767 2112767 defendant Smyth Thomas (legal representative) 593816 593816 Smyth, Thomas, of Sudbery, yeoman, executrix of 1
4249354 2112767 2112767 defendant Smythe Philippa widow 593816 593816 Smythe, Philippa, of Sudbery, widow 2
4255561 2114842 2114842 defendant Reade Thomas dyer 593816 593816 Reade, Thomas, of Sudbery, dyer 3
4267944 2118908 2118908 defendant Reade Thomas dyer 593816 593816 Reade, Thomas, of Sudbery, dyer 3
4280340 2123026 2123026 defendant Gowldinge Richard clothier 593816 593816 Gowldinge, Richard, of Sudbery, clothier 3
4434811 2175645 2175645 plaintiff Lygoun John   593816 593816 Lygoun, John, of Sudbery 0
4437235 2176391 2176391 defendant Bryen Margaret   593816 593816 Bryen, Margaret, of Sudbery, formerly wife of John 0
4470637 2191465 2191465 defendant Cook John chaplain 593816 593816 Cook, John, of Sudbery, chaplain 0
4470638 2191465 2191465 defendant Aldhous Robert brewer 593816 593816 Aldhous, Robert, of Sudbery, brewer 1
4474407 2192651 2192651 plaintiff Dobbys Thomas   593816 593816 Dobbys, Thomas, of Sudbery 0
4475398 2192985 2192985 plaintiff Dobbes John   593816 593816 Dobbes, John, of Sudbery 1
4475399 2192985 2192985 plaintiff Gerveys Peter   593816 593816 Gerveys, Peter, of Sudbery 2
4479799 2194343 2194343 defendant Dobbes Thomas   593816 593816 Dobbes, Thomas, of Sudbery 0
4479804 2194343 2194343 defendant Avelyne Robert   593816 593816 Avelyne, Robert, of Sudbery 5
4485635 2196215 2196215 plaintiff Remshale John (legal representative) 593816 593816 Remshale, John, of Sudbery, executors of 0
4485636 2196215 2196215 plaintiff Gerevays Peter   593816 593816 (Gerevays, Peter, of Sudbery 1
4485637 2196215 2196215 plaintiff Nicole William   593816 593816 Nicole, William, of Sudbery 2
4485639 2196215 2196215 defendant Stevenes John   593816 593816 Stevenes, John, of Sudbery 1
4485640 2196215 2196215 defendant Dobbys Thomas   593816 593816 Dobbys, Thomas, of Sudbery 2
4487917 2196943 2196943 plaintiff Spycer Thomas   593816 593816 Spycer, Thomas, of Sudbery 0
4500511 2200781 2200781 defendant Shepherde John   593816 593816 Shepherde, John, of Sudbery 0
4512907 2204470 2204470 defendant Alred John   593816 593816 Alred, John, of Sudbery 1
4522161 2207277 2207277 defendant Stacy William barber 593816 593816 Stacy, William, of Sudbery, barber 0
4525788 2208369 2208369 defendant Dobbes Thomas   593816 593816 Dobbes, Thomas, of Sudbery 0
4525792 2208369 2208369 defendant Thurgor John   593816 593816 Thurgor, John, of Sudbery 4
4525793 2208369 2208369 defendant Avelyne Robert   593816 593816 Avelyne, Robert, of Sudbery 5
4550953 2216233 2216233 plaintiff Dobbes John   593816 593816 Dobbes, John, of Sudbery 0
4550954 2216233 2216233 defendant Seman John   593816 593816 Seman, John, of Sudbery 0
4583351 2226213 2226213 defendant Peperard John   593816 593816 Peperard, John, of Sudbery 0
4585278 2226820 2226820 plaintiff Hadneham John   593816 593816 Hadneham, John, of Sudbery 0
4605025 2232730 2232730 defendant Scaldere Roger   593816 593816 Scaldere, Roger, of Sudbery 0
4607577 2233477 2233477 defendant Pepard John, sen   593816 593816 Pepard, John, sen, of Sudbery 0
4607588 2233480 2233480 defendant Pepard John, sen   593816 593816 Pepard, John, sen, of Sudbery 0
4643812 2244286 2244286 defendant Arnold William   593816 593816 Arnold, William, of Sudbery 0
4658510 2248541 2248541 defendant West Thomas butcher 593816 593816 West, Thomas, of Sudbery, butcher 0
4666996 2255410 2255410 plaintiff Anclyve Robert   593816 593816 Anclyve, Robert, of Sudbery 0
4667967 2255687 2255687 plaintiff Baketon John   593816 593816 Baketon, John, of Sudbery 0
4670449 2256442 2256442 plaintiff Bryce Geoffrey   593816 593816 Bryce, Geoffrey, of Sudbery, warden of the college of St Gregory 0
4670450 2256442 2256442 defendant Thurgor John (legal representative) 593816 593816 Thurgor, John, of Sudbery, draper, executor of 0
4677898 2258704 2258704 plaintiff Hengham Thomas (legal representative) 593816 593816 Hengham, Thomas, of Sudbery, former warden of the college of St Gregory, executors of 0
4677899 2258704 2258704 plaintiff Bryce Geoffrey   593816 593816 (Bryce, Geoffrey, of Sudbery, warden of the College of St Gregory 1
4682676 2260197 2260197 defendant Scaldere Roger husbandman 593816 593816 Scaldere, Roger, of Sudbery, husbandman 0
4682678 2260197 2260197 defendant Hadham John yeoman 593816 593816 Hadham, John, of Sudbery, yeoman 2
4737581 2276862 2276862 defendant Bray John tanner 593816 593816 Bray, John, of Sudbery, tanner 0
4784443 2291139 2291139 plaintiff Dobbys Thomas   593816 593816 Dobbys, Thomas, of Sudbery 0
4784444 2291139 2291139 defendant Bakere John fuller 593816 593816 Bakere, John, of Sudbery, fuller 0
4784445 2291139 2291139 defendant Cowelle John tailor 593816 593816 Cowelle, John, of Sudbery, tailor 1
4784446 2291139 2291139 defendant Prentys Thomas weaver 593816 593816 Prentys, Thomas, of Sudbery, weaver 2
4788238 2292391 2292391 defendant Scaldere Roger chapman 593816 593816 Scaldere, Roger, of Sudbery, chapman 0
4792191 2293647 2293647 defendant Spernale John husbandman 593816 593816 Spernale, John, of Sudbery, husbandman 0
4800852 2296455 2296455 plaintiff West Thomas   593816 593816 West, Thomas, of Sudbery 0
4800856 2296455 2296455 defendant Mitton Nicholas dyer 593816 593816 Mitton, Nicholas, of Sudbery, dyer 3
4800857 2296455 2296455 defendant Kyngispeer Richard fisher 593816 593816 Kyngispeer, Richard, of Sudbery, fisher 4
4800858 2296456 2296456 plaintiff West Thomas   593816 593816 West, Thomas, of Sudbery 0
4819076 2302051 2302051 defendant Aylmer Simon laborer 593816 593816 Aylmer, Simon, of Sudbery, laborer 1
4861420 2314943 2314943 defendant Bust John (legal representative) 593816 593816 Bust, John, of Sudbery, executors of 0
4861421 2314943 2314943 defendant Reynold William weaver 593816 593816 (Reynold, William, of Sudbery, weaver 1
4861422 2314943 2314943 defendant Shorthose Thomas weaver 593816 593816 Shorthose, Thomas, of Sudbery, weaver 2
4864159 2315765 2315765 defendant Taillour Hugh tailor 593816 593816 Taillour, Hugh, of Sudbery, tailor 1
4906447 2328602 2328602 defendant Plays John skinner 593816 593816 Plays, John, of Sudbery, skinner 0
4906449 2328603 2328603 plaintiff Darre Richard   593816 593816 Darre, Richard, of Sudbery 0
4989141 2353689 2353689 defendant Taillour Hugh tailor 593816 593816 Taillour, Hugh, of Sudbery, tailor 1
5002017 2357491 2357491 defendant Fyschlake William mercer 593816 593816 Fyschlake, William, of Sudbery, mercer 0
5010643 2359983 2359983 defendant Muryell Robert yeoman 593816 593816 Muryell, Robert, of Sudbery, yeoman 0
5010644 2359983 2359983 defendant Herward William yeoman 593816 593816 Herward, William, of Sudbery, yeoman 1
5016644 2361758 2361758 defendant Synton William cordwainer 593816 593816 Synton, William, of Sudbery, cordwainer 3
5018445 2362278 2362278 defendant Bakere John hosteler 593816 593816 Bakere, John, of Sudbery, hosteler 1
5019976 2362724 2362724 plaintiff Deynes Robert dyer 593816 593816 Deynes, Robert, of Sudbery, dyer 0
5021200 2363100 2363100 defendant Bachot Edmund scrivener 593816 593816 Bachot, Edmund, of Sudbery, scrivener 2
5023784 2363862 2363862 defendant Lambard John (legal representative) 593816 593816 Lambard, John, of Sudbery, baker, administrator of 2
5023968 2363921 2363921 defendant Payn William mercer 593816 593816 Payn, William, of Sudbery, mercer 0
5023971 2363921 2363921 defendant Imper John mercer 593816 593816 Imper, John, of Sudbery, mercer 3
5024092 2363952 2363952 defendant Lenne John dyer 593816 593816 Lenne, John, of Sudbery, dyer 0
5030150 2365687 2365687 plaintiff Payn William   593816 593816 Payn, William, of Sudbery 0
5033425 2366657 2366657 defendant Mannyng Thomas   593816 593816 Mannyng, Thomas, of Sudbery, mason 1
5037466 2367829 2367829 plaintiff Friot John   593816 593816 Friot, John, of Sudbery 1
5037467 2367829 2367829 defendant Fysshlak William merchant 593816 593816 Fysshlak, William, of Sudbery, merchant 0
5037468 2367829 2367829 defendant Tame Thomas mercer 593816 593816 Tame, Thomas, of Sudbery, mercer 1
5037469 2367829 2367829 defendant Musket William saddler 593816 593816 Musket, William, of Sudbery, saddler 2
5037470 2367829 2367829 defendant Be--roche John baker 593816 593816 Be--roche, John, of Sudbery, baker 3
5038624 2368196 2368196 plaintiff Arlyn Thomas   593816 593816 Arlyn, Thomas, of Sudbery 0
5038625 2368196 2368196 defendant Berwyk John weaver 593816 593816 Berwyk, John, of Sudbery, weaver 0
5038626 2368196 2368196 defendant Hotches alias Fytches John weaver 593816 593816 Hotches alias Fytches, John, of Sudbery, weaver 1
5047211 2370786 2370786 defendant Baker Richard husbandman 593816 593816 Baker, Richard, of Sudbery, husbandman 1
5055972 2373356 2373356 defendant Kyngston John barker 593816 593816 Kyngston, John, of Sudbery, barker 0
5055974 2373357 2373357 defendant Kyngston Thomas barker 593816 593816 Kyngston, Thomas, of Sudbery, barker 0
5057700 2373871 2373871 plaintiff Cook Thomas   593816 593816 Cook, Thomas, of Sudbery 0
5058925 2374234 2374234 defendant Sydey John fuller 593816 593816 Sydey, John, of Sudbery, fuller 1
5060417 2374693 2374693 defendant Sterre John weaver 593816 593816 Sterre, John, of Sudbery, weaver 1
5062986 2375462 2375462 defendant Hynde John wooder 593816 593816 Hynde, John, of Sudbery, wooder 0
5062987 2375462 2375462 defendant Appylton John weaver 593816 593816 Appylton, John, of Sudbery, weaver 1
5062988 2375462 2375462 defendant Aldus Thomas mercer 593816 593816 Aldus, Thomas, of Sudbery, mercer 2
5073111 2378444 2378444 plaintiff Tylle John weaver 593816 593816 Tylle, John, of Sudbery, weaver 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);