names

167 rows where place_id = 606190

✎ 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
3655177 1911879 1911879 plaintiff (not given) William prior of Birde 606190 606190 Birde, William, of Bath, prior of the House & church of the Blessed Apostles, Peter & Paul 0
3664370 1914806 1914806 defendant Staunton John gent 606190 606190 Staunton, John, of Bath, gent 0
3758926 1944783 1944783 defendant Whelpley Thomas yeoman 606190 606190 Whelpley, Thomas, of Bath, yeoman 0
3758927 1944783 1944783 defendant Strong Richard tucker 606190 606190 Strong, Richard, of Bath, tucker 1
3807363 1960209 1960209 plaintiff Wodward Agnes widow 606190 606190 Wodward, Agnes, of Bath, widow 0
3864556 1978343 1978343 defendant Long Thomas baker 606190 606190 Long, Thomas, of Bath, baker 3
3875920 1982199 1982199 defendant Kytt William weaver 606190 606190 Kytt, William, of Bath, weaver 0
3897335 1989326 1989326 defendant Clement John clothier 606190 606190 Clement, John, of Bath, clothier 2
3897339 1989327 1989327 defendant Clement John clothier 606190 606190 Clement, John, of Bath, clothier 2
3897343 1989328 1989328 defendant Clement John clothier 606190 606190 Clement, John, of Bath, clothier 2
3897349 1989329 1989329 defendant Clement John clothier 606190 606190 Clement, John, of Bath, clothier 2
3926069 1999038 1999038 defendant Ludwell Edward clothier 606190 606190 Ludwell, Edward, of Bath, clothier 0
3926071 1999039 1999039 defendant Yong alias Longe Thomas baker 606190 606190 Yong alias Longe, Thomas, of Bath, baker 0
3939741 2003596 2003596 defendant Ludwell Edward clothier 606190 606190 Ludwell, Edward, of Bath, clothier 0
4019570 2031726 2031726 defendant Chapman Peter yeoman 606190 606190 Chapman, Peter, of Bath, yeoman 1
4020070 2031905 2031905 plaintiff (not given) Thomas rector of Whethill 606190 606190 Whethill, Thomas, of Bath, rector of Combe Hawye, Soms, executors of 0
4113288 2065019 2065019 defendant Turner Robert   606190 606190 Turner, Robert, of Bath, yeoman, his son 1
4245112 2111351 2111351 defendant Murford Thomas yeoman 606190 606190 Murford, Thomas, of Bath, yeoman 0
4251924 2113633 2113633 defendant Hancock John butcher 606190 606190 Hancock, John, of Bath, butcher 1
4288681 2126006 2126006 defendant Sherwood John   606190 606190 Sherwood, John, of Bath, Doctor of Medicine 2
4312294 2134436 2134436 defendant Perman John   606190 606190 Perman, John, of Bath, apothecary 1
4333347 2141435 2141435 defendant Blaclege alias Singleton Henry cooper 606190 606190 Blaclege alias Singleton, Henry, of Bath, cooper 0
4344808 2145464 2145464 defendant Pearman Richard vintner 606190 606190 Pearman, Richard, of Bath, vintner 1
4407906 2167209 2167209 defendant Perman John, senior baker 606190 606190 Perman, John, senior, of Bath, baker 0
4407907 2167209 2167209 defendant Perman John, junior   606190 606190 Perman, John, junior, of Bath, apothecary 1
4412797 2168875 2168875 defendant Callaway John   606190 606190 Callaway, John, of Bath, surgeon 1
4412798 2168875 2168875 defendant Beedle William   606190 606190 Beedle, William, of Bath, mason 2
4414409 2169417 2169417 defendant Durcote John   606190 606190 Durcote, John, of Bath 0
4414410 2169417 2169417 defendant Huse John   606190 606190 Huse, John, of Bath 1
4435392 2175823 2175823 defendant Hercy Benedict merchant 606190 606190 Hercy, Benedict, of Bath, merchant 0
4438612 2181365 2181365 defendant Swayn Thomas   606190 606190 Swayn, Thomas, of Bath 1
4483065 2195400 2195400 defendant Tykenhull John   606190 606190 Tykenhull, John, of Bath 2
4492546 2198356 2198356 defendant Newelyn Robert   606190 606190 Newelyn, Robert, of Bath 0
4510213 2203677 2203677 plaintiff Barbour Thomas   606190 606190 Barbour, Thomas, of Bath 0
4512838 2204447 2204447 defendant Bertelot Henry merchant 606190 606190 Bertelot, Henry, of Bath, merchant 0
4522070 2207244 2207244 defendant Whyte John   606190 606190 Whyte, John, of Bath 0
4522694 2207436 2207436 plaintiff Savage John   606190 606190 (Savage, John, of Bath 1
4525686 2208331 2208331 defendant Hert John clerk & parson of the church of the BM within the North Gate 606190 606190 Hert, John, of Bath, clerk & parson of the church of the BM within the North Gate 0
4534628 2211101 2211101 plaintiff Schestebery John master of the hospital of St John Baptist 606190 606190 Schestebery, John, of Bath, master of the hospital of St John Baptist 0
4534641 2211106 2211106 plaintiff Scot John John (legal representative) 606190 606190 Scot, John John, of Bath, fishmonger, executors of 0
4534930 2211205 2211205 plaintiff Shaftebury John master of the house or hospital of St John Baptist 606190 606190 Shaftebury, John, of Bath, master of the house or hospital of St John Baptist 0
4537455 2211982 2211982 defendant Parker William chandler 606190 606190 Parker, William, of Bath, chandler 0
4555872 2217777 2217777 defendant Shaftesbury John master of the hospital of St John 606190 606190 Shaftesbury, John, of Bath, master of the hospital of St John 0
4566845 2221191 2221191 defendant Sheftesbury John clerk 606190 606190 Sheftesbury, John, of Bath, clerk 0
4611815 2234758 2234758 defendant Stanfery Thomas   606190 606190 Stanfery, Thomas, of Bath 0
4626812 2239327 2239327 plaintiff Radestoke William   606190 606190 Radestoke, William, of Bath 0
4634682 2241694 2241694 defendant Belryngger Richard   606190 606190 Belryngger, Richard, of Bath 0
4639485 2243064 2243064 defendant Bartelot William   606190 606190 Bartelot, William, of Bath 0
4640856 2243425 2243425 defendant Bartelot Henry   606190 606190 Bartelot, Henry, of Bath and Briggewater 0
4640864 2243426 2243426 defendant Bartelot Henry   606190 606190 Bartelot, Henry, of Bath and Briggewater 0
4644650 2244522 2244522 defendant Bartelot Henry   606190 606190 Bartelot, Henry, of Bath 1
4647101 2245208 2245208 plaintiff Rydeler John master 606190 606190 Rydeler, John, of Bath, master 0
4647368 2245286 2245286 plaintiff Scheftesbury John master of the hospital of St John Baptist 606190 606190 Scheftesbury, John, of Bath, master of the hospital of St John Baptist 0
4647370 2245287 2245287 plaintiff Schestbery John master of the hospital of St John Baptist 606190 606190 Schestbery, John, of Bath, master of the hospital of St John Baptist 0
4653169 2246927 2246927 defendant Carter Thomasine (legal representative) 606190 606190 Carter, Thomasine, of Bath, executor of 0
4668351 2255814 2255814 defendant Pork John butcher 606190 606190 Pork, John, of Bath, butcher 1
4668352 2255814 2255814 defendant Moreys John mercer 606190 606190 Moreys, John, of Bath, mercer 2
4668353 2255814 2255814 defendant Blaffard John weaver 606190 606190 Blaffard, John, of Bath, weaver 3
4668354 2255814 2255814 defendant Fyshyde William goldsmith 606190 606190 Fyshyde, William, of Bath, goldsmith 4
4668355 2255814 2255814 defendant Bosard John goldsmith 606190 606190 Bosard, John, of Bath, goldsmith 5
4668356 2255814 2255814 defendant Cleuer Richard tailor 606190 606190 Cleuer, Richard, of Bath, tailor 6
4668357 2255814 2255814 defendant Eynsham William mercer 606190 606190 Eynsham, William, of Bath, mercer 7
4668359 2255815 2255815 defendant Rythe or Ryche Walter chapman 606190 606190 Rythe or Ryche, Walter, of Bath, chapman 0
4678296 2258820 2258820 plaintiff Hobbys Roger   606190 606190 Hobbys, Roger, of Bath, on his own account 0
4679438 2259185 2259185 defendant Poste John shoemaker 606190 606190 Poste, John, of Bath, shoemaker 0
4679439 2259185 2259185 defendant Cockes John shoemaker 606190 606190 Cockes, John, of Bath, shoemaker 1
4679440 2259185 2259185 defendant Cok William husbandman 606190 606190 Cok, William, of Bath, husbandman 2
4679442 2259185 2259185 defendant Osteler Robert ostler 606190 606190 Osteler, Robert, of Bath, ostler 4
4693503 2263470 2263470 defendant Jones John fuller 606190 606190 Jones, John, of Bath, fuller 0
4697615 2264742 2264742 defendant Lowyston William baker 606190 606190 Lowyston, William, of Bath, baker 0
4697648 2264754 2264754 defendant Loder William weaver 606190 606190 Loder, William, of Bath, weaver 0
4700907 2265687 2265687 plaintiff Forster Richard   606190 606190 Forster, Richard, of Bath 0
4702386 2266158 2266158 defendant Radestoke William yeoman 606190 606190 Radestoke, William, of Bath, porter in the priory in Bath, yeoman 0
4703846 2266582 2266582 plaintiff Holewelle Simon   606190 606190 Holewelle, Simon, of Bath 0
4704382 2266745 2266745 defendant Touker Roger dyer 606190 606190 Touker, Roger, of Bath, dyer 3
4704664 2266839 2266839 plaintiff Janyn John shoemaker 606190 606190 Janyn, John, of Bath, shoemaker 0
4704665 2266839 2266839 defendant Draycotys John carrier 606190 606190 Draycotys, John, of Bath, carrier 0
4711754 2269000 2269000 plaintiff Savage John   606190 606190 Savage, John, of Bath 0
4713418 2269518 2269518 defendant Osbern William fuller 606190 606190 Osbern, William, of Bath, fuller 0
4715692 2270238 2270238 plaintiff Waspray Robert (legal representative) 606190 606190 Waspray, Robert, of Bath, executors of 0
4715693 2270238 2270238 plaintiff Wydecombe Richard   606190 606190 (Wydecombe, Richard, of Bath 1
4715694 2270238 2270238 plaintiff Byton John   606190 606190 Byton, John, of Bath 2
4716831 2270591 2270591 plaintiff Wydecombe Richard   606190 606190 Wydecombe, Richard, of Bath 0
4716832 2270591 2270591 plaintiff Eyton John   606190 606190 Eyton, John, of Bath 1
4727884 2273964 2273964 plaintiff Heynes John   606190 606190 Heynes, John, of Bath, burgess & merchant 1
4727885 2273964 2273964 plaintiff Newelyn Robert   606190 606190 Newelyn, Robert, of Bath, burgess & merchant 2
4727888 2273965 2273965 plaintiff Heynes John   606190 606190 Heynes, John, of Bath, burgess & merchant 1
4727889 2273965 2273965 plaintiff Newelyn Robert   606190 606190 Newelyn, Robert, of Bath, burgess & merchant 2
4733510 2275656 2275656 plaintiff Redyngge John weaver 606190 606190 Redyngge, John, of Bath, weaver 0
4734364 2275916 2275916 defendant (not given) John vicar of Baret 606190 606190 Baret, John, of Bath, vicar of the church of St Mary of Stalles 2
4734557 2275974 2275974 defendant Bolton Thomas clerk 606190 606190 Bolton, Thomas, of Bath, clerk 1
4734563 2275975 2275975 defendant Bolton Thomas clerk 606190 606190 Bolton, Thomas, of Bath, clerk 1
4739042 2277303 2277303 defendant Kensek William weaver 606190 606190 Kensek, William, of Bath, weaver 0
4740659 2277785 2277785 defendant Skynner John skinner 606190 606190 Skynner, John, of Bath, skinner 0
4751227 2280835 2280835 defendant Bolton Thomas clerk 606190 606190 Bolton, Thomas, of Bath, clerk 1
4753782 2281557 2281557 plaintiff Wespray Robert (legal representative) 606190 606190 Wespray, Robert, of Bath, executors of 0
4755918 2282234 2282234 defendant Roche Richard fuller 606190 606190 Roche, Richard, of Bath, fuller 0
4758790 2283102 2283102 defendant Bosard John goldsmith 606190 606190 Bosard, John, of Bath, goldsmith 0
4758998 2283166 2283166 defendant Olyff John   606190 606190 Olyff, John, of Bath, cook 0
4764877 2284994 2284994 defendant Carter Henry fuller 606190 606190 Carter, Henry, of Bath, fuller 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);