names

114 rows where place_id = 586714

✎ 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
3589449 1864338 1864338 defendant Seffrey Ralph husbandman 586714 586714 Seffrey, Ralph, of Hempnale, husbandman 2
3598020 1867005 1867005 defendant Goche John yeoman 586714 586714 Goche, John, of Hempnale, yeoman 0
3602995 1868603 1868603 defendant Goche John yeoman 586714 586714 Goche, John, of Hempnale, yeoman 2
3633431 1905268 1905268 defendant Potter John husbandman 586714 586714 Potter, John, of Hempnale, husbandman 8
3638350 1906812 1906812 defendant Prest Robert butcher 586714 586714 Prest, Robert, of Hempnale, butcher 3
3641669 1907852 1907852 defendant Molle Ambrose, senior husbandman 586714 586714 Molle, Ambrose, senior, of Hempnale, husbandman 1
3647382 1909569 1909569 defendant Goldsmyth Robert smith 586714 586714 Goldsmyth, Robert, of Hempnale, smith 0
3650423 1910501 1910501 defendant Verdon John (legal representative) 586714 586714 Verdon, John, of Hempnale, executors of 1
3650424 1910501 1910501 defendant Verdon Agnes widow 586714 586714 (Verdon, Agnes, of Hempnale, widow 2
3670414 1916702 1916702 defendant Preste Robert   586714 586714 Preste, Robert, of Hempnale, butcher, administrators of 1
3680906 1920111 1920111 defendant Weston John husbandman 586714 586714 (Weston, John, of Hempnale, husbandman 1
3680908 1920111 1920111 defendant Swan Robert husbandman 586714 586714 Swan, Robert, of Hempnale, husbandman 3
3697082 1925307 1925307 defendant Sporle Robert husbandman 586714 586714 Sporle, Robert, of Hempnale, husbandman 0
3705120 1927889 1927889 defendant Verdon John yeoman 586714 586714 Verdon, John, of Hempnale, yeoman 5
3715440 1931116 1931116 defendant Weston Geoffrey husbandman 586714 586714 Weston, Geoffrey, of Hempnale, husbandman 1
3719059 1932238 1932238 defendant Meke Thomas butcher 586714 586714 Meke, Thomas, of Hempnale, butcher 0
3719067 1932240 1932240 defendant Meke Thomas butrcher 586714 586714 Meke, Thomas, of Hempnale, butrcher 4
3727891 1934993 1934993 defendant Sporle Robert, junior laborer 586714 586714 Sporle, Robert, junior, of Hempnale, laborer 0
3727893 1934993 1934993 defendant Hoker Richard husbandman 586714 586714 Hoker, Richard, of Hempnale, husbandman 2
3733917 1936852 1936852 defendant Randall William husbandman 586714 586714 Randall, William, of Hempnale, husbandman 0
3745370 1940458 1940458 defendant Myngey John husbandman 586714 586714 Myngey, John, of Hempnale, husbandman 1
3753671 1943090 1943090 defendant Sporle Robert husbandman 586714 586714 Sporle, Robert, of Hempnale, husbandman 0
3776194 1950300 1950300 defendant Parke John husbandman 586714 586714 Parke, John, of Hempnale, husbandman 1
3796324 1956715 1956715 defendant Turnour alias Flecher John carpenter 586714 586714 Turnour alias Flecher, John, of Hempnale, carpenter 1
3796325 1956715 1956715 defendant Goldsmyth John husbandman 586714 586714 Goldsmyth, John, of Hempnale, husbandman 2
3812772 1961888 1961888 defendant Randolff Thomas butcher 586714 586714 Randolff, Thomas, of Hempnale, butcher 1
3835515 1969047 1969047 defendant Sporle Robert husbandman 586714 586714 Sporle, Robert, of Hempnale, husbandman 3
3864448 1978307 1978307 defendant Dowe Andrew husbandman 586714 586714 Dowe, Andrew, of Hempnale, husbandman 1
3872024 1980875 1980875 defendant Myngey William husbandman 586714 586714 Myngey, William, of Hempnale, husbandman 2
3879677 1983459 1983459 defendant Clipwell John   586714 586714 Clipwell, John, of Hempnale, "kedyer" 1
3894107 1988245 1988245 defendant Kerison William husbandman 586714 586714 Kerison, William, of Hempnale, husbandman 3
3973340 2015248 2015248 defendant Sporle John husbandman 586714 586714 Sporle, John, of Hempnale, husbandman 0
3973341 2015248 2015248 defendant Kyrke John husbandman 586714 586714 Kyrke, John, of Hempnale, husbandman 1
4003274 2025928 2025928 defendant Roberd Robert butcher 586714 586714 Roberd, Robert, of Hempnale, butcher 0
4019146 2031586 2031586 defendant Roberd Edward yeoman 586714 586714 Roberd, Edward, of Hempnale, yeoman 3
4110199 2063909 2063909 defendant Leggood John tanner 586714 586714 Leggood, John, of Hempnale, tanner 0
4215535 2100930 2100930 defendant Fayerman Robert husbandman 586714 586714 Fayerman, Robert, of Hempnale, husbandman 1
4573478 2223231 2223231 defendant Newehaghe John   586714 586714 Newehaghe, John, of Hempnale 6
4659106 2248719 2248719 defendant Lese Walter yeoman 586714 586714 Lese, Walter, of Hempnale, yeoman 1
4699238 2265227 2265227 defendant Edrych William husbandman 586714 586714 Edrych, William, of Hempnale, husbandman 0
4699772 2265371 2265371 defendant Sporle Henry   586714 586714 Sporle, Henry, of Hempnale, shoe maker 2
4744164 2278821 2278821 plaintiff Drake John   586714 586714 Drake, John, of Hempnale, on his own account 0
4755318 2282051 2282051 defendant Geselyng William   586714 586714 Geselyng, William, of Hempnale, shepherd 0
4758974 2283158 2283158 defendant Bond John husbandman 586714 586714 Bond, John, of Hempnale, husbandman 3
4758975 2283158 2283158 defendant Geselyng William yeoman 586714 586714 Geselyng, William, of Hempnale, yeoman 4
4761277 2283875 2283875 plaintiff Drake John   586714 586714 Drake, John, of Hempnale 0
4854710 2312837 2312837 defendant Lancastre John husbandman 586714 586714 Lancastre, John, of Hempnale, husbandman 1
4854717 2312838 2312838 defendant Thorne John husbandman 586714 586714 Thorne, John, of Hempnale, husbandman 1
4854725 2312839 2312839 defendant Thorne John husbandman 586714 586714 Thorne, John, of Hempnale, husbandman 1
4854740 2312841 2312841 defendant Lancastre John husbandman 586714 586714 Lancastre, John, of Hempnale, husbandman 1
4854754 2312843 2312843 defendant Fyncham Simon husbandman 586714 586714 Fyncham, Simon, of Hempnale, husbandman 1
4868508 2317125 2317125 defendant Lede Walter husbandman 586714 586714 Lede, Walter, of Hempnale, husbandman 0
4868510 2317126 2317126 defendant Lete or Lece Walter husbandman 586714 586714 Lete or Lece, Walter, of Hempnale, husbandman 0
4873040 2318525 2318525 defendant Thorn John husbandman 586714 586714 Thorn, John, of Hempnale, husbandman 0
4873047 2318526 2318526 defendant Thorn John husbandman 586714 586714 Thorn, John, of Hempnale, husbandman 1
4873053 2318527 2318527 defendant Thorn John husbandman 586714 586714 Thorn, John, of Hempnale, husbandman 0
4873059 2318528 2318528 defendant Thorn John husbandman 586714 586714 Thorn, John, of Hempnale, husbandman 0
4878399 2320190 2320190 defendant Lese Walter yeoman 586714 586714 Lese, Walter, of Hempnale, yeoman 0
4928752 2335420 2335420 defendant Colkyrk Henry tiler 586714 586714 Colkyrk, Henry, of Hempnale, tiler 0
4942030 2339490 2339490 defendant Colkyrke Henry yeoman 586714 586714 Colkyrke, Henry, of Hempnale, yeoman 0
4963978 2346135 2346135 defendant Tyler Henry tiler 586714 586714 Tyler, Henry, of Hempnale, tiler 1
4968132 2347417 2347417 defendant Borle Richard weaver 586714 586714 Borle, Richard, of Hempnale, weaver 0
4996053 2355673 2355673 defendant Bencelyn William tiler 586714 586714 Bencelyn, William, of Hempnale, tiler 0
5042468 2369353 2369353 defendant Glover John glover 586714 586714 Glover, John, of Hempnale, glover 4
5058699 2374165 2374165 defendant Rychemond Robert yeoman 586714 586714 Rychemond, Robert, of Hempnale, yeoman 0
5082062 2381130 2381130 defendant Richemond Robert yeoman 586714 586714 Richemond, Robert, of Hempnale, yeoman 0
5107322 2388569 2388569 defendant Colkirke Alice widow 586714 586714 (Colkirke, Alice, of Hempnale, widow 1
5109616 2389242 2389242 defendant Thorn John husbandman 586714 586714 Thorn, John, of Hempnale, husbandman 0
5111206 2389665 2389665 defendant Custauns John husbandman 586714 586714 Custauns, John, of Hempnale, husbandman 3
5113936 2390464 2390464 defendant Jaye Richard husbandman 586714 586714 Jaye, Richard, of Hempnale, husbandman 0
5122116 2392889 2392889 defendant Rychemond Robert yeoman 586714 586714 Rychemond, Robert, of Hempnale, yeoman 0
5212229 2419315 2419315 defendant Fuller Geoffrey clerk 586714 586714 Fuller, Geoffrey, of Hempnale, clerk 5
5212356 2419357 2419357 defendant Seferey Ralph shoemaker 586714 586714 Seferey, Ralph, of Hempnale, shoemaker 2
5213914 2419799 2419799 defendant Thorn John husbandman 586714 586714 Thorn, John, of Hempnale, husbandman 0
5223681 2422611 2422611 defendant Thorn John husbandman 586714 586714 Thorn, John, of Hempnale, husbandman 1
5227369 2423632 2423632 defendant Seffrey Thomas yeoman 586714 586714 Seffrey, Thomas, of Hempnale, yeoman 0
5233012 2425237 2425237 defendant Them John yeoman 586714 586714 Them, John, of Hempnale, yeoman 0
5251708 2430639 2430639 defendant Thorn John yeoman 586714 586714 Thorn, John, of Hempnale, yeoman 0
5270094 2436359 2436359 defendant Rechemond Robert yeoman 586714 586714 Rechemond, Robert, of Hempnale, yeoman 3
5271372 2436720 2436720 defendant Custance John husbandman 586714 586714 Custance, John, of Hempnale, husbandman 1
5276102 2438085 2438085 defendant Newehawe William husbandman 586714 586714 Newehawe, William, of Hempnale, husbandman 2
5278214 2438725 2438725 defendant Thorn John husbandman 586714 586714 Thorn, John, of Hempnale, husbandman 0
5281914 2439787 2439787 defendant Rychemonde Robert yeoman 586714 586714 Rychemonde, Robert, of Hempnale, yeoman 2
5285001 2440636 2440636 defendant Qwene Thomas yeoman 586714 586714 Qwene, Thomas, of Hempnale, glover, together with Goldsmyth, Robert, of Topcroft, yeoman 0
5285002 2440636 2440636 defendant Goldsmyth Geoffre smith 586714 586714 Goldsmyth, Geoffre, of Hempnale, smith 1
5285003 2440636 2440636 defendant Chetyller Walter tailor 586714 586714 Chetyller, Walter, of Hempnale, tailor 2
5285004 2440636 2440636 defendant Turnour Thomas husandman 586714 586714 Turnour, Thomas, of Hempnale, husandman 3
5293692 2443118 2443118 defendant Pykenot William husbandman 586714 586714 Pykenot, William, of Hempnale, husbandman 2
5306598 2446961 2446961 defendant Thorn John husbandman 586714 586714 Thorn, John, of Hempnale, husbandman 0
5326714 2453057 2453057 defendant Newehawe Hugh chaplain 586714 586714 Newehawe, Hugh, of Hempnale, chaplain 2
5352849 2460979 2460979 defendant Sporle Robert shoemaker 586714 586714 (Sporle, Robert, of Hempnale, shoemaker 2
5357702 2462476 2462476 defendant Kyng William butcher 586714 586714 Kyng, William, of Hempnale, butcher 2
5362128 2463820 2463820 defendant Sporle Robert yeoman 586714 586714 Sporle, Robert, of Hempnale, yeoman 0
5365280 2464816 2464816 defendant Seffrey William husbandman 586714 586714 Seffrey, William, of Hempnale, husbandman 0
5365854 2464974 2464974 plaintiff Sage John   586714 586714 Sage, John, of Hempnale 1
5365855 2464974 2464974 defendant Benslyn Robert husbandman 586714 586714 Benslyn, Robert, of Hempnale, husbandman 0
5380909 2469595 2469595 defendant Seffrey William husbandman 586714 586714 Seffrey, William, of Hempnale, husbandman 2
5384206 2470569 2470569 defendant Seffrey William husbandman 586714 586714 Seffrey, William, of Hempnale, husbandman 2
5386146 2471105 2471105 defendant Sefrey William yeoman 586714 586714 Sefrey, William, of Hempnale, yeoman 0
5391580 2472663 2472663 defendant Chetilborough Thomas husbandman 586714 586714 Chetilborough, Thomas, of Hempnale, husbandman 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);