names

113 rows where place_id = 757836

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4448994 2184629 2184629 plaintiff Gayton John de skinner 757836 757836 Gayton, John de, of Pountfreyt, skinner 0
4448995 2184629 2184629 defendant Wakefeld Thomas de (legal representative) 757836 757836 Wakefeld, Thomas de, of Pountfreyt, executor of 0
4448996 2184629 2184629 defendant Wakefold William de   757836 757836 Wakefold, William de, of Pountfreyt 1
4461586 2188700 2188700 defendant Forster Emma   757836 757836 Forster, Emma, of Pountfreyt, formerly wife of Robert 2
4485086 2196034 2196034 defendant White John   757836 757836 White, John, of Pountfreyt 1
4534493 2211059 2211059 defendant Fenton William de   757836 757836 Fenton, William de, of Pountfreyt 1
4547729 2215228 2215228 defendant Latewys John   757836 757836 Latewys, John, of Pountfreyt 0
4550850 2216201 2216201 defendant Fenton William de   757836 757836 Fenton, William de, of Pountfreyt 1
4552221 2216649 2216649 plaintiff Farneley Warin de   757836 757836 Farneley, Warin de, of Pountfreyt 0
4552222 2216649 2216649 defendant Dawe Simon shoemaker 757836 757836 Dawe, Simon, of Pountfreyt, shoemaker 0
4552695 2216795 2216795 plaintiff Forster John   757836 757836 Forster, John, of Pountfreyt 0
4555653 2217697 2217697 defendant Caudray John dyer 757836 757836 Caudray, John, of Pountfreyt, dyer 0
4559566 2218942 2218942 plaintiff Metheley John de skinner 757836 757836 Metheley, John de, of Pountfreyt, skinner 0
4562689 2219888 2219888 defendant Hesyll John   757836 757836 Hesyll, John, of Pountfreyt 0
4565906 2220892 2220892 defendant Fraunceys William   757836 757836 Fraunceys, William, of Pountfreyt 0
4580846 2225492 2225492 defendant Gilmyn Thomas   757836 757836 Gilmyn, Thomas, of Pountfreyt 0
4581915 2225792 2225792 defendant Rankyn Richard   757836 757836 Rankyn, Richard, of Pountfreyt 0
4599620 2231096 2231096 defendant Fraunceys William   757836 757836 Fraunceys, William, of Pountfreyt 0
4606787 2233236 2233236 defendant Flemyng William   757836 757836 Flemyng, William, of Pountfreyt 0
4609183 2233977 2233977 plaintiff Broune John   757836 757836 Broune, John, of Pountfreyt 0
4612393 2234946 2234946 defendant Geffray John   757836 757836 Geffray, John, of Pountfreyt 3
4612561 2234996 2234996 defendant Asshe Robert (legal representative) 757836 757836 Asshe, Robert, of Pountfreyt, executors of 0
4612565 2234997 2234997 defendant York John de   757836 757836 York, John de, of Pountfreyt 0
4612566 2234997 2234997 defendant Ylys Ralph de   757836 757836 Ylys, Ralph de, of Pountfreyt 1
4618278 2236725 2236725 defendant Carleton John de   757836 757836 Carleton, John de, of Pountfreyt 3
4620107 2237270 2237270 defendant Whitlay Robert skinner 757836 757836 Whitlay, Robert, of Pountfreyt, skinner 2
4620108 2237270 2237270 defendant Godered Thomas tailor 757836 757836 Godered, Thomas, of Pountfreyt, tailor 3
4620109 2237270 2237270 defendant Snawe Adam plasterer 757836 757836 Snawe, Adam, of Pountfreyt, plasterer 4
4620110 2237270 2237270 defendant Bereswerd John skinner 757836 757836 Bereswerd, John, of Pountfreyt, skinner 5
4626415 2239213 2239213 defendant Lewes John   757836 757836 Lewes, John, of Pountfreyt 3
4627323 2239489 2239489 defendant Sutton William   757836 757836 Sutton, William, of Pountfreyt 1
4631900 2240861 2240861 defendant Dunsford John   757836 757836 Dunsford, John, of Pountfreyt 0
4632683 2241108 2241108 plaintiff Wakefeld William   757836 757836 Wakefeld, William, of Pountfreyt 0
4632690 2241109 2241109 plaintiff Wakefeld William   757836 757836 Wakefeld, William, of Pountfreyt 0
4639862 2243163 2243163 plaintiff Thornton John   757836 757836 (Thornton, John, of Pountfreyt, vicar 1
4640125 2243229 2243229 plaintiff del Hall William   757836 757836 del Hall, William, of Pountfreyt 0
4642896 2244034 2244034 plaintiff Hiprom John   757836 757836 Hiprom, John, of Pountfreyt 0
4642898 2244035 2244035 plaintiff Hiprom John   757836 757836 Hiprom, John, of Pountfreyt 0
4642899 2244035 2244035 defendant Warrewyk Nicholas   757836 757836 Warrewyk, Nicholas, of Pountfreyt 0
4642901 2244035 2244035 defendant Spellowe William   757836 757836 Spellowe, William, of Pountfreyt 2
4647011 2245188 2245188 defendant Sutton William   757836 757836 Sutton, William, of Pountfreyt 4
4647012 2245188 2245188 defendant Sutton John   757836 757836 Sutton, John, of Pountfreyt 5
4647013 2245188 2245188 defendant York John   757836 757836 York, John, of Pountfreyt 6
4647021 2245189 2245189 defendant Sutton William   757836 757836 Sutton, William, of Pountfreyt 4
4647022 2245189 2245189 defendant Sutton John   757836 757836 Sutton, John, of Pountfreyt 5
4647023 2245189 2245189 defendant (illegible) John   757836 757836 _, John, of Pountfreyt 6
4650358 2246127 2246127 defendant Hamylton John   757836 757836 Hamylton, John, of Pountfreyt 0
4653267 2246961 2246961 defendant Huchonson John tailor 757836 757836 Huchonson, John, of Pountfreyt, tailor 0
4661325 2249365 2249365 defendant Abraham John draper 757836 757836 Abraham, John, of Pountfreyt, draper 0
4663084 2249918 2249918 defendant Brunby John gent 757836 757836 Brunby, John, of Pountfreyt, gent 1
4663448 2250044 2250044 plaintiff Godfray John   757836 757836 Godfray, John, of Pountfreyt 0
4675927 2258080 2258080 defendant Brystall Robert swerdsliper or maker of sword sheaths 757836 757836 Brystall, Robert, of Pountfreyt, swerdsliper or maker of sword sheaths 0
4676789 2258362 2258362 plaintiff Grene John draper 757836 757836 Grene, John, of Pountfreyt, draper 0
4678033 2258741 2258741 defendant Larkestok Robert yeoman 757836 757836 Larkestok, Robert, of Pountfreyt, yeoman 4
4688193 2261875 2261875 plaintiff Taillour Henry   757836 757836 Taillour, Henry, of Pountfreyt 0
4691713 2262941 2262941 defendant Baghill John skinner 757836 757836 Baghill, John, of Pountfreyt, skinner 3
4701966 2266023 2266023 defendant Vaus William butcher 757836 757836 Vaus, William, of Pountfreyt, butcher 1
4723391 2272626 2272626 plaintiff del Hall William   757836 757836 del Hall, William, of Pountfreyt 0
4735032 2276103 2276103 defendant Yong Thomas shoemaker 757836 757836 Yong, Thomas, of Pountfreyt, shoemaker 1
4736899 2276668 2276668 defendant Barbour Richard taverner 757836 757836 Barbour, Richard, of Pountfreyt, taverner 2
4737556 2276858 2276858 plaintiff Wakefeld William   757836 757836 Wakefeld, William, of Pountfreyt 0
4738508 2277136 2277136 plaintiff Whit John chaplain 757836 757836 Whit, John, of Pountfreyt, chaplain 0
4747716 2279840 2279840 defendant Dounton John yeoman 757836 757836 Dounton, John, of Pountfreyt, yeoman 0
4752430 2281170 2281170 plaintiff Taillour Henry   757836 757836 Taillour, Henry, of Pountfreyt 0
4752643 2281235 2281235 plaintiff Thuresby John   757836 757836 Thuresby, John, of Pountfreyt 0
4752646 2281235 2281235 defendant Lorymer William husbandman 757836 757836 Lorymer, William, of Pountfreyt, husbandman 2
4754102 2281662 2281662 defendant Taillour William tailor 757836 757836 Taillour, William, of Pountfreyt, tailor 0
4754338 2281736 2281736 defendant Skelbroke Nicholas husbandman 757836 757836 Skelbroke, Nicholas, of Pountfreyt, husbandman 0
4763463 2284558 2284558 defendant Vaus William butcher 757836 757836 Vaus, William, of Pountfreyt, butcher 0
4774813 2288115 2288115 defendant Denyas John slater 757836 757836 (Denyas, John, of Pountfreyt, slater 1
4779268 2289495 2289495 plaintiff Boteler John   757836 757836 Boteler, John, of Pountfreyt 0
4779333 2289519 2289519 defendant Lytster John barker 757836 757836 Lytster, John, of Pountfreyt, barker 0
4779334 2289519 2289519 defendant Woderove William saddler 757836 757836 Woderove, William, of Pountfreyt, saddler 1
4784155 2291044 2291044 defendant de Melton Robert yeoman 757836 757836 de Melton, Robert, of Pountfreyt, yeoman 0
4792354 2293695 2293695 plaintiff Methelay Thomas fisher 757836 757836 Methelay, Thomas, of Pountfreyt, fisher 0
4797917 2295531 2295531 defendant Denyas or Devyas Richard slater 757836 757836 Denyas or Devyas, Richard, of Pountfreyt, slater 2
4805649 2297975 2297975 defendant Lebarn Robert weaver 757836 757836 Lebarn, Robert, of Pountfreyt, weaver 1
4814954 2300787 2300787 defendant Wade Robert   757836 757836 Wade, Robert, of Pountfreyt, nail maker 2
4815060 2300822 2300822 defendant Wade Robert   757836 757836 Wade, Robert, of Pountfreyt, nail maker 2
4815583 2300981 2300981 defendant Dounton John yeoman 757836 757836 Dounton, John, of Pountfreyt, yeoman 0
4815585 2300982 2300982 defendant Dounton John yeoman 757836 757836 Dounton, John, of Pountfreyt, yeoman 0
4825658 2304064 2304064 defendant Vause William butcher 757836 757836 Vause, William, of Pountfreyt, butcher 0
4850762 2311689 2311689 defendant Huntston Thomas yeoman 757836 757836 Huntston, Thomas, of Pountfreyt, yeoman 2
4857529 2313743 2313743 defendant Shelton William husbandman 757836 757836 Shelton, William, of Pountfreyt, husbandman 0
4869079 2317302 2317302 defendant Lyndelay John yeoman 757836 757836 Lyndelay, John, of Pountfreyt, yeoman 0
4873077 2318534 2318534 defendant Wrote Thomas weaver 757836 757836 Wrote, Thomas, of Pountfreyt, draper together with Wortlay, John, of Snayth, weaver 0
4888874 2323306 2323306 defendant Derkyn Robert gent 757836 757836 Derkyn, Robert, of Pountfreyt, gent 4
4905904 2328450 2328450 defendant Bunny Richard laborer 757836 757836 Bunny, Richard, of Pountfreyt, laborer 2
4905905 2328450 2328450 defendant Sibsay William cordwainer 757836 757836 Sibsay, William, of Pountfreyt, cordwainer 3
4918397 2332270 2332270 defendant Layrstok Robert yeoman 757836 757836 Layrstok, Robert, of Pountfreyt, Yorks, senior, yeoman 0
4981532 2351389 2351389 plaintiff Sutton John (legal representative) 757836 757836 Sutton, John, of Pountfreyt, executors of 0
4981534 2351389 2351389 defendant Cade Robert skinner 757836 757836 Cade, Robert, of Pountfreyt, skinner 0
5066196 2376415 2376415 defendant Bate William barker 757836 757836 Bate, William, of Pountfreyt, barker 0
5066782 2376593 2376593 defendant Scargill William, senior esq 757836 757836 Scargill, William, senior, of Pountfreyt, esq 0
5083896 2381684 2381684 defendant Bate Robert weaver 757836 757836 Bate, Robert, of Pountfreyt, weaver 0
5098969 2386128 2386128 defendant Moldson John walker 757836 757836 Moldson, John, of Pountfreyt, walker 0
5098970 2386128 2386128 defendant Marchall John walker 757836 757836 Marchall, John, of Pountfreyt, walker 1
5098971 2386128 2386128 defendant Chambre Thomas walker 757836 757836 Chambre, Thomas, of Pountfreyt, walker 2
5098972 2386128 2386128 defendant Walker Robert walker 757836 757836 Walker, Robert, of Pountfreyt, walker 3
5115030 2390813 2390813 plaintiff Merebek John, senior   757836 757836 Merebek, John, senior, of Pountfreyt 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);