names

258 rows where place_id = 585937

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587532 1863748 1863748 defendant Coweper Thomas clothmaker 585937 585937 Coweper, Thomas, of Bylston, clothmaker 3
3590044 1864525 1864525 defendant Rowe John yeoman 585937 585937 Rowe, John, of Bylston, yeoman 2
3590087 1864540 1864540 defendant Roo John husbandman 585937 585937 Roo, John, of Bylston, husbandman 0
3592015 1865117 1865117 defendant Hewet John carpenter 585937 585937 Hewet, John, of Bylston, carpenter 0
3592016 1865117 1865117 defendant Screvener Richard husbandman 585937 585937 Screvener, Richard, of Bylston, husbandman 1
3597214 1866753 1866753 defendant Carter Alexander pedder 585937 585937 Carter, Alexander, of Bylston, pedder 1
3603235 1868681 1868681 defendant Bryght Robert merchant 585937 585937 Bryght, Robert, of Bylston, merchant 0
3606155 1869594 1869594 defendant Cook John clothmaker 585937 585937 Cook, John, of Bylston, clothmaker 0
3613303 1871810 1871810 defendant Wright Robert baker 585937 585937 Wright, Robert, of Bylston, baker 2
3616330 1872746 1872746 defendant Cook John clothmaker 585937 585937 Cook, John, of Bylston, clothmaker 0
3628332 1903722 1903722 defendant Coole John   585937 585937 Coole, John, of Bylston, Suff yeoman 0
3630803 1904456 1904456 defendant Parker Henry clothman 585937 585937 Parker, Henry, of Bylston, clothman 0
3631038 1904529 1904529 defendant Osmunde John tailor 585937 585937 Osmunde, John, of Bylston, tailor 1
3631040 1904529 1904529 defendant Fuller John laborer 585937 585937 Fuller, John, of Bylston, laborer 3
3638305 1906798 1906798 defendant Osmond John tailor 585937 585937 Osmond, John, of Bylston, tailor 0
3640636 1907512 1907512 defendant Gybroke William shoemaker 585937 585937 Gybroke, William, of Bylston, shoemaker 4
3648910 1910047 1910047 defendant Downyng Robert weaver 585937 585937 Downyng, Robert, of Bylston, weaver 0
3652517 1911118 1911118 defendant Grene John, junior grasier 585937 585937 Grene, John, junior, of Bylston, grasier 1
3652521 1911119 1911119 defendant Grene John, junior grasier 585937 585937 Grene, John, junior, of Bylston, grasier 1
3665350 1915115 1915115 defendant Laman John husbandman 585937 585937 Laman, John, of Bylston, husbandman 3
3685453 1921601 1921601 defendant Wryght Robert (legal representative) 585937 585937 Wryght, Robert, of Bylston, husbandman, administratrix of 0
3685454 1921601 1921601 defendant Wryght Agnes widow 585937 585937 Wryght, Agnes, of Bylston, widow 1
3685456 1921602 1921602 defendant Wryghte Robert (legal representative) 585937 585937 Wryghte, Robert, of Bylston, husbandman, administratrix of 0
3685457 1921602 1921602 defendant Wryght Agnes widow 585937 585937 Wryght, Agnes, of Bylston, widow 1
3694491 1924482 1924482 defendant Carter John shoemaker 585937 585937 Carter, John, of Bylston, shoemaker 0
3694500 1924486 1924486 defendant Grenewode John yeoman 585937 585937 Grenewode, John, of Bylston, yeoman 0
3696212 1925036 1925036 defendant Andrewe John weaver 585937 585937 Andrewe, John, of Bylston, weaver 0
3696213 1925036 1925036 defendant Cherche John weaver 585937 585937 Cherche, John, of Bylston, weaver 1
3696220 1925038 1925038 defendant White John tiler 585937 585937 White, John, of Bylston, tiler 0
3696221 1925038 1925038 defendant Andrewe John weaver 585937 585937 Andrewe, John, of Bylston, weaver 1
3696222 1925038 1925038 defendant Carter Alexander weaver 585937 585937 Carter, Alexander, of Bylston, weaver 2
3697577 1925464 1925464 defendant Hoo John yeoman 585937 585937 Hoo, John, of Bylston, yeoman 0
3710053 1929454 1929454 defendant Wythe William tiler 585937 585937 Wythe, William, of Bylston, tiler 1
3716823 1931548 1931548 defendant Coke Richard husbandman 585937 585937 Coke, Richard, of Bylston, husbandman 1
3728751 1935232 1935232 defendant Grene John drover 585937 585937 Grene, John, of Bylston, drover 0
3729249 1935398 1935398 defendant Mannyng John smith 585937 585937 Mannyng, John, of Bylston, smith 2
3730586 1935802 1935802 defendant Crosse John cooper 585937 585937 Crosse, John, of Bylston, cooper 0
3741178 1939101 1939101 defendant Brundisshe Thomas dyer 585937 585937 Brundisshe, Thomas, of Bylston, dyer 4
3741199 1939105 1939105 defendant Burndysshe Thomas dyer 585937 585937 Burndysshe, Thomas, of Bylston, dyer 4
3748308 1941400 1941400 defendant Baker Edward chaplain 585937 585937 (Baker, Edward, of Bylston, chaplain 1
3757522 1944327 1944327 defendant Cook Hugh butcher 585937 585937 Cook, Hugh, of Bylston, butcher 0
3760743 1945361 1945361 defendant Coke Hugh butcher 585937 585937 Coke, Hugh, of Bylston, butcher 0
3761104 1945475 1945475 defendant Salter Thomas woolman 585937 585937 Salter, Thomas, of Bylston, woolman 0
3761208 1945509 1945509 defendant Baly Thomas painter 585937 585937 Baly, Thomas, of Bylston, painter 0
3763014 1946063 1946063 plaintiff Grynwade Thomas   585937 585937 Grynwade, Thomas, of Bylston 0
3763015 1946063 1946063 defendant Coke Hugh butcher 585937 585937 Coke, Hugh, of Bylston, butcher 0
3764032 1946395 1946395 defendant Gossenold Edmund yeoman 585937 585937 Gossenold, Edmund, of Bylston, yeoman 0
3767389 1947445 1947445 defendant Cooke Hugh butcher 585937 585937 Cooke, Hugh, of Bylston, butcher 0
3768141 1947672 1947672 defendant Salter Thomas clothmaker 585937 585937 Salter, Thomas, of Bylston, clothmaker 2
3768142 1947672 1947672 defendant Wythe John tiler 585937 585937 Wythe, John, of Bylston, tiler 3
3773876 1949540 1949540 defendant Sawer George husbandman 585937 585937 Sawer, George, of Bylston, husbandman 1
3773878 1949540 1949540 defendant Awood John laborer 585937 585937 Awood, John, of Bylston, laborer 3
3773879 1949540 1949540 defendant Brundyssh Thomas laborer 585937 585937 Brundyssh, Thomas, of Bylston, laborer 4
3774379 1949710 1949710 defendant Carter William shoemaker 585937 585937 Carter, William, of Bylston, shoemaker 1
3775511 1950083 1950083 defendant Wryght Thomas, junior clothman 585937 585937 Wryght, Thomas, junior, of Bylston, clothman 0
3777974 1950822 1950822 defendant Crosse Robert cooper 585937 585937 Crosse, Robert, of Bylston, cooper 0
3778013 1950834 1950834 defendant Skoye Robert shoemaker 585937 585937 Skoye, Robert, of Bylston, shoemaker 1
3778014 1950834 1950834 defendant Maybroke William shoemaker 585937 585937 Maybroke, William, of Bylston, shoemaker 2
3784302 1952880 1952880 defendant Downyng Robert draper 585937 585937 Downyng, Robert, of Bylston, draper 3
3784303 1952880 1952880 defendant Cowper Lawrence innkeeper 585937 585937 Cowper, Lawrence, of Bylston, innkeeper 4
3784304 1952880 1952880 defendant Wyth John tiler 585937 585937 Wyth, John, of Bylston, tiler 5
3802324 1958625 1958625 defendant Salter Thomas clothmaker 585937 585937 Salter, Thomas, of Bylston, clothmaker 1
3802325 1958625 1958625 defendant Cowper Lawrence husbandman 585937 585937 Cowper, Lawrence, of Bylston, husbandman 2
3812332 1961749 1961749 defendant bemond John butcher 585937 585937 bemond, John, of Bylston, butcher 2
3815719 1962834 1962834 defendant Gybbon William husbandman 585937 585937 Gybbon, William, of Bylston, husbandman 2
3823128 1965145 1965145 defendant Gebon William laborer 585937 585937 Gebon, William, of Bylston, laborer 0
3830628 1967461 1967461 defendant Pype Alice spinster 585937 585937 Pype, Alice, of Bylston, spinster 0
3832056 1967926 1967926 defendant Mannyng John smith 585937 585937 Mannyng, John, of Bylston, smith 0
3843099 1971366 1971366 defendant Bolton John laborer 585937 585937 Bolton, John, of Bylston, laborer 0
3843101 1971366 1971366 defendant Carter Henry laborer 585937 585937 Carter, Henry, of Bylston, laborer 2
3844455 1971813 1971813 defendant Hole Thomas smith 585937 585937 Hole, Thomas, of Bylston, smith 1
3853974 1974881 1974881 defendant Blomfeld John yeoman 585937 585937 Blomfeld, John, of Bylston, yeoman 0
3859267 1976593 1976593 plaintiff Carter Alexander   585937 585937 Carter, Alexander, of Bylston 0
3859269 1976593 1976593 defendant Marchauntte John laborer 585937 585937 Marchauntte, John, of Bylston, laborer 1
3859993 1976843 1976843 defendant Eybroke William shoemaker 585937 585937 Eybroke, William, of Bylston, shoemaker 0
3860653 1977056 1977056 defendant Blomfeld John husbandman 585937 585937 Blomfeld, John, of Bylston, husbandman 0
3863342 1977936 1977936 defendant Blomefeld John baker 585937 585937 Blomefeld, John, of Bylston, baker 0
3867487 1979360 1979360 defendant Blomfeld John husbandman 585937 585937 Blomfeld, John, of Bylston, husbandman 0
3869882 1980171 1980171 defendant Draper Henry husbandman 585937 585937 Draper, Henry, of Bylston, husbandman 3
3869883 1980171 1980171 defendant Janyng Henry cooper 585937 585937 Janyng, Henry, of Bylston, cooper 4
3873479 1981347 1981347 defendant Bolton John laborer 585937 585937 Bolton, John, of Bylston, laborer 0
3873483 1981347 1981347 defendant Paty Rose widow 585937 585937 Paty, Rose, of Bylston, widow 4
3874201 1981595 1981595 defendant Gybroke William shoemaker 585937 585937 Gybroke, William, of Bylston, shoemaker 0
3879190 1983293 1983293 defendant Graveley Richard yeoman 585937 585937 Graveley, Richard, of Bylston, yeoman 1
3883247 1984660 1984660 defendant Blomefeld John husbandman 585937 585937 Blomefeld, John, of Bylston, husbandman 0
3885247 1985320 1985320 plaintiff Barker Robert merchant 585937 585937 Barker, Robert, of Bylston, merchant 0
3896516 1989042 1989042 defendant Coley Richard yeoman 585937 585937 Coley, Richard, of Bylston, yeoman 0
3909909 1993622 1993622 defendant Carter Alexander yeoman 585937 585937 Carter, Alexander, of Bylston, yeoman 2
3913642 1994903 1994903 defendant Thrower William sherman 585937 585937 Thrower, William, of Bylston, sherman 0
3914576 1995220 1995220 defendant Blomefeld John husbandman 585937 585937 Blomefeld, John, of Bylston, husbandman 0
3916586 1995924 1995924 defendant Heyward John yeoman 585937 585937 Heyward, John, of Bylston, yeoman 0
3919491 1996850 1996850 plaintiff Lawrens Thomas yeoman 585937 585937 Lawrens, Thomas, of Bylston, yeoman 0
3919492 1996850 1996850 defendant Sheperd Nicholas   585937 585937 Sheperd, Nicholas, of Bylston, surgeon 0
3958945 2010211 2010211 defendant Geyrey Thomas husbandman 585937 585937 Geyrey, Thomas, of Bylston, husbandman 1
3958946 2010211 2010211 defendant Geyrey William husbandman 585937 585937 Geyrey, William, of Bylston, husbandman 2
3958947 2010211 2010211 defendant Gryffyn Robert husbandman 585937 585937 Gryffyn, Robert, of Bylston, husbandman 3
3958948 2010211 2010211 defendant Glen William husbandman 585937 585937 Glen, William, of Bylston, husbandman 4
3969093 2013803 2013803 defendant Osmonde Robert clothier 585937 585937 Osmonde, Robert, of Bylston, clothier 0
3982270 2018427 2018427 defendant Bogas William tanner 585937 585937 Bogas, William, of Bylston, tanner 0
4018128 2031205 2031205 defendant Wright John clothier 585937 585937 Wright, John, of Bylston, clothier 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);