names

86 rows where place_id = 663311

✎ 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
3968347 2013561 2013561 defendant Renson John baker 663311 663311 Renson, John, of Bridgwater, baker 0
3999574 2024614 2024614 plaintiff Galhampton or Gallyngton John merchant 663311 663311 Galhampton or Gallyngton, John, of Bridgwater, merchant 0
4057689 2045132 2045132 defendant Wood Richard merchant 663311 663311 Wood, Richard, of Bridgwater, merchant 0
4064627 2047631 2047631 defendant Rouswell Robert   663311 663311 Rouswell, Robert, of Bridgwater, mason 2
4071030 2049940 2049940 plaintiff Mollens Robert (legal representative) 663311 663311 Mollens, Robert, of Bridgwater, gent, executors of 0
4071032 2049940 2049940 defendant Morse John (legal representative) 663311 663311 Morse, John, of Bridgwater, yeoman, executor of 0
4076515 2051896 2051896 defendant Shercombe Geoffrey yeoman 663311 663311 Shercombe, Geoffrey, of Bridgwater, yeoman 0
4085415 2055060 2055060 defendant Halswell Hugh gent 663311 663311 Halswell, Hugh, of Bridgwater, or of Bowre, gent 0
4089787 2056642 2056642 defendant Edward John gent 663311 663311 Edward, John, of Bridgwater, gent 0
4089788 2056642 2056642 defendant Warman Adrian yeoman 663311 663311 Warman, Adrian, of Bridgwater, yeoman 1
4089789 2056642 2056642 defendant Fyshe Richard shoemaker 663311 663311 Fyshe, Richard, of Bridgwater, shoemaker 2
4117234 2066469 2066469 defendant Collyns Derbeus or Derby chapman 663311 663311 Collyns, Derbeus or Derby, of Bridgwater, chapman 3
4126939 2069927 2069927 defendant Lyminge Robert yeoman 663311 663311 Lyminge, Robert, of Bridgwater, yeoman 0
4126940 2069927 2069927 defendant Hoskins William yeoman 663311 663311 Hoskins, William, of Bridgwater, yeoman 1
4131541 2071598 2071598 defendant Popham George merchant 663311 663311 Popham, George, of Bridgwater, merchant 2
4133711 2072390 2072390 defendant Bowringe Robert yeoman 663311 663311 Bowringe, Robert, of Bridgwater, yeoman 2
4145884 2076717 2076717 defendant Galhampton John yeoman 663311 663311 Galhampton, John, of Bridgwater, yeoman 0
4150289 2078232 2078232 defendant Lynynge or Lyvynge Robert yeoman 663311 663311 Lynynge or Lyvynge, Robert, of Bridgwater, yeoman 0
4150290 2078232 2078232 defendant Hoskins William yeoman 663311 663311 Hoskins, William, of Bridgwater, yeoman 1
4177623 2087649 2087649 defendant Doddyngton Edward gent 663311 663311 Doddyngton, Edward, of Bridgwater, gent 2
4181961 2089169 2089169 defendant Odar Elizabeth widow 663311 663311 Odar, Elizabeth, of Bridgwater, widow 1
4188725 2091535 2091535 defendant Peryn William weaver 663311 663311 Peryn, William, of Bridgwater, or of Dorchester, Dorset, weaver 0
4212820 2100018 2100018 defendant Cooke Robert shoemaker 663311 663311 Cooke, Robert, of Bridgwater, shoemaker 0
4215514 2100921 2100921 defendant Milles Richard yeoman 663311 663311 Milles, Richard, of Bridgwater, yeoman 0
4224361 2104005 2104005 defendant Pike John   663311 663311 Pike, John, of Bridgwater merchant 1
4229883 2105935 2105935 defendant Colridge Simon shoemaker 663311 663311 Colridge, Simon, of Bridgwater, shoemaker 0
4233039 2107062 2107062 defendant Castleman Gasparus mercer 663311 663311 Castleman, Gasparus, of Bridgwater, mercer 0
4233182 2107115 2107115 defendant Symes Henry (legal representative) 663311 663311 Symes, Henry, of Bridgwater, yeoman, administratrix of 0
4233183 2107115 2107115 defendant Symes Katherine widow 663311 663311 Symes, Katherine, of Bridgwater, widow 1
4236670 2108399 2108399 defendant Forde William yeoman 663311 663311 Forde, William, of Bridgwater, yeoman 0
4236673 2108400 2108400 defendant Tilboro Henry yeoman 663311 663311 Tilboro, Henry, of Bridgwater, yeoman 0
4243409 2110788 2110788 defendant Watt or Watkins John gent 663311 663311 Watt or Watkins, John, of Bridgwater, gent 0
4243951 2110959 2110959 defendant Bucke John merchant 663311 663311 Bucke, John, of Bridgwater, merchant 1
4244264 2111070 2111070 defendant Bulpan Edward husbandman 663311 663311 Bulpan, Edward, of Bridgwater, or of Morland, Soms, husbandman 0
4251185 2113374 2113374 defendant Milles Richard yeoman 663311 663311 Milles, Richard, of Bridgwater, yeoman 0
4251333 2113424 2113424 defendant Symes Henry (legal representative) 663311 663311 Symes, Henry, of Bridgwater, yeoman, administratrix of 0
4251334 2113424 2113424 defendant Symes Katherine widow 663311 663311 Symes, Katherine, of Bridgwater, widow 1
4255433 2114813 2114813 defendant Bulpan Edward husbandman 663311 663311 Bulpan, Edward, of Bridgwater, or of Morland, Soms, husbandman 0
4255439 2114814 2114814 defendant Milles Richard yeoman 663311 663311 Milles, Richard, of Bridgwater, yeoman 1
4255440 2114814 2114814 defendant Frumynge Jasper chandler 663311 663311 Frumynge, Jasper, of Bridgwater, chandler 2
4286807 2125336 2125336 defendant Rowborrowe Athewinus tailor 663311 663311 Rowborrowe, Athewinus, of Bridgwater, tailor 0
4287102 2125441 2125441 defendant Berryfeilde Roger victualer 663311 663311 Berryfeilde, Roger, of Bridgwater, victualer 0
4301818 2130758 2130758 defendant Berifeilde Roger butcher 663311 663311 Berifeilde, Roger, of Bridgwater, butcher 1
4302423 2130968 2130968 defendant Frowman Jasper merchant 663311 663311 Frowman, Jasper, of Bridgwater, merchant 1
4305159 2131941 2131941 defendant Marchaunte John gent 663311 663311 Marchaunte, John, of Bridgwater, gent 1
4307400 2132726 2132726 defendant Francklyn James yeoman 663311 663311 Francklyn, James, of Bridgwater, yeoman 0
4318947 2136739 2136739 defendant Habberfeilde George gent 663311 663311 Habberfeilde, George, of Bridgwater, gent 2
4329296 2140110 2140110 defendant Marchant John gent 663311 663311 Marchant, John, of Bridgwater, gent 1
4355236 2149052 2149052 defendant Weche Fabian tanner 663311 663311 Weche, Fabian, of Bridgwater, tanner 0
4355237 2149052 2149052 defendant Yendall or Yeudall Abraham tanner 663311 663311 together with Yendall or Yeudall, Abraham, of Bridgwater, tanner 1
4359213 2150453 2150453 defendant Baker Robert clothier 663311 663311 Baker, Robert, of Bridgwater, clothier 1
4360299 2150852 2150852 defendant Lokyer John butcher 663311 663311 Lokyer, John, of Bridgwater, butcher 0
4361317 2151209 2151209 defendant Bowringe Robert yeoman 663311 663311 Bowringe, Robert, of Bridgwater, yeoman 0
4363298 2151945 2151945 defendant Castleman Jasper mercer 663311 663311 Castleman, Jasper, of Bridgwater, mercer 0
4363300 2151945 2151945 defendant Haberfield George yeoman 663311 663311 Haberfield, George, of Bridgwater, yeoman 2
4363556 2152038 2152038 defendant Thomas William merchant 663311 663311 Thomas, William, of Bridgwater, merchant 0
4375133 2156166 2156166 defendant Thomas William chapman 663311 663311 Thomas, William, of Bridgwater, chapman 0
4375134 2156166 2156166 defendant Thomas John chapman 663311 663311 Thomas, John, of Bridgwater, chapman 1
4375464 2156279 2156279 defendant Mathewes Thomas   663311 663311 Mathewes, Thomas, of Bridgwater, sailor 0
4375465 2156279 2156279 defendant Bennett Thomas clothier 663311 663311 Bennett, Thomas, of Bridgwater, clothier 1
4378116 2157240 2157240 defendant Mathewes Thomas   663311 663311 Mathewes, Thomas, of Bridgwater, sailor 3
4378536 2157396 2157396 defendant Hurford Augustine tailor 663311 663311 Hurford, Augustine, of Bridgwater, tailor 1
4379247 2157658 2157658 defendant Weche Fabian tanner 663311 663311 Weche, Fabian, of Bridgwater, tanner 0
4379248 2157658 2157658 defendant Yendall Abraham tanner 663311 663311 Yendall, Abraham, of Bridgwater, tanner 1
4382047 2158680 2158680 defendant Gatcombe John husbandman 663311 663311 Gatcombe, John, of Bridgwater, husbandman 1
4382386 2158809 2158809 defendant Thomas John merchant 663311 663311 Thomas, John, of Bridgwater, merchant 0
4384234 2159420 2159420 defendant Thomas John chapman 663311 663311 Thomas, John, of Bridgwater, chapman 1
4390116 2161314 2161314 defendant Blake Humphrey gent 663311 663311 Blake, Humphrey, of Bridgwater, gent 1
4408184 2167308 2167308 defendant Townsen Thomas husbandman 663311 663311 Townsen, Thomas, of Bridgwater, husbandman 1
4408185 2167308 2167308 defendant Neeld Richard, junior husbandman 663311 663311 Neeld, Richard, junior, of Bridgwater, husbandman 2
4408365 2167372 2167372 defendant Reape Robert yeoman 663311 663311 Reape, Robert, of Bridgwater, yeoman 0
4485282 2196099 2196099 defendant Warde Richard   663311 663311 Warde, Richard, of Bridgwater 2
4692909 2263291 2263291 defendant Dyer Roger dyer 663311 663311 Dyer, Roger, of Bridgwater, dyer 0
4693647 2263514 2263514 defendant Tought William merchant 663311 663311 Tought, William, of Bridgwater, merchant 0
4695231 2263987 2263987 defendant Broun William   663311 663311 Broun, William, of Bridgwater, hoop maker 0
4703679 2266531 2266531 defendant Austyn Walter husbandman 663311 663311 Austyn, Walter, of Bridgwater, husbandman 0
4703728 2266545 2266545 defendant Bussh Thomas merchant 663311 663311 Bussh, Thomas, of Bridgwater, merchant 0
4706069 2267273 2267273 defendant Broune Walter weaver 663311 663311 Broune, Walter, of Bridgwater, weaver 0
4707045 2267586 2267586 defendant Pytte John merchant 663311 663311 Pytte, John, of Bridgwater, merchant 0
4708041 2267888 2267888 defendant atte Water William yeoman 663311 663311 atte Water, William, of Bridgwater, yeoman 0
4714371 2269824 2269824 defendant Dyer Andrew dyer 663311 663311 Dyer, Andrew, of Bridgwater, dyer 2
4720150 2271646 2271646 plaintiff Bretell Richard   663311 663311 Bretell, Richard, of Bridgwater 0
4736830 2276648 2276648 defendant Ayleward John merchant 663311 663311 Ayleward, John, of Bridgwater, merchant 0
4736833 2276648 2276648 defendant Davy Philip tanner 663311 663311 Davy, Philip, of Bridgwater, tanner 3
4755465 2282088 2282088 plaintiff atte Wode William   663311 663311 atte Wode, William, of Bridgwater 0
4846059 2310272 2310272 plaintiff Pilton Thomas master of the hospital of St John Baptist 663311 663311 Pilton, Thomas, of Bridgwater, master of the hospital of St John Baptist 0

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