names

369 rows where place_id = 593282

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611178 1871173 1871173 defendant Granyn or Gravyn John clerk 593282 593282 Granyn or Gravyn, John, of Drayton, clerk 1
3613050 1871734 1871734 defendant Freman Thomas yeoman 593282 593282 Freman, Thomas, of Drayton under Visiard, yeoman 0
3614652 1872234 1872234 defendant Grevyle John esq 593282 593282 Grevyle, John, of Drayton, esq 0
3617209 1873006 1873006 defendant Cravyn or Cranyn John clerk 593282 593282 Cravyn or Cranyn, John, of Drayton, clerk 0
3620485 1873984 1873984 defendant Warne Nicholas husbandman 593282 593282 Warne, Nicholas, of Drayton, husbandman 0
3640889 1907594 1907594 defendant Smyth John husbandman 593282 593282 Smyth, John, of Drayton, husbandman 2
3640890 1907594 1907594 defendant Smyth William husbandman 593282 593282 Smyth, William, of Drayton, husbandman 3
3646326 1909242 1909242 defendant Lerer Edward husbandman 593282 593282 Lerer, Edward, of Drayton, husbandman 0
3649529 1910242 1910242 defendant Clare John husbandman 593282 593282 Clare, John, of Drayton, husbandman 2
3649533 1910243 1910243 defendant Clare John husbandman 593282 593282 Clare, John, of Drayton, husbandman 2
3656885 1912410 1912410 defendant Hill William yeoman 593282 593282 Hill, William, of Drayton, yeoman 0
3668192 1915999 1915999 defendant Banaster Andrew yeoman 593282 593282 Banaster, Andrew, of Drayton, yeoman 0
3668764 1916166 1916166 defendant Thomlynson William, senior husbandman 593282 593282 Thomlynson, William, senior, of Drayton, husbandman 0
3678637 1919379 1919379 defendant Hyll Humphrey gent 593282 593282 Hyll, Humphrey, of Drayton, gent 0
3680970 1920126 1920126 defendant Gregory Thomas husbandman 593282 593282 Gregory, Thomas, of Drayton, husbandman 0
3706016 1928173 1928173 defendant Spencer Thomas mealman 593282 593282 Spencer, Thomas, of Drayton, mealman 1
3706017 1928173 1928173 defendant Bowes Clement mealman 593282 593282 Bowes, Clement, of Drayton, mealman 2
3709704 1929346 1929346 defendant Rogers Stephen husbandman 593282 593282 Rogers, Stephen, of Drayton, husbandman 0
3709705 1929346 1929346 defendant Catte Robert husbandman 593282 593282 Catte, Robert, of Drayton, husbandman 1
3732970 1936533 1936533 defendant Warnys John husbandman 593282 593282 Warnys, John, of Drayton, husbandman 4
3736642 1937712 1937712 defendant Smyth Thomas yeoman 593282 593282 Smyth, Thomas, of Drayton, yeoman 0
3738668 1938304 1938304 plaintiff Mynton John   593282 593282 Mynton, John, of Drayton 0
3742934 1939640 1939640 defendant Webster Geoffrey husbandman 593282 593282 Webster, Geoffrey, of Drayton, husbandman 0
3743583 1939869 1939869 plaintiff Worthy John, senior   593282 593282 Worthy, John, senior, of Drayton 0
3767934 1947608 1947608 defendant Colley John tanner 593282 593282 Colley, John, of Drayton, tanner 0
3772080 1948958 1948958 defendant Hurne Nicholas husbandman 593282 593282 Hurne, Nicholas, of Drayton, husbandman 4
3789075 1954393 1954393 defendant Gade Henry husbandman 593282 593282 Gade, Henry, of Drayton, husbandman 0
3794182 1956051 1956051 defendant Coke William butcher 593282 593282 Coke, William, of Drayton, butcher 2
3815068 1962634 1962634 defendant Hyrne Nicholas yeoman 593282 593282 Hyrne, Nicholas, of Drayton, yeoman 0
3815069 1962634 1962634 defendant Kempe William, senior husbandman 593282 593282 Kempe, William, senior, of Drayton, husbandman 1
3815569 1962786 1962786 defendant Lucas Henry husbandman 593282 593282 Lucas, Henry, of Drayton, husbandman 1
3817651 1963423 1963423 plaintiff Lawes Thomas   593282 593282 Lawes, Thomas, of Drayton 0
3817653 1963424 1963424 plaintiff Lawes Thomas   593282 593282 Lawes, Thomas, of Drayton 0
3825860 1965937 1965937 defendant Assheby Thomas husbandman 593282 593282 Assheby, Thomas, of Drayton, husbandman 2
3825861 1965937 1965937 defendant Horne John tailor 593282 593282 Horne, John, of Drayton, tailor 3
3828546 1966803 1966803 defendant Robyns William husbandman 593282 593282 Robyns, William, of Drayton, husbandman 0
3834601 1968755 1968755 defendant Buller William husbandman 593282 593282 Buller, William, of Drayton, husbandman 1
3840470 1970579 1970579 defendant Hartwell Robert husbandman 593282 593282 Hartwell, Robert, of Drayton, husbandman 4
3840476 1970580 1970580 defendant Hartwell Robert husbandman 593282 593282 Hartwell, Robert, of Drayton, husbandman 4
3843006 1971343 1971343 defendant Bromley Elzabeth   593282 593282 Bromley, Elzabeth, of Drayton, widow of Bromley, Richard 0
3850745 1973825 1973825 plaintiff Mynton John tanner 593282 593282 Mynton, John, of Drayton under Halis, tanner 0
3850757 1973829 1973829 plaintiff Mynton John, senior (legal representative) 593282 593282 Mynton, John, senior, of Drayton, tanner, executor of 0
3859998 1976845 1976845 defendant Lawes Thomas husbandman 593282 593282 Lawes, Thomas, of Drayton, husbandman 1
3860023 1976850 1976850 defendant Lawes Thomas husbandman 593282 593282 Lawes, Thomas, of Drayton, husbandman 0
3862195 1977539 1977539 defendant Assheby William husbandman 593282 593282 Assheby, William, of Drayton, husbandman 0
3862196 1977539 1977539 defendant Clerke Thomas husbandman 593282 593282 Clerke, Thomas, of Drayton, husbandman 1
3863108 1977861 1977861 defendant Assheby Thomas husbandman 593282 593282 Assheby, Thomas, of Drayton, husbandman 0
3863110 1977862 1977862 defendant Assheby Thomas husbandman 593282 593282 Assheby, Thomas, of Drayton, husbandman 0
3863409 1977956 1977956 defendant Alet Thomas husbandman 593282 593282 Alet, Thomas, of Drayton, husbandman 1
3864748 1978405 1978405 defendant Baggelby Thomas husbandman 593282 593282 Baggelby, Thomas, of Drayton, husbandman 1
3870079 1980234 1980234 defendant Kyng William husbandman 593282 593282 Kyng, William, of Drayton, husbandman 1
3874028 1981536 1981536 defendant Mynton John tanner 593282 593282 Mynton, John, of Drayton, tanner 0
3876729 1982458 1982458 defendant Assheby Thomas husbandman 593282 593282 Assheby, Thomas, of Drayton, husbandman 1
3877307 1982654 1982654 defendant Assheby Thomas husbandman 593282 593282 Assheby, Thomas, of Drayton, husbandman 0
3878599 1983091 1983091 defendant Brom John, junior husbandman 593282 593282 Brom, John, junior, of Drayton, husbandman 1
3880856 1983868 1983868 defendant Hyggys John husbandman 593282 593282 Hyggys, John, of Drayton, husbandman 0
3887427 1986060 1986060 defendant Gladon Thomas brickmaker 593282 593282 Gladon, Thomas, of Drayton, brickmaker 1
3894315 1988316 1988316 defendant Grygge John warrener 593282 593282 Grygge, John, of Drayton, warrener 4
3909779 1993580 1993580 defendant Kyng William yeoman 593282 593282 Kyng, William, of Drayton, yeoman 0
3909780 1993580 1993580 defendant Capon Thomas husbandman 593282 593282 Capon, Thomas, of Drayton, husbandman 1
3909782 1993580 1993580 defendant Capon Edward husbandman 593282 593282 Capon, Edward, of Drayton, husbandman 3
3919729 1996937 1996937 defendant Banester John husbandman 593282 593282 Banester, John, of Drayton, Dorchester, husbandman 0
3924069 1998360 1998360 defendant Capys Thomas husbandman 593282 593282 Capys, Thomas, of Drayton, husbandman 2
3942289 2004434 2004434 defendant Davys Joan widow 593282 593282 Davys, Joan, of Drayton, widow 0
3942616 2004537 2004537 defendant Raybold Thomas husbandman 593282 593282 Raybold, Thomas, of Drayton, husbandman 3
3946457 2005828 2005828 defendant Styre William   593282 593282 Styre, William, of Drayton, scythe smith 4
3949384 2006856 2006856 defendant Harman Simon   593282 593282 Harman, Simon, of Drayton, hair weaver 0
3954805 2008749 2008749 defendant Connopp Margaret widow 593282 593282 Connopp, Margaret, of Drayton, widow 0
3954806 2008749 2008749 defendant Parkes Richard, senior yeoman 593282 593282 Parkes, Richard, senior, of Drayton, yeoman 1
3957066 2009538 2009538 defendant Parrat Leonard yeoman 593282 593282 Parrat, Leonard, of Drayton, yeoman 0
3963959 2012002 2012002 plaintiff Andrews John   593282 593282 Andrews, John, of Drayton, rough mason 0
3966854 2013041 2013041 defendant Kyng Hugh husbandman 593282 593282 Kyng, Hugh, of Drayton, husbandman 0
3966855 2013041 2013041 defendant Bateman John husbandman 593282 593282 Bateman, John, of Drayton, husbandman 1
3972766 2015048 2015048 plaintiff Geyle Thomas yeoman 593282 593282 Geyle, Thomas, of Drayton, yeoman 0
3973035 2015138 2015138 defendant Browne Robert husbandman 593282 593282 Browne, Robert, of Drayton, husbandman 3
3977198 2016594 2016594 defendant Browne Robert husbandman 593282 593282 Browne, Robert, of Drayton, husbandman 1
3979780 2017520 2017520 defendant Albecke John yeoman 593282 593282 Albecke, John, of Drayton, yeoman 0
3979782 2017521 2017521 defendant Allcock John yeoman 593282 593282 Allcock, John, of Drayton, yeoman 0
3979784 2017522 2017522 defendant Bratford John yeoman 593282 593282 Bratford, John, of Drayton, yeoman 0
3979786 2017523 2017523 defendant Bratford John yeoman 593282 593282 Bratford, John, of Drayton, yeoman 0
3979788 2017524 2017524 defendant Ellys William yeoman 593282 593282 Ellys, William, of Drayton, yeoman 0
3979790 2017525 2017525 defendant Elys William yeoman 593282 593282 Elys, William, of Drayton, yeoman 0
3979792 2017526 2017526 defendant Goodwyn or Goodyn Henry yeoman 593282 593282 Goodwyn or Goodyn, Henry, of Drayton, yeoman 0
3979794 2017527 2017527 defendant Jarvis Edward yeoman 593282 593282 Jarvis, Edward, of Drayton, yeoman 0
3979796 2017528 2017528 defendant Jarvys Edward yeoman 593282 593282 Jarvys, Edward, of Drayton, yeoman 0
3979798 2017529 2017529 defendant Wickam Joan widow 593282 593282 Wickam, Joan, of Drayton, widow 0
3979800 2017530 2017530 defendant Wickam Joan widow 593282 593282 Wickam, Joan, of Drayton, widow 0
3983756 2018964 2018964 defendant Croyden Robert husbandman 593282 593282 Croyden, Robert, of Drayton, husbandman 0
3984921 2019363 2019363 defendant Jacobbe Henry yeoman 593282 593282 Jacobbe. Henry, of Drayton, yeoman 4
3986916 2020063 2020063 defendant Browne Robert husbandman 593282 593282 Browne, Robert, of Drayton, husbandman 3
3986921 2020064 2020064 defendant Browne Robert husbandman 593282 593282 Browne, Robert, of Drayton, husbandman 3
3987215 2020173 2020173 defendant Pagett Anne widow 593282 593282 Pagett, Anne, of Drayton, widow 0
4015045 2030075 2030075 defendant Blyth John husbandman 593282 593282 Blyth, John, of Drayton, husbandman 6
4037948 2038221 2038221 defendant Blythe John husbandman 593282 593282 Blythe, John, of Drayton, husbandman 2
4059603 2045825 2045825 defendant Symons Thomas husbandman 593282 593282 Symons, Thomas, of Drayton, husbandman 0
4066866 2048446 2048446 defendant Barwell Christopher husbandman 593282 593282 Barwell, Christopher, of Drayton, husbandman 1
4070692 2049816 2049816 defendant Kynge Hugh yeoman 593282 593282 Kynge, Hugh, of Drayton, yeoman 0
4090388 2056847 2056847 defendant Cooke Humphrey laborer 593282 593282 Cooke, Humphrey, of Drayton, laborer 1
4090389 2056847 2056847 defendant Allen Elizabeth spinster 593282 593282 Allen, Elizabeth, of Drayton, spinster 2
4112376 2064685 2064685 defendant Tylney Mathew husbandman 593282 593282 Tylney, Mathew, of Drayton, 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);