names

421 rows where place_id = 597874

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587542 1863752 1863752 defendant Sandforde John chaplain 597874 597874 Sandforde, John, of Stowe St Edward, chaplain 0
3587547 1863754 1863754 plaintiff Aleyn Thomas   597874 597874 Aleyn, Thomas, of Stowe St Edward 0
3602120 1868328 1868328 defendant Harryes John   597874 597874 Harryes, John, of Stowe St Edward, wool merchant 0
3602121 1868328 1868328 defendant Harryes William yeoman 597874 597874 Harryes, William, of Stowe St Edward, yeoman 1
3602568 1868464 1868464 defendant Harres William yeoman 597874 597874 Harres, William, of Stowe St Edward, yeoman 1
3605245 1869308 1869308 defendant Besseford John yeoman 597874 597874 Besseford, John, of Stowe St Edward, yeoman 0
3616767 1872874 1872874 defendant Sklatter William yeoman 597874 597874 Sklatter, William, of Stowe St Edward, yeoman 0
3616770 1872874 1872874 defendant Aleyn Thomas woolman 597874 597874 Aleyn, Thomas, of Stowe St Edward, woolman 3
3616771 1872874 1872874 defendant Warde John tailor 597874 597874 Warde, John, of Stowe St Edward, tailor 4
3616772 1872874 1872874 defendant Lotte John tailor 597874 597874 Lotte, John, of Stowe St Edward, tailor 5
3625133 1875395 1875395 defendant Spicer John spicer 597874 597874 Spicer, John, of Stowe St Edward, spicer 2
3630190 1904291 1904291 defendant Coye John husbandman 597874 597874 Coye, John, of Stowe, husbandman 3
3630196 1904292 1904292 defendant Coye John husbandman 597874 597874 Coye, John, of Stowe, husbandman 3
3631323 1904606 1904606 defendant Robertys Thomas yeoman 597874 597874 Robertys, Thomas, of Stowe St Edward, yeoman 0
3635064 1905765 1905765 defendant Robertis Thomas merchant 597874 597874 Robertis, Thomas, of Stowe St Edward, merchant 0
3635065 1905765 1905765 defendant Spycer Richard butcher 597874 597874 Spycer, Richard, of Stowe St Edward, butcher 1
3635069 1905766 1905766 defendant Spyre Richard butcher 597874 597874 Spyre, Richard, of Stowe St Edward, butcher 1
3635073 1905767 1905767 defendant Wyndesmore Richard yeoman 597874 597874 Wyndesmore, Richard, of Stowe St Edward, yeoman 1
3635339 1905848 1905848 plaintiff Pakket John woolman 597874 597874 Pakket, John, of Stowe St Edward, woolman 0
3637759 1906624 1906624 defendant Reyner Joan widow 597874 597874 Reyner, Joan, of Stowe, widow 5
3644134 1908597 1908597 defendant Coy John husbandman 597874 597874 Coy, John, of Stowe, husbandman 4
3666209 1915380 1915380 plaintiff Roche William gent 597874 597874 Roche, William, of Stowe, gent 1
3668098 1915966 1915966 plaintiff Alewey John   597874 597874 Alewey, John, of Stowe 0
3674751 1918148 1918148 plaintiff Grey Richard   597874 597874 Grey, Richard, of Stowe 0
3674754 1918149 1918149 plaintiff Grey Richard   597874 597874 Grey, Richard, of Stowe 0
3675343 1918326 1918326 defendant Neele William yeoman 597874 597874 Neele, William, of Stowe, yeoman 0
3675345 1918327 1918327 defendant Nele William yeoman 597874 597874 Nele, William, of Stowe, yeoman 0
3680755 1920062 1920062 plaintiff Rychardson John   597874 597874 Rychardson, John, of Stowe 0
3680758 1920063 1920063 plaintiff Rychardson John   597874 597874 Rychardson, John, of Stowe 0
3680892 1920107 1920107 plaintiff Saunders John   597874 597874 Saunders, John, of Stowe 0
3680895 1920108 1920108 plaintiff Saunders John   597874 597874 Saunders, John, of Stowe 0
3684668 1921337 1921337 defendant Neele Henry yeoman 597874 597874 Neele, Henry, of Stowe, yeoman 2
3689127 1922761 1922761 defendant Coye John husbandman 597874 597874 Coye, John, of Stowe, husbandman 3
3689254 1922801 1922801 defendant Harreys William yeoman 597874 597874 Harreys, William, of Stowe, yeoman 2
3689256 1922801 1922801 defendant Lepyncote Lewis yeoman 597874 597874 Lepyncote, Lewis, of Stowe, yeoman 4
3689257 1922801 1922801 defendant Hemmyng John yeoman 597874 597874 Hemmyng, John, of Stowe, yeoman 5
3689258 1922801 1922801 defendant Lepyncote John yeoman 597874 597874 Lepyncote, John, of Stowe, yeoman 6
3695912 1924958 1924958 defendant Dalyngton John yeoman 597874 597874 Dalyngton, John, of Stowe, yeoman 1
3703853 1927483 1927483 defendant Alen John husbandman 597874 597874 Alen, John, of Stowe St Edward, husbandman 3
3703858 1927484 1927484 defendant Alen John husbandman 597874 597874 Alen, John, of Stowe St Edward, husbandman 3
3703863 1927485 1927485 defendant Alen John husbandman 597874 597874 Alen, John, of Stowe St Edward, husbandman 3
3712163 1930121 1930121 defendant Elyott John husbandman 597874 597874 Elyott, John, of Stowe, husbandman 4
3717687 1931827 1931827 defendant Alen John husbandman 597874 597874 Alen, John, of Stowe St Edward, husbandman 2
3723629 1933663 1933663 defendant Denbold Robert yeoman 597874 597874 Denbold, Robert, of Stowe, yeoman 0
3745754 1940573 1940573 defendant Saunders George gent 597874 597874 Saunders, George, of Stowe, gent 0
3757660 1944374 1944374 defendant Adamson Hugh husbandman 597874 597874 Adamson, Hugh, of Stowe, husbandman 2
3764162 1946441 1946441 defendant Brodde John husbandman 597874 597874 Brodde, John, of Stowe, husbandman 0
3765191 1946777 1946777 defendant ap Deyo Hugh husbandman 597874 597874 ap Deyo, Hugh, of Stowe, husbandman 1
3769250 1948038 1948038 defendant Pate Thomas husbandman 597874 597874 Pate, Thomas, of Stowe, husbandman 0
3780122 1951508 1951508 defendant Streton Thomas clothier 597874 597874 Streton, Thomas, of Stowe, clothier 0
3785105 1953129 1953129 defendant Pate Walter husbandman 597874 597874 Pate, Walter, of Stowe, husbandman 0
3816434 1963051 1963051 defendant Harvy Richard yeoman 597874 597874 Harvy, Richard, of Stowe, yeoman 0
3817263 1963310 1963310 defendant Borough Katherine widow 597874 597874 Borough, Katherine, of Stowe, widow 0
3827654 1966508 1966508 defendant Belfeld Ralph yeoman 597874 597874 Belfeld, Ralph, of Stowe, yeoman 2
3827655 1966508 1966508 defendant Tamson John yeoman 597874 597874 Tamson, John, of Stowe, yeoman 3
3829035 1966962 1966962 defendant Nele William husbandman 597874 597874 Nele, William, of Stowe, husbandman 0
3830472 1967409 1967409 plaintiff Fletam Nicholas gent 597874 597874 Fletam, Nicholas, of Stowe, gent 0
3837364 1969597 1969597 defendant Vergoes William yeoman 597874 597874 Vergoes, William, of Stowe, yeoman 0
3839900 1970413 1970413 defendant North Thomas husbandman 597874 597874 North, Thomas, of Stowe, husbandman 4
3842566 1971204 1971204 defendant Lowyke Robert husbandman 597874 597874 Lowyke, Robert, of Stowe, husbandman 0
3858824 1976439 1976439 defendant Bedo David weaver 597874 597874 Bedo, David, of Stowe, weaver 0
3859609 1976707 1976707 defendant Tapsyman William husbandman 597874 597874 Tapsyman, William, of Stowe, husbandman 2
3861764 1977400 1977400 defendant Hopkyns Thomas smith 597874 597874 Hopkyns, Thomas, of Stowe, smith 0
3863570 1978008 1978008 defendant Gerveys Hugh husbandman 597874 597874 Gerveys, Hugh, of Stowe, husbandman 1
3866151 1978907 1978907 defendant Fulmerston Robert yeoman 597874 597874 Fulmerston, Robert, of Stowe, yeoman 0
3869244 1979956 1979956 defendant Pykyngton William   597874 597874 (Pykyngton, William, of Stowe St Edward 3
3873969 1981517 1981517 defendant Baron William innholder 597874 597874 Baron, William, of Stowe, innholder 1
3883749 1984836 1984836 defendant Tomson John husbandman 597874 597874 Tomson, John, of Stowe, husbandman 0
3883750 1984836 1984836 defendant Dean Henry husbandman 597874 597874 Dean, Henry, of Stowe, husbandman 1
3885986 1985565 1985565 defendant Heggys John innholder 597874 597874 Heggys, John, of Stowe, innholder 0
3903234 1991305 1991305 defendant Webster alias Chapfyman Robert husbandman 597874 597874 Webster alias Chapfyman, Robert, of Stowe, husbandman 0
3910627 1993872 1993872 defendant Hodgys John innholder 597874 597874 Hodgys, John, of Stowe, innholder 0
3910629 1993873 1993873 defendant Hoggys John innholder 597874 597874 Hoggys, John, of Stowe, innholder 0
3910636 1993875 1993875 defendant Hogys John innholder 597874 597874 Hogys, John, of Stowe, innholder 0
3916436 1995877 1995877 plaintiff Fletam Nicholas (legal representative) 597874 597874 Fletam, Nicholas, of Stowe, gent, executors of 0
3921115 1997413 1997413 defendant Sandford Arthur gent 597874 597874 Sandford, Arthur, of Stowe St Edward, gent 1
3923548 1998184 1998184 defendant Fethern John   597874 597874 Fethern, John, of Stowe St Edward 0
3924198 1998401 1998401 defendant Pore Andrew   597874 597874 Pore, Andrew, of Stowe, wheel wright 4
3931685 2000898 2000898 defendant Barker William husbandman 597874 597874 Barker, William, of Stowe, husbandman 1
3933833 2001611 2001611 defendant Veale John yeoman 597874 597874 Veale, John, of Stowe, yeoman 3
3946509 2005847 2005847 defendant Spilman Francis gent 597874 597874 Spilman, Francis, of Stowe, gent 0
3982936 2018676 2018676 plaintiff Skarlett Robert clothier 597874 597874 Skarlett, Robert, of Stowe, clothier 0
3993853 2022550 2022550 defendant Cumyn Edward gent 597874 597874 Cumyn, Edward, of Stowe, gent 3
3998415 2024171 2024171 defendant Spylman Francis esq 597874 597874 Spylman, Francis, of Stowe, esq 0
4016192 2030489 2030489 defendant Stele Thomas (legal representative) 597874 597874 Stele, Thomas, of Stowe, husbandman, executrix of 0
4016193 2030489 2030489 defendant Stele Joan widow 597874 597874 Stele, Joan, of Stowe, widow 1
4035389 2037331 2037331 plaintiff Hobbes William   597874 597874 Hobbes, William, of Stowe 0
4045080 2040693 2040693 defendant Ellott Lawrence yeoman 597874 597874 Ellott, Lawrence, of Stowe, yeoman 2
4052829 2043448 2043448 plaintiff Agarman William yeoman 597874 597874 Agarman, William, of Stowe, yeoman 0
4119600 2067297 2067297 defendant ap Rice Henry laborer 597874 597874 ap Rice, Henry, of Stowe, laborer 0
4119601 2067297 2067297 defendant James Elizabeth widow 597874 597874 James, Elizabeth, of Stowe, widow 1
4130960 2071384 2071384 defendant Beswick John clerk 597874 597874 Beswick, John, of Stowe, clerk 0
4151924 2078783 2078783 defendant Wright Robert husbandman 597874 597874 Wright, Robert, of Stowe, husbandman 2
4199967 2095539 2095539 defendant Partriche Robert, junior gent 597874 597874 Partriche, Robert, junior, of Stowe, gent 0
4207694 2098251 2098251 defendant Sayntloo Clement esq 597874 597874 Sayntloo, Clement, of Stowe, esq 0
4223827 2103819 2103819 defendant Assey Edmund husbandman 597874 597874 Assey, Edmund, of Stowe, husbandman 2
4225690 2104450 2104450 defendant Assey Edmund yeoman 597874 597874 Assey Edmund, of Stowe, yeoman 0
4234179 2107487 2107487 defendant Strehay John merchant 597874 597874 Strehay, John, of Stowe, or of Chartley, merchant 0
4235120 2107841 2107841 defendant Robert Robert husbandman 597874 597874 Robert, Robert, of Stowe, husbandman 0
4240276 2109722 2109722 defendant Estland William yeoman 597874 597874 Estland, William, of Stowe, yeoman 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);