names

116 rows where place_id = 594261

✎ 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
3598369 1867120 1867120 defendant Velour John (legal representative) 594261 594261 Velour, John, of Bathe, executrix of 2
3615329 1872438 1872438 defendant Flewet Richard (legal representative) 594261 594261 Flewet, Richard, of Bathe, executrix of 0
3615330 1872438 1872438 defendant Flewet Joan widow 594261 594261 Flewet, Joan, of Bathe, widow 1
3621062 1874144 1874144 defendant Walley William fuller 594261 594261 Walley, William, of Bathe, fuller 0
3621068 1874145 1874145 defendant Walley William fuller 594261 594261 Walley, William, of Bathe, fuller 0
3621357 1874221 1874221 defendant Walley William fuller 594261 594261 Walley, William, of Bathe, fuller 0
3634305 1905526 1905526 defendant Collys Richard husbandman 594261 594261 Collys, Richard, of Bathe, husbandman 2
3831669 1967802 1967802 defendant Hochyns Thomas chapman 594261 594261 Hochyns, Thomas, of Bathe, chapman 0
3855809 1975448 1975448 plaintiff West Thomas   594261 594261 West, Thomas, of Bathe 0
3855810 1975448 1975448 defendant Cokkys Richard yeoman 594261 594261 Cokkys, Richard, of Bathe, yeoman 0
3857932 1976123 1976123 defendant Tynby Rowland innholder 594261 594261 Tynby, Rowland, of Bathe, innholder 0
3884402 1985053 1985053 defendant Chapman William clothman 594261 594261 Chapman, William, of Bathe, clothman 0
3914238 1995108 1995108 defendant Gurney Thomas   594261 594261 Gurney, Thomas, of Bathe, cook 0
3944110 2005049 2005049 defendant Robynson William chapman 594261 594261 Robynson, William, of Bathe, chapman 1
3980275 2017711 2017711 defendant Turner Thomas yeoman 594261 594261 Turner, Thomas, of Bathe, yeoman 1
3984145 2019095 2019095 plaintiff Style John clothier 594261 594261 Style, John, of Bathe, clothier 0
4038937 2038546 2038546 defendant Powell Stephen yeoman 594261 594261 Powell, Stephen, of Bathe, Old Radnor, yeoman 1
4061880 2046645 2046645 defendant ap Harry Watkin yeoman 594261 594261 ap Harry, Watkin, of Bathe, yeoman 0
4076667 2051943 2051943 defendant Shaxton Nicholas yeoman 594261 594261 Shaxton, Nicholas, of Bathe, yeoman 10
4154023 2079501 2079501 defendant Jenkyn Howell yeoman 594261 594261 Jenkyn, Howell, of Bathe, or of Castleton, yeoman 0
4195264 2093890 2093890 defendant Berrington William innholder 594261 594261 Berrington, William, of Bathe, innholder 0
4439152 2181528 2181528 defendant Toukere Gerard   594261 594261 Toukere, Gerard, of Bathe 3
4444450 2183243 2183243 plaintiff Coke William   594261 594261 Coke, William, of Bathe 0
4461329 2188625 2188625 defendant Cook William   594261 594261 Cook, William, of Bathe 0
4534644 2211107 2211107 plaintiff Scot John (legal representative) 594261 594261 Scot, John, of Bathe, fishmonger, executors of 0
4536899 2211811 2211811 plaintiff Stot John (legal representative) 594261 594261 Stot, John, of Bathe, fishmonger, executors of 0
4560451 2219210 2219210 defendant Bartelot Henry   594261 594261 Bartelot, Henry, of Bathe 2
4565435 2220758 2220758 defendant Bertelot Henry   594261 594261 Bertelot, Henry, of Bathe 0
4567927 2221539 2221539 defendant South John   594261 594261 South, John, of Bathe 6
4575870 2223942 2223942 defendant Bertlet Henry merchant 594261 594261 Bertlet, Henry, of Bathe, merchant 0
4595381 2229810 2229810 plaintiff Redhed Robert   594261 594261 Redhed, Robert, of Bathe 0
4603061 2232169 2232169 defendant Haygoby John   594261 594261 Haygoby, John, of Bathe 1
4604547 2232588 2232588 defendant Bertelot Henry merchant 594261 594261 Bertelot, Henry, of Bathe, merchant 0
4616842 2236270 2236270 defendant Bartelot William   594261 594261 Bartelot, William, of Bathe 0
4634684 2241695 2241695 defendant Holme Richard tailor 594261 594261 Holme, Richard, of Bathe, tailor 0
4639728 2243131 2243131 defendant (illegible) Henry   594261 594261 _, Henry, of Bathe 1
4664811 2250468 2250468 defendant Hobbes Roger weaver 594261 594261 Hobbes, Roger, of Bathe, weaver 0
4679441 2259185 2259185 defendant Skynner John skinner 594261 594261 Skynner, John, of Bathe, skinner 3
4687019 2261547 2261547 defendant Of Chambre John weaver 594261 594261 Of Chambre, John, of Bathe, weaver 0
4687020 2261547 2261547 defendant Janyns John shoemaker 594261 594261 Janyns, John, of Bathe, shoemaker 1
4687021 2261547 2261547 defendant Richard-servant Foster Richard weaver 594261 594261 Richard-servant Foster, Richard, of Bathe, weaver 2
4689456 2262259 2262259 defendant atte Wode John weaver 594261 594261 atte Wode, John, of Bathe, weaver 0
4693252 2263391 2263391 defendant Langeworthy Robert husbandman 594261 594261 Langeworthy, Robert, of Bathe, husbandman 0
4693505 2263471 2263471 defendant Compton William   594261 594261 Compton, William, of Bathe, holy water clerk 0
4694451 2263758 2263758 defendant Cole John   594261 594261 Cole, John, of Bathe 0
4697616 2264742 2264742 defendant Squyer alias Corbyn William baker alias laborer 594261 594261 Squyer alias Corbyn, William, of Bathe, baker alias laborer 1
4700909 2265688 2265688 plaintiff Forster Richard merchant 594261 594261 Forster, Richard, of Bathe, merchant 0
4726449 2273554 2273554 defendant Saunford Hugh gent 594261 594261 Saunford, Hugh, of Bathe, gent 0
4727937 2273981 2273981 plaintiff Longe John   594261 594261 (Longe, John, of Bathe 1
4733719 2275727 2275727 plaintiff Rodygge John weaver 594261 594261 Rodygge, John, of Bathe, weaver 0
4739114 2277323 2277323 defendant Cooke John goldsmith 594261 594261 Cooke, John, of Bathe, goldsmith 0
4754281 2281717 2281717 defendant Mareys John husbandman 594261 594261 Mareys, John, of Bathe, husbandman 0
4761340 2283890 2283890 defendant Strange William fuller 594261 594261 Strange, William, of Bathe, fuller 0
4761341 2283890 2283890 defendant Longe John chapman 594261 594261 Longe, John, of Bathe, chapman 1
4777889 2289073 2289073 defendant Roche Richard tucker 594261 594261 Roche, Richard, of Bathe, tucker 0
4777891 2289074 2289074 defendant Roche Richard tucker 594261 594261 Roche, Richard, of Bathe, tucker 0
4782681 2290598 2290598 defendant Costervyle Henry chapman 594261 594261 Costervyle, Henry, of Bathe, chapman 0
4782682 2290598 2290598 defendant Baret Thomas chapman 594261 594261 Baret, Thomas, of Bathe, chapman 1
4788977 2292606 2292606 defendant Honybrygge Richard weaver 594261 594261 Honybrygge, Richard, of Bathe, weaver 0
4791113 2293319 2293319 defendant Helyer Thomas   594261 594261 Helyer, Thomas, of Bathe, bailiff 0
4798971 2295851 2295851 defendant Carter William tucker 594261 594261 Carter, William, of Bathe, tucker 0
4809048 2299005 2299005 defendant Bryan John laborer 594261 594261 Bryan, John, of Bathe, laborer 0
4809050 2299006 2299006 defendant Bryan John sadler 594261 594261 Bryan, John, of Bathe, sadler 0
4815360 2300913 2300913 defendant Bokelond John weaver 594261 594261 Bokelond, John, of Bathe, weaver 0
4816820 2301364 2301364 defendant Lytelton Thomas fuller 594261 594261 Lytelton, Thomas, of Bathe, fuller 1
4818796 2301964 2301964 defendant Costervyle Henry chapman 594261 594261 Costervyle, Henry, of Bathe, chapman 0
4825401 2303987 2303987 defendant Northfolk John merchant 594261 594261 Northfolk, John, of Bathe, merchant 2
4826599 2304354 2304354 defendant Carter William fuller 594261 594261 Carter, William, of Bathe, fuller 0
4856196 2313313 2313313 defendant Cardygan David weaver 594261 594261 Cardygan, David, of Bathe, weaver 0
4856197 2313313 2313313 defendant Coksale Richard glover 594261 594261 Coksale, Richard, of Bathe, glover 1
4856198 2313313 2313313 defendant Taverner William weaver 594261 594261 Taverner, William, of Bathe, weaver 2
4857350 2313684 2313684 defendant Herford John cordwainer 594261 594261 Herford, John, of Bathe, cordwainer 0
4875796 2319391 2319391 defendant Megge Thomas vintner 594261 594261 Megge, Thomas, of Bathe, husbandman, or of Colchester, vintner 0
4886303 2322576 2322576 defendant Swayn Thomas husbandman 594261 594261 Swayn, Thomas, of Bathe, husbandman 1
4893616 2324703 2324703 defendant Cartere William   594261 594261 Cartere, William, of Bathe, bailiff 3
4900819 2326886 2326886 defendant Smalemore William weaver 594261 594261 Smalemore, William, of Bathe, weaver 1
4912769 2330494 2330494 plaintiff Godewyn Robert yeoman 594261 594261 Godewyn, Robert, of Bathe, yeoman 6
4912770 2330494 2330494 plaintiff Yonge John baker 594261 594261 Yonge, John, of Bathe, baker 7
4965867 2346720 2346720 defendant Longelege William weaver 594261 594261 Longelege, William, of Bathe, weaver 3
4973509 2349024 2349024 defendant Phelpys William merchant 594261 594261 Phelpys, William, of Bathe, merchant 0
4989776 2353860 2353860 defendant Prat Richard   594261 594261 Prat, Richard, of Bathe, shoe maker 1
5016878 2361829 2361829 defendant Ilfircombe William bowyer 594261 594261 Ilfircombe, William, of Bathe, bowyer 1
5030178 2365694 2365694 defendant Porke William butcher 594261 594261 (Porke, William, of Bathe, butcher 1
5032971 2366530 2366530 plaintiff Stanborowgh Roger weaver 594261 594261 Stanborowgh, Roger, of Bathe, weaver 1
5053004 2372494 2372494 defendant Whitchurch William glover 594261 594261 Whitchurch, William, of Bathe, glover 0
5082589 2381300 2381300 defendant Payn William barber 594261 594261 Payn, William, of Bathe, barber 0
5082590 2381300 2381300 defendant Widdenham William tucker 594261 594261 Widdenham, William, of Bathe, tucker 1
5087438 2382703 2382703 defendant Stanborowe alias Haynys Roger merchant 594261 594261 Stanborowe alias Haynys, Roger, of Bathe, merchant 0
5090105 2383475 2383475 defendant Stanburgh Roger weaver 594261 594261 Stanburgh, Roger, of Bathe, weaver 0
5091590 2383930 2383930 defendant Browne Richard weaver 594261 594261 Browne, Richard, of Bathe, weaver 0
5092884 2384300 2384300 defendant Hervy John clerk 594261 594261 Hervy, John, of Bathe, clerk 1
5221101 2421877 2421877 defendant Ryggelyne Rchard butcher 594261 594261 Ryggelyne, Rchard, of Bathe, butcher 0
5229998 2424387 2424387 defendant Riglyn Richard butcher 594261 594261 Riglyn, Richard, of Bathe, butcher 0
5236344 2426219 2426219 defendant Meke Stephen yeoman 594261 594261 Meke, Stephen, of Bathe, yeoman 1
5255374 2431795 2431795 defendant Parker Richard   594261 594261 Parker, Richard, of Bathe, cook 1
5383672 2470414 2470414 defendant Dier Richard dyer 594261 594261 Dier, Richard, of Bathe, dyer 0
5383673 2470414 2470414 defendant Seyten John clothman 594261 594261 Seyten, John, of Bathe, clothman 1
5395461 2473778 2473778 defendant Dyer Richard dyer 594261 594261 Dyer, Richard, of Bathe, dyer 0
5395462 2473778 2473778 defendant Sexton John   594261 594261 Sexton, John, of Bathe, cloth man 1
5408320 2477459 2477459 defendant Dyer Richard   594261 594261 Dyer, Richard, of Bathe 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);