names

117 rows where place_id = 593908

✎ 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
3613813 1871977 1871977 defendant Carvanell or Carnavell Peter yeoman 593908 593908 Carvanell or Carnavell, Peter, of Penrynburgh, yeoman 0
3619883 1873793 1873793 defendant Boveythen or Boneythen James esq 593908 593908 Boveythen or Boneythen, James, of Penrynburgh, esq 0
3644159 1908607 1908607 defendant Petyt Thomas gent 593908 593908 Petyt, Thomas, of Penrynburgh, gent 0
3646980 1909456 1909456 defendant Bevell John gent 593908 593908 Bevell, John, of Penrynburgh, gent 0
3646981 1909456 1909456 defendant Bodrygy Gerend   593908 593908 Bodrygy, Gerend, of Penrynburgh, franklin 1
3652110 1911008 1911008 defendant Harrys Peter yeoman 593908 593908 Harrys, Peter, of Penrynburgh, yeoman 3
3676594 1918718 1918718 defendant Colorian Thomasine widow 593908 593908 Colorian, Thomasine, of Penrynburgh, widow 0
3676595 1918718 1918718 defendant Colroger Thomas   593908 593908 Colroger, Thomas, of Penrynburgh, franklin 1
3676596 1918718 1918718 defendant Polkeynhorne Thomas   593908 593908 Polkeynhorne, Thomas, of Penrynburgh, franklin 2
3692299 1923761 1923761 defendant Cavell John gent 593908 593908 Cavell, John, of Penrynburgh, gent 0
3704053 1927556 1927556 defendant Myller Roger miller 593908 593908 Myller, Roger, of Penrynburgh, miller 1
3719710 1932433 1932433 defendant Vyaugh George husbandman 593908 593908 Vyaugh, George, of Penrynburgh, husbandman 0
3719711 1932433 1932433 defendant George Walter laborer 593908 593908 George, Walter, of Penrynburgh, laborer 1
3719712 1932433 1932433 defendant Tremouth John husbandman 593908 593908 Tremouth, John, of Penrynburgh, husbandman 2
3719713 1932433 1932433 defendant George John tailor 593908 593908 George, John, of Penrynburgh, tailor 3
3822794 1965034 1965034 defendant Morell Henry yeoman 593908 593908 Morell, Henry, of Penrynburgh, yeoman 1
3839201 1970187 1970187 defendant Garrard John chapman 593908 593908 Garrard, John, of Penrynburgh, chapman 0
3841617 1970961 1970961 defendant Bartholomewe John carpenter 593908 593908 Bartholomewe, John, of Penrynburgh, carpenter 3
3843079 1971360 1971360 defendant Dowyer John weaver 593908 593908 Dowyer, John, of Penrynburgh, weaver 0
3848451 1973095 1973095 defendant Rayson Francis   593908 593908 Rayson, Francis, of Penrynburgh, "bryton" 0
3899417 1990019 1990019 defendant Carnavell Alexander yoman 593908 593908 Carnavell, Alexander, of Penrynburgh, yoman 5
4709268 2268267 2268267 defendant Kerys Robert   593908 593908 Kerys, Robert, of Penrynburgh 0
4794371 2294384 2294384 defendant Colle Oto helier or roofer 593908 593908 Colle, Oto, of Penrynburgh, helier or roofer 0
4861194 2314865 2314865 defendant Morys Stephen yeoman 593908 593908 Morys, Stephen, of Penrynburgh, yeoman 0
4882534 2321445 2321445 defendant Urban Isabel widow 593908 593908 Urban, Isabel, of Penrynburgh, widow 2
4890648 2323831 2323831 defendant Urban Isabel widow 593908 593908 Urban, Isabel, of Penrynburgh, widow 2
4934175 2337076 2337076 defendant Vathy Thomas tailor 593908 593908 Vathy, Thomas, of Penrynburgh, tailor 0
4942108 2339515 2339515 defendant Bossonsek Thomas tailor 593908 593908 (Bossonsek, Thomas, of Penrynburgh, tailor 1
4942109 2339515 2339515 defendant Carnergh Benedict husbandman 593908 593908 Carnergh, Benedict, of Penrynburgh, husbandman 2
4942110 2339515 2339515 defendant Michell John chapman 593908 593908 Michell, John, of Penrynburgh, chapman 3
4961721 2345468 2345468 defendant Hasell William laborer 593908 593908 Hasell, William, of Penrynburgh, laborer 0
5082826 2381369 2381369 defendant Trefethen John gent 593908 593908 Trefethen, John, of Penrynburgh, gent 0
5113457 2390327 2390327 defendant Matthy Thomas yeoman 593908 593908 Matthy, Thomas, of Penrynburgh, yeoman 0
5113458 2390327 2390327 defendant Hoggys Henry gent 593908 593908 Hoggys, Henry, of Penrynburgh, gent 1
5113461 2390327 2390327 defendant Kellygrewe Thomas gent 593908 593908 Kellygrewe, Thomas, of Penrynburgh, gent 4
5254616 2431564 2431564 defendant Jakmychell Henry tucker 593908 593908 Jakmychell, Henry, of Penrynburgh, tucker 1
5254617 2431564 2431564 defendant Tyler John tiler 593908 593908 Tyler, John, of Penrynburgh, tiler 2
5254618 2431564 2431564 defendant Parker Roert dyer 593908 593908 Parker, Roert, of Penrynburgh, dyer 3
5258656 2432829 2432829 defendant Cokke James clerk 593908 593908 Cokke, James, of Penrynburgh, clerk 0
5258658 2432830 2432830 defendant Cokke James clerk 593908 593908 Cokke, James, of Penrynburgh, clerk 0
5265997 2435120 2435120 defendant Carnsnyowe Thomas husbandman 593908 593908 Carnsnyowe, Thomas, of Penrynburgh, husbandman 4
5278100 2438688 2438688 plaintiff Baryll John, junior   593908 593908 Baryll, John, junior, of Penrynburgh 0
5278101 2438688 2438688 defendant Cobbe William merchant 593908 593908 Cobbe, William, of Penrynburgh, or of Penbroke, merchant 0
5284618 2440515 2440515 plaintiff Garyll John, junior   593908 593908 Garyll, John, junior, of Penrynburgh 0
5284619 2440515 2440515 defendant Cobbe William merchant 593908 593908 Cobbe, William, of Penrynburgh, or of Penbroke, merchant 0
5295195 2443588 2443588 defendant Pennans John gent 593908 593908 Pennans, John, of Penrynburgh, gent 0
5317569 2450340 2450340 defendant Toket Mathew merchant 593908 593908 Toket, Mathew, of Penrynburgh, merchant 0
5330654 2454250 2454250 defendant Tucote Mathew tailor 593908 593908 Tucote, Mathew, of Penrynburgh, tailor 0
5330655 2454250 2454250 defendant Chynnowe William cordwainer 593908 593908 Chynnowe, William, of Penrynburgh, cordwainer 1
5330656 2454250 2454250 defendant Jakmychell Henry tucker 593908 593908 Jakmychell, Henry, of Penrynburgh, tucker 2
5330661 2454250 2454250 defendant Bally William tanner 593908 593908 Bally, William, of Penrynburgh, tanner 7
5333075 2454963 2454963 defendant Weller Noel weaver 593908 593908 Weller, Noel, of Penrynburgh, weaver 1
5333076 2454963 2454963 defendant Frank Henry   593908 593908 Frank, Henry, of Penrynburgh, groom 2
5333077 2454963 2454963 defendant Buttewyn William tailor 593908 593908 Buttewyn, William, of Penrynburgh, tailor 3
5333078 2454963 2454963 defendant Wardell John yeoman 593908 593908 Wardell, John, of Penrynburgh, yeoman 4
5344474 2458449 2458449 defendant Drogon John laborer 593908 593908 Drogon, John, of Penrynburgh, laborer 0
5344476 2458449 2458449 defendant Kyllygrewe Thomas gent 593908 593908 Kyllygrewe, Thomas, of Penrynburgh, gent 2
5344477 2458449 2458449 defendant Fallasse Noel Herry weaver 593908 593908 Fallasse, Noel Herry, of Penrynburgh, weaver 3
5344478 2458449 2458449 defendant Janyn Henry weaver 593908 593908 Janyn, Henry, of Penrynburgh,weaver 4
5344479 2458449 2458449 defendant Bertolomewe John tucker 593908 593908 Bertolomewe, John, of Penrynburgh, tucker 5
5344480 2458449 2458449 defendant Rawe Thomas cpordwainer 593908 593908 Rawe, Thomas, of Penrynburgh, cpordwainer 6
5344484 2458449 2458449 defendant Kestell Richard tailor 593908 593908 Kestell, Richard, of Penrynburgh, tailor 10
5344485 2458449 2458449 defendant John William tailor 593908 593908 John, William, of Penrynburgh, tailor 11
5344486 2458449 2458449 defendant Skynne David Perys laborer 593908 593908 Skynne, David Perys, of Penrynburgh, laborer 12
5344487 2458449 2458449 defendant Seyntaubyn William tailor 593908 593908 Seyntaubyn, William, of Penrynburgh, tailor 13
5344735 2458528 2458528 defendant Danyolla John scrivener 593908 593908 Danyolla, John, of Penrynburgh, scrivener 0
5344736 2458528 2458528 defendant Hellys Thomas yeoman 593908 593908 Hellys, Thomas, of Penrynburgh, yeoman 1
5344737 2458528 2458528 defendant Hikcauntour Thomas laborer 593908 593908 Hikcauntour, Thomas, of Penrynburgh, laborer 2
5344738 2458528 2458528 defendant Jacmychell Henry yeoman 593908 593908 Jacmychell, Henry, of Penrynburgh, yeoman 3
5344739 2458528 2458528 defendant Reyll John yeoman 593908 593908 Reyll, John, of Penrynburgh, yeoman 4
5344743 2458528 2458528 defendant Tucote Mathew tailor 593908 593908 together with Tucote, Mathew, of Penrynburgh, tailor 8
5344751 2458529 2458529 defendant Tucote Mathew tailor 593908 593908 Tucote, Mathew, of Penrynburgh, tailor 0
5344754 2458529 2458529 defendant Tucote John laborer 593908 593908 Tucote, John, of Penrynburgh, laborer 3
5344755 2458529 2458529 defendant Danyolla John scrivener 593908 593908 together with Danyolla, John, of Penrynburgh, scrivener 4
5344756 2458529 2458529 defendant Hellys Thomas yeoman 593908 593908 Hellys, Thomas, of Penrynburgh, yeoman 5
5344757 2458529 2458529 defendant Hikcaunter Thomas laborer 593908 593908 Hikcaunter, Thomas, of Penrynburgh, laborer 6
5344758 2458529 2458529 defendant Jakmichell Henry yeoman 593908 593908 Jakmichell, Henry, of Penrynburgh, yeoman 7
5344759 2458529 2458529 defendant Reyll John yeoman 593908 593908 Reyll, John, of Penrynburgh, yeoman 8
5346556 2459072 2459072 defendant Hygowe Richard chaplain 593908 593908 Hygowe, Richard, of Penrynburgh, chaplain 1
5346557 2459072 2459072 defendant Penmeneth Florence widow 593908 593908 Penmeneth, Florence, of Penrynburgh, widow 2
5346558 2459072 2459072 defendant Corse Agnes widow 593908 593908 Corse, Agnes, of Penrynburgh, widow 3
5391653 2472681 2472681 defendant (not given) John vicar of Luky 593908 593908 Luky, John, of Penrynburgh, clerk & perpetual vicar of the collegiate church of St Thomas the Martyr, in Glasney 0
5492122 2502554 2502554 defendant Dungy John husbandman 593908 593908 Dungy, John, of Penrynburgh, husbandman 0
5503349 2505958 2505958 defendant (not given) John vicar of Luky 593908 593908 Luky, John, of Penrynburgh, clerk, vicar of St Thomas Martyr College, Glasneye 0
5517208 2510216 2510216 defendant Kellygrewe Thomas esq 593908 593908 Kellygrewe, Thomas, of Penrynburgh, esq 0
5536523 2515907 2515907 defendant William Thomas husbandman 593908 593908 William, Thomas, of Penrynburgh, husbandman 0
5538496 2516522 2516522 defendant Mercer Katherine widow 593908 593908 Mercer, Katherine, of Penrynburgh, widow 1
5541473 2517449 2517449 plaintiff Killygrewe Thomas (legal representative) 593908 593908 Killygrewe, Thomas, of Penrynburgh, esq, executors of 0
5541614 2517485 2517485 plaintiff Kylligrewe Thomas (legal representative) 593908 593908 Kylligrewe, Thomas, of Penrynburgh, esq, executors of 0
5541624 2517487 2517487 plaintiff Kyllygrewe Thomas (legal representative) 593908 593908 Kyllygrewe, Thomas, of Penrynburgh, esq, executors of 0
5542755 2517854 2517854 defendant (not given) Alexander rector of Penhyll 593908 593908 Penhyll, Alexander, of Penrynburgh, rector of St Logan 0
5546581 2519001 2519001 defendant Court John merchant 593908 593908 Court, John, of Penrynburgh, merchant 0
5546771 2519058 2519058 defendant Janyn Simon smith 593908 593908 Janyn, Simon, of Penrynburgh, smith 0
5555646 2521644 2521644 defendant Pers Henry pewterer 593908 593908 Pers, Henry, of Penrynburgh, pewterer 0
5562764 2523697 2523697 defendant Roscorowe William mercer 593908 593908 Roscorowe, William, of Penrynburgh, mercer 0
5570354 2525898 2525898 defendant John Mathew chaplain 593908 593908 John, Mathew, of Penrynburgh, chaplain 0
5572308 2526454 2526454 defendant Gerves William gent 593908 593908 Gerves, William, of Penrynburgh, gent 0
5572998 2526651 2526651 defendant Bevyll John gent 593908 593908 Bevyll, John, of Penrynburgh, gent 0
5573004 2526654 2526654 defendant Tresythny John gent 593908 593908 Tresythny, John, of Penrynburgh, gent 0
5574237 2527029 2527029 defendant Gerves William gent 593908 593908 Gerves, William, of Penrynburgh, 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);