names

528 rows where place_id = 586459

✎ 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
3588776 1864133 1864133 defendant Thorp Thomas gent 586459 586459 Thorp, Thomas, of Stoke, gent 0
3588778 1864133 1864133 defendant Bothomley John laborer 586459 586459 Bothomley, John, of Stoke, laborer 2
3597276 1866767 1866767 defendant Hopkyns Henry husbandman 586459 586459 Hopkyns, Henry, of Stoke, husbandman 0
3597507 1866842 1866842 defendant Hopkyns Henry husbandman 586459 586459 Hopkyns, Henry, of Stoke, husbandman 0
3603183 1868661 1868661 defendant Knappe John husbandman 586459 586459 (Knappe, John, of Stoke, husbandman 1
3605169 1869281 1869281 defendant Barley homas   586459 586459 Barley, homas, of Stoke, Derbsm gent 1
3606537 1869716 1869716 defendant Gyles William yeoman 586459 586459 Gyles, William, of Stoke, yeoman 1
3614070 1872064 1872064 defendant Gee Geoffrey husbandman 586459 586459 Gee, Geoffrey, of Stoke, or of Newerk, husbandman 0
3614428 1872162 1872162 defendant Cost or Coft Richard waterman 586459 586459 Cost or Coft, Richard, of Stoke, waterman 0
3614758 1872264 1872264 defendant Uvedale Thomas gent 586459 586459 Uvedale, Thomas, of Stoke juxta Winchester, gent 1
3619582 1873692 1873692 defendant Cost or Coft Richard waterman 586459 586459 Cost or Coft, Richard, of Stoke, waterman 0
3621288 1874199 1874199 defendant Smyth John husbandman 586459 586459 Smyth, John, of Stoke, husbandman 0
3623140 1874759 1874759 defendant Nycoll John husbandman 586459 586459 Nycoll, John, of Stoke, husbandman 2
3623490 1874879 1874879 defendant Byrdeporte Robert gent 586459 586459 Byrdeporte, Robert, of Stoke, gent 1
3624060 1875055 1875055 defendant Oforth Simon clothier 586459 586459 Oforth, Simon, of Stoke under Myndepe, clothier 0
3629178 1903994 1903994 defendant Hyll John husbandman 586459 586459 Hyll, John, of Stoke juxta Leomynster, husbandman 0
3629179 1903994 1903994 defendant Phylyppys John laborer 586459 586459 Phylyppys, John, of Stoke juxta Leomynster, laborer 1
3642007 1907949 1907949 defendant Rogers John husbandman 586459 586459 Rogers, John, of Stoke juxta Leomynster, husbandman 2
3642009 1907949 1907949 defendant Cole John husbandman 586459 586459 (Cole, John, of Stoke juxta Leomynster, husbandman 4
3643957 1908539 1908539 defendant Hewester Philip laborer 586459 586459 Hewester, Philip, of Stoke, laborer 1
3644197 1908618 1908618 defendant Axe Thomas, junior husbandman 586459 586459 Axe, Thomas, junior, of Stoke under Hamedon, husbandman 0
3647018 1909467 1909467 plaintiff Hall Thomas   586459 586459 Hall, Thomas, of Stoke 2
3650456 1910510 1910510 defendant Hove John husbandman 586459 586459 Hove, John, of Stoke, husbandman 0
3653129 1911310 1911310 defendant Thorne William husbandman 586459 586459 Thorne, William, of Stoke under Hamden, husbandman 0
3653130 1911310 1911310 defendant Thomas David yeoman 586459 586459 Thomas, David, of Stoke under Hamden, yeoman 1
3655544 1911993 1911993 defendant Andrew John   586459 586459 Andrew, John, of Stoke, groom 0
3655690 1912042 1912042 defendant Marston William husbandman 586459 586459 Marston, William, of Stoke Prior, husbandman 2
3655691 1912042 1912042 defendant Cheelyngeworth William husbandman 586459 586459 Cheelyngeworth, William, of Stoke Prior, husbandman 3
3655692 1912042 1912042 defendant Pakeman Thomas husbandman 586459 586459 Pakeman, Thomas, of Stoke Prior, husbandman 4
3657589 1912636 1912636 plaintiff Danys Thomas (legal representative) 586459 586459 Danys, Thomas, of Stoke St Edward, yeoman, executor of 0
3659432 1913210 1913210 defendant Pope John   586459 586459 Pope, John, of Stoke husbandman 3
3660842 1913658 1913658 defendant Iden Robert gent 586459 586459 Iden, Robert, of Stoke, gent 0
3667973 1915923 1915923 defendant Randyll Humphrey yeoman 586459 586459 Randyll, Humphrey, of Stoke, yeoman 1
3667976 1915924 1915924 defendant Randyll Humphrey yeoman 586459 586459 Randyll, Humphrey, of Stoke, yeoman 1
3668024 1915938 1915938 defendant Bothomley Robert husbandman 586459 586459 Bothomley, Robert, of Stoke juxta Newer, husbandman 1
3672473 1917391 1917391 defendant Downe Robert laborer 586459 586459 Downe, Robert, of Stoke, laborer 0
3672474 1917391 1917391 defendant Clerke John husbandman 586459 586459 Clerke, John, of Stoke, husbandman 1
3673073 1917586 1917586 defendant Bradshawe Roger   586459 586459 Bradshawe, Roger, of Stoke 1
3675341 1918325 1918325 defendant Gilbert John husbandman 586459 586459 Gilbert, John, of Stoke Prior, husbandman 4
3679492 1919654 1919654 defendant Dowghty John husbandman 586459 586459 Dowghty, John, of Stoke, husbandman 0
3682863 1920749 1920749 defendant Carowe Robert laborer 586459 586459 Carowe, Robert, of Stoke, laborer 0
3685598 1921648 1921648 defendant Hathe John, senior husbandman 586459 586459 Hathe, John, senior, of Stoke, husbandman 3
3688168 1922450 1922450 defendant Pertriche Hugh chaplain 586459 586459 Pertriche, Hugh, of Stoke, chaplain 1
3691443 1923481 1923481 defendant Gonner William yeoman 586459 586459 Gonner, William, of Stoke, yeoman 5
3698729 1925819 1925819 plaintiff Wayle John yeoman 586459 586459 Wayle, John, of Stoke, yeoman 0
3698730 1925819 1925819 plaintiff Purser John yeoman 586459 586459 Purser, John, of Stoke, yeoman 1
3698731 1925819 1925819 plaintiff Arnold John   586459 586459 Arnold, John, of Stoke 2
3701964 1926866 1926866 defendant Hamond John husbandman 586459 586459 Hamond, John, of Stoke, husbandman 1
3707092 1928505 1928505 defendant Morley William husbandman 586459 586459 Morley, William, of Stoke, husbandman 4
3711016 1929755 1929755 defendant Hiller Richard husbandman 586459 586459 Hiller, Richard, of Stoke Prior, husbandman 2
3717790 1931865 1931865 defendant Hyller Thomas husbandman 586459 586459 Hyller, Thomas, of Stoke Prior, husbandman 1
3720053 1932546 1932546 defendant Barrett Isabel widow 586459 586459 Barrett, Isabel, of Stoke, widow 0
3728679 1935208 1935208 defendant Bayle Roger husbandman 586459 586459 Bayle, Roger, of Stoke, husbandman 2
3733550 1936738 1936738 defendant Elston Robert, senior laborer 586459 586459 Elston, Robert, senior, of Stoke, laborer 0
3734114 1936917 1936917 defendant Smale Richard husbandman 586459 586459 Smale, Richard, of Stoke, husbandman 16
3739119 1938443 1938443 defendant Hyller Hugh husbandman 586459 586459 Hyller, Hugh, of Stoke Prior, husbandman 2
3740248 1938806 1938806 defendant Rothewell John clerk 586459 586459 Rothewell, John, of Stoke, clerk 2
3740594 1938917 1938917 defendant Hyller Hugh   586459 586459 Hyller, Hugh, of Stoke Prior, husbandman, son of Hyllar, William 0
3741700 1939269 1939269 defendant Wogarde John, junior husbandman 586459 586459 Wogarde, John, junior, of Stoke, husbandman 1
3741701 1939269 1939269 defendant Wogarde John, senior husbandman 586459 586459 Wogarde, John, senior, of Stoke, husbandman 2
3743096 1939694 1939694 defendant Gylbert John husbandman 586459 586459 Gylbert, John, of Stoke Prior, husbandman 1
3743867 1939967 1939967 defendant Arnold Edmund tailor 586459 586459 Arnold, Edmund, of Stoke, tailor 0
3744096 1940050 1940050 defendant Dryver William butcher 586459 586459 Dryver, William, of Stoke, butcher 1
3748216 1941370 1941370 defendant Hamon Thomas husbandman 586459 586459 Hamon, Thomas, of Stoke, husbandman 0
3748217 1941370 1941370 defendant Harman John beer brewer 586459 586459 Harman, John, of Stoke, beer brewer 1
3748218 1941370 1941370 defendant Lancaster John tailor 586459 586459 Lancaster, John, of Stoke, tailor 2
3748219 1941370 1941370 defendant Rason John husbandman 586459 586459 Rason, John, of Stoke, husbandman 3
3748220 1941370 1941370 defendant Coston Andrew husbandman 586459 586459 Coston, Andrew, of Stoke, husbandman 4
3749995 1941916 1941916 defendant Baylly John husbandman 586459 586459 Baylly, John, of Stoke Prior, husbandman 0
3756342 1943951 1943951 defendant Bothomley Robert husbandman 586459 586459 Bothomley, Robert, of Stoke, husbandman 0
3756343 1943951 1943951 defendant Stafford John husbandman 586459 586459 Stafford, John, of Stoke, husbandman 1
3757367 1944283 1944283 plaintiff Berley George gent 586459 586459 Berley, George, of Stoke, gent 0
3764328 1946505 1946505 defendant Awberte John yeoman 586459 586459 Awberte, John, of Stoke Prior, yeoman 2
3768113 1947663 1947663 defendant Baylys Thomas husbandman 586459 586459 Baylys, Thomas, of Stoke Prior, husbandman 0
3768386 1947757 1947757 defendant Chapman William husbandman 586459 586459 Chapman, William, of Stoke, husbandman 0
3771872 1948892 1948892 defendant Browne Richard husbandman 586459 586459 Browne, Richard, of Stoke, husbandman 0
3780365 1951591 1951591 defendant Percy John gent 586459 586459 Percy, John, of Stoke, gent 0
3782241 1952198 1952198 plaintiff Holte Thomas clothmaker 586459 586459 Holte, Thomas, of Stoke, clothmaker 0
3785847 1953363 1953363 defendant Hyllar Hugh husbandman 586459 586459 Hyllar, Hugh, of Stoke Prior, husbandman 0
3785849 1953363 1953363 defendant Yardyngton John husbandman 586459 586459 Yardyngton, John, of Stoke Prior, husbandman 2
3785900 1953381 1953381 defendant Reynold John mercer 586459 586459 Reynold, John, of Stoke, mercer 0
3793361 1955785 1955785 defendant Wayll John yeoman 586459 586459 Wayll, John, of Stoke, yeoman 0
3794263 1956077 1956077 defendant Lardman William yeoman 586459 586459 Lardman, William, of Stoke, yeoman 1
3794939 1956282 1956282 defendant Cokys Henry miller 586459 586459 Cokys, Henry, of Stoke Prior, miller 0
3794940 1956282 1956282 defendant Cristover William husbandman 586459 586459 Cristover, William, of Stoke Prior, husbandman 1
3794941 1956282 1956282 defendant Hodbache John husbandman 586459 586459 Hodbache, John, of Stoke Prior, husbandman 2
3797543 1957124 1957124 defendant Man William husbandman 586459 586459 Man, William, of Stoke Archer, husbandman 4
3797733 1957189 1957189 defendant Hanbach Richard husbandman 586459 586459 Hanbach, Richard, of Stoke Archer, husbandman 1
3797734 1957189 1957189 defendant Grome John laborer 586459 586459 Grome, John, of Stoke Archer, laborer 2
3810183 1961076 1961076 defendant Way- John yeoman 586459 586459 Way-, John, of Stoke, yeoman 0
3811631 1961536 1961536 defendant Shepey Humphrey husbandman 586459 586459 Shepey, Humphrey, of Stoke Prior, husbandman 0
3812008 1961664 1961664 defendant Cokys Henry miller 586459 586459 Cokys, Henry, of Stoke Prior, miller 0
3812009 1961664 1961664 defendant Cristofer William husbandman 586459 586459 Cristofer, William, of Stoke Prior, husbandman 1
3812010 1961664 1961664 defendant Hodbache John husbandman 586459 586459 Hodbache, John, of Stoke Prior, husbandman 2
3814623 1962483 1962483 defendant Mason Walter husbandman 586459 586459 Mason, Walter, of Stoke, husbandman 1
3819349 1963937 1963937 defendant Traves William husbandman 586459 586459 Traves, William, of Stoke, husbandman 2
3819350 1963937 1963937 defendant Frane William husbandman 586459 586459 Frane, William, of Stoke, husbandman 3
3819351 1963937 1963937 defendant Wellys John husbandman 586459 586459 Wellys, John, of Stoke, husbandman 4
3819757 1964058 1964058 defendant Smyth Roger husbandman 586459 586459 Smyth, Roger, of Stoke Prior, husbandman 3
3823956 1965365 1965365 defendant Stoke Robert esq 586459 586459 Stoke, Robert, of Stoke, esq 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);