names

520 rows where place_id = 587635

✎ 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
3592014 1865117 1865117 plaintiff Foord William   587635 587635 Foord, William, of Hadlegh 0
3599144 1867368 1867368 defendant Robyns William   587635 587635 Robyns, William, of Hadlegh, tile maker 1
3604177 1868973 1868973 plaintiff Gardener William   587635 587635 Gardener, William, of Hadlegh 0
3604247 1868992 1868992 defendant Draper Robert carpenter 587635 587635 Draper, Robert, of Hadlegh, carpenter 2
3605017 1869231 1869231 defendant Warde William butcher 587635 587635 Warde, William, of Hadlegh, butcher 4
3609110 1870508 1870508 plaintiff Wiliot alias Spycer John fishmonger 587635 587635 Wiliot alias Spycer, John, of Hadlegh, fishmonger 0
3609114 1870509 1870509 plaintiff Wiliot alias Spycer John fishmonger 587635 587635 Wiliot alias Spycer, John, of Hadlegh, fishmonger 0
3609118 1870510 1870510 plaintiff Wiliot alis Spycer John fishmonger 587635 587635 Wiliot alis Spycer, John, of Hadlegh, fishmonger 0
3617365 1873051 1873051 plaintiff Foord William clothman or merchant 587635 587635 Foord, William, of Hadlegh, clothman or merchant 0
3617369 1873052 1873052 plaintiff Foord William merchant 587635 587635 Foord, William, of Hadlegh, merchant 0
3617371 1873053 1873053 plaintiff Foord William merchant 587635 587635 Foord, William, of Hadlegh, merchant 0
3617375 1873054 1873054 plaintiff Foorde William merchant 587635 587635 Foorde, William, of Hadlegh, merchant 0
3630293 1904323 1904323 plaintiff Emeryngale John   587635 587635 Emeryngale, John, of Hadlegh 0
3630295 1904323 1904323 defendant Man Richard husbandman 587635 587635 Man, Richard, of Hadlegh, husbandman 1
3644038 1908564 1908564 defendant Raynold John carpenter 587635 587635 Raynold, John, of Hadlegh, carpenter 0
3658956 1913065 1913065 plaintiff Fulsnape Alice (legal representative) 587635 587635 Fulsnape, Alice, of Hadlegh, widow, executrix & formerly wife of Thomas Fulsnape, of Hadlegh, cloth maker, executor of 0
3680472 1919975 1919975 defendant Balle Richard clothman 587635 587635 Balle, Richard, of Hadlegh, clothman 0
3685482 1921612 1921612 defendant Rolff Robert yeoman 587635 587635 Rolff, Robert, of Hadlegh, yeoman 0
3685484 1921613 1921613 defendant Veasy Thomas clothier 587635 587635 Veasy, Thomas, of Hadlegh, clothier 0
3687065 1922128 1922128 plaintiff Carpenter Robert husbandman 587635 587635 Carpenter, Robert, of Hadlegh, husbandman 0
3700523 1926406 1926406 defendant Rolff Robert yeoman 587635 587635 Rolff, Robert, of Hadlegh, yeoman 0
3710604 1929639 1929639 defendant Gardener Margaret widow 587635 587635 Gardener, Margaret, of Hadlegh, widow 4
3765837 1946981 1946981 plaintiff Woodward John mercer 587635 587635 Woodward, John, of Hadlegh, mercer 1
3820380 1964253 1964253 defendant Cooper Richard merchant 587635 587635 Cooper, Richard, of Hadlegh, merchant 0
3852830 1974493 1974493 defendant Clerk Robert shoemaker 587635 587635 Clerk, Robert, of Hadlegh, shoemaker 0
3884261 1985001 1985001 defendant Ryder John yeoman 587635 587635 Ryder, John, of Hadlegh, yeoman 0
3884269 1985003 1985003 defendant Ryder John yeoman 587635 587635 Ryder, John, of Hadlegh, yeoman 0
3941481 2004161 2004161 defendant Clarke Walter gent 587635 587635 Clarke, Walter, of Hadlegh, gent 0
3941482 2004161 2004161 defendant Chapman Thomas butcher 587635 587635 Chapman, Thomas, of Hadlegh, butcher 1
3969289 2013863 2013863 defendant Edward Edward mariner 587635 587635 Edward, Edward, of Hadlegh, mariner 6
4031586 2035959 2035959 defendant Trunchefeld Richard shoemaker 587635 587635 Trunchefeld, Richard, of Hadlegh, shoemaker 0
4451976 2185601 2185601 defendant Jacob John smith 587635 587635 Jacob, John, of Hadlegh, smith 0
4469007 2190981 2190981 defendant Maykons Thomas   587635 587635 Maykons, Thomas, of Hadlegh 0
4474717 2192756 2192756 defendant Mory John   587635 587635 Mory, John, of Hadlegh 2
4489389 2197402 2197402 defendant Sparowe Robert   587635 587635 Sparowe, Robert, of Hadlegh 0
4494273 2198901 2198901 defendant Parker John   587635 587635 Parker, John, of Hadlegh 0
4494281 2198903 2198903 defendant P--- John   587635 587635 P---, John, of Hadlegh 4
4494293 2198907 2198907 defendant Parker John   587635 587635 Parker, John, of Hadlegh 0
4514154 2204845 2204845 defendant Alderton William   587635 587635 Alderton, William, of Hadlegh 0
4529531 2209519 2209519 defendant Brounyng William   587635 587635 Brounyng, William, of Hadlegh 0
4529532 2209519 2209519 defendant Elys John fuller 587635 587635 Elys, John, of Hadlegh, fuller 1
4531911 2210247 2210247 plaintiff Plat Saveria   587635 587635 Plat, Saveria, of Hadlegh, formerly wife of John 0
4536636 2211738 2211738 plaintiff atte Stone Thomas, sen   587635 587635 atte Stone, Thomas, sen, of Hadlegh 1
4540452 2212913 2212913 defendant Tybbe John   587635 587635 Tybbe, John, of Hadlegh 0
4542567 2213560 2213560 plaintiff _emkyl Nicholas   587635 587635 _emkyl, Nicholas, of Hadlegh 0
4542568 2213560 2213560 defendant Bayn John   587635 587635 Bayn, John, of Hadlegh 0
4545249 2214435 2214435 defendant Tiryngton Henry   587635 587635 Tiryngton, Henry, of Hadlegh 0
4545255 2214436 2214436 defendant Tyryngton Henry   587635 587635 Tyryngton, Henry, of Hadlegh 0
4545815 2214621 2214621 defendant Cort John   587635 587635 Cort, John, of Hadlegh 0
4547615 2215191 2215191 defendant Skilman Thomas   587635 587635 Skilman, Thomas, of Hadlegh 0
4547616 2215191 2215191 defendant Prynce John   587635 587635 Prynce, John, of Hadlegh, wheel wright 1
4549957 2215918 2215918 defendant Bayn John   587635 587635 Bayn, John, of Hadlegh 0
4551463 2216397 2216397 plaintiff Dunton Augustine   587635 587635 Dunton, Augustine, of Hadlegh 0
4555795 2217751 2217751 plaintiff Hillary Robert   587635 587635 Hillary, Robert, of Hadlegh 0
4555796 2217751 2217751 defendant Kempston John   587635 587635 Kempston, John, of Hadlegh 0
4557926 2218409 2218409 defendant Doyre John   587635 587635 Doyre, John, of Hadlegh 1
4557929 2218409 2218409 defendant Man John   587635 587635 Man, John, of Hadlegh 4
4562614 2219864 2219864 defendant Lane Geoffrey in the chaplain 587635 587635 Lane, Geoffrey in the, of Hadlegh, chaplain 0
4574676 2223608 2223608 plaintiff Beton William (legal representative) 587635 587635 Beton, William, of Hadlegh, executors of 0
4575077 2223727 2223727 defendant Huntyngfeld John   587635 587635 Huntyngfeld, John, of Hadlegh 0
4579715 2225140 2225140 defendant Bayn Thomas   587635 587635 Bayn, Thomas, of Hadlegh 0
4585051 2226746 2226746 plaintiff Greyne Thomas   587635 587635 Greyne, Thomas, of Hadlegh 0
4589302 2228029 2228029 plaintiff Lestequeen John (legal representative) 587635 587635 Lestequeen, John, of Hadlegh, executors of 0
4589308 2228030 2228030 plaintiff Lestequeen John (legal representative) 587635 587635 Lestequeen, John, of Hadlegh, executors of 0
4589419 2228068 2228068 plaintiff Leye Ralph (legal representative) 587635 587635 Leye, Ralph, of Hadlegh, executors of 0
4590277 2228329 2228329 defendant Bayn Thomas   587635 587635 Bayn, Thomas, of Hadlegh 0
4594863 2229647 2229647 defendant Bradmere John   587635 587635 Bradmere, John, of Hadlegh 3
4597169 2230355 2230355 defendant Flyngaunt William   587635 587635 Flyngaunt, William, of Hadlegh 0
4597173 2230356 2230356 defendant Porter John, sen   587635 587635 Porter, John, sen, of Hadlegh 0
4597202 2230368 2230368 plaintiff Semere Richard   587635 587635 Semere, Richard, of Hadlegh 0
4597653 2230517 2230517 defendant Sadeler Peter   587635 587635 Sadeler, Peter, of Hadlegh 0
4597654 2230517 2230517 defendant Fuller Stephen   587635 587635 Fuller, Stephen, of Hadlegh 1
4597655 2230517 2230517 defendant Elys John   587635 587635 Elys, John, of Hadlegh 2
4597656 2230517 2230517 defendant Barbour Walter   587635 587635 Barbour, Walter, of Hadlegh 3
4599476 2231053 2231053 defendant atte Legh John   587635 587635 (atte Legh, John, of Hadlegh 1
4604700 2232636 2232636 defendant Page John   587635 587635 Page, John, of Hadlegh 0
4605775 2232921 2232921 plaintiff at Ston Thomas   587635 587635 at Ston, Thomas, of Hadlegh 0
4606007 2232995 2232995 plaintiff atte Stone Thomas   587635 587635 atte Stone, Thomas, of Hadlegh 0
4606009 2232995 2232995 defendant Hach Robert   587635 587635 Hach, Robert, of Hadlegh 1
4606010 2232996 2232996 plaintiff atte Stone Thomas   587635 587635 atte Stone, Thomas, of Hadlegh 0
4606499 2233143 2233143 plaintiff Bakere William   587635 587635 Bakere, William, of Hadlegh 0
4606500 2233143 2233143 defendant Cadyllere Peter   587635 587635 Cadyllere, Peter, of Hadlegh 0
4608080 2233641 2233641 defendant Hach Robert   587635 587635 Hach, Robert, of Hadlegh 0
4608081 2233641 2233641 defendant Armesby William   587635 587635 Armesby, William, of Hadlegh 1
4608395 2233737 2233737 defendant Millere Richard   587635 587635 Millere, Richard, of Hadlegh 0
4609407 2234043 2234043 plaintiff Bryon John   587635 587635 Bryon, John, of Hadlegh 0
4609410 2234043 2234043 defendant Doddere Thomas   587635 587635 Doddere, Thomas, of Hadlegh 2
4609411 2234043 2234043 defendant Dade Thomas   587635 587635 Dade, Thomas, of Hadlegh 3
4609412 2234043 2234043 defendant Benton Thomas   587635 587635 Benton, Thomas, of Hadlegh 4
4609631 2234109 2234109 defendant Peyt Simon   587635 587635 Peyt, Simon, of Hadlegh 1
4613595 2235267 2235267 defendant Gobyon Richard   587635 587635 Gobyon, Richard, of Hadlegh 1
4614736 2235620 2235620 defendant Elys John   587635 587635 Elys, John, of Hadlegh 0
4615770 2235928 2235928 defendant Pydebeff Robert   587635 587635 Pydebeff, Robert, of Hadlegh 0
4615779 2235930 2235930 defendant Smyth Stephen   587635 587635 Smyth, Stephen, of Hadlegh 0
4619202 2237002 2237002 defendant Ryngbelle James   587635 587635 Ryngbelle, James, of Hadlegh 5
4619203 2237002 2237002 defendant Haylok Thomas   587635 587635 Haylok, Thomas, of Hadlegh 6
4619332 2237041 2237041 plaintiff Hillary alias Dextere Robert   587635 587635 Hillary alias Dextere, Robert, of Hadlegh 0
4619719 2237154 2237154 defendant Smyth John   587635 587635 Smyth, John, of Hadlegh 0
4619721 2237155 2237155 defendant Smyth John   587635 587635 Smyth, John, of Hadlegh 0
4619907 2237207 2237207 defendant Gardener Robert   587635 587635 Gardener, Robert, of Hadlegh 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);