names

116 rows where place_id = 601726

✎ 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
3646722 1909375 1909375 defendant Wynsham Walter husbandman 601726 601726 Wynsham, Walter, of Ottery St Mary, husbandman 0
3691883 1923621 1923621 defendant Trent John dyer 601726 601726 Trent, John, of Ottery St Mary, dyer 0
3797152 1956993 1956993 defendant Tyce Mathew courser 601726 601726 Tyce, Mathew, of Ottery St Mary, courser 0
3914701 1995262 1995262 defendant Roper John clerk 601726 601726 Roper, John, of Ottery St Mary, clerk 0
3931891 2000966 2000966 defendant Curham William gent 601726 601726 Curham, William, of Ottery St Mary, gent 0
3936771 2002626 2002626 defendant Coke William gent 601726 601726 Coke, William, of Ottery St Mary, gent 0
3937472 2002869 2002869 defendant Mercer Hugh weaver 601726 601726 Mercer, Hugh, of Ottery St Mary, weaver 0
3939615 2003556 2003556 defendant Crone John husbandman 601726 601726 Crone, John, of Ottery St Mary, husbandman 0
3939616 2003556 2003556 defendant Oxe Thomas weaver 601726 601726 Oxe, Thomas, of Ottery St Mary, weaver 1
3941998 2004333 2004333 defendant Wynter John dyer 601726 601726 Wynter, John, of Ottery St Mary, dyer 0
3941999 2004333 2004333 defendant Adaham Peter butcher 601726 601726 Adaham, Peter, of Ottery St Mary, butcher 1
3947471 2006188 2006188 defendant Batte John, senior husbandman 601726 601726 Batte, John, senior, of Ottery St Mary, husbandman 0
3961515 2011127 2011127 defendant Collyn Thomas smith 601726 601726 Collyn, Thomas, of Ottery St Mary, smith 0
3965246 2012457 2012457 defendant Wheton John laborer 601726 601726 Wheton, John, of Ottery St Mary, laborer 0
4011614 2028899 2028899 defendant Bodbere William   601726 601726 Bodbere, William, of Ottery St Mary 1
4011615 2028899 2028899 defendant Gale John husbandman 601726 601726 Gale, John, of Ottery St Mary, husbandman 2
4025932 2033924 2033924 defendant England John husbandman 601726 601726 England, John, of Ottery St Mary, husbandman 0
4025933 2033924 2033924 defendant Godbeare William husbandman 601726 601726 Godbeare, William, of Ottery St Mary, husbandman 1
4070165 2049620 2049620 defendant Barrett Geoffrey shoemaker 601726 601726 Barrett, Geoffrey, of Ottery St Mary, shoemaker 0
4070166 2049620 2049620 defendant Leight Hugh   601726 601726 Leight, Hugh, of Ottery St Mary, bottle maker 1
4176945 2087410 2087410 defendant Stone William carpenter 601726 601726 Stone, William, of Ottery St Mary, carpenter 0
4378686 2157449 2157449 defendant Courtney Roger gent 601726 601726 Courtney, Roger, of Ottery St mary, gent 0
4380312 2158062 2158062 defendant Channon John yeoman 601726 601726 Channon, John, of Ottery St Mary, yeoman 2
4535464 2211362 2211362 plaintiff Slade William (legal representative) 601726 601726 Slade, William, of Ottery St Mary, warden of the collegiate church, administrator of 0
4541766 2213319 2213319 defendant Slade William   601726 601726 Slade, William, of Ottery St Mary, warden of the collegiate church, administrators of 0
4591616 2228735 2228735 defendant Cook Henry   601726 601726 Cook, Henry, of Ottery St Mary 4
4591617 2228735 2228735 defendant Cook Richard   601726 601726 Cook, Richard, of Ottery St Mary 5
4617078 2236349 2236349 defendant atte Were William   601726 601726 atte Were, William, of Ottery St Mary 0
4619989 2237232 2237232 defendant Shepherd John   601726 601726 Shepherd, John, of Ottery St Mary 0
4688230 2261887 2261887 defendant Mone or Move John husbandman 601726 601726 Mone or Move, John, of Ottery St Mary, husbandman 0
4699081 2265181 2265181 defendant Balkeborn Henry clerk 601726 601726 Balkeborn, Henry, of Ottery St Mary, clerk 0
4699662 2265346 2265346 defendant Lowe John husbandman 601726 601726 Lowe, John, of Ottery St Mary, husbandman 0
4711687 2268978 2268978 plaintiff Sarger John   601726 601726 Sarger, John, of Ottery St Mary, warden of the collegiate church 0
4724018 2272810 2272810 defendant Lowe John husbandman 601726 601726 Lowe, John, of Ottery St Mary, husbandman 0
4724020 2272811 2272811 defendant Lowe John husbandman 601726 601726 Lowe, John, of Ottery St Mary, husbandman 0
4727663 2273894 2273894 defendant Segour Thomas husbandman 601726 601726 Segour, Thomas, of Ottery St Mary, husbandman 0
4736915 2276674 2276674 defendant Cook John tanner 601726 601726 Cook, John, of Ottery St Mary, tanner 0
4752783 2281270 2281270 defendant Cook John tanner 601726 601726 Cook, John, of Ottery St Mary, tanner 0
4756211 2282318 2282318 defendant Trende John husbandman 601726 601726 Trende, John, of Ottery St Mary, husbandman 1
4760185 2283535 2283535 plaintiff Cooke John   601726 601726 Cooke, John, of Ottery St Mary 0
4760187 2283536 2283536 plaintiff Cooke John   601726 601726 Cooke, John, of Ottery St Mary 0
4761551 2283957 2283957 defendant Lowe John   601726 601726 Lowe, John, of Ottery St Mary, mason 0
4769716 2286501 2286501 defendant Hawell Thomas laborer 601726 601726 Hawell, Thomas, of Ottery St Mary, laborer 1
4774007 2287853 2287853 defendant Barlebyn John husbandman 601726 601726 Barlebyn, John, of Ottery St Mary, husbandman 1
4775018 2288183 2288183 defendant Cook John tanner 601726 601726 Cook, John, of Ottery St Mary, tanner 0
4775019 2288183 2288183 defendant Cadehay Henry husbandman 601726 601726 Cadehay, Henry, of Ottery St Mary, husbandman 1
4803806 2297370 2297370 defendant Holbem Nicholas   601726 601726 Holbem, Nicholas, of Ottery St Mary, bailiff 1
4814131 2300520 2300520 defendant Adam Henry husbandman 601726 601726 Adam, Henry, of Ottery St Mary, husbandman 0
4820075 2302356 2302356 defendant Foulhill Thomas gent 601726 601726 Foulhill, Thomas, of Ottery St Mary, gent 0
4820077 2302357 2302357 defendant Foulhill Thomas gent 601726 601726 Foulhill, Thomas, of Ottery St Mary, gent 0
4827484 2304645 2304645 defendant Boll or Bell Henry husbandman 601726 601726 Boll or Bell, Henry, of Ottery St Mary, husbandman 0
4837363 2307625 2307625 defendant Foulehill Thomas gent 601726 601726 Foulehill, Thomas, of Ottery St Mary, gent 1
4848058 2310859 2310859 plaintiff Sarger John   601726 601726 Sarger, John, of Ottery St Mary, warden of the collegiate church 0
4909332 2329460 2329460 defendant Hayes Robert shoemaker 601726 601726 Hayes, Robert, of Ottery St Mary, shoemaker 1
4909340 2329461 2329461 defendant Mone or Move Thomas laborer 601726 601726 Mone or Move, Thomas, of Ottery St Mary, laborer 3
4912544 2330425 2330425 defendant Coke Geoffrey   601726 601726 Coke, Geoffrey, of Ottery St Mary, "fissheionter" 0
4912545 2330425 2330425 defendant Ayssh John fuller 601726 601726 Ayssh, John, of Ottery St Mary, fuller 1
4916644 2331716 2331716 defendant Baker alias Dyer Henry dyer 601726 601726 Baker alias Dyer, Henry, of Ottery St Mary, dyer 0
4926510 2334709 2334709 defendant Taylewre William chapman 601726 601726 Taylewre, William, of Ottery St Mary, chapman 2
4929435 2335624 2335624 defendant Pounde Geoffrey butcher 601726 601726 Pounde, Geoffrey, of Ottery St Mary, butcher 2
4932116 2336441 2336441 plaintiff Wenman Geoffrey   601726 601726 Wenman, Geoffrey, of Ottery St Mary 0
4998318 2356368 2356368 defendant Cooke Henry tanner 601726 601726 Cooke, Henry, of Ottery St Mary, tanner 0
5000564 2357035 2357035 defendant Bancombe John clerk 601726 601726 Bancombe, John, of Ottery St Mary, clerk 0
5000571 2357038 2357038 defendant Bancombe John clerk 601726 601726 Bancombe, John, of Ottery St Mary, clerk 0
5004673 2358270 2358270 defendant Aunger Henry husbandman 601726 601726 Aunger, Henry, of Ottery St Mary, husbandman 0
5006612 2358833 2358833 plaintiff Sherman William (legal representative) 601726 601726 Sherman, William, of Ottery St Mary, executrix of 0
5011056 2360089 2360089 defendant Bittelisgate Thomas gent 601726 601726 Bittelisgate, Thomas, of Ottery St Mary, gent 0
5011438 2360211 2360211 defendant Bancombe John clerk 601726 601726 Bancombe, John, of Ottery St Mary, clerk 0
5139264 2397973 2397973 defendant Rolond Richard smith 601726 601726 Rolond, Richard, of Ottery St Mary, smith 1
5159706 2403942 2403942 defendant Shepehurde Richard tanner 601726 601726 Shepehurde, Richard, of Ottery St Mary, tanner 0
5160201 2404079 2404079 defendant Roland Richard smith 601726 601726 Roland, Richard, of Ottery St Mary, smith 1
5161184 2404372 2404372 defendant Spyne John gent 601726 601726 Spyne, John, of Ottery St Mary, gent 0
5162030 2404629 2404629 defendant Baker John yeoman 601726 601726 Baker, John, of Ottery St Mary, yeoman 0
5167557 2406239 2406239 defendant Somer William husbandman 601726 601726 Somer, William, of Ottery St Mary, husbandman 0
5167558 2406239 2406239 defendant Maior Ellis   601726 601726 Maior, Ellis, of Ottery St Mary, groom 1
5167559 2406239 2406239 defendant Slade John   601726 601726 Slade, John, of Ottery St Mary, groom 2
5167561 2406239 2406239 defendant Baker Henry husbandman 601726 601726 together with Baker, Henry, of Ottery St Mary, husbandman 4
5170344 2407056 2407056 defendant Scorche John husbandman 601726 601726 Scorche, John, of Ottery St Mary, husbandman 1
5170345 2407056 2407056 defendant Robyn Robert tailor 601726 601726 Robyn, Robert, of Ottery St Mary, tailor 2
5170351 2407056 2407056 defendant Salter John weaver 601726 601726 Salter, John, of Ottery St Mary, weaver 8
5175054 2408397 2408397 defendant Rolond Richard smith 601726 601726 Rolond, Richard, of Ottery St Mary, smith 1
5175651 2408566 2408566 defendant Spyne John gent 601726 601726 Spyne, John, of Ottery St Mary, gent 0
5178925 2409565 2409565 defendant Spene John husbandman 601726 601726 Spene, John, of Ottery St Mary, husbandman 0
5195743 2414499 2414499 defendant Englond Thomas yeoman 601726 601726 Englond, Thomas, of Ottery St Mary, yeoman 0
5196060 2414595 2414595 defendant Rolond Richard smith 601726 601726 Rolond, Richard, of Ottery St Mary, smith 1
5201671 2416257 2416257 defendant Spene John husbandman 601726 601726 Spene, John, of Ottery St Mary, husbandman 0
5209375 2418479 2418479 defendant Engelond Thomas yeoman 601726 601726 Engelond, Thomas, of Ottery St Mary, yeoman 0
5300425 2445085 2445085 defendant Bastard Thomas yeoman 601726 601726 Bastard, Thomas, of Ottery St Mary, yeoman 0
5366650 2465220 2465220 defendant Hurne John dyer 601726 601726 Hurne, John, of Ottery St Mary, dyer 0
5369991 2466204 2466204 defendant Benet John tailor 601726 601726 Benet, John, of Ottery St Mary, tailor 0
5374255 2467547 2467547 defendant Dollyng William dyer 601726 601726 Dollyng, William, of Ottery St Mary, dyer 3
5375564 2467947 2467947 plaintiff Ralegh Philip merchant 601726 601726 Ralegh, Philip, of Ottery St Mary, merchant 0
5376599 2468279 2468279 defendant Dollyng William dyer 601726 601726 Dollyng, William, of Ottery St Mary, dyer 2
5377625 2468584 2468584 defendant Wenman Thomas   601726 601726 Wenman, Thomas, of Ottery St Mary 0
5386142 2471104 2471104 defendant Stephyn John yeoman 601726 601726 Stephyn, John, of Ottery St Mary, yeoman 0
5405874 2476753 2476753 defendant Tremayn John toker 601726 601726 Tremayn, John, of Ottery St Mary, toker 1
5405876 2476753 2476753 defendant Dollyng William dyer 601726 601726 Dollyng, William, of Ottery St Mary, dyer 3
5422920 2481810 2481810 defendant Slade Thomas husbandman 601726 601726 Slade, Thomas, of Ottery St Mary, husbandman 0
5435682 2485609 2485609 defendant Trygge John smith 601726 601726 Trygge, John, of Ottery St Mary, smith 1
5437002 2486002 2486002 defendant Burcombe Thomasina widow 601726 601726 Burcombe, Thomasina, of Ottery St Mary, widow 2

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