names

166 rows where place_id = 780266

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4667186 2255469 2255469 defendant Stevenys Thomas gent 780266 780266 Stevenys, Thomas, of Gloucester, Gloucs, gent 0
4667311 2255505 2255505 defendant Martyn John   780266 780266 Martyn, John, of Gloucester, Gloucs, bladesmith 0
4668845 2255960 2255960 defendant Horner John chapman 780266 780266 Horner, John, of Gloucester, Gloucs, chapman 2
4670968 2256589 2256589 defendant Mountayn William cutler 780266 780266 Mountayn, William, of Gloucester, Gloucs, cutler 2
4677981 2258730 2258730 defendant Brygge Thomas yeoman 780266 780266 (Brygge, Thomas, of Gloucester, Gloucs, yeoman 4
4680245 2259432 2259432 defendant Moreton Walter gent 780266 780266 Moreton, Walter, of Gloucester, Gloucs, gent 1
4682392 2260112 2260112 defendant Stevenes Thomas gent 780266 780266 Stevenes, Thomas, of Gloucester, Gloucs, gent 0
4687532 2261691 2261691 defendant Hopkyns Richard chapman 780266 780266 Hopkyns, Richard, of Gloucester, Gloucs, chapman 1
4687539 2261692 2261692 defendant Hopkyns Richard chapman 780266 780266 Hopkyns, Richard, of Gloucester, Gloucs, chapman 1
4687568 2261697 2261697 defendant Gallrugge Thomas gent 780266 780266 Gallrugge, Thomas, of Gloucester, Gloucs, gent 1
4688501 2261968 2261968 defendant Hopkyns Richard chapman 780266 780266 Hopkyns, Richard, of Gloucester, Gloucs, chapman 0
4688921 2262091 2262091 defendant Horner alias Reymond John chapman 780266 780266 Horner alias Reymond, John, of Gloucester, Gloucs, chapman 0
4690669 2262632 2262632 defendant Manchester Philip yeoman 780266 780266 Manchester, Philip, of Gloucester, Gloucs, yeoman 1
4692458 2263159 2263159 defendant Goodeman William barber 780266 780266 Goodeman, William, of Gloucester, Gloucs, barber 1
4694741 2263850 2263850 defendant ap Yevan David chapman 780266 780266 ap Yevan, David, of Gloucester, Gloucs, chapman 0
4694743 2263851 2263851 defendant ap Yevan David chapman 780266 780266 ap Yevan, David, of Gloucester, Gloucs, chapman 0
4695237 2263990 2263990 defendant Irlond John dyer 780266 780266 Irlond, John, of Gloucester, Gloucs, dyer 0
4695357 2264028 2264028 defendant Circestre William smith 780266 780266 Circestre, William, of Gloucester, Gloucs, smith 0
4696237 2264307 2264307 defendant Freman Walter   780266 780266 Freman, Walter, of Gloucester, Gloucs, brass worker 0
4698100 2264892 2264892 defendant Heydon Agatha widow 780266 780266 Heydon, Agatha, of Gloucester, Gloucs, widow 0
4699245 2265230 2265230 defendant Hopkyn Richard dyer 780266 780266 Hopkyn, Richard, of Gloucester, Gloucs, dyer 0
4706878 2267530 2267530 defendant Brasier Walter brasier 780266 780266 Brasier, Walter, of Gloucester, Gloucs, brasier 0
4707898 2267839 2267839 defendant Baker William baker 780266 780266 Baker, William, of Gloucester, Gloucs, baker 0
4708751 2268107 2268107 defendant Skele William clerk 780266 780266 Skele, William, of Gloucester, Gloucs, clerk 2
4718700 2271188 2271188 defendant Wayte John   780266 780266 Wayte, John, of Gloucester, Gloucs, notary 0
4727886 2273964 2273964 defendant Galbrugge Thomas   780266 780266 Galbrugge, Thomas, of Gloucester, Gloucs 0
4727890 2273965 2273965 defendant Galbrugge Thomas gent 780266 780266 Galbrugge, Thomas, of Gloucester, Gloucs, gent 0
4728846 2274259 2274259 defendant Sebroke Lionel gent 780266 780266 (Sebroke, Lionel, of Gloucester, Gloucs, gent 1
4731388 2275017 2275017 defendant Cotford John gent 780266 780266 Cotford, John, of Gloucester, Gloucs, gent 1
4734669 2275998 2275998 defendant Tregowe Richard clerk 780266 780266 Tregowe, Richard, of Gloucester, Gloucs, husbandman, formerly of Lopidon, clerk 0
4743459 2278616 2278616 defendant Heydon Agatha widow 780266 780266 Heydon, Agatha, of Gloucester, Gloucs, widow 3
4743466 2278617 2278617 defendant Heydon Agatha widow 780266 780266 Heydon, Agatha, of Gloucester, Gloucs, widow 3
4743787 2278712 2278712 defendant Chapman David mercer 780266 780266 Chapman, David, of Gloucester, Gloucs, mercer 0
4743789 2278713 2278713 defendant Chapman David mercer 780266 780266 Chapman, David, of Gloucester, Gloucs, mercer 0
4744122 2278806 2278806 defendant Gold John cutler 780266 780266 Gold, John, of Gloucester, Gloucs, cutler 3
4744144 2278813 2278813 defendant Gold John cutler 780266 780266 Gold, John, of Gloucester, Gloucs, cutler 3
4744193 2278828 2278828 defendant Dhapman David chapman 780266 780266 Dhapman, David, of Gloucester, Gloucs, chapman 2
4752000 2281081 2281081 defendant Sparowe William chapman 780266 780266 Sparowe, William, of Gloucester, Gloucs, chapman 0
4752005 2281082 2281082 defendant Sparowe William chapman 780266 780266 Sparowe, William, of Gloucester, Gloucs, chapman 0
4755952 2282243 2282243 defendant Hert Walter clerk 780266 780266 together with Hert, Walter, of Gloucester, Gloucs, clerk 2
4756409 2282367 2282367 defendant Gerard John gent 780266 780266 Gerard, John, of Gloucester, Gloucs, gent 1
4756689 2282456 2282456 defendant Kirkeby John mercer 780266 780266 Kirkeby, John, of Gloucester, Gloucs, mercer 0
4758962 2283156 2283156 defendant Salbrigge Thomas esq 780266 780266 Salbrigge, Thomas, of Gloucester, Gloucs, esq 3
4762611 2284286 2284286 defendant Ingel John dyer 780266 780266 Ingel, John, of Gloucester, Gloucs, dyer 1
4762735 2284326 2284326 defendant Hopkynes David dyer 780266 780266 Hopkynes, David, of Gloucester, Gloucs, dyer 0
4765026 2285036 2285036 defendant Galbrugge Thomas gent 780266 780266 Galbrugge, Thomas, of Gloucester, Gloucs, gent 0
4765428 2285172 2285172 defendant Hypkyns Richard   780266 780266 Hypkyns, Richard, of Gloucester, Gloucs, burgess & chapman 0
4766856 2285626 2285626 defendant Stevenes Thomas chapman 780266 780266 Stevenes, Thomas, of Gloucester, Gloucs, chapman 0
4768172 2286017 2286017 defendant Stranwas John barber 780266 780266 Stranwas, John, of Gloucester, Gloucs, barber 0
4771141 2286956 2286956 defendant Hynton Richard dyer 780266 780266 Hynton, Richard, of Gloucester, Gloucs, dyer 0
4771980 2287210 2287210 defendant Trewepeny John clerk 780266 780266 Trewepeny, John, of Gloucester, Gloucs, clerk 0
4772928 2287503 2287503 defendant Chapman David chapman 780266 780266 Chapman, David, of Gloucester, Gloucs, chapman 0
4772992 2287526 2287526 defendant Hepkyns Richard chapman 780266 780266 Hepkyns, Richard, of Gloucester, Gloucs, chapman 0
4802900 2297095 2297095 defendant Assheworth John tailor 780266 780266 Assheworth, John, of Gloucester, Gloucs, tailor 0
4802906 2297096 2297096 defendant Raa Thomas (legal representative) 780266 780266 Raa, Thomas, of Gloucester, Gloucs, gent, executors of 0
4802912 2297097 2297097 defendant Raa Thomas (legal representative) 780266 780266 Raa, Thomas, of Gloucester, Gloucs, gent, executors of 0
4802918 2297098 2297098 defendant Assheworth John tailor 780266 780266 Assheworth, John, of Gloucester, Gloucs, tailor 0
4806676 2298298 2298298 defendant Bentham John draper 780266 780266 Bentham, John, of Gloucester, Gloucs, draper 1
4809154 2299039 2299039 defendant Golde John cutler 780266 780266 Golde, John, of Gloucester, Gloucs, cutler 1
4812826 2300128 2300128 defendant Bylley John chapman 780266 780266 Bylley, John, of Gloucester, Gloucs, chapman 1
4813436 2300314 2300314 defendant Walton John baker 780266 780266 Walton, John, of Gloucester, Gloucs, baker 0
4816972 2301410 2301410 defendant Edwarde John gent 780266 780266 Edwarde, John, of Gloucester, Gloucs, gent 0
4816975 2301411 2301411 defendant Edwarde John gent 780266 780266 Edwarde, John, of Gloucester, Gloucs, gent 0
4818264 2301790 2301790 defendant Denys Richard shoemaker 780266 780266 Denys, Richard, of Gloucester, Gloucs, shoemaker 0
4818549 2301881 2301881 defendant Goolde John cutler 780266 780266 Goolde, John, of Gloucester, Gloucs, cutler 0
4819984 2302328 2302328 defendant Whityng William gent 780266 780266 Whityng, William, of Gloucester, Gloucs, gent 0
4826425 2304302 2304302 defendant Hepkyns Richard dyer 780266 780266 Hepkyns, Richard, of Gloucester, Glouc, dyer 0
4828473 2304946 2304946 defendant Elderfelde William mercer 780266 780266 (Elderfelde, William, of Gloucester, Gloucs, mercer 1
4829265 2305192 2305192 defendant Staunton Thomas laborer 780266 780266 Staunton, Thomas, of Gloucester, Gloucs, laborer 0
4830091 2305455 2305455 defendant Coule or Conle John dyer 780266 780266 Coule or Conle, John, of Gloucester, Gloucs, dyer 3
4832763 2306271 2306271 defendant Barnard John cutler 780266 780266 Barnard, John, of Gloucester, Gloucs, cutler 1
4832771 2306273 2306273 defendant Bernard John cutler 780266 780266 Bernard, John, of Gloucester, Gloucs, cutler 0
4838159 2307857 2307857 defendant Galbrigge Thomas gent 780266 780266 Galbrigge, Thomas, of Gloucester, Gloucs, gent 1
4838166 2307860 2307860 defendant Galbrigge Thomas gent 780266 780266 Galbrigge, Thomas, of Gloucester, Gloucs, gent 1
4840875 2308682 2308682 defendant Botlowe James   780266 780266 Botlowe, James, of Gloucester, Gloucs, spice seller 4
4840924 2308696 2308696 defendant Botlowe James spicer 780266 780266 Botlowe, James, of Gloucester, Gloucs, spicer 4
4845755 2310183 2310183 defendant Chalecote Thomas gent 780266 780266 Chalecote, Thomas, of Gloucester, Glouc, gent 3
4915153 2331247 2331247 defendant Stonehouse Thomas gent 780266 780266 Stonehouse, Thomas, of Gloucester, Gloucs, gent 2
4915158 2331248 2331248 defendant Stonehouse Thomas gent 780266 780266 Stonehouse, Thomas, of Gloucester, Gloucs, gent 2
4918394 2332269 2332269 defendant Bysshop Philip vintner 780266 780266 (Bysshop, Philip, of Gloucester, Gloucs, vintner 1
4920861 2333038 2333038 defendant Luke John   780266 780266 Luke, John, of Gloucester, Gloucs, brass worker 0
4922603 2333483 2333483 defendant Chapman David chapman 780266 780266 Chapman, David, of Gloucester, Gloucs, chapman 1
4922620 2333486 2333486 defendant Chapman David chapman 780266 780266 Chapman, David, of Gloucester, Gloucs, chapman 1
4924718 2334168 2334168 defendant Thirston John chapman 780266 780266 Thirston, John, of Gloucester, Gloucs, chapman 0
4924731 2334171 2334171 defendant Thirston John chapman 780266 780266 Thirston, John, of Gloucester, Gloucs, chapman 0
4930281 2335871 2335871 defendant Kempston Thomas gent 780266 780266 Kempston, Thomas, of Gloucester, Gloucs, gent 0
4931490 2336229 2336229 defendant Pynner John pinner 780266 780266 Pynner, John, of Gloucester, Gloucs, pinner 2
4931791 2336330 2336330 defendant Wythe John yeoman 780266 780266 Wythe, John, of Gloucester, Gloucs, yeoman 1
4993610 2354962 2354962 defendant Saller John   780266 780266 Saller, John, of Gloucester, Gloucs, wire drawer 3
4996302 2355752 2355752 defendant Bysshop Robert vintner 780266 780266 Bysshop, Robert, of Gloucester, Gloucs, vintner 0
5001136 2357209 2357209 defendant Bysshop John taverner 780266 780266 Bysshop, John, of Gloucester, Gloucs, taverner 1
5003446 2357904 2357904 defendant Coudlon William baker 780266 780266 Coudlon, William, of Gloucester, Gloucs, baker 2
5003452 2357905 2357905 defendant Condelen William baker 780266 780266 Condelen, William, of Gloucester, Gloucs, baker 2
5010312 2359884 2359884 defendant Andreux John gent 780266 780266 Andreux, John, of Gloucester, Gloucs, gent 0
5041881 2369170 2369170 defendant Rede Thomas husbandman 780266 780266 Rede, Thomas, of Gloucester, Gloucs, husbandman 0
5046273 2370517 2370517 defendant Preston Thomas tailor 780266 780266 Preston, Thomas, of Gloucester, Gloucs, tailor 1
5124709 2393702 2393702 defendant Broun Thomas weaver 780266 780266 Broun, Thomas, of Gloucester, Gloucs, weaver 1
5126173 2394136 2394136 defendant Hoke John mercer 780266 780266 Hoke, John, of Gloucester, Gloucs, mercer 1
5127964 2394656 2394656 defendant Fountayn William merchant 780266 780266 Fountayn, William, of Gloucester, Gloucs, merchant 1
5131988 2395842 2395842 defendant Howes John merchant 780266 780266 Howes, John, of Gloucester, Gloucs, merchant 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);