names

134 rows where place_id = 589661

✎ 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
3598343 1867111 1867111 defendant Andrewe William husbandman 589661 589661 Andrewe, William, of Modbury, husbandman 0
3601466 1868113 1868113 plaintiff Baker John   589661 589661 Baker, John, of Modbury 0
3630772 1904449 1904449 defendant Baker John husbandman 589661 589661 Baker, John, of Modbury, husbandman 2
3658152 1912805 1912805 defendant Dyver John yeoman 589661 589661 Dyver, John, of Modbury, yeoman 1
3666656 1915517 1915517 plaintiff Wakeham John, junior   589661 589661 Wakeham, John, junior, of Modbury 0
3689047 1922736 1922736 defendant Toley John   589661 589661 Toley, John, of Modbury, mason 0
3690331 1923138 1923138 defendant Champernon Philip esq 589661 589661 Champernon, Philip, of Modbury, esq 0
3692100 1923697 1923697 defendant Hyll Thomas shoemaker 589661 589661 Hyll, Thomas, of Modbury, shoemaker 0
3704776 1927784 1927784 defendant Champernon Philip esq 589661 589661 Champernon, Philip, of Modbury, esq 1
3714201 1930740 1930740 defendant Hullond Robert husbandman 589661 589661 Hullond, Robert, of Modbury, husbandman 1
3732643 1936441 1936441 defendant Morys John husbandman 589661 589661 Morys, John, of Modbury, husbandman 0
3737742 1938025 1938025 defendant Cole John carver 589661 589661 Cole, John, of Modbury, carver 3
3751091 1942269 1942269 defendant Trebyll William miller 589661 589661 Trebyll, William, of Modbury, miller 1
3789539 1954554 1954554 defendant Rous Roger yeoman 589661 589661 Rous, Roger, of Modbury, yeoman 0
3805191 1959568 1959568 defendant Frynde Andrew yeoman 589661 589661 Frynde, Andrew, of Modbury, yeoman 0
3821561 1964639 1964639 defendant Frynde Andrew yeoman 589661 589661 Frynde, Andrew, of Modbury, yeoman 0
3872514 1981032 1981032 defendant Barnacote William smith 589661 589661 Barnacote, William, of Modbury, smith 1
3877278 1982644 1982644 defendant Wakeham John tinner 589661 589661 Wakeham, John, of Modbury, tinner 0
3877279 1982644 1982644 defendant Dower Christopher tinner 589661 589661 Dower, Christopher, of Modbury, tinner 1
3877280 1982644 1982644 defendant Weryng John tinner 589661 589661 Weryng, John, of Modbury, tinner 2
3877281 1982644 1982644 defendant Hull Edmund tinner 589661 589661 Hull, Edmund, of Modbury, tinner 3
3877282 1982644 1982644 defendant Wyllyng Walter tinner 589661 589661 Wyllyng, Walter, of Modbury, tinner 4
3877283 1982644 1982644 defendant Wynston Elias tinner 589661 589661 Wynston, Elias, of Modbury, tinner 5
3877284 1982644 1982644 defendant Crokker Hugh tinner 589661 589661 Crokker, Hugh, of Modbury, tinner 6
3896716 1989111 1989111 defendant Hastyng alias Yabbecombe John pannier maker 589661 589661 Hastyng alias Yabbecombe, John, of Modbury, pannier maker 0
3904529 1991763 1991763 defendant Frende Robert weaver 589661 589661 Frende, Robert, of Modbury, weaver 0
3904850 1991886 1991886 defendant Champernon Philip   589661 589661 Champernon, Philip, of Modbury, knight 0
3904853 1991887 1991887 defendant Champernon Philip   589661 589661 Champernon, Philip, of Modbury, knight 0
3951994 2007760 2007760 defendant Wynston Henry husbandman 589661 589661 Wynston, Henry, of Modbury, husbandman 0
3968300 2013542 2013542 defendant Ward alias Waye John husbandman 589661 589661 Ward alias Waye, John, of Modbury, husbandman 0
3985777 2019676 2019676 defendant Huytt John husbandman 589661 589661 Huytt, John, of Modbury, husbandman 0
3985778 2019676 2019676 defendant Wylls John husbandman 589661 589661 Wylls, John, of Modbury, husbandman 1
3985779 2019676 2019676 defendant Stydston George husbandman 589661 589661 Stydston, George, of Modbury, husbandman 2
3988881 2020768 2020768 defendant Predyaux Philip gent 589661 589661 Predyaux, Philip, of Modbury, or of Holbeton, Devon, gent 0
3988882 2020768 2020768 defendant Moershade Thomas husbandman 589661 589661 Moershade, Thomas, of Modbury, husbandman 1
3988886 2020769 2020769 defendant Harte Richard husbandman 589661 589661 Harte, Richard, of Modbury, husbandman 1
3988890 2020770 2020770 defendant Moershade Thomas husbandman 589661 589661 Moershade, Thomas, of Modbury, husbandman 1
3988894 2020771 2020771 defendant Moershade Thomas husbandman 589661 589661 Moershade, Thomas, of Modbury, husbandman 1
4002970 2025829 2025829 defendant Facy Richard husbandman 589661 589661 Facy, Richard, of Modbury, husbandman 0
4012947 2029362 2029362 defendant Champernon Katherine widow 589661 589661 Champernon, Katherine, of Modbury, widow 0
4012948 2029362 2029362 defendant Chollons Nicholas gent 589661 589661 Chollons, Nicholas, of Modbury, gent 1
4012949 2029362 2029362 defendant Riche Hugh yeoman 589661 589661 Riche, Hugh, of Modbury, yeoman 2
4012950 2029362 2029362 defendant Hephurde Thomas husbandman 589661 589661 Hephurde, Thomas, of Modbury, husbandman 3
4023612 2033154 2033154 defendant Boyes Ricard tailor 589661 589661 Boyes, Ricard, of Modbury, tailor 1
4023616 2033155 2033155 defendant Boyes Richard tailor 589661 589661 Boyes, Richard, of Modbury, tailor 1
4436529 2176162 2176162 plaintiff Speke Guy   589661 589661 Speke, Guy, of Modbury 0
4447992 2184294 2184294 defendant Taillour Lawrence   589661 589661 Taillour, Lawrence, of Modbury 2
4557217 2218191 2218191 defendant Averay William   589661 589661 Averay, William, of Modbury 1
4597333 2230406 2230406 defendant Goldsmyth Thomas   589661 589661 Goldsmyth, Thomas, of Modbury 0
4601208 2231611 2231611 defendant Roger John   589661 589661 Roger, John, of Modbury, prior 0
4667870 2255650 2255650 defendant Herte William husbandman 589661 589661 Herte, William, of Modbury, husbandman 1
4667872 2255650 2255650 defendant Herte John husbandman 589661 589661 Herte, John, of Modbury, husbandman 3
4683320 2260387 2260387 defendant Prus Henry gent 589661 589661 Prus, Henry, of Modbury, gent 0
4683672 2260494 2260494 defendant Drewe Henry gent 589661 589661 Drewe, Henry, of Modbury, gent 0
4715305 2270120 2270120 defendant Bacheler Nicholas   589661 589661 Bacheler, Nicholas, of Modbury, glove maker 0
4715308 2270121 2270121 defendant Bacheler Nicholas   589661 589661 Bacheler, Nicholas, of Modbury, glove maker 0
4722872 2272469 2272469 defendant Hayman John shoemaker 589661 589661 Hayman, John, of Modbury, shoemaker 0
4722873 2272469 2272469 defendant Shepherd John shoemaker 589661 589661 Shepherd, John, of Modbury, shoemaker 1
4722874 2272469 2272469 defendant Marshall John chapman 589661 589661 Marshall, John, of Modbury, chapman 2
4722875 2272469 2272469 defendant Lede Walter tailor 589661 589661 Lede, Walter, of Modbury, tailor 3
4728091 2274034 2274034 defendant Kylyowe Walter glover 589661 589661 Kylyowe, Walter, of Modbury, glover 1
4728092 2274034 2274034 defendant Rethe Thomas glover 589661 589661 Rethe, Thomas, of Modbury, glover 2
4733141 2275542 2275542 defendant Assherigge Walter chaplain 589661 589661 Assherigge, Walter, of Modbury, chaplain 0
4733349 2275607 2275607 defendant Cole John yeoman 589661 589661 Cole, John, of Modbury, yeoman 0
4734124 2275856 2275856 defendant Lede Walter husbandman 589661 589661 Lede, Walter, of Modbury, husbandman 2
4735795 2276343 2276343 defendant Cutfyn Richard shoemaker 589661 589661 Cutfyn, Richard, of Modbury, shoemaker 1
4749598 2280365 2280365 defendant Huchyn Richard yeoman 589661 589661 Huchyn, Richard, of Modbury, yeoman 0
4750877 2280739 2280739 defendant Skynner Robert laborer 589661 589661 Skynner, Robert, of Modbury, laborer 2
4765836 2285314 2285314 plaintiff Nycoll John Exeter diocese 589661 589661 Nycoll, John, of Modbury, Exeter diocese 1
4765840 2285315 2285315 plaintiff Nyoll John Exeter diocese 589661 589661 Nyoll, John, of Modbury, Exeter diocese 1
4765846 2285316 2285316 plaintiff Nyoll John Exeter diocese 589661 589661 Nyoll, John, of Modbury, Exeter diocese 1
4765853 2285317 2285317 plaintiff Nyoll John Exeter diocese 589661 589661 Nyoll, John, of Modbury, Exeter diocese 1
4765860 2285318 2285318 plaintiff Nyoll John Exeter diocese 589661 589661 Nyoll, John, of Modbury, Exeter diocese 1
4770074 2286611 2286611 plaintiff Preaux Adam   589661 589661 Preaux, Adam, of Modbury, prior 0
4770076 2286611 2286611 defendant Lyneghere Walter yeoman 589661 589661 Lyneghere, Walter, of Modbury, yeoman 1
4780455 2289885 2289885 defendant Sheter John tailor 589661 589661 Sheter, John, of Modbury, tailor 3
4784673 2291212 2291212 plaintiff Huchon Richard   589661 589661 Huchon, Richard, of Modbury 1
4784676 2291213 2291213 plaintiff Huchon Richard   589661 589661 Huchon, Richard, of Modbury 1
4784679 2291214 2291214 plaintiff Huchon Richard   589661 589661 Huchon, Richard, of Modbury 1
4785723 2291568 2291568 plaintiff Ferrour or Smith John (legal representative) 589661 589661 Ferrour or Smith, John, of Modbury, executors of 0
4786817 2291934 2291934 defendant Scos William   589661 589661 Scos, William, of Modbury, Devon husbandman 0
4788859 2292571 2292571 defendant Huchon Richard merchant 589661 589661 Huchon, Richard, of Modbury, merchant 1
4794772 2294504 2294504 defendant Huchyn Richard husbandman 589661 589661 Huchyn, Richard, of Modbury, husbandman 0
4833312 2306429 2306429 defendant Wyot John butcher 589661 589661 Wyot, John, of Modbury, butcher 0
4850373 2311572 2311572 defendant Lynge Walter husbandman 589661 589661 Lynge, Walter, of Modbury, husbandman 0
4881066 2320989 2320989 defendant Hill Robert esq 589661 589661 Hill, Robert, of Modbury, esq 1
4882883 2321562 2321562 defendant Fortescu Joan   589661 589661 Fortescu, Joan, of Modbury, widow of Fortescu, William 2
4936434 2337785 2337785 defendant Stenelake William butcher 589661 589661 Stenelake, William, of Modbury, butcher 1
4942279 2339579 2339579 defendant Greder Stephen laborer 589661 589661 Greder, Stephen, of Modbury, laborer 0
4959683 2344857 2344857 defendant Chope Richard yeoman 589661 589661 together with Chope, Richard, of Modbury, yeoman 2
4986284 2352825 2352825 defendant Chope Richard yeoman 589661 589661 Chope, Richard, of Modbury, yeoman 0
4989533 2353802 2353802 defendant atte Trewyn William husbandman 589661 589661 atte Trewyn, William, of Modbury, husbandman 0
4989534 2353802 2353802 defendant White Lawrence tinker 589661 589661 White, Lawrence, of Modbury, tinker 1
5004427 2358191 2358191 defendant Legh John husbandman 589661 589661 Legh, John, of Modbury, husbandman 2
5015266 2361347 2361347 defendant Trumpyngdon John gent 589661 589661 Trumpyngdon, John, of Modbury, gent 0
5015723 2361483 2361483 defendant Shynner Robert, junior butcher 589661 589661 Shynner, Robert, junior, of Modbury, butcher 0
5023247 2363702 2363702 defendant Wyll Simon husbandman 589661 589661 Wyll, Simon, of Modbury, husbandman 3
5037456 2367825 2367825 defendant Mewy John weaver 589661 589661 Mewy, John, of Modbury, weaver 0
5039789 2368543 2368543 defendant Trumpyngdon John gent 589661 589661 Trumpyngdon, John, of Modbury, gent 0
5039890 2368574 2368574 defendant Tollok John husbandman 589661 589661 Tollok, John, of Modbury, husbandman 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);