names

176 rows where place_id = 587395

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591287 1864900 1864900 defendant Laurens William laborer 587395 587395 Laurens, William, of Tavystoke, laborer 0
3591917 1865085 1865085 defendant Webbe Alice widow 587395 587395 Webbe, Alice, of Tavystoke, widow 0
3599376 1867448 1867448 defendant Callard Richard smith 587395 587395 Callard, Richard, of Tavystoke, smith 0
3606161 1869596 1869596 defendant Brune Robert spurrier 587395 587395 Brune, Robert, of Tavystoke, spurrier 0
3608585 1870344 1870344 defendant Medewell Michael husbandman 587395 587395 Medewell, Michael, of Tavystoke, husbandman 0
3621591 1874292 1874292 defendant Combe John husbandman 587395 587395 Combe, John, of Tavystoke, groom, son of Combe, William, of Tavystoke, husbandman 3
3655575 1912006 1912006 defendant Lechemore Thomas   587395 587395 Lechemore, Thomas, of Tavystoke, parchement maker 0
3711135 1929797 1929797 plaintiff Stowforde Thomas merchant 587395 587395 Stowforde, Thomas, of Tavystoke, merchant 0
3714285 1930767 1930767 defendant Boys Joan widow 587395 587395 Boys, Joan, of Tavystoke, widow 0
3724836 1934053 1934053 defendant Gardener John yeoman 587395 587395 Gardener, John, of Tavystoke, yeoman 0
3724894 1934072 1934072 defendant Mayowe Richard merchant 587395 587395 (Mayowe, Richard, of Tavystoke, merchant 1
3736373 1937618 1937618 defendant Cole Walter butcher 587395 587395 Cole, Walter, of Tavystoke, butcher 1
3737736 1938024 1938024 defendant Sergeaunt John clerk 587395 587395 Sergeaunt, John, of Tavystoke, clerk 0
3737737 1938024 1938024 defendant Master John shoemaker 587395 587395 Master, John, of Tavystoke, shoemaker 1
3739381 1938524 1938524 defendant Croppe Thomas fletcher 587395 587395 Croppe, Thomas, of Tavystoke, fletcher 0
3739574 1938588 1938588 defendant Croppe Thomas fletcher 587395 587395 Croppe, Thomas, of Tavystoke, fletcher 0
3743063 1939679 1939679 defendant Pyke John butcher 587395 587395 Pyke, John, of Tavystoke, butcher 0
3751795 1942482 1942482 defendant Gurtotte John husbandman 587395 587395 Gurtotte, John, of Tavystoke, husbandman 0
3751957 1942528 1942528 defendant Combe alias Medwell Edward dyer 587395 587395 Combe alias Medwell, Edward, of Tavystoke, dyer 1
3789619 1954584 1954584 defendant Amydes John yeoman 587395 587395 Amydes, John, of Tavystoke, yeoman 0
3865060 1978516 1978516 plaintiff Mayow Richard merchant 587395 587395 Mayow, Richard, of Tavystoke, merchant 0
3875839 1982173 1982173 defendant Vynton Robert husbandman 587395 587395 Vynton, Robert, of Tavystoke, husbandman 0
3920318 1997137 1997137 plaintiff Mayowe Richard (legal representative) 587395 587395 Mayowe, Richard, of Tavystoke, merchant, executors of 0
3920552 1997222 1997222 defendant Toker Nicholas   587395 587395 Toker, Nicholas, of Tavystoke, franklin 0
3920553 1997222 1997222 defendant Peter John   587395 587395 Peter, John, of Tavystoke, groom 1
3920554 1997222 1997222 defendant Drake John, junior cordwainer 587395 587395 Drake, John, junior, of Tavystoke, cordwainer 2
3921788 1997633 1997633 defendant Frankelyn John butcher 587395 587395 Frankelyn, John, of Tavystoke, butcher 0
3942824 2004603 2004603 plaintiff Wyllyams Richarda widow 587395 587395 Wyllyams, Richarda, of Tavystoke, widow 0
3942825 2004603 2004603 plaintiff Grylles William merchant 587395 587395 Grylles, William, of Tavystoke, merchant 1
3958001 2009862 2009862 defendant Bonde William husbandman 587395 587395 Bonde, William, of Tavystoke, husbandman 0
4058275 2045344 2045344 plaintiff Cervyngton John (legal representative) 587395 587395 Cervyngton, John, of Tavystoke, gent, administrator of 0
4083874 2054505 2054505 defendant Ellyott John vintner 587395 587395 Ellyott, John, of Tavystoke, vintner 2
4088635 2056235 2056235 defendant Gyll John (legal representative) 587395 587395 Gyll, John, of Tavystoke, executors of 0
4424438 2172483 2172483 defendant Stacy William   587395 587395 Stacy, William, of Tavystoke 0
4434230 2175466 2175466 defendant Stacy William   587395 587395 Stacy, William, of Tavystoke 0
4514804 2205050 2205050 defendant Hogekyn John butcher 587395 587395 Hogekyn, John, of Tavystoke, butcher 0
4540249 2212852 2212852 plaintiff Webber William   587395 587395 Webber, William, of Tavystoke 0
4581703 2225726 2225726 defendant Tayl William   587395 587395 Tayl, William, of Tavystoke 0
4658320 2248486 2248486 defendant Trote Nicholas clerk 587395 587395 Trote, Nicholas, of Tavystoke, clerk 0
4666752 2255330 2255330 defendant Pyper Richard butcher 587395 587395 Pyper, Richard, of Tavystoke, butcher 0
4676648 2258314 2258314 defendant Cotell Stephen tanner 587395 587395 Cotell, Stephen, of Tavystoke, tanner 0
4725918 2273392 2273392 defendant Wilshe John hooper 587395 587395 Wilshe, John, of Tavystoke, hooper 2
4726451 2273554 2273554 defendant Northende Thomas chapman 587395 587395 Northende, Thomas, of Tavystoke, chapman 2
4727192 2273766 2273766 defendant Northende Thomas chapman 587395 587395 Northende, Thomas, of Tavystoke, chapman 1
4746925 2279601 2279601 defendant Julkyn John gent 587395 587395 Julkyn, John, of Tavystoke, gent 0
4746929 2279603 2279603 defendant Julkyn John gent 587395 587395 Julkyn, John, of Tavystoke, gent 0
4752479 2281186 2281186 defendant Mey John tanner 587395 587395 Mey, John, of Tavystoke, tanner 0
4779129 2289447 2289447 defendant Bodyer William   587395 587395 Bodyer, William, of Tavystoke, bailiff 4
4797520 2295397 2295397 defendant Gerard Richard draper 587395 587395 Gerard, Richard, of Tavystoke, draper 0
4881161 2321016 2321016 defendant Raddon John baker 587395 587395 Raddon, John, of Tavystoke, baker 0
4954719 2343365 2343365 defendant Stacy John glover 587395 587395 Stacy, John, of Tavystoke, glover 3
4963009 2345846 2345846 defendant Chamberleyn John   587395 587395 Chamberleyn, John, of Tavystoke, bailiff 8
4974006 2349188 2349188 defendant Fyven John skinner 587395 587395 Fyven, John, of Tavystoke, skinner 1
4974007 2349188 2349188 defendant Snowedon John skinner 587395 587395 Snowedon, John, of Tavystoke, skinner 2
4979026 2350685 2350685 defendant Forster John baker 587395 587395 Forster, John, of Tavystoke, baker 0
4985209 2352508 2352508 defendant Chamberleyn John   587395 587395 Chamberleyn, John, of Tavystoke, bailiff 1
4990929 2354176 2354176 defendant Bruyn John fuller 587395 587395 Bruyn, John, of Tavystoke, fuller 2
5000873 2357130 2357130 defendant Avener John mercer 587395 587395 Avener, John, of Tavystoke, mercer 0
5000874 2357130 2357130 defendant Aunfrey John husbandman 587395 587395 Aunfrey, John, of Tavystoke, husbandman 1
5015724 2361483 2361483 defendant Mason John mercer 587395 587395 Mason, John, of Tavystoke, mercer 1
5041550 2369074 2369074 defendant Fitz John gent 587395 587395 Fitz, John, of Tavystoke, gent 0
5047025 2370732 2370732 defendant Dusty Thomas plumber 587395 587395 Dusty, Thomas, of Tavystoke, plumber 0
5047027 2370733 2370733 defendant Dusty Thomas plumber 587395 587395 Dusty, Thomas, of Tavystoke, plumber 0
5047766 2370948 2370948 plaintiff Pewe William   587395 587395 Pewe, William, of Tavystoke, abbot of the church of the BM & St Rumon 0
5047767 2370948 2370948 defendant Assheford William merchant 587395 587395 Assheford, William, of Tavystoke, merchant 0
5047768 2370948 2370948 defendant Mersshwill William husbandman 587395 587395 Mersshwill, William, of Tavystoke, husbandman 1
5047770 2370948 2370948 defendant Snowedon John husbandman 587395 587395 Snowedon, John, of Tavystoke, husbandman 3
5050223 2371687 2371687 defendant Ayssheford William merchant 587395 587395 Ayssheford, William, of Tavystoke, merchant 0
5050224 2371687 2371687 defendant Mersshwill William husbandman 587395 587395 Mersshwill, William, of Tavystoke, husbandman 1
5050226 2371687 2371687 defendant Snowedon John husbandman 587395 587395 Snowedon, John, of Tavystoke, husbandman 3
5052961 2372477 2372477 defendant Fresshepond William merchant 587395 587395 Fresshepond, William, of Tavystoke, merchant 0
5054487 2372918 2372918 defendant Vespount William merchant 587395 587395 Vespount, William, of Tavystoke, merchant 0
5060078 2374580 2374580 defendant Swetyng John merchant 587395 587395 Swetyng, John, of Tavystoke, merchant 0
5063426 2375586 2375586 defendant Assheford William mercer 587395 587395 Assheford, William, of Tavystoke, mercer 0
5071169 2377871 2377871 defendant Kyngeston William yeoman 587395 587395 Kyngeston, William, of Tavystoke, yeoman 0
5071171 2377872 2377872 defendant Kyngeston William yeoman 587395 587395 Kyngeston, William, of Tavystoke, yeoman 0
5072483 2378255 2378255 defendant Caddele John husbandman 587395 587395 Caddele, John, of Tavystoke, husbandman 0
5080633 2380695 2380695 defendant Helyere alias Plummer William plumber 587395 587395 Helyere alias Plummer, William, of Tavystoke, plumber 0
5087412 2382696 2382696 defendant Whityng William   587395 587395 Whityng, William, of Tavystoke, bailiff 12
5088750 2383086 2383086 plaintiff Langebroke Richard (legal representative) 587395 587395 Langebroke, Richard, of Tavystoke, tucker, executors of 0
5090833 2383708 2383708 defendant Eston John chaplain 587395 587395 Eston, John, of Tavystoke, chaplain 0
5090836 2383709 2383709 defendant Eston John chaplain 587395 587395 Eston, John, of Tavystoke, chaplain 0
5090839 2383710 2383710 defendant Eston John chaplain 587395 587395 Eston, John, of Tavystoke, chaplain 0
5098447 2385975 2385975 defendant Northcote Richard husbandman 587395 587395 Northcote, Richard, of Tavystoke, husbandman 0
5105499 2388054 2388054 defendant Fitz John gent 587395 587395 Fitz, John, of Tavystoke, gent 0
5105899 2388167 2388167 defendant Ayssheforth William yeoman 587395 587395 Ayssheforth, William, of Tavystoke, yeoman 0
5105900 2388167 2388167 defendant Drake Thomas yeoman 587395 587395 Drake, Thomas, of Tavystoke, yeoman 1
5105901 2388167 2388167 defendant Hill Richard yeoman 587395 587395 Hill, Richard, of Tavystoke, yeoman 2
5122625 2393050 2393050 defendant Helyer William yeoman 587395 587395 Helyer, William, of Tavystoke, yeoman 0
5123924 2393450 2393450 defendant Julkyn Joan widow 587395 587395 Julkyn, Joan, of Tavystoke, widow 4
5123932 2393451 2393451 defendant Julkyn Joan widow 587395 587395 Julkyn, Joan, of Tavystoke, widow 4
5130623 2395446 2395446 defendant Frespound William   587395 587395 Frespound, William, of Tavystoke 0
5134909 2396714 2396714 defendant Wynter John husbandman 587395 587395 Wynter, John, of Tavystoke, husbandman 0
5134914 2396715 2396715 defendant Wynter John husbandman 587395 587395 Wynter, John, of Tavystoke, husbandman 0
5142645 2398978 2398978 defendant Honychurch John gent 587395 587395 (Honychurch, John, of Tavystoke, gent 1
5142646 2398978 2398978 defendant Julkyn Richard gent 587395 587395 Julkyn, Richard, of Tavystoke, gent 2
5150057 2401152 2401152 defendant Freyspound William merchant 587395 587395 Freyspound, William, of Tavystoke, merchant 0
5154978 2402611 2402611 defendant Wynter John husbandman 587395 587395 Wynter, John, of Tavystoke, husbandman 0
5163095 2404933 2404933 defendant Humfray Walter fuller 587395 587395 Humfray, Walter, of Tavystoke, fuller 0
5172282 2407617 2407617 plaintiff Mey John tanner 587395 587395 Mey, John, of Tavystoke, 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);