names

185 rows where place_id = 586813

✎ 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
3589720 1864424 1864424 defendant Webber Emma widow 586813 586813 Webber, Emma, of Pylton, widow 0
3595106 1866099 1866099 defendant Legh William yeoman 586813 586813 Legh, William, of Pylton, yeoman 4
3596194 1866438 1866438 defendant Catecotte William, junior tailor 586813 586813 Catecotte, William, junior, of Pylton, tailor 0
3609557 1870654 1870654 defendant Paty Richard clothier 586813 586813 Paty, Richard, of Pylton, clothier 0
3611161 1871166 1871166 defendant Burke Thomas husbandman 586813 586813 Burke, Thomas, of Pylton, husbandman 4
3611643 1871310 1871310 defendant Burke Thomas husbandman 586813 586813 Burke, Thomas, of Pylton, husbandman 4
3611649 1871311 1871311 defendant Burke Thomas husbandman 586813 586813 Burke, Thomas, of Pylton, husbandman 4
3612112 1871432 1871432 defendant Tappyscote Philip weaver 586813 586813 Tappyscote, Philip, of Pylton, weaver 0
3613237 1871794 1871794 defendant Galyngton John husbandman 586813 586813 Galyngton, John, of Pylton, husbandman 3
3618360 1873373 1873373 defendant Fulbroke John gent 586813 586813 Fulbroke, John, of Pylton, gent 0
3618573 1873434 1873434 plaintiff Harper William (legal representative) 586813 586813 Harper, William, of Pylton, tucker, executor of 0
3618574 1873434 1873434 plaintiff Thorn John   586813 586813 Thorn, John, of Pylton 1
3643463 1908383 1908383 defendant Kempe Simon miller 586813 586813 Kempe, Simon, of Pylton, miller 0
3643465 1908383 1908383 defendant Elys Robert weaver 586813 586813 Elys, Robert, of Pylton, weaver 2
3643466 1908383 1908383 defendant Elys John weaver 586813 586813 Elys, John, of Pylton, weaver 3
3644177 1908611 1908611 defendant Southerey John yeoman 586813 586813 Southerey, John, of Pylton, yeoman 3
3644214 1908622 1908622 defendant Sotherey John yeoman 586813 586813 Sotherey, John, of Pylton, yeoman 1
3646990 1909460 1909460 defendant Walshe Richard merchant 586813 586813 Walshe, Richard, of Pylton, merchant 0
3646992 1909461 1909461 defendant Paty Geoffrey husbandman 586813 586813 Paty, Geoffrey, of Pylton, husbandman 0
3646993 1909461 1909461 defendant Downe Richard husbandman 586813 586813 Downe, Richard, of Pylton, husbandman 1
3646994 1909461 1909461 defendant Seler Hugh weaver 586813 586813 Seler, Hugh, of Pylton, weaver 2
3646995 1909461 1909461 defendant Norys John tailor 586813 586813 Norys, John, of Pylton, tailor 3
3646996 1909461 1909461 defendant Wilke John weaver 586813 586813 Wilke, John, of Pylton, weaver 4
3702375 1927002 1927002 defendant Brett Alexander gent 586813 586813 Brett, Alexander, of Pylton, gent 0
3718007 1931927 1931927 defendant Grant Thomas carrier 586813 586813 Grant, Thomas, of Pylton, carrier 4
3718015 1931929 1931929 defendant Grant Thomas carrier 586813 586813 Grant, Thomas, of Pylton, carrier 4
3723758 1933707 1933707 defendant Bradley Thomas husbandman 586813 586813 Bradley, Thomas, of Pylton, husbandman 0
3724826 1934049 1934049 defendant Milward Stephen butcher 586813 586813 Milward, Stephen, of Pylton, butcher 0
3738166 1938151 1938151 defendant Sergant William, senior miller 586813 586813 Sergant, William, senior, of Pylton, miller 0
3742920 1939637 1939637 defendant Slader Simon tucker 586813 586813 Slader, Simon, of Pylton, tucker 8
3744280 1940109 1940109 defendant Townesend John, junior husbandman 586813 586813 Townesend, John, junior, of Pylton, husbandman 0
3753557 1943051 1943051 defendant Wylkyn Nicholas fuller 586813 586813 Wylkyn, Nicholas, of Pylton, fuller 1
3755085 1943537 1943537 defendant Slader Simon tucker 586813 586813 Slader, Simon, of Pylton, tucker 8
3758208 1944557 1944557 defendant Byrtt Robert esq 586813 586813 Byrtt, Robert, of Pylton, esq 0
3770012 1948281 1948281 defendant Byrt Alexander gent 586813 586813 Byrt, Alexander, of Pylton, gent 0
3772829 1949194 1949194 defendant Howell William husbandman 586813 586813 Howell, William, of Pylton, husbandman 0
3798235 1957346 1957346 defendant Soper Leonard yeoman 586813 586813 Soper, Leonard, of Pylton, yeoman 0
3858872 1976455 1976455 plaintiff Brytt Robert esq 586813 586813 Brytt, Robert, of Pylton, esq 0
3858875 1976456 1976456 plaintiff Brytt Robert esq 586813 586813 Brytt, Robert, of Pylton, esq 0
3896149 1988916 1988916 defendant Thorn Robert clerk 586813 586813 Thorn, Robert, of Pylton, clerk 0
3907290 1992731 1992731 defendant Pyper John butcher 586813 586813 Pyper, John, of Pylton, butcher 1
3917806 1996316 1996316 defendant Aprichard Thomas weaver 586813 586813 Aprichard, Thomas, of Pylton, weaver 0
3917977 1996379 1996379 defendant ap Rychard alias Welssheman Thomas haberdasher 586813 586813 ap Rychard alias Welssheman, Thomas, of Pylton, haberdasher 0
3924874 1998637 1998637 defendant Hyll William smith 586813 586813 Hyll, William, of Pylton, smith 0
3941151 2004043 2004043 defendant Norman Thomas weaver 586813 586813 Norman, Thomas, of Pylton, weaver 1
3948413 2006509 2006509 plaintiff Dabraham James weaver 586813 586813 Dabraham, James, of Pylton, weaver 0
3976878 2016484 2016484 defendant Dyer Walter yeoman 586813 586813 Dyer, Walter, of Pylton, yeoman 0
3976880 2016485 2016485 defendant Dyer Walter yeoman 586813 586813 Dyer, Walter, of Pylton, yeoman 0
4101928 2061002 2061002 defendant Thorn George yeoman 586813 586813 Thorn, George, of Pylton, yeoman 0
4144846 2076357 2076357 defendant Halle Walter clothier 586813 586813 Halle, Walter, of Pylton, clothier 0
4182068 2089207 2089207 defendant Williams Thomas yeoman 586813 586813 Williams, Thomas, of Pylton, yeoman 1
4262605 2117159 2117159 defendant Dart John   586813 586813 Dart, John, of Pylton, "fresemaker" 2
4288937 2126099 2126099 defendant Wilkyns John husbandman 586813 586813 Wilkyns, John, of Pylton, husbandman 0
4288939 2126100 2126100 defendant Wilkyns John husbandman 586813 586813 Wilkyns, John, of Pylton, husbandman 0
4289663 2126367 2126367 defendant Huddye Richard gent 586813 586813 Huddye, Richard, of Pylton, gent 2
4291567 2127059 2127059 defendant Best alias Cooke John fuller 586813 586813 Best alias Cooke, John, of Pylton, fuller 0
4311894 2134296 2134296 defendant Wynge Thomas yeoman 586813 586813 Wynge, Thomas, of Pylton, yeoman 0
4316573 2135916 2135916 defendant Taylbushe Edward yeoman 586813 586813 Taylbushe, Edward, of Pylton, yeoman 0
4316574 2135916 2135916 defendant Horwood John weaver 586813 586813 Horwood, John, of Pylton, weaver 1
4316575 2135916 2135916 defendant Horwood Thomas weaver 586813 586813 Horwood Thomas, of Pylton, weaver 2
4316576 2135916 2135916 defendant Hore William weaver 586813 586813 Hore, William, of Pylton, weaver 3
4316577 2135916 2135916 defendant Richard Oliver weaver 586813 586813 Richard, Oliver, of Pylton, weaver 4
4316705 2135960 2135960 defendant Rawles or Ralse William husbandman 586813 586813 Rawles or Ralse, William, of Pylton, husbandman 1
4375099 2156154 2156154 defendant Skynner Richard laborer 586813 586813 Skynner, Richard, of Pylton, laborer 0
4474742 2192766 2192766 defendant Bret John   586813 586813 Bret, John, of Pylton 0
4483262 2195462 2195462 defendant Reys Walter   586813 586813 Reys, Walter, of Pylton 5
4489544 2197450 2197450 defendant Dodde Nicholas   586813 586813 Dodde, Nicholas, of Pylton, parson 0
4492120 2198223 2198223 defendant Dod Nicholas   586813 586813 Dod, Nicholas, of Pylton, parson 2
4522368 2207340 2207340 plaintiff Gregory Walter   586813 586813 Gregory, Walter, of Pylton 0
4537663 2212052 2212052 defendant Toker John   586813 586813 Toker, John, of Pylton 2
4548200 2215379 2215379 defendant Reynold Athelina   586813 586813 Reynold, Athelina, of Pylton 0
4548201 2215379 2215379 defendant Reynald William   586813 586813 Reynald, William, of Pylton, son of Athelina 1
4694595 2263806 2263806 defendant Stukele Robert chapman 586813 586813 Stukele, Robert, of Pylton, chapman 1
4739956 2277573 2277573 defendant Depyng John husbandman 586813 586813 Depyng, John, of Pylton, husbandman 2
4767725 2285886 2285886 defendant Cornyssh John husbandman 586813 586813 Cornyssh, John, of Pylton, husbandman 2
4802575 2296992 2296992 defendant Yongwode William husbandman 586813 586813 Yongwode, William, of Pylton, husbandman 2
4807681 2298593 2298593 defendant Hamont John yeoman 586813 586813 Hamont, John, of Pylton, yeoman 2
4807787 2298622 2298622 defendant Beche Thomas husbandman 586813 586813 Beche, Thomas, of Pylton, husbandman 1
4807789 2298622 2298622 defendant Weste John husbandman 586813 586813 Weste, John, of Pylton, husbandman 3
4807790 2298622 2298622 defendant Pyers John husbandman 586813 586813 Pyers, John, of Pylton, husbandman 4
4880846 2320917 2320917 defendant Stukele Robert drover 586813 586813 Stukele, Robert, of Pylton, drover 1
4956471 2343892 2343892 defendant Tyler William husbandman 586813 586813 Tyler, William, of Pylton, husbandman 0
4960266 2345046 2345046 defendant Benette John laborer 586813 586813 Benette, John, of Pylton, laborer 0
4960268 2345046 2345046 defendant Webber John chaplain 586813 586813 (Webber, John, of Pylton, chaplain 2
4960269 2345046 2345046 defendant Vycary Thomas husbandman 586813 586813 Vycary, Thomas, of Pylton, husbandman 3
4971719 2348469 2348469 defendant Cokke John husbandman 586813 586813 Cokke, John, of Pylton, husbandman 2
4998048 2356276 2356276 defendant Gregory Stephen baker 586813 586813 Gregory, Stephen, of Pylton, baker 0
4999944 2356861 2356861 defendant Webber John chaplain 586813 586813 Webber, John, of Pylton, chaplain 0
4999945 2356861 2356861 defendant Webber William fuller 586813 586813 Webber, William, of Pylton, fuller 1
5014316 2361043 2361043 defendant Hamond Thomas carrier 586813 586813 Hamond, Thomas, of Pylton, carrier 1
5016923 2361842 2361842 defendant Passelewe Thomas husbandman 586813 586813 Passelewe, Thomas, of Pylton, husbandman 1
5018897 2362415 2362415 defendant Bayly Thomas husbandman 586813 586813 Bayly, Thomas, of Pylton, husbandman 0
5033736 2366745 2366745 defendant Kene Simon carrier 586813 586813 Kene, Simon, of Pylton, carrier 2
5041615 2369094 2369094 defendant Styward Robert husbandman 586813 586813 Styward, Robert, of Pylton, husbandman 1
5060128 2374597 2374597 defendant Perys Martin (legal representative) 586813 586813 Perys, Martin, of Pylton, merchant, executors of 0
5060132 2374598 2374598 defendant Vaylok John (legal representative) 586813 586813 Vaylok, John, of Pylton, tucker, executors of 0
5066592 2376532 2376532 defendant Clerk Richard husbandman 586813 586813 Clerk, Richard, of Pylton, husbandman 0
5068433 2377058 2377058 defendant Lange David panier maker 586813 586813 Lange, David, of Pylton, panier maker 0
5070002 2377523 2377523 plaintiff Ryddell Richard (legal representative) 586813 586813 Ryddell, Richard, of Pylton, executors of 0
5079675 2380409 2380409 defendant Pylton Robert gent 586813 586813 Pylton, Robert, of Pylton, gent 1

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);