names

102 rows where place_id = 730909

✎ 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
4291217 2126925 2126925 defendant Hooper William husbandman 730909 730909 Hooper, William, of Okhampton, husbandman 0
4291218 2126925 2126925 defendant Ware William husbandman 730909 730909 Ware, William, of Okhampton, husbandman 1
4291219 2126925 2126925 defendant Payne John husbandman 730909 730909 together with Payne, John, of Okhampton, husbandman 2
4485434 2196150 2196150 defendant Trewyna Henry   730909 730909 Trewyna, Henry, of Okhampton 0
4485591 2196200 2196200 defendant Trellyva Henry   730909 730909 Trellyva, Henry, of Okhampton 0
4491639 2198070 2198070 defendant Neucomena Richard   730909 730909 Neucomena, Richard, of Okhampton 1
4550713 2216167 2216167 plaintiff Denebold Geoffrey   730909 730909 Denebold, Geoffrey, of Okhampton 0
4568043 2221571 2221571 defendant Beaueclerk John   730909 730909 Beaueclerk, John, of Okhampton 0
4568044 2221571 2221571 defendant Osmond John   730909 730909 Osmond, John, of Okhampton 1
4589929 2228210 2228210 defendant Nemet William   730909 730909 Nemet, William, of Okhampton 2
4612471 2234966 2234966 defendant Lemman John   730909 730909 Lemman, John, of Okhampton 0
4612473 2234967 2234967 defendant Lemman John   730909 730909 Lemman, John, of Okhampton 0
4621936 2237840 2237840 defendant Milleward John   730909 730909 Milleward, John, of Okhampton 0
4657892 2248354 2248354 defendant Peyrs John, junior skinner 730909 730909 Peyrs, John, junior, of Okhampton, skinner 0
4657894 2248354 2248354 defendant Osmound John, senior glasier 730909 730909 Osmound, John, senior, of Okhampton, glasier 2
4657895 2248354 2248354 defendant Osmound John, junior glasyer 730909 730909 Osmound, John, junior, of Okhampton, glasyer 3
4658432 2248517 2248517 defendant Breghe John tanner 730909 730909 Breghe, John, of Okhampton, tanner 0
4658433 2248517 2248517 defendant Crymell William   730909 730909 Crymell, William, of Okhampton, "fysshionter" 1
4658434 2248517 2248517 defendant Shylleston John shoemaker 730909 730909 Shylleston, John, of Okhampton, shoemaker 2
4658480 2248532 2248532 defendant Juyll of Ivyll Richard carpenter 730909 730909 Juyll of Ivyll, Richard, of Okhampton, carpenter 0
4672946 2257179 2257179 defendant Levunan Walter shoemaker 730909 730909 Levunan, Walter, of Okhampton, shoemaker 0
4673842 2257438 2257438 plaintiff Denbold Geoffrey   730909 730909 Denbold, Geoffrey, of Okhampton, on his own account 0
4735864 2276368 2276368 defendant Kyng John shoemaker 730909 730909 Kyng, John, of Okhampton, shoemaker 0
4740783 2277821 2277821 defendant Coule John husbandman 730909 730909 Coule, John, of Okhampton, husbandman 0
4741425 2277986 2277986 defendant Matheu John shoemaker 730909 730909 Matheu, John, of Okhampton, shoemaker 1
4778767 2289333 2289333 defendant Tokevyll Robert husbandman 730909 730909 Tokevyll, Robert, of Okhampton, husbandman 3
4786541 2291840 2291840 defendant Tokevyle Robert husbandman 730909 730909 Tokevyle, Robert, of Okhampton, husbandman 3
4787413 2292132 2292132 defendant Shyre William cordwainer 730909 730909 Shyre, William, of Okhampton, cordwainer 1
4787414 2292132 2292132 defendant Stokhey William tanner 730909 730909 Stokhey, William, of Okhampton, tanner 2
4787967 2292304 2292304 defendant Weryng John clerk 730909 730909 Weryng, John, of Okhampton, clerk 1
4795864 2294856 2294856 defendant Poul Roger smith 730909 730909 Poul, Roger, of Okhampton, smith 2
4800965 2296492 2296492 defendant Brogh John tanner 730909 730909 Brogh, John, of Okhampton, tanner 2
4804109 2297473 2297473 defendant Northecote John fisher 730909 730909 Northecote, John, of Okhampton, fisher 0
4805663 2297980 2297980 defendant atte Wille John   730909 730909 atte Wille, John, of Okhampton 0
4806007 2298089 2298089 defendant atte Berne John   730909 730909 atte Berne, John, of Okhampton 0
4808261 2298762 2298762 defendant Rysdon Matilda   730909 730909 (Rysdon, Matilda, of Okhampton, widow, formerly wife of Testator 1
4816381 2301215 2301215 defendant Bregh John husbandman 730909 730909 Bregh, John, of Okhampton, husbandman 0
4818604 2301900 2301900 defendant Breghe John husbandman 730909 730909 Breghe, John, of Okhampton, husbandman 0
4821359 2302763 2302763 defendant Northecote John fisher 730909 730909 Northecote, John, of Okhampton, fisher 0
4825050 2303876 2303876 defendant Bray John husbandman 730909 730909 Bray, John, of Okhampton, husbandman 0
4834421 2306773 2306773 defendant Ryston Thomas (legal representative) 730909 730909 Ryston, Thomas, of Okhampton, executors of 0
4840799 2308659 2308659 defendant Estacote William tanner 730909 730909 Estacote, William, of Okhampton, tanner 1
4840800 2308659 2308659 defendant Lenman Walter   730909 730909 Lenman, Walter, of Okhampton, shoe maker 2
4840801 2308659 2308659 defendant Smyth John smith 730909 730909 Smyth, John, of Okhampton, smith 3
4869152 2317328 2317328 defendant Attewille John cutler 730909 730909 Attewille, John, of Okhampton, cutler 0
4872352 2318314 2318314 defendant Wrentemour William (legal representative) 730909 730909 Wrentemour, William, of Okhampton, executors of 6
4872353 2318314 2318314 defendant Piers Henry husbandman 730909 730909 (Piers, Henry, of Okhampton, husbandman 7
4881409 2321085 2321085 defendant Burlond Thomas husbandman 730909 730909 Burlond, Thomas, of Okhampton, husbandman 0
4888556 2323220 2323220 defendant Toly Margery   730909 730909 Toly, Margery, of Okhampton, servant 0
4889234 2323418 2323418 defendant Breghe Joan widow 730909 730909 (Breghe, Joan, of Okhampton, widow 1
4889235 2323418 2323418 defendant Breghe William clerk 730909 730909 Breghe, William, of Okhampton, clerk 2
4893606 2324701 2324701 defendant Breghe Joan widow 730909 730909 (Breghe, Joan, of Okhampton, widow 1
4893607 2324701 2324701 defendant Breghe William clerk 730909 730909 Breghe, William, of Okhampton, clerk 2
4900778 2326878 2326878 defendant Geffrey Richard mercer 730909 730909 Geffrey, Richard, of Okhampton, mercer 2
4901362 2327036 2327036 defendant Rondon or Roudon William shoemaker 730909 730909 Rondon or Roudon, William, of Okhampton, shoemaker 0
4901363 2327036 2327036 defendant Hethman John shoemaker 730909 730909 Hethman, John, of Okhampton, shoemaker 1
4904076 2327890 2327890 defendant Rondon or Roudon William shoemaker 730909 730909 Rondon or Roudon, William, of Okhampton, shoemaker 0
4904077 2327890 2327890 defendant Hethman John shoemaker 730909 730909 Hethman, John, of Okhampton, shoemaker 1
4908663 2329264 2329264 defendant Corndon Roger yeoman 730909 730909 Corndon, Roger, of Okhampton, yeoman 4
4919450 2332588 2332588 defendant Cama or Canna Nicholas hostler 730909 730909 Cama or Canna, Nicholas, of Okhampton, hostler 0
4931307 2336170 2336170 defendant Rysdon Geoffrey husbandman 730909 730909 Rysdon, Geoffrey, of Okhampton, husbandman 0
4948192 2341407 2341407 defendant Bonvyle William yeoman 730909 730909 Bonvyle, William, of Okhampton, yeoman 0
4965132 2346496 2346496 defendant Estecote William tanner 730909 730909 Estecote, William, of Okhampton, tanner 1
4974009 2349188 2349188 defendant Coryngdon Roger yeoman 730909 730909 Coryngdon, Roger, of Okhampton, yeoman 4
4985835 2352678 2352678 defendant Skynner John skinner 730909 730909 Skynner, John, of Okhampton, skinner 3
4988797 2353605 2353605 defendant Canne Richard weaver 730909 730909 Canne, Richard, of Okhampton, weaver 0
4995831 2355599 2355599 defendant Denbold Henry gent 730909 730909 Denbold, Henry, of Okhampton, gent 0
5010177 2359842 2359842 defendant Rysdon Geoffrey yeoman 730909 730909 Rysdon, Geoffrey, of Okhampton, yeoman 0
5011988 2360356 2360356 defendant Stracche John yeoman 730909 730909 Stracche, John, of Okhampton, yeoman 1
5011989 2360356 2360356 defendant Kylbury John shoemaker 730909 730909 Kylbury, John, of Okhampton, shoemaker 2
5016060 2361579 2361579 defendant Geffray Richard   730909 730909 Geffray, Richard, of Okhampton, bailiff 0
5021530 2363197 2363197 defendant Geffray Richard   730909 730909 Geffray, Richard, of Okhampton, bailiff 1
5030238 2365713 2365713 defendant Huyssh Thomas yeoman 730909 730909 Huyssh, Thomas, of Okhampton, yeoman 1
5035181 2367153 2367153 defendant Geffrey Richard   730909 730909 Geffrey, Richard, of Okhampton, bailiff 0
5035740 2367309 2367309 defendant Hakeworthy Walter   730909 730909 Hakeworthy, Walter, of Okhampton 0
5039899 2368576 2368576 defendant Barne John merchant 730909 730909 Barne, John, of Okhampton, merchant 0
5060447 2374703 2374703 defendant Wode John chaplain 730909 730909 Wode, John, of Okhampton, chaplain 0
5078048 2379917 2379917 defendant Barne John merchant 730909 730909 Barne, John, of Okhampton, merchant 0
5093668 2384544 2384544 defendant Alyn Thomas tailor 730909 730909 Alyn, Thomas, of Okhampton, tailor 0
5093669 2384544 2384544 defendant More John smith 730909 730909 More, John, of Okhampton, smith 1
5108824 2389008 2389008 defendant atte Bern John husbandman 730909 730909 atte Bern, John, of Okhampton, husbandman 0
5113397 2390310 2390310 defendant Geffrey Richard yeoman 730909 730909 Geffrey, Richard, of Okhampton, yeoman 0
5126458 2394214 2394214 defendant Barbour John barber 730909 730909 Barbour, John, of Okhampton, barber 0
5128954 2394953 2394953 defendant Geffray Richard yeoman 730909 730909 Geffray, Richard, of Okhampton, yeoman 0
5128976 2394960 2394960 defendant Geffrey Richard yeoman 730909 730909 Geffrey, Richard, of Okhampton, yeoman 0
5135123 2396770 2396770 defendant Estcote William tanner 730909 730909 Estcote, William, of Okhampton, tanner 0
5135817 2396990 2396990 plaintiff More John parker 730909 730909 More, John, of Okhampton, parker 0
5142548 2398948 2398948 defendant Addelerd Roger tanner 730909 730909 Addelerd, Roger, of Okhampton, tanner 0
5213040 2419551 2419551 defendant Lytelweke William merchant 730909 730909 Lytelweke, William, of Okhampton, merchant 2
5221089 2421873 2421873 defendant Geffray Richard husbandman 730909 730909 Geffray, Richard, of Okhampton, husbandman 0
5222080 2422160 2422160 defendant Estcote William tanner 730909 730909 Estcote, William, of Okhampton, tanner 0
5258538 2432786 2432786 defendant Horewyll Nicholas husbandman 730909 730909 Horewyll, Nicholas, of Okhampton, husbandman 0
5270611 2436500 2436500 defendant Stabbok John husbandman 730909 730909 Stabbok, John, of Okhampton, husbandman 3
5288381 2441623 2441623 plaintiff Litelweke William (legal representative) 730909 730909 Litelweke, William, of Okhampton, administratrix of 0
5288950 2441774 2441774 plaintiff Lytelwyke William (legal representative) 730909 730909 Lytelwyke, William, of Okhampton, administratrix of 0
5321325 2451472 2451472 plaintiff Litelweke William   730909 730909 Litelweke, William, of Okhampton, administrators of 0
5321330 2451473 2451473 plaintiff Litelweke William   730909 730909 Litelweke, William, of Okhampton, administrators of 0
5333628 2455130 2455130 defendant Growedon Walter yeoman 730909 730909 Growedon, Walter, of Okhampton, yeoman 0
5333632 2455131 2455131 defendant Growedon Walter yeoman 730909 730909 Growedon, Walter, of Okhampton, yeoman 0
5464009 2494152 2494152 defendant Flode John chaplain 730909 730909 Flode, John, of Okhampton, chaplain 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);