names

279 rows where place_id = 588304

✎ 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
3594052 1865780 1865780 defendant Ferrour John yeoman 588304 588304 Ferrour, John, of Bokkyng, yeoman 0
3604637 1869113 1869113 defendant Sutton Robert husbandman 588304 588304 Sutton, Robert, of Bokkyng, husbandman 1
3616999 1872937 1872937 defendant Pocche Richard butcher 588304 588304 Pocche, Richard, of Bokkyng, butcher 1
3617870 1873212 1873212 defendant May Robert clothier 588304 588304 (May, Robert, of Bokkyng, clothier 1
3617873 1873213 1873213 defendant May Robert clothier 588304 588304 (May, Robert, of Bokkyng, clothier 1
3618616 1873447 1873447 plaintiff Harware William husbandman 588304 588304 Harware, William, of Bokkyng, husbandman 0
3618619 1873447 1873447 defendant Whyte William yeoman 588304 588304 Whyte, William, of Bokkyng, yeoman 2
3619955 1873816 1873816 defendant Royson John fuller 588304 588304 Royson, John, of Bokkyng, fuller 1
3619956 1873816 1873816 defendant Alesonder or Alefonder John carpenter 588304 588304 Alesonder or Alefonder, John, of Bokkyng, carpenter 2
3629296 1904023 1904023 defendant Cowle John tanner 588304 588304 Cowle, John, of Bokkyng, tanner 1
3629297 1904023 1904023 defendant Wellys John yeoman 588304 588304 Wellys, John, of Bokkyng, yeoman 2
3637648 1906588 1906588 defendant Browne Michael yeoman 588304 588304 Browne, Michael, of Bokkyng, yeoman 0
3637649 1906588 1906588 defendant Idon William yeoman 588304 588304 Idon, William, of Bokkyng, yeoman 1
3637651 1906589 1906589 defendant Broun Michael yeoman 588304 588304 Broun, Michael, of Bokkyng, yeoman 0
3637652 1906589 1906589 defendant Idon William yeoman 588304 588304 Idon, William, of Bokkyng, yeoman 1
3661655 1913922 1913922 defendant Wyborowe John carier 588304 588304 Wyborowe, John, of Bokkyng, carier 1
3661855 1913994 1913994 defendant Freman Robert laborer 588304 588304 Freman, Robert, of Bokkyng, laborer 0
3685394 1921585 1921585 defendant Keteryche John   588304 588304 Keteryche, John, of Bokkyng, wheelwright 1
3693801 1924260 1924260 plaintiff May John, senior (legal representative) 588304 588304 May, John, senior, of Bokkyng, executor of May, Robert, of Bokyng, clothman, executrix of 0
3693894 1924295 1924295 plaintiff Mey John, junior (legal representative) 588304 588304 Mey, John, junior, of Bokkyng, executor of Mey, Robert, of Bokkyng, clothman, executrix of 0
3714028 1930686 1930686 defendant Hubberd John clothier 588304 588304 Hubberd, John, of Bokkyng, clothier 0
3716332 1931399 1931399 plaintiff Clovyle Edward (legal representative) 588304 588304 Clovyle, Edward, of Bokkyng, esq, executrix of 0
3729747 1935559 1935559 defendant Hubberd John clothier 588304 588304 Hubberd, John, of Bokkyng, clothier 0
3731898 1936208 1936208 plaintiff Clovyle Edward (legal representative) 588304 588304 Clovyle, Edward, of Bokkyng, esq, executrix of 0
3745962 1940644 1940644 defendant Somercote Thomas butcher 588304 588304 Somercote, Thomas, of Bokkyng, butcher 0
3756286 1943927 1943927 defendant Man William weaver 588304 588304 Man, William, of Bokkyng, weaver 3
3772327 1949030 1949030 defendant Man William weaver 588304 588304 Man, William, of Bokkyng, weaver 3
3777450 1950696 1950696 defendant Halle John butcher 588304 588304 Halle, John, of Bokkyng, butcher 0
3789846 1954652 1954652 defendant Warner Thomas husbandman 588304 588304 Warner, Thomas, of Bokkyng, husbandman 0
3800428 1958057 1958057 defendant Morell Richard yeoman 588304 588304 Morell, Richard, of Bokkyng, yeoman 0
3800429 1958057 1958057 defendant Turnor Robert butcher 588304 588304 Turnor, Robert, of Bokkyng, butcher 1
3800430 1958057 1958057 defendant Man William weaver 588304 588304 Man, William, of Bokkyng, weaver 2
3827168 1966360 1966360 plaintiff Bokkyng Richard gent 588304 588304 Bokkyng, Richard, of Bokkyng, gent 0
3833285 1968337 1968337 defendant Harrys John laborer 588304 588304 Harrys, John, of Bokkyng, laborer 0
3856523 1975667 1975667 defendant Dunbabyn James yeoman 588304 588304 Dunbabyn, James, of Bokkyng, yeoman 0
3895559 1988719 1988719 defendant Garrarde alias Garratt William yeoman 588304 588304 Garrarde alias Garratt, William, of Bokkyng, yeoman 0
3906708 1992537 1992537 defendant Cotton Joan widow 588304 588304 Cotton, Joan, of Bokkyng, widow 0
3913892 1994993 1994993 defendant Ussher William yeoman 588304 588304 Ussher, William, of Bokkyng, yeoman 0
3913894 1994994 1994994 defendant Ussher William yeoman 588304 588304 Ussher, William, of Bokkyng, yeoman 0
3924684 1998570 1998570 defendant Colysor Christopher tailor 588304 588304 Colysor, Christopher, of Bokkyng, tailor 1
3954104 2008508 2008508 defendant Loveday Thomas clothier 588304 588304 Loveday, Thomas, of Bokkyng, clothier 0
4422263 2171832 2171832 defendant Dunnemawe John dyer 588304 588304 Dunnemawe, John, of Bokkyng, dyer 0
4426197 2172997 2172997 defendant Pacche John   588304 588304 Pacche, John, of Bokkyng 0
4505875 2202345 2202345 plaintiff Strang John draper 588304 588304 Strang, John, of Bokkyng, draper, on his own account 0
4505877 2202346 2202346 plaintiff Strang John draper 588304 588304 Strang, John, of Bokkyng, draper, on his own account 0
4526872 2208681 2208681 defendant Hamstede William   588304 588304 Hamstede, William, of Bokkyng 2
4571425 2222649 2222649 defendant Richard John, sen   588304 588304 Richard, John, sen, of Bokkyng 2
4573880 2223348 2223348 defendant Cay Geoffrey   588304 588304 Cay, Geoffrey, of Bokkyng 0
4577373 2224438 2224438 defendant Bray John   588304 588304 Bray, John, of Bokkyng 0
4582988 2226105 2226105 defendant Assh John   588304 588304 Assh, John, of Bokkyng 0
4596510 2230149 2230149 defendant Dyer Robert   588304 588304 Dyer, Robert, of Bokkyng 1
4607319 2233399 2233399 defendant Iden Philip   588304 588304 Iden, Philip, of Bokkyng 0
4607567 2233476 2233476 plaintiff Bertelot Thomas   588304 588304 Bertelot, Thomas, of Bokkyng 0
4627092 2239424 2239424 plaintiff Renkyn William   588304 588304 Renkyn, William, of Bokkyng 0
4628009 2239682 2239682 defendant Dyere Adam   588304 588304 Dyere, Adam, of Bokkyng 0
4633180 2241247 2241247 plaintiff Warde John   588304 588304 Warde, John, of Bokkyng 0
4640649 2243374 2243374 defendant Baron John   588304 588304 Baron, John, of Bokkyng 3
4640670 2243377 2243377 defendant Baron John   588304 588304 Baron, John, of Bokkyng 3
4654849 2247393 2247393 defendant Bartelot Thomas chandler 588304 588304 Bartelot, Thomas, of Bokkyng, chandler 0
4657949 2248370 2248370 plaintiff Compton John   588304 588304 Compton, John, of Bokkyng 0
4657951 2248371 2248371 plaintiff Compton John   588304 588304 Compton, John, of Bokkyng 0
4661200 2249329 2249329 plaintiff Dyere John   588304 588304 Dyere, John, of Bokkyng 0
4674471 2257625 2257625 defendant Grantham Robert dyer 588304 588304 Grantham, Robert, of Bokkyng, dyer 0
4674473 2257626 2257626 defendant Grantham Robert dyer 588304 588304 Grantham, Robert, of Bokkyng, dyer 0
4679482 2259197 2259197 defendant Shaldeford William husbandman 588304 588304 Shaldeford, William, of Bokkyng, husbandman 3
4679483 2259197 2259197 defendant Chambre John husbandman 588304 588304 Chambre, John, of Bokkyng, husbandman 4
4707464 2267711 2267711 defendant Shaldeford William husbandman 588304 588304 Shaldeford, William, of Bokkyng, husbandman 1
4707465 2267711 2267711 defendant Estfeld John husbandman 588304 588304 Estfeld, John, of Bokkyng, husbandman 2
4713766 2269629 2269629 defendant Whithede Simon butcher 588304 588304 Whithede, Simon, of Bokkyng, butcher 0
4715491 2270183 2270183 plaintiff Warde John (legal representative) 588304 588304 Warde, John, of Bokkyng, executors of 0
4715501 2270183 2270183 defendant Neweman John husbandman 588304 588304 Neweman, John, of Bokkyng, husbandman 4
4715502 2270184 2270184 plaintiff Warde John (legal representative) 588304 588304 Warde, John, of Bokkyng, executors of 0
4715512 2270185 2270185 plaintiff Warde John (legal representative) 588304 588304 Warde, John, of Bokkyng, executors of 0
4716319 2270416 2270416 plaintiff Whithed Simon   588304 588304 Whithed, Simon, of Bokkyng 0
4716320 2270416 2270416 defendant Rysby John tailor 588304 588304 Rysby, John, of Bokkyng, tailor 0
4722452 2272341 2272341 defendant Bolthood William farmer 588304 588304 Bolthood, William, of Bokkyng, farmer 1
4722987 2272500 2272500 defendant Purye Henry yeoman 588304 588304 Purye, Henry, of Bokkyng, yeoman 2
4723261 2272585 2272585 defendant Dytton Robert husbandman 588304 588304 Dytton, Robert, of Bokkyng, husbandman 2
4734708 2276011 2276011 plaintiff Shaldyrford alias Webbe William   588304 588304 Shaldyrford alias Webbe, William, of Bokkyng 0
4735056 2276114 2276114 defendant Lane William husbandman 588304 588304 Lane, William, of Bokkyng, husbandman 0
4735073 2276118 2276118 defendant Dunmowe John fuller 588304 588304 Dunmowe, John, of Bokkyng, fuller 1
4740378 2277697 2277697 plaintiff Baldewen John de dyer 588304 588304 Baldewen, John de, of Bokkyng, dyer 0
4743552 2278641 2278641 defendant Kyng John (legal representative) 588304 588304 Kyng, John, of Bokkyng, parson, administrator of 3
4747162 2279674 2279674 defendant Bolthoode William husbandman 588304 588304 Bolthoode, William, of Bokkyng, husbandman 1
4751082 2280798 2280798 defendant Noble Thomas yeoman 588304 588304 Noble, Thomas, of Bokkyng, yeoman 3
4751520 2280929 2280929 defendant Love or Lone William husbandman 588304 588304 Love or Lone, William, of Bokkyng, husbandman 0
4751522 2280929 2280929 defendant Sturgeon William carpenter 588304 588304 Sturgeon, William, of Bokkyng, carpenter 2
4761995 2284098 2284098 defendant Bolthod William farmer 588304 588304 Bolthod, William, of Bokkyng, farmer 1
4764607 2284916 2284916 defendant Noble Thomas husbandman 588304 588304 Noble, Thomas, of Bokkyng, husbandman 0
4765713 2285272 2285272 defendant Shaldeford William husbandman 588304 588304 Shaldeford, William, of Bokkyng, husbandman 1
4767144 2285710 2285710 defendant Bone Richard husbandman 588304 588304 Bone, Richard, of Bokkyng, husbandman 1
4767145 2285710 2285710 defendant Wilby John husbandman 588304 588304 Wilby, John, of Bokkyng, husbandman 2
4767146 2285710 2285710 defendant Gyles Benedict husbandman 588304 588304 Gyles, Benedict, of Bokkyng, husbandman 3
4767147 2285710 2285710 defendant Barbour Thomas husbandman 588304 588304 Barbour, Thomas, of Bokkyng, husbandman 4
4771952 2287200 2287200 defendant Shaldford William husbandman 588304 588304 (Shaldford, William, of Bokkyng, husbandman 2
4772636 2287411 2287411 defendant Gamelyn Thomas dyer 588304 588304 Gamelyn, Thomas, of Bokkyng, dyer 0
4772874 2287487 2287487 defendant Cook John husbandman 588304 588304 Cook, John, of Bokkyng, husbandman 2
4776724 2288712 2288712 defendant Pach Peter laborer 588304 588304 Pach, Peter, of Bokkyng, laborer 1
4785450 2291469 2291469 defendant Bolthod William farmer 588304 588304 Bolthod, William, of Bokkyng, farmer 1
4787262 2292086 2292086 defendant Bocher Simon butcher 588304 588304 Bocher, Simon, of Bokkyng, butcher 3

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