names

1,865 rows where place_id = 585970

✎ 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
3587604 1863770 1863770 defendant Hert Thomas taverner 585970 585970 Hert, Thomas, of Oxford, taverner 1
3587742 1863812 1863812 defendant Blakborn William vintner or fishmonger 585970 585970 Blakborn, William, of Oxford, vintner or fishmonger 0
3588133 1863938 1863938 defendant Bedowe John clerk 585970 585970 Bedowe, John, of Oxford, clerk 2
3589362 1864314 1864314 defendant Hokkebanke John tailor 585970 585970 Hokkebanke, John, of Oxford, tailor 1
3589665 1864409 1864409 defendant Smyth John chapman 585970 585970 Smyth, John, of Oxford, chapman 1
3589688 1864413 1864413 defendant Smyth John chapman 585970 585970 Smyth, John, of Oxford, chapman 2
3589975 1864505 1864505 defendant Skydmore Margaret (legal representative) 585970 585970 Skydmore, Margaret, of Oxford, widow, executor of 0
3589976 1864505 1864505 defendant Havell or Hanell John butcher 585970 585970 Havell or Hanell, John, of Oxford, butcher 1
3593259 1865525 1865525 defendant Kent Richard mercer 585970 585970 Kent, Richard, of Oxford, mercer 0
3593509 1865603 1865603 defendant Hanell or Hanell John butcher 585970 585970 Hanell or Hanell, John, of Oxford, butcher 0
3593965 1865751 1865751 defendant Skydmore Margaret (legal representative) 585970 585970 Skydmore, Margaret, of Oxford, widow, executrix of Skydmore, George, of Oxford, butcher, executor of 0
3593966 1865751 1865751 defendant Havell or Hanell John butcher 585970 585970 Havell or Hanell, John, of Oxford, butcher 1
3595234 1866144 1866144 defendant Norcotte Richard vintner 585970 585970 Norcotte, Richard, of Oxford, vintner 0
3597615 1866879 1866879 defendant Hokebanke John tailor 585970 585970 Hokebanke, John, of Oxford, tailor 1
3599858 1867606 1867606 defendant Seman John sherman 585970 585970 Seman, John, of Oxford, sherman 0
3599859 1867606 1867606 defendant Warde George clerk 585970 585970 Warde, George, of Oxford, clerk 1
3602933 1868581 1868581 defendant Wodcok Robert chapman 585970 585970 Wodcok, Robert, of Oxford, chapman 0
3603684 1868822 1868822 plaintiff Eggecomb John   585970 585970 Eggecomb, John, of Oxford 0
3603686 1868823 1868823 plaintiff Eggecomb John   585970 585970 Eggecomb, John, of Oxford 0
3603688 1868824 1868824 plaintiff Eggecomb John   585970 585970 Eggecomb, John, of Oxford 0
3607100 1869885 1869885 defendant Weston alias Fermour Henry yeoman or wax chandler 585970 585970 Weston alias Fermour, Henry, of Oxford, yeoman or wax chandler 0
3607357 1869962 1869962 plaintiff Rokesburgh John clerk 585970 585970 Rokesburgh, John, of Oxford, clerk 0
3607360 1869963 1869963 plaintiff Rokesburgh John clerk 585970 585970 Rokesburgh, John, of Oxford, clerk 0
3607363 1869964 1869964 plaintiff Rokesburgh John clerk 585970 585970 Rokesburgh, John, of Oxford, clerk 0
3607654 1870048 1870048 defendant Warden Thomas brewer 585970 585970 Warden, Thomas, of Oxford, brewer 6
3610536 1870958 1870958 defendant Couber Richard brewer 585970 585970 Couber, Richard, of Oxford, brewer 0
3612655 1871598 1871598 defendant Coke Christopher yeoman 585970 585970 Coke, Christopher, of Oxford, yeoman 0
3613013 1871719 1871719 defendant Fox Richard butcher 585970 585970 Fox, Richard, of Oxford, butcher 0
3613680 1871926 1871926 defendant Copeland William fishmonger 585970 585970 Copeland, William, of Oxford, fishmonger 0
3613767 1871959 1871959 defendant Roys John yeoman 585970 585970 Roys, John, of Oxford, yeoman 0
3614340 1872139 1872139 defendant Takley John cordwainer 585970 585970 Takley, John, of Oxford, cordwainer 0
3616230 1872717 1872717 defendant Palewell John vintner 585970 585970 Palewell, John, of Oxford, vintner 0
3616232 1872717 1872717 defendant Walker John   585970 585970 Walker, John, of Oxford, book seller 2
3616234 1872718 1872718 defendant Rokkesburgh John clerk 585970 585970 Rokkesburgh, John, of Oxford, clerk 0
3621533 1874277 1874277 defendant Frire Thomas tailor 585970 585970 Frire, Thomas, of Oxford, tailor 0
3622576 1874596 1874596 defendant Frire Thomas tailor 585970 585970 Frire, Thomas, of Oxford, tailor 0
3623749 1874961 1874961 plaintiff Souche James gent 585970 585970 Souche, James, of Oxford, gent 0
3625061 1875371 1875371 defendant Baxster Thomas hatmaker 585970 585970 Baxster, Thomas, of Oxford, hatmaker 1
3625799 1875607 1875607 defendant Baxster Roger yeoman 585970 585970 Baxster, Roger, of Oxford, yeoman 0
3625993 1902988 1902988 defendant Fryer William grocer 585970 585970 Fryer, William, of Oxford, grocer 1
3626000 1902989 1902989 defendant Blont Thomas grocer 585970 585970 Blont, Thomas, of Oxford, grocer 1
3626311 1903086 1903086 plaintiff Assheley John   585970 585970 Assheley, John, of Oxford 0
3630649 1904415 1904415 defendant Barlowe Richard cordwainer 585970 585970 Barlowe, Richard, of Oxford, cordwainer 0
3630650 1904415 1904415 defendant Mores Thomas baker 585970 585970 Mores, Thomas, of Oxford, baker 1
3630651 1904415 1904415 defendant Barbette Richard tailor 585970 585970 Barbette, Richard, of Oxford, tailor 2
3632000 1904824 1904824 defendant Hethe Michael husbandman 585970 585970 Hethe, Michael, of Oxford, husbandman 0
3632428 1904960 1904960 plaintiff Heynes John gent 585970 585970 Heynes, John, of Oxford, gent 0
3633282 1905227 1905227 defendant Bradfeld John yeoman 585970 585970 Bradfeld, John, of Oxford, yeoman 3
3634129 1905473 1905473 defendant Goderyche John clerk 585970 585970 Goderyche, John, of Oxford, clerk 0
3636330 1906154 1906154 defendant Heth Michael yeoman 585970 585970 Heth, Michael, of Oxford, yeoman 0
3636934 1906346 1906346 defendant Rogers John brewer 585970 585970 Rogers, John, of Oxford, brewer 1
3637500 1906540 1906540 plaintiff Smyth Thomas   585970 585970 Smyth, Thomas, of Oxford 0
3637946 1906687 1906687 defendant Archer John brewer 585970 585970 Archer, John, of Oxford, brewer 0
3639287 1907099 1907099 defendant Bocher John butcher 585970 585970 Bocher, John, of Oxford, butcher 1
3640611 1907504 1907504 defendant Broke John merchant 585970 585970 Broke, John, of Oxford, merchant 4
3641060 1907645 1907645 defendant Cooke John tailor 585970 585970 Cooke, John, of Oxford, tailor 0
3642110 1907981 1907981 defendant Hewster Thomas fishmonger 585970 585970 Hewster, Thomas, of Oxford, fishmonger 0
3642246 1908023 1908023 defendant Beneston William yeoman 585970 585970 Beneston, William, of Oxford, yeoman 1
3642247 1908023 1908023 defendant Heth Michael husbandman 585970 585970 Heth, Michael, of Oxford, husbandman 2
3645054 1908862 1908862 defendant Rogers John draper 585970 585970 Rogers, John, of Oxford, draper 0
3646340 1909248 1909248 defendant Dawes John chaplain 585970 585970 Dawes, John, of Oxford, chaplain 0
3646672 1909363 1909363 defendant Stede John   585970 585970 Stede, John, of Oxford, worsted loader 0
3649983 1910361 1910361 defendant Sparke William clerk 585970 585970 Sparke, William, of Oxford, clerk 1
3651122 1910718 1910718 defendant Clamond John clerk 585970 585970 Clamond, John, of Oxford, clerk 0
3651131 1910719 1910719 defendant Slamond John clerk 585970 585970 Slamond, John, of Oxford, clerk 0
3655049 1911843 1911843 plaintiff Bentley Thomas   585970 585970 Bentley, Thomas, of Oxford 0
3655050 1911843 1911843 defendant Gold John clerk 585970 585970 Gold, John, of Oxford, clerk 0
3656376 1912240 1912240 defendant Morys Thomas baker 585970 585970 Morys, Thomas, of Oxford, baker 0
3656580 1912313 1912313 defendant Wynslowe Richard pewterer 585970 585970 Wynslowe, Richard, of Oxford, pewterer 1
3658031 1912766 1912766 defendant Pantery Thomas   585970 585970 Pantery, Thomas, of Oxford, esq, head beadle & mace bearer of the Arts Faculty of the University 0
3658820 1913017 1913017 defendant Harrys John chaplain 585970 585970 Harrys, John, of Oxford, chaplain 1
3658821 1913017 1913017 defendant Michell Thomas clerk 585970 585970 Michell, Thomas, of Oxford, clerk 2
3658822 1913017 1913017 defendant Russhebury Thomas chaplain 585970 585970 Russhebury, Thomas, of Oxford, chaplain 3
3659535 1913242 1913242 defendant Franklyn Robert smith 585970 585970 Franklyn, Robert, of Oxford, smith 1
3659638 1913270 1913270 defendant Franglyn Robert smith 585970 585970 Franglyn, Robert, of Oxford, smith 1
3659648 1913272 1913272 defendant Gascoigne John tailor 585970 585970 Gascoigne, John, of Oxford, tailor 2
3659650 1913273 1913273 defendant Stede John   585970 585970 Stede, John, of Oxford, worsted maker 0
3659651 1913273 1913273 defendant Ferman Robert gent 585970 585970 Ferman, Robert, of Oxford, gent 1
3660409 1913513 1913513 defendant Trabor or Travor John hosier 585970 585970 Trabor or Travor, John, of Oxford, hosier 0
3660410 1913513 1913513 defendant Gamston Thomas carrier 585970 585970 Gamston, Thomas, of Oxford, carrier 1
3660412 1913514 1913514 defendant Travor John hosier 585970 585970 Travor, John, of Oxford, hosier 0
3660413 1913514 1913514 defendant Gamston Thomas carrier 585970 585970 Gamston, Thomas, of Oxford, carrier 1
3661806 1913975 1913975 defendant Boroedale Thomas yeoman 585970 585970 Boroedale, Thomas, of Oxford, yeoman 1
3663150 1914391 1914391 defendant Lynley John cobbler 585970 585970 Lynley, John, of Oxford, cobbler 0
3663684 1914577 1914577 defendant Cryppys Thomas   585970 585970 Cryppys, Thomas, of Oxford 1
3663874 1914639 1914639 defendant Kent Walter mercer 585970 585970 Kent, Walter, of Oxford, mercer 0
3663876 1914640 1914640 defendant Kent Walter mercer 585970 585970 Kent, Walter, of Oxford, mercer 0
3667246 1915691 1915691 plaintiff Wilford Edmund (legal representative) 585970 585970 Wilford, Edmund, of of Oxford, clerk of the University, executors of 0
3667249 1915691 1915691 defendant Style David   585970 585970 Style, David, of Oxford, apothecary 0
3667253 1915692 1915692 defendant Friar William   585970 585970 Friar, William, of Oxford, physician 0
3667305 1915713 1915713 defendant Friar William   585970 585970 Friar, William, of Oxford, physician 0
3667306 1915713 1915713 defendant Stephenson Giles yeoman 585970 585970 Stephenson, Giles, of Oxford, yeoman 1
3667307 1915713 1915713 defendant Style David   585970 585970 Style, David, of Oxford, apothecary 2
3667315 1915715 1915715 defendant Stephenson Giles yeoman 585970 585970 Stephenson, Giles, of Oxford, yeoman 0
3667840 1915883 1915883 defendant Spencer Robert   585970 585970 Spencer, Robert, of Oxford, fish monger 0
3669100 1916269 1916269 defendant Spencer Robert fishmonger 585970 585970 Spencer, Robert, of Oxford, fishmonger 0
3669408 1916371 1916371 defendant Willyams John baker 585970 585970 Willyams, John, of Oxford, baker 0
3669409 1916371 1916371 defendant Dyer John yeoman 585970 585970 Dyer, John, of Oxford, yeoman 1
3669410 1916371 1916371 defendant Fermer William yeoman 585970 585970 Fermer, William, of Oxford, yeoman 2
3669411 1916371 1916371 defendant Gyles William yeoman 585970 585970 Gyles, William, of Oxford, yeoman 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);