names

160 rows where place_id = 590141

✎ 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
3600058 1867671 1867671 defendant Badam William husbandman 590141 590141 Badam, William, of Dursley, husbandman 1
3639899 1907292 1907292 plaintiff Wykys Edmund esq 590141 590141 Wykys, Edmund, of Dursley, esq 0
3650234 1910444 1910444 defendant Payne John baker or innholder 590141 590141 Payne, John, of Dursley, baker or innholder 0
3660318 1913487 1913487 defendant Burstowe James butcher 590141 590141 Burstowe, James, of Dursley, butcher 2
3669757 1916487 1916487 defendant Pacy William weaver 590141 590141 Pacy, William, of Dursley, weaver 5
3672613 1917433 1917433 defendant Thurston Thomas tucker 590141 590141 Thurston, Thomas, of Dursley, tucker 0
3672878 1917529 1917529 defendant Rogers Maurice butcher 590141 590141 Rogers, Maurice, of Dursley, butcher 1
3675793 1918461 1918461 defendant Samford William tucker 590141 590141 Samford, William, of Dursley, tucker 0
3686842 1922045 1922045 defendant Brystowe John butcher 590141 590141 Brystowe, John, of Dursley, butcher 0
3686843 1922045 1922045 defendant Rogers Maurice butcher 590141 590141 Rogers, Maurice, of Dursley, butcher 1
3703407 1927343 1927343 plaintiff Davys John, senior   590141 590141 Davys, John, senior, of Dursley 0
3714562 1930853 1930853 defendant Samford John weaver 590141 590141 Samford, John, of Dursley, weaver 0
3714563 1930853 1930853 defendant Grenowe David tailor 590141 590141 Grenowe, David, of Dursley, tailor 1
3731341 1936024 1936024 defendant Fynche Augustine clothman 590141 590141 Fynche, Augustine, of Dursley, clothman 1
3731345 1936026 1936026 defendant Stynchecombe Robert chaplain 590141 590141 Stynchecombe, Robert, of Dursley, chaplain 0
3731346 1936026 1936026 defendant Fynche Augustine clothman 590141 590141 Fynche, Augustine, of Dursley, clothman 1
3735627 1937376 1937376 defendant Cole Thomas wheeler 590141 590141 Cole, Thomas, of Dursley, wheeler 0
3744843 1940286 1940286 defendant Bowser Richard sherman 590141 590141 Bowser, Richard, of Dursley, sherman 0
3749605 1941787 1941787 defendant Parker Henry weaver 590141 590141 Parker, Henry, of Dursley, weaver 2
3756463 1943994 1943994 defendant Galond Nicholas weaver 590141 590141 Galond, Nicholas, of Dursley, weaver 2
3768234 1947704 1947704 defendant Rogers Maurice butcher 590141 590141 Rogers, Maurice, of Dursley, butcher 1
3771680 1948842 1948842 defendant Trotman Nicholas weaver 590141 590141 Trotman, Nicholas, of Dursley, weaver 1
3772343 1949035 1949035 defendant Pole Thomas husbandman 590141 590141 Pole, Thomas, of Dursley, husbandman 2
3780123 1951508 1951508 defendant Byreatt John carrier 590141 590141 Byreatt, John, of Dursley, carrier 1
3780599 1951660 1951660 defendant Peyn John husbandman 590141 590141 Peyn, John, of Dursley, husbandman 0
3780600 1951660 1951660 defendant Taylour William husbandman 590141 590141 Taylour, William, of Dursley, husbandman 1
3786058 1953431 1953431 defendant Mayhewe Thomas yeoman 590141 590141 Mayhewe, Thomas, of Dursley, yeoman 2
3789374 1954498 1954498 defendant Tretman Nicholas weaver 590141 590141 Tretman, Nicholas, of Dursley, weaver 0
3793019 1955675 1955675 defendant Ithell Thomas husbandman 590141 590141 Ithell, Thomas, of Dursley, husbandman 0
3802535 1958690 1958690 defendant Bowser Robert yeoman 590141 590141 Bowser, Robert, of Dursley, yeoman 0
3804455 1959333 1959333 defendant Pegeler Nicholas tucker 590141 590141 Pegeler, Nicholas, of Dursley, tucker 0
3805357 1959623 1959623 defendant Ithell Richard husbandman 590141 590141 Ithell, Richard, of Dursley, husbandman 0
3856562 1975677 1975677 defendant Trotman Nicholas weaver 590141 590141 Trotman, Nicholas, of Dursley, weaver 5
3856570 1975679 1975679 defendant Eskyn John tucker 590141 590141 Eskyn, John, of Dursley, tucker 3
3858116 1976194 1976194 defendant Webbe Edward clothier 590141 590141 Webbe, Edward, of Dursley, clothier 0
3858117 1976194 1976194 defendant Cole Thomas husbandman 590141 590141 Cole, Thomas, of Dursley, husbandman 1
3876555 1982405 1982405 defendant Bocher William butcher 590141 590141 Bocher, William, of Dursley, butcher 1
3884182 1984975 1984975 defendant Heskys John clothier 590141 590141 Heskys, John, of Dursley, clothier 0
3940945 2003980 2003980 defendant Smalewod Thomas clothman 590141 590141 Smalewod, Thomas, of Dursley, clothman 0
3940947 2003981 2003981 defendant Smalwod Thomas clothman 590141 590141 Smalwod, Thomas, of Dursley, clothman 0
3948440 2006518 2006518 defendant Nelme or Neline William weaver 590141 590141 Nelme or Neline, William, of Dursley, weaver 0
3948441 2006518 2006518 defendant Parker John weaver 590141 590141 Parker, John, of Dursley, weaver 1
3948442 2006518 2006518 defendant Hyll Thomas weaver 590141 590141 Hyll, Thomas, of Dursley, weaver 2
3948443 2006518 2006518 defendant Adams thomas weaver 590141 590141 Adams, thomas, of Dursley, weaver 3
3962310 2011400 2011400 defendant Plant Richard clothier 590141 590141 Plant, Richard, of Dursley, clothier 0
3962937 2011635 2011635 plaintiff Wolworthe alias Webbe John clothier 590141 590141 Wolworthe alias Webbe, John, of Dursley, clothier 0
3988781 2020735 2020735 defendant Atwood Thomas, senior weaver 590141 590141 Atwood, Thomas, senior, of Dursley, weaver 0
4037130 2037943 2037943 plaintiff Jochym Thomas weaver 590141 590141 Jochym, Thomas, of Dursley, weaver 0
4083041 2054229 2054229 defendant Fynche John yeoman 590141 590141 Fynche, John, of Dursley, yeoman 0
4139266 2074413 2074413 defendant Hynck William clerk 590141 590141 Hynck, William, of Dursley, clerk 0
4150910 2078452 2078452 defendant Bowcer Edmund gent 590141 590141 Bowcer, Edmund, of Dursley, gent 0
4150912 2078452 2078452 defendant Plante Richard yeoman 590141 590141 Plante, Richard, of Dursley, yeoman 2
4150913 2078452 2078452 defendant Davis alias Wormecote Thomas yeoman 590141 590141 Davis alias Wormecote, Thomas, of Dursley, yeoman 3
4150915 2078453 2078453 defendant Bowcer Edmund gent 590141 590141 Bowcer, Edmund, of Dursley, gent 0
4150916 2078453 2078453 defendant Kynge Richard yeoman 590141 590141 Kynge, Richard, of Dursley, yeoman 1
4150917 2078453 2078453 defendant Plante John yeoman 590141 590141 Plante, John, of Dursley, yeoman 2
4150918 2078453 2078453 defendant Plante Richard yeoman 590141 590141 Plante, Richard, of Dursley, yeoman 3
4150919 2078453 2078453 defendant Davis alias Wormecote Thomas yeoman 590141 590141 Davis alias Wormecote, Thomas, of Dursley, yeoman 4
4165254 2083356 2083356 defendant Plante Richard yeoman 590141 590141 Plante, Richard, of Dursley, yeoman 0
4165256 2083356 2083356 defendant Davis alias Wormecote Thomas yeoman 590141 590141 Davis alias Wormecote, Thomas, of Dursley, yeoman 2
4165257 2083356 2083356 defendant Turner Thomas yeoman 590141 590141 Turner, Thomas, of Dursley, yeoman 3
4165258 2083356 2083356 defendant Plante John yeoman 590141 590141 Plante, John, of Dursley, yeoman 4
4166356 2083728 2083728 defendant Grace John dyer 590141 590141 Grace, John, of Dursley, yeoman, dyer 1
4303100 2131213 2131213 defendant Fynche John clerk 590141 590141 Fynche, John, of Dursley, clerk 0
4303101 2131213 2131213 defendant Fynche Elizabeth spinster 590141 590141 Fynche, Elizabeth, of Dursley, spinster 1
4318240 2136487 2136487 defendant Bence Samuel yeoman 590141 590141 Bence, Samuel, of Dursley, yeoman 0
4374772 2156032 2156032 defendant Flemynge Hugh clothier 590141 590141 Flemynge, Hugh, of Dursley, clothier 0
4374782 2156036 2156036 defendant Flemynge Hugh clothier 590141 590141 Flemynge, Hugh, of Dursley, clothier 0
4480307 2194505 2194505 plaintiff Kyng William   590141 590141 Kyng, William, of Dursley 0
4485583 2196197 2196197 plaintiff Rede John   590141 590141 Rede, John, of Dursley 0
4485584 2196197 2196197 defendant Pulune Richard shoemaker 590141 590141 Pulune, Richard, of Dursley, shoemaker 0
4645949 2244886 2244886 defendant Tanner Thomas   590141 590141 Tanner, Thomas, of Dursley 0
4678813 2258977 2258977 defendant Webbe Robert butcher 590141 590141 Webbe, Robert, of Dursley, butcher 2
4712602 2269260 2269260 defendant Baker Richard baker 590141 590141 Baker, Richard, of Dursley, baker 2
4725224 2273183 2273183 defendant Smyth John smith 590141 590141 Smyth, John, of Dursley, smith 2
4725225 2273183 2273183 defendant Toft John dyer 590141 590141 Toft, John, of Dursley, dyer 3
4731894 2275156 2275156 defendant Peyso John dyer 590141 590141 Peyso, John, of Dursley, dyer 2
4735639 2276297 2276297 defendant Teysant John dyer 590141 590141 Teysant, John, of Dursley, dyer 0
4735656 2276301 2276301 defendant Teysaunt John dyer 590141 590141 Teysaunt, John, of Dursley, dyer 0
4763792 2284665 2284665 defendant Webbe Robert butcher 590141 590141 Webbe, Robert, of Dursley, butcher 0
4781401 2290191 2290191 defendant Tanner Thomas merchant 590141 590141 Tanner, Thomas, of Dursley, merchant 1
4781402 2290191 2290191 defendant Webbe Robert butcher 590141 590141 Webbe Robert, of Dursley, butcher 2
4853968 2312649 2312649 defendant Packer Thomas husbandman 590141 590141 Packer, Thomas, of Dursley, husbandman 0
4882154 2321322 2321322 plaintiff Tanner Thomas merchant 590141 590141 Tanner, Thomas, of Dursley, merchant 1
4882234 2321351 2321351 defendant Plymmeswode Walter tucker 590141 590141 Plymmeswode, Walter, of Dursley, tucker 0
4916401 2331629 2331629 defendant Tanner Thomas tanner 590141 590141 Tanner, Thomas, of Dursley, tanner 0
5010825 2360018 2360018 defendant Vale John fuller 590141 590141 Vale, John, of Dursley, fuller 0
5023029 2363644 2363644 plaintiff Gylmyn alias Tanner Thomas merchant 590141 590141 Gylmyn alias Tanner, Thomas, of Dursley, merchant 0
5041434 2369045 2369045 defendant Wilmete John husbandman 590141 590141 Wilmete, John, of Dursley, husbandman 1
5054081 2372814 2372814 defendant Wyke Thomas gent 590141 590141 Wyke, Thomas, of Dursley, gent 0
5058547 2374112 2374112 plaintiff Davy John merchant 590141 590141 Davy, John, of Dursley, merchant 0
5072491 2378259 2378259 plaintiff Wolworth Robert weaver 590141 590141 Wolworth, Robert, of Dursley, weaver 1
5073286 2378498 2378498 defendant Jamys John tucker or draper 590141 590141 Jamys, John, of Dursley, tucker or draper 0
5075625 2379209 2379209 defendant Gybbes Nicholas weaver 590141 590141 Gybbes, Nicholas, of Dursley, weaver 0
5076171 2379374 2379374 defendant Wykes Thomas gent 590141 590141 Wykes, Thomas, of Dursley, gent 0
5076172 2379374 2379374 defendant Wykes John gent 590141 590141 Wykes, John, of Dursley, gent 1
5077070 2379639 2379639 defendant Plynnswode Walter tucker 590141 590141 Plynnswode, Walter, of Dursley, tucker 0
5079017 2380208 2380208 defendant Averey Nicholas tucker 590141 590141 Averey, Nicholas, of Dursley, tucker 1
5083719 2381633 2381633 defendant Tanner Robert gent 590141 590141 Tanner, Robert, of Dursley, gent 1
5085963 2382287 2382287 defendant Carpynter alias Walker John fuller 590141 590141 Carpynter alias Walker, John, of Dursley, 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);