names

202 rows where place_id = 591196

✎ 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
3603676 1868818 1868818 defendant Walton Robert laborer 591196 591196 Walton, Robert, of Wendover, laborer 1
3604620 1869107 1869107 defendant Ase Thomas butcher 591196 591196 Ase, Thomas, of Wendover, butcher 0
3615596 1872517 1872517 defendant Assheton Ralph husbandman 591196 591196 Assheton, Ralph, of Wendover, husbandman 0
3627587 1903487 1903487 defendant Hanys John husbandman 591196 591196 Hanys, John, of Wendover, husbandman 0
3630082 1904258 1904258 defendant Carter Nicholas yeoman 591196 591196 Carter, Nicholas, of Wendover, yeoman 0
3630083 1904258 1904258 defendant Bele Griffith yeoman 591196 591196 Bele, Griffith, of Wendover, yeoman 1
3633748 1905367 1905367 defendant Wylcokkys Walter gent 591196 591196 Wylcokkys, Walter, of Wendover, gent 0
3637840 1906652 1906652 defendant Wilcokkys Michael chapman 591196 591196 Wilcokkys, Michael, of Wendover, chapman 0
3637841 1906652 1906652 defendant Slade John chapman 591196 591196 Slade, John, of Wendover, chapman 1
3667617 1915815 1915815 defendant Here John husbandman 591196 591196 Here, John, of Wendover, husbandman 1
3683141 1920846 1920846 defendant Colett William yeoman 591196 591196 Colett, William, of Wendover, yeoman 0
3686456 1921917 1921917 defendant Hawes Thomas husbandman 591196 591196 Hawes, Thomas, of Wendover, husbandman 1
3689009 1922721 1922721 defendant Colett William butcher 591196 591196 Colett, William, of Wendover, butcher 0
3689011 1922722 1922722 defendant Collett William, junior butcher 591196 591196 Collett, William, junior, of Wendover, butcher 0
3692901 1923977 1923977 defendant Collett William butcher 591196 591196 Collett, William, of Wendover, butcher 0
3703764 1927456 1927456 defendant Bradshawe William yeoman 591196 591196 Bradshawe, William, of Wendover, yeoman 0
3712693 1930286 1930286 defendant Bemond John butcher 591196 591196 Bemond, John, of Wendover, butcher 1
3732135 1936286 1936286 defendant Raynard John husbandman 591196 591196 Raynard, John, of Wendover, husbandman 1
3743426 1939818 1939818 defendant Welsshe Robert husbandman 591196 591196 Welsshe, Robert, of Wendover, husbandman 0
3745918 1940630 1940630 plaintiff Carter Nicholas   591196 591196 Carter, Nicholas, of Wendover 0
3750053 1941934 1941934 defendant Kyng Robert clerk 591196 591196 Kyng, Robert, of Wendover, clerk 0
3750054 1941934 1941934 defendant Welhed John carpenter 591196 591196 Welhed, John, of Wendover, carpenter 1
3750055 1941934 1941934 defendant Fossard William laborer 591196 591196 Fossard, William, of Wendover, laborer 2
3756205 1943898 1943898 defendant Collet William, junior husbandman 591196 591196 Collet, William, junior, of Wendover, husbandman 0
3759809 1945064 1945064 defendant Hare Robert pardoner 591196 591196 Hare, Robert, of Wendover, pardoner 0
3759810 1945064 1945064 defendant Hare John husbandman 591196 591196 Hare, John, of Wendover, husbandman 1
3759814 1945066 1945066 defendant Reyner William husbandman 591196 591196 Reyner, William, of Wendover, husbandman 0
3765699 1946938 1946938 defendant Colet William, junior butcher 591196 591196 Colet, William, junior, of Wendover, butcher 0
3773998 1949581 1949581 defendant Collett William, junior husbandman 591196 591196 Collett, William, junior, of Wendover, husbandman 0
3775226 1949985 1949985 defendant Reyner Willian husbandman 591196 591196 Reyner, Willian, of Wendover, husbandman 0
3775227 1949985 1949985 defendant Hare John husbandman 591196 591196 Hare, John, of Wendover, husbandman 1
3777708 1950777 1950777 defendant Hare John husbandman 591196 591196 Hare, John, of Wendover, husbandman 2
3778112 1950866 1950866 defendant Grasbroke John husbandman 591196 591196 Grasbroke, John, of Wendover, husbandman 3
3778118 1950867 1950867 defendant Grasbroke John husbandman 591196 591196 Grasbroke, John, of Wendover, husbandman 4
3779015 1951160 1951160 defendant Leggyngham Henry gent 591196 591196 Leggyngham, Henry, of Wendover, gent 0
3795088 1956329 1956329 defendant Bonyngton or Bovyngton Edward husbandman 591196 591196 Bonyngton or Bovyngton, Edward, of Wendover, husbandman 4
3814264 1962369 1962369 defendant Reyner William husbandman 591196 591196 Reyner, William, of Wendover, husbandman 0
3815393 1962731 1962731 defendant Colet William, junior husbandman 591196 591196 Colet, William, junior, of Wendover, husbandman 0
3816142 1962952 1962952 defendant Fawkener Robert husbandman 591196 591196 Fawkener, Robert, of Wendover, husbandman 0
3816143 1962952 1962952 defendant Reyner William husbandman 591196 591196 Reyner, William, of Wendover, husbandman 1
3827254 1966391 1966391 defendant Wyer John   591196 591196 Wyer, John, of Wendover 0
3827423 1966440 1966440 defendant Tayllour alias Peers John tailor 591196 591196 Tayllour alias Peers, John, of Wendover, tailor 1
3831664 1967800 1967800 defendant Free John yeoman 591196 591196 Free, John, of Wendover, yeoman 1
3831667 1967801 1967801 defendant Free John yeoman 591196 591196 Free, John, of Wendover, yeoman 1
3832179 1967977 1967977 plaintiff Hill Robert husbandman 591196 591196 Hill, Robert, of Wendover, husbandman 0
3833143 1968294 1968294 defendant Weston John laborer 591196 591196 Weston, John, of Wendover, laborer 0
3843107 1971368 1971368 defendant Golett William butcher 591196 591196 Golett, William, of Wendover, butcher 0
3843338 1971449 1971449 defendant Ley William tanner 591196 591196 Ley, William, of Wendover, tanner 0
3843340 1971450 1971450 defendant Rolfe William butcher 591196 591196 Rolfe, William, of Wendover, butcher 0
3847436 1972760 1972760 defendant Colett William butcher 591196 591196 Colett, William, of Wendover, butcher 0
3848358 1973062 1973062 plaintiff Hyll Robert husbandman 591196 591196 Hyll, Robert, of Wendover, husbandman 0
3856584 1975685 1975685 defendant Grene William tailor 591196 591196 Grene, William, of Wendover, tailor 1
3859839 1976790 1976790 defendant Reyner William husbandman 591196 591196 Reyner, William, of Wendover, husbandman 0
3862101 1977511 1977511 defendant Colett William butcher 591196 591196 Colett, William, of Wendover, butcher 0
3870414 1980347 1980347 defendant Grene Thomas tailor 591196 591196 Grene, Thomas, of Wendover, tailor 3
3872309 1980963 1980963 defendant Tracher John husbandman 591196 591196 Tracher, John, of Wendover, husbandman 0
3886036 1985580 1985580 defendant Rayner William husbandman 591196 591196 Rayner, William, of Wendover, husbandman 0
3905938 1992270 1992270 defendant Collet William butcher 591196 591196 Collet, William, of Wendover, butcher 0
3917731 1996286 1996286 plaintiff Hare John husbandman 591196 591196 Hare, John, of Wendover, husbandman 0
3917732 1996286 1996286 defendant Andbroke Thomas yeoman 591196 591196 Andbroke, Thomas, of Wendover, yeoman 0
3920970 1997362 1997362 defendant Grover Thomas husbandman 591196 591196 Grover, Thomas, of Wendover, husbandman 0
3937449 2002859 2002859 defendant Wyatt John   591196 591196 Wyatt, John, of Wendover, inn holder 0
3946869 2005974 2005974 defendant Kyppyng Nicholas yeoman 591196 591196 Kyppyng, Nicholas, of Wendover, yeoman 0
3957541 2009702 2009702 defendant Smythe John husbandman 591196 591196 Smythe, John, of Wendover, husbandman 0
3962902 2011619 2011619 defendant Medecalf Christopher clerk 591196 591196 Medecalf, Christopher, of Wendover, clerk 0
3970074 2014131 2014131 defendant Okebanke John husbandman 591196 591196 Okebanke, John, of Wendover, husbandman 0
3970075 2014131 2014131 defendant Bewdon Richard laborer 591196 591196 Bewdon, Richard, of Wendover, laborer 1
3970076 2014131 2014131 defendant Crede Richard laborer 591196 591196 Crede, Richard, of Wendover, laborer 2
3970077 2014131 2014131 defendant Laxton Henry laborer 591196 591196 Laxton, Henry, of Wendover, laborer 3
4023212 2033010 2033010 defendant Okebancke Edmund yeoman 591196 591196 Okebancke, Edmund, of Wendover, yeoman 0
4034814 2037128 2037128 defendant Free Henry yeoman 591196 591196 Free, Henry, of Wendover, yeoman 0
4034815 2037128 2037128 defendant Hyll Joan widow 591196 591196 Hyll, Joan, of Wendover, widow 1
4034816 2037128 2037128 defendant Hyll Nicholas yeoman 591196 591196 Hyll, Nicholas, of Wendover, yeoman 2
4034817 2037128 2037128 defendant Collett Henry yeoman 591196 591196 Collett, Henry, of Wendover, yeoman 3
4034818 2037128 2037128 defendant Kyppyng Nicholas yeoman 591196 591196 Kyppyng, Nicholas, of Wendover, yeoman 4
4047739 2041639 2041639 defendant Whelpley Thomas   591196 591196 Whelpley, Thomas, of Wendover, wheelwright 0
4052060 2043160 2043160 defendant Okebancke Edmund yeoman 591196 591196 Okebancke, Edmund, of Wendover, yeoman 0
4052062 2043161 2043161 defendant Okebancke Edmund yeoman 591196 591196 Okebancke, Edmund, of Wendover, yeoman 0
4086491 2055452 2055452 defendant Hyll William yeoman 591196 591196 Hyll, William, of Wendover, yeoman 1
4093713 2058076 2058076 defendant Hill William yeoman 591196 591196 Hill, William, of Wendover, yeoman 1
4104813 2061998 2061998 defendant Frye Henry yeoman 591196 591196 Frye, Henry, of Wendover, yeoman 0
4104815 2061999 2061999 defendant Hyll Nicholas yeoman 591196 591196 Hyll, Nicholas, of Wendover, yeoman 0
4123592 2068739 2068739 defendant Griffyn George yeoman 591196 591196 Griffyn, George, of Wendover, yeoman 1
4128496 2070482 2070482 defendant Hyll Nicholas yeoman 591196 591196 Hyll, Nicholas, of Wendover, yeoman 2
4128500 2070483 2070483 defendant Hill Nicholas yeoman 591196 591196 Hill, Nicholas, of Wendover, yeoman 2
4149937 2078108 2078108 defendant Wyer Henry yeoman 591196 591196 Wyer, Henry, of Wendover, yeoman 1
4203390 2096735 2096735 defendant Trye Edmund yeoman 591196 591196 Trye, Edmund, of Wendover, yeoman 1
4216474 2101256 2101256 defendant Gybson Christopher yeoman 591196 591196 Gybson, Christopher, of Wendover, yeoman 0
4217841 2101731 2101731 defendant Wrighte George gent 591196 591196 Wrighte, George, of Wendover, gent 0
4301504 2130641 2130641 defendant Hill Barnard yeoman 591196 591196 Hill, Barnard, of Wendover, yeoman 0
4301505 2130641 2130641 defendant Fulkes William husbandman 591196 591196 Fulkes, William, of Wendover, husbandman 1
4302581 2131019 2131019 defendant Ledgingham Michael gent 591196 591196 Ledgingham, Michael, of Wendover, gent 0
4326654 2139274 2139274 defendant Colson Christopher husbandman 591196 591196 Colson, Christopher, of Wendover, husbandman 1
4352951 2148261 2148261 defendant Bacon Nicholas gent 591196 591196 Bacon, Nicholas, of Wendover, gent 0
4382760 2158939 2158939 defendant Wrighte George gent 591196 591196 Wrighte, George, of Wendover, gent 0
4392099 2161983 2161983 defendant Humfry John   591196 591196 Humfry, John, of Wendover, wheelwright 3
4406304 2166675 2166675 defendant Bacon Nicholas gent 591196 591196 Bacon, Nicholas, of Wendover, gent 0
4458167 2187589 2187589 plaintiff Purchas John   591196 591196 Purchas, John, of Wendover 0
4458168 2187589 2187589 defendant Tylere William   591196 591196 Tylere, William, of Wendover 0
4488385 2197084 2197084 defendant Hunte Thomas   591196 591196 Hunte, Thomas, of Wendover 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);