names

214 rows where place_id = 600191

✎ 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
3591274 1864897 1864897 plaintiff Drake John (legal representative) 600191 600191 Drake, John, of Wysbeche, executors of 0
3591277 1864898 1864898 plaintiff Drake John (legal representative) 600191 600191 Drake, John, of Wysbeche, executors of 0
3591282 1864899 1864899 plaintiff Drake John (legal representative) 600191 600191 Drake, John, of Wysbeche, executors of 0
3640129 1907359 1907359 plaintiff Wythe Thomas   600191 600191 Wythe, Thomas, of Wysbeche 0
3653788 1911443 1911443 plaintiff Wythe Thomas   600191 600191 Wythe, Thomas, of Wysbeche 0
3774672 1949810 1949810 defendant Danyell Lawrence gent 600191 600191 Danyell, Lawrence, of Wysbeche, gent 0
3920013 1997033 1997033 defendant Reynam John yeoman 600191 600191 Reynam, John, of Wysbeche, yeoman 1
3920014 1997033 1997033 defendant Emnyth William yeoman 600191 600191 Emnyth, William, of Wysbeche, yeoman 2
3920015 1997033 1997033 defendant Johnson William yeoman 600191 600191 Johnson, William, of Wysbeche, yeoman 3
3920018 1997034 1997034 defendant Deye William chandler 600191 600191 Deye, William, of Wysbeche, chandler 1
3920019 1997034 1997034 defendant Johnson Thomas husbandman 600191 600191 Johnson, Thomas, of Wysbeche, husbandman 2
3938738 2003297 2003297 defendant Rede Thomas (legal representative) 600191 600191 Rede, Thomas, of Wysbeche, gent, executors of 0
4468235 2190734 2190734 defendant Spenser John spicer 600191 600191 Spenser, John, of Wysbeche, spicer 0
4469743 2191210 2191210 defendant Johansone Aleyn taverner 600191 600191 Johansone, Aleyn, of Wysbeche, taverner 0
4496915 2199701 2199701 defendant Ferour Thomas   600191 600191 Ferour, Thomas, of Wysbeche 0
4509723 2203523 2203523 plaintiff Austynson Henry   600191 600191 Austynson, Henry, of Wysbeche 0
4586643 2227233 2227233 defendant Fadir John   600191 600191 Fadir, John, of Wysbeche 0
4588265 2227721 2227721 defendant Mawer John   600191 600191 Mawer, John, of Wysbeche 3
4593097 2229149 2229149 defendant Couper Richard   600191 600191 Couper, Richard, of Wysbeche 0
4604794 2232666 2232666 defendant Lathe Robert   600191 600191 Lathe, Robert, of Wysbeche 0
4623656 2238376 2238376 defendant Coupere Reginald   600191 600191 Coupere, Reginald, of Wysbeche 0
4671521 2256739 2256739 defendant White Addam husbandman 600191 600191 White, Addam, of Wysbeche, husbandman 0
4671522 2256739 2256739 defendant Smyth Mathew smith 600191 600191 Smyth, Mathew, of Wysbeche, smith 1
4678613 2258916 2258916 defendant Jonson Robert brewer 600191 600191 Jonson, Robert, of Wysbeche, brewer 0
4681453 2259816 2259816 defendant Wheneld Thomas husbandman 600191 600191 Wheneld, Thomas, of Wysbeche, husbandman 0
4693124 2263354 2263354 plaintiff Banham William   600191 600191 Banham, William, of Wysbeche 0
4722831 2272453 2272453 defendant Lombe Richard yeoman 600191 600191 Lombe, Richard, of Wysbeche, yeoman 1
4726178 2273471 2273471 defendant Mast William husbandman 600191 600191 Mast, William, of Wysbeche, husbandman 0
4734012 2275824 2275824 defendant Fyssher Thomas yeoman 600191 600191 Fyssher, Thomas, of Wysbeche, yeoman 0
4736050 2276415 2276415 defendant Jesep John glover 600191 600191 Jesep, John, of Wysbeche, glover 0
4736054 2276415 2276415 defendant Burwell Robert yeoman 600191 600191 Burwell, Robert, of Wysbeche, yeoman 4
4742897 2278431 2278431 defendant Halle Richard clerk 600191 600191 Halle, Richard, of Wysbeche, clerk 0
4742898 2278431 2278431 defendant Haverell Simon husbandman 600191 600191 Haverell, Simon, of wysbeche, husbandman 1
4752128 2281103 2281103 defendant Benet John husbandman 600191 600191 Benet, John, of Wysbeche, husbandman 0
4752129 2281103 2281103 defendant Wilkys John smith 600191 600191 Wilkys, John, of Wysbeche, smith 1
4756772 2282482 2282482 defendant Temer Henry husbandman 600191 600191 Temer, Henry, of Wysbeche, husbandman 2
4759552 2283328 2283328 plaintiff Claycroft John   600191 600191 Claycroft, John, of Wysbeche 0
4763403 2284542 2284542 defendant Belman William butcher 600191 600191 Belman, William, of Wysbeche, butcher 1
4763405 2284542 2284542 defendant Dunham John butcher 600191 600191 Dunham, John, of Wysbeche, butcher 3
4767271 2285750 2285750 defendant Williamesson Simon husbandman 600191 600191 Williamesson, Simon, of Wysbeche, husbandman 1
4767912 2285938 2285938 defendant Broun Peter husbandman 600191 600191 Broun, Peter, of Wysbeche, husbandman 2
4771243 2286989 2286989 defendant Tewe John yeoman 600191 600191 Tewe, John, of Wysbeche, yeoman 1
4771244 2286989 2286989 defendant Ferrour John yeoman 600191 600191 Ferrour, John, of Wysbeche, yeoman 2
4771249 2286990 2286990 defendant Halle Agnes single woman 600191 600191 Halle, Agnes, of Wysbeche, single woman 0
4771250 2286990 2286990 defendant Grene William   600191 600191 Grene, William, of Wysbeche, servant 1
4771251 2286990 2286990 defendant Ocle John   600191 600191 Ocle, John, of Wysbeche, glove maker 2
4771252 2286990 2286990 defendant Goldsmyth Marcus yeoman 600191 600191 Goldsmyth, Marcus, of Wysbeche, yeoman 3
4772821 2287469 2287469 defendant Brynkele Thomas tailor 600191 600191 Brynkele, Thomas, of Wysbeche, tailor 0
4774306 2287943 2287943 defendant Wryght William skinner 600191 600191 Wryght, William, of Wysbeche, skinner 0
4777366 2288913 2288913 defendant Williamesson Simon husbandman 600191 600191 Williamesson, Simon, of Wysbeche, husbandman 1
4780069 2289772 2289772 defendant Spellowe Adam yeoman 600191 600191 Spellowe, Adam, of Wysbeche, yeoman 0
4789682 2292841 2292841 defendant Clare John cordwainer 600191 600191 Clare, John, of Wysbeche, cordwainer 1
4789683 2292841 2292841 defendant Brynkeley Thomas husbandman 600191 600191 Brynkeley, Thomas, of Wysbeche, husbandman 2
4792335 2293689 2293689 defendant Broun Peter husbandman 600191 600191 Broun, Peter, of Wysbeche, husbandman 1
4795059 2294599 2294599 defendant Mannyng Simon butcher 600191 600191 Mannyng, Simon, of Wysbeche, butcher 0
4796253 2294975 2294975 plaintiff Salter William   600191 600191 Salter, William, of Wysbeche 0
4796258 2294976 2294976 plaintiff Salter William   600191 600191 Salter, William, of Wysbeche 0
4798385 2295682 2295682 defendant Broun Peter husbandman 600191 600191 Broun, Peter, of Wysbeche, husbandman 0
4798386 2295682 2295682 defendant Gose Gilbert husbandman 600191 600191 Gose, Gilbert, of Wysbeche, husbandman 1
4798387 2295682 2295682 defendant Wynter William husbandman 600191 600191 Wynter, William, of Wysbeche, husbandman 2
4798388 2295682 2295682 defendant Wright John husbandman 600191 600191 Wright, John, of Wysbeche, husbandman 3
4799746 2296106 2296106 defendant Attemere John barker 600191 600191 Attemere, John, of Wysbeche, barker 0
4799747 2296106 2296106 defendant Tylneye John yeoman 600191 600191 Tylneye, John, of Wysbeche, yeoman 1
4799748 2296106 2296106 defendant Lombe Richard   600191 600191 Lombe, Richard, of Wysbeche, white chandler 2
4801065 2296523 2296523 defendant Cook Thomas husbandman 600191 600191 Cook, Thomas, of Wysbeche, husbandman 0
4801503 2296650 2296650 plaintiff Loke Richard chaplain 600191 600191 (Loke, Richard, of Wysbeche, chaplain 1
4801504 2296650 2296650 plaintiff Lyly John chaplain 600191 600191 Lyly, John, of Wysbeche, chaplain 2
4801930 2296788 2296788 plaintiff Loke John chaplain 600191 600191 (Loke, John, of Wysbeche, chaplain 1
4801931 2296788 2296788 plaintiff Lyly John chaplain 600191 600191 Lyly, John, of Wysbeche, chaplain 2
4803851 2297380 2297380 defendant Belman William   600191 600191 Belman, William, of Wysbeche, bell man 5
4812448 2300005 2300005 defendant Drake Thomas yeoman 600191 600191 Drake, Thomas, of Wysbeche, yeoman 0
4812462 2300009 2300009 defendant Drake Thomas yeoman 600191 600191 Drake, Thomas, of Wysbeche, yeoman 0
4822574 2303136 2303136 defendant Paryssh John yeoman 600191 600191 Paryssh, John, of Wysbeche, yeoman 1
4847013 2310571 2310571 defendant Neuhous William husbandman 600191 600191 Neuhous, William, of Wysbeche, husbandman 3
4856720 2313475 2313475 defendant Thakker John waterman 600191 600191 Thakker, John, of Wysbeche, waterman 3
4859205 2314253 2314253 defendant Newehouse John husbandman 600191 600191 Newehouse, John, of Wysbeche, husbandman 0
4859345 2314304 2314304 defendant Wysbeche Simon   600191 600191 Wysbeche, Simon, of Wysbeche 0
4861486 2314961 2314961 defendant Whynell or Whyvell Thomas husbandman 600191 600191 Whynell or Whyvell, Thomas, of Wysbeche, husbandman 0
4863964 2315703 2315703 defendant Hopkyn John husbandman 600191 600191 Hopkyn, John, of Wysbeche, husbandman 3
4866496 2316481 2316481 defendant Burwell Robert yeoman 600191 600191 Burwell, Robert, of Wysbeche, yeoman 0
4874870 2319081 2319081 defendant Meryweder Thomas chapman 600191 600191 Meryweder, Thomas, of Wysbeche, chapman 2
4897226 2325788 2325788 defendant Kepe John brewer 600191 600191 Kepe, John, of Wysbeche, brewer 0
4906211 2328534 2328534 defendant Bonyng or Bovyng John husbandman 600191 600191 Bonyng or Bovyng, John, of Wysbeche, husbandman 0
4907773 2328993 2328993 defendant Barbour John fuller 600191 600191 Barbour, John, of Wysbeche, fuller 1
4907776 2328994 2328994 defendant Barbour John fuller 600191 600191 Barbour, John, of Wysbeche, fuller 1
4908754 2329286 2329286 defendant Averyll Richarde   600191 600191 Averyll, Richarde, of Wysbeche 0
4923808 2333889 2333889 defendant de Grene William yeoman 600191 600191 de Grene, William, of Wysbeche, yeoman 2
4923809 2333889 2333889 defendant Abell Ralph yeoman 600191 600191 Abell, Ralph, of Wysbeche, yeoman 3
4935421 2337475 2337475 defendant Tharald Margaret widow 600191 600191 Tharald, Margaret, of Wysbeche, widow 0
4946235 2340809 2340809 plaintiff Joly Thomas dyer 600191 600191 Joly, Thomas, of Wysbeche, dyer 0
4946236 2340809 2340809 defendant Methewode John   600191 600191 Methewode, John, of Wysbeche, wood maker 0
4958877 2344626 2344626 defendant Joly Thomas dyer 600191 600191 Joly, Thomas, of Wysbeche, dyer 1
4958878 2344626 2344626 defendant Flete Geoffrey husbandman 600191 600191 Flete, Geoffrey, of Wysbeche, husbandman 2
4958879 2344626 2344626 defendant Wryte John husbandman 600191 600191 Wryte, John, of Wysbeche, husbandman 3
4958880 2344626 2344626 defendant Grene William glover 600191 600191 Grene, William, of Wysbeche, glover 4
4958885 2344627 2344627 defendant Jovy Thomas dyer 600191 600191 Jovy, Thomas, of Wysbeche, dyer 1
4958886 2344627 2344627 defendant Flete Geoffrey husbandman 600191 600191 Flete, Geoffrey, of Wysbeche, husbandman 2
4958887 2344627 2344627 defendant Wryte John husbandman 600191 600191 Wryte, John, of Wysbeche, husbandman 3
4958888 2344627 2344627 defendant Grene William glover 600191 600191 Grene, William, of Wysbeche, glover 4
4960183 2345018 2345018 defendant Weldon Thomas chapman 600191 600191 Weldon, Thomas, of Wysbeche, chapman 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);