names

274 rows where place_id = 589309

✎ 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
3597170 1866740 1866740 defendant Sturgeon John carpenter 589309 589309 Sturgeon, John, of Neuport, carpenter 0
3623101 1874749 1874749 plaintiff Salter John (legal representative) 589309 589309 Salter, John, of Neuport, executors of 0
3625805 1875608 1875608 defendant Colet Richard (legal representative) 589309 589309 Colet, Richard, of Neuport, bailiff, executors of 0
3626388 1903111 1903111 defendant Booth William yeoman 589309 589309 Booth, William, of Neuport, yeoman 0
3633468 1905281 1905281 defendant Tydder Ellen widow 589309 589309 Tydder, Ellen, of Neuport, widow 2
3633470 1905281 1905281 defendant Kyndall Richard embroiderer 589309 589309 Kyndall, Richard, of Neuport, mercer, embroiderer 4
4415089 2169620 2169620 defendant Loksmyth John   589309 589309 Loksmyth, John, of Neuport 0
4429469 2174016 2174016 plaintiff Walkere Thomas le   589309 589309 Walkere, Thomas le, of Neuport 0
4443081 2182798 2182798 defendant Taillour William   589309 589309 Taillour, William, of Neuport 0
4448796 2184562 2184562 defendant Taverner John   589309 589309 Taverner, John, of Neuport 0
4454899 2186545 2186545 plaintiff Mason Simon   589309 589309 Mason, Simon, of Neuport 0
4456096 2186931 2186931 plaintiff Neuman Richard   589309 589309 Neuman, Richard, of Neuport 0
4470867 2191538 2191538 defendant Chal--- William weaver 589309 589309 Chal---, William, of Neuport, weaver 1
4470870 2191539 2191539 defendant Chalonwebbe William   589309 589309 Chalonwebbe, William, of Neuport 1
4492973 2198505 2198505 defendant Dalby John   589309 589309 Dalby, John, of Neuport, vicar 1
4505225 2202162 2202162 defendant Walton Thomas   589309 589309 Walton, Thomas, of Neuport 0
4510467 2203734 2203734 defendant Trumpour John shoemaker 589309 589309 Trumpour, John, of Neuport, shoemaker 0
4517085 2205744 2205744 defendant Skynnere John   589309 589309 Skynnere, John, of Neuport 8
4517086 2205744 2205744 defendant Webbe William   589309 589309 Webbe, William, of Neuport 9
4518548 2206174 2206174 defendant Orum John smith 589309 589309 Orum, John, of Neuport, smith 1
4519656 2206509 2206509 defendant Abbot John   589309 589309 Abbot, John, of Neuport 1
4527246 2208800 2208800 defendant Draper David   589309 589309 Draper, David, of Neuport 1
4529760 2209592 2209592 defendant Modeford John tanner 589309 589309 Modeford, John, of Neuport, tanner 0
4546869 2214950 2214950 plaintiff Brugger John carpenter 589309 589309 Brugger, John, of Neuport, carpenter 0
4551120 2216293 2216293 plaintiff Dosy Robert   589309 589309 Dosy, Robert, of Neuport 0
4552243 2216656 2216656 plaintiff Fauconer Joan   589309 589309 Fauconer, Joan, of Neuport 0
4552244 2216656 2216656 defendant Keype Richard   589309 589309 Keype, Richard, of Neuport 0
4553208 2216936 2216936 plaintiff Gace Robert   589309 589309 Gace, Robert, of Neuport 0
4555224 2217570 2217570 defendant Lonke William   589309 589309 Lonke, William, of Neuport 0
4555225 2217570 2217570 defendant Halle William   589309 589309 Halle, William, of Neuport 1
4555226 2217570 2217570 defendant Balle John   589309 589309 Balle, John, of Neuport 2
4555227 2217570 2217570 defendant Palmer Robert   589309 589309 Palmer, Robert, of Neuport 3
4555228 2217570 2217570 defendant Yerdeley John   589309 589309 Yerdeley, John, of Neuport 4
4555229 2217570 2217570 defendant Lokley John   589309 589309 Lokley, John, of Neuport 5
4564241 2220386 2220386 defendant Hamond Adam fishmonger 589309 589309 Hamond, Adam, of Neuport, fishmonger 0
4564243 2220387 2220387 defendant Hamond Adam miller 589309 589309 Hamond, Adam, of Neuport, miller 0
4565291 2220714 2220714 defendant Malehurst William   589309 589309 Malehurst, William, of Neuport 1
4565314 2220717 2220717 defendant Hayteley John   589309 589309 Hayteley, John, of Neuport 1
4565406 2220750 2220750 defendant Holewey John smith 589309 589309 Holewey, John, of Neuport, smith 0
4571028 2222507 2222507 defendant Lecroft Malcolm   589309 589309 Lecroft, Malcolm, of Neuport 0
4578360 2224721 2224721 defendant Drovere Thomas   589309 589309 Drovere, Thomas, of Neuport 0
4593422 2229229 2229229 defendant Pytton William   589309 589309 Pytton, William, of Neuport 0
4593423 2229229 2229229 defendant Owghtred John   589309 589309 Owghtred, John, of Neuport, mill ward 1
4606637 2233185 2233185 defendant Barker Roger   589309 589309 Barker, Roger, of Neuport 0
4614212 2235457 2235457 defendant Louk John   589309 589309 Louk, John, of Neuport 0
4622784 2238103 2238103 defendant Halle William   589309 589309 Halle, William, of Neuport 0
4626326 2239189 2239189 defendant Taillour Adam   589309 589309 Taillour, Adam, of Neuport 1
4630642 2240494 2240494 defendant Lyney Roger   589309 589309 Lyney, Roger, of Neuport 0
4632216 2240959 2240959 plaintiff Turtell John   589309 589309 Turtell, John, of Neuport 0
4637142 2242418 2242418 plaintiff (not given) John   589309 589309 Blank, John, of Neuport 0
4647713 2245389 2245389 defendant Flemyng William   589309 589309 Flemyng, William, of Neuport 1
4647947 2245467 2245467 defendant Longe John   589309 589309 Longe, John, of Neuport 0
4652000 2246561 2246561 defendant Bastard William laborer 589309 589309 Bastard, William, of Neuport, laborer 2
4652001 2246561 2246561 defendant Keype Richard carter 589309 589309 Keype, Richard, of Neuport, carter 3
4652536 2246747 2246747 plaintiff Baker John   589309 589309 Baker, John, of Neuport 0
4652947 2246852 2246852 plaintiff Barker Roger   589309 589309 Barker, Roger, of Neuport 0
4652949 2246852 2246852 defendant de Crofte Maculus fisher 589309 589309 de Crofte, Maculus, of Neuport, fisher 1
4671808 2256829 2256829 defendant Harlyng John woolman 589309 589309 Harlyng, John, of Neuport, woolman 2
4676797 2258363 2258363 defendant Bakere Adam baker 589309 589309 Bakere, Adam, of Neuport, baker 2
4685378 2261022 2261022 defendant Heldere John tailor 589309 589309 Heldere, John, of Neuport, tailor 0
4689078 2262145 2262145 plaintiff Trumper John shoemaker 589309 589309 Trumper, John, of Neuport, shoemaker 0
4722635 2272395 2272395 defendant Baker Adam baker 589309 589309 Baker, Adam, of Neuport, baker 0
4724293 2272894 2272894 defendant Rede Thomas   589309 589309 Rede, Thomas, of Neuport, wool winder 2
4726653 2273608 2273608 defendant Wattes Thomas laborer 589309 589309 Wattes, Thomas, of Neuport, laborer 1
4731670 2275100 2275100 defendant Gyles John laborer 589309 589309 Gyles, John, of Neuport, laborer 0
4734619 2275990 2275990 defendant Gylot William draper 589309 589309 Gylot, William, of Neuport, draper 0
4744286 2278852 2278852 plaintiff Dyer John   589309 589309 Dyer, John, of Neuport 0
4753357 2281426 2281426 defendant Pray Peter ploughman 589309 589309 Pray, Peter, of Neuport, ploughman 0
4755555 2282117 2282117 defendant Tynte John husbandman 589309 589309 Tynte, John, of Neuport, husbandman 0
4786534 2291838 2291838 defendant Gyles William draper 589309 589309 Gyles, William, of Neuport, draper 0
4801047 2296517 2296517 defendant Irlond John, senior glover 589309 589309 Irlond, John, senior, of Neuport, glover 0
4801070 2296525 2296525 defendant Ferrour or Smith William yeoman 589309 589309 Ferrour or Smith, William, of Neuport, yeoman 0
4805025 2297777 2297777 defendant Whte Robert smith 589309 589309 Whte, Robert, of Neuport, smith 0
4811087 2299577 2299577 defendant Hawekyn William fisher 589309 589309 Hawekyn, William, of Neuport, fisher 0
4811251 2299628 2299628 defendant Rowell William butcher 589309 589309 Rowell, William, of Neuport, butcher 0
4818523 2301873 2301873 defendant Hawkyn William fisher 589309 589309 Hawkyn, William, of Neuport, fisher 1
4820682 2302544 2302544 defendant Mitley John, junior fisher 589309 589309 Mitley, John, junior, of Neuport, fisher 0
4822670 2303167 2303167 defendant Shyrewod John chaplain 589309 589309 Shyrewod, John, of Neuport, chaplain 0
4837132 2307566 2307566 defendant Idryche Geoffrey hosier 589309 589309 Idryche, Geoffrey, of Neuport, hosier 0
4837471 2307655 2307655 defendant Mathe William husbandman 589309 589309 Mathe, William, of Neuport, husbandman 2
4837473 2307655 2307655 defendant Maldon Richard husbandman 589309 589309 Maldon, Richard, of Neuport, husbandman 4
4864699 2315928 2315928 defendant Tromper John husbandman 589309 589309 Tromper, John, of Neuport, husbandman 0
4870742 2317826 2317826 defendant Neweman John smith 589309 589309 Neweman, John, of Neuport, smith 2
4882125 2321310 2321310 defendant Rondull Thomas   589309 589309 Rondull, Thomas, of Neuport 0
4882297 2321373 2321373 defendant Herlyng John husbandman 589309 589309 Herlyng, John, of Neuport, husbandman 0
4884593 2322091 2322091 defendant Beyng Joan   589309 589309 Beyng, Joan, of Neuport, widow of Beyng, Thomas 0
4886242 2322560 2322560 defendant Never or Neuer alias Pyper John piper 589309 589309 Never or Neuer alias Pyper, John, of Neuport, piper 0
4886803 2322728 2322728 defendant Harlyng John husbandman 589309 589309 Harlyng, John, of Neuport, husbandman 0
4886821 2322732 2322732 defendant Punt Thomas yeoman 589309 589309 Punt, Thomas, of Neuport, yeoman 0
4886822 2322732 2322732 defendant Turtell Henry yeoman 589309 589309 Turtell, Henry, of Neuport, yeoman 1
4886823 2322732 2322732 defendant Cristemass John weaver 589309 589309 Cristemass, John, of Neuport, weaver 2
4886824 2322732 2322732 defendant Briggeman Richard weaver 589309 589309 Briggeman, Richard, of Neuport, weaver 3
4891533 2324087 2324087 defendant Herlyng John husbandman 589309 589309 Herlyng, John, of Neuport, husbandman 0
4894219 2324877 2324877 defendant Hoker Roger, junior husbandman 589309 589309 Hoker, Roger, junior, of Neuport, husbandman 0
4894220 2324877 2324877 defendant Mildenhale John yeoman 589309 589309 Mildenhale, John, of Neuport, yeoman 1
4894221 2324877 2324877 defendant Netherhane or Netherhave Thomas   589309 589309 Netherhane or Netherhave, Thomas, of Neuport, fan maker 2
4898422 2326161 2326161 defendant Punte Thomas husbandman 589309 589309 Punte, Thomas, of Neuport, husbandman 0
4899729 2326548 2326548 defendant Lecroft Maculus husbandman 589309 589309 Lecroft, Maculus, of Neuport, husbandman 1
4905526 2328327 2328327 defendant Busshe John chaplain 589309 589309 Busshe, John, of Neuport, chaplain 0
4905530 2328328 2328328 defendant Bocher Jen husbandman 589309 589309 Bocher, Jen, of Neuport, husbandman 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);