names

207 rows where place_id = 588220

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593772 1865689 1865689 defendant Davy John butcher 588220 588220 Davy, John, of Wesenham, butcher 0
3594481 1865902 1865902 defendant Cooke John laborer 588220 588220 Cooke, John, of Wesenham, laborer 0
3595307 1866164 1866164 defendant Byrd John husbandman 588220 588220 Byrd, John, of Wesenham, husbandman 2
3608069 1870176 1870176 defendant Anger or Auger Clement butcher 588220 588220 Anger or Auger, Clement, of Wesenham, butcher 1
3613608 1871901 1871901 defendant Houell or Hovell Richard husbandman 588220 588220 Houell or Hovell, Richard, of Wesenham, husbandman 3
3642537 1908108 1908108 defendant Came Mathew yeaman 588220 588220 Came, Mathew, of Wesenham, yeaman 1
3656211 1912189 1912189 plaintiff Camme Mathew yeoman 588220 588220 Camme, Mathew, of Wesenham, yeoman 0
3663826 1914620 1914620 defendant Malster Thomas   588220 588220 Malster, Thomas, of Wesenham, shepherd 3
3663827 1914620 1914620 defendant Mayne Robert husbandman 588220 588220 Mayne, Robert, of Wesenham, husbandman 4
3670857 1916849 1916849 defendant Camme Mathew yeoman 588220 588220 Camme, Mathew, of Wesenham, yeoman 2
3689131 1922762 1922762 defendant Edryche Thomas husbandman 588220 588220 Edryche, Thomas, of Wesenham, husbandman 1
3710525 1929614 1929614 plaintiff Skyppon Thomas   588220 588220 Skyppon, Thomas, of Wesenham 0
3714758 1930918 1930918 defendant Skyppon Thomas yeoman 588220 588220 Skyppon, Thomas, of Wesenham, yeoman 1
3715699 1931200 1931200 defendant Mayn Robert yeoman 588220 588220 Mayn, Robert, of Wesenham St Peter, yeoman 2
3719156 1932275 1932275 defendant Lyon Richard yeoman 588220 588220 Lyon, Richard, of Wesenham, yeoman 3
3721191 1932928 1932928 defendant Broun Thomas butcher 588220 588220 Broun, Thomas, of Wesenham, butcher 0
3721357 1932987 1932987 defendant Edwardys John yeoman 588220 588220 Edwardys, John, of Wesenham, yeoman 0
3721358 1932987 1932987 defendant Mayn Robert yeoman 588220 588220 Mayn, Robert, of Wesenham, yeoman 1
3725185 1934164 1934164 defendant Fuller Robert laborer 588220 588220 Fuller, Robert, of Wesenham, laborer 0
3725186 1934164 1934164 defendant Laws William laborer 588220 588220 Laws, William, of Wesenham, laborer 1
3725187 1934164 1934164 defendant Ederyche Thomas laborer 588220 588220 Ederyche, Thomas, of Wesenham, laborer 2
3734331 1936975 1936975 defendant Mayn Robert yeoman 588220 588220 Mayn, Robert, of Wesenham, yeoman 3
3737384 1937929 1937929 defendant Yelverton John gent 588220 588220 Yelverton, John, of Wesenham, gent 0
3741081 1939073 1939073 defendant Pengell John husbandman 588220 588220 Pengell, John, of Wesenham, husbandman 1
3748550 1941479 1941479 defendant Sart Thomas chaplain 588220 588220 Sart, Thomas, of Wesenham, chaplain 2
3749246 1941691 1941691 defendant Bayly Thomas   588220 588220 Bayly, Thomas, of Wesenham, shepherd 0
3754961 1943500 1943500 defendant Johnson Geoffrey butcher 588220 588220 Johnson, Geoffrey, of Wesenham, butcher 3
3755534 1943689 1943689 plaintiff Wright William (legal representative) 588220 588220 Wright, William, of Wesenham, executor of 0
3763276 1946147 1946147 defendant Coke Thomas husbandman 588220 588220 Coke, Thomas, of Wesenham, husbandman 0
3771046 1948632 1948632 defendant Coke Thomas yeoman 588220 588220 Coke, Thomas, of Wesenham, yeoman 0
3771047 1948632 1948632 defendant Coke William yeoman 588220 588220 Coke, William, of Wesenham, yeoman 1
3775054 1949929 1949929 defendant Cooke William husbandman 588220 588220 Cooke, William, of Wesenham, husbandman 3
3775055 1949929 1949929 defendant Cooke Thomas husbandman 588220 588220 Cooke, Thomas, of Wesenham, husbandman 4
3791248 1955097 1955097 plaintiff Wright William (legal representative) 588220 588220 Wright, William, of Wesenham, executor of 0
3791251 1955098 1955098 plaintiff Wright William (legal representative) 588220 588220 Wright, William, of Wesenham, executor of 0
3799541 1957777 1957777 defendant Edwardys John husbandman 588220 588220 Edwardys, John, of Wesenham, husbandman 0
3802488 1958676 1958676 defendant Cooke Thomas husbandman 588220 588220 Cooke, Thomas, of Wesenham, husbandman 4
3802489 1958676 1958676 defendant Cooke William husbandman 588220 588220 Cooke, William, of Wesenham, husbandman 5
3805002 1959509 1959509 defendant Coke William yeoman 588220 588220 Coke, William,of Wesenham, yeoman 0
3805945 1959797 1959797 defendant Hamond John tailor 588220 588220 Hamond, John, of Wesenham, tailor 0
3808381 1960495 1960495 defendant Skypon Thomas yeoman 588220 588220 Skypon, Thomas, of Wesenham, yeoman 1
3813031 1961982 1961982 defendant Johnson Geoffrey (legal representative) 588220 588220 Johnson, Geoffrey, of Wesenham, butcher, administratrix of 0
3813032 1961982 1961982 defendant Johnson Isabel widow 588220 588220 Johnson, Isabel, of Wesenham, widow 1
3820818 1964402 1964402 defendant Coke Thomas husbandman 588220 588220 Coke, Thomas, of Wesenham, husbandman 1
3825612 1965862 1965862 defendant Wryght Thomas husbandman 588220 588220 Wryght, Thomas, of Wesenham, husbandman 0
3825616 1965864 1965864 defendant Elwyn John   588220 588220 Elwyn, John, of Wesenham, shepherd 0
3825618 1965865 1965865 defendant Skyppon Luke laborer 588220 588220 Skyppon, Luke, of Wesenham, laborer 0
3825619 1965865 1965865 defendant Skyppon Thomas, junior laborer 588220 588220 Skyppon, Thomas, junior, of Wesenham, laborer 1
3825622 1965865 1965865 defendant Wright Thomas husbandman 588220 588220 Wright, Thomas, of Wesenham, husbandman 4
3829714 1967186 1967186 defendant Johnson William butcher 588220 588220 Johnson, William, of Wesenham, butcher 0
3830244 1967352 1967352 defendant Warde John husbandman 588220 588220 Warde, John, of Wesenham, husbandman 0
3830251 1967355 1967355 defendant Elwyn John husbandman 588220 588220 Elwyn, John, of Wesenham, husbandman 0
3846207 1972369 1972369 defendant Gowty John weaver 588220 588220 Gowty, John, of Wesenham, weaver 0
3846589 1972486 1972486 defendant Mathewe Thomas husbandman 588220 588220 Mathewe, Thomas, of Wesenham, husbandman 1
3846747 1972536 1972536 defendant Purveys Thomas husbandman 588220 588220 Purveys, Thomas, of Wesenham, husbandman 3
3851588 1974084 1974084 defendant Buntyng Robert roper 588220 588220 Buntyng, Robert, of Wesenham, roper 0
3852373 1974343 1974343 defendant Cook Thomas husbandman 588220 588220 Cook, Thomas, of Wesenham, husbandman 3
3852374 1974343 1974343 defendant Cook William husbandman 588220 588220 Cook, William, of Wesenham, husbandman 4
3853234 1974630 1974630 plaintiff Shippon Thomas, senior   588220 588220 Shippon, Thomas, senior, of Wesenham 0
3853831 1974830 1974830 defendant Buntyng Robert roper 588220 588220 Buntyng, Robert, of Wesenham, roper 0
3853832 1974830 1974830 defendant Pyngyll William husbandman 588220 588220 Pyngyll, William, of Wesenham, husbandman 1
3858777 1976421 1976421 defendant Scrybe Andrew blacksmith 588220 588220 Scrybe, Andrew, of Wesenham St Peter, blacksmith 0
3858778 1976421 1976421 defendant Skyppon Thomas husbandman 588220 588220 Skyppon, Thomas, of Wesenham St Peter, husbandman 1
3867813 1979467 1979467 defendant Shreef Andrew smith 588220 588220 Shreef, Andrew, of Wesenham, smith 0
3867814 1979467 1979467 defendant Warde John husbandman 588220 588220 Warde, John, of Wesenham, husbandman 1
3867815 1979467 1979467 defendant Smyth John carpenter 588220 588220 Smyth, John, of Wesenham, carpenter 2
3877380 1982680 1982680 defendant Maxe Richrad husbandman 588220 588220 Maxe, Richrad, of Wesenham, husbandman 0
3882110 1984275 1984275 defendant Buntyng Robert roper 588220 588220 Buntyng, Robert, of Wesenham, roper 0
3882111 1984275 1984275 defendant Skyppon Thomas yeoman 588220 588220 Skyppon, Thomas, of Wesenham, yeoman 1
3882112 1984275 1984275 defendant Pyngyll John husbandman 588220 588220 Pyngyll, John, of Wesenham, husbandman 2
3909407 1993447 1993447 plaintiff Skyppon Thomas, senior (legal representative) 588220 588220 Skyppon, Thomas, senior, of Wesenham, executors of 0
3909411 1993447 1993447 defendant Shreve Andrew blacksmith 588220 588220 Shreve, Andrew, of Wesenham St Peter, blacksmith 0
3946611 2005882 2005882 defendant Skippon Luke yeoman 588220 588220 Skippon, Luke, of Wesenham St Peter, yeoman 1
3949524 2006906 2006906 plaintiff Elwyn John   588220 588220 Elwyn, John, of Wesenham 0
3950952 2007402 2007402 defendant Smyth Nicholas yeoman 588220 588220 Smyth, Nicholas, of Wesenham, yeoman 0
3970225 2014183 2014183 defendant Forbye Margery widow 588220 588220 Forbye, Margery, of Wesenham, widow 3
3971968 2014753 2014753 plaintiff Forby Hillary yeoman 588220 588220 Forby, Hillary, of Wesenham St Peter, yeoman 0
3983304 2018801 2018801 plaintiff Smythe Nicholas yeoman 588220 588220 Smythe, Nicholas, of Wesenham, yeoman 0
4005254 2026660 2026660 plaintiff Kett Richard yeoman 588220 588220 Kett, Richard, of Wesenham, yeoman 0
4005256 2026661 2026661 plaintiff Kett Richard yeoman 588220 588220 Kett, Richard, of Wesenham, yeoman 0
4013734 2029643 2029643 defendant Smyth Nicholas yeoman 588220 588220 Smyth, Nicholas, of Wesenham, yeoman 0
4015289 2030162 2030162 defendant Balye William   588220 588220 Balye, William, of Wesenham, shepherd 0
4015339 2030180 2030180 plaintiff Smyth Nicholas yeoman 588220 588220 Smyth, Nicholas, of Wesenham, yeoman 0
4053264 2043548 2043548 defendant Aldreed Edmund laborer 588220 588220 Aldreed, Edmund, of Wesenham, laborer 4
4075152 2051416 2051416 defendant Algar William grocer 588220 588220 Algar, William, of Wesenham, grocer 0
4076038 2051725 2051725 defendant Algar William grocer 588220 588220 Algar, William, of Wesenham, grocer 0
4118499 2066908 2066908 defendant Barton Hillary husbandman 588220 588220 Barton, Hillary, of Wesenham, husbandman 0
4153938 2079473 2079473 defendant Algar William grocer 588220 588220 Algar, William, of Wesenham, grocer 2
4213445 2100221 2100221 defendant Elmeden George yeoman 588220 588220 Elmeden, George, of Wesenham, yeoman 1
4218865 2102093 2102093 defendant Newarke William gent 588220 588220 Newarke, William, of Wesenham, gent 1
4221725 2103092 2103092 defendant Powlie Nicholas yeoman 588220 588220 Powlie, Nicholas, of Wesenham, yeoman 0
4227937 2105254 2105254 defendant Newarke William gent 588220 588220 Newarke, William, of Wesenham, gent 2
4247446 2112128 2112128 defendant Powlie Nicholas yeoman 588220 588220 Powlie, Nicholas, of Wesenham, yeoman 0
4249763 2112902 2112902 defendant Denny Thomas yeoman 588220 588220 Denny, Thomas, of Wesenham, yeoman 0
4261039 2116657 2116657 defendant Catton Luke tailor 588220 588220 Catton, Luke, of Wesenham, tailor 1
4286181 2125111 2125111 defendant Elmeden George yeoman 588220 588220 Elmeden, George, of Wesenham, yeoman 0
4354122 2148668 2148668 defendant Clarke Thomas husbandman 588220 588220 Clarke, Thomas, of Wesenham St Peter, husbandman 0
4354123 2148668 2148668 defendant Bateman William husbandman 588220 588220 Bateman, William, of Wesenham St Peter, husbandman 1
4388099 2160648 2160648 defendant Kynge Richard clerk 588220 588220 Kynge, Richard, of Wesenham, clerk 1
4388100 2160648 2160648 defendant Davye Henry husbandman 588220 588220 Davye, Henry, of Wesenham, husbandman 2

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