names

211 rows where place_id = 588233

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593803 1865701 1865701 plaintiff Horton Richard gent 588233 588233 Horton, Richard, of Charleton, gent 0
3597243 1866760 1866760 defendant Perys Peter laborer 588233 588233 Perys, Peter, of Charleton, laborer 4
3597244 1866760 1866760 defendant Perys John laborer 588233 588233 Perys, John, of Charleton, laborer 5
3597245 1866760 1866760 defendant Branger or Brauger Edmund laborer 588233 588233 Branger or Brauger, Edmund, of Charleton, laborer 6
3599147 1867369 1867369 defendant Wellyng Richard husbandman 588233 588233 Wellyng, Richard, of Charleton, husbandman 0
3599148 1867369 1867369 defendant Thorne Edith widow 588233 588233 Thorne, Edith, of Charleton, widow 1
3630369 1904335 1904335 defendant Yerelle Thomas husbandman 588233 588233 Yerelle, Thomas, of Charleton, husbandman 2
3641160 1907685 1907685 defendant Larder John gent 588233 588233 Larder, John, of Charleton, gent 0
3649314 1910176 1910176 defendant Hynde William husbandman 588233 588233 Hynde, William, of Charleton, husbandman 0
3650842 1910628 1910628 defendant Jamys Thomas husbandman 588233 588233 Jamys, Thomas, of Charleton, husbandman 0
3670658 1916786 1916786 defendant Chancy William gent 588233 588233 Chancy, William, of Charleton, gent 0
3670660 1916787 1916787 defendant Chawfy William gent 588233 588233 Chawfy, William, of Charleton, gent 0
3670667 1916790 1916790 defendant Chawcey William gent 588233 588233 Chawcey, William, of Charleton, gent 0
3670892 1916863 1916863 defendant Prowte William carpenter 588233 588233 Prowte, William, of Charleton, carpenter 0
3671216 1916970 1916970 defendant Chancy William gent 588233 588233 Chancy, William, of Charleton, gent 0
3672352 1917354 1917354 defendant Twyne Robert husbandman 588233 588233 Twyne, Robert, of Charleton, husbandman 1
3682950 1920781 1920781 defendant Skullard Edmund husbandman 588233 588233 Skullard, Edmund, of Charleton, husbandman 0
3710801 1929694 1929694 defendant Symon Thomas (legal representative) 588233 588233 Symon, Thomas, of Charleton, clerk, executor of 0
3718520 1932071 1932071 defendant Haradon Robert husbandman 588233 588233 Haradon, Robert, of Charleton, husbandman 0
3725387 1934233 1934233 defendant (not given) Thomas vicar of Symon 588233 588233 Symon, Thomas, of Charleton, vicar of Tawton, executor of 0
3737729 1938022 1938022 defendant Legh William husbandman 588233 588233 Legh, William, of Charleton, husbandman 1
3737730 1938022 1938022 defendant Elyott Robert husbandman 588233 588233 Elyott, Robert, of Charleton, husbandman 2
3737731 1938022 1938022 defendant Elyott William husbandman 588233 588233 Elyott, William, of Charleton, husbandman 3
3759306 1944899 1944899 defendant Ewen alias Bruan Thomas husbandman 588233 588233 Ewen alias Bruan, Thomas, of Charleton, under Horethorne, husbandman 0
3766132 1947058 1947058 defendant Haradon Roger husbandman 588233 588233 Haradon, Roger, of Charleton, husbandman 2
3774179 1949637 1949637 plaintiff Andrewes Thomas esq 588233 588233 Andrewes, Thomas, of Charleton, esq 0
3796497 1956776 1956776 defendant Sowdon Richard chaplain 588233 588233 Sowdon, Richard, of Charleton, chaplain 0
3797424 1957082 1957082 defendant Ellyot John gent 588233 588233 Ellyot, John, of Charleton, gent 0
3805670 1959716 1959716 defendant Clyff Robert husbandman 588233 588233 Clyff, Robert, of Charleton, husbandman 0
3805672 1959717 1959717 defendant Clyff Robert husbandman 588233 588233 Clyff, Robert, of Charleton, husbandman 0
3811583 1961517 1961517 defendant Long John gent 588233 588233 Long, John, of Charleton, gent 0
3814686 1962504 1962504 defendant Elyott John gent 588233 588233 Elyott, John, of Charleton, gent 0
3817004 1963226 1963226 defendant Adams Robert husbandman 588233 588233 Adams, Robert, of Charleton, husbandman 0
3824715 1965604 1965604 defendant Tanner Robert husbandman 588233 588233 Tanner, Robert, of Charleton, husbandman 0
3826653 1966181 1966181 defendant Hyberdene William husbandman 588233 588233 Hyberdene, William, of Charleton, husbandman 0
3826655 1966182 1966182 defendant Hyberdene William husbandman 588233 588233 Hyberdene, William, of Charleton, husbandman 0
3840879 1970716 1970716 defendant Courte John yeoman 588233 588233 Courte, John, of Charleton, yeoman 1
3841565 1970945 1970945 defendant Colle Thomas husbandman 588233 588233 Colle, Thomas, of Charleton, husbandman 0
3850620 1973783 1973783 defendant Harrys Thomas husbandman 588233 588233 Harrys, Thomas, of Charleton, husbandman 0
3878777 1983150 1983150 defendant Gune Roger carpenter 588233 588233 Gune, Roger, of Charleton, carpenter 1
3882706 1984480 1984480 defendant Lewke Richard husbandman 588233 588233 (Lewke, Richard, of Charleton, husbandman 1
3889209 1986628 1986628 defendant Vale John husbandman 588233 588233 Vale, John, of Charleton, husbandman 0
3894235 1988290 1988290 defendant Logett William husbandman 588233 588233 Logett, William, of Charleton, husbandman 0
3897557 1989395 1989395 defendant Dyngley Henry esq 588233 588233 Dyngley, Henry, of Charleton, esq 0
3910890 1993965 1993965 defendant Dyngley Henry esq 588233 588233 Dyngley, Henry, of Charleton, esq 0
3930038 2000392 2000392 defendant Luke Richard husbandman 588233 588233 Luke, Richard, of Charleton, husbandman 0
3945033 2005358 2005358 defendant Rondell Nicholas husbandman 588233 588233 Rondell, Nicholas, of Charleton, husbandman 0
3945034 2005358 2005358 defendant Rondell William husbandman 588233 588233 Rondell, William, of Charleton, husbandman 1
3945797 2005605 2005605 defendant Bychlighe Richard husbandman 588233 588233 Bychlighe, Richard, of Charleton, husbandman 0
3945798 2005605 2005605 defendant Randell Richard husbandman 588233 588233 Randell, Richard, of Charleton, husbandman 1
3945799 2005605 2005605 defendant Randell William husbandman 588233 588233 Randell, William, of Charleton, husbandman 2
3966266 2012829 2012829 defendant Luke Richard husbandman 588233 588233 (Luke, Richard, of Charleton, husbandman 1
3971212 2014488 2014488 plaintiff Dyneley Henry esq 588233 588233 Dyneley, Henry, of Charleton, esq 0
4005305 2026676 2026676 defendant Same Robert husbandman 588233 588233 Same, Robert, of Charleton, husbandman 1
4005997 2026918 2026918 defendant Smyth Thomas yeoman 588233 588233 Smyth, Thomas, of Charleton, yeoman;Maye, Roger, of Wotton Bassett, yeoman 3
4005998 2026918 2026918 defendant Webb Richard yeoman 588233 588233 Webb, Richard, of Charleton, yeoman 4
4026470 2034112 2034112 defendant Foyell William tailor 588233 588233 Foyell, William, of Charleton, tailor 1
4038375 2038365 2038365 defendant Webbe Richard yeoman 588233 588233 Webbe, Richard, of Charleton, yeoman 5
4038382 2038366 2038366 defendant Webbe Richard yeoman 588233 588233 Webbe, Richard, of Charleton, yeoman 5
4045012 2040672 2040672 plaintiff Rondell William   588233 588233 Rondell, William, of Charleton 0
4045015 2040673 2040673 plaintiff Rondell William   588233 588233 Rondell, William, of Charleton 0
4047327 2041501 2041501 defendant Thornehill Robert gent 588233 588233 Thornehill, Robert, of Charleton, gent 0
4047330 2041502 2041502 defendant Thornehull Robert gent 588233 588233 Thornehull, Robert, of Charleton, gent 0
4049780 2042363 2042363 defendant Browne Thomas husbandman 588233 588233 Browne, Thomas, of Charleton, husbandman 0
4050965 2042788 2042788 defendant Weymont Richard yeoman 588233 588233 Weymont, Richard, of Charleton, yeoman 0
4050966 2042788 2042788 defendant Weymont Stephen yeoman 588233 588233 Weymont, Stephen, of Charleton, yeoman 1
4062006 2046696 2046696 defendant Kynwelmarshe Cecily widow 588233 588233 Kynwelmarshe, Cecily, of Charleton, widow 1
4073737 2050901 2050901 defendant Chappell Edward husbandman 588233 588233 Chappell, Edward, of Charleton, husbandman 0
4076778 2051983 2051983 defendant Clarke Robert yeoman 588233 588233 Clarke, Robert, of Charleton, yeoman 1
4098502 2059794 2059794 defendant Chauncelor William husbandman 588233 588233 Chauncelor, William, of Charleton, husbandman 1
4099789 2060245 2060245 defendant Dyngley Henry, junior gent 588233 588233 Dyngley, Henry, junior, of Charleton, gent 0
4112765 2064828 2064828 defendant Smyth Thomas yeoman 588233 588233 Smyth, Thomas, of Charleton, yeoman 0
4135756 2073115 2073115 defendant Taverner Richard husbandman 588233 588233 Taverner, Richard, of Charleton, husbandman 0
4139027 2074329 2074329 defendant Hall John   588233 588233 Hall, John, of Charleton Magna wheeler 0
4166845 2083900 2083900 defendant Egbeare William husbandman 588233 588233 Egbeare, William, of Charleton, husbandman 0
4189389 2091789 2091789 defendant Barnes Richard smith 588233 588233 Barnes, Richard, of Charleton, smith 2
4193883 2093422 2093422 defendant Grydlowe James yeoman 588233 588233 Grydlowe, James, of Charleton, yeoman 1
4215330 2100858 2100858 defendant Wyrdnam William gent 588233 588233 Wyrdnam, William, of Charleton, gent 0
4236192 2108227 2108227 defendant Cowper William husbandman 588233 588233 Cowper, William, of Charleton, husbandman 1
4316198 2135777 2135777 defendant Kenyon Robert   588233 588233 Kenyon, Robert, of Charleton, laborer, his son 1
4317509 2136239 2136239 defendant Fulwell George gent 588233 588233 Fulwell, George, of Charleton, gent 2
4367678 2153493 2153493 defendant Ball alias Bawlie Anthony husbandman 588233 588233 Ball alias Bawlie, Anthony, of Charleton, husbandman 0
4369575 2154176 2154176 defendant Harrys Thomas draper 588233 588233 Harrys, Thomas, of Charleton, draper 0
4369709 2154225 2154225 defendant Chappell Edward husbandman 588233 588233 Chappell, Edward, of Charleton, husbandman 0
4373840 2155712 2155712 defendant Tizard Thomas yeoman 588233 588233 Tizard, Thomas, of Charleton, Charminster, yeoman 0
4391447 2161755 2161755 defendant Ball Edmund husbandman 588233 588233 Ball, Edmund, of Charleton, husbandman 1
4483261 2195462 2195462 defendant Tymme Richard, senior   588233 588233 Tymme, Richard, senior, of Charleton 4
4607125 2233344 2233344 defendant Hopkyn John   588233 588233 Hopkyn, John, of Charleton 1
4617766 2236559 2236559 defendant Balle Thomas   588233 588233 Balle, Thomas, of Charleton 0
4622126 2237898 2237898 defendant Haywode John   588233 588233 Haywode, John, of Charleton on Ottemor 0
4622902 2238142 2238142 defendant atte Wille Adam   588233 588233 atte Wille, Adam, of Charleton 0
4639273 2243004 2243004 defendant Whete John   588233 588233 Whete, John, of Charleton 0
4644031 2244352 2244352 defendant Haywode John   588233 588233 Haywode, John, of Charleton on Ottemor, parson 0
4653644 2247067 2247067 defendant Sudbury Henry husbandman 588233 588233 Sudbury, Henry, of Charleton, husbandman 0
4685491 2261057 2261057 plaintiff Rydon John   588233 588233 Rydon, John, of Charleton, on his own account 0
4689352 2262231 2262231 defendant Toukere Thomas laborer 588233 588233 Toukere, Thomas, of Charleton, laborer 0
4692414 2263145 2263145 defendant Court John husbandman 588233 588233 Court, John, of Charleton, husbandman 0
4704325 2266730 2266730 defendant atte Noke John   588233 588233 atte Noke, John, of Charleton, vicar 0
4706321 2267359 2267359 defendant Thrent John husbandman 588233 588233 Thrent, John, of Charleton, husbandman 1
4706322 2267359 2267359 defendant West William husbandman 588233 588233 West, William, of Charleton, husbandman 2

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);