names

178 rows where place_id = 586125

✎ 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
3587986 1863895 1863895 defendant Hurst Arthur chapman 586125 586125 Hurst, Arthur, of Dudley, chapman 3
3587987 1863895 1863895 defendant Wynse William chapman 586125 586125 Wynse, William, of Dudley, chapman 4
3638090 1906729 1906729 defendant Walker John smith 586125 586125 Walker, John, of Dudley, smith 0
3638091 1906729 1906729 defendant Walker Robert smith 586125 586125 Walker, Robert, of Dudley, smith 1
3638093 1906730 1906730 defendant Walker John smith 586125 586125 Walker, John, of Dudley, smith 0
3638094 1906730 1906730 defendant Walker Robert smith 586125 586125 Walker, Robert, of Dudley, smith 1
3643267 1908318 1908318 defendant Colbrond George chapman 586125 586125 Colbrond, George, of Dudley, chapman 1
3659954 1913371 1913371 defendant Dudley alias Sutton Edward   586125 586125 Dudley alias Sutton, Edward, of Dudley, knight 0
3659956 1913372 1913372 defendant Dudley alias Sutton Edward   586125 586125 Dudley alias Sutton, Edward, of Dudley, knight 0
3662552 1914203 1914203 defendant Wynslowe Thomas butcher 586125 586125 Wynslowe, Thomas, of Dudley, butcher 4
3668426 1916076 1916076 defendant Smyth William yeoman 586125 586125 Smyth, William, of Dudley, yeoman 0
3711028 1929760 1929760 defendant Rouse Richard yeoman 586125 586125 Rouse, Richard, of Dudley, yeoman 0
3711031 1929761 1929761 defendant Rouse Richard yeoman 586125 586125 Rouse, Richard, of Dudley, yeoman 0
3725677 1934317 1934317 defendant Rouse Richard yeoman 586125 586125 Rouse, Richard, of Dudley, yeoman 0
3729201 1935382 1935382 defendant Smyth William tanner or horse courser 586125 586125 Smyth, William, of Dudley, tanner or horse courser 0
3744794 1940272 1940272 defendant Sutton Edward   586125 586125 Sutton, Edward, of Dudley, knight 0
3781096 1951825 1951825 defendant Bryge Hugh   586125 586125 Bryge, Hugh, of Dudley, nail maker 0
3806637 1959974 1959974 defendant Jones Richard yeoman 586125 586125 Jones, Richard, of Dudley, yeoman 1
3806638 1959974 1959974 defendant Cobborne James yeoman 586125 586125 Cobborne, James, of Dudley, yeoman 2
3806647 1959975 1959975 defendant Jones Richard yeoman 586125 586125 Jones, Richard, of Dudley, yeoman 1
3806648 1959975 1959975 defendant Colborne James yeoman 586125 586125 Colborne, James, of Dudley, yeoman 2
3813307 1962074 1962074 defendant Hawekes John smith 586125 586125 Hawekes, John, of Dudley, smith 1
3824229 1965456 1965456 defendant Colborne James yeoman 586125 586125 Colborne, James, of Dudley, yeoman 2
3860624 1977045 1977045 defendant Freerson Robert nailer 586125 586125 Freerson, Robert, of Dudley, nailer 4
3904798 1991867 1991867 defendant Heywood alias Heyward Robert yeoman 586125 586125 Heywood alias Heyward, Robert, of Dudley, yeoman 0
3946351 2005796 2005796 defendant Parshowse alias Parke John yeoman 586125 586125 Parshowse alias Parke, John, of Dudley, yeoman 0
3946352 2005796 2005796 defendant Wheeler Robert yeoman 586125 586125 Wheeler, Robert, of Dudley, yeoman 1
3964624 2012233 2012233 defendant Atkys William yeoman 586125 586125 Atkys, William, of Dudley, yeoman 0
3964627 2012234 2012234 defendant Atkys John husbandman 586125 586125 Atkys, John, of Dudley, husbandman 1
3965750 2012638 2012638 defendant Aperke John nailer 586125 586125 Aperke, John, of Dudley, nailer 0
3970268 2014196 2014196 defendant Etkys William husbandman or yeoman 586125 586125 Etkys, William, of Dudley, husbandman or yeoman 0
3980984 2017956 2017956 defendant Saunders alias Bate Thomas   586125 586125 Saunders alias Bate, Thomas, of Dudley, "grubber" 0
3987024 2020100 2020100 defendant Fyssher Thomas nailer 586125 586125 Fyssher, Thomas, of Dudley, nailer 0
4012998 2029381 2029381 defendant Atkys William yeoman 586125 586125 Atkys, William, of Dudley, yeoman 0
4014106 2029773 2029773 defendant A Parke John nailer 586125 586125 A Parke, John, of Dudley, nailer 0
4017022 2030790 2030790 defendant Robynson alias Mason Richard butcher 586125 586125 Robynson alias Mason, Richard, of Dudley, butcher 0
4030588 2035600 2035600 defendant Atkys William yeoman 586125 586125 Atkys, William, of Dudley, yeoman 0
4035488 2037366 2037366 defendant Wheler William nailer 586125 586125 Wheler, William, of Dudley, nailer 0
4035489 2037366 2037366 defendant Rodys William laborer 586125 586125 Rodys, William, of Dudley, laborer 1
4035490 2037366 2037366 defendant Parryngham William smith 586125 586125 Parryngham, William, of Dudley, smith 2
4037290 2038001 2038001 plaintiff Jones Richard   586125 586125 Jones, Richard, of Dudley, gent, administrators of 0
4038017 2038242 2038242 defendant Atkys William yeoman 586125 586125 Atkys, William, of Dudley, yeoman 0
4045583 2040870 2040870 defendant A Parke John nailer 586125 586125 A Parke, John, of Dudley, nailer 0
4051012 2042803 2042803 plaintiff Wheler Robert (legal representative) 586125 586125 Wheler, Robert, of Dudley, executrix of 0
4051014 2042803 2042803 defendant Patyngham Thomas (legal representative) 586125 586125 Patyngham, Thomas, of Dudley, yeoman, executors of 0
4051016 2042803 2042803 defendant Patyngham William nailer 586125 586125 Patyngham, William, of Dudley, nailer 2
4051017 2042804 2042804 plaintiff Wheler Robert (legal representative) 586125 586125 Wheler, Robert, of Dudley, executrix of 0
4051019 2042804 2042804 defendant Patyngham Thomas (legal representative) 586125 586125 Patyngham, Thomas, of Dudley, yeoman, executors of 0
4051021 2042804 2042804 defendant Patyngham William nailer 586125 586125 Patyngham, William, of Dudley, nailer 2
4056351 2044655 2044655 defendant Carie John gent 586125 586125 Carie, John, of Dudley, gent 0
4062502 2046879 2046879 defendant Robynson alias Mason John nailer 586125 586125 Robynson alias Mason, John, of Dudley, nailer 0
4062503 2046879 2046879 defendant Robynson alias Mason John butcher 586125 586125 Robynson alias Mason, John, of Dudley, butcher 1
4062504 2046879 2046879 defendant Shawe George laborer 586125 586125 Shawe, George, of Dudley, laborer 2
4069807 2049487 2049487 defendant Wryght Humphrey yeoman 586125 586125 Wryght, Humphrey, of Dudley, yeoman 2
4074602 2051218 2051218 defendant Pershowse alias Aparke John nailer 586125 586125 Pershowse alias Aparke, John, of Dudley, nailer 0
4076921 2052033 2052033 defendant Hawles William butcher 586125 586125 Hawles, William, of Dudley, butcher 0
4077597 2052275 2052275 defendant Parke Adam nailer 586125 586125 Parke, Adam, of Dudley, nailer 1
4101623 2060887 2060887 defendant Foley Richard nailer 586125 586125 Foley, Richard, of Dudley, nailer 0
4101625 2060888 2060888 defendant Foley Richard nailer 586125 586125 Foley, Richard, of Dudley, nailer 0
4101627 2060889 2060889 defendant Parsus alias Parke George yeoman 586125 586125 Parsus alias Parke, George, of Dudley, yeoman 0
4101628 2060889 2060889 defendant Parsus alias Parke Joan spinster 586125 586125 Joan his wife, alias Joan Homes, of Dudley, spinster 1
4101630 2060890 2060890 defendant Parsus or Parke George yeoman 586125 586125 Parsus or Parke, George, of Dudley, yeoman 0
4101631 2060890 2060890 defendant Parsus or Parke Joan spinster 586125 586125 Joan his wife, alias Joan Homes, of Dudley, spinster 1
4106506 2062617 2062617 defendant A Parke alias Parsehouse John blacksmith 586125 586125 A Parke alias Parsehouse, John, of Dudley, blacksmith 0
4106507 2062617 2062617 defendant Jukes Humphrey blacksmith 586125 586125 Jukes, Humphrey, of Dudley, blacksmith 1
4106508 2062617 2062617 defendant Jukes John blacksmith 586125 586125 Jukes, John, of Dudley, blacksmith 2
4119221 2067167 2067167 defendant Smyth Richard yeoman 586125 586125 Smyth, Richard, of Dudley, yeoman 1
4121263 2067900 2067900 defendant Parke or Apark John nailer 586125 586125 Parke or Apark, John, of Dudley, nailer 0
4121264 2067900 2067900 defendant Grove Thomas collier 586125 586125 Grove, Thomas, of Dudley, collier 1
4136266 2073315 2073315 defendant Payton or Paytwyn John yeoman 586125 586125 Payton or Paytwyn, John, of Dudley, yeoman 1
4140857 2074967 2074967 defendant A Parke John yeoman 586125 586125 A Parke, John, of Dudley, yeoman 0
4140858 2074967 2074967 defendant Askewe John gent 586125 586125 Askewe, John, of Dudley, or of Franckley, gent 1
4142106 2075415 2075415 defendant Smyth Richard yeoman 586125 586125 Smyth, Richard, of Dudley, yeoman 1
4142107 2075415 2075415 defendant Aparke alias Aparsehowse John yeoman 586125 586125 Aparke alias Aparsehowse, John, of Dudley, yeoman 2
4144374 2076192 2076192 defendant Park John nailer 586125 586125 Park, John, of Dudley, nailer 0
4144375 2076192 2076192 defendant Grove Thomas collier 586125 586125 Grove, Thomas, of Dudley, collier 1
4152043 2078826 2078826 defendant Fysher Thomas nailer 586125 586125 Fysher, Thomas, of Dudley, nailer 2
4164371 2083057 2083057 defendant Payton alias Patwyne John yeoman 586125 586125 Payton alias Patwyne, John, of Dudley, yeoman 1
4165723 2083509 2083509 defendant Aparke John yeoman 586125 586125 Aparke, John, of Dudley, yeoman 0
4165724 2083509 2083509 defendant Askewe John gent 586125 586125 Askewe, John, of Dudley, or of Franckeley, gent 1
4167033 2083973 2083973 defendant Grene or Agreene Richard yeoman 586125 586125 Grene or Agreene, Richard, of Dudley, yeoman 0
4167034 2083973 2083973 defendant ap Jevan John yeoman 586125 586125 ap Jevan, John, of Dudley, yeoman 1
4169599 2084873 2084873 defendant Caree John gent 586125 586125 Caree, John, of Dudley, gent 3
4175635 2086948 2086948 defendant Fysher Thomas nailer 586125 586125 Fysher, Thomas, of Dudley, nailer 3
4184055 2089919 2089919 defendant Payton alias Paytwyn John yeoman 586125 586125 Payton alias Paytwyn, John, of Dudley, yeoman 0
4185513 2090442 2090442 defendant James Henry yeoman 586125 586125 James, Henry, of Dudley, yeoman 1
4189228 2091725 2091725 defendant Mylner William husbandman 586125 586125 Mylner, William, of Dudley, husbandman 3
4220120 2102537 2102537 defendant Colborne Roger gent 586125 586125 Colborne, Roger, of Dudley, gent 1
4220121 2102537 2102537 defendant Mason William butcher 586125 586125 Mason, William, of Dudley, butcher 2
4232251 2106783 2106783 defendant Milton or Mitton Leonard weaver 586125 586125 Milton or Mitton, Leonard, of Dudley, weaver 0
4235436 2107962 2107962 defendant Pratt Humphrey tailor 586125 586125 Pratt, Humphrey, of Dudley, tailor 0
4238240 2108983 2108983 defendant James alias Davies John   586125 586125 James alias Davies, John, of Dudley, "grubber" or digger 0
4240418 2109773 2109773 defendant Ryder Simon nailer 586125 586125 Ryder, Simon, of Dudley, nailer 0
4293458 2127723 2127723 defendant Horton John driver 586125 586125 Horton, John, of Dudley, driver 0
4293460 2127724 2127724 defendant Jukes John blacksmith 586125 586125 Jukes, John, of Dudley, blacksmith, son of John Jukes or Jewck, of Duddeley, blacksmith 0
4298563 2129591 2129591 defendant Folley Richard yeoman 586125 586125 Folley, Richard, of Dudley, yeoman 0
4311005 2133995 2133995 defendant Smyth William weaver 586125 586125 Smyth, William, of Dudley, weaver 1
4320662 2137318 2137318 defendant Foxley John nailer 586125 586125 Foxley, John, of Dudley, nailer 0
4322833 2138054 2138054 defendant Robynson alias Mason Humphrey husbandman 586125 586125 Robynson alias Mason, Humphrey, of Dudley, husbandman 0
4324502 2138584 2138584 defendant Bets William laborer 586125 586125 Bets, William, of Dudley, laborer 4

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