names

134 rows where place_id = 654209

✎ 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
3931546 2000850 2000850 defendant Sallwyn William yeoman 654209 654209 Sallwyn, William, of Cirencester, Gloucs, yeoman 0
3934475 2001826 2001826 defendant Tykeley Richard yeoman 654209 654209 Tykeley, Richard, of Cirencester, Gloucs, yeoman 1
4629346 2240110 2240110 plaintiff Snell Thomas   654209 654209 Snell, Thomas, of Cirencester, Gloucs 0
4640860 2243425 2243425 defendant Wellyfed John   654209 654209 Wellyfed, John, of Cirencester, Gloucs 4
4640868 2243426 2243426 defendant Wellyfed John   654209 654209 Wellyfed, John, of Cirencester, Gloucs 4
4668207 2255768 2255768 defendant Lovekyn John tanner 654209 654209 Lovekyn, John, of Cirencester, Gloucs, tanner 0
4670173 2256376 2256376 defendant Drapere John merchant & son of Richard Drapere 654209 654209 Drapere, John, of Cirencester, Gloucs, merchant & son of Richard Drapere 0
4681121 2259723 2259723 defendant Lowekyng John yeoman 654209 654209 Lowekyng, John, of Cirencester, Gloucs, yeoman 0
4685629 2261096 2261096 defendant Norton John carpneter 654209 654209 Norton, John, of Cirencester, Gloucs, carpneter 0
4694245 2263700 2263700 defendant Thrisk John tanner 654209 654209 Thrisk, John, of Cirencester, Gloucs, tanner 3
4694737 2263849 2263849 defendant Draper Richard chapman 654209 654209 Draper, Richard, of Cirencester, Gloucs, chapman 1
4694752 2263853 2263853 defendant Drapere Richard chapman 654209 654209 Drapere, Richard, of Cirencester, Gloucs, chapman 1
4696373 2264344 2264344 defendant Sadelere Robert sadler 654209 654209 Sadelere, Robert, of Cirencester, Gloucs, sadler 0
4696709 2264448 2264448 defendant Drapere William   654209 654209 Drapere, William, of Cirencester, Gloucs, linen draperr 0
4697506 2264707 2264707 defendant Draper John draper 654209 654209 Draper, John, of Cirencester, Gloucs, draper 0
4698249 2264934 2264934 defendant Wellyfed John chapman 654209 654209 Wellyfed, John, of Cirencester, Gloucs, chapman 2
4699720 2265355 2265355 defendant Broun Thomas weaver 654209 654209 Broun, Thomas, of Cirencester, Gloucs, weaver 2
4702390 2266159 2266159 defendant Phelpis Thomas husbandman 654209 654209 Phelpis, Thomas, of Cirencester, Gloucs, husbandman 0
4702398 2266162 2266162 defendant Phelyps Thomas   654209 654209 Phelyps, Thomas, of Cirencester, Gloucs, husbandman, son of Thomas 0
4702399 2266162 2266162 defendant Phelyps Thomas husbandman 654209 654209 Phelyps, Thomas, of Cirencester, Gloucs, husbandman 1
4704640 2266831 2266831 defendant Draper John merchant 654209 654209 Draper, John, of Cirencester, Gloucs, merchant 0
4710853 2268750 2268750 defendant Draper William draper 654209 654209 Draper, William, of Cirencester, Gloucs, draper 0
4712244 2269145 2269145 defendant Draper John merchant 654209 654209 Draper, John, of Cirencester, Gloucs, draper, son of Richard Draper of Cirencester, merchant 0
4716015 2270317 2270317 defendant Benet Thomas gent 654209 654209 Benet, Thomas, of Cirencester, Gloucs, gent 1
4716019 2270318 2270318 defendant Benet Thomas gent 654209 654209 Benet, Thomas, of Cirencester, Gloucs, gent 1
4716757 2270563 2270563 defendant Beste William   654209 654209 Beste, William, of Cirencester, Gloucs, abbot 0
4717247 2270723 2270723 defendant Lukyn John chapman 654209 654209 Lukyn, John, of Cirencester, Gloucs, chapman 0
4717249 2270724 2270724 defendant Lukyn John chapman 654209 654209 Lukyn, John, of Cirencester, Gloucs, chapman 0
4719089 2271318 2271318 defendant Groune Thomas weaver 654209 654209 Groune, Thomas, of Cirencester, Gloucs, weaver 0
4719090 2271318 2271318 defendant Benet John yeoman 654209 654209 Benet, John, of Cirencester, Gloucs, yeoman 1
4719204 2271357 2271357 defendant Hoper John chapman 654209 654209 Hoper, John, of Cirencester, Gloucs, chapman 1
4719639 2271486 2271486 defendant Doughton William yeoman 654209 654209 (Doughton, William, of Cirencester, Gloucs, yeoman 1
4721108 2271935 2271935 defendant Broune Thomas weaver 654209 654209 Broune, Thomas, of Cirencester, Gloucs, weaver 0
4721109 2271936 2271936 plaintiff Cable John butcher 654209 654209 Cable, John, of Cirencester, Gloucs, butcher 0
4722889 2272475 2272475 defendant Broune Thomas weaver 654209 654209 Broune, Thomas, of Cirencester, Gloucs, weaver 0
4723607 2272687 2272687 defendant Torald John glover 654209 654209 Torald, John, of Cirencester, Glouc, glover 0
4725698 2273326 2273326 defendant Skirnour John weaver 654209 654209 Skirnour, John, of Cirencester, Gloucs, weaver 0
4725702 2273327 2273327 defendant Skyrmour John weaver 654209 654209 Skyrmour, John, of Cirencester, Gloucs, weaver 0
4729619 2274476 2274476 defendant Draper William draper 654209 654209 Draper, William, of Cirencester, Gloucs, draper 2
4730398 2274705 2274705 defendant Draper William chapman 654209 654209 Draper, William, of Cirencester, Gloucs, chapman 4
4731895 2275157 2275157 plaintiff Northcote Henry mercer 654209 654209 Northcote, Henry, of Cirencester, Gloucs, mercer 0
4734041 2275831 2275831 defendant Draper John   654209 654209 Draper, John, of Cirencester, Gloucs, wool buyer 0
4738082 2277014 2277014 defendant Tyrell John   654209 654209 Tyrell, John, of Cirencester, Gloucs, glove maker 0
4740936 2277858 2277858 defendant Lourere John   654209 654209 Lourere, John, of Cirencester, Gloucs, furbour 1
4742556 2278323 2278323 defendant Tyrell John glover 654209 654209 Tyrell, John, of Cirencester, Gloucs, glover 0
4742872 2278424 2278424 defendant Horneby William beltmaker 654209 654209 Horneby, William, of Cirencester, Gloucs, beltmaker 2
4748285 2280007 2280007 defendant Browne Thomas husbandman 654209 654209 Browne, Thomas, of Cirencester, Gloucs, husbandman 1
4749418 2280310 2280310 defendant Welynes John chapman 654209 654209 Welynes, John, of Cirencester, Gloucs, chapman 0
4751729 2280993 2280993 defendant Drapere William merchant 654209 654209 Drapere, William, of Cirencester, Gloucs, merchant 0
4751732 2280994 2280994 defendant Drape William draper 654209 654209 Drape, William, of Cirencester, Gloucs, draper 1
4752463 2281182 2281182 defendant Lonekyn or Lovekyn John tanner 654209 654209 Lonekyn or Lovekyn, John, of Cirencester, Gloucs, tanner 1
4753510 2281477 2281477 plaintiff Warner William   654209 654209 Warner, William, of Cirencester, Gloucs, on his own account 0
4760119 2283510 2283510 defendant Draper William husbandman 654209 654209 Draper, William, of Cirencester, Gloucs, husbandman 0
4760421 2283610 2283610 defendant Hobbus Andrew butcher 654209 654209 Hobbus, Andrew, of Cirencester, Gloucs, butcher 0
4761587 2283968 2283968 defendant Draper William draper 654209 654209 Draper, William, of Cirencester, Gloucs, draper 3
4762086 2284127 2284127 defendant Doughton John husbandman 654209 654209 Doughton, John, of Cirencester, Gloucs, husbandman 0
4762905 2284380 2284380 defendant Drapur William merchant 654209 654209 Drapur, William, of Cirencester, Gloucs, merchant 0
4802907 2297096 2297096 defendant Grene John chapman 654209 654209 (Grene, John, of Cirencester, Gloucs, chapman 1
4802913 2297097 2297097 defendant Grene John chapman 654209 654209 (Grene, John, of Cirencester, Gloucs, chapman 1
4804118 2297477 2297477 defendant Carpenter David carpenter 654209 654209 Carpenter, David, of Cirencester, Gloucs, carpenter 1
4804124 2297478 2297478 defendant Carpenter David carpenter 654209 654209 Carpenter, David, of Cirencester, Gloucs, carpenter 1
4808645 2298868 2298868 defendant Steneyate Richard weaver 654209 654209 Steneyate, Richard, of Cirencester, Gloucs, weaver 0
4816505 2301254 2301254 defendant Cabull John chapman 654209 654209 Cabull, John, of Cirencester, Gloucs, chapman 1
4825824 2304112 2304112 defendant Duke John husbandman 654209 654209 Duke, John, of Cirencester, Gloucs, husbandman 0
4826313 2304266 2304266 defendant Sareney John draper 654209 654209 Sareney, John, of Cirencester, Gloucs, draper 0
4832051 2306055 2306055 defendant Lyde John chapman 654209 654209 Lyde, John, of Cirencester, Gloucs, chapman 2
4838158 2307857 2307857 defendant Malmeshull John yeoman 654209 654209 Malmeshull, John, of Cirencester, Gloucs, yeoman 0
4838165 2307860 2307860 defendant Malmeshull John yeoman 654209 654209 Malmeshull, John, of Cirencester, Gloucs, yeoman 0
4839189 2308185 2308185 defendant Luyde John fishmonger 654209 654209 Luyde, John, of Cirencester, Gloucs, fishmonger 2
4852563 2312224 2312224 defendant Lynche Henry dyer 654209 654209 Lynche, Henry, of Cirencester, Gloucs, dyer 0
4911347 2330052 2330052 defendant Robyns Roger weaver 654209 654209 Robyns, Roger, of Cirencester, Gloucs, weaver 1
4911350 2330053 2330053 defendant Robyns Roger weaver 654209 654209 Robyns, Roger, of Cirencester, Gloucs, weaver 1
4912126 2330294 2330294 defendant Andrewe Robert (legal representative) 654209 654209 Andrewe, Robert, of Cirencester, Gloucs, tanner, executors of 0
4930419 2335915 2335915 defendant Powle William weaver 654209 654209 Powle, William, of Cirencester, Gloucs, weaver 0
4988092 2353412 2353412 defendant Ebbesham William gent 654209 654209 (Ebbesham, William, of Cirencester, Gloucs, gent 1
4990880 2354164 2354164 defendant Howell David   654209 654209 Howell, David, of Cirencester, Gloucs, merchant, alias of Wales 1
4990950 2354183 2354183 defendant Howell David   654209 654209 Howell, David, of Cirencester, Gloucs, merchant, alias of Wales 1
4993298 2354869 2354869 defendant Austyn John chapman 654209 654209 Austyn, John, of Cirencester, Gloucs, chapman 1
4994773 2355293 2355293 defendant Prelat William gent 654209 654209 Prelat, William, of Cirencester, Gloucs, gent 2
4997749 2356183 2356183 plaintiff Hopton Hugh chapman 654209 654209 Hopton, Hugh, of Cirencester, Gloucs, chapman 0
5001137 2357209 2357209 defendant Austyn John chapman 654209 654209 Austyn, John, of Cirencester, Gloucs, chapman 2
5003434 2357901 2357901 defendant Austyn John chapman 654209 654209 Austyn, John, of Cirencester, Gloucs, chapman 1
5008509 2359385 2359385 defendant Austyn John chapman 654209 654209 Austyn, John, of Cirencester, Gloucs, chapman 0
5008714 2359440 2359440 defendant austyn John chapman 654209 654209 austyn, John, of Cirencester, Gloucs, chapman 1
5128332 2394765 2394765 defendant Chilton John chapman 654209 654209 Chilton, John, of Cirencester, Gloucs, chapman 0
5129901 2395233 2395233 defendant Keke Geoffrey weaver 654209 654209 Keke, Geoffrey, of Cirencester, Gloucs, weaver 0
5136271 2397126 2397126 defendant Mose Thomas weaver 654209 654209 Mose, Thomas, of Cirencester, Gloucs, weaver 1
5141907 2398753 2398753 defendant Prelatte William gent 654209 654209 Prelatte, William, of Cirencester, Gloucs, gent 0
5145263 2399755 2399755 defendant Fourbour Robert furbisher 654209 654209 Fourbour, Robert, of Cirencester, Gloucs, furbisher 0
5146124 2399993 2399993 defendant Smale Robert chaplain 654209 654209 Smale, Robert, of Cirencester, Gloucs, chaplain 0
5147426 2400395 2400395 defendant Chilton John chapman 654209 654209 Chilton, John, of Cirencester, Gloucs, chapman 0
5147430 2400396 2400396 defendant Chylton Johne chapman 654209 654209 Chylton, Johne, of Cirencester, Gloucs, chapman 0
5149139 2400877 2400877 defendant Keke Geoffrey weaver 654209 654209 Keke, Geoffrey, of Cirencester, Gloucs, weaver 0
5156630 2403093 2403093 defendant Mose Thomas weaver 654209 654209 Mose, Thomas, of Cirencester, Gloucs, weaver 1
5162984 2404902 2404902 defendant Prelate William gent 654209 654209 Prelate, William, of Cirencester, Gloucs, gent 0
5165383 2405623 2405623 defendant Keke Geoffrey weaver 654209 654209 Keke, Geoffrey, of Cirencester, Gloucs, weaver 0
5167138 2406123 2406123 defendant Chilton John chapman 654209 654209 Chilton, John, of Cirencester, Gloucs, chapman 0
5172377 2407646 2407646 defendant Maynard William   654209 654209 Maynard, William, of Cirencester, Gloucs, cloth man 0
5172765 2407764 2407764 defendant Mose Thomas weaver 654209 654209 Mose, Thomas, of Cirencester, Gloucs, weaver 1
5172768 2407765 2407765 defendant Hues Stephen butcher 654209 654209 Hues, Stephen, of Cirencester, Gloucs, butcher 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);