names

162 rows where place_id = 586874

✎ 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
3589867 1864472 1864472 defendant Turnour John yeoman 586874 586874 Turnour, John, of Asshe, yeoman 0
3633830 1905392 1905392 defendant Theyre Clement laborer 586874 586874 Theyre, Clement, of Asshe, laborer 0
3633832 1905392 1905392 defendant Theyre Thomas weaver 586874 586874 Theyre, Thomas, of Asshe, weaver 2
3633833 1905392 1905392 defendant Monger Thomas weaver 586874 586874 Monger, Thomas, of Asshe, weaver 3
3633834 1905392 1905392 defendant Machwyke William laborer 586874 586874 Machwyke, William, of Asshe, laborer 4
3634211 1905500 1905500 defendant Whyte John, senior yeoman 586874 586874 Whyte, John, senior, of Asshe, yeoman 0
3637191 1906432 1906432 defendant Page John laborer 586874 586874 Page, John, of Asshe, laborer 2
3648181 1909826 1909826 defendant Payn Henry husbandman 586874 586874 Payn, Henry, of Asshe Prior, husbandman 0
3658978 1913072 1913072 defendant Man Thomas yeoman 586874 586874 Man, Thomas, of Asshe, yeoman 0
3712935 1930365 1930365 defendant atte Wood Robert yeoman 586874 586874 atte Wood, Robert, of Asshe, yeoman 0
3733215 1936621 1936621 defendant Mone Edward (legal representative) 586874 586874 Mone, Edward, of Asshe, gent, administratrix of 0
3733219 1936622 1936622 defendant Mone Anne   586874 586874 Mone, Anne, of Asshe 1
3749089 1941644 1941644 defendant at Wode Robert yeoman 586874 586874 at Wode, Robert, of Asshe, yeoman 1
3757014 1944173 1944173 plaintiff Grene John clerk 586874 586874 Grene, John, of Asshe, clerk 1
3761884 1945725 1945725 defendant Atwode John yeroman 586874 586874 Atwode, John, of Asshe, yeroman 2
3794598 1956189 1956189 defendant Tressell Richard husbandman 586874 586874 Tressell, Richard, of Asshe, husbandman 0
3794599 1956189 1956189 defendant Carter John laborer 586874 586874 Carter, John, of Asshe, laborer 1
3795272 1956388 1956388 defendant Stacy John yeoman 586874 586874 Stacy, John, of Asshe, yeoman 0
3803719 1959077 1959077 defendant Garbett John husbandman 586874 586874 Garbett, John, of Asshe, husbandman 2
3812231 1961728 1961728 defendant Parker Henry yeoman 586874 586874 Parker, Henry, of Asshe Street, Semer, yeoman 0
3857509 1975984 1975984 plaintiff Averell James yeoman 586874 586874 Averell, James, of Asshe, yeoman 0
3876828 1982490 1982490 defendant Sweteman Roger   586874 586874 Sweteman, Roger, of Asshe, groom 0
3878723 1983133 1983133 defendant Pownte Thomas husbandman 586874 586874 Pownte, Thomas, of Asshe, husbandman 0
3881897 1984199 1984199 defendant Hoode John clerk 586874 586874 Hoode, John, of Asshe, clerk 0
3984039 2019059 2019059 defendant Stappell Richard yeoman 586874 586874 Stappell, Richard, of Asshe, yeoman 0
3994946 2022943 2022943 defendant Semper Edmund yeoman 586874 586874 Semper, Edmund, of Asshe, yeoman 1
4036545 2037754 2037754 plaintiff Hutchyn William yeoman 586874 586874 Hutchyn, William, of Asshe, yeoman 0
4140456 2074831 2074831 defendant Perrott Richard gent 586874 586874 Perrott, Richard, of Asshe, gent 0
4158725 2081125 2081125 defendant Perrott Richard gent 586874 586874 Perrott, Richard, of Asshe, gent 0
4174179 2086424 2086424 defendant Draper Robert butcher 586874 586874 Draper, Robert, of Asshe, butcher 0
4180494 2088659 2088659 defendant Knyght Henry yeoman 586874 586874 Knyght, Henry, of Asshe, or of Alton, Hants, yeoman 0
4180495 2088659 2088659 defendant Russell George yeoman 586874 586874 Russell, George, of Asshe, yeoman 1
4280726 2123164 2123164 defendant Hadsole William yeoman 586874 586874 Hadsole, William, of Asshe, yeoman 0
4415396 2169711 2169711 defendant Lyouns Philip   586874 586874 Lyouns, Philip, of Asshe 0
4417236 2170271 2170271 defendant Torald William   586874 586874 Torald, William, of Asshe, parson 0
4423787 2172286 2172286 defendant Lyouns Philip   586874 586874 Lyouns, Philip, of Asshe 0
4433901 2175364 2175364 defendant Lyouns Philip   586874 586874 Lyouns, Philip, of Asshe 0
4452554 2185800 2185800 defendant Brewester William   586874 586874 Brewester, William, of Asshe 0
4465942 2190011 2190011 defendant Wylot William   586874 586874 Wylot, William, of Asshe 5
4465943 2190011 2190011 defendant Collesson John   586874 586874 Collesson, John, of Asshe 6
4465958 2190014 2190014 defendant Wylot William   586874 586874 Wylot, William, of Asshe 5
4465959 2190014 2190014 defendant Colleson John   586874 586874 Colleson, John, of Asshe 6
4480603 2194602 2194602 defendant Tappere William   586874 586874 Tappere, William, of Asshe 5
4507763 2202884 2202884 defendant Moselyng Richard   586874 586874 Moselyng, Richard, of Asshe 1
4509510 2203442 2203442 defendant Dromound John   586874 586874 Dromound, John, of Asshe, parson 0
4521328 2207015 2207015 defendant Sor Lawrence   586874 586874 Sor, Lawrence, of Asshe 0
4521331 2207015 2207015 defendant Collard John   586874 586874 Collard, John, of Asshe 3
4544164 2214090 2214090 defendant Wolfrich Richard   586874 586874 Wolfrich, Richard, of Asshe 0
4544165 2214090 2214090 defendant Wolfrich John   586874 586874 Wolfrich, John, of Asshe 1
4544167 2214091 2214091 defendant Wolfrith Richard   586874 586874 Wolfrith, Richard, of Asshe 0
4544271 2214123 2214123 defendant Seympere Robert   586874 586874 Seympere, Robert, of Asshe 2
4544272 2214123 2214123 defendant (illegible) John   586874 586874 _, John, of Asshe 3
4562645 2219876 2219876 defendant Idlee John   586874 586874 Idlee, John, of Asshe 0
4569883 2222150 2222150 plaintiff Whityng Thomas   586874 586874 Whityng, Thomas, of Asshe 0
4603470 2232275 2232275 defendant Piers William   586874 586874 Piers, William, of Asshe 3
4603475 2232276 2232276 defendant Baker Richard   586874 586874 Baker, Richard, of Asshe 2
4603477 2232276 2232276 defendant Piers William   586874 586874 Piers, William, of Asshe 4
4651683 2246504 2246504 defendant Ildegate Richard husbandman 586874 586874 Ildegate, Richard, of Asshe, husbandman 0
4678957 2259025 2259025 defendant Launce Richard husbandman 586874 586874 Launce, Richard, of Asshe, husbandman 1
4680567 2259533 2259533 defendant Eldergate Richard yeoman 586874 586874 Eldergate, Richard, of Asshe, yeoman 1
4681972 2259977 2259977 defendant Dlam John husbandman 586874 586874 Dlam, John, of Asshe, husbandman 0
4686414 2261355 2261355 defendant Foldet John skinner 586874 586874 Foldet, John, of Asshe, skinner 3
4691431 2262846 2262846 defendant Derby Thomas walker 586874 586874 Derby, Thomas, of Asshe, walker 1
4704114 2266665 2266665 defendant Glover Richard yeoman 586874 586874 Glover, Richard, of Asshe, yeoman 0
4709402 2268294 2268294 defendant Hamon Thomas husbandman 586874 586874 Hamon, Thomas, of Asshe, husbandman 0
4719757 2271526 2271526 defendant Rodeland John husbandman 586874 586874 Rodeland, John, of Asshe, husbandman 0
4720865 2271859 2271859 defendant Smyth John smith 586874 586874 Smyth, John, of Asshe, smith 0
4721564 2272076 2272076 defendant Dreye Nicholas   586874 586874 Dreye, Nicholas, of Asshe, inland fish seller 0
4731999 2275186 2275186 defendant Yldhalgate Richard gent 586874 586874 Yldhalgate, Richard, of Asshe, gent 0
4736433 2276528 2276528 plaintiff Taillour John   586874 586874 Taillour, John, of Asshe 0
4746331 2279423 2279423 defendant Clyderowe Roger esq 586874 586874 Clyderowe, Roger, of Asshe, esq 1
4749153 2280235 2280235 defendant Aleyn John laborer 586874 586874 Aleyn, John, of Asshe, laborer 0
4755161 2282002 2282002 defendant Middelton Thomas farmer 586874 586874 Middelton, Thomas, of Asshe, farmer 0
4766707 2285576 2285576 defendant Swalwe John husbandman 586874 586874 Swalwe, John, of Asshe, husbandman 0
4787323 2292106 2292106 defendant Goodlef William laborer 586874 586874 Goodlef, William, of Asshe, laborer 0
4787878 2292275 2292275 defendant Cherche Richard yeoman 586874 586874 Cherche, Richard, of Asshe, yeoman 0
4793338 2294014 2294014 defendant Stile John yeoman 586874 586874 Stile, John, of Asshe, yeoman 0
4793993 2294250 2294250 defendant Beke John laborer 586874 586874 (Beke, John, of Asshe, laborer 1
4807299 2298480 2298480 defendant Chertham John husbandman 586874 586874 Chertham, John, of Asshe, husbandman 1
4815068 2300826 2300826 defendant Roulond John   586874 586874 Roulond, John, of Asshe, parson & chaplain 0
4820363 2302438 2302438 defendant Assheby Philip gent 586874 586874 Assheby, Philip, of Asshe, gent 0
4821826 2302901 2302901 defendant Baker John husbandman 586874 586874 Baker, John, of Asshe, husbandman 0
4821827 2302901 2302901 defendant Ayleward William husbandman 586874 586874 Ayleward, William, of Asshe, husbandman 1
4824463 2303701 2303701 plaintiff Taylour John (legal representative) 586874 586874 Taylour, John, of Asshe, executors of 0
4830400 2305542 2305542 defendant Lovegold Walter husbandman 586874 586874 Lovegold, Walter, of Asshe, husbandman 1
4833010 2306341 2306341 defendant Clyfton John draper 586874 586874 Clyfton, John, of Asshe, draper 0
4860009 2314499 2314499 defendant Peny Thomas yeoman 586874 586874 Peny, Thomas, of Asshe, yeoman 0
4866296 2316426 2316426 defendant Edyngborgh John yeoman 586874 586874 Edyngborgh, John, of Asshe, yeoman 1
4871090 2317934 2317934 defendant Idelee John gent 586874 586874 Idelee, John, of Asshe, gent 0
4875194 2319195 2319195 defendant Bere Robert   586874 586874 Bere, Robert, of Asshe 1
4882695 2321501 2321501 defendant atte Lee Robert husbandman 586874 586874 atte Lee, Robert, of Asshe, husbandman 2
4897750 2325964 2325964 defendant Carswell Nicholas husbandman 586874 586874 Carswell, Nicholas, of Asshe, husbandman 0
4910778 2329880 2329880 defendant Starke Stephen husbandman 586874 586874 Starke, Stephen, of Asshe, husbandman 0
4910779 2329880 2329880 defendant Leefe John husbandman 586874 586874 Leefe, John, of Asshe, husbandman 1
4913137 2330605 2330605 defendant Peny Thomas yeoman 586874 586874 Peny, Thomas, of Asshe, yeoman 0
4938326 2338367 2338367 defendant Peny Thomas yeoman 586874 586874 Peny, Thomas, of Asshe, yeoman 0
4939785 2338831 2338831 defendant Crystemesse John husbandman 586874 586874 Crystemesse, John, of Asshe, husbandman 0
4968728 2347617 2347617 defendant Carswell Nicholas husbandman 586874 586874 Carswell, Nicholas, of Asshe, husbandman 0
4969325 2347784 2347784 defendant Joynour John husbandman 586874 586874 Joynour, John, of Asshe, husbandman 2
4983186 2351872 2351872 defendant Goode John gent 586874 586874 Goode, John, of Asshe, 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);