names

342 rows where place_id = 586935

✎ 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
3590029 1864520 1864520 defendant Wynshyp William drover 586935 586935 Wynshyp, William, of Royston, drover 0
3623231 1874793 1874793 defendant Mettam John draper 586935 586935 Mettam, John, of Royston, draper 0
3623232 1874793 1874793 defendant Mettam Katherine widow 586935 586935 Mettam, Katherine, of Royston, widow 1
3627414 1903429 1903429 defendant Marshall Robert chapman 586935 586935 Marshall, Robert, of Royston, chapman 1
3630501 1904372 1904372 defendant Gery Richard gent 586935 586935 Gery, Richard, of Royston, gent 0
3636583 1906233 1906233 defendant Wylys William yeoman 586935 586935 Wylys, William, of Royston, yeoman 0
3641036 1907635 1907635 defendant Burre Thomas maltman 586935 586935 Burre, Thomas, of Royston, maltman 0
3648217 1909840 1909840 defendant Marshall Richard chapman 586935 586935 Marshall, Richard, of Royston, chapman 3
3654950 1911810 1911810 defendant Gery Richard gent 586935 586935 Gery, Richard, of Royston, gent 0
3658428 1912887 1912887 defendant White Robert   586935 586935 White, Robert, of Royston, prior 0
3663308 1914448 1914448 defendant Badewey Thomas smith 586935 586935 Badewey, Thomas, of Royston, smith 2
3663327 1914453 1914453 defendant Whyte Robert   586935 586935 Whyte, Robert, of Royston, prior 0
3665563 1915180 1915180 defendant Wyllons Thomas husbandman 586935 586935 Wyllons, Thomas, of Royston, husbandman 0
3665564 1915180 1915180 defendant Ussher Thomas husbandman 586935 586935 Ussher, Thomas, of Royston, husbandman 1
3667210 1915680 1915680 plaintiff (not given) Robert prior of Whyte 586935 586935 Whyte, Robert, of Royston, prior of the Priory 0
3667211 1915680 1915680 defendant Wyllowes Thomas husbandman & inn holder 586935 586935 Wyllowes, Thomas, of Royston, husbandman & inn holder 0
3674971 1918203 1918203 defendant Sturdy Ralph roper 586935 586935 Sturdy, Ralph, of Royston, roper 2
3675094 1918242 1918242 defendant Wyllowys Thomas husbandman 586935 586935 Wyllowys, Thomas, of Royston, husbandman 2
3675095 1918242 1918242 defendant Ussher Thomas draper 586935 586935 Ussher, Thomas, of Royston, draper 3
3675607 1918406 1918406 defendant Wyllowys Thomas innholder 586935 586935 Wyllowys, Thomas, of Royston, innholder 0
3690534 1923205 1923205 defendant Wyllowes Thomas innholder 586935 586935 Wyllowes, Thomas, of Royston, innholder 1
3691287 1923433 1923433 defendant Clerk Richard gent 586935 586935 Clerk, Richard, of Royston, gent 0
3691288 1923433 1923433 defendant Raynes Hugh yeoman 586935 586935 Raynes, Hugh, of Royston, yeoman 1
3696809 1925227 1925227 defendant Ramkyn William   586935 586935 Ramkyn, William, of Royston, wax chandler 1
3700051 1926248 1926248 defendant Seson John innholder 586935 586935 Seson, John, of Royston, innholder 2
3718290 1932005 1932005 defendant Chamber William yeoman 586935 586935 Chamber, William, of Royston, yeoman 0
3732854 1936504 1936504 defendant Benkys Anne widow 586935 586935 Benkys, Anne, of Royston, widow 0
3732855 1936504 1936504 defendant Benkys John husbandman 586935 586935 Benkys, John, of Royston, husbandman 1
3732856 1936504 1936504 defendant Benkys William husbandman 586935 586935 Benkys, William, of Royston, husbandman 2
3744882 1940299 1940299 defendant Assherey John schoolmaster 586935 586935 Assherey, John, of Royston, schoolmaster 0
3755932 1943808 1943808 defendant Martiris Thomas   586935 586935 Martiris, Thomas, of Royston 1
3755934 1943808 1943808 defendant Rowse John yeoman 586935 586935 Rowse, John, of Royston, yeoman 3
3755935 1943808 1943808 defendant Raynes Hugh yeoman 586935 586935 Raynes, Hugh, of Royston, yeoman 4
3755936 1943808 1943808 defendant Butler Thomas yeoman 586935 586935 Butler, Thomas, of Royston, yeoman 5
3759091 1944829 1944829 defendant Jacob John innholder 586935 586935 Jacob, John, of Royston, innholder 0
3761175 1945498 1945498 defendant Ussher Thomas yeoman 586935 586935 Ussher, Thomas, of Royston, yeoman 1
3763316 1946159 1946159 defendant Wolston William weaver 586935 586935 Wolston, William, of Royston, weaver 1
3763546 1946233 1946233 defendant Clerk John (legal representative) 586935 586935 Clerk, John, of Royston, executrix of 0
3763547 1946233 1946233 defendant Clerke Elizabeth widow 586935 586935 Clerke, Elizabeth, of Royston, widow 1
3763549 1946234 1946234 defendant Clerke John (legal representative) 586935 586935 Clerke, John, of Royston, executrix of 0
3763550 1946234 1946234 defendant Clerke Elizabeth widow 586935 586935 Clerke, Elizabeth, of Royston, widow 1
3770871 1948576 1948576 defendant Wyllows John innholder 586935 586935 Wyllows, John, of Royston, innholder 0
3772123 1948974 1948974 defendant Toller Richard sawyer 586935 586935 Toller, Richard, of Royston, sawyer 1
3772124 1948974 1948974 defendant Lavender William sawyer 586935 586935 Lavender, William, of Royston, sawyer 2
3774876 1949872 1949872 defendant Willons Thomas innholder 586935 586935 Willons, Thomas, of Royston, innholder 1
3782759 1952353 1952353 plaintiff Jacob John   586935 586935 Jacob, John,of Royston 0
3789874 1954658 1954658 defendant Goldsmyth Robert yeoman 586935 586935 Goldsmyth, Robert, of Royston, yeoman 3
3790029 1954703 1954703 defendant Jacob John innholder 586935 586935 Jacob, John, of Royston, innholder 0
3790491 1954848 1954848 defendant Reynold William innholder 586935 586935 Reynold, William, of Royston, innholder 4
3792558 1955530 1955530 defendant Willowes Thomas innholder 586935 586935 Willowes, Thomas, of Royston, innholder 1
3802059 1958541 1958541 defendant Newton Thomas tailor 586935 586935 Newton, Thomas, of Royston, tailor 0
3803260 1958924 1958924 defendant Newton Thomas tailor 586935 586935 Newton, Thomas, of Royston, tailor 0
3811544 1961506 1961506 defendant Porter Richard laborer 586935 586935 Porter, Richard, of Royston, laborer 0
3863872 1978091 1978091 defendant Sewell John yeoman and innholder 586935 586935 Sewell, John, of Royston, yeoman and innholder 3
3866672 1979086 1979086 defendant Sneull Christopher butcher 586935 586935 Sneull, Christopher, of Royston, butcher 1
3905700 1992183 1992183 defendant Edwardes William   586935 586935 Edwardes, William, of Royston, ploughwright 0
3909684 1993547 1993547 defendant Stone William gent 586935 586935 Stone, William, of Royston, gent 0
3913125 1994722 1994722 defendant Raynoldys Thomas yeoman 586935 586935 (Raynoldys, Thomas, of Royston, yeoman 1
3918293 1996454 1996454 defendant Raynold Thomas yeoman 586935 586935 Raynold, Thomas, of Royston, yeoman 0
3923440 1998144 1998144 defendant Wynger George husbandman 586935 586935 Wynger, George, of Royston, husbandman 1
3929787 2000301 2000301 plaintiff Chambres Margaret widow 586935 586935 Chambres, Margaret, of Royston, widow 0
3956639 2009386 2009386 defendant Makerns or Makerus William yeoman 586935 586935 Makerns or Makerus, William, of Royston, yeoman 1
3959810 2010524 2010524 plaintiff Snell or Suell John, senior butcher 586935 586935 Snell or Suell, John, senior, of Royston, butcher 0
3959811 2010524 2010524 plaintiff Dyxe John mercer 586935 586935 Dyxe, John, of Royston, mercer 1
3963279 2011759 2011759 defendant Greneakers Henry innholder 586935 586935 Greneakers, Henry, of Royston, innholder 0
3963280 2011759 2011759 defendant Greneakers Agnes widow of Lawrence Ebden alias Stone 586935 586935 Agnes his wife, alias Agnes Ebden alias Stone, of Royston, widow of Lawrence Ebden alias Stone 1
3965585 2012577 2012577 defendant Turner James   586935 586935 Turner, James, of Royston, tallow chandler 0
3967892 2013398 2013398 plaintiff Campyon John yeoman 586935 586935 Campyon, John, of Royston, yeoman 0
3973719 2015382 2015382 defendant Greneacre Henry gent 586935 586935 Greneacre, Henry, of Royston, gent 0
4055884 2044486 2044486 plaintiff Bolton James yeoman 586935 586935 Bolton, James, of Royston, yeoman 0
4066120 2048171 2048171 defendant Denton Richard carpenter 586935 586935 Denton, Richard, of Royston, carpenter 1
4083303 2054312 2054312 defendant Turston Henry clerk 586935 586935 Turston, Henry, of Royston, clerk 5
4085833 2055208 2055208 defendant Harvy Richard laborer 586935 586935 Harvy, Richard, of Royston, laborer 1
4085835 2055208 2055208 defendant Mackerell John butcher 586935 586935 Mackerell, John, of Royston, butcher 3
4087930 2055974 2055974 defendant Byrde Henry yeoman 586935 586935 Byrde, Henry, of Royston, yeoman 0
4087932 2055975 2055975 defendant Byrde Henry yeoman 586935 586935 Byrde, Henry, of Royston, yeoman 0
4101883 2060984 2060984 defendant Crouche John saddler 586935 586935 Crouche, John, of Royston, saddler 0
4101884 2060984 2060984 defendant Fylwood Barnard yeoman 586935 586935 Fylwood, Barnard, of Royston, yeoman 1
4101885 2060984 2060984 defendant Carter Robert yeoman 586935 586935 Carter, Robert, of Royston, yeoman 2
4113742 2065199 2065199 defendant Moore John blacksmith 586935 586935 Moore, John, of Royston, blacksmith 0
4121103 2067840 2067840 defendant Ashewell Thomas tailor 586935 586935 Ashewell, Thomas, of Royston, tailor 0
4121104 2067840 2067840 defendant Fennynge Jerome laborer 586935 586935 Fennynge, Jerome, of Royston, laborer 1
4126492 2069757 2069757 defendant Nichols Richard husbandman 586935 586935 Nichols, Richard, of Royston, husbandman 0
4126493 2069757 2069757 defendant Nicolls William husbandman 586935 586935 Nicolls, William, of Royston, husbandman 1
4138222 2074039 2074039 defendant Turton Henry clerk 586935 586935 Turton, Henry, of Royston, clerk 1
4139817 2074604 2074604 defendant Turner James yeoman 586935 586935 Turner, James, of Royston, yeoman 0
4141209 2075084 2075084 defendant Gott Christopher blacksmith 586935 586935 Gott, Christopher, of Royston, blacksmith 0
4141210 2075084 2075084 defendant Bell Edward innholder 586935 586935 Bell, Edward, of Royston, innholder 1
4141211 2075084 2075084 defendant Burham or Barram Samuel maltster 586935 586935 Burham or Barram, Samuel, of Royston, maltster 2
4143772 2075981 2075981 defendant Gote Francis smith 586935 586935 Gote, Francis, of Royston, smith 4
4148520 2077609 2077609 defendant Woode Silvester husbandman 586935 586935 Woode, Silvester, of Royston, husbandman 0
4187818 2091241 2091241 defendant Swann Richard yeoman 586935 586935 Swann, Richard, of Royston, or of Newton, yeoman 1
4187824 2091242 2091242 defendant Fawsett alias Arthure Joan widow 586935 586935 Fawsett alias Arthure, Joan, of Royston, widow 4
4201532 2096081 2096081 defendant Hall John innholder 586935 586935 Hall, John, of Royston, innholder 1
4220136 2102543 2102543 defendant Lumbe Brian husbandman 586935 586935 Lumbe, Brian, of Royston, husbandman 2
4220250 2102587 2102587 defendant Crowche Thomas saddler 586935 586935 Crowche, Thomas, of Royston, saddler 2
4220254 2102588 2102588 defendant Crowche Thomas saddler 586935 586935 Crowche, Thomas, of Royston, saddler 2
4222069 2103210 2103210 defendant Gyll Peter husbandman 586935 586935 Gyll, Peter, of Royston, husbandman 0
4222070 2103210 2103210 defendant Grene Richard husbandman 586935 586935 Grene, Richard, of Royston, husbandman 1
4227228 2105002 2105002 defendant Burram Edward maltster 586935 586935 Burram, Edward, of of Royston, maltster 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);