names

1,794 rows where place_id = 586208

✎ 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
3588170 1863954 1863954 plaintiff Barton John   586208 586208 Barton, John, of Hereford 0
3588174 1863955 1863955 plaintiff Barton John   586208 586208 Barton, John, of Hereford 0
3589047 1864222 1864222 defendant Underwod John yeoman 586208 586208 Underwod, John, of Hereford, yeoman 3
3589048 1864222 1864222 defendant Mattys William husbandman 586208 586208 Mattys, William, of Hereford, husbandman 4
3590808 1864764 1864764 defendant Goldsmyth William yeoman 586208 586208 Goldsmyth, William, of Hereford, yeoman 1
3590809 1864764 1864764 defendant Baker Meuryk yeoman 586208 586208 Baker, Meuryk, of Hereford, yeoman 2
3592482 1865265 1865265 defendant ap John William ap Res yeoman 586208 586208 ap John, William ap Res, of Hereford, or of Glandestre, Wales, yeoman 0
3594361 1865868 1865868 defendant Brugge John yeoman 586208 586208 Brugge, John, of Hereford, yeoman 0
3594362 1865868 1865868 defendant Wylcok John ap David yeoman 586208 586208 Wylcok, John ap David, of Hereford, yeoman 1
3596410 1866507 1866507 defendant Baldewyn Richard cordwainer 586208 586208 Baldewyn, Richard, of Hereford, cordwainer 1
3596766 1866622 1866622 defendant Kerver Thomas chaplain 586208 586208 Kerver, Thomas, of Hereford, chaplain 0
3599806 1867585 1867585 plaintiff Walle John merchant 586208 586208 Walle, John, of Hereford, merchant 0
3600308 1867743 1867743 defendant Jonys Joan widow 586208 586208 Jonys, Joan, of Hereford, widow 0
3600312 1867744 1867744 defendant Jonys Joan widow 586208 586208 Jonys, Joan, of Hereford, widow 0
3605102 1869261 1869261 defendant Melyn Walter yeoman 586208 586208 Melyn, Walter, of Hereford, yeoman 0
3605103 1869261 1869261 defendant Cantelowe William yeoman 586208 586208 Cantelowe, William, of Hereford, yeoman 1
3608170 1870210 1870210 defendant Bonde Richard clerk 586208 586208 Bonde, Richard, of Hereford, clerk 0
3609835 1870745 1870745 defendant Breynton John gent 586208 586208 Breynton, John, of Hereford, gent 0
3613643 1871913 1871913 defendant Clerk William gent 586208 586208 Clerk, William, of Hereford, gent 1
3613647 1871914 1871914 defendant Clerk William gent 586208 586208 Clerk, William, of Hereford, gent 1
3617007 1872939 1872939 defendant Delabere Richard   586208 586208 Delabere, Richard, of Hereford, knight 2
3621242 1874183 1874183 defendant Gybbes Roger esq 586208 586208 Gybbes, Roger, of Hereford, esq 0
3621244 1874184 1874184 defendant Gybbes Roger esq 586208 586208 Gybbes, Roger, of Hereford, esq 0
3621730 1874334 1874334 defendant Gybbes Roger esq 586208 586208 Gybbes, Roger, of Hereford, esq 0
3624214 1875106 1875106 defendant Gybbes Roger esq 586208 586208 Gybbes, Roger, of Hereford, esq 0
3624216 1875107 1875107 defendant Taylowe John esq 586208 586208 Taylowe, John, of Hereford, esq 0
3624217 1875107 1875107 defendant Hobbe Henry cordwainer 586208 586208 Hobbe, Henry, of Hereford, cordwainer 1
3624218 1875107 1875107 defendant Yarworth Walter yeoman 586208 586208 Yarworth, Walter, of Hereford, yeoman 2
3626854 1903250 1903250 defendant Morys Agnes widow 586208 586208 Morys, Agnes, of Hereford, widow 1
3628392 1903745 1903745 defendant Tyddenour William tiler 586208 586208 Tyddenour, William, of Hereford, tiler 1
3628393 1903745 1903745 defendant Hare Richard tiler 586208 586208 Hare, Richard, of Hereford, tiler 2
3629678 1904136 1904136 defendant Rypton Richard pewterer 586208 586208 Rypton, Richard, of Hereford, pewterer 0
3629891 1904203 1904203 plaintiff Dodyn Benedict clerk 586208 586208 Dodyn, Benedict, of Hereford, clerk 0
3629893 1904203 1904203 defendant Grene Hugh clerk 586208 586208 Grene, Hugh, of Hereford, clerk 1
3629894 1904203 1904203 defendant Draper Thomas merchant 586208 586208 Draper, Thomas, of Hereford, merchant 2
3629895 1904203 1904203 defendant Carpenter Robert ironmonger 586208 586208 Carpenter, Robert, of Hereford, ironmonger 3
3631277 1904597 1904597 defendant Adams John baker 586208 586208 Adams, John, of Hereford, baker 1
3631280 1904597 1904597 defendant Penderyn Joan widow 586208 586208 Penderyn, Joan, of Hereford, widow 4
3631615 1904702 1904702 defendant Davyes John fuller 586208 586208 Davyes, John, of Hereford, fuller 2
3632762 1905061 1905061 defendant Lesseman Elizabeth widow 586208 586208 Lesseman, Elizabeth, of Hereford, widow 0
3632763 1905061 1905061 defendant Lesseman Walter chandler 586208 586208 Lesseman, Walter, of Hereford, chandler 1
3632919 1905112 1905112 defendant Blacston Walter yeoman 586208 586208 Blacston, Walter, of Hereford, yeoman 0
3632922 1905112 1905112 defendant Lewes Mathew yeoman 586208 586208 Lewes, Mathew, of Hereford, yeoman 3
3635799 1905997 1905997 defendant Yomans Richard glover 586208 586208 Yomans, Richard, of Hereford, glover 2
3638174 1906756 1906756 defendant Caldycot William tailor 586208 586208 Caldycot, William, of Hereford, tailor 0
3638176 1906757 1906757 defendant Caldycot William tailor 586208 586208 Caldycot, William, of Hereford, tailor 0
3638844 1906972 1906972 defendant Heryng Simon (legal representative) 586208 586208 Heryng, Simon, of Hereford, gent, executor of 0
3638845 1906972 1906972 defendant Heryng Henry gent 586208 586208 Heryng, Henry, of Hereford, gent 1
3638846 1906972 1906972 defendant Ragon John gent 586208 586208 Ragon John, of Hereford, gent 2
3642387 1908064 1908064 defendant Tyddynour William tiler 586208 586208 Tyddynour, William, of Hereford, tiler 0
3642388 1908064 1908064 defendant Hare Richard tiler 586208 586208 Hare, Richard, of Hereford, tiler 1
3643003 1908259 1908259 defendant Lewys John laborer 586208 586208 Lewys, John, of Hereford, laborer 2
3643272 1908320 1908320 defendant Goldsmyth Ellen widow 586208 586208 Goldsmyth, Ellen, of Hereford, widow 1
3643792 1908487 1908487 defendant Walwyn Margaret widow 586208 586208 Walwyn, Margaret, of Hereford, widow 0
3643793 1908487 1908487 defendant Wallar John yeoman 586208 586208 Wallar, John, of Hereford, yeoman 1
3645235 1908916 1908916 defendant Walwyn Nicholas clerk 586208 586208 Walwyn, Nicholas, of Hereford, clerk 2
3645550 1909005 1909005 defendant Caldecot William tailor 586208 586208 Caldecot, William, of Hereford, tailor 1
3645613 1909024 1909024 defendant Walwyn Nicholas clerk 586208 586208 Walwyn, Nicholas, of Hereford, clerk 2
3646547 1909321 1909321 defendant Bele Roger draper 586208 586208 Bele, Roger, of Hereford, draper 0
3649010 1910078 1910078 defendant Butler Thomas (legal representative) 586208 586208 Butler, Thomas, of Hereford, yeoman, executrix of 0
3649011 1910078 1910078 defendant Butler Alice widow 586208 586208 Butler, Alice, of Hereford, widow 1
3651268 1910764 1910764 defendant Horton William goldsmith 586208 586208 Horton, William, of Hereford, goldsmith 0
3651711 1910891 1910891 defendant Wallewyn Nicholas clerk 586208 586208 Wallewyn, Nicholas, of Hereford, clerk 0
3655194 1911882 1911882 defendant Edwardes alias Baker Richard yeoman 586208 586208 Edwardes alias Baker, Richard, of Hereford, yeoman 2
3655711 1912046 1912046 defendant ap Richard David chaplain 586208 586208 ap Richard, David, of Hereford, chaplain 1
3656323 1912222 1912222 defendant Delavere or Delabere William clerk and Canon residentiary of Hereford Cathedral 586208 586208 Delavere or Delabere, William, of Hereford, clerk and Canon residentiary of Hereford Cathedral 0
3659556 1913250 1913250 defendant Haynes William husbandman 586208 586208 Haynes, William, of Hereford, husbandman 0
3662462 1914172 1914172 defendant Delavere or Delabere William clerk and Canon residentiary of Hereford Cathedral 586208 586208 Delavere or Delabere, William, of Hereford, clerk and Canon residentiary of Hereford Cathedral 0
3666227 1915386 1915386 defendant Dyer John weaver 586208 586208 Dyer, John, of Hereford, weaver 0
3666229 1915387 1915387 defendant Dyer John weaver 586208 586208 Dyer, John, of Hereford, weaver 0
3670129 1916604 1916604 defendant Chippenham Henry (legal representative) 586208 586208 Chippenham, Henry, of Hereford, esq, executrix of 0
3670130 1916604 1916604 defendant Chippenham Sybil widow 586208 586208 Chippenham, Sybil, of Hereford, widow 1
3670132 1916605 1916605 defendant Chippenham Henry (legal representative) 586208 586208 Chippenham, Henry, of Hereford, executrix of 0
3670133 1916605 1916605 defendant Chipenham Sybil widow 586208 586208 Chipenham, Sybil, of Hereford, widow 1
3671010 1916906 1916906 defendant Williams John skinner 586208 586208 Williams, John, of Hereford, skinner 0
3671012 1916906 1916906 defendant Brugge Thomas yeoman 586208 586208 Brugge, Thomas, of Hereford, yeoman 2
3671387 1917028 1917028 defendant Jonys David husbandman 586208 586208 Jonys, David, of Hereford, husbandman 2
3671388 1917028 1917028 defendant Chalnor Lewis weaver 586208 586208 Chalnor, Lewis, of Hereford, weaver 3
3677470 1919004 1919004 defendant Bromefeld Richard clerk 586208 586208 Bromefeld, Richard, of Hereford, clerk 2
3677477 1919005 1919005 defendant Bromefeld Richard clerk 586208 586208 Bromefeld, Richard, of Hereford, clerk 2
3678204 1919236 1919236 defendant Warnestrawe Vincent mercer 586208 586208 Warnestrawe, Vincent, of Hereford, mercer 0
3678734 1919415 1919415 defendant Meredith Bedone tailor 586208 586208 Meredith, Bedone, of Hereford, tailor 1
3678737 1919416 1919416 defendant Meredyth Bedone tailor 586208 586208 Meredyth, Bedone, of Hereford, tailor 1
3679716 1919724 1919724 defendant Warmynster Vincent mercer 586208 586208 Warmynster, Vincent, of Hereford, mercer 0
3679718 1919725 1919725 defendant Warmystrawe Vincent mercer 586208 586208 Warmystrawe, Vincent, of Hereford, mercer 0
3683643 1921015 1921015 defendant Semper Thomas yeoman 586208 586208 Semper, Thomas, of Hereford, yeoman 0
3683653 1921018 1921018 defendant Semper Thomas yeoman 586208 586208 Semper, Thomas, of Hereford, yeoman 0
3685641 1921664 1921664 defendant Mower Roger baker 586208 586208 Mower, Roger, of Hereford, baker 2
3686650 1921978 1921978 defendant Carpynter Robert draper 586208 586208 Carpynter, Robert, of Hereford, draper 0
3690215 1923098 1923098 defendant Dyer John, junior weaver 586208 586208 Dyer, John, junior, of Hereford, weaver 0
3690280 1923122 1923122 plaintiff Gebons Thomas   586208 586208 Gebons, Thomas, of Hereford 0
3690639 1923238 1923238 defendant Yemans John glover 586208 586208 Yemans, John, of Hereford, glover 0
3692124 1923706 1923706 defendant Nevell Richard vintner 586208 586208 Nevell, Richard, of Hereford, vintner 0
3695898 1924954 1924954 defendant Bourghill William clerk 586208 586208 Bourghill, William, of Hereford, clerk 0
3696254 1925050 1925050 defendant Fuller Henry fishmonger 586208 586208 Fuller, Henry, of Hereford, fishmonger 0
3698242 1925673 1925673 defendant Hewet Thomas yeoman 586208 586208 Hewet, Thomas, of Hereford, yeoman 0
3698377 1925712 1925712 defendant Chippynham Sybil widow 586208 586208 Chippynham, Sybil, of Hereford, widow 0
3698379 1925713 1925713 defendant Chippynham Sybil widow 586208 586208 Chippynham, Sybil, of Hereford, widow 0
3698452 1925736 1925736 defendant Norreys Edmund yeoman 586208 586208 Norreys, Edmund, of Hereford, yeoman 0
3698677 1925802 1925802 defendant Beyngham Richard gent 586208 586208 Beyngham, Richard, of Hereford, gent 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);