names

146 rows where place_id = 603088

✎ 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
3647775 1909697 1909697 plaintiff Mark William (legal representative) 603088 603088 Mark, William, of Leskerd, executrix of 0
3647781 1909699 1909699 plaintiff Marke William (legal representative) 603088 603088 Marke, William, of Leskerd, executrix of 0
3653025 1911276 1911276 defendant Genys John carpenter 603088 603088 Genys, John, of Leskerd, carpenter 0
3653026 1911276 1911276 defendant Chapman Thomas weaver 603088 603088 Chapman, Thomas, of Leskerd, weaver 1
3655073 1911848 1911848 plaintiff Bere William   603088 603088 Bere, William, of Leskerd 0
3657159 1912504 1912504 defendant Marke Alice widow 603088 603088 (Marke, Alice, of Leskerd, widow 1
3662096 1914067 1914067 plaintiff Marke William (legal representative) 603088 603088 Marke, William, of Leskerd, executrix of 0
3686064 1921801 1921801 defendant Croke Robert yeoman 603088 603088 Croke, Robert, of Leskerd, yeoman 0
3696260 1925051 1925051 defendant Marle William yeoman 603088 603088 Marle, William, of Leskerd, yeoman 3
3703210 1927275 1927275 defendant Tregasowe John esq 603088 603088 Tregasowe, John, of Leskerd, esq 0
3705612 1928036 1928036 defendant Pykkyn Thomas yeoman 603088 603088 Pykkyn, Thomas, of Leskerd, yeoman 0
3707630 1928684 1928684 plaintiff Marke William (legal representative) 603088 603088 Marke, William, of Leskerd, executrix of 0
3719628 1932406 1932406 defendant Coryton Peter esq 603088 603088 Coryton, Peter, of Leskerd, esq 1
3728400 1935128 1935128 defendant Rogger John glover 603088 603088 Rogger, John, of Leskerd, glover 0
3729682 1935534 1935534 defendant Webbe John laborer 603088 603088 Webbe, John, of Leskerd, laborer 3
3740439 1938867 1938867 defendant Hunte John, senior tanner 603088 603088 Hunte, John, senior, of Leskerd, tanner 0
3740440 1938867 1938867 defendant Hunte John, junior glover 603088 603088 Hunte, John, junior, of Leskerd, glover 1
3744450 1940167 1940167 defendant Rympe John tanner 603088 603088 Rympe, John, of Leskerd, tanner 0
3744451 1940167 1940167 defendant Wilcok Richard glover 603088 603088 Wilcok, Richard, of Leskerd, glover 1
3757171 1944225 1944225 defendant Kympe John tanner 603088 603088 Kympe, John, of Leskerd, tanner 0
3757172 1944225 1944225 defendant Wilcoke Richard glover 603088 603088 Wilcoke, Richard, of Leskerd, glover 1
3770619 1948495 1948495 defendant Marke William yeoman 603088 603088 Marke, William, of Leskerd, yeoman 0
3821323 1964561 1964561 defendant Hunt John husbandman 603088 603088 Hunt, John, of Leskerd, husbandman 0
3821324 1964561 1964561 defendant Pyckyn John husbandman 603088 603088 Pyckyn, John, of Leskerd, husbandman 1
3848768 1973199 1973199 defendant Bere William gent 603088 603088 Bere, William, of Leskerd, gent 0
3849343 1973392 1973392 defendant Bere William gent 603088 603088 Bere, William, of Leskerd, gent 0
3865112 1978535 1978535 defendant Bere William gent 603088 603088 Bere, William, of Leskerd, gent 0
3872098 1980899 1980899 plaintiff Bealbery John, junior   603088 603088 Bealbery, John, junior, of Leskerd 0
3879185 1983291 1983291 defendant Bere William gent 603088 603088 Bere, William, of Leskerd, gent 0
3885448 1985388 1985388 plaintiff Bealbury John, senior merchant 603088 603088 Bealbury, John, senior, of Leskerd, merchant 0
3891996 1987574 1987574 plaintiff Madyk John   603088 603088 Madyk, John, of Leskerd 0
3913335 1994794 1994794 plaintiff Bealbury John   603088 603088 Bealbury, John, of Leskerd, senior 0
3914151 1995079 1995079 defendant Croke Robert yeoman 603088 603088 Croke, Robert, of Leskerd, yeoman 3
3914661 1995247 1995247 defendant Hooper John husbandman 603088 603088 Hooper, John, of Leskerd, husbandman 0
3915043 1995387 1995387 defendant Phelyp Thomas husbandman 603088 603088 Phelyp, Thomas, of Leskerd, husbandman 0
3919154 1996731 1996731 defendant Walsche Robert husbandman 603088 603088 Walsche, Robert, of Leskerd, husbandman 0
3922263 1997758 1997758 defendant Welche Robert husbandman 603088 603088 Welche, Robert, of Leskerd, husbandman 0
3924462 1998494 1998494 defendant Bealbury John, senior merchant 603088 603088 Bealbury, John, senior, of Leskerd, merchant 4
3969210 2013840 2013840 defendant Grosse William gent 603088 603088 Grosse, William, of Leskerd, gent 0
3969922 2014080 2014080 defendant Tregarthen Hugh weaver 603088 603088 Tregarthen, Hugh, of Leskerd, weaver 0
3969923 2014080 2014080 defendant Longdon Robert gent 603088 603088 Longdon, Robert, of Leskerd, gent 1
3979536 2017439 2017439 plaintiff Nottell Thomas   603088 603088 Nottell, Thomas, of Leskerd 0
4049672 2042322 2042322 defendant Gattyscomb Edward husbandman 603088 603088 Gattyscomb, Edward, of Leskerd, husbandman 0
4049673 2042322 2042322 defendant Kempe William tailor 603088 603088 Kempe, William, of Leskerd, tailor 1
4049674 2042322 2042322 defendant Warman Walter miller 603088 603088 Warman, Walter, of Leskerd, miller 2
4139371 2074444 2074444 defendant Pett John, senior yeoman 603088 603088 Pett, John, senior, of Leskerd, yeoman 2
4513702 2204712 2204712 defendant fouke John   603088 603088 fouke, John, of Leskerd 0
4533850 2210856 2210856 defendant Bythewater William   603088 603088 Bythewater, William, of Leskerd 0
4736975 2276693 2276693 defendant Polmargh John   603088 603088 Polmargh, John, of Leskerd, mason 0
4804057 2297453 2297453 defendant Helyer Alan tanner 603088 603088 Helyer, Alan, of Leskerd, tanner 0
4842008 2309039 2309039 defendant Helier John tailor 603088 603088 Helier, John, of Leskerd, tailor 2
4851135 2311807 2311807 defendant Webbe John cleuter or nail maker 603088 603088 Webbe, John, of Leskerd, cleuter or nail maker 0
4851172 2311817 2311817 defendant Webbe John   603088 603088 Webbe, John, of Leskerd, nail maker 0
4851183 2311819 2311819 defendant Webbe John   603088 603088 Webbe, John, of Leskerd, nail maker 0
4855875 2313211 2313211 defendant Pyken Roger tanner 603088 603088 Pyken, Roger, of Leskerd, tanner 0
4890088 2323677 2323677 defendant Priour John laborer 603088 603088 Priour, John, of Leskerd, laborer 3
4906600 2328649 2328649 defendant Joche John tanner 603088 603088 Joche, John, of Leskerd, tanner 0
4949415 2341806 2341806 defendant Achym William tanner 603088 603088 Achym, William, of Leskerd, tanner 0
4950834 2342232 2342232 defendant Graunt Simon smith 603088 603088 Graunt, Simon, of Leskerd, smith 1
4950835 2342232 2342232 defendant Mory Vincent smith 603088 603088 Mory, Vincent, of Leskerd, smith 2
4950836 2342232 2342232 defendant Parker Walter yeoman 603088 603088 Parker, Walter, of Leskerd, yeoman 3
4950837 2342232 2342232 defendant More Richard tanner 603088 603088 More, Richard, of Leskerd, tanner 4
4950840 2342233 2342233 defendant Graunt Simon smith 603088 603088 Graunt, Simon, of Leskerd, smith 1
4950841 2342233 2342233 defendant Mory Vincent smith 603088 603088 Mory, Vincent, of Leskerd, smith 2
4950842 2342233 2342233 defendant Parker Walter yeoman 603088 603088 Parker, Walter, of Leskerd, yeoman 3
4950843 2342233 2342233 defendant More Richard tanner 603088 603088 More, Richard, of Leskerd, tanner 4
4959296 2344745 2344745 defendant Cosyn John, junior smith 603088 603088 Cosyn, John, junior, of Leskerd, smith 1
4959297 2344745 2344745 defendant Perkyn William husbandman 603088 603088 Perkyn, William, of Leskerd, husbandman 2
4961408 2345383 2345383 defendant Vage Richard gent 603088 603088 Vage, Richard, of Leskerd, gent 0
4963219 2345907 2345907 defendant Pyken John tanner 603088 603088 Pyken, John, of Leskerd, tanner 0
4963220 2345907 2345907 defendant Helyer Alan tanner 603088 603088 Helyer, Alan, of Leskerd, tanner 1
4963221 2345907 2345907 defendant Berball John tanner 603088 603088 Berball, John, of Leskerd, tanner 2
4964471 2346282 2346282 defendant Vage Richard merchant 603088 603088 Vage, Richard, of Leskerd, merchant 13
4964473 2346282 2346282 defendant Hicke John mercer 603088 603088 Hicke, John, of Leskerd, mercer 15
4972560 2348724 2348724 defendant Necoll Walter laborer 603088 603088 Necoll, Walter, of Leskerd, laborer 2
4974751 2349417 2349417 defendant Fursdon John tanner 603088 603088 Fursdon, John, of Leskerd, tanner 0
4987879 2353342 2353342 defendant Vage Richard merchant 603088 603088 Vage, Richard, of Leskerd, merchant 0
4991812 2354435 2354435 defendant Colys John cutler 603088 603088 Colys, John, of Leskerd, cutler 1
4998882 2356550 2356550 plaintiff Kyng John (legal representative) 603088 603088 Kyng, John, of Leskerd, formerly vicar, executor of 0
5003359 2357881 2357881 plaintiff Parker Walter yeoman 603088 603088 Parker, Walter, of Leskerd, yeoman 0
5008590 2359405 2359405 defendant Hikke John shoemaker 603088 603088 Hikke, John, of Leskerd, shoemaker 3
5037971 2367988 2367988 defendant Frenship Peter parker 603088 603088 Frenship, Peter, of Leskerd, parker 0
5038597 2368188 2368188 defendant Pykyn John cobbler 603088 603088 Pykyn, John, of Leskerd, cobbler 2
5039627 2368499 2368499 defendant Pyken John draper 603088 603088 Pyken, John, of Leskerd, draper 0
5039628 2368499 2368499 defendant Symon William smith 603088 603088 Symon, William, of Leskerd, smith 1
5045394 2370252 2370252 defendant William Thomas   603088 603088 William, Thomas, of Leskerd, shoe maker 0
5061682 2375086 2375086 defendant Kempe Nicholas cutler 603088 603088 Kempe, Nicholas, of Leskerd, cutler 0
5068998 2377222 2377222 defendant Colys John cutler 603088 603088 Colys, John, of Leskerd, cutler 0
5086595 2382470 2382470 defendant Croft John laborer 603088 603088 Croft, John, of Leskerd, laborer 0
5088928 2383138 2383138 defendant Ware Simon cordwainter 603088 603088 Ware, Simon, of Leskerd, cordwainter 0
5096536 2385419 2385419 defendant Achyn William cordwainer 603088 603088 Achyn, William, of Leskerd, cordwainer 5
5128821 2394914 2394914 defendant Croft William tanner 603088 603088 Croft, William, of Leskerd, tanner 0
5128822 2394914 2394914 defendant Cok Thomas tanner 603088 603088 Cok, Thomas, of Leskerd, tanner 1
5133852 2396395 2396395 defendant Wyot William barber 603088 603088 Wyot, William, of Leskerd, barber 2
5133932 2396422 2396422 defendant Stevyn Richard fysshionter 603088 603088 Stevyn, Richard, of Leskerd, fysshionter 0
5140927 2398464 2398464 defendant Steven Nicholas gent 603088 603088 Steven, Nicholas, of Leskerd, gent 4
5153852 2402281 2402281 defendant Stevyn Richard   603088 603088 Stevyn, Richard, of Leskerd, fish jouter 0
5153854 2402282 2402282 defendant Stevyn Richard   603088 603088 Stevyn, Richard, of Leskerd, fish jouter 0
5154226 2402393 2402393 defendant Mory Thomas shoemaker 603088 603088 Mory, Thomas, of Leskerd, shoemaker 1
5171101 2407270 2407270 defendant Stevyn Richard   603088 603088 Stevyn, Richard, of Leskerd, fish jouter 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);