names

224 rows where place_id = 591291

✎ 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
3603953 1868905 1868905 defendant Warner William clothmaker 591291 591291 Warner, William, of Dedham, Essex, clothmaker 0
3603965 1868908 1868908 defendant Warner William clothmaker 591291 591291 Warner, William, of Dedham, Essex, clothmaker 0
3603970 1868909 1868909 defendant Warner William clothmaker 591291 591291 Warner, William, of Dedham, Essex, clothmaker 0
3616604 1872825 1872825 plaintiff Dunton Stephen clothmaker 591291 591291 Dunton, Stephen, of Dedham, Essex, clothmaker 0
3617863 1873210 1873210 defendant Webbe Thomas clothmaker 591291 591291 Webbe, Thomas, of Dedham, Essex, clothmaker 0
3632196 1904887 1904887 plaintiff Hawke Robert (legal representative) 591291 591291 Hawke, Robert, of Dedham, Essex, yeoman or clothier, executors of 0
3632201 1904888 1904888 plaintiff Hawke Robert (legal representative) 591291 591291 Hawke, Robert, of Dedham, Essex, yeoman, clothier, executors of 0
3658941 1913059 1913059 defendant Buttar Thomas   591291 591291 Buttar, Thomas, of Dedham, Essex, cloth maker 0
3658944 1913060 1913060 defendant Warner Ralph   591291 591291 Warner, Ralph, of Dedham, Essex, cloth maker 0
3658947 1913061 1913061 defendant Warner Ralph   591291 591291 Warner, Ralph, of Dedham, Essex, cloth maker 0
3658950 1913062 1913062 defendant Warner Ralph   591291 591291 Warner, Ralph, of Dedham, Essex, cloth maker 0
3688200 1922459 1922459 plaintiff Craddoke Robert clothman 591291 591291 Craddoke, Robert, of Dedham, Essex, clothman 0
3690042 1923044 1923044 defendant Warner Ralph clothmaker 591291 591291 Warner, Ralph, of Dedham, Essex, clothmaker 0
3690044 1923045 1923045 defendant Laurence John clothmaker 591291 591291 Laurence, John, of Dedham, Essex, clothmaker 0
3734284 1936960 1936960 defendant Laurence John clothmaker 591291 591291 Laurence, John, of Dedham, Essex, clothmaker 1
3734350 1936981 1936981 defendant Blakbourne George yeoman 591291 591291 Blakbourne, George, of Dedham, Essex, yeoman 0
3752640 1942757 1942757 defendant Stafford Thomas husbandman 591291 591291 Stafford, Thomas, of Dedham, Essex, husbandman 0
3758265 1944580 1944580 defendant Webbe Henry yeoman or clothier 591291 591291 Webbe, Henry, of Dedham, Essex, yeoman or clothier 0
3763061 1946079 1946079 defendant Busshe William clothmaker 591291 591291 Busshe, William, of Dedham, Essex, clothmaker 0
3763067 1946080 1946080 defendant Busshe William clothmaker 591291 591291 Busshe, William, of Dedham, Essex, clothmaker 0
3769243 1948035 1948035 defendant Cradok John clothier 591291 591291 Cradok, John, of Dedham, Essex, clothier 0
3769388 1948083 1948083 defendant Waren Ralph clothmaker 591291 591291 Waren, Ralph, of Dedham, Essex, clothmaker 0
3769451 1948106 1948106 defendant Stafford Thomas husbandman 591291 591291 Stafford, Thomas, of Dedham, Essex, husbandman 0
3780233 1951545 1951545 defendant Warner Ralph clothmaker 591291 591291 Warner, Ralph, of Dedham, Essex, clothmaker 0
3780237 1951546 1951546 defendant Warner Ralph clothmaker 591291 591291 Warner, Ralph, of Dedham, Essex, clothmaker 0
3790771 1954941 1954941 defendant Warner Ralph clothman 591291 591291 Warner, Ralph, of Dedham, Essex, clothman 0
3790775 1954942 1954942 defendant Warner Robert clothman 591291 591291 Warner, Robert, of Dedham, Essex, clothman 0
3798585 1957462 1957462 defendant Warner Ralph clothmaker 591291 591291 Warner, Ralph, of Dedham, Essex, clothmaker 1
3808352 1960485 1960485 defendant Warner Ralph clothier 591291 591291 Warner, Ralph, of Dedham, Essex, clothier 0
3808356 1960486 1960486 defendant Warner Ralph clothier 591291 591291 Warner, Ralph, of Dedham, Essex, clothier 1
3814558 1962466 1962466 defendant Petywell Robert clothier 591291 591291 Petywell, Robert, of Dedham, Essex, clothier 0
3863492 1977986 1977986 defendant Webbe Joan widow 591291 591291 Webbe, Joan, of Dedham, Essex, widow 0
3866730 1979107 1979107 defendant Mynott John clothmaker 591291 591291 Mynott, John, of Dedham, Essex, clothmaker 0
3868746 1979786 1979786 defendant Jude James clothier 591291 591291 Jude, James, of Dedham, Essex, clothier 0
3876340 1982332 1982332 plaintiff Gordon John clothmaker 591291 591291 Gordon, John, of Dedham, Essex, clothmaker 0
3876433 1982364 1982364 plaintiff Greneleff John (legal representative) 591291 591291 Greneleff, John, of Dedham, Essex, executors of 0
3882605 1984447 1984447 defendant Spralle Giles clothmaker 591291 591291 Spralle, Giles, of Dedham, Essex, clothmaker 0
3901743 1990805 1990805 defendant Horres Thomas clothier 591291 591291 Horres, Thomas, of Dedham, Essex, clothier 0
3904351 1991704 1991704 defendant Butler William clothman 591291 591291 Butler, William, of Dedham, Essex, clothman 0
3913602 1994887 1994887 defendant Clerke Richard clothier 591291 591291 Clerke, Richard, of Dedham, Essex, clothier 0
3917747 1996291 1996291 defendant Orreys Thomas clothier 591291 591291 Orreys, Thomas, of Dedham, Essex, clothier 0
3917901 1996349 1996349 defendant Wollman John clothier 591291 591291 Wollman, John, of Dedham, Essex, clothier 1
3921022 1997379 1997379 plaintiff Orreys Thomas clothmaker 591291 591291 Orreys, Thomas, of Dedham, Essex, clothmaker 0
3924357 1998456 1998456 defendant Orreas Thomas clothier 591291 591291 Orreas, Thomas, of Dedham, Essex, clothier 1
3927134 1999411 1999411 plaintiff Addeson Nicholas clothier 591291 591291 Addeson, Nicholas, of Dedham, Essex, clothier 0
3927771 1999627 1999627 defendant Rolff Robert clothier 591291 591291 Rolff, Robert, of Dedham, Essex, clothier 1
3930130 2000422 2000422 defendant Barwyk Robert clothier 591291 591291 Barwyk, Robert, of Dedham, Essex, clothier 0
3930461 2000535 2000535 defendant Cane Richard clothier 591291 591291 Cane, Richard, of Dedham, Essex, clothier 0
3939663 2003572 2003572 defendant Cane Richard clothier 591291 591291 Cane, Richard, of Dedham, Essex, clothier 0
3944071 2005035 2005035 defendant Warner William clothier 591291 591291 Warner, William, of Dedham, Essex, clothier 0
3946476 2005837 2005837 defendant Browne Martin clothier 591291 591291 Browne, Martin, of Dedham, Essex, clothier 0
3950487 2007247 2007247 defendant Barker alias Payne John miller 591291 591291 Barker alias Payne, John, of Dedham, Essex, miller 1
3951864 2007712 2007712 defendant Clerke Richard husbandman 591291 591291 Clerke, Richard, of Dedham, Essex, husbandman 0
3955574 2009019 2009019 plaintiff Maye John   591291 591291 Maye, John, of Dedham, Essex 0
3962134 2011338 2011338 defendant Williams alias Foteman Philip yeoman 591291 591291 Williams alias Foteman, Philip, of Dedham, Essex, yeoman 0
3962252 2011379 2011379 defendant Barwyck Robert clothier 591291 591291 Barwyck, Robert, of Dedham, Essex, clothier 1
3968787 2013711 2013711 defendant Sterlynge Ralph clothier 591291 591291 Sterlynge, Ralph, of Dedham, Essex, clothier 0
3968791 2013712 2013712 defendant Woodhowse John clothier 591291 591291 (Woodhowse, John, of Dedham, Essex, clothier 1
3968880 2013743 2013743 defendant Raven Henry clothier 591291 591291 Raven, Henry, of Dedham, Essex, clothier 2
3973985 2015471 2015471 defendant Warner John clothier 591291 591291 Warner, John, of Dedham, Essex, clothier 1
3980805 2017898 2017898 defendant Mykylfyld Thomas butcher 591291 591291 Mykylfyld, Thomas, of Dedham, Essex, butcher 0
3983571 2018892 2018892 defendant Warner William clothier 591291 591291 Warner, William, of Dedham, Essex, clothier 0
3984846 2019335 2019335 defendant Carter Thomas yeoman 591291 591291 Carter, Thomas, of Dedham, Essex, yeoman 0
4001021 2025139 2025139 defendant Starlyng Ralph clothier 591291 591291 Starlyng, Ralph, of Dedham, Essex, clothier 0
4001561 2025338 2025338 defendant Ellynatte Thomas clerk 591291 591291 Ellynatte, Thomas, of Dedham, Essex, clerk 1
4015859 2030359 2030359 plaintiff Sparhawke Lewis   591291 591291 Sparhawke, Lewis, of Dedham, Essex 0
4018223 2031242 2031242 defendant Warner William clothier 591291 591291 Warner, William, of Dedham, Essex, clothier 0
4020412 2032023 2032023 defendant Starlyng Ralph clothier 591291 591291 Starlyng, Ralph, of Dedham, Essex, clothier 0
4036390 2037698 2037698 defendant Neberd William clothier 591291 591291 Neberd, William, of Dedham, Essex, clothier 0
4037700 2038135 2038135 defendant Raven Henry clothier 591291 591291 Raven, Henry, of Dedham, Essex, clothier 0
4039352 2038701 2038701 plaintiff Lytlebury William clothier 591291 591291 Lytlebury, William, of Dedham, Essex, clothier 0
4058419 2045397 2045397 defendant Grene John   591291 591291 Grene, John, of Dedham, Essex, millwright 0
4067317 2048613 2048613 plaintiff Indye or Judye Nicholas clothier 591291 591291 Indye or Judye, Nicholas, of Dedham, Essex, clothier 0
4094241 2058276 2058276 defendant Warner William clothier 591291 591291 Warner, William, of Dedham, Essex, clothier 0
4120359 2067555 2067555 defendant Sparhawke Lewis chapman 591291 591291 Sparhawke, Lewis, of Dedham, Essex, chapman 0
4123958 2068867 2068867 defendant Vaysey Richard clothier 591291 591291 Vaysey, Richard, of Dedham, Essex, clothier 0
4130731 2071301 2071301 defendant Wood Clement clothier 591291 591291 Wood, Clement, of Dedham, Essex, clothier 0
4144460 2076224 2076224 defendant Parker Wistan clothier 591291 591291 Parker, Wistan, of Dedham, Essex, clothier 0
4193290 2093219 2093219 defendant Dunton William clothier 591291 591291 Dunton, William, of Dedham, Essex, clothier 0
4223695 2103773 2103773 defendant Freman Robert clothier 591291 591291 Freman, Robert, of Dedham, Essex, clothier 0
4231262 2106434 2106434 defendant Cole Thomas clothier 591291 591291 Cole, Thomas, of Dedham, Essex, clothier 0
4239218 2109341 2109341 defendant Freman Robert clothier 591291 591291 Freman, Robert, of Dedham, Essex, clothier 3
4239221 2109342 2109342 defendant Lufkyn Nathaniel clothier 591291 591291 Lufkyn, Nathaniel, of Dedham, Essex, clothier 1
4239224 2109343 2109343 defendant Lufkyn Nathaniel clothier 591291 591291 Lufkyn, Nathaniel, of Dedham, Essex, clothier 1
4239230 2109344 2109344 defendant Sandford Henry clothier 591291 591291 Sandford, Henry, of Dedham, Essex, clothier 2
4241612 2110180 2110180 defendant Vesie Lawrence clother 591291 591291 Vesie, Lawrence, of Dedham, Essex, clother 2
4241876 2110275 2110275 defendant Sharpe Thomas clothier 591291 591291 Sharpe, Thomas, of Dedham, Essex, clothier 0
4245224 2111386 2111386 defendant Skynner Stephen clothier 591291 591291 Skynner, Stephen, of Dedham, Essex, clothier 2
4255551 2114841 2114841 defendant Crowe Michael clothier 591291 591291 Crowe, Michael, of Dedham, Essex, clothier 0
4255665 2114868 2114868 defendant Freman Robert clothier 591291 591291 Freman, Robert, of Dedham, Essex, clothier 0
4261373 2116769 2116769 defendant Sandford Henry clothier 591291 591291 Sandford, Henry, of Dedham, Essex, clothier 1
4261376 2116770 2116770 defendant Luskyn Nathaniel clothier 591291 591291 Luskyn, Nathaniel, of Dedham, Essex, clothier 1
4261380 2116771 2116771 defendant Luskyn Nathaniel clothier 591291 591291 Luskyn, Nathaniel, of Dedham, Essex, clothier 1
4267934 2118907 2118907 defendant Crowe Michael clothier 591291 591291 Crowe, Michael, of Dedham, Essex, clothier 0
4268049 2118931 2118931 defendant Freman Robert clothier 591291 591291 Freman, Robert, of Dedham, Essex, clothier 2
4284144 2124375 2124375 defendant Sherman Edmund clothier 591291 591291 Sherman, Edmund, of Dedham, Essex, clothier 0
4303081 2131205 2131205 defendant Sparhawe Samuel grocer 591291 591291 Sparhawe, Samuel, of Dedham, Essex, grocer 0
4307532 2132772 2132772 defendant Butter William clothier 591291 591291 Butter, William, of Dedham, Essex, clothier 0
4321321 2137548 2137548 defendant Turner Robert yeoman 591291 591291 Turner, Robert, of Dedham, Essex, yeoman 3
4339561 2143605 2143605 defendant Morphewe John clothier 591291 591291 Morphewe, John, of Dedham, Essex, clothier 3

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