names

231 rows where place_id = 593181

✎ 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
3610811 1871048 1871048 defendant Rouland Richard husbandman 593181 593181 Rouland, Richard, of Staverton, husbandman 0
3617019 1872944 1872944 defendant Davy John husbandman 593181 593181 Davy, John, of Staverton, husbandman 0
3617020 1872944 1872944 defendant Macy Robert husbandman 593181 593181 Macy, Robert, of Staverton, husbandman 1
3661914 1914017 1914017 defendant Rowe John, junior merchant 593181 593181 Rowe, John, junior, of Staverton, merchant 0
3664429 1914823 1914823 defendant Emet John butcher 593181 593181 Emet, John, of Staverton, butcher 0
3680024 1919816 1919816 defendant Wynter John husbandman 593181 593181 Wynter, John, of Staverton, husbandman 0
3680025 1919816 1919816 defendant Elys Thomas husbandman 593181 593181 Elys, Thomas, of Staverton, husbandman 1
3689968 1923022 1923022 defendant Macy John husbandman 593181 593181 Macy, John, of Staverton, husbandman 1
3718775 1932151 1932151 defendant Abraham Thomas yeoman 593181 593181 Abraham, Thomas, of Staverton, yeoman 0
3733700 1936786 1936786 defendant Abraham Thomas yeoman 593181 593181 Abraham, Thomas, of Staverton, yeoman 0
3737739 1938025 1938025 defendant Wolcote Richard carver 593181 593181 Wolcote, Richard, of Staverton, carver 0
3737740 1938025 1938025 defendant Pyke Thomas husbandman 593181 593181 Pyke, Thomas, of Staverton, husbandman 1
3737741 1938025 1938025 defendant Heth John husbandman 593181 593181 Heth, John, of Staverton, husbandman 2
3743582 1939868 1939868 defendant Wolston Thomas   593181 593181 Wolston, Thomas, of Staverton, franklin 0
3768852 1947905 1947905 defendant Pyke Thomas husbandman 593181 593181 Pyke, Thomas, of Staverton, husbandman 2
3787547 1953895 1953895 defendant Pyke Thomas husbandman 593181 593181 Pyke, Thomas, of Staverton, husbandman 0
3790938 1954998 1954998 defendant Ford Richard husbandman 593181 593181 Ford, Richard, of Staverton, husbandman 0
3795518 1956478 1956478 defendant Ruswell alias Whytlok Thomas yeoman 593181 593181 Ruswell alias Whytlok, Thomas, of Staverton, yeoman 0
3803411 1958968 1958968 defendant Abraham Thomas yeoman 593181 593181 Abraham, Thomas, of Staverton, yeoman 0
3807477 1960244 1960244 defendant Bowdon Thomas husbandman 593181 593181 Bowdon, Thomas, of Staverton, husbandman 0
3824896 1965666 1965666 defendant Forde John husbandman 593181 593181 Forde, John, of Staverton, husbandman 10
3847705 1972853 1972853 defendant Hamlyn Thomas yeoman 593181 593181 Hamlyn, Thomas, of Staverton, yeoman 2
3847706 1972853 1972853 defendant Abraham Thomas yeoman 593181 593181 Abraham, Thomas, of Staverton, yeoman 3
3858212 1976223 1976223 defendant Graunt John husbandman 593181 593181 Graunt, John, of Staverton, husbandman 0
3875097 1981906 1981906 defendant Harry William yeoman 593181 593181 Harry, William, of Staverton, yeoman 0
3875098 1981906 1981906 defendant Coffen William   593181 593181 Coffen, William, of Staverton, groom 1
3875099 1981906 1981906 defendant Wynter John, junior yeoman 593181 593181 Wynter, John, junior, of Staverton, yeoman 2
3875100 1981906 1981906 defendant Aptor Richard yeoman 593181 593181 Aptor, Richard, of Staverton, yeoman 3
3888615 1986447 1986447 defendant Tres John husbandman 593181 593181 Tres, John, of Staverton, husbandman 0
3897632 1989423 1989423 defendant Wolston Thomas gent 593181 593181 Wolston, Thomas, of Staverton, gent 0
3897633 1989423 1989423 defendant Gold Thomas merchant 593181 593181 Gold, Thomas, of Staverton, merchant 1
3897635 1989423 1989423 defendant Pole John yeoman 593181 593181 Pole, John, of Staverton, yeoman 3
3897636 1989423 1989423 defendant Damerell John laborer 593181 593181 Damerell, John, of Staverton, laborer 4
3897637 1989423 1989423 defendant Standon Edward husbandman 593181 593181 Standon, Edward, of Staverton, husbandman 5
3897638 1989423 1989423 defendant Colboll Edward weaver 593181 593181 Colboll, Edward, of Staverton, weaver 6
3897639 1989423 1989423 defendant Serell John husbandman 593181 593181 Serell, John, of Staverton, husbandman 7
3897640 1989423 1989423 defendant Wynsore Thomas butcher 593181 593181 Wynsore, Thomas, of Staverton, butcher 8
3897641 1989423 1989423 defendant Wynsore John laborer 593181 593181 Wynsore, John, of Staverton, laborer 9
3897642 1989423 1989423 defendant Emmette Henry butcher 593181 593181 Emmette, Henry, of Staverton, butcher 10
3897643 1989423 1989423 defendant Ellis Evastasia widow 593181 593181 Ellis, Evastasia, of Staverton, widow 11
3897644 1989423 1989423 defendant Irsyll John baker 593181 593181 Irsyll, John, of Staverton, baker 12
3929810 2000308 2000308 defendant Wolston John gent 593181 593181 Wolston, John, of Staverton, gent 0
3934056 2001685 2001685 plaintiff Harward John   593181 593181 Harward, John, of Staverton 0
3934057 2001685 2001685 defendant Pyke John husbandman 593181 593181 Pyke, John, of Staverton, husbandman 0
3941275 2004087 2004087 defendant Willyams John butcher 593181 593181 Willyams, John, of Staverton, butcher 0
3942099 2004372 2004372 defendant Brodryche Thomas draper 593181 593181 Brodryche, Thomas, of Staverton, draper 0
3942101 2004373 2004373 defendant Cosyn Katherine widow 593181 593181 Cosyn, Katherine, of Staverton, widow 0
3942103 2004374 2004374 defendant Gowld Thomas merchant 593181 593181 Gowld, Thomas, of Staverton, merchant 0
3948266 2006453 2006453 plaintiff Crossyn William merchant 593181 593181 Crossyn, William, of Staverton, merchant 0
3948268 2006454 2006454 plaintiff Crossyn William merchant 593181 593181 Crossyn, William, of Staverton, merchant 0
3948271 2006455 2006455 plaintiff Crossyn William merchant 593181 593181 Crossyn, William, of Staverton, merchant 0
3959507 2010416 2010416 defendant Blacheford John butcher 593181 593181 Blacheford, John, of Staverton, butcher 0
3960444 2010750 2010750 defendant Goule William merchant 593181 593181 Goule, William, of Staverton, merchant 0
3966797 2013023 2013023 defendant Gamon Richard clerk 593181 593181 Gamon, Richard, of Staverton, clerk 0
3972472 2014950 2014950 defendant Broderidge Thomas merchant 593181 593181 Broderidge, Thomas, of Staverton, merchant 0
3993347 2022361 2022361 plaintiff Caunter William   593181 593181 Caunter, William, of Staverton 0
3993349 2022362 2022362 plaintiff Caunter William   593181 593181 Caunter, William, of Staverton 0
4009838 2028295 2028295 defendant Smith Thomas husbandman 593181 593181 Smith, Thomas, of Staverton, husbandman 0
4010892 2028673 2028673 defendant Petherycke Walter husbandman 593181 593181 Petherycke, Walter, of Staverton, husbandman 0
4010893 2028673 2028673 defendant Adam William husbandman 593181 593181 Adam, William, of Staverton, husbandman 1
4012313 2029125 2029125 plaintiff Pyke Edward weaver 593181 593181 Pyke, Edward, of Staverton, weaver 0
4016597 2030641 2030641 defendant Leetis John husbandman 593181 593181 Leetis, John, of Staverton, husbandman 0
4018524 2031357 2031357 defendant Wyllyam Owen yeoman 593181 593181 Wyllyam, Owen, of Staverton, yeoman 0
4018528 2031358 2031358 defendant Wyllyam Owen yeoman 593181 593181 Wyllyam, Owen, of Staverton, yeoman 0
4024401 2033405 2033405 plaintiff Blacheforde Thomas husbandman 593181 593181 Blacheforde, Thomas, of Staverton, husbandman 0
4024402 2033405 2033405 defendant Wylmede William husbandman 593181 593181 Wylmede, William, of Staverton, husbandman 0
4041652 2039507 2039507 defendant Adam William husbandman 593181 593181 Adam, William, of Staverton, husbandman 1
4067122 2048539 2048539 defendant Toope John yeoman 593181 593181 Toope, John, of Staverton, yeoman 0
4071411 2050074 2050074 plaintiff Moundford John yeoman 593181 593181 Moundford, John, of Staverton, yeoman 0
4072909 2050608 2050608 defendant Adams William husbandman 593181 593181 Adams, William, of Staverton, husbandman 0
4074588 2051214 2051214 defendant Smyth Francis husbandman 593181 593181 Smyth, Francis, of Staverton, husbandman 1
4088027 2056014 2056014 defendant Duck John yeoman 593181 593181 Duck, John, of Staverton, yeoman 0
4088028 2056014 2056014 defendant Roo John, junior gent 593181 593181 Roo, John, junior, of Staverton, gent 1
4118993 2067074 2067074 defendant Kynaston Thomas gent 593181 593181 Kynaston, Thomas, of Staverton, gent 0
4130214 2071116 2071116 defendant Willson Richard clerk 593181 593181 Willson, Richard, of Staverton, clerk 0
4153634 2079364 2079364 defendant Willson Richard clerk 593181 593181 Willson, Richard, of Staverton, clerk 0
4170863 2085299 2085299 defendant Venne Richard yeoman 593181 593181 Venne, Richard, of Staverton, yeoman 0
4183209 2089609 2089609 defendant Williams Owen yeoman 593181 593181 Williams, Owen, of Staverton, yeoman 0
4183925 2089872 2089872 defendant Ven Richard husbandman 593181 593181 Ven, Richard, of Staverton, husbandman 0
4188881 2091591 2091591 defendant Williams Owen yeoman 593181 593181 Williams, Owen, of Staverton, yeoman 0
4188882 2091591 2091591 defendant Ven Richard yeoman 593181 593181 Ven, Richard, of Staverton, yeoman 1
4204872 2097245 2097245 defendant Peke William husbandman 593181 593181 Peke William, of Staverton, husbandman 1
4206385 2097776 2097776 defendant Ven Richard yeoman 593181 593181 Ven, Richard, of Staverton, yeoman 0
4206386 2097776 2097776 defendant Williams Owen yeoman 593181 593181 Williams, Owen, of Staverton, yeoman 1
4259870 2116273 2116273 defendant Tayler John yeoman 593181 593181 Tayler, John, of Staverton, yeoman 0
4283992 2124317 2124317 defendant Clement William yeoman 593181 593181 Clement, William, of Staverton, yeoman 0
4317189 2136124 2136124 defendant Bradridge Thomas yeoman 593181 593181 Bradridge, Thomas, of Staverton, yeoman 0
4317190 2136124 2136124 defendant Bradridge Joan widow 593181 593181 Bradridge, Joan, of Staverton, widow 1
4323310 2138215 2138215 defendant Wilson Richard clerk 593181 593181 Wilson, Richard, of Staverton, clerk 0
4345615 2145734 2145734 defendant Symes Elizabeth widow 593181 593181 Symes, Elizabeth, of Staverton, widow 0
4345617 2145735 2145735 defendant Symes Elizabeth widow 593181 593181 Symes, Elizabeth, of Staverton, widow 0
4359514 2150561 2150561 defendant Lyell Robert butcher 593181 593181 Lyell, Robert, of Staverton, butcher 0
4399871 2164544 2164544 defendant Wollery John yeoman 593181 593181 Wollery, John, of Staverton, yeoman 0
4421942 2171737 2171737 defendant Hirdman Agnes   593181 593181 Hirdman, Agnes, of Staverton, formerly wife of John 0
4430357 2174284 2174284 defendant Pryk Thomas   593181 593181 Pryk, Thomas, of Staverton 0
4430359 2174285 2174285 defendant Pryk Thomas   593181 593181 Pryk, Thomas, of Staverton 0
4483593 2195559 2195559 defendant Yong John   593181 593181 Yong, John, of Staverton, vicar 1
4483594 2195559 2195559 defendant Smyth Wiliam   593181 593181 Smyth, Wiliam, of Staverton 2
4517048 2205739 2205739 defendant Hokemore Richard   593181 593181 Hokemore, Richard, of Staverton 2
4531170 2210024 2210024 plaintiff Passelewe Simon (legal representative) 593181 593181 Passelewe, Simon, of Staverton, executors of 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);