names

281 rows where place_id = 586028

✎ 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
3587734 1863809 1863809 defendant Shene Ralph miller 586028 586028 Shene, Ralph, of Tamworth, miller 0
3590123 1864549 1864549 defendant Lawe Robert yeoman 586028 586028 Lawe, Robert, of Tamworth, yeoman 2
3606477 1869697 1869697 defendant Chattok Henry yeoman 586028 586028 Chattok, Henry, of Tamworth, yeoman 1
3614400 1872153 1872153 defendant Parker Richard yeoman 586028 586028 Parker, Richard, of Tamworth, yeoman 2
3617186 1872999 1872999 defendant Dey Richard yeoman 586028 586028 Dey, Richard, of Tamworth, yeoman 0
3627614 1903498 1903498 defendant Ferrers Dorothy widow 586028 586028 Ferrers, Dorothy, of Tamworth, widow 0
3627615 1903498 1903498 defendant Milwey John fisher 586028 586028 Milwey, John, of Tamworth, fisher 1
3629502 1904083 1904083 defendant Hyll John roper 586028 586028 Hyll, John, of Tamworth, roper 0
3637524 1906547 1906547 defendant Hill John yeoman 586028 586028 Hill, John, of Tamworth, yeoman 0
3655271 1911905 1911905 defendant Salysbury Hugh (legal representative) 586028 586028 Salysbury, Hugh, of Tamworth, administrator of 0
3656960 1912434 1912434 defendant Gregge Thomas yeoman 586028 586028 Gregge, Thomas, of Tamworth, yeoman 0
3656961 1912434 1912434 defendant Breten Humphrey yeoman 586028 586028 Breten, Humphrey, of Tamworth, yeoman 1
3656962 1912434 1912434 defendant Goodwyn Humphrey laborer 586028 586028 Goodwyn, Humphrey, of Tamworth, laborer 2
3656963 1912434 1912434 defendant Elyot Thomas weaver 586028 586028 Elyot, Thomas, of Tamworth, weaver 3
3656965 1912435 1912435 defendant Jakes John gent 586028 586028 Jakes, John, of Tamworth, gent 0
3656967 1912436 1912436 defendant Jekys John gent 586028 586028 Jekys, John, of Tamworth, gent 0
3656969 1912437 1912437 defendant Loge Ralph weaver 586028 586028 Loge, Ralph, of Tamworth, weaver 0
3657448 1912589 1912589 defendant Wodshawe Thomas yeoman 586028 586028 Wodshawe, Thomas, of Tamworth, yeoman 0
3673630 1917783 1917783 defendant Sawbryge Richard chaplain 586028 586028 Sawbryge, Richard, of Tamworth, chaplain 0
3685402 1921588 1921588 defendant Jekys John gent 586028 586028 Jekys, John, of Tamworth, gent 0
3709592 1929309 1929309 defendant Thyrkyll William gent 586028 586028 Thyrkyll, William, of Tamworth, gent 2
3714646 1930878 1930878 defendant Harthyll John grasier 586028 586028 Harthyll, John, of Tamworth, grasier 0
3750397 1942042 1942042 defendant Iseburn Barnaby husbandman 586028 586028 Iseburn, Barnaby, of Tamworth, husbandman 0
3765939 1947013 1947013 defendant Iseburne Barnabas husbandman 586028 586028 Iseburne, Barnabas, of Tamworth, husbandman 0
3830297 1967370 1967370 plaintiff Ferrers Humphrey   586028 586028 Ferrers, Humphrey, of Tamworth, knight 0
3887759 1986164 1986164 defendant Bretten Evan gent 586028 586028 Bretten, Evan, of Tamworth, gent 0
3906951 1992614 1992614 defendant Edensover Thomas butcher 586028 586028 Edensover, Thomas, of Tamworth, butcher 0
3923169 1998056 1998056 defendant Stockys Thomas courser 586028 586028 Stockys, Thomas, of Tamworth, courser 1
3942323 2004445 2004445 defendant Jakes Richard gent 586028 586028 Jakes, Richard, of Tamworth, gent 0
3942474 2004492 2004492 defendant Gryntwyche Robert tanner 586028 586028 Gryntwyche, Robert, of Tamworth, tanner 1
3945575 2005527 2005527 defendant Wylcokkes William baker 586028 586028 Wylcokkes, William, of Tamworth, baker 2
3947967 2006352 2006352 defendant Weston Christopher fishmonger 586028 586028 Weston, Christopher, of Tamworth, fishmonger 0
3958253 2009961 2009961 plaintiff Reynes Thomas butcher 586028 586028 Reynes, Thomas, of Tamworth, butcher 0
3958254 2009961 2009961 defendant Bretton John gent 586028 586028 Bretton, John, of Tamworth, gent 0
3962980 2011649 2011649 defendant Bucklande John butcher 586028 586028 Bucklande, John, of Tamworth, butcher 1
3988042 2020468 2020468 defendant Walker John butcher 586028 586028 Walker, John, of Tamworth, butcher 3
4021358 2032363 2032363 defendant Harecourte Walter gent 586028 586028 Harecourte, Walter, of Tamworth, gent 0
4068654 2049077 2049077 defendant Sydnoll or Sydnalle John yeoman 586028 586028 Sydnoll or Sydnalle, John, of Tamworth, yeoman 0
4068655 2049077 2049077 defendant Ede John husbandman 586028 586028 Ede, John, of Tamworth, husbandman 1
4068656 2049077 2049077 defendant Ede Richard husbandman 586028 586028 Ede, Richard, of Tamworth, husbandman 2
4070024 2049568 2049568 defendant Smalley Thomas yeoman 586028 586028 Smalley, Thomas, of Tamworth, yeoman 0
4082644 2054103 2054103 defendant Harecourte Edward   586028 586028 Harecourte, Edward, of Tamworth, gent, his son 1
4084001 2054553 2054553 defendant Brompton Henry cutler 586028 586028 Brompton, Henry, of Tamworth, cutler 3
4112592 2064760 2064760 defendant Cryspe William yeoman 586028 586028 Cryspe, William, of Tamworth, yeoman 1
4115916 2065979 2065979 defendant Terrye Henry laborer 586028 586028 Terrye, Henry, of Tamworth, laborer 0
4147800 2077370 2077370 defendant Hill Henry shoemaker 586028 586028 Hill, Henry, of Tamworth, shoemaker 1
4164982 2083260 2083260 defendant Ashley Thomas maltster 586028 586028 Ashley, Thomas, of Tamworth, maltster 1
4166589 2083810 2083810 defendant Stokys Francis shoemaker 586028 586028 Stokys, Francis, of Tamworth, shoemaker 1
4166590 2083810 2083810 defendant Stokys John, junior shoemaker 586028 586028 Stokys, John, junior, of Tamworth, shoemaker 2
4169840 2084948 2084948 defendant Quynborowe Henry yeoman 586028 586028 Quynborowe, Henry, of Tamworth, yeoman 3
4181378 2088966 2088966 defendant Buckland John yeoman 586028 586028 Buckland, John, of Tamworth, yeoman 0
4189815 2091933 2091933 defendant Siddowne or Sitdowne Nicholas laborer 586028 586028 Siddowne or Sitdowne, Nicholas, of Tamworth, laborer 0
4189816 2091933 2091933 defendant Walton John laborer 586028 586028 Walton, John, of Tamworth, laborer 1
4193167 2093178 2093178 defendant Quynborowe Henry yeoman 586028 586028 Quynborowe, Henry, of Tamworth, yeoman 3
4194662 2093691 2093691 defendant Ferrers George gent 586028 586028 Ferrers, George, of Tamworth, gent 0
4279703 2122818 2122818 defendant Smyth Henry cooper 586028 586028 Smyth, Henry, of Tamworth, cooper 2
4319572 2136957 2136957 defendant Caladowne Richard yeoman 586028 586028 Caladowne, Richard, of Tamworth, yeoman 1
4364286 2152287 2152287 defendant Tuttell Edward tanner 586028 586028 Tuttell, Edward, of Tamworth, tanner 0
4369533 2154163 2154163 defendant Curson Henry mercer 586028 586028 Curson, Henry, of Tamworth, mercer 1
4394618 2162789 2162789 defendant Grene Thomas yeoman 586028 586028 Grene, Thomas, of Tamworth, yeoman 0
4413573 2169137 2169137 defendant Grubbe John   586028 586028 Grubbe, John, of Tamworth 0
4415023 2169597 2169597 defendant Cok John le   586028 586028 Cok, John le, of Tamworth 0
4416647 2170070 2170070 defendant Cartwright Richard   586028 586028 Cartwright, Richard, of Tamworth 1
4417222 2170265 2170265 defendant Cartewrighte John le   586028 586028 Cartewrighte, John le, of Tamworth 1
4422003 2171762 2171762 plaintiff Derstehull Ralph de   586028 586028 Derstehull, Ralph de, of Tamworth 0
4422004 2171762 2171762 defendant Cotun Robert de merchant 586028 586028 Cotun, Robert de, of Tamworth, merchant 0
4423022 2172058 2172058 defendant Coke John le   586028 586028 Coke, John le, of Tamworth 0
4424380 2172467 2172467 defendant Priour Ralph   586028 586028 Priour, Ralph, of Tamworth 1
4427283 2173367 2173367 defendant Cartewryghte John le   586028 586028 Cartewryghte, John le, of Tamworth 1
4433338 2175182 2175182 defendant Cok John le   586028 586028 Cok, John le, of Tamworth 0
4443325 2182872 2182872 defendant Lyne William   586028 586028 Lyne, William, of Tamworth 5
4456859 2187156 2187156 defendant Sadeler John   586028 586028 Sadeler, John, of Tamworth 0
4464051 2189427 2189427 defendant Staunford John   586028 586028 Staunford, John, of Tamworth 0
4469213 2191039 2191039 defendant Breton Adam   586028 586028 Breton, Adam, of Tamworth 0
4469215 2191040 2191040 defendant Staunford John   586028 586028 Staunford, John, of Tamworth, burgess 0
4480801 2194659 2194659 defendant Simond Thomas tailor 586028 586028 Simond, Thomas, of Tamworth, tailor 0
4481094 2194768 2194768 defendant Warner John   586028 586028 Warner, John, of Tamworth 2
4483647 2195576 2195576 defendant Morlee John   586028 586028 Morlee, John, of Tamworth 0
4483695 2195592 2195592 defendant Breton Adam   586028 586028 Breton, Adam, of Tamworth 0
4483696 2195592 2195592 defendant Henge John   586028 586028 Henge, John, of Tamworth 1
4483838 2195642 2195642 defendant Elford John   586028 586028 Elford, John, of Tamworth 0
4485079 2196031 2196031 defendant Breton Adam   586028 586028 Breton, Adam, of Tamworth 0
4500645 2200823 2200823 plaintiff Keel Henry   586028 586028 Keel, Henry, of Tamworth 0
4500647 2200823 2200823 defendant Whitewell William   586028 586028 Whitewell, William, of Tamworth 1
4506719 2202576 2202576 defendant Sandforde Richard   586028 586028 Sandforde, Richard, of Tamworth 1
4506721 2202577 2202577 defendant Sandforde Richard   586028 586028 Sandforde, Richard, of Tamworth 0
4507947 2202950 2202950 defendant Barker John   586028 586028 Barker, John, of Tamworth 0
4507948 2202950 2202950 defendant Sawer Walter   586028 586028 Sawer, Walter, of Tamworth 1
4515999 2205422 2205422 defendant Saduler John   586028 586028 Saduler, John, of Tamworth 1
4516003 2205422 2205422 defendant Barker John   586028 586028 Barker, John, of Tamworth 5
4520481 2206753 2206753 defendant North John   586028 586028 North, John, of Tamworth 0
4524039 2207852 2207852 defendant Wyshawe William chaplain 586028 586028 Wyshawe, William, of Tamworth, chaplain 0
4524040 2207852 2207852 defendant Coton John   586028 586028 Coton, John, of Tamworth 1
4525027 2208168 2208168 defendant Newark Robert   586028 586028 Newark, Robert, of Tamworth 1
4525032 2208169 2208169 defendant Newark Robert   586028 586028 Newark, Robert, of Tamworth 1
4526876 2208683 2208683 defendant Heuster John   586028 586028 Heuster, John, of Tamworth 0
4526877 2208683 2208683 defendant Whaterost Richard heuster 586028 586028 Whaterost, Richard, of Tamworth, heuster 1
4527669 2208935 2208935 defendant Reede John   586028 586028 Reede, John, of Tamworth 2
4527670 2208935 2208935 defendant Baxter Alexander   586028 586028 Baxter, Alexander, of Tamworth 3
4527686 2208937 2208937 defendant Hewester John   586028 586028 Hewester, John, of Tamworth 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);