names

125 rows where place_id = 588044

✎ 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
3593176 1865496 1865496 defendant Cutbert Richard gent 588044 588044 Cutbert, Richard, of Truruburgh, gent 0
3599104 1867356 1867356 defendant Treyouran John (legal representative) 588044 588044 Treyouran, John, of Truruburgh, gent, executor of Treouran, Roger, administrator of 0
3599105 1867356 1867356 defendant Treouran Henry gent 588044 588044 Treouran, Henry, of Truruburgh, gent 1
3599402 1867454 1867454 defendant Treoyuran John (legal representative) 588044 588044 Treoyuran, John, of Truruburgh, gent, executor of Treouran, Roger, administrator of 0
3599403 1867454 1867454 defendant Treouran Henry gent 588044 588044 Treouran, Henry, of Truruburgh, gent 1
3602229 1868362 1868362 defendant Skybyryowe John   588044 588044 Skybyryowe, John, of Truruburgh, franklin 0
3611759 1871342 1871342 defendant Glover Pascase glover 588044 588044 Glover, Pascase, of Truruburgh, glover 0
3611760 1871342 1871342 defendant Trigeon John merchant 588044 588044 Trigeon, John, of Truruburgh, merchant 1
3611761 1871342 1871342 defendant Meret John husbandman 588044 588044 Meret, John, of Truruburgh, husbandman 2
3611762 1871342 1871342 defendant Vychell John William husbandman 588044 588044 Vychell, John William, of Truruburgh, husbandman 3
3611763 1871342 1871342 defendant Morton John yeoman 588044 588044 Morton, John, of Truruburgh, yeoman 4
3611945 1871398 1871398 defendant Trewyke Richard yeoman 588044 588044 Trewyke, Richard, of Truruburgh, yeoman 0
3611955 1871400 1871400 defendant Melender John miller 588044 588044 Melender, John, of Truruburgh, miller 3
3611956 1871400 1871400 defendant William John Michell draper 588044 588044 William, John Michell, of Truruburgh, draper 4
3611957 1871400 1871400 defendant Angoyfbean John smith 588044 588044 Angoyfbean, John, of Truruburgh, smith 5
3629063 1903968 1903968 defendant Treweke John merchant 588044 588044 Treweke, John, of Truruburgh, merchant 0
3631387 1904628 1904628 defendant Norton Otto butcher 588044 588044 Norton, Otto, of Truruburgh, butcher 0
3631389 1904628 1904628 defendant Newman John yeoman 588044 588044 Newman, John, of Truruburgh, yeoman 2
3687413 1922240 1922240 defendant Bevylle Peter esq 588044 588044 Bevylle, Peter, of Truruburgh, esq 0
3687415 1922241 1922241 defendant Bevylle Peter esq 588044 588044 Bevylle, Peter, of Truruburgh, esq 0
3695025 1924655 1924655 defendant Newman John yeoman 588044 588044 Newman, John, of Truruburgh, yeoman 1
3696258 1925051 1925051 defendant Polsue William husbandman 588044 588044 Polsue, William, of Truruburgh, husbandman 1
3697974 1925590 1925590 defendant Michell Drew merchant 588044 588044 Michell, Drew, of Truruburgh, merchant 1
3710177 1929498 1929498 defendant Trewyke John   588044 588044 Trewyke, John, of Truruburgh 0
3712345 1930179 1930179 defendant Norton Oto merchant 588044 588044 Norton, Oto, of Truruburgh, merchant 0
3712346 1930179 1930179 defendant Jak William John yeoman 588044 588044 Jak William, John, of Truruburgh, yeoman 1
3712347 1930179 1930179 defendant Austyn Henry yeoman 588044 588044 Austyn, Henry, of Truruburgh, yeoman 2
3712348 1930179 1930179 defendant Laurence Oto merchant 588044 588044 Laurence, Oto, of Truruburgh, merchant 3
3722475 1933290 1933290 plaintiff Michell John   588044 588044 Michell, John, of Truruburgh 0
3722476 1933290 1933290 defendant Bevill Peter gent 588044 588044 Bevill, Peter, of Truruburgh, gent 0
3726711 1934617 1934617 defendant Michell Drew merchant 588044 588044 Michell, Drew, of Truruburgh, merchant 0
3772051 1948948 1948948 defendant Luyar William dyer 588044 588044 Luyar, William, of Truruburgh, dyer 0
3774296 1949683 1949683 defendant Kytson John sherman 588044 588044 Kytson, John, of Truruburgh, sherman 1
3801229 1958308 1958308 plaintiff Michell John   588044 588044 Michell, John, of Truruburgh 0
3841793 1971016 1971016 defendant Jackwilliam John tinner 588044 588044 Jackwilliam, John, of Truruburgh, tinner 1
3845313 1972095 1972095 defendant Randall Nicholas cordwainer 588044 588044 Randall, Nicholas, of Truruburgh, cordwainer 0
3862301 1977578 1977578 defendant Michell Drew merchant 588044 588044 Michell, Drew, of Truruburgh, merchant 0
3871110 1980590 1980590 defendant Weryng Richard carpenter 588044 588044 Weryng, Richard, of Truruburgh, carpenter 0
3871111 1980590 1980590 defendant Wylliam John glover 588044 588044 Wylliam, John, of Truruburgh, glover 1
3873250 1981270 1981270 defendant Spycer alias Tredacke John shipmaster 588044 588044 Spycer alias Tredacke, John, of Truruburgh, shipmaster 0
3874713 1981759 1981759 defendant Hoygge Thomas   588044 588044 Hoygge, Thomas, of Truruburgh, mason 0
3900636 1990444 1990444 defendant Stephyn Philip merchant 588044 588044 Stephyn, Philip, of Truruburgh, merchant 0
3905813 1992225 1992225 defendant Ryce George yeoman 588044 588044 Ryce, George, of Truruburgh, yeoman 0
3918887 1996639 1996639 defendant Buys Nicholas merchant 588044 588044 Buys, Nicholas, of Truruburgh, merchant 0
3919742 1996942 1996942 defendant Buys Nicholas merchant 588044 588044 Buys, Nicholas, of Truruburgh, merchant 0
3919743 1996942 1996942 defendant Rice George merchant 588044 588044 Rice, George, of Truruburgh, merchant 1
3926937 1999340 1999340 defendant Michell Drewe merchant 588044 588044 Michell, Drewe, of Truruburgh, merchant 0
4799448 2296008 2296008 defendant Millender Oliver   588044 588044 Millender, Oliver, of Truruburgh, millward 0
4860401 2314616 2314616 defendant Josep Thomas tanner 588044 588044 Josep, Thomas, of Truruburgh, tanner 0
4860803 2314741 2314741 defendant Jakhopkyn John painter 588044 588044 Jakhopkyn, John, of Truruburgh, painter 0
4860807 2314742 2314742 defendant Jakhopkyn Thomas painter 588044 588044 Jakhopkyn, Thomas, of Truruburgh, painter 0
4868206 2317036 2317036 plaintiff Hykkealy John carpenter 588044 588044 Hykkealy, John, of Truruburgh, carpenter 0
4868208 2317036 2317036 defendant Kymbre Lawrence yeoman 588044 588044 Kymbre, Lawrence, of Truruburgh, yeoman 1
4868209 2317036 2317036 defendant Porthkyllys William carpenter 588044 588044 Porthkyllys, William, of Truruburgh, carpenter 2
4868210 2317036 2317036 defendant Condorewe John yeoman 588044 588044 Condorewe, John, of Truruburgh, yeoman 3
4896518 2325582 2325582 defendant John Thomas husbandman 588044 588044 John, Thomas, of Truruburgh, husbandman 0
4896554 2325592 2325592 plaintiff Treghere John   588044 588044 Treghere, John, of Truruburgh 0
4982601 2351708 2351708 defendant Touker William tucker 588044 588044 Touker, William, of Truruburgh, tucker 1
5061122 2374903 2374903 defendant Penles or Peules John merchant 588044 588044 Penles or Peules, John, of Truruburgh, merchant 2
5061127 2374904 2374904 defendant Penles or Peules John merchant 588044 588044 Penles or Peules, John, of Truruburgh, merchant 2
5084832 2381968 2381968 defendant Michell John husbandman 588044 588044 Michell, John, of Truruburgh, husbandman 0
5084835 2381969 2381969 defendant Michell John husbandman 588044 588044 Michell, John, of Truruburgh, husbandman 0
5088460 2383000 2383000 defendant Goef Nicholas mariner 588044 588044 Goef, Nicholas, of Truruburgh, mariner 2
5091299 2383854 2383854 defendant Trehere Martin tailor 588044 588044 Trehere, Martin, of Truruburgh, tailor 0
5091304 2383855 2383855 defendant Trehere Martin tailor 588044 588044 Trehere, Martin, of Truruburgh, tailor 0
5097895 2385814 2385814 defendant Lagher Thomas   588044 588044 Lagher, Thomas, of Truruburgh, crock maker 1
5097915 2385821 2385821 defendant Milward Peter   588044 588044 Milward, Peter, of Truruburgh, millward 0
5120397 2392392 2392392 defendant Joan alias Trehar Martin husbandman or tailor 588044 588044 Joan alias Trehar, Martin, of Truruburgh, husbandman or tailor 2
5212539 2419415 2419415 defendant Penelewe Urban yeoman 588044 588044 Penelewe, Urban, of Truruburgh, yeoman 1
5212540 2419415 2419415 defendant Bray Thomas yeoman 588044 588044 Bray, Thomas, of Truruburgh, yeoman 2
5250843 2430374 2430374 defendant Treouran John gent 588044 588044 Treouran, John, of Truruburgh, gent 0
5254091 2431397 2431397 defendant Laghar William gent 588044 588044 Laghar, William, of Truruburgh, gent 1
5258455 2432759 2432759 defendant Josep Thomas husbandman 588044 588044 Josep, Thomas, of Truruburgh, husbandman 0
5280065 2439245 2439245 defendant Polglas John (legal representative) 588044 588044 Polglas, John, of Truruburgh, dyer, executor of 1
5280066 2439245 2439245 defendant Polglas John yeoman 588044 588044 Polglas, John, of Truruburgh, yeoman 2
5295209 2443590 2443590 defendant Gay Thomas gent 588044 588044 Gay, Thomas, of Truruburgh, gent 3
5321424 2451499 2451499 defendant Markowe John, senior ostler or yeoman 588044 588044 Markowe, John, senior, of Truruburgh, ostler or yeoman 2
5321425 2451499 2451499 defendant Trekernethe Oto yeoman 588044 588044 Trekernethe, Oto, of Truruburgh, yeoman 3
5323776 2452198 2452198 defendant Aleyn John   588044 588044 Aleyn, John, of Truruburgh, groom 1
5323777 2452198 2452198 defendant Marcawe William chaplain 588044 588044 Marcawe, William, of Truruburgh, chaplain 2
5323779 2452198 2452198 defendant Tremayn William tailor 588044 588044 Tremayn, William, of Truruburgh, tailor 4
5323785 2452199 2452199 defendant Aleyn Margaret widow 588044 588044 together with Aleyn, Margaret, of Truruburgh, widow 2
5323786 2452199 2452199 defendant Aleyn John   588044 588044 Aleyn, John, of Truruburgh, groom 3
5323787 2452199 2452199 defendant Marcawe William chaplain 588044 588044 Marcawe, William, of Truruburgh, chaplain 4
5323789 2452199 2452199 defendant Tremayn William tailor 588044 588044 Tremayn, William, of Truruburgh, tailor 6
5323942 2452244 2452244 defendant Varcowe William chaplain 588044 588044 Varcowe, William, of Truruburgh, chaplain 0
5327354 2453252 2453252 defendant Baylly William weaver 588044 588044 Baylly, William, of Truruburgh, weaver 2
5327355 2453252 2453252 defendant Porthkellys Walter carpenter 588044 588044 Porthkellys, Walter, of Truruburgh, carpenter 3
5327356 2453252 2453252 defendant Thomas Michael weaver 588044 588044 Thomas, Michael, of Truruburgh, weaver 4
5330616 2454247 2454247 defendant Banden William tanner 588044 588044 Banden, William, of Truruburgh, tanner 1
5330617 2454247 2454247 defendant Oppy John cordwainer 588044 588044 Oppy, John, of Truruburgh, cordwainer 2
5330618 2454247 2454247 defendant Touker Henry tucker 588044 588044 Touker, Henry, of Truruburgh, tucker 3
5330619 2454247 2454247 defendant Cordelyon Walter miller 588044 588044 Cordelyon, Walter, of Truruburgh, miller 4
5330641 2454249 2454249 defendant Banden or Bauen William tanner 588044 588044 Banden or Bauen, William, of Truruburgh, tanner 2
5330642 2454249 2454249 defendant Oppy John cordwainer 588044 588044 Oppy, John, of Truruburgh, cordwainer 3
5330643 2454249 2454249 defendant Touker Henry tucker 588044 588044 Touker, Henry, of Truruburgh, tucker 4
5330644 2454249 2454249 defendant Cordelyon Walter miller 588044 588044 Cordelyon, Walter, of Truruburgh, miller 5
5359553 2463023 2463023 defendant Courdelyon Walter miller 588044 588044 Courdelyon, Walter, of Truruburgh, miller 0
5359554 2463023 2463023 defendant Pynnowe Stephen husbandman 588044 588044 Pynnowe, Stephen, of Truruburgh, husbandman 1
5362421 2463902 2463902 defendant Burthey Drew tanner 588044 588044 Burthey, Drew, of Truruburgh, tanner 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);