names

166 rows where place_id = 590449

✎ 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
3597351 1866791 1866791 defendant Credy John, senior husbandman 590449 590449 Credy, John, senior, of Halberton Abbot, husbandman 0
3601238 1868049 1868049 defendant Daly John yeoman 590449 590449 Daly, John, of Halberton, yeoman 1
3612053 1871413 1871413 defendant Parker John husbandman 590449 590449 Parker, John, of Halberton, husbandman 0
3627514 1903463 1903463 defendant Crosse John   590449 590449 Crosse, John, of Halberton, or of Selake, franklin 0
3633312 1905233 1905233 defendant Crosse John gent 590449 590449 Crosse, John, of Halberton, gent 0
3649181 1910132 1910132 defendant Hoper John mercer 590449 590449 Hoper, John, of Halberton, mercer 0
3669420 1916373 1916373 defendant Sedborough William   590449 590449 Sedborough, William, of Halberton, franklin 0
3675753 1918451 1918451 defendant More William husbandman 590449 590449 More, William, of Halberton, husbandman 0
3686860 1922052 1922052 defendant Waren John tucker 590449 590449 Waren, John, of Halberton, tucker 0
3688219 1922465 1922465 defendant Tournour Nicholas husbandman 590449 590449 Tournour, Nicholas, of Halberton, husbandman 0
3697489 1925434 1925434 defendant Daly Ibota widow 590449 590449 Daly, Ibota, of Halberton, widow 0
3698797 1925841 1925841 defendant Waryn John yeoman 590449 590449 Waryn, John, of Halberton, yeoman 0
3706329 1928266 1928266 defendant Norrys Richard carpenter 590449 590449 Norrys, Richard, of Halberton, carpenter 0
3710282 1929532 1929532 defendant Beare Humphrey yeoman 590449 590449 Beare, Humphrey, of Halberton, yeoman 0
3711674 1929963 1929963 plaintiff Tourner Humphrey (legal representative) 590449 590449 Tourner, Humphrey, of Halberton, executors of 0
3716892 1931570 1931570 defendant Turnour Nicholas husbandman 590449 590449 Turnour, Nicholas, of Halberton, husbandman 0
3717143 1931647 1931647 defendant Turner John husbandman 590449 590449 Turner, John, of Halberton, husbandman 0
3720049 1932544 1932544 defendant More William husbandman 590449 590449 More, William, of Halberton, husbandman 0
3726774 1934640 1934640 defendant Holcombe William husbandman 590449 590449 Holcombe, William, of Halberton, husbandman 0
3726778 1934642 1934642 defendant Holcombe William husbandman 590449 590449 Holcombe, William, of Halberton, husbandman 0
3727345 1934826 1934826 defendant Lake John tucker 590449 590449 Lake, John, of Halberton, tucker 0
3727349 1934828 1934828 defendant Weer John husbandman 590449 590449 Weer, John, of Halberton, husbandman 0
3727352 1934829 1934829 defendant Roo Richard husbandman 590449 590449 Roo, Richard, of Halberton, husbandman 0
3736377 1937619 1937619 defendant More William husbandman 590449 590449 More, William, of Halberton, husbandman 0
3742433 1939504 1939504 plaintiff Turner John (legal representative) 590449 590449 Turner, John, of Halberton, executors of 0
3746763 1940903 1940903 defendant Hoper John yeoman 590449 590449 Hoper, John, of Halberton, yeoman 0
3751852 1942498 1942498 defendant Parker Edward husbandman 590449 590449 Parker, Edward, of Halberton, husbandman 1
3751854 1942498 1942498 defendant Campe John   590449 590449 Campe, John, of Halberton, groom 3
3751857 1942499 1942499 defendant Parker Edward husbandman 590449 590449 Parker, Edward, of Halberton, husbandman 0
3751859 1942499 1942499 defendant Campe John   590449 590449 Campe, John, of Halberton, groom 2
3758491 1944652 1944652 defendant Manlegh John sherman 590449 590449 Manlegh, John, of Halberton, sherman 0
3760179 1945183 1945183 defendant Hoper John yeoman 590449 590449 Hoper, John, of Halberton, yeoman 0
3772093 1948964 1948964 defendant Lewsemore John husbandman 590449 590449 Lewsemore, John, of Halberton, husbandman 0
3772094 1948964 1948964 defendant Merwode Maldwin gent 590449 590449 Merwode, Maldwin, of Halberton, gent 1
3772100 1948965 1948965 defendant Laneman Walter   590449 590449 Laneman, Walter, of Halberton, parish clerk 0
3772692 1949154 1949154 defendant Drewe Thomas husbandman 590449 590449 Drewe, Thomas, of Halberton, husbandman 0
3772694 1949155 1949155 defendant Manleygh Joan widow 590449 590449 Manleygh, Joan, of Halberton, widow 0
3772767 1949175 1949175 defendant Orchard William weaver 590449 590449 Orchard, William, of Halberton, weaver 0
3775318 1950020 1950020 defendant Harry Alice widow 590449 590449 Harry, Alice, of Halberton, widow 0
3775319 1950020 1950020 defendant Harry Michael   590449 590449 Harry, Michael, of Halberton, groom 1
3775320 1950020 1950020 defendant Wodebeare John husbandman 590449 590449 Wodebeare, John, of Halberton, husbandman 2
3776542 1950414 1950414 defendant Manlegh John sherman 590449 590449 Manlegh, John, of Halberton, sherman 0
3778248 1950906 1950906 defendant Hoper John yeoman 590449 590449 Hoper, John, of Halberton, yeoman 0
3786045 1953427 1953427 defendant Sedburgh Joan widow 590449 590449 Sedburgh, Joan, of Halberton, widow 0
3799871 1957877 1957877 defendant Parker Edmund husbandman 590449 590449 Parker, Edmund, of Halberton, husbandman 1
3799958 1957909 1957909 defendant Carslake Joan widow 590449 590449 Carslake, Joan, of Halberton, widow 0
3799959 1957909 1957909 defendant Carslake John   590449 590449 Carslake, John, of Halberton, groom 1
3799960 1957909 1957909 defendant Carslake Edmund   590449 590449 Carslake, Edmund, of Halberton, groom 2
3799961 1957909 1957909 defendant Parker John husbandman 590449 590449 Parker, John, of Halberton, husbandman 3
3807221 1960155 1960155 defendant Hert John tucker 590449 590449 Hert, John, of Halberton, tucker 0
3811936 1961638 1961638 defendant Horne Nicholas husbandman 590449 590449 Horne, Nicholas, of Halberton, husbandman 0
3811937 1961638 1961638 defendant Lovecroft John husbandman 590449 590449 Lovecroft, John, of Halberton, husbandman 1
3819913 1964107 1964107 defendant Sedburgh Joan widow 590449 590449 Sedburgh, Joan, of Halberton, widow 0
3821886 1964735 1964735 defendant Passemer John, junior yeoman 590449 590449 Passemer, John, junior, of Halberton, yeoman 0
3824550 1965552 1965552 defendant Borough Michael husbandman 590449 590449 Borough, Michael, of Halberton, husbandman 0
3824553 1965553 1965553 defendant Wynbowe John smith 590449 590449 Wynbowe, John, of Halberton, smith 0
3826869 1966253 1966253 defendant Turnour Nicholas husbandman 590449 590449 Turnour, Nicholas, of Halberton, husbandman 1
3832260 1968004 1968004 defendant Warre Thomas butcher 590449 590449 Warre, Thomas, of Halberton, butcher 0
3832262 1968005 1968005 defendant Warre Thomas butcher 590449 590449 Warre, Thomas, of Halberton, butcher 0
3838579 1969992 1969992 defendant Turnour alias Pytt John yeoman 590449 590449 Turnour alias Pytt, John, of Halberton, husbandman, yeoman 0
3841297 1970858 1970858 defendant Whythed Ralph husbandman 590449 590449 Whythed, Ralph, of Halberton, husbandman 1
3841298 1970858 1970858 defendant Wer John butcher 590449 590449 Wer, John, of Halberton, butcher 2
3845447 1972135 1972135 defendant Beare Humphrey husbandman 590449 590449 Beare, Humphrey, of Halberton, husbandman 1
3845738 1972215 1972215 defendant Dalegh William husbandman 590449 590449 Dalegh, William, of Halberton, husbandman 0
3848906 1973248 1973248 defendant Parker Edmund husbandman 590449 590449 Parker, Edmund, of Halberton, husbandman 0
3854861 1975165 1975165 defendant Drew John husbandman 590449 590449 Drew, John, of Halberton, husbandman 0
3854862 1975165 1975165 defendant Parker John, senior husbandman 590449 590449 Parker, John, senior, of Halberton, husbandman 1
3855118 1975234 1975234 defendant Styllyerd William yeoman 590449 590449 Styllyerd, William, of Halberton, yeoman 0
3855794 1975443 1975443 defendant Pryll Richard husbandman 590449 590449 Pryll, Richard, of Halberton, husbandman 0
3858689 1976389 1976389 defendant Modyford Robert husbandman 590449 590449 Modyford, Robert, of Halberton, husbandman 0
3861260 1977236 1977236 defendant Beere Humphrey husbandman 590449 590449 Beere, Humphrey, of Halberton, husbandman 1
3863081 1977852 1977852 defendant Broke Joan widow 590449 590449 Broke, Joan, of Halberton, widow 0
3864087 1978172 1978172 defendant Parker Edmund husbandman 590449 590449 Parker, Edmund, of Halberton, husbandman 0
3873164 1981241 1981241 defendant Parker Edmund husbandman 590449 590449 Parker, Edmund, of Halberton, husbandman 0
3877276 1982643 1982643 defendant Broke Joan widow 590449 590449 Broke, Joan, of Halberton, widow 0
3880470 1983724 1983724 defendant Parker Edmund husbandman 590449 590449 Parker, Edmund, of Halberton, husbandman 0
3882903 1984545 1984545 defendant Warryn John husbandman 590449 590449 Warryn, John, of Halberton, husbandman 0
3883334 1984692 1984692 defendant Orchard William weaver 590449 590449 Orchard, William, of Halberton, weaver 0
3886584 1985761 1985761 defendant Goodyng Lawrence husbandman 590449 590449 Goodyng, Lawrence, of Halberton, husbandman 0
3890569 1987108 1987108 defendant Sedburgh Silvester gent 590449 590449 Sedburgh, Silvester, of Halberton, gent 0
3906433 1992444 1992444 defendant Heyne Edward husbandman 590449 590449 Heyne, Edward, of Halberton, husbandman 0
3914274 1995118 1995118 defendant Hundaller William laborer 590449 590449 Hundaller, William, of Halberton, laborer 1
3921272 1997468 1997468 defendant Waren John husbandman 590449 590449 Waren, John, of Halberton, husbandman 1
3921301 1997471 1997471 defendant Waren John husbandman 590449 590449 Waren, John, of Halberton, husbandman 0
3926778 1999289 1999289 defendant Sanford Christopher gent 590449 590449 Sanford, Christopher, of Halberton, gent 1
3926779 1999289 1999289 defendant Hundaller William laborer 590449 590449 Hundaller, William, of Halberton, laborer 2
3929287 2000139 2000139 defendant Weyre Thomas husbandman 590449 590449 Weyre, Thomas, of Halberton, husbandman 0
3945161 2005401 2005401 defendant Venman John husbandman 590449 590449 Venman, John, of Halberton, husbandman 0
3946389 2005808 2005808 defendant Chubbe John husbandman 590449 590449 Chubbe, John, of Halberton, husbandman 3
3946409 2005814 2005814 defendant Hyll James husbandman 590449 590449 Hyll, James, of Halberton, husbandman 0
3977906 2016846 2016846 defendant Willinge Robert husbandman 590449 590449 Willinge, Robert, of Halberton, husbandman 0
3978173 2016947 2016947 defendant Sanforde Christopher gent 590449 590449 Sanforde, Christopher, of Halberton, gent 0
3978174 2016947 2016947 defendant Gyttysham William yeoman 590449 590449 Gyttysham, William, of Halberton, yeoman 1
3978175 2016947 2016947 defendant Warren John, junior   590449 590449 Warren, John, junior, of Halberton, groom 2
3980128 2017656 2017656 defendant Hale Wilmota widow 590449 590449 Hale, Wilmota, of Halberton, widow 0
3980132 2017658 2017658 defendant Holcombe William butcher 590449 590449 Holcombe, William, of Halberton, butcher 0
3985220 2019470 2019470 defendant Ford Christopher   590449 590449 Ford, Christopher, of Halberton, weaver, son of William 1
3985223 2019471 2019471 defendant Ford Christopher   590449 590449 Ford, Christopher, of Halberton, weaver, son of William 1
3986380 2019872 2019872 defendant Battyn William husbandman 590449 590449 Battyn, William, of Halberton, husbandman 0
3991977 2021892 2021892 defendant Lesseter Robert husbandman 590449 590449 Lesseter, Robert, of Halberton, 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);