names

134 rows where place_id = 596909

✎ 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
3626606 1903174 1903174 defendant Masele William gent 596909 596909 Masele, William, of Tregony, gent 0
3626607 1903174 1903174 defendant Masele Thomas yeoman 596909 596909 Masele, Thomas, of Tregony, yeoman 1
3626608 1903174 1903174 defendant Masele Margery spinster 596909 596909 Masele, Margery, of Tregony, spinster 2
3652042 1910988 1910988 defendant Trenowythe Richard husbandman 596909 596909 Trenowythe, Richard, of Tregony, husbandman 5
3658376 1912868 1912868 defendant (not given) John vicar of Treventh 596909 596909 Treventh, John, of Tregony, vicar of St James the Apostle church 2
3683215 1920869 1920869 defendant Harry Nicholas yeoman 596909 596909 Harry, Nicholas, of Tregony, yeoman 0
3695012 1924650 1924650 defendant Lenne William merchant 596909 596909 Lenne, William, of Tregony, merchant 0
3696257 1925051 1925051 defendant Poule John husbandman 596909 596909 Poule, John, of Tregony, husbandman 0
3722477 1933290 1933290 defendant Lenne William merchant 596909 596909 Lenne, William, of Tregony, merchant 1
3782904 1952396 1952396 defendant William of Maurice husbandman 596909 596909 William, of Maurice, of Tregony, husbandman 2
3819192 1963889 1963889 defendant Cary John yeoman 596909 596909 (Cary, John, of Tregony, yeoman 4
3846245 1972381 1972381 defendant Cary John husbandman 596909 596909 Cary, John, of Tregony, husbandman 0
3846246 1972381 1972381 defendant Tom John husbandman 596909 596909 Tom, John, of Tregony, husbandman 1
3846247 1972381 1972381 defendant Len Richard   596909 596909 Len, Richard, of Tregony, groom 2
4011117 2028747 2028747 defendant Collyns Hugh yeoman 596909 596909 Collyns, Hugh, of Tregony, yeoman 5
4273553 2120709 2120709 defendant Oby Henry   596909 596909 Oby, Henry, of Tregony, mason 0
4310206 2133725 2133725 defendant Mondey Hugh yeoman 596909 596909 Mondey, Hugh, of Tregony, yeoman 2
4441371 2182239 2182239 defendant Cary Thomas   596909 596909 Cary, Thomas, of Tregony 0
4462333 2188917 2188917 plaintiff Symond Martin   596909 596909 Symond, Martin, of Tregony 0
4470587 2191448 2191448 plaintiff Brusy Thomas   596909 596909 Brusy, Thomas, of Tregony 0
4473983 2192514 2192514 defendant Taillour William   596909 596909 Taillour, William, of Tregony 12
4473985 2192514 2192514 defendant Brusya Thomas   596909 596909 Brusya, Thomas, of Tregony 14
4501105 2200950 2200950 defendant Zele Henry   596909 596909 Zele, Henry, of Tregony 3
4502187 2201283 2201283 defendant Bray William   596909 596909 Bray, William, of Tregony 1
4503698 2201726 2201726 defendant Rychard John   596909 596909 Rychard, John, of Tregony 4
4503705 2201727 2201727 defendant Rychard John   596909 596909 Rychard, John, of Tregony 4
4514679 2205009 2205009 defendant Stork John shoemaker 596909 596909 Stork, John, of Tregony, shoemaker 0
4527842 2208982 2208982 defendant Treghar William   596909 596909 Treghar, William, of Tregony 3
4535826 2211481 2211481 defendant Sele Henry   596909 596909 Sele, Henry, of Tregony 1
4544184 2214097 2214097 defendant Dyver John fuller 596909 596909 Dyver, John, of Tregony, fuller 0
4615235 2235775 2235775 defendant Trevarrek Richard   596909 596909 Trevarrek, Richard, of Tregony 0
4623336 2238269 2238269 defendant Glover Peter   596909 596909 Glover, Peter, of Tregony 2
4673373 2257313 2257313 defendant Symon Martin   596909 596909 Symon, Martin, of Tregony, administrators of 1
4673374 2257313 2257313 defendant Richard John husbandman 596909 596909 (Richard, John, of Tregony, husbandman 2
4673376 2257313 2257313 defendant Bodyer William (legal representative) 596909 596909 Bodyer, William, of Tregony, executors of 4
4678689 2258940 2258940 defendant Dyner John toker or fuller 596909 596909 Dyner, John, of Tregony, toker or fuller 1
4678690 2258940 2258940 defendant Sperk John yeoman 596909 596909 Sperk, John, of Tregony, yeoman 2
4678691 2258940 2258940 defendant Howe Richard   596909 596909 Howe, Richard, of Tregony, groom 3
4680400 2259485 2259485 defendant Trelewyth John husbandman 596909 596909 Trelewyth, John, of Tregony, husbandman 0
4680401 2259485 2259485 defendant Spark John yeoman 596909 596909 Spark, John, of Tregony, yeoman 1
4680402 2259485 2259485 defendant Penwerne Thomas yeoman 596909 596909 Penwerne, Thomas, of Tregony, yeoman 2
4680403 2259485 2259485 defendant Toker Thomas toker or fuller of cloth 596909 596909 Toker, Thomas, of Tregony, toker or fuller of cloth 3
4680404 2259485 2259485 defendant Wylcok John laborer 596909 596909 Wylcok, John, of Tregony, laborer 4
4680405 2259485 2259485 defendant Dyver John laborer 596909 596909 Dyver, John, of Tregony, laborer 5
4680406 2259485 2259485 defendant Symon John yeoman 596909 596909 Symon, John, of Tregony, yeoman 6
4680407 2259485 2259485 defendant Hardy John yeoman 596909 596909 Hardy, John, of Tregony, yeoman 7
4682214 2260058 2260058 defendant Carpenter William carpenter 596909 596909 Carpenter, William, of Tregony, carpenter 0
4682217 2260059 2260059 defendant Carpenter William carpenter 596909 596909 Carpenter, William, of Tregony, carpenter 0
4684024 2260611 2260611 defendant Sperk John yeoman 596909 596909 Sperk, John, of Tregony, yeoman 2
4684025 2260611 2260611 defendant Dyver John toker 596909 596909 Dyver, John, of Tregony, toker 3
4684026 2260611 2260611 defendant Toker Thomas toker 596909 596909 Toker, Thomas, of Tregony, toker 4
4684027 2260611 2260611 defendant Trelowyth John husbandman 596909 596909 Trelowyth, John, of Tregony, husbandman 5
4688997 2262116 2262116 defendant Pomeray Thomas   596909 596909 Pomeray, Thomas, of Tregony, knight 0
4688999 2262116 2262116 defendant Toker Thomas toker 596909 596909 Toker, Thomas, of Tregony, toker 2
4689000 2262116 2262116 defendant Spark John yeoman 596909 596909 Spark, John, of Tregony, yeoman 3
4689402 2262243 2262243 defendant Trelewyth John husbandman 596909 596909 Trelewyth, John, of Tregony, husbandman 2
4691049 2262726 2262726 defendant Trelewyth John husbandman 596909 596909 Trelewyth, John, of Tregony, husbandman 0
4691050 2262726 2262726 defendant Spark John yeoman 596909 596909 Spark, John, of Tregony, yeoman 1
4691051 2262726 2262726 defendant Penwerne Thomas yeoman 596909 596909 Penwerne, Thomas, of Tregony, yeoman 2
4691052 2262726 2262726 defendant Toker Thomas toker or fuller of cloth 596909 596909 Toker, Thomas, of Tregony, toker or fuller of cloth 3
4691053 2262726 2262726 defendant Wylcok John laborer 596909 596909 Wylcok, John, of Tregony, laborer 4
4691054 2262726 2262726 defendant Dyver John laborer 596909 596909 Dyver, John, of Tregony, laborer 5
4691055 2262726 2262726 defendant Symon John yeoman 596909 596909 Symon, John, of Tregony, yeoman 6
4691056 2262726 2262726 defendant Hardy John yeoman 596909 596909 Hardy, John, of Tregony, yeoman 7
4696599 2264415 2264415 plaintiff Cay John   596909 596909 Cay, John, of Tregony 0
4696601 2264415 2264415 defendant Piddre Thomas tinner 596909 596909 Piddre, Thomas, of Tregony, tinner 1
4698408 2264979 2264979 defendant Simon Martin   596909 596909 Simon, Martin, of Tregony, administrators of 1
4698409 2264979 2264979 defendant Richard John husbandman 596909 596909 (Richard, John, of Tregony, husbandman 2
4714690 2269923 2269923 defendant Penpyn Thomas   596909 596909 Penpyn, Thomas, of Tregony, shoe maker 1
4726691 2273618 2273618 defendant Trovarrek Richard gent 596909 596909 Trovarrek, Richard, of Tregony, gent 0
4731041 2274913 2274913 plaintiff Cay John   596909 596909 Cay, John, of Tregony 1
4731042 2274913 2274913 defendant Trevarrek Richard gent 596909 596909 Trevarrek, Richard, of Tregony, gent 0
4731043 2274913 2274913 defendant Skyburyowe John yeoman 596909 596909 Skyburyowe, John, of Tregony, yeoman 1
4737107 2276726 2276726 defendant Trelewych John gent 596909 596909 Trelewych, John, of Tregony, gent 3
4745281 2279130 2279130 defendant Bonny Nicholas shoemaker 596909 596909 Bonny, Nicholas, of Tregony, shoemaker 3
4747129 2279667 2279667 defendant Penwern Thomas   596909 596909 Penwern, Thomas, of Tregony 0
4747194 2279682 2279682 defendant Penwern Thomas husbandman 596909 596909 Penwern, Thomas, of Tregony, husbandman 0
4769907 2286559 2286559 defendant Trelowyth John gent 596909 596909 Trelowyth, John, of Tregony, gent 0
4769909 2286560 2286560 defendant Trelowyth John gent 596909 596909 Trelowyth, John, of Tregony, gent 0
4774029 2287861 2287861 defendant Penalwell Nicholas   596909 596909 Penalwell, Nicholas, of Tregony, shoe maker 1
4776711 2288707 2288707 defendant Froden John gent 596909 596909 Froden, John, of Tregony, gent 0
4783686 2290919 2290919 defendant Trelowyth John gent 596909 596909 Trelowyth, John, of Tregony, gent 0
4783688 2290920 2290920 defendant Trelowyth John gent 596909 596909 Trelowyth, John, of Tregony, gent 0
4794464 2294405 2294405 defendant Trelowyth John gent 596909 596909 Trelowyth, John, of Tregony, gent 0
4816806 2301358 2301358 defendant Dyer Pastus dyer 596909 596909 Dyer, Pastus, of Tregony, dyer 0
4836938 2307510 2307510 defendant Tredyny Richard yeoman 596909 596909 Tredyny, Richard, of Tregony, yeoman 2
4836939 2307510 2307510 defendant Denny Nicholas   596909 596909 Denny, Nicholas, of Tregony, shoe maker 3
4860681 2314702 2314702 defendant Cristowe Baldwin husbandman 596909 596909 Cristowe, Baldwin, of Tregony, husbandman 0
4882059 2321285 2321285 defendant Tregellest Henry husbandman 596909 596909 Tregellest, Henry, of Tregony, husbandman 5
4909910 2329621 2329621 defendant Trevarrek Richard gent 596909 596909 Trevarrek, Richard, of Tregony, gent 0
4935458 2337484 2337484 defendant Trenarrek Richard gent 596909 596909 Trenarrek, Richard, of Tregony, gent 0
4938088 2338291 2338291 plaintiff Cay John   596909 596909 Cay, John, of Tregony 0
4939518 2338746 2338746 defendant Helston John yeoman 596909 596909 Helston, John, of Tregony, yeoman 0
4963747 2346069 2346069 plaintiff Cay John   596909 596909 Cay, John, of Tregony 0
4982635 2351719 2351719 defendant Froden John (legal representative) 596909 596909 Froden, John, of Tregony, gent, executors of 0
4982637 2351719 2351719 defendant Froden Joan widow 596909 596909 Froden, Joan, of Tregony, widow 2
5006619 2358835 2358835 defendant Mathewe John husbandman 596909 596909 Mathewe, John, of Tregony, husbandman 0
5009414 2359637 2359637 defendant Trelowyth William   596909 596909 Trelowyth, William, of Tregony, franklin 0
5019573 2362610 2362610 defendant Jakkay Roger mercer 596909 596909 Jakkay, Roger, of Tregony, mercer 0
5019574 2362610 2362610 defendant Penwaryn Thomas gent 596909 596909 Penwaryn, Thomas, of Tregony, gent 1

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);