names

550 rows where place_id = 586344

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588477 1864041 1864041 defendant Goold William butcher 586344 586344 Goold, William, of Burton, butcher 0
3602570 1868464 1868464 defendant Taylour Henry yeoman 586344 586344 Taylour, Henry, of Burton, yeoman 3
3610480 1870940 1870940 defendant Husbond Thomas husbandman 586344 586344 Husbond, Thomas, of Burton, husbandman 0
3612494 1871541 1871541 defendant Grome John yeoman 586344 586344 Grome, John, of Burton Stather, yeoman 1
3612495 1871541 1871541 defendant Granyter Thomas yeoman 586344 586344 Granyter, Thomas, of Burton Stather, yeoman 2
3630598 1904399 1904399 defendant Parker Richard shoemaker 586344 586344 Parker, Richard, of Burton Stather, shoemaker 0
3633702 1905351 1905351 defendant Rudde John husbandman 586344 586344 Rudde, John, of Burton, husbandman 1
3635386 1905864 1905864 defendant Anderson Thomas yeoman 586344 586344 Anderson, Thomas, of Burton Stater, yeoman 0
3635388 1905865 1905865 defendant Anderson Thomas yeoman 586344 586344 Anderson, Thomas, of Burton Stater, yeoman 0
3636881 1906327 1906327 defendant Spokys Robert, senior husbandman 586344 586344 Spokys, Robert, senior, of Burton, husbandman 1
3638565 1906877 1906877 defendant Morys Thomas husbandman 586344 586344 Morys, Thomas, of Burton, husbandman 0
3644311 1908643 1908643 defendant Hylton Christopher esq 586344 586344 Hylton, Christopher, of Burton, esq 3
3650272 1910460 1910460 defendant Scorfeld Thomas husbandman 586344 586344 Scorfeld, Thomas, of Burton, husbandman 0
3660268 1913473 1913473 defendant Helton William gent 586344 586344 Helton, William, of Burton, gent 0
3660269 1913473 1913473 defendant Hirde John husbandman 586344 586344 Hirde, John, of Burton, husbandman 1
3660270 1913473 1913473 defendant Jakson Thomas husbandman 586344 586344 Jakson, Thomas, of Burton, husbandman 2
3660271 1913473 1913473 defendant Pereth Christopher husbandman 586344 586344 Pereth, Christopher, of Burton, husbandman 3
3660272 1913473 1913473 defendant Hirde Christopher husbandman 586344 586344 Hirde, Christopher, of Burton, husbandman 4
3675183 1918270 1918270 defendant Meyst Andrew yeoman 586344 586344 Meyst, Andrew, of Burton, yeoman 2
3688197 1922458 1922458 plaintiff Coye John (legal representative) 586344 586344 Coye, John, of Burton, executor of 0
3691076 1923371 1923371 defendant Lacon Christopher gent 586344 586344 Lacon, Christopher, of Burton Stather, gent 1
3700028 1926243 1926243 defendant Barnard John laborer 586344 586344 Barnard, John, of Burton Stader, laborer 0
3706337 1928269 1928269 defendant Lane John husbandman 586344 586344 Lane, John, of Burton on Water, husbandman 0
3716829 1931551 1931551 defendant Gomersall William yeoman 586344 586344 Gomersall, William, of Burton, yeoman 0
3728894 1935285 1935285 defendant Burdousse John husbandman 586344 586344 Burdousse, John, of Burton, husbandman 4
3746238 1940732 1940732 defendant Wastelyn John gent 586344 586344 Wastelyn, John, of Burton Stather, gent 0
3749359 1941720 1941720 defendant Smyth William yeoman 586344 586344 Smyth, William, of Burton, yeoman 3
3749989 1941915 1941915 defendant Cokk William yeoman 586344 586344 Cokk, William, of Burton, yeoman 1
3749990 1941915 1941915 defendant Smyth Philip yeoman 586344 586344 Smyth, Philip, of Burton, yeoman 2
3749991 1941915 1941915 defendant Wheler William chaplain 586344 586344 Wheler, William, of Burton, chaplain 3
3749992 1941915 1941915 defendant Longworthe Nicholas chaplain 586344 586344 Longworthe, Nicholas, of Burton, chaplain 4
3754670 1943419 1943419 defendant Clerke John miller 586344 586344 Clerke, John, of Burton, miller 0
3754671 1943419 1943419 defendant Morehowe James yeoman 586344 586344 Morehowe, James, of Burton, yeoman 1
3766893 1947311 1947311 defendant Sprott Christopher husbandman 586344 586344 Sprott, Christopher, of Burton, husbandman 1
3775503 1950079 1950079 defendant Gretton Henry butcher 586344 586344 Gretton, Henry, of Burton, butcher 3
3780461 1951621 1951621 defendant Meysy Andrew yeoman 586344 586344 Meysy, Andrew, of Burton, yeoman 1
3783944 1952755 1952755 defendant Raskyll John cordwainer 586344 586344 Raskyll, John, of Burton Stather, cordwainer 0
3785737 1953329 1953329 defendant Hyde Richard husbandman 586344 586344 Hyde, Richard, of Burton, husbandman 0
3785761 1953335 1953335 defendant Nykkys Thomas husbandman 586344 586344 Nykkys, Thomas, of Burton, husbandman 0
3796215 1956681 1956681 defendant Meyse Andrew husbandman 586344 586344 Meyse, Andrew, of Burton, husbandman 0
3806847 1960048 1960048 defendant Lucas Thomas husbandman 586344 586344 Lucas, Thomas, of Burton, husbandman 1
3807160 1960133 1960133 defendant Tynte Edmund (legal representative) 586344 586344 Tynte, Edmund, of Burton, yeoman, executor of 0
3820061 1964153 1964153 defendant Knesall William butcher 586344 586344 Knesall, William, of Burton, butcher 0
3822423 1964911 1964911 defendant Wodde Thomas husbandman 586344 586344 Wodde, Thomas, of Burton, husbandman 1
3826897 1966263 1966263 defendant Taylour Walter husbandman 586344 586344 Taylour, Walter, of Burton, husbandman 0
3826898 1966263 1966263 defendant Bulkyn Richard husbandman 586344 586344 Bulkyn, Richard, of Burton, husbandman 1
3827639 1966503 1966503 plaintiff Broke Robert yeoman 586344 586344 Broke, Robert, of Burton, yeoman 0
3834805 1968822 1968822 defendant Symson Peter   586344 586344 Symson, Peter, of Burton, surgeon 0
3834807 1968823 1968823 defendant Symson Peter   586344 586344 Symson, Peter, of Burton, surgeon 0
3846031 1972318 1972318 defendant Barnard William husbandman 586344 586344 Barnard, William, of Burton, husbandman 0
3846824 1972558 1972558 defendant Rode John husbandman 586344 586344 Rode, John, of Burton, husbandman 0
3856826 1975758 1975758 defendant Mawger William husbandman 586344 586344 Mawger, William, of Burton, husbandman 0
3860592 1977037 1977037 defendant Blokley Henry husbandman 586344 586344 Blokley, Henry, of Burton on Water, husbandman 0
3860593 1977037 1977037 defendant Tommys William husbandman 586344 586344 Tommys, William, of Burton on Water, husbandman 1
3860594 1977037 1977037 defendant Paryt Robert husbandman 586344 586344 Paryt, Robert, of Burton on Water, husbandman 2
3860605 1977039 1977039 defendant Reve Edward husbandman 586344 586344 Reve, Edward, of Burton Latymer, husbandman 1
3861703 1977376 1977376 defendant Smythe Gilbert gent 586344 586344 Smythe, Gilbert, of Burton, gent 0
3868841 1979819 1979819 defendant Witton Richard husbandman 586344 586344 Witton, Richard, of Burton, husbandman 2
3877261 1982638 1982638 defendant Lane William husbandman 586344 586344 Lane, William, of Burton on Water, husbandman 0
3877262 1982638 1982638 defendant Bynkys Nicholas butcher 586344 586344 Bynkys, Nicholas, of Burton on Water, butcher 1
3877263 1982638 1982638 defendant Wakefyld William laborer 586344 586344 Wakefyld, William, of Burton on Water, laborer 2
3877264 1982638 1982638 defendant Bynkys John laborer 586344 586344 Bynkys, John, of Burton on Water, laborer 3
3901228 1990637 1990637 defendant Kymble Thomas yeoman 586344 586344 Kymble, Thomas, of Burton, yeoman 0
3901229 1990637 1990637 defendant Dryng William, senior husbandman 586344 586344 Dryng, William, senior, of Burton, husbandman 1
3901230 1990637 1990637 defendant Ive Thomas husbandman 586344 586344 Ive, Thomas, of Burton, husbandman 2
3901231 1990637 1990637 defendant Dryng William, junior husbandman 586344 586344 Dryng, William, junior, of Burton, husbandman 3
3901232 1990637 1990637 defendant Dryng Oliver husbandman 586344 586344 Dryng, Oliver, of Burton, husbandman 4
3901233 1990637 1990637 defendant Semer Alexander, junior gent 586344 586344 Semer, Alexander, junior, of Burton, gent 5
3928142 1999750 1999750 defendant Hylton Thomas yeoman 586344 586344 Hylton, Thomas, of Burton, yeoman 0
3928143 1999750 1999750 defendant Penreth Robert yeoman 586344 586344 Penreth, Robert, of Burton, yeoman 1
3928144 1999750 1999750 defendant Hyrde William yeoman 586344 586344 Hyrde, William, of Burton, yeoman 2
3928149 1999751 1999751 defendant Hylton Thomas yeoman 586344 586344 Hylton, Thomas, of Burton, yeoman 0
3928150 1999751 1999751 defendant Penreth Robert yeoman 586344 586344 Penreth, Robert, of Burton, yeoman 1
3928151 1999751 1999751 defendant Hyrde William yeoman 586344 586344 Hyrde, William, of Burton, yeoman 2
3936185 2002426 2002426 plaintiff Luggare John   586344 586344 Luggare, John, of Burton 0
3938810 2003321 2003321 plaintiff Reve Edward   586344 586344 Reve, Edward, of Burton 0
3940867 2003954 2003954 defendant Nevyll George gent 586344 586344 Nevyll, George, of Burton, gent 0
3960087 2010628 2010628 defendant Knyght William yeoman 586344 586344 Knyght, William, of Burton, yeoman 0
3961668 2011182 2011182 defendant Wulston Robert gent 586344 586344 Wulston, Robert, of Burton Latymer, gent 0
3966832 2013034 2013034 defendant Stone Thomas shoemaker 586344 586344 Stone, Thomas, of Burton, shoemaker 1
3966836 2013035 2013035 defendant Stone Thomas shoemaker 586344 586344 Stone, Thomas, of Burton, shoemaker 1
3974376 2015611 2015611 plaintiff Hawles William mercer 586344 586344 Hawles, William, of Burton, mercer 0
3977139 2016576 2016576 defendant Wylcock Roger husbandman 586344 586344 Wylcock, Roger, of Burton, husbandman 0
3977140 2016576 2016576 defendant Wilcock Jerome husbandman 586344 586344 Wilcock, Jerome, of Burton, husbandman 1
3977141 2016576 2016576 defendant Wilcock Richard husbandman 586344 586344 Wilcock, Richard, of Burton, husbandman 2
3977142 2016576 2016576 defendant Wilcock John husbandman 586344 586344 Wilcock, John, of Burton, husbandman 3
3977143 2016576 2016576 defendant Wylcock Thomas husbandman 586344 586344 Wylcock, Thomas, of Burton, husbandman 4
3977144 2016576 2016576 defendant Tarte Ralph husbandman 586344 586344 Tarte, Ralph, of Burton, husbandman 5
3977145 2016576 2016576 defendant Grene Thomas husbandman 586344 586344 Grene, Thomas, of Burton, husbandman 6
3977146 2016576 2016576 defendant Haburley Walter husbandman 586344 586344 Haburley, Walter, of Burton, husbandman 7
3977147 2016576 2016576 defendant Haburley William husbandman 586344 586344 Haburley, William, of Burton, husbandman 8
3977148 2016576 2016576 defendant Ball John husbandman 586344 586344 Ball, John, of Burton, husbandman 9
3977149 2016576 2016576 defendant Hygg William husbandman 586344 586344 Hygg, William, of Burton, husbandman 10
3977150 2016576 2016576 defendant Myddleton John husbandman 586344 586344 Myddleton, John, of Burton, husbandman 11
3977506 2016703 2016703 defendant Asheton Robert husbandman 586344 586344 Asheton, Robert, of Burton Latymer, husbandman 0
3977960 2016864 2016864 defendant Shawe James clothier 586344 586344 Shawe, James, of Burton, clothier 1
4005111 2026615 2026615 plaintiff Kendale John yeoman 586344 586344 Kendale, John, of Burton, yeoman 0
4005405 2026714 2026714 defendant Bowthe Thomas yeoman 586344 586344 Bowthe, Thomas, of Burton juxta Stather, yeoman 0
4008885 2027941 2027941 defendant Draper John husbandman 586344 586344 Draper, John, of Burton, husbandman 0
4013540 2029580 2029580 plaintiff Rowland Thomas husbandman 586344 586344 Rowland, Thomas, of Burton, husbandman 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);