names

134 rows where place_id = 597039

✎ 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
3627047 1903320 1903320 defendant Powne William fuller 597039 597039 Powne, William, of Newbury, fuller 1
3627048 1903320 1903320 defendant Carpenter William fuller 597039 597039 Carpenter, William, of Newbury, fuller 2
3654959 1911812 1911812 defendant Griffith Philip yeoman 597039 597039 (Griffith, Philip, of Newbury, yeoman 3
3669057 1916253 1916253 defendant Andrewys John yeoman 597039 597039 Andrewys, John, of Newbury, yeoman 0
3681845 1920427 1920427 defendant Seer Thomas fuller 597039 597039 Seer, Thomas, of Newbury, fuller 0
3681847 1920427 1920427 defendant Andrewes John yeoman 597039 597039 Andrewes, John, of Newbury, yeoman 2
3681848 1920427 1920427 defendant Gryffyth Philip yeoman 597039 597039 Gryffyth, Philip, of Newbury, yeoman 3
3683530 1920981 1920981 defendant Andrewys John yeoman 597039 597039 Andrewys, John, of Newbury, yeoman 0
3685742 1921697 1921697 defendant Repon Thomas clothman 597039 597039 Repon, Thomas, of Newbury, clothman 2
3690610 1923227 1923227 defendant Mey Henry yeoman 597039 597039 Mey, Henry, of Newbury, yeoman 1
3690698 1923257 1923257 defendant Elys John yeoman 597039 597039 Elys, John, of Newbury, yeoman 0
3715932 1931269 1931269 defendant Lorymer Richard weaver 597039 597039 Lorymer, Richard, of Newbury, weaver 0
3715934 1931270 1931270 defendant Turnour John weaver 597039 597039 Turnour, John, of Newbury, weaver 0
3715935 1931270 1931270 defendant Cowper William butcher 597039 597039 Cowper, William, of Newbury, butcher 1
3720887 1932828 1932828 defendant Pondys Christopher clothier 597039 597039 Pondys, Christopher, of Newbury, clothier 3
3720888 1932828 1932828 defendant Mey Henry clothier 597039 597039 Mey, Henry, of Newbury, clothier 4
3756570 1944035 1944035 defendant Sharpe Edward clothmaker 597039 597039 Sharpe, Edward, of Newbury, clothmaker 0
3804258 1959264 1959264 defendant May Henry fuller 597039 597039 May, Henry, of Newbury, fuller 0
3804260 1959264 1959264 defendant Seson Thomas dyer 597039 597039 Seson, Thomas, of Newbury, dyer 2
3808552 1960552 1960552 defendant Hoper Henry dyer 597039 597039 Hoper, Henry, of Newbury, dyer 0
3858836 1976444 1976444 defendant Palmer Richard mercer 597039 597039 Palmer, Richard, of Newbury, mercer 0
3858838 1976444 1976444 defendant Stere John miller 597039 597039 Stere, John, of Newbury, miller 2
3859942 1976827 1976827 defendant Tytyng Robert fuller 597039 597039 Tytyng, Robert, of Newbury, fuller 0
3873046 1981199 1981199 defendant Stere John miller 597039 597039 Stere, John, of Newbury, miller 2
3876586 1982415 1982415 defendant Faller Robert chandler 597039 597039 Faller, Robert, of Newbury, chandler 0
3885269 1985326 1985326 plaintiff Barkysdale John clothman 597039 597039 Barkysdale, John, of Newbury, clothman 0
3891203 1987325 1987325 plaintiff Knyght John gent 597039 597039 Knyght, John, of Newbury, gent 0
3900140 1990272 1990272 plaintiff Bruges Richard Esq 597039 597039 Bruges, Richard, of Newbury, Esq 0
3930070 2000401 2000401 plaintiff Cock Richard mercer 597039 597039 Cock, Richard, of Newbury, mercer 0
3965190 2012436 2012436 defendant Hollawaye Francis yeoman 597039 597039 Hollawaye, Francis, of Newbury, yeoman 0
3972267 2014864 2014864 defendant Twyne William sherman 597039 597039 Twyne, William, of Newbury, sherman 0
4004150 2026258 2026258 plaintiff Hynde Henry mercer 597039 597039 Hynde, Henry, of Newbury, mercer 0
4041718 2039520 2039520 plaintiff Stocker Gilbert   597039 597039 Stocker, Gilbert, of Newbury, linen draper 1
4041721 2039521 2039521 plaintiff Stocker Gilbert   597039 597039 Stocker, Gilbert, of Newbury, linen draper 1
4041724 2039522 2039522 plaintiff Stocker Gilbert   597039 597039 Stocker, Gilbert, of Newbury, linen draper 1
4041727 2039523 2039523 plaintiff Stocker Gilbert   597039 597039 Stocker, Gilbert, of Newbury, linen draper 1
4041730 2039524 2039524 plaintiff Stocker Gilbert   597039 597039 Stocker, Gilbert, of Newbury, linen draper 1
4041733 2039525 2039525 plaintiff Stocker Gilbert   597039 597039 Stocker, Gilbert, of Newbury, linen draper 1
4041736 2039526 2039526 plaintiff Stocker Gilbert   597039 597039 Stocker, Gilbert, of Newbury, linen draper 1
4041737 2039526 2039526 defendant Vertew John fuller 597039 597039 Vertew, John, of Newbury, fuller 0
4073337 2050752 2050752 plaintiff Phillipps John capper 597039 597039 Phillipps, John, of Newbury, capper 0
4073338 2050752 2050752 defendant Morrell David mercer 597039 597039 Morrell, David, of Newbury, mercer 0
4171785 2085591 2085591 defendant Wylkenson Griffin chandler 597039 597039 Wylkenson, Griffin, of Newbury, chandler 0
4217115 2101479 2101479 defendant Cranage Thomas butcher 597039 597039 Cranage, Thomas, of Newbury, or of Spenhamland, butcher 0
4303777 2131449 2131449 defendant Slococke Thomas yeoman 597039 597039 Slococke, Thomas, of Newbury, or of Hampstede Marshall, yeoman 0
4303778 2131449 2131449 defendant Tarrant John shoemaker 597039 597039 Tarrant, John, of Newbury, or of Kyntbury Egle, shoemaker 1
4303780 2131450 2131450 defendant Davy Nicholas weaver 597039 597039 Davy, Nicholas, of Newbury, weaver 0
4303781 2131450 2131450 defendant Foster John joiner 597039 597039 Foster, John, of Newbury, joiner 1
4306606 2132448 2132448 defendant Grenewaye John tailor 597039 597039 Grenewaye, John, of Newbury, or of Shawebridge, tailor 0
4414357 2169402 2169402 defendant atte Hyde John   597039 597039 atte Hyde, John, of Newbury 0
4414359 2169403 2169403 defendant atte Hyde John   597039 597039 atte Hyde, John, of Newbury 0
4474597 2192716 2192716 defendant Motthe John   597039 597039 Motthe, John, of Newbury 1
4484377 2195810 2195810 defendant Smyth Roger   597039 597039 Smyth, Roger, of Newbury 0
4484378 2195810 2195810 defendant Sa-- John   597039 597039 Sa--, John, of Newbury 1
4522566 2207396 2207396 defendant Baker Richard   597039 597039 Baker, Richard, of Newbury 0
4535230 2211283 2211283 defendant Chapman Henry   597039 597039 Chapman, Henry, of Newbury, servant of Simon Chapman 0
4535670 2211433 2211433 plaintiff Smyth Roger   597039 597039 Smyth, Roger, of Newbury 0
4579165 2224966 2224966 defendant Hayward John   597039 597039 Hayward, John, of Newbury 1
4586048 2227060 2227060 defendant Messager Nicholas   597039 597039 Messager, Nicholas, of Newbury 0
4613735 2235310 2235310 defendant Megge William   597039 597039 Megge, William, of Newbury 0
4627578 2239558 2239558 defendant Bathe John   597039 597039 Bathe, John, of Newbury 2
4629111 2240029 2240029 defendant Sutton John   597039 597039 Sutton, John, of Newbury 0
4637943 2242632 2242632 defendant Baudewene John   597039 597039 Baudewene, John, of Newbury 9
4646645 2245082 2245082 defendant Bathe John   597039 597039 Bathe, John, of Newbury 0
4692945 2263303 2263303 defendant Tounesdnde Edward husbandman 597039 597039 Tounesdnde, Edward, of Newbury, husbandman 0
4712957 2269366 2269366 defendant Webbe Robert laborer 597039 597039 Webbe, Robert, of Newbury, laborer 1
4721173 2271955 2271955 defendant Motthe John (legal representative) 597039 597039 Motthe, John, of Newbury, administrator of 5
4732876 2275458 2275458 defendant Smyth Robert yeoman 597039 597039 Smyth, Robert, of Newbury, yeoman 0
4760954 2283769 2283769 plaintiff Deneman Robert (legal representative) 597039 597039 Deneman, Robert, of Newbury, executor of 0
4762172 2284148 2284148 defendant Baker Richard husbandman 597039 597039 Baker, Richard, of Newbury, husbandman 0
4765504 2285202 2285202 defendant Aston John laborer 597039 597039 Aston, John, of Newbury, laborer 0
4765505 2285202 2285202 defendant Pannyng John   597039 597039 Pannyng, John, of Newbury, servant 1
4770477 2286742 2286742 defendant Heyne Robert husbandman 597039 597039 Heyne, Robert, of Newbury, husbandman 0
4830792 2305658 2305658 defendant Sawesere Thomas chapman 597039 597039 Sawesere, Thomas, of Newbury, chapman 0
4834274 2306730 2306730 defendant Fryth Robert draper 597039 597039 Fryth, Robert, of Newbury, draper 0
4835732 2307174 2307174 plaintiff Draper Roger   597039 597039 Draper, Roger, of Newbury 0
4835734 2307174 2307174 defendant Wynet Hugh fuller 597039 597039 Wynet, Hugh, of Newbury, fuller 0
4837802 2307757 2307757 defendant Messynger Nicholas yeoman 597039 597039 Messynger, Nicholas, of Newbury, yeoman 0
4837803 2307757 2307757 defendant Fryth Robert hosier 597039 597039 Fryth, Robert, of Newbury, hosier 1
4840484 2308562 2308562 defendant Banden or Bauden John husbandman 597039 597039 Banden or Bauden, John, of Newbury, husbandman 0
4841229 2308794 2308794 defendant Tounsende Edward chapman 597039 597039 Tounsende, Edward, of Newbury, chapman 0
4841230 2308794 2308794 defendant Draper Roger hosier 597039 597039 Draper, Roger, of Newbury, hosier 1
4913209 2330630 2330630 plaintiff Chippns John   597039 597039 Chippns, John, of Newbury 0
4914721 2331121 2331121 plaintiff Darell Thomas   597039 597039 Darell, Thomas, of Newbury 0
4978509 2350521 2350521 defendant Addesbury Richard gent 597039 597039 Addesbury, Richard, of Newbury, gent 0
4991873 2354455 2354455 plaintiff Coteler Thomas mercer 597039 597039 Coteler, Thomas, of Newbury, mercer 0
4992114 2354533 2354533 defendant Newebrigge Thomas fuller 597039 597039 Newebrigge, Thomas, of Newbury, fuller 0
4992115 2354533 2354533 defendant Lynne John carpenter 597039 597039 Lynne, John, of Newbury, carpenter 1
4994377 2355193 2355193 defendant Graunt John skinner 597039 597039 Graunt, John, of Newbury, skinner 0
4996407 2355783 2355783 defendant Cateleyn Robert yeoman 597039 597039 Cateleyn, Robert, of Newbury, yeoman 0
4998496 2356431 2356431 plaintiff Justyse John weaver 597039 597039 Justyse, John, of Newbury, weaver 0
5003540 2357931 2357931 defendant Fryth alias Hosyer Robert hosier 597039 597039 Fryth alias Hosyer, Robert, of Newbury, hosier 0
5006753 2358871 2358871 defendant Petyte Nicholas fuller 597039 597039 Petyte, Nicholas, of Newbury, fuller 1
5050085 2371647 2371647 defendant Smyth William chapman 597039 597039 Smyth, William, of Newbury, chapman 2
5076038 2379330 2379330 defendant Chyppes John kerseyman 597039 597039 Chyppes, John, of Newbury, kerseyman 0
5129622 2395155 2395155 defendant Devenysshe Richard yeoman 597039 597039 Devenysshe, Richard, of Newbury, yeoman 0
5136529 2397199 2397199 plaintiff Okeham John   597039 597039 Okeham, John, of Newbury 0
5143801 2399322 2399322 defendant Graunt John skinner 597039 597039 Graunt, John, of Newbury, skinner 1
5143802 2399322 2399322 defendant Spencer John mercer 597039 597039 Spencer, John, of Newbury, mercer 2
5143803 2399322 2399322 defendant Whithig John dyer 597039 597039 Whithig, John, of Newbury, dyer 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);