names

483 rows where place_id = 587074

✎ 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
3590387 1864634 1864634 defendant Mylward John husbandman 587074 587074 Mylward, John, of Donyngton, husbandman 2
3590662 1864723 1864723 defendant Broccas George gent 587074 587074 Broccas, George, of Donyngton, gent 0
3591553 1864982 1864982 defendant Chekon Thomas husbandman 587074 587074 Chekon, Thomas, of Donyngton, husbandman 0
3591555 1864983 1864983 defendant Chekon Thomas husbandman 587074 587074 Chekon, Thomas, of Donyngton, husbandman 0
3599268 1867414 1867414 defendant Glover alias Jay Richard butcher 587074 587074 Glover alias Jay, Richard, of Donyngton, butcher 0
3624507 1875200 1875200 defendant Brown Henry yeoman 587074 587074 Brown, Henry, of Donyngton, yeoman 2
3632886 1905103 1905103 defendant Haylyn alias SMyth William yeoman 587074 587074 Haylyn alias SMyth, William, of Donyngton, or of Wynterbournstoke, yeoman 0
3634183 1905494 1905494 defendant Reynoldson William husbandman 587074 587074 Reynoldson, William, of Donyngton, husbandman 0
3638190 1906761 1906761 defendant Lokson John husbandman 587074 587074 Lokson, John, of Donyngton, husbandman 0
3638729 1906928 1906928 defendant Huls or Holes Thomas clerk 587074 587074 Huls or Holes, Thomas, of Donyngton, clerk 0
3645965 1909131 1909131 plaintiff Hasylrig Robert esq 587074 587074 Hasylrig, Robert, of Donyngton, esq 1
3650300 1910469 1910469 defendant Hasylryg Robert esq 587074 587074 Hasylryg, Robert, of Donyngton, esq 1
3650308 1910470 1910470 defendant Hasylryg Robert esq 587074 587074 Hasylryg, Robert, of Donyngton, esq 1
3654726 1911735 1911735 defendant Langley Edward gent 587074 587074 Langley, Edward, of Donyngton, gent 4
3656341 1912228 1912228 defendant Hylton Roger   587074 587074 Hylton, Roger, of Donyngton, in Holandl gent 0
3659267 1913154 1913154 defendant Doinnall Margery widow 587074 587074 Doinnall, Margery, of Donyngton, widow 0
3659272 1913154 1913154 defendant Coton Bartholomew gent 587074 587074 Coton, Bartholomew, of Donyngton, gent 5
3662538 1914202 1914202 defendant Doinnall Margery widow 587074 587074 Doinnall, Margery, of Donyngton, widow 0
3662543 1914202 1914202 defendant Coton Bartholomew gent 587074 587074 Coton, Bartholomew, of Donyngton, gent 5
3664351 1914798 1914798 defendant Robyns John husbandman 587074 587074 Robyns, John, of Donyngton, husbandman 0
3665926 1915280 1915280 defendant Bomnall Margery widow 587074 587074 Bomnall, Margery, of Donyngton, widow 0
3665931 1915280 1915280 defendant Cotom Bartholomew gent 587074 587074 Cotom, Bartholomew, of Donyngton, gent 5
3667532 1915787 1915787 defendant Dommall Margery widow 587074 587074 Dommall, Margery, of Donyngton, widow 0
3667537 1915787 1915787 defendant Cotom Bartholmew gent 587074 587074 Cotom, Bartholmew, of Donyngton, gent 5
3671162 1916950 1916950 defendant Bond John yeoman 587074 587074 Bond, John, of Donyngton, yeoman 0
3671164 1916951 1916951 defendant Hylton Roger gent 587074 587074 Hylton, Roger, of Donyngton, gent 0
3671166 1916952 1916952 defendant Roberd Richard yeoman 587074 587074 Roberd, Richard, of Donyngton, yeoman 0
3671195 1916963 1916963 defendant Johnson John laborer 587074 587074 Johnson, John, of Donyngton, laborer 0
3672777 1917492 1917492 defendant Robert Richard yeoman 587074 587074 Robert, Richard, of Donyngton, yeoman 1
3672778 1917492 1917492 defendant Bownd John yeoman 587074 587074 Bownd, John, of Donyngton, yeoman 2
3672781 1917493 1917493 defendant Robert Richard yeoman 587074 587074 Robert, Richard, of Donyngton, yeoman 1
3672782 1917493 1917493 defendant Bownd John yeoman 587074 587074 Bownd, John, of Donyngton, yeoman 2
3680579 1920006 1920006 defendant Hylton Roger gent 587074 587074 Hylton, Roger, of Donyngton, gent 0
3684138 1921175 1921175 defendant Broune Thomas gent 587074 587074 Broune, Thomas, of Donyngton, gent 0
3686100 1921813 1921813 defendant Greve Robert tanner 587074 587074 Greve, Robert, of Donyngton, tanner 0
3688199 1922458 1922458 defendant Roberd Henry husbandman 587074 587074 Roberd, Henry, of Donyngton, husbandman 0
3690390 1923157 1923157 defendant Borett Thomas tailor 587074 587074 Borett, Thomas, of Donyngton, tailor 0
3690997 1923347 1923347 defendant Fissher John laborer 587074 587074 Fissher, John, of Donyngton, laborer 1
3692769 1923929 1923929 defendant Botell Richard glover 587074 587074 Botell, Richard, of Donyngton, glover 0
3692891 1923973 1923973 defendant Minsterley Hugh clerk 587074 587074 Minsterley, Hugh, of Donyngton, clerk 1
3692892 1923973 1923973 defendant Staunton John husbandman 587074 587074 Staunton, John, of Donyngton, husbandman 2
3693396 1924150 1924150 defendant Brodeley Thurstan laborer 587074 587074 Brodeley, Thurstan, of Donyngton, laborer 0
3697232 1925355 1925355 defendant Martyn Ralph yeoman 587074 587074 Martyn, Ralph, of Donyngton, yeoman 0
3706164 1928219 1928219 defendant Hulton Roger gent 587074 587074 Hulton, Roger, of Donyngton, gent 1
3709801 1929381 1929381 defendant Robynson Richard laborer 587074 587074 Robynson, Richard, of Donyngton, laborer 0
3714878 1930949 1930949 defendant Hylton Roger gent 587074 587074 Hylton, Roger, of Donyngton, gent 0
3715429 1931112 1931112 defendant Hylton Roger gent 587074 587074 Hylton, Roger, of Donyngton, gent 0
3719239 1932302 1932302 defendant Massyngberd William mercer 587074 587074 Massyngberd, William, of Donyngton, mercer 0
3719356 1932339 1932339 defendant Fyssher John yeoman 587074 587074 Fyssher, John, of Donyngton, yeoman 0
3720421 1932667 1932667 defendant Kerchener John husbandman 587074 587074 Kerchener, John, of Donyngton, husbandman 0
3722399 1933269 1933269 defendant Gybson Robert husbandman 587074 587074 Gybson, Robert, of Donyngton, husbandman 0
3728654 1935199 1935199 defendant Sutton Thomas   587074 587074 Sutton, Thomas, of Donyngton, gent, son of Sutton, William, of Boston 0
3736464 1937651 1937651 defendant Kerchener John husbandman 587074 587074 Kerchener, John, of Donyngton, husbandman 1
3742120 1939403 1939403 defendant Greve Robert tanner 587074 587074 Greve, Robert, of Donyngton, tanner 1
3754123 1943236 1943236 defendant Renoldson Thomas tanner 587074 587074 Renoldson, Thomas, of Donyngton, tanner 0
3759205 1944866 1944866 defendant Ely Thomas tailor 587074 587074 Ely, Thomas, of Donyngton, tailor 0
3759256 1944885 1944885 defendant Greve Robert tanner 587074 587074 Greve, Robert, of Donyngton, tanner 3
3764761 1946643 1946643 defendant Ely Thomas husbandman 587074 587074 Ely, Thomas, of Donyngton, husbandman 0
3764763 1946644 1946644 defendant Reyner Thomas husbandman 587074 587074 Reyner, Thomas, of Donyngton, husbandman 0
3764776 1946648 1946648 defendant Mynwyte Robert husbandman 587074 587074 Mynwyte, Robert, of Donyngton, husbandman 0
3764777 1946648 1946648 defendant Chekyn Richard laborer 587074 587074 Chekyn, Richard, of Donyngton, laborer 1
3764778 1946648 1946648 defendant Hasty Richard laborer 587074 587074 Hasty, Richard, of Donyngton, laborer 2
3769449 1948105 1948105 defendant Jakson John husbandman 587074 587074 Jakson, John, of Donyngton, husbandman 0
3771532 1948790 1948790 defendant Colson Robert husbandman 587074 587074 Colson, Robert, of Donyngton, husbandman 0
3773364 1949382 1949382 defendant Lawe Thomas laborer 587074 587074 Lawe, Thomas, of Donyngton, laborer 1
3773365 1949382 1949382 defendant Townesende John laborer 587074 587074 Townesende, John, of Donyngton, laborer 2
3782213 1952188 1952188 defendant Dobson Thomas husbandman 587074 587074 Dobson, Thomas, of Donyngton, husbandman 0
3782762 1952354 1952354 defendant Robert Henry husbandman 587074 587074 Robert, Henry, of Donyngton, husbandman 0
3782763 1952354 1952354 defendant Bond John yeoman 587074 587074 Bond, John, of Donyngton, yeoman 1
3782764 1952354 1952354 defendant Johnson John yeoman 587074 587074 Johnson, John, of Donyngton, yeoman 2
3782777 1952359 1952359 defendant Ely Thomas husbandman 587074 587074 Ely, Thomas, of Donyngton, husbandman 0
3782779 1952360 1952360 defendant Ely Thomas husbandman 587074 587074 Ely, Thomas, of Donyngton, husbandman 0
3782781 1952361 1952361 defendant Ely Thomas husbandman 587074 587074 Ely, Thomas, of Donyngton, husbandman 0
3782790 1952365 1952365 defendant Hasty Richard laborer 587074 587074 Hasty, Richard, of Donyngton, laborer 0
3782792 1952366 1952366 defendant Norton Robert husbandman 587074 587074 Norton, Robert, of Donyngton, husbandman 0
3782793 1952366 1952366 defendant Norton Richard husbandman 587074 587074 Norton, Richard, of Donyngton, husbandman 1
3782794 1952366 1952366 defendant bennet William laborer 587074 587074 bennet, William, of Donyngton, laborer 2
3786185 1953472 1953472 defendant Galyard Richard husbandman 587074 587074 Galyard, Richard, of Donyngton, husbandman 0
3786527 1953578 1953578 defendant Grene John thatcher 587074 587074 Grene, John, of Donyngton, thatcher 1
3789029 1954381 1954381 defendant Thomson Nicholas roper 587074 587074 Thomson, Nicholas, of Donyngton, roper 0
3791132 1955060 1955060 defendant Lawe Thomas laborer 587074 587074 Lawe, Thomas, of Donyngton, laborer 1
3791133 1955060 1955060 defendant Townesende John laborer 587074 587074 Townesende, John, of Donyngton, laborer 2
3795308 1956401 1956401 defendant Robert Henry husbandman 587074 587074 Robert, Henry, of Donyngton, husbandman 0
3795643 1956520 1956520 defendant Godbald Roger yeoman 587074 587074 Godbald, Roger, of Donyngton, yeoman 0
3796738 1956865 1956865 defendant Harryson Thurstan   587074 587074 Harryson, Thurstan, of Donyngton, cartwright 0
3796739 1956865 1956865 defendant Burneham John laborer 587074 587074 Burneham, John, of Donyngton, laborer 1
3796740 1956865 1956865 defendant Folgeam Robert laborer 587074 587074 Folgeam, Robert, of Donyngton, laborer 2
3796741 1956865 1956865 defendant Wilson John husbandman 587074 587074 Wilson, John, of Donyngton, husbandman 3
3798901 1957571 1957571 defendant Hulton Thomas gent 587074 587074 Hulton, Thomas, of Donyngton, gent 0
3805710 1959731 1959731 defendant Roberd Henry husbandman 587074 587074 Roberd, Henry, of Donyngton, husbandman 1
3805711 1959731 1959731 defendant Rochester Ralph sherman 587074 587074 Rochester, Ralph, of Donyngton, sherman 2
3811829 1961602 1961602 defendant Pytte Simon husbandman 587074 587074 Pytte, Simon, of Donyngton, husbandman 1
3811831 1961603 1961603 defendant Pytte Simon husbandman 587074 587074 Pytte, Simon, of Donyngton, husbandman 0
3812535 1961808 1961808 defendant Roberd Henry yeoman 587074 587074 Roberd, Henry, of Donyngton, yeoman 0
3815016 1962617 1962617 defendant Gylby Bartholomew husbandman 587074 587074 Gylby, Bartholomew, of Donyngton, husbandman 0
3815407 1962735 1962735 defendant Fyscher John husbandman 587074 587074 Fyscher, John, of Donyngton, husbandman 0
3820943 1964444 1964444 defendant Rippyngale John husbandman 587074 587074 Rippyngale, John, of Donyngton, husbandman 0
3820945 1964445 1964445 defendant Smyth Simon husbandman 587074 587074 Smyth, Simon, of Donyngton, husbandman 0
3821249 1964537 1964537 defendant Greve Robert tanner 587074 587074 Greve, Robert, of Donyngton, tanner 0
3827093 1966332 1966332 defendant Robert Henry innholder 587074 587074 Robert, Henry, of Donyngton, innholder 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);