names

434 rows where place_id = 586397

✎ 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
3588619 1864084 1864084 defendant Palmer Robert laborer 586397 586397 Palmer, Robert, of Morton, laborer 3
3588692 1864107 1864107 defendant Harpe Richard husbandman 586397 586397 Harpe, Richard, of Morton, husbandman 0
3588693 1864107 1864107 defendant Curtes John yeoman 586397 586397 Curtes, John, of Morton, yeoman 1
3595507 1866229 1866229 defendant Kebbe William laborer 586397 586397 Kebbe, William, of Morton, laborer 2
3595508 1866229 1866229 defendant Knebbe John baker 586397 586397 Knebbe, John, of Morton, baker 3
3595509 1866229 1866229 defendant Curteys John weaver 586397 586397 Curteys, John, of Morton, weaver 4
3595638 1866261 1866261 defendant Gryffyn John husbandman 586397 586397 Gryffyn, John, of Morton, husbandman 3
3599969 1867645 1867645 defendant Gryffyn John husbandman 586397 586397 Gryffyn, John, of Morton, husbandman 2
3617040 1872952 1872952 defendant Clerk John husbandman 586397 586397 Clerk, John, of Morton, husbandman 0
3617043 1872953 1872953 defendant Clerk John husbandman 586397 586397 Clerk, John, of Morton, husbandman 0
3619331 1873643 1873643 defendant Taillour John laborer 586397 586397 Taillour, John, of Morton, laborer 21
3629376 1904043 1904043 defendant Selers Richard laborer 586397 586397 Selers, Richard, of Morton, laborer 15
3631288 1904600 1904600 defendant Morecroft Richard laborer 586397 586397 Morecroft, Richard, of Morton, laborer 0
3638375 1906821 1906821 defendant Crosse John clerk 586397 586397 Crosse, John, of Morton, clerk 1
3642754 1908182 1908182 defendant Wryght Thomas husbandman 586397 586397 Wryght, Thomas, of Morton, husbandman 0
3647638 1909646 1909646 defendant Jones Roger husbandman 586397 586397 Jones, Roger, of Morton, husbandman 3
3654957 1911812 1911812 defendant Kyllyngworth Curthbert brewer 586397 586397 Kyllyngworth, Curthbert, of Morton, yeoman, Gylyg, Thomas, of Redyng, brewer 1
3659559 1913250 1913250 defendant Coke Richard husbandman 586397 586397 Coke, Richard, of Morton, husbandman 3
3672138 1917284 1917284 defendant Kyng William husbandman 586397 586397 Kyng, William, of Morton, husbandman 0
3673352 1917681 1917681 defendant (not given) Humphrey rector of Stowell 586397 586397 Stowell, Humphrey, of Morton, clerk, rector of Matton 0
3675234 1918290 1918290 defendant Byke William husbandman 586397 586397 Byke, William, of Morton, husbandman 0
3679079 1919525 1919525 defendant Charlys John (legal representative) 586397 586397 Charlys, John, of Morton, yeoman, executrix of 0
3679080 1919525 1919525 defendant Charlys Alice widow 586397 586397 Charlys, Alice, of Morton, widow 1
3690110 1923068 1923068 defendant Randolff Richard husbandman 586397 586397 Randolff, Richard, of Morton, husbandman 4
3700085 1926258 1926258 defendant Brugge John   586397 586397 Brugge, John, of Morton clerk 0
3712160 1930121 1930121 defendant Payn Richard husbandman 586397 586397 Payn, Richard, of Morton, husbandman 1
3717472 1931749 1931749 defendant Mason William husbandman 586397 586397 Mason, William, of Morton, husbandman 0
3719664 1932417 1932417 plaintiff Harrys Thomas   586397 586397 Harrys, Thomas, of Morton 0
3723125 1933499 1933499 defendant Bremylcombe John husbandman 586397 586397 Bremylcombe, John, of Morton, husbandman 0
3733522 1936728 1936728 defendant Strynger Richard clerk 586397 586397 Strynger, Richard, of Morton, clerk 0
3735408 1937311 1937311 plaintiff Harrys Thomas   586397 586397 Harrys, Thomas, of Morton 0
3749637 1941800 1941800 defendant Thurstone John husbandman 586397 586397 Thurstone, John, of Morton, husbandman 0
3750615 1942112 1942112 defendant Page John husbandman 586397 586397 Page, John, of Morton, husbandman 0
3763313 1946158 1946158 defendant Page John husbandman 586397 586397 Page, John, of Morton, husbandman 3
3792732 1955580 1955580 defendant Townerowe William yeoman 586397 586397 Townerowe, William, of Morton, yeoman 0
3793422 1955808 1955808 defendant Townerowe William yeoman 586397 586397 Townerowe, William, of Morton, yeoman 0
3796874 1956900 1956900 defendant Townerowe William yeoman 586397 586397 Townerowe, William, of Morton, yeoman 0
3798119 1957307 1957307 defendant Page John husbandman 586397 586397 Page, John, of Morton, husbandman 4
3799099 1957628 1957628 defendant Townerowe William yeoman 586397 586397 Townerowe, William, of Morton, yeoman 0
3802171 1958575 1958575 defendant Crosse John clerk 586397 586397 Crosse, John, of Morton, clerk 2
3803601 1959040 1959040 defendant Townerowe William yeoman 586397 586397 Townerowe, William, of Morton, yeoman 0
3807432 1960229 1960229 defendant Page John husbandman 586397 586397 Page, John, of Morton, husbandman 0
3807437 1960230 1960230 defendant Page John husbandman 586397 586397 Page, John, of Morton, husbandman 0
3810738 1961258 1961258 defendant Henond or Hevond Richard husbandman 586397 586397 Henond or Hevond, Richard, of Morton, husbandman 0
3810739 1961258 1961258 defendant Henond or Hevond Thomas husbandman 586397 586397 Henond or Hevond, Thomas, of Morton, husbandman 1
3815449 1962749 1962749 defendant Crosse John clerk 586397 586397 Crosse, John, of Morton, clerk 0
3818233 1963618 1963618 defendant Page John husbandman 586397 586397 Page, John, of Morton, husbandman 1
3830691 1967483 1967483 defendant Townerowe William yeoman 586397 586397 Townerowe, William, of Morton, yeoman 0
3836406 1969296 1969296 defendant Townerowe William yeoman 586397 586397 Townerowe, William, of Morton, yeoman 0
3842633 1971225 1971225 defendant Heynond Richard husbandman 586397 586397 Heynond, Richard, of Morton, husbandman 0
3842634 1971225 1971225 defendant Heynond Thomas husbandman 586397 586397 Heynond, Thomas, of Morton, husbandman 1
3845805 1972238 1972238 defendant Repynghale Thomas gent 586397 586397 Repynghale, Thomas, of Morton, gent 0
3858598 1976363 1976363 defendant Townerowe William yeoman 586397 586397 Townerowe, William, of Morton, yeoman 0
3864275 1978245 1978245 defendant Rewe Richard merchant 586397 586397 Rewe, Richard, of Morton, merchant 0
3866858 1979152 1979152 defendant Alyf John weaver 586397 586397 Alyf, John, of Morton, weaver 0
3866873 1979159 1979159 defendant Townerowe William yeoman 586397 586397 Townerowe, William, of Morton, yeoman 0
3880816 1983853 1983853 plaintiff Repynghale Thomas esq 586397 586397 Repynghale, Thomas, of Morton, esq 0
3880818 1983854 1983854 plaintiff Repynghale Thomas esq 586397 586397 Repynghale, Thomas, of Morton, esq 0
3882847 1984529 1984529 defendant Norys John husbandman 586397 586397 Norys, John, of Morton, husbandman 0
3882848 1984529 1984529 defendant Walys Henry husbandman 586397 586397 Walys, Henry, of Morton, husbandman 1
3882849 1984529 1984529 defendant Shoyle James husbandman 586397 586397 Shoyle, James, of Morton, husbandman 2
3883296 1984677 1984677 plaintiff Warde William   586397 586397 Warde, William, of Morton 0
3883298 1984678 1984678 plaintiff Warde William   586397 586397 Warde, William, of Morton 0
3885074 1985268 1985268 defendant Hamond Richard, junior butcher 586397 586397 Hamond, Richard, junior, of Morton juxta Leomynster, butcher 1
3887374 1986041 1986041 defendant Kyrke Thomas husbandman 586397 586397 Kyrke, Thomas, of Morton, husbandman 0
3898065 1989562 1989562 defendant Kyrke Thomas yeoman 586397 586397 Kyrke, Thomas, of Morton, yeoman 0
3898067 1989563 1989563 defendant Kyrke Thomas yeoman 586397 586397 Kyrke, Thomas, of Morton, yeoman 0
3900244 1990309 1990309 defendant Cosyn William   586397 586397 Cosyn, William, of Morton, horse courser 1
3907305 1992737 1992737 defendant Bygegood William husbandman 586397 586397 Bygegood, William, of Morton, husbandman 0
3924763 1998600 1998600 defendant Petre William husbandman 586397 586397 Petre, William, of Morton, husbandman 1
3925619 1998880 1998880 defendant Ball Lewis husbandman 586397 586397 Ball, Lewis, of Morton, husbandman 0
3925620 1998880 1998880 defendant Johnson Richard husbandman 586397 586397 Johnson, Richard, of Morton, husbandman 1
3925621 1998880 1998880 defendant Wever Thomas laborer 586397 586397 Wever, Thomas, of Morton, laborer 2
3929594 2000248 2000248 plaintiff Kyng Robert   586397 586397 Kyng, Robert, of Morton 1
3941297 2004094 2004094 defendant Philip Mancel husbandman 586397 586397 Philip, Mancel, of Morton, husbandman 0
3941298 2004094 2004094 defendant Harryson John husbandman 586397 586397 Harryson, John, of Morton, husbandman 1
3941300 2004094 2004094 defendant Burley Margaret widow 586397 586397 Burley, Margaret, of Morton, widow 3
3941302 2004095 2004095 defendant Philip Mauncelin husbandman 586397 586397 Philip, Mauncelin, of Morton, husbandman 0
3946722 2005920 2005920 plaintiff Kynge Robert   586397 586397 Kynge, Robert, of Morton 1
3955963 2009156 2009156 defendant Ward Thomas husbandman 586397 586397 Ward, Thomas, of Morton, husbandman 1
3957223 2009591 2009591 defendant Staple Thomas yeoman 586397 586397 Staple, Thomas, of Morton, yeoman 1
3957224 2009591 2009591 defendant Thornton James yeoman 586397 586397 Thornton, James, of Morton, yeoman 2
3958661 2010104 2010104 defendant Henderwell William husbandman 586397 586397 Henderwell, William, of Morton, husbandman 2
3969086 2013801 2013801 defendant Colsye Richard husbandman 586397 586397 Colsye, Richard, of Morton, husbandman 1
3970156 2014160 2014160 defendant Netleton John gent 586397 586397 Netleton, John, of Morton, gent 0
3990741 2021443 2021443 defendant Wykes George gent 586397 586397 Wykes, George, of Morton, gent 0
3992386 2022043 2022043 defendant Kynaston Roger   586397 586397 Kynaston, Roger, of Morton, Salop gent 0
4011524 2028875 2028875 defendant Godfrey William husbandman 586397 586397 Godfrey, William, of Morton, husbandman 0
4012650 2029248 2029248 defendant Kynge Robert yeoman 586397 586397 Kynge, Robert, of Morton, yeoman 3
4018451 2031332 2031332 plaintiff Urrey Thomas   586397 586397 Urrey, Thomas, of Morton 0
4028350 2034790 2034790 plaintiff Cony Richard merchant of the staple 586397 586397 Cony, Richard, of Morton, merchant of the staple 0
4054217 2043893 2043893 defendant Warton Thomas yeoman 586397 586397 Warton, Thomas, of Morton, yeoman 1
4054362 2043951 2043951 defendant Bennett Andrew yeoman 586397 586397 Bennett, Andrew, of Morton, yeoman 0
4054363 2043951 2043951 defendant Hill Richard weaver 586397 586397 Hill, Richard, of Morton, weaver 1
4054364 2043951 2043951 defendant Potter John yeoman 586397 586397 Potter, John, of Morton, yeoman 2
4058726 2045514 2045514 plaintiff Clarke Thomas gent 586397 586397 Clarke, Thomas, of Morton, or of Derenton, Durham, gent 0
4082872 2054174 2054174 defendant ap Richard William gent 586397 586397 ap Richard, William, of Morton, gent 2
4082876 2054175 2054175 defendant ap Richard William gent 586397 586397 ap Richard, William, of Morton, gent 2
4083908 2054520 2054520 defendant Warten Thomas yeoman 586397 586397 Warten, Thomas, of Morton, yeoman 0
4086581 2055487 2055487 defendant Stowe Robert husbandman 586397 586397 Stowe, Robert, of Morton, husbandman 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);