names

305 rows where place_id = 586402

✎ 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
3588630 1864087 1864087 defendant Newelond John stationer 586402 586402 Newelond, John, of Hadley, Suff, stationer 0
3597445 1866819 1866819 defendant Hosnold Edmund yeoman 586402 586402 Hosnold, Edmund, of Hadley, Suff, yeoman 1
3603202 1868668 1868668 defendant Baker alias Loder Thomas clothmaker 586402 586402 Baker alias Loder, Thomas, of Hadley, Suff, clothmaker 0
3603204 1868669 1868669 defendant Baker Thomas clothmaker 586402 586402 Baker, Thomas, of Hadley, Suff, clothmaker 0
3604684 1869127 1869127 defendant Houghton Robert woolman 586402 586402 Houghton, Robert, of Hadley, Suff, woolman 0
3626456 1903130 1903130 defendant Rasse or Raffe John husbandman 586402 586402 Rasse or Raffe, John, of Hadley, Suff, husbandman 0
3628312 1903717 1903717 defendant Kyng Thomas   586402 586402 Kyng, Thomas, of Hadley, Suff, cook 0
3631062 1904538 1904538 defendant Turnour Roger yeoman 586402 586402 Turnour, Roger, of Hadley, Suff, yeoman 0
3632312 1904926 1904926 defendant Smyth John merchant 586402 586402 Smyth, John, of Hadley, Suff, merchant 0
3636447 1906189 1906189 defendant Smythe John merchant 586402 586402 Smythe, John, of Hadley, Suff, merchant 0
3665023 1915006 1915006 defendant Forde Robert, junior merchant 586402 586402 Forde, Robert, junior, of Hadley, Suff, merchant 1
3676780 1918774 1918774 defendant Quyntybn Thomas shoemaker 586402 586402 Quyntybn, Thomas, of Hadley, Suff, shoemaker 0
3685355 1921574 1921574 defendant Clerke William clothman 586402 586402 Clerke, William, of Hadley, Suff, clothman 3
3685361 1921575 1921575 defendant Clerke William clothmaker 586402 586402 Clerke, William, of Hadley, Suff, clothmaker 3
3688740 1922640 1922640 defendant Quyntyn John clothier 586402 586402 Quyntyn, John, of Hadley, Suff, clothier 2
3692888 1923972 1923972 defendant Quynten John clothier 586402 586402 Quynten, John, of Hadley, Suff, clothier 0
3694899 1924613 1924613 defendant Miller William chapman 586402 586402 Miller, William, of Hadley, Suff, chapman 0
3705380 1927970 1927970 defendant Millalle alias Mellar William chapman or clothman 586402 586402 Millalle alias Mellar, William, of Hadley, Suff, chapman or clothman 0
3705391 1927972 1927972 defendant Myllale alias Myller William chapman 586402 586402 Myllale alias Myller, William, of Hadley, Suff, chapman 0
3705994 1928165 1928165 defendant Brownyn Robert clothmaker 586402 586402 Brownyn, Robert, of Hadley, Suff, clothmaker 0
3708611 1928993 1928993 defendant Clerke Walter clothman 586402 586402 Clerke, Walter, of Hadley, Suff, clothman 0
3709344 1929220 1929220 defendant Miller William chapman 586402 586402 Miller, William, of Hadley, Suff, chapman 1
3712828 1930332 1930332 defendant Balle Richard clothier 586402 586402 Balle, Richard, of Hadley, Suff, clothier 0
3712830 1930333 1930333 defendant Marshall William clothier 586402 586402 Marshall, William, of Hadley, Suff, clothier 0
3712832 1930334 1930334 defendant Bronwyn Robert clothier 586402 586402 Bronwyn, Robert, of Hadley, Suff, clothier 0
3717881 1931893 1931893 defendant Ropkynnys Richard clothier 586402 586402 Ropkynnys, Richard, of Hadley, Suff, clothier 0
3720025 1932536 1932536 defendant Colbrond William husbandman 586402 586402 Colbrond, William, of Hadley, Suff, husbandman 0
3720089 1932559 1932559 defendant Barfot John, junior clothmaker 586402 586402 Barfot, John, junior, of Hadley, Suff, clothmaker 0
3721463 1933022 1933022 defendant Dowell Henry gent 586402 586402 Dowell, Henry, of Hadley, Suff, gent 1
3722061 1933163 1933163 defendant Fenne Robert merchant 586402 586402 Fenne, Robert, of Hadley, Suff, merchant 2
3729395 1935441 1935441 defendant Turnor William slothier 586402 586402 Turnor, William, of Hadley, Suff, slothier 3
3733635 1936761 1936761 defendant Robkynnys Richard clothier 586402 586402 Robkynnys, Richard, of Hadley, Suff, clothier 0
3737418 1937941 1937941 defendant Dooyll Henry gent 586402 586402 Dooyll, Henry, of Hadley, Suff, gent 0
3747877 1941259 1941259 defendant Wodward John innholder 586402 586402 Wodward, John, of Hadley, Suff, innholder 0
3755776 1943765 1943765 defendant Quyntyne John clothmaker 586402 586402 Quyntyne, John, of Hadley, Suff, clothmaker 0
3759707 1945028 1945028 defendant Marchall William clothman 586402 586402 Marchall, William, of Hadley, Suff, clothman 0
3759709 1945029 1945029 defendant Marshall William clothman 586402 586402 Marshall, William, of Hadley, Suff, clothman 0
3763043 1946072 1946072 defendant Freman John gent 586402 586402 Freman, John, of Hadley, Suff, gent 1
3765892 1946996 1946996 defendant Yllard Robert clothman 586402 586402 Yllard, Robert, of Hadley, Suff, clothman 1
3769919 1948249 1948249 defendant Marchall William clothman 586402 586402 Marchall, William, of Hadley, Suff, clothman 0
3773819 1949524 1949524 defendant Quyntyne John clothmaker 586402 586402 Quyntyne, John, of Hadley, Suff, clothmaker 0
3783068 1952459 1952459 defendant Quyntyne John yeoman 586402 586402 Quyntyne, John, of Hadley, Suff, yeoman 0
3787199 1953787 1953787 defendant Forthe Robert, junior gent 586402 586402 Forthe, Robert, junior, of Hadley, Suff, gent 0
3787201 1953788 1953788 defendant Forthe Robert, junior gent 586402 586402 Forthe, Robert, junior, of Hadley, Suff, gent 0
3790767 1954939 1954939 defendant Quyntyn John clothman 586402 586402 Quyntyn, John, of Hadley, Suff, clothman 0
3790769 1954940 1954940 defendant Quyntyn John clothman 586402 586402 Quyntyn, John, of Hadley, Suff, clothman 0
3792484 1955509 1955509 defendant Brownwyn John, junior clothmaker 586402 586402 Brownwyn, John, junior, of Hadley, Suff, clothmaker 1
3802967 1958826 1958826 defendant Clerke John clothier 586402 586402 Clerke, John, of Hadley, Suff, clothier 1
3802985 1958833 1958833 defendant Myller William chapman 586402 586402 Myller, William, of Hadley, Suff, chapman 0
3802987 1958834 1958834 defendant Myller William chapman 586402 586402 Myller, William, of Hadley, Suff, chapman 0
3807922 1960367 1960367 defendant Marshall William clothmaker 586402 586402 Marshall, William, of Hadley, Suff, clothmaker 0
3807931 1960370 1960370 defendant Marsshall William clothmaker 586402 586402 Marsshall, William, of Hadley, Suff, clothmaker 0
3812753 1961882 1961882 defendant Martyn Thomas clothman 586402 586402 Martyn, Thomas, of Hadley, Suff, clothman 1
3813771 1962220 1962220 defendant Wodward John chapman 586402 586402 Wodward, John, of Hadley, Suff, chapman 0
3818094 1963572 1963572 defendant Morton Henry clothman 586402 586402 Morton, Henry, of Hadley, Suff, clothman 0
3819888 1964101 1964101 defendant Sparowe Thomas   586402 586402 Sparowe, Thomas, of Hadley, Suff, innkeepr 0
3826764 1966224 1966224 defendant Raynam alias Rayman William clothmaker 586402 586402 Raynam alias Rayman, William, of Hadley, Suff, clothmaker 1
3826769 1966225 1966225 defendant Raynam alias Rayman William clothmaker 586402 586402 Raynam alias Rayman, William, of Hadley, Suff, clothmaker 1
3832626 1968130 1968130 defendant Milner William chapman 586402 586402 Milner, William, of Hadley, suff, chapman 1
3837936 1969778 1969778 defendant Woodward John mercer 586402 586402 Woodward, John, of Hadley, Suff, mercer 1
3837943 1969780 1969780 defendant Woodward John mercer 586402 586402 Woodward, John, of Hadley, Suff, mercer 1
3843449 1971489 1971489 defendant Polle alias Clerk William dyer 586402 586402 Polle alias Clerk, William, of Hadley, Suff, dyer 0
3856063 1975521 1975521 defendant Meller William chapman 586402 586402 Meller, William, of Hadley, Suff, chapman 1
3856068 1975522 1975522 defendant Meller William chapman 586402 586402 Meller, William, of Hadley, Suff, chapman 1
3864571 1978348 1978348 defendant Boylle alias Dowell Henry gent 586402 586402 Boylle alias Dowell, Henry, of Hadley, Suff, gent 0
3864591 1978352 1978352 defendant Doylle Henry gent 586402 586402 Doylle, Henry, of Hadley, Suff, gent 1
3866912 1979171 1979171 defendant Pycher Edward innholder 586402 586402 Pycher, Edward, of Hadley, Suff, innholder 0
3866920 1979175 1979175 defendant Pycher Edward innholder 586402 586402 Pycher, Edward, of Hadley, Suff, innholder 0
3867222 1979274 1979274 defendant Pycher Edward innholder 586402 586402 Pycher, Edward, of Hadley, Suff, innholder 0
3869922 1980184 1980184 defendant Aylmer Nicholas clothmaker 586402 586402 Aylmer, Nicholas, of Hadley, Suff, clothmaker 0
3869928 1980185 1980185 defendant Kygyll John sherman 586402 586402 Kygyll, John, of Hadley, Suff, sherman 0
3869942 1980187 1980187 defendant Motam John clothman 586402 586402 Motam, John, of Hadley, Suff, clothman 2
3882795 1984509 1984509 defendant Miller William mercer 586402 586402 Miller, William, of Hadley, Suff, mercer 0
3889441 1986700 1986700 defendant Weston William clothier 586402 586402 Weston, William, of Hadley, Suff, clothier 0
3903884 1991536 1991536 defendant Allcoke John clothmaker 586402 586402 Allcoke, John, of Hadley, Suff, clothmaker 0
3913000 1994680 1994680 defendant Reynold John (legal representative) 586402 586402 Reynold, John, of Hadley, Suff, cordwainer, executors of 0
3926349 1999136 1999136 defendant Saret Edmund clothyer 586402 586402 Saret, Edmund, of Hadley, Suff, clothyer 0
3934660 2001887 2001887 defendant Chambre Thomas   586402 586402 Chambre, Thomas, of Hadley, Suff, tailor & of Upchurche, Kent 0
3935256 2002103 2002103 defendant Rolff John clothier 586402 586402 Rolff, John, of Hadley, Suff, clothier 0
3938867 2003339 2003339 defendant Thomson Richard draper 586402 586402 Thomson, Richard, of Hadley, Suff, draper 4
3939564 2003535 2003535 defendant Barker Thomas clothier 586402 586402 Barker, Thomas, of Hadley, Suff, clothier 0
3941589 2004200 2004200 defendant Spryngfeld John   586402 586402 Spryngfeld, John, of Hadley, Suff, inn holder 0
3941921 2004309 2004309 defendant Spryngefeld John   586402 586402 Spryngefeld, John, of Hadley, suff, inn holder 1
3941924 2004310 2004310 defendant Spryngefeld John   586402 586402 Spryngefeld, John, of Hadley, Suff, inn holder 1
3947450 2006181 2006181 defendant Clyffe Ralph clothier 586402 586402 Clyffe, Ralph, of Hadley, Suff, clothier 0
3947454 2006182 2006182 defendant Clyffe Ralph clothier 586402 586402 Clyffe, Ralph, of Hadley, Suff, clothier 0
3948043 2006381 2006381 defendant Facon Thomas clothier 586402 586402 Facon, Thomas, of Hadley, Suff, clothier 0
3954293 2008576 2008576 defendant Fawcon Thomas clother 586402 586402 Fawcon, Thomas, of Hadley, Suff, clother 2
3958234 2009953 2009953 plaintiff Reson Richard clothmaker 586402 586402 Reson, Richard, of Hadley, Suff, clothmaker 0
3961481 2011113 2011113 plaintiff Turner Robert clothier 586402 586402 Turner, Robert, of Hadley, Suff, clothier 0
3962248 2011378 2011378 defendant Garrard John clothier 586402 586402 Garrard, John, of Hadley, Suff, clothier 0
3962251 2011379 2011379 defendant Hubbard William merchant or broker 586402 586402 Hubbard, William, of Hadley, Suff, merchant or broker 0
3962256 2011380 2011380 defendant Doggett Thomas, junior clothmaker 586402 586402 Doggett, Thomas, junior, of Hadley, Suff, clothmaker 1
3974028 2015486 2015486 defendant Mycklefyld Robert chapman 586402 586402 Mycklefyld, Robert, of Hadley, Suff, chapman 3
3978147 2016935 2016935 defendant Gleson Thomas yeoman 586402 586402 Gleson, Thomas, of Hadley, Suff, yeoman 1
3982648 2018563 2018563 defendant Ewe Robert yeoman 586402 586402 Ewe, Robert, of Hadley, Suff, yeoman 3
3992893 2022211 2022211 defendant Gossnold William clothier 586402 586402 Gossnold, William, of Hadley, Suff, clothier 0
3993039 2022259 2022259 defendant Andrewes William butcher 586402 586402 Andrewes, William, of Hadley, Suff, butcher 1
3995455 2023118 2023118 defendant Bekon Stephen clothier 586402 586402 Bekon, Stephen, of Hadley, Suff, clothier 0
3998622 2024243 2024243 defendant Myclefeld Robert yeoman 586402 586402 Myclefeld, Robert, of Hadley, Suff, yeoman 5

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