names

147 rows where place_id = 642255

✎ 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
3625199 1875415 1875415 defendant Walssh John gent 642255 642255 Walssh, John, of Tyverton, Devon, or of Bristol, gent 1
3729610 1935509 1935509 defendant Seleke John   642255 642255 Seleke, John, of Tyverton, Devon, court holder 2
3866799 1979132 1979132 defendant Awbre alias Lee Thomas merchant 642255 642255 Awbre alias Lee, Thomas, of Tyverton, Devon, merchant 0
3866805 1979133 1979133 defendant Awbre alias Lee Thomas merchant 642255 642255 Awbre alias Lee, Thomas, of Tyverton, Devon, merchant 0
3917581 1996239 1996239 plaintiff Haglly Richard (legal representative) 642255 642255 Haglly, Richard, of Tyverton, Devon, clothier, executors of 0
3929390 2000176 2000176 defendant Style John mercer 642255 642255 Style, John, of Tyverton, Devon, mercer 0
3929927 2000352 2000352 defendant Style John chapman 642255 642255 Style, John, of Tyverton, Devon, chapman 0
3957655 2009737 2009737 defendant Carewe Gavin   642255 642255 Carewe, Gavin, of Tyverton, Devon, knight 0
3957843 2009804 2009804 defendant Donne Philip yeoman 642255 642255 Donne, Philip, of Tyverton, Devon, yeoman 1
3961926 2011267 2011267 plaintiff Walron Robert clothier 642255 642255 Walron, Robert, of Tyverton, Devon, clothier 0
3967932 2013413 2013413 plaintiff Capron Richard clothier 642255 642255 Capron, Richard, of Tyverton, Devon, clothier 0
3974535 2015669 2015669 defendant Lande or Laude John clothier 642255 642255 Lande or Laude, John, of Tyverton, Devon, clothier 0
3978582 2017086 2017086 defendant Payne John dyer 642255 642255 Payne, John, of Tyverton, Devon, dyer 1
3980915 2017935 2017935 plaintiff Powell Richard clothier 642255 642255 Powell, Richard, of Tyverton, Devon, clothier 0
3983695 2018940 2018940 defendant Wasshyngton Thomas   642255 642255 Wasshyngton, Thomas, of Tyverton, Devon, clerk, curate of St George, Southwark, Surrey 0
3990724 2021436 2021436 plaintiff Blundell Peter clothier 642255 642255 Blundell, Peter, of Tyverton, Devon, clothier 0
3992820 2022186 2022186 defendant Laylond James carrier or husbandman 642255 642255 Laylond, James, of Tyverton, Devon, carrier or husbandman 1
3993752 2022518 2022518 plaintiff Chilcott John clothier 642255 642255 Chilcott, John, of Tyverton, Devon, clothier 0
3993756 2022519 2022519 plaintiff Chilcott John clothier 642255 642255 Chilcott, John, of Tyverton, Devon, clothier 0
4003659 2026074 2026074 defendant Lonsmore or Losemore Robert draper 642255 642255 Lonsmore or Losemore, Robert, of Tyverton, Devon, draper 0
4017084 2030817 2030817 plaintiff Tanner William clothier 642255 642255 Tanner, William, of Tyverton, Devon, clothier 0
4017893 2031113 2031113 plaintiff Tramlett Henry clothier 642255 642255 Tramlett, Henry, of Tyverton, Devon, clothier 0
4017895 2031114 2031114 plaintiff Tramlett Henry clothier 642255 642255 Tramlett, Henry, of Tyverton, Devon, clothier 0
4017897 2031115 2031115 plaintiff Tramlett Henry clothier 642255 642255 Tramlett, Henry, of Tyverton, Devon, clothier 0
4017899 2031116 2031116 plaintiff Tramlett Henry clothier 642255 642255 Tramlett, Henry, of Tyverton, Devon, clothier 0
4024321 2033389 2033389 defendant Bedell John husbandman 642255 642255 Bedell, John, of Tyverton, Devon, husbandman 2
4024331 2033390 2033390 defendant Bedell John husbandman 642255 642255 Bedell, John, of Tyverton, Devon, husbandman 2
4024352 2033392 2033392 defendant Peers Anthony draper 642255 642255 Peers, Anthony, of Tyverton, Devon, draper 0
4024541 2033452 2033452 plaintiff Blundell Peter clothier 642255 642255 Blundell, Peter, of Tyverton, Devon, clothier 0
4029173 2035078 2035078 defendant Churley John husbandman 642255 642255 Churley, John, of Tyverton, Devon, husbandman 0
4029176 2035079 2035079 defendant Churle John husbandman 642255 642255 Churle, John, of Tyverton, Devon, husbandman 0
4031998 2036112 2036112 plaintiff Fulford John yeoman 642255 642255 Fulford, John, of Tyverton, Devon, yeoman 0
4032000 2036113 2036113 plaintiff Fulford John yeoman 642255 642255 Fulford, John, of Tyverton, Devon, yeoman 0
4041929 2039601 2039601 defendant Deyman Thomas gent 642255 642255 Deyman, Thomas, of Tyverton, Devon, gent 0
4044003 2040307 2040307 plaintiff Pyers Richard clothier 642255 642255 Pyers, Richard, of Tyverton, Devon, clothier 0
4044005 2040308 2040308 plaintiff Pyers Richard clothier 642255 642255 Pyers, Richard, of Tyverton, Devon, clothier 0
4049120 2042131 2042131 plaintiff Tremblett Henry clothier 642255 642255 Tremblett, Henry, of Tyverton, Devon, clothier 0
4049122 2042132 2042132 plaintiff Tremblett Henry clothier 642255 642255 Tremblett, Henry, of Tyverton, Devon, clothier 0
4051248 2042886 2042886 defendant Fulforde Henry yeoman 642255 642255 Fulforde, Henry, of Tyverton, Devon, yeoman 0
4056663 2044770 2044770 defendant Huckley John clothier 642255 642255 Huckley, John, of Tyverton, Devon, clothier 0
4067484 2048682 2048682 defendant Vanner Robert draper 642255 642255 Vanner, Robert, of Tyverton, Devon, draper 0
4088144 2056050 2056050 defendant Darche Michael husbandman 642255 642255 Darche, Michael, of Tyverton, Devon, husbandman 2
4097733 2059520 2059520 defendant Donne or Doune Richard yeoman 642255 642255 Donne or Doune, Richard, of Tyverton, Devon, yeoman 0
4103374 2061488 2061488 defendant Deamonde Thomas gent 642255 642255 Deamonde, Thomas, of Tyverton, Devon, gent 1
4115290 2065759 2065759 defendant Hickley John yeoman 642255 642255 Hickley, John, of Tyverton, Devon, yeoman 1
4115701 2065899 2065899 defendant Loman Henry hatter 642255 642255 Loman, Henry, of Tyverton, Devon, yeoman, hatter 0
4119843 2067386 2067386 defendant Kerslake John tucker 642255 642255 Kerslake, John, of Tyverton, Devon, tucker 0
4119845 2067387 2067387 defendant Kerslake John tucker 642255 642255 Kerslake, John, of Tyverton, Devon, tucker 0
4126067 2069609 2069609 defendant Kerslake John tucker 642255 642255 Kerslake, John, of Tyverton, Devon, tucker 0
4127306 2070060 2070060 defendant Braye William husbandman 642255 642255 Braye, William, of Tyverton, Devon, husbandman 0
4141413 2075153 2075153 defendant Reade Alexander tailor 642255 642255 Reade, Alexander, of Tyverton, Devon, tailor 1
4146416 2076896 2076896 defendant Ellyce John husbandman 642255 642255 Ellyce, John, of Tyverton, Devon, husbandman 0
4147975 2077423 2077423 defendant Ellys Robert husbandman 642255 642255 Ellys, Robert, of Tyverton, Devon, husbandman 0
4162259 2082360 2082360 defendant Waldron Mathew merchant 642255 642255 Waldron, Mathew, of Tyverton, Devon, merchant 0
4165189 2083333 2083333 defendant Losemore Lewis yeoman 642255 642255 Losemore, Lewis, of Tyverton, Devon, yeoman 0
4165317 2083376 2083376 defendant Deyman Thomas (legal representative) 642255 642255 Deyman, Thomas, of Tyverton, Devon, gent, executor of 0
4167811 2084229 2084229 defendant Donne Philip yeoman 642255 642255 Donne, Philip, of Tyverton, Devon, yeoman 0
4170371 2085130 2085130 defendant Staplehill John yeoman 642255 642255 Staplehill, John, of Tyverton, Devon, yeoman 0
4179010 2088135 2088135 defendant Grygge Thomas merchant 642255 642255 Grygge, Thomas, of Tyverton, Devon, merchant 0
4182156 2089236 2089236 defendant Byddell Nicholas husbandman 642255 642255 Byddell, Nicholas, of Tyverton, Devon, husbandman 0
4191445 2092576 2092576 defendant Cullinne or Cullume John gent 642255 642255 Cullinne or Cullume, John, of Tyverton, Devon, gent 3
4196277 2094242 2094242 defendant Crudge John tucker 642255 642255 Crudge, John, of Tyverton, Devon, tucker 3
4196279 2094243 2094243 defendant Merywether Nicholas hatter 642255 642255 Merywether, Nicholas, of Tyverton, Devon, hatter 0
4205867 2097596 2097596 defendant Webber Thomas yeoman 642255 642255 (Webber, Thomas, of Tyverton, Devon, yeoman 4
4206335 2097761 2097761 defendant Pears Richard clothier 642255 642255 Pears, Richard, of Tyverton, Devon, yeoman, clothier 0
4211240 2099482 2099482 defendant Southwood John clothier 642255 642255 Southwood, John, of Tyverton, Devon, clothier 1
4229704 2105870 2105870 defendant Venman Thomas clothier 642255 642255 Venman, Thomas, of Tyverton, Devon, clothier 0
4240031 2109639 2109639 defendant Lande Simon merchant 642255 642255 Lande, Simon, of Tyverton, Devon, merchant 0
4247325 2112081 2112081 defendant Gyfford Roger esq 642255 642255 Gyfford, Roger, of Tyverton, Devon, esq 0
4257091 2115345 2115345 defendant Clevanger Nicholas merchant 642255 642255 Clevanger, Nicholas, of Tyverton, Devon, merchant 0
4259878 2116275 2116275 defendant Venman Thomas clothier 642255 642255 Venman, Thomas, of Tyverton, Devon, clothier 0
4261853 2116917 2116917 defendant Gifford George gent 642255 642255 Gifford, George, of Tyverton, Devon, gent 0
4272052 2120218 2120218 defendant Gyfford Roger esq 642255 642255 Gyfford, Roger, of Tyverton, Devon, esq 0
4272798 2120467 2120467 defendant Gyfford George gent 642255 642255 Gyfford, George, of Tyverton, Devon, gent 0
4297581 2129238 2129238 defendant Deyman Roger gent 642255 642255 Deyman, Roger, of Tyverton, Devon, gent 0
4307104 2132620 2132620 defendant Tanner William tanner 642255 642255 Tanner, William, of Tyverton, Devon, tanner 1
4312478 2134501 2134501 defendant Crudge Thomas   642255 642255 Crudge, Thomas, of Tyverton, Devon, felt maker 0
4312479 2134501 2134501 defendant Shortydge Hugh yeoman 642255 642255 Shortydge, Hugh, of Tyverton, Devon, yeoman 1
4313203 2134730 2134730 defendant Crudge Thomas   642255 642255 Crudge, Thomas, of Tyverton, Devon, felt maker 0
4314238 2135087 2135087 defendant Lande or Laude Richard husbandman 642255 642255 Lande or Laude, Richard, of Tyverton, Devon, husbandman 0
4324814 2138687 2138687 defendant Shortridge Hugh yeoman 642255 642255 Shortridge, Hugh, of Tyverton, Devon, yeoman 0
4328981 2140002 2140002 defendant Prowse Thomas yeoman 642255 642255 Prowse, Thomas, of Tyverton, Devon, yeoman 0
4336520 2142510 2142510 defendant Rychardes John clerk 642255 642255 Rychardes, John, of Tyverton, Devon, or of London, clerk 0
4345216 2145603 2145603 defendant Richard John clerk 642255 642255 Richard, John, of Tyverton, Devon, clerk 0
4345701 2145765 2145765 defendant Tanner William chapman 642255 642255 Tanner, William, of Tyverton, Devon, chapman 1
4354495 2148807 2148807 defendant Gifford George gent 642255 642255 Gifford, George, of Tyverton, Devon, gent 1
4362017 2151459 2151459 defendant Boroughe George yeoman 642255 642255 Boroughe, George, of Tyverton, Devon, yeoman 0
4362163 2151513 2151513 defendant Deymond Robert gent 642255 642255 Deymond, Robert, of Tyverton, Devon, gent 3
4364954 2152519 2152519 defendant Tanner William draper 642255 642255 Tanner, William, of Tyverton, Devon, draper 0
4369241 2154061 2154061 defendant Gifford George gent 642255 642255 Gifford, George, of Tyverton, Devon, gent 0
4378595 2157417 2157417 defendant Gifford George gent 642255 642255 Gifford, George, of Tyverton, Devon, gent 1
4385374 2159799 2159799 defendant Deyman Roger gent 642255 642255 Deyman, Roger, of Tyverton, Devon, gent 0
4388174 2160673 2160673 defendant Clifford George gent 642255 642255 Clifford, George, of Tyverton, Devon, gent 0
4400420 2164736 2164736 defendant Rook or Rookes Peter husbandman 642255 642255 Rook or Rookes, Peter, of Tyverton, Devon, husbandman 1
4657654 2248284 2248284 defendant Baker Thomas merchant 642255 642255 Baker, Thomas, of Tyverton, Devon, merchant 4
4686283 2261313 2261313 defendant Pleymark John shoemaker 642255 642255 Pleymark, John, of tyverton, Devon, shoemaker 0
4686284 2261313 2261313 defendant Pleymark Reginald tanner 642255 642255 Pleymark, Reginald, of Tyverton, Devon, tanner 1
4753490 2281468 2281468 defendant Gerard Reginald yeoman 642255 642255 Gerard, Reginald, of Tyverton, Devon, yeoman 1
4806205 2298146 2298146 defendant Sedburgh Robert yeoman 642255 642255 Sedburgh, Robert, of Tyverton, Devon, yeoman 0
4806207 2298147 2298147 defendant Sedburgh Robert yeoman 642255 642255 Sedburgh, Robert, of Tyverton, Devon, yeoman 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);