names

106 rows where place_id = 591028

✎ 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
3603091 1868632 1868632 defendant Lane Peter husbandman 591028 591028 Lane, Peter, of Crediton, husbandman 0
3611118 1871152 1871152 defendant Dourysshe Thomas gent 591028 591028 Dourysshe, Thomas, of Crediton, gent 0
3612481 1871536 1871536 defendant Corun Robert glover 591028 591028 Corun, Robert, of Crediton, glover 0
3612487 1871539 1871539 defendant Cayleway Richard weaver 591028 591028 Cayleway, Richard, of Crediton, weaver 0
3643350 1908345 1908345 defendant Gregson Edward clerk 591028 591028 Gregson, Edward, of Crediton, clerk 0
3649940 1910348 1910348 defendant Estbroke Ralph butcher 591028 591028 Estbroke, Ralph, of Crediton, butcher 0
3649941 1910348 1910348 defendant Rocher Richard butcher 591028 591028 Rocher, Richard, of Crediton, butcher 1
3649942 1910348 1910348 defendant Paunceford Margery widow 591028 591028 Paunceford, Margery, of Crediton, widow 2
3649943 1910348 1910348 defendant Howell Hugh tucker 591028 591028 Howell, Hugh, of Crediton, tucker 3
3686912 1922071 1922071 defendant Bysshopp Henry (legal representative) 591028 591028 Bysshopp, Henry, of Crediton, executors of 0
3714679 1930889 1930889 plaintiff Bodlegh John, senior   591028 591028 Bodlegh, John, senior, of Crediton 0
3714681 1930889 1930889 defendant Helyer John, junior weaver 591028 591028 Helyer, John, junior, of Crediton, weaver 1
3816236 1962986 1962986 defendant Hoke Robert weaver 591028 591028 Hoke, Robert, of Crediton, weaver 0
3978354 2017014 2017014 defendant Delve Peter husbandman 591028 591028 Delve, Peter, of Crediton, husbandman 1
4013152 2029435 2029435 defendant Whyte John husbandman 591028 591028 Whyte, John, of Crediton, husbandman 1
4013153 2029435 2029435 defendant Delve Walter husbandman 591028 591028 Delve, Walter, of Crediton, husbandman 2
4025093 2033635 2033635 plaintiff Bradmeade Gilbert yeoman 591028 591028 Bradmeade, Gilbert, of Crediton, yeoman 0
4025095 2033636 2033636 plaintiff Bradmede Gilbert yeoman 591028 591028 Bradmede, Gilbert, of Crediton, yeoman 0
4028692 2034913 2034913 defendant Kingwell William yeoman 591028 591028 Kingwell, William, of Crediton, yeoman 0
4035035 2037212 2037212 defendant Seldon Richard barber 591028 591028 Seldon, Richard, of Crediton, barber 1
4038634 2038456 2038456 defendant Kingewell William huasbandman 591028 591028 Kingewell, William, of Crediton, huasbandman 0
4038636 2038457 2038457 defendant Trewman William husbandman 591028 591028 Trewman, William, of Crediton, husbandman 0
4040852 2039218 2039218 defendant Kingwell William yeoman 591028 591028 Kingwell, William, of Crediton, yeoman 1
4045010 2040671 2040671 plaintiff Rondell John victualer 591028 591028 Rondell, John, of Crediton, victualer 0
4054355 2043948 2043948 defendant Kyngwell John husbandman 591028 591028 Kyngwell, John, of Crediton, husbandman 0
4056095 2044568 2044568 defendant Lane Richard tanner 591028 591028 Lane, Richard, of Crediton, tanner 0
4056129 2044581 2044581 defendant Lane Richard tanner 591028 591028 Lane, Richard, of Crediton, tanner 0
4071166 2049992 2049992 defendant Delve Robert yeoman 591028 591028 Delve, Robert, of Crediton, yeoman 1
4082009 2053867 2053867 defendant Delve Walter husbandman 591028 591028 Delve, Walter, of Crediton, husbandman 0
4082010 2053867 2053867 defendant Delve Peter husbandman 591028 591028 Delve, Peter, of Crediton, husbandman 1
4092291 2057543 2057543 defendant Lobdon John, junior   591028 591028 Lobdon, John, junior, of Crediton, husbandman, son of John Lobdon 0
4104743 2061974 2061974 defendant Delve Walter husbandman 591028 591028 Delve, Walter, of Crediton, husbandman 3
4131564 2071608 2071608 defendant Wade Philip baker 591028 591028 Wade, Philip, of Crediton, baker 0
4131565 2071608 2071608 defendant Gullocke John husbandman 591028 591028 Gullocke, John, of Crediton, husbandman 1
4178773 2088052 2088052 defendant Grauntland Henry husbandman 591028 591028 Grauntland, Henry, of Crediton, husbandman 3
4215707 2100991 2100991 defendant Atwill Gilbert gent 591028 591028 Atwill, Gilbert, of Crediton, gent 1
4291787 2127137 2127137 defendant Baker alias Nylde Thomas yeoman 591028 591028 Baker alias Nylde, Thomas, of Crediton, yeoman 2
4323893 2138402 2138402 defendant Kyngewell Mathew weaver 591028 591028 Kyngewell, Mathew, of Crediton, weaver 0
4323894 2138402 2138402 defendant Preston Roger husbandman 591028 591028 Preston, Roger, of Crediton, husbandman 1
4326626 2139265 2139265 defendant Kenell Robert husbandman 591028 591028 Kenell, Robert, of Crediton, husbandman 1
4378168 2157257 2157257 defendant Wade alias Baker Thomas baker 591028 591028 Wade alias Baker, Thomas, of Crediton, baker 0
4483615 2195566 2195566 defendant Revell John   591028 591028 Revell, John, of Crediton 0
4524255 2207921 2207921 defendant Reve Alice   591028 591028 Reve, Alice, of Crediton, formerly wife of Richard 2
4528677 2209250 2209250 defendant Sherman David   591028 591028 Sherman, David, of Crediton 0
4551856 2216527 2216527 defendant Carpenter William   591028 591028 Carpenter, William, of Crediton 1
4558157 2218492 2218492 plaintiff Lodys William (legal representative) 591028 591028 Lodys, William, of Crediton, prebendary of Holy Cross college & church, executors of 0
4558160 2218492 2218492 defendant Hody William   591028 591028 Hody, William, of Crediton 0
4590795 2228473 2228473 defendant Hoghe Walter   591028 591028 Hoghe, Walter, of Crediton 1
4651567 2246488 2246488 defendant Spynkhull Nicholas   591028 591028 Spynkhull, Nicholas, of Crediton, bailiff 12
4678170 2258780 2258780 defendant Anvelmaker John smith 591028 591028 with Anvelmaker, John, of Crediton, smith 1
4697410 2264677 2264677 defendant Blakhay Roger chaplain 591028 591028 Blakhay, Roger, of Crediton, chaplain 1
4697411 2264677 2264677 defendant Spynell Nicholas yeoman 591028 591028 Spynell, Nicholas, of Crediton, yeoman 2
4697412 2264677 2264677 defendant Sture William   591028 591028 Sture, William, of Crediton, shoe maker 3
4702401 2266163 2266163 defendant Lobbedon William chapman 591028 591028 Lobbedon, William, of Crediton, chapman 0
4702403 2266163 2266163 defendant Hanberygge William husbandman 591028 591028 Hanberygge, William, of Crediton, husbandman 2
4716073 2270334 2270334 defendant Dyer Simon dyer 591028 591028 Dyer, Simon, of Crediton, dyer 0
4721900 2272181 2272181 defendant Smyth John   591028 591028 Smyth, John, of Crediton, iron worker 0
4726453 2273554 2273554 defendant Smale John tailor 591028 591028 Smale, John, of Crediton, tailor 4
4728300 2274096 2274096 defendant Gay Walter husbandman 591028 591028 Gay, Walter, of Crediton, husbandman 0
4730810 2274837 2274837 defendant Brere Hugh butcher 591028 591028 Brere, Hugh, of Crediton, butcher 0
4730834 2274843 2274843 defendant Thomas John smith 591028 591028 Thomas, John, of Crediton, smith 2
4736533 2276556 2276556 defendant Hurste Walter draper 591028 591028 Hurste, Walter, of Crediton, draper 0
4846860 2310523 2310523 defendant Bryan Robert butcher 591028 591028 Bryan, Robert, of Crediton, butcher 3
4908513 2329217 2329217 defendant Brok Philip chaplain 591028 591028 Brok, Philip, of Crediton, chaplain 0
4910693 2329853 2329853 defendant Huntyngdon John   591028 591028 Huntyngdon, John, of Crediton, warden of the church & chapel of St Lawrence 1
4912236 2330328 2330328 defendant Dokcombe William smith 591028 591028 Dokcombe, William, of Crediton, smith 2
4996294 2355751 2355751 plaintiff Haddon John merchant 591028 591028 Haddon, John, of Crediton, merchant 0
5208879 2418320 2418320 defendant Raymond John yeoman 591028 591028 Raymond, John, of Crediton, yeoman 2
5209683 2418572 2418572 defendant Davy Thomas baker 591028 591028 Davy, Thomas, of Crediton, baker 0
5209684 2418572 2418572 defendant Wynterburne William baker 591028 591028 Wynterburne, William, of Crediton, baker 1
5237943 2426685 2426685 defendant Mounston William butcher 591028 591028 Mounston, William, of Crediton, butcher 1
5268619 2435942 2435942 defendant Laxby Thomas husbandman 591028 591028 Laxby, Thomas, of Crediton, husbandman 0
5276252 2438122 2438122 defendant Cineme Lawrence   591028 591028 Cineme, Lawrence, of Crediton, brass worker 0
5310487 2448173 2448173 plaintiff Walron John   591028 591028 Walron, John, of Crediton 0
5370400 2466328 2466328 defendant Cornewe William smith 591028 591028 Cornewe, William, of Crediton, smith 2
5383248 2470285 2470285 defendant Lyndesey Alexander   591028 591028 Lyndesey, Alexander, of Crediton 0
5383249 2470285 2470285 defendant Stevyn Henry husbandman 591028 591028 Stevyn, Henry, of Crediton, husbandman 1
5383251 2470285 2470285 defendant Geffrey John tailor 591028 591028 Geffrey, John, of Crediton, tailor 3
5405718 2476709 2476709 defendant Geffray John tailor 591028 591028 Geffray, John, of Crediton, tailor 4
5409088 2477684 2477684 defendant Holdeasshe Richard laborer 591028 591028 Holdeasshe, Richard, of Crediton, laborer 3
5420929 2481188 2481188 defendant Geffray John tailor 591028 591028 Geffray, John, of Crediton, tailor 4
5422499 2481675 2481675 defendant Holdeasshe Richard laborer 591028 591028 Holdeasshe, Richard, of Crediton, laborer 3
5422504 2481676 2481676 defendant Holdeasshe Richard laborer 591028 591028 Holdeasshe, Richard, of Crediton, laborer 3
5422509 2481677 2481677 defendant Choldeasshe Richard laborer 591028 591028 Choldeasshe, Richard, of Crediton, laborer 3
5424951 2482428 2482428 defendant Choldesasshe Richard laborer 591028 591028 Choldesasshe, Richard, of Crediton, laborer 3
5426161 2482778 2482778 defendant Dyer Giles tailor 591028 591028 Dyer, Giles, of Crediton, tailor 2
5440724 2487134 2487134 defendant Geffrey John tailor 591028 591028 Geffrey, John, of Crediton, tailor 3
5444928 2488366 2488366 defendant Sampson John yeoman 591028 591028 Sampson, John, of Crediton, yeoman 1
5445350 2488507 2488507 defendant Lethe John smith 591028 591028 Lethe, John, of Crediton, smith 1
5469444 2495784 2495784 defendant Sampson John yeoman 591028 591028 Sampson, John, of Crediton, yeoman 1
5477722 2498356 2498356 defendant Forlonge Henry smith 591028 591028 Forlonge, Henry, of Crediton, smith 0
5478929 2498719 2498719 defendant Jacob John husbandman 591028 591028 Jacob, John, of Crediton, husbandman 3
5478930 2498719 2498719 defendant Jacob Thomas weaver 591028 591028 Jacob, Thomas, of Crediton, weaver 4
5478931 2498719 2498719 defendant Basse Thomas laborer 591028 591028 Basse, Thomas, of Crediton, laborer 5
5480631 2499169 2499169 defendant Sampson John yeoman 591028 591028 Sampson, John, of Crediton, yeoman 1
5482778 2499795 2499795 defendant Forlonge Henry smith 591028 591028 Forlonge, Henry, of Crediton, smith 0
5485139 2500476 2500476 defendant Byrche Richard mercer 591028 591028 Byrche, Richard, of Crediton, mercer 0
5486474 2500846 2500846 defendant Lane Peter mercer 591028 591028 Lane, Peter, of Crediton, mercer 0
5498952 2504622 2504622 defendant Colbeare Stephen baker 591028 591028 Colbeare, Stephen, of Crediton, baker 1
5509241 2507747 2507747 defendant Arter Henry smith 591028 591028 Arter, Henry, of Crediton, smith 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);