names

142 rows where place_id = 588239

✎ 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
3593813 1865706 1865706 plaintiff Hotte Thomas   588239 588239 Hotte, Thomas, of Yelverton 0
3606754 1869787 1869787 defendant Heynes Robert yeoman 588239 588239 Heynes, Robert, of Yelverton, yeoman 2
3619265 1873629 1873629 plaintiff Hotte Thomas   588239 588239 Hotte, Thomas, of Yelverton 0
3619268 1873629 1873629 defendant Wyot Thomas gent 588239 588239 Wyot, Thomas, of Yelverton, gent 2
3619270 1873629 1873629 defendant Pratte John husbandman 588239 588239 Pratte, John, of Yelverton, husbandman 4
3781598 1951982 1951982 defendant Feld Thomas husbandman 588239 588239 Feld, Thomas, of Yelverton, husbandman 0
3798205 1957335 1957335 defendant Clyfford Richard gent 588239 588239 Clyfford, Richard, of Yelverton, gent 0
3803724 1959079 1959079 defendant Heynes John husbandman 588239 588239 Heynes, John, of Yelverton, husbandman 0
3855208 1975261 1975261 defendant Syer John butcher 588239 588239 Syer, John, of Yelverton, butcher 0
3915860 1995683 1995683 defendant Warner alias Potter Humphrey yeoman 588239 588239 Warner alias Potter, Humphrey, of Yelverton, yeoman 0
3915863 1995683 1995683 defendant Ryches alias Poynter John husbandman 588239 588239 Ryches alias Poynter, John, of Yelverton, husbandman 3
3955986 2009164 2009164 defendant Rychers alias Poynter Thomas yeoman 588239 588239 Rychers alias Poynter, Thomas, of Yelverton, yeoman 0
3969842 2014055 2014055 defendant Colman Thomas husbandman 588239 588239 Colman, Thomas, of Yelverton, husbandman 0
3981361 2018102 2018102 defendant Toftwood Thomas yeoman 588239 588239 Toftwood, Thomas, of Yelverton, yeoman 0
3981362 2018102 2018102 defendant Arnolde John yeoman 588239 588239 Arnolde, John, of Yelverton, yeoman 1
3984907 2019360 2019360 plaintiff Toftwood Thomas yeoman 588239 588239 Toftwood, Thomas, of Yelverton, yeoman 0
3986618 2019953 2019953 defendant Rede Robert husbandman 588239 588239 Rede, Robert, of Yelverton, husbandman 0
4011359 2028838 2028838 defendant Kene Edmund yeoman 588239 588239 Kene, Edmund, of Yelverton, yeoman 0
4013407 2029529 2029529 plaintiff Rongaye John yeoman 588239 588239 Rongaye, John, of Yelverton, yeoman 0
4021108 2032272 2032272 plaintiff Wrongaye John yeoman 588239 588239 Wrongaye, John, of Yelverton, yeoman 0
4129242 2070760 2070760 defendant Granawaye Robert husbandman 588239 588239 Granawaye, Robert, of Yelverton, husbandman 0
4155828 2080117 2080117 defendant Turner Absolon husbandman 588239 588239 Turner, Absolon, of Yelverton, husbandman 2
4156021 2080178 2080178 defendant Turner Absalom yeoman 588239 588239 Turner, Absalom, of Yelverton, yeoman 3
4169239 2084742 2084742 defendant Kene Edmund gent 588239 588239 Kene, Edmund, of Yelverton, gent 3
4221441 2102991 2102991 defendant Kybert or Keybert Thomas yeoman 588239 588239 Kybert or Keybert, Thomas, of Yelverton, yeoman 2
4222290 2103286 2103286 defendant Dannock Nicholas gent 588239 588239 Dannock, Nicholas, of Yelverton, gent 0
4247277 2112066 2112066 defendant Keybert Thomas yeoman 588239 588239 Keybert, Thomas, of Yelverton, yeoman 2
4261927 2116940 2116940 defendant Bannock Nicholas gent 588239 588239 Bannock, Nicholas, of Yelverton, gent 1
4477477 2193622 2193622 defendant Fyk Andrew   588239 588239 Fyk, Andrew, of Yelverton 0
4477478 2193622 2193622 defendant Sparhauk Andrew   588239 588239 Sparhauk, Andrew, of Yelverton 1
4516259 2205495 2205495 defendant Sparhauk Andrew   588239 588239 Sparhauk, Andrew, of Yelverton 1
4579426 2225044 2225044 defendant Kenseye John   588239 588239 Kenseye, John, of Yelverton 0
4595187 2229748 2229748 defendant Sperhauk Andrew   588239 588239 Sperhauk, Andrew, of Yelverton 6
4595200 2229749 2229749 defendant Sperhauk Andrew   588239 588239 Sperhauk, Andrew, of Yelverton 6
4635228 2241858 2241858 defendant Warner Agnes   588239 588239 Warner, Agnes, of Yelverton, formerly wife of Thomas 1
4666866 2255365 2255365 defendant Sparhauk Andrew yeoman 588239 588239 Sparhauk, Andrew, of Yelverton, yeoman 1
4679900 2259322 2259322 defendant Bee Geoffrey husbandman 588239 588239 Bee, Geoffrey, of Yelverton, husbandman 1
4679901 2259322 2259322 defendant Sparhauk Andrew yeoman 588239 588239 Sparhauk, Andrew, of Yelverton, yeoman 2
4683137 2260340 2260340 defendant Sendell John clerk 588239 588239 Sendell, John, of Yelverton, clerk 0
4686904 2261511 2261511 defendant Warner Thomas (legal representative) 588239 588239 Warner, Thomas, of Yelverton, executors of 2
4687826 2261761 2261761 defendant Sparhauke Andrew yeoman 588239 588239 Sparhauke, Andrew, of Yelverton, yeoman 1
4713473 2269535 2269535 defendant Sendell John chaplain 588239 588239 Sendell, John, of Yelverton, chaplain 1
4713481 2269536 2269536 defendant Sperhauk Andrew yeoman 588239 588239 Sperhauk, Andrew, of Yelverton, yeoman 1
4720923 2271877 2271877 defendant Wyrmegeye John yeoman 588239 588239 Wyrmegeye, John, of Yelverton, yeoman 1
4726292 2273507 2273507 defendant Sperhauk Andrew yeoman 588239 588239 Sperhauk, Andrew, of Yelverton, yeoman 1
4726293 2273507 2273507 defendant Bee Geofrey yeoman 588239 588239 Bee, Geofrey, of Yelverton, yeoman 2
4730154 2274630 2274630 defendant Wermegey John husbandman 588239 588239 Wermegey, John, of Yelverton, husbandman 1
4730157 2274631 2274631 defendant Wermegeye John husbandman 588239 588239 Wermegeye, John, of Yelverton, husbandman 1
4733428 2275632 2275632 defendant atte Medewe John weaver 588239 588239 atte Medewe, John, of Yelverton, weaver 1
4733437 2275633 2275633 defendant Tomme John husbandman 588239 588239 Tomme, John, of Yelverton, husbandman 5
4736016 2276404 2276404 defendant Sendell John chaplain 588239 588239 Sendell, John, of Yelverton, chaplain 5
4739356 2277395 2277395 defendant Reyser Thomas husbandman 588239 588239 Reyser, Thomas, of Yelverton, husbandman 1
4739357 2277395 2277395 defendant Wormyngey John yeoman 588239 588239 Wormyngey, John, of Yelverton, yeoman 2
4741619 2278044 2278044 defendant Wyrmegey John husbandman 588239 588239 Wyrmegey, John, of Yelverton, husbandman 0
4741621 2278044 2278044 defendant Bee Geoffrey husbandman 588239 588239 Bee, Geoffrey, of Yelverton, husbandman 2
4741622 2278044 2278044 defendant Sparwe John husbandman 588239 588239 Sparwe, John, of Yelverton, husbandman 3
4744268 2278847 2278847 defendant Wyrmegeye John yeoman 588239 588239 Wyrmegeye, John, of Yelverton, yeoman 1
4750256 2280552 2280552 defendant Wyrmegeye John yeoman 588239 588239 Wyrmegeye, John, of Yelverton, yeoman 0
4752076 2281091 2281091 defendant Wermegey John yeoman 588239 588239 Wermegey, John, of Yelverton, yeoman 0
4754412 2281760 2281760 defendant Wormyngey John husbandman 588239 588239 Wormyngey, John, of Yelverton, husbandman 0
4754416 2281761 2281761 defendant Wormyngey John husbandman 588239 588239 Wormyngey, John, of Yelverton, husbandman 0
4755674 2282158 2282158 defendant Sendell John clerk 588239 588239 Sendell, John, of Yelverton, clerk 0
4757349 2282670 2282670 defendant Sperhauk Andrew husbandman 588239 588239 Sperhauk, Andrew, of Yelverton, husbandman 4
4758335 2282981 2282981 defendant Wyrmegeye John yeoman 588239 588239 Wyrmegeye, John, of Yelverton, yeoman 0
4759437 2283293 2283293 defendant Sylham Henry   588239 588239 Sylham, Henry, of Yelverton, servant 0
4759439 2283294 2283294 defendant Sylham Henry   588239 588239 Sylham, Henry, of Yelverton, servant 0
4767184 2285722 2285722 defendant Wirmegeye John husbandman 588239 588239 Wirmegeye, John, of Yelverton, husbandman 0
4768815 2286224 2286224 defendant Sendell John chaplain 588239 588239 Sendell, John, of Yelverton, chaplain 0
4773848 2287800 2287800 defendant Wyrmegey John husbandman 588239 588239 Wyrmegey, John, of Yelverton, husbandman 1
4778668 2289312 2289312 defendant Fuller Nicholas husbandman 588239 588239 Fuller, Nicholas, of Yelverton, husbandman 0
4780582 2289923 2289923 defendant Wirmegey John yeoman 588239 588239 Wirmegey, John, of Yelverton, yeoman 0
4793324 2294010 2294010 defendant Sendell John chaplain 588239 588239 Sendell, John, of Yelverton, chaplain 0
4794846 2294532 2294532 defendant Wyrmyngeye John husbandman 588239 588239 Wyrmyngeye, John, of Yelverton, husbandman 1
4799847 2296133 2296133 defendant Wyrmegey John husbandman 588239 588239 Wyrmegey, John, of Yelverton, husbandman 1
4809529 2299149 2299149 defendant Fuller Nicholas husbandman 588239 588239 Fuller, Nicholas, of Yelverton, husbandman 2
4820250 2302403 2302403 defendant Wyrmegeye John yeoman 588239 588239 Wyrmegeye, John, of Yelverton, yeoman 0
4820254 2302404 2302404 defendant Wyrmegeye John yeoman 588239 588239 Wyrmegeye, John, of Yelverton, yeoman 0
4825500 2304019 2304019 defendant Burny William yeoman 588239 588239 Burny, William, of Yelverton, yeoman 0
4825501 2304019 2304019 defendant Reyser Thomas   588239 588239 Reyser, Thomas, of Yelverton, 1
4877854 2320035 2320035 defendant Chirche William clerk 588239 588239 Chirche, William, of Yelverton, clerk 0
4885103 2322233 2322233 defendant Wyrmegey John yeoman 588239 588239 Wyrmegey, John, of Yelverton, yeoman 2
4901164 2326979 2326979 defendant Fuller Nicholas husbandman 588239 588239 Fuller, Nicholas, of Yelverton, husbandman 8
4905037 2328184 2328184 plaintiff Sparwe or Sparowe John   588239 588239 Sparwe or Sparowe, John, of Yelverton 2
4918913 2332430 2332430 defendant Burny William husbandman 588239 588239 Burny, William, of Yelverton, husbandman 1
4924642 2334144 2334144 defendant Fuller Nicholas yeoman 588239 588239 Fuller, Nicholas, of Yelverton, yeoman 0
4935872 2337609 2337609 defendant Wyrmyngey John yeoman 588239 588239 Wyrmyngey, John, of Yelverton, yeoman 0
4936617 2337836 2337836 defendant Wymergey John husbandman 588239 588239 Wymergey, John, of Yelverton, husbandman 0
4936620 2337837 2337837 defendant Wyrmegey John husbandman 588239 588239 Wyrmegey, John, of Yelverton, husbandman 0
4938136 2338307 2338307 defendant Fuller Nicholas yeoman 588239 588239 Fuller, Nicholas, of Yelverton, yeoman 0
4938137 2338307 2338307 defendant Warmalle John yeoman 588239 588239 Warmalle, John, of Yelverton, yeoman 1
4949648 2341887 2341887 defendant Burny William husbandman 588239 588239 Burny, William, of Yelverton, husbandman 4
4949875 2341941 2341941 defendant Fuller Geoffrey chaplain 588239 588239 Fuller, Geoffrey, of Yelverton, chaplain 9
4958601 2344539 2344539 defendant Smyth John yeoman 588239 588239 Smyth, John, of Yelverton, yeoman 1
4958603 2344539 2344539 defendant Warmale John yeoman 588239 588239 Warmale, John, of Yelverton, yeoman 3
4982760 2351755 2351755 defendant F- Nicholas husbandman 588239 588239 F-, Nicholas, of Yelverton, husbandman 1
4993666 2354980 2354980 defendant Fullere Nicholas yeoman 588239 588239 Fullere, Nicholas, of Yelverton, yeoman 0
5001056 2357187 2357187 defendant Smyth John yeoman 588239 588239 Smyth, John, of Yelverton, yeoman 0
5002462 2357633 2357633 defendant Warmale John husbandman 588239 588239 Warmale, John, of Yelverton, husbandman 1
5012922 2360611 2360611 defendant Duke Richard husbandman 588239 588239 Duke, Richard, of Yelverton, husbandman 0
5142445 2398917 2398917 defendant Duke Richard husbandman 588239 588239 Duke, Richard, of Yelverton, 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);