names

232 rows where place_id = 587224

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590813 1864765 1864765 defendant Hoker John yeoman 587224 587224 Hoker, John, of Otery St Mary, yeoman 0
3590819 1864766 1864766 defendant Sherman William dyer 587224 587224 (Sherman, William, of Otery St Mary, dyer 1
3592112 1865149 1865149 defendant Stevyns John yeoman 587224 587224 Stevyns, John, of Otery St Mary, yeoman 0
3594936 1866044 1866044 defendant Lomyn Alexander glover 587224 587224 Lomyn, Alexander, of Otery St Mary, glover 0
3596582 1866565 1866565 defendant Carpenter alias Forest Richard cordwainer 587224 587224 Carpenter alias Forest, Richard, of Otery St Mary, cordwainer 0
3597384 1866803 1866803 defendant Vantard or Vautard William gent 587224 587224 Vantard or Vautard, William, of Otery St Mary, gent 0
3599211 1867395 1867395 defendant Hillyng William yeoman 587224 587224 Hillyng, William, of Otery St Mary, yeoman 0
3599212 1867395 1867395 defendant Pepyr William tailor 587224 587224 Pepyr, William, of Otery St Mary, tailor 1
3599213 1867395 1867395 defendant Hillyng Charles baker 587224 587224 Hillyng, Charles, of Otery St Mary, baker 2
3599214 1867395 1867395 defendant Cullyng John laborer 587224 587224 Cullyng, John, of Otery St Mary, laborer 3
3599215 1867395 1867395 defendant Wade Thomas yeoman 587224 587224 Wade, Thomas, of Otery St Mary, yeoman 4
3599216 1867395 1867395 defendant Smale Thomas laborer 587224 587224 Smale, Thomas, of Otery St Mary, laborer 5
3609443 1870618 1870618 defendant Stoweford Philip yeoman 587224 587224 Stoweford, Philip, of Otery St Mary, yeoman 0
3613757 1871955 1871955 defendant Chanon John merchant 587224 587224 Chanon, John, of Otery St Mary, merchant 0
3618453 1873399 1873399 defendant benet John gent 587224 587224 benet, John, of Otery St Mary, gent 2
3619944 1873812 1873812 defendant Hacche John husbandman 587224 587224 Hacche, John, of Otery St Mary, husbandman 0
3619946 1873813 1873813 defendant Hacche John husbandman 587224 587224 Hacche, John, of Otery St Mary, husbandman 0
3627349 1903404 1903404 defendant Dunrygge John tucker 587224 587224 Dunrygge, John, of Otery St Mary, tucker 0
3650133 1910411 1910411 defendant Castell Nicholas mercer 587224 587224 Castell, Nicholas, of Otery St Mary, mercer 1
3652823 1911207 1911207 defendant Saunder John butcher 587224 587224 Saunder, John, of Otery St Mary, butcher 0
3670971 1916892 1916892 defendant Raly John yeoman 587224 587224 Raly, John, of Otery St Mary, yeoman 0
3686045 1921795 1921795 defendant Shurman William clothier 587224 587224 Shurman, William, of Otery St Mary, clothier 1
3689840 1922982 1922982 defendant Coke John gent 587224 587224 Coke, John, of Otery St Mary, gent 0
3689841 1922982 1922982 defendant Alyn Willliam   587224 587224 Alyn, Willliam, of Otery St Mary, groom 1
3689842 1922982 1922982 defendant Borough John husbandman 587224 587224 Borough, John, of Otery St Mary, husbandman 2
3691849 1923612 1923612 defendant Style James husbandman 587224 587224 Style, James, of Otery St Mary, husbandman 0
3691850 1923612 1923612 defendant Taillor Michael husbandman 587224 587224 Taillor, Michael, of Otery St Mary, husbandman 1
3695282 1924745 1924745 defendant Hone Robert dyer 587224 587224 Hone, Robert, of Otery St Mary, dyer 0
3762863 1946022 1946022 defendant Marshall Thomas   587224 587224 Marshall, Thomas, of Otery St Mary, groom 1
3765393 1946837 1946837 defendant More John (legal representative) 587224 587224 More, John, of Otery St Mary, gent, executrix of 0
3765394 1946837 1946837 defendant More Joan widow 587224 587224 More, Joan, of Otery St Mary, widow 1
3769165 1948013 1948013 defendant Sherman John dyer 587224 587224 Sherman, John, of Otery St Mary, dyer 0
3769167 1948014 1948014 defendant Style James miller 587224 587224 Style, James, of Otery St Mary, miller 0
3787473 1953872 1953872 defendant Browne William laborer 587224 587224 (Browne, William, of Otery St Mary, laborer 1
3791469 1955167 1955167 defendant Healmer Henry tucker 587224 587224 Healmer, Henry, of Otery St Mary, tucker 0
3795489 1956469 1956469 defendant Randall William yeoman 587224 587224 Randall, William, of Otery St Mary, yeoman 0
3826706 1966202 1966202 defendant Clappe Nicholas dyer 587224 587224 Clappe, Nicholas, of Otery St Mary, dyer 0
3829701 1967181 1967181 defendant Clappe John husbandman 587224 587224 Clappe, John, of Otery St Mary, husbandman 1
3837199 1969537 1969537 defendant Grenowe Nicholas husbandman 587224 587224 Grenowe, Nicholas, of Otery St Mary, husbandman 0
3847923 1972926 1972926 defendant Barret Thomas weaver 587224 587224 Barret, Thomas, of Otery St Mary, weaver 2
3852792 1974479 1974479 defendant Turpyn William husbandman 587224 587224 Turpyn, William, of Otery St Mary, husbandman 0
3852794 1974480 1974480 defendant Turpyn William husbandman 587224 587224 Turpyn, William, of Otery St Mary, husbandman 0
3853205 1974623 1974623 defendant Dellyng or Dollyng Richard weaver 587224 587224 Dellyng or Dollyng, Richard, of Otery St Mary, weaver 0
3855798 1975444 1975444 defendant Mugge Joan widow 587224 587224 Mugge, Joan, of Otery St Mary, widow 1
3867694 1979432 1979432 plaintiff Sherman John clothier 587224 587224 Sherman, John, of Otery St Mary, clothier 0
3867698 1979433 1979433 plaintiff Sherman John clothier 587224 587224 Sherman, John, of Otery St Mary, clothier 0
3868262 1979622 1979622 plaintiff Stoford William   587224 587224 Stoford, William, of Otery St Mary 0
3868376 1979661 1979661 defendant Moore Alice widow 587224 587224 Moore, Alice, of Otery St Mary, widow 0
3877164 1982602 1982602 defendant Ware William husbandman 587224 587224 Ware, William, of Otery St Mary, husbandman 1
3882421 1984386 1984386 defendant Sprake William turner 587224 587224 Sprake, William, of Otery St Mary, turner 0
3902094 1990935 1990935 defendant More Hugh gent 587224 587224 More, Hugh, of Otery St Mary, gent 0
3904917 1991905 1991905 defendant Clapp Nicholas dyer 587224 587224 Clapp, Nicholas, of Otery St Mary, dyer 0
3923828 1998277 1998277 defendant Besse John husbandman 587224 587224 Besse, John, of Otery St Mary, husbandman 0
3951393 2007549 2007549 defendant Clappe John husbandman 587224 587224 Clappe, John, of Otery St Mary, husbandman 0
3959127 2010278 2010278 defendant Courteney John esq 587224 587224 Courteney, John, of Otery St Mary, esq 0
3959817 2010526 2010526 defendant Ware Alice widow 587224 587224 Ware, Alice, of Otery St Mary, widow 0
3961424 2011090 2011090 plaintiff Tucke William   587224 587224 Tucke, William, of Otery St Mary 0
3965004 2012365 2012365 defendant Salter John husbandman 587224 587224 Salter, John, of Otery St Mary, husbandman 0
3973638 2015351 2015351 defendant Babyngton Walter gent 587224 587224 Babyngton, Walter, of Otery St Mary, gent 0
3974415 2015625 2015625 plaintiff Haydon John   587224 587224 Haydon, John, of Otery St Mary, esq, feoffee of John Lauerance, late of Otery St Mary 0
3978247 2016975 2016975 defendant Babyngton Walter gent 587224 587224 Babyngton, Walter, of Otery St Mary, gent 0
4027134 2034351 2034351 plaintiff Stoford John   587224 587224 Stoford, John, of Otery St Mary 1
4072645 2050520 2050520 defendant Babyngton Walter gent 587224 587224 Walter Babyngton, of Otery St Mary, gent 1
4107290 2062899 2062899 defendant Barett Griffin shoemaker 587224 587224 Barett, Griffin, of Otery St Mary, shoemaker 0
4107291 2062899 2062899 defendant Ligh Robert   587224 587224 Ligh, Robert, of Otery St Mary 1
4138305 2074066 2074066 defendant Marker William cordwainer 587224 587224 Marker, William, of Otery St Mary, cordwainer 0
4159103 2081254 2081254 defendant Stonyng Roger husbandman 587224 587224 Stonyng, Roger, of Otery St Mary, husbandman 0
4159104 2081254 2081254 defendant Edmond Richard husbandman 587224 587224 Edmond, Richard, of Otery St Mary, husbandman 1
4301598 2130675 2130675 defendant Bird Mathew yeoman 587224 587224 Bird, Mathew, of Otery St Mary, yeoman 0
4335711 2142222 2142222 defendant Morris George yeoman 587224 587224 Morris, George, of Otery St Mary, yeoman 0
4335712 2142222 2142222 defendant Morris William yeoman 587224 587224 together with Morris, William, of Otery St Mary, yeoman 1
4335713 2142222 2142222 defendant Morris Richard yeoman 587224 587224 Morris, Richard, of Otery St Mary, yeoman 2
4567868 2221522 2221522 defendant Twyford John   587224 587224 Twyford, John, of Otery St Mary 0
4651545 2246487 2246487 defendant Willesdon Henry   587224 587224 Willesdon, Henry, of Otery St Mary, bailiff 3
4661295 2249353 2249353 defendant Bysshup Richard husbandman 587224 587224 Bysshup, Richard, of Otery St Mary, husbandman 0
4782286 2290463 2290463 defendant Dyre Geoffrey laborer 587224 587224 Dyre, Geoffrey, of Otery St Mary, laborer 0
4782287 2290463 2290463 defendant Dyre John laborer 587224 587224 Dyre, John, of Otery St Mary, laborer 1
4796374 2295016 2295016 plaintiff Sarger Thomas   587224 587224 Sarger, Thomas, of Otery St Mary 0
4799415 2295997 2295997 defendant Berlebyn John husbandman 587224 587224 Berlebyn, John, of Otery St Mary, husbandman 1
4799657 2296075 2296075 defendant Chuddelegh John baker 587224 587224 Chuddelegh, John, of Otery St Mary, baker 1
4823495 2303438 2303438 defendant Onger or Ouger Herny husbandman 587224 587224 Onger or Ouger, Herny, of Otery St Mary, husbandman 0
4867412 2316774 2316774 plaintiff Chichestre Richard clerk 587224 587224 Chichestre, Richard, of Otery St Mary, clerk 3
4889321 2323449 2323449 defendant Latymer Thomas   587224 587224 Latymer, Thomas, of Otery St Mary, bailiff 0
4897646 2325928 2325928 defendant Weye John shoemaker 587224 587224 Weye, John, of Otery St Mary, shoemaker 1
4902113 2327271 2327271 defendant Tayllour William chapman 587224 587224 Tayllour, William, of Otery St Mary, chapman 0
4907130 2328793 2328793 defendant Latymer Thomas yeoman 587224 587224 Latymer, Thomas, of Otery St Mary, yeoman 0
4928346 2335289 2335289 defendant Burdescombe Richard mercer 587224 587224 Burdescombe, Richard, of Otery St Mary, mercer 0
4934944 2337333 2337333 defendant Chapman William chapman 587224 587224 Chapman, William, of Otery St Mary, chapman 0
4941939 2339463 2339463 defendant Dyer John dyer 587224 587224 Dyer, John, of Otery St Mary, dyer 0
4946589 2340930 2340930 defendant Taylour William chapman 587224 587224 Taylour, William, of Otery St Mary, chapman 0
4947380 2341178 2341178 defendant Stylyng John husbandman 587224 587224 Stylyng, John, of Otery St Mary, husbandman 0
4947381 2341178 2341178 defendant Burcomb John butcher 587224 587224 Burcomb, John, of Otery St Mary, butcher 1
4947382 2341178 2341178 defendant Taillour William chapman 587224 587224 Taillour, William, of Otery St Mary, chapman 2
4952603 2342740 2342740 defendant Wrey William chaplain 587224 587224 Wrey, William, of Otery St Mary, chaplain 0
4952604 2342740 2342740 defendant Baggewyll William tucker 587224 587224 Baggewyll, William, of Otery St Mary, tucker 1
4953379 2342975 2342975 defendant Whever Richard chaplain 587224 587224 Whever, Richard, of Otery St Mary, chaplain 0
4953427 2342991 2342991 defendant Baker Mathew baker 587224 587224 Baker, Mathew, of Otery St Mary, baker 1
4957521 2344218 2344218 defendant Burcombe John butcher 587224 587224 Burcombe, John, of Otery St Mary, butcher 1
4966301 2346853 2346853 defendant Burdyscombe John clerk 587224 587224 Burdyscombe, John, of Otery St Mary, clerk 2
4972470 2348698 2348698 defendant Heyes Robert shoemaker 587224 587224 Heyes, Robert, of Otery St Mary, shoemaker 1

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