names

87 rows where place_id = 596561

✎ 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
3625277 1875441 1875441 defendant Baten Robert clothman 596561 596561 Baten, Robert, of Bath, Soms, clothman 0
3656090 1912156 1912156 defendant Wolmer Richard butcher 596561 596561 Wolmer, Richard, of Bath, Soms, butcher 2
3687398 1922235 1922235 defendant Wodde Grace widow 596561 596561 Wodde, Grace, of Bath, Soms, widow 1
3885432 1985381 1985381 defendant Mytton William yeoman 596561 596561 Mytton, William, of Bath, Soms, yeoman 0
3897333 1989326 1989326 defendant Crowche William gent 596561 596561 Crowche, William, of Bath, Soms, gent 0
3897337 1989327 1989327 defendant Crowche William gent 596561 596561 Crowche, William, of Bath, Soms, gent 0
3897341 1989328 1989328 defendant Crowche William gent 596561 596561 Crowche, William, of Bath, Soms, gent 0
3897347 1989329 1989329 defendant Crowche William gent 596561 596561 Crowche, William, of Bath, Soms, gent 0
3939914 2003648 2003648 defendant Ludwall Edward clothier 596561 596561 Ludwall, Edward, of Bath, Soms, clothier 0
3944725 2005254 2005254 defendant Ludwell Edward gent 596561 596561 Ludwell, Edward, of Bath, Soms, clothier, gent 3
3950277 2007182 2007182 defendant Davys John alderman 596561 596561 Davys, John, of Bath, Soms, alderman 0
3968781 2013708 2013708 defendant Sporewey Robert gent 596561 596561 Sporewey, Robert, of Bath, Soms, gent 2
3969607 2013979 2013979 defendant Chapman Richard chapman 596561 596561 Chapman, Richard, of Bath, Soms, chapman 0
3986427 2019888 2019888 defendant Turner Thomas yeoman 596561 596561 Turner, Thomas, of Bath, Soms, yeoman 0
3992029 2021914 2021914 defendant Turnor Thomas gent 596561 596561 Turnor, Thomas, of Bath, Soms, gent 1
4020355 2032002 2032002 defendant Fyssher Henry chapman 596561 596561 Fyssher, Henry, of Bath, Soms, chapman 0
4070608 2049783 2049783 plaintiff Mathewe Thomas gent 596561 596561 Mathewe, Thomas, of Bath, Soms, gent 0
4076346 2051838 2051838 plaintiff Sherstone William clothier 596561 596561 Sherstone, William, of Bath, Soms, clothier 0
4076348 2051839 2051839 plaintiff Sherstone William clothier 596561 596561 Sherstone, William, of Bath, Soms, clothier 0
4085464 2055079 2055079 defendant Whippinge William yeoman 596561 596561 Whippinge, William, of Bath, Soms, yeoman 0
4087217 2055719 2055719 defendant Mathue or Mathewe Thomas gent 596561 596561 Mathue or Mathewe, Thomas, of Bath, Soms, gent 0
4093781 2058098 2058098 defendant Perman George gent 596561 596561 Perman, George, of Bath, Soms, gent 0
4100108 2060371 2060371 defendant Perman George gent 596561 596561 Perman, George, of Bath, Soms, gent 1
4101388 2060800 2060800 defendant Howell Mathew chapman 596561 596561 Howell, Mathew, of Bath, Soms, chapman 0
4105582 2062277 2062277 defendant Fysher Henry chapman 596561 596561 Fysher, Henry, of Bath, Soms, chapman 0
4105584 2062278 2062278 defendant Fysher Henry chapman 596561 596561 Fysher, Henry, of Bath, Soms, chapman 0
4113287 2065019 2065019 defendant Turner Thomas yeoman 596561 596561 Turner, Thomas, of Bath, Soms, yeoman 0
4119286 2067190 2067190 defendant Davers John gent 596561 596561 Davers, John, of Bath, Soms, gent 0
4130109 2071075 2071075 defendant Colthurste Edmund gent 596561 596561 Colthurste, Edmund, of Bath, Soms, gent 0
4134614 2072710 2072710 defendant Busshe Thomas gent 596561 596561 Busshe, Thomas, of Bath, Soms, gent 0
4145057 2076432 2076432 defendant Blackleythe Henry vintner 596561 596561 Blackleythe, Henry, of Bath, Soms, vintner 0
4162826 2082542 2082542 defendant Gybbes John gent 596561 596561 Gybbes, John, of Bath, Soms, gent 12
4166026 2083621 2083621 defendant Ivell Joan   596561 596561 Ivell, Joan, of Bath, Soms, widow of William Iwell, of North Breadley 0
4190125 2092051 2092051 defendant Coulthurste Edmund esq 596561 596561 Coulthurste, Edmund, of Bath, Soms, esq 0
4201611 2096107 2096107 defendant Hopkyns Paul chapman 596561 596561 Hopkyns, Paul, of Bath, Soms, chapman 2
4209742 2098962 2098962 defendant Perman George alderman 596561 596561 Perman, George, of Bath, Soms, alderman 0
4209744 2098963 2098963 defendant Cavell William alderman 596561 596561 Cavell, William, of Bath, Soms, alderman 0
4242647 2110532 2110532 defendant Meredith Richard clerk 596561 596561 Meredith, Richard, of Bath, Soms, clerk 0
4251923 2113633 2113633 defendant Martyn Jerome dyer 596561 596561 Martyn, Jerome, of Bath, Soms, dyer 0
4297978 2129380 2129380 defendant Pearman George gent 596561 596561 Pearman, George, of Bath, Soms, gent 0
4305990 2132234 2132234 defendant Grenden Thomas chapman 596561 596561 Grenden, Thomas, of Bath, Soms, chapman 0
4311892 2134295 2134295 defendant Sherewode John   596561 596561 Sherewode, John, of Bath, Soms, gent, Doctor of Medicine 0
4312293 2134436 2134436 defendant Sherwood John   596561 596561 Sherwood, John, of Bath, Soms, Doctor of Medicine 0
4325105 2138780 2138780 defendant Hopkyns Paul vintner 596561 596561 Hopkyns, Paul, of Bath, Soms, yeoman, vintner 0
4325450 2138888 2138888 defendant Weekes Robert esq 596561 596561 Weekes, Robert, of Bath, Soms, esq 1
4338947 2143377 2143377 defendant Coker Lawrence gent 596561 596561 Coker, Lawrence, of Bath, Soms, gent 0
4344804 2145463 2145463 defendant Perman Richard vintner 596561 596561 Perman, Richard, of Bath, Soms, vintner 0
4344807 2145464 2145464 defendant Perman John vintner 596561 596561 Perman, John, of Bath, Soms, vintner 0
4356123 2149364 2149364 defendant Grynden Thomas chapman 596561 596561 Grynden, Thomas, of Bath, Soms, chapman 0
4398465 2164068 2164068 defendant Fisher Robert yeoman 596561 596561 Fisher, Robert, of Bath, Soms, yeoman 1
4412796 2168875 2168875 defendant Coxe Stephen chandler 596561 596561 Coxe, Stephen, of Bath, Soms, chandler 0
4606263 2233071 2233071 defendant Bartelot William   596561 596561 Bartelot, William, of Bath, Soms 0
4649042 2245770 2245770 defendant Wydecombe Thomas   596561 596561 Wydecombe, Thomas, of Bath, Soms 1
4653170 2246927 2246927 defendant Savage John, junior chapman 596561 596561 Savage, John, junior, of Bath, Soms, chapman 1
4653173 2246928 2246928 defendant Savage John, junior chapman 596561 596561 Savage, John, junior, of Bath, Soms, chapman 1
4675093 2257821 2257821 defendant Honybrigge Richard weaver 596561 596561 Honybrigge, Richard, of Bath, Soms, weaver 0
4702393 2266160 2266160 defendant Radestoke William yeoman & porter of the priory in Bath 596561 596561 Radestoke, William, of Bath, Soms, yeoman & porter of the priory in Bath 0
4703102 2266346 2266346 defendant Hobbes Roger yeoman 596561 596561 Hobbes, Roger, of Bath, Soms, yeoman 0
4703104 2266347 2266347 defendant Hobbes Roger yeoman 596561 596561 Hobbes, Roger, of Bath, Soms, yeoman 0
4704381 2266745 2266745 defendant Strange William fuller 596561 596561 Strange, William, of Bath, Soms, fuller 2
4717521 2270815 2270815 defendant Stanfery Thomas, sen mercer 596561 596561 Stanfery, Thomas, sen, of Bath, Soms, mercer 0
4720030 2271612 2271612 defendant Bukerell Henry merchant 596561 596561 Bukerell, Henry, of Bath, Soms, merchant 0
4725765 2273345 2273345 defendant Essekes John husbandman 596561 596561 Essekes, John, of Bath, Soms, husbandman 3
4727887 2273965 2273965 plaintiff Honybrugge William   596561 596561 Honybrugge, William, of Bath, Soms, burgess & merchant 0
4733511 2275656 2275656 defendant Lange John draper 596561 596561 Lange, John, of Bath, Soms, draper 0
4734556 2275974 2275974 defendant Stanefery Thomas mercer 596561 596561 Stanefery, Thomas, of Bath, Soms, mercer 0
4734562 2275975 2275975 defendant Standfery Thomas mercer 596561 596561 Standfery, Thomas, of Bath, Soms, mercer 0
4751213 2280832 2280832 defendant Aylemere Thomas fuller 596561 596561 Aylemere, Thomas, of Bath, Soms, fuller 2
4751226 2280835 2280835 defendant Stanefery Thomas mercer 596561 596561 Stanefery, Thomas, of Bath, Soms, mercer 0
4760240 2283555 2283555 defendant Holme John mercer 596561 596561 Holme, John, of Bath, Soms, mercer 2
4810326 2299375 2299375 defendant Haynes John husbandman 596561 596561 Haynes, John, of Bath, Soms, husbandman 0
4866978 2316637 2316637 plaintiff Haynes John   596561 596561 Haynes, John, of Bath, Soms 0
4869681 2317483 2317483 defendant Montayne John husbandman 596561 596561 Montayne, John, of Bath, Soms, husbandman 0
4877412 2319889 2319889 defendant Haynes John weaver 596561 596561 Haynes, John, of Bath, Soms, weaver 0
4912777 2330494 2330494 plaintiff Sever Geoffrey weaver 596561 596561 Sever, Geoffrey, of Bath, Soms, weaver 14
4925262 2334330 2334330 defendant Perkyn John fuller 596561 596561 Perkyn, John, of Bath, Soms, fuller 3
4996305 2355753 2355753 defendant Megge Thomas merchant 596561 596561 Megge, Thomas, of Bath, Soms, merchant 0
4996307 2355754 2355754 defendant Megge Thomas merchant 596561 596561 Megge, Thomas, of Bath, Soms, merchant 0
5004127 2358095 2358095 defendant Abyndon William   596561 596561 Abyndon, William, of Bath, Soms, cloth maker 1
5133177 2396181 2396181 defendant Mowntayne John gent 596561 596561 Mowntayne, John, of Bath, Soms, gent 0
5137387 2397447 2397447 defendant Sexteyn John clothmaker 596561 596561 Sexteyn, John, of Bath, Soms, clothmaker 2
5158021 2403469 2403469 defendant Sexteyn John   596561 596561 Sexteyn, John, of Bath, Soms, cloth maker 2
5173743 2408017 2408017 defendant Sexteyn John   596561 596561 Sexteyn, John, of Bath, Soms, cloth maker 2
5188552 2412372 2412372 defendant Stanborowe Roger merchant 596561 596561 Stanborowe, Roger, of Bath, Soms, merchant 0
5229348 2424195 2424195 defendant Chepman John chapman 596561 596561 Chepman, John, of Bath, Soms, chapman 1
5404036 2476230 2476230 defendant Haynes William clothier 596561 596561 (Haynes, William, of Bath, Soms, clothier 1
5432575 2484713 2484713 defendant Haynes William clothier 596561 596561 (Haynes, William, of Bath, Soms, clothier 1

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);