names

180 rows where place_id = 591189

✎ 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
3594123 1865804 1865804 defendant Fetyll Robert   591189 591189 Fetyll, Robert, of Dunton, parson of Dogton and Dunton 0
3603649 1868809 1868809 defendant Fetyll Robert clerk 591189 591189 Fetyll, Robert, of Dunton, clerk 2
3613712 1871938 1871938 plaintiff Bekyrton Richard   591189 591189 Bekyrton, Richard, of Dunton 0
3613713 1871938 1871938 defendant Moye Henry clerk 591189 591189 Moye, Henry, of Dunton, clerk 0
3613714 1871938 1871938 defendant Deryng John   591189 591189 Deryng, John, of Dunton, shepherd 1
3616035 1872648 1872648 defendant Stalworthy John yeoman 591189 591189 Stalworthy, John, of Dunton, yeoman 6
3617362 1873049 1873049 defendant Smyth William husbandman 591189 591189 Smyth, William, of Dunton, husbandman 11
3631621 1904705 1904705 defendant Richeman John husbandman 591189 591189 Richeman, John, of Dunton, husbandman 0
3634259 1905513 1905513 defendant Fowle John husbandman 591189 591189 Fowle, John, of Dunton, husbandman 2
3676825 1918791 1918791 defendant Knottysford Humphrey clerk 591189 591189 Knottysford, Humphrey, of Dunton, clerk 0
3678402 1919299 1919299 defendant Sutton Agnes widow 591189 591189 (Sutton, Agnes, of Dunton, widow 1
3682286 1920558 1920558 defendant Sherpe Robert husbandman 591189 591189 Sherpe, Robert, of Dunton, husbandman 1
3682289 1920559 1920559 plaintiff Sutton John (legal representative) 591189 591189 Sutton, John, of Dunton, executors of 0
3682292 1920559 1920559 plaintiff Sutton John, junior   591189 591189 Sutton, John, junior, of Dunton 3
3685218 1921528 1921528 defendant Cartoun Thomas chaplain 591189 591189 Cartoun, Thomas, of Dunton, chaplain 0
3700272 1926321 1926321 defendant Cartonn or Cartoun Thomas chaplain 591189 591189 Cartonn or Cartoun, Thomas, of Dunton, chaplain 0
3719154 1932275 1932275 defendant Brevytour John husbandman 591189 591189 Brevytour, John, of Dunton, husbandman 1
3744545 1940195 1940195 defendant Canon James yeoman 591189 591189 Canon, James, of Dunton, yeoman 2
3748544 1941478 1941478 defendant Smyth William husbandman 591189 591189 Smyth, William, of Dunton, husbandman 1
3748549 1941479 1941479 defendant Smyth William carpenter 591189 591189 Smyth, William, of Dunton, carpenter 1
3759946 1945107 1945107 defendant Coryngton Ralph husbandman 591189 591189 Coryngton, Ralph, of Dunton, husbandman 1
3766491 1947178 1947178 defendant Balle John husbandman 591189 591189 Balle, John, of Dunton, husbandman 0
3790128 1954731 1954731 plaintiff Wadeluff Robert clerk 591189 591189 Wadeluff, Robert, of Dunton, clerk 0
3806611 1959968 1959968 defendant Caryngton or Carnton Ralph husbandman 591189 591189 Caryngton or Carnton, Ralph, of Dunton, husbandman 1
3810807 1961281 1961281 defendant Carneton Ralph husbandman 591189 591189 Carneton, Ralph, of Dunton, husbandman 0
3815137 1962653 1962653 defendant Smyth William husbandman 591189 591189 Smyth, William, of Dunton, husbandman 0
3823663 1965299 1965299 plaintiff Corbytt John   591189 591189 Corbytt, John, of Dunton 2
3824456 1965519 1965519 defendant Caryngton Ralph husbandman 591189 591189 Caryngton, Ralph, of Dunton, husbandman 1
3825374 1965786 1965786 defendant Richeman John husbandman 591189 591189 Richeman, John, of Dunton, husbandman 2
3870457 1980361 1980361 defendant Smyth Thomas laborer 591189 591189 Smyth, Thomas, of Dunton, laborer 2
3873139 1981232 1981232 defendant Travell Henry husbandman 591189 591189 Travell, Henry, of Dunton, husbandman 0
3877310 1982655 1982655 defendant Emmys Robert husbandman 591189 591189 Emmys, Robert, of Dunton, husbandman 1
3877337 1982668 1982668 defendant Ansell John husbandman 591189 591189 Ansell, John, of Dunton, husbandman 0
3879897 1983534 1983534 defendant Brobytur Henry husbandman 591189 591189 Brobytur, Henry, of Dunton, husbandman 2
3889703 1986791 1986791 defendant Yarham John husbandman 591189 591189 Yarham, John, of Dunton, husbandman 3
3903759 1991491 1991491 defendant Yarham John husbandman 591189 591189 Yarham, John, of Dunton, husbandman 3
3989604 2021029 2021029 defendant Jennyson Thomas yeoman 591189 591189 Jennyson, Thomas, of Dunton, yeoman 0
3989608 2021030 2021030 defendant Jennyson Thomas yeoman 591189 591189 Jennyson, Thomas, of Dunton, yeoman 0
4002400 2025636 2025636 defendant Jennyson Thomas yeoman 591189 591189 Jennyson, Thomas, of Dunton, yeoman 0
4015318 2030173 2030173 defendant Jennyson Thomas yeoman 591189 591189 Jennyson, Thomas, of Dunton, yeoman 0
4021368 2032367 2032367 defendant Jennyson Thomas yeoman 591189 591189 Jennyson, Thomas, of Dunton, yeoman 0
4028807 2034951 2034951 defendant Jenyson Thomas yeoman 591189 591189 Jenyson, Thomas, of Dunton, yeoman 0
4032766 2036372 2036372 defendant Jennyson Thomas yeoman 591189 591189 Jennyson, Thomas, of Dunton, yeoman 0
4047390 2041523 2041523 defendant Jenyson Thomas yeoman 591189 591189 Jenyson, Thomas, of Dunton, yeoman 0
4050516 2042612 2042612 defendant Jenyson Thomas yeoman 591189 591189 Jenyson, Thomas, of Dunton, yeoman 0
4053933 2043784 2043784 defendant Wolston Thomas husbandman 591189 591189 Wolston, Thomas, of Dunton, husbandman 0
4142144 2075430 2075430 defendant Crowe Richard yeoman 591189 591189 Crowe, Richard, of Dunton, yeoman 0
4152972 2079146 2079146 defendant Jenyson Thomas yeoman 591189 591189 Jenyson, Thomas, of Dunton, yeoman 0
4176297 2087188 2087188 defendant Crowe Nicholas yeoman 591189 591189 Crowe, Nicholas, of Dunton, yeoman 0
4242541 2110503 2110503 defendant Crowe Nicholas gent 591189 591189 Crowe, Nicholas, of Dunton, gent 0
4242544 2110504 2110504 defendant Crowe Nicholas gent 591189 591189 Crowe, Nicholas, of Dunton, gent 0
4244837 2111263 2111263 defendant Crowe Nicholas yeoman or gent 591189 591189 Crowe, Nicholas, of Dunton, yeoman or gent 0
4244850 2111266 2111266 defendant Crowe Nicholas gent 591189 591189 Crowe, Nicholas, of Dunton, gent 0
4279008 2122588 2122588 defendant Crowe Nicholas yeoman 591189 591189 Crowe, Nicholas, of Dunton, yeoman 0
4315316 2135468 2135468 defendant Rothewell Thomas gent 591189 591189 Rothewell, Thomas, of Dunton, yeoman, or Grymston, gent 0
4350323 2147373 2147373 defendant Ball John yeoman 591189 591189 Ball, John, of Dunton, yeoman 0
4353750 2148533 2148533 defendant Jenyson Thomas yeoman 591189 591189 Jenyson, Thomas, of Dunton, yeoman 0
4354796 2148898 2148898 defendant Rabye William husbandman 591189 591189 Rabye, William, of Dunton, husbandman 3
4355288 2149069 2149069 defendant Shepeheard or Sheperd Basil yeoman 591189 591189 Shepeheard or Sheperd, Basil, of Dunton, yeoman 1
4369069 2154003 2154003 defendant Hopkyns alias Searle Thomas yeoman 591189 591189 Hopkyns alias Searle, Thomas, of Dunton, yeoman 0
4387558 2160479 2160479 defendant Jennyson Thomas yeoman 591189 591189 Jennyson, Thomas, of Dunton, yeoman 0
4431728 2174695 2174695 defendant Eton Hugh de   591189 591189 Eton, Hugh de, of Dunton, parson 0
4445820 2183637 2183637 defendant Gylle Richard   591189 591189 Gylle, Richard, of Dunton 3
4461302 2188620 2188620 defendant Flanvill John   591189 591189 Flanvill, John, of Dunton 1
4522670 2207429 2207429 defendant Yareham Thomas   591189 591189 Yareham, Thomas, of Dunton 2
4525994 2208431 2208431 defendant Yaram Thomas   591189 591189 Yaram, Thomas, of Dunton 6
4550203 2216009 2216009 defendant Fithelere Henry   591189 591189 Fithelere, Henry, of Dunton 0
4550204 2216009 2216009 defendant Brentour Thomas   591189 591189 Brentour, Thomas, of Dunton 1
4552252 2216660 2216660 defendant Geffrey William   591189 591189 Geffrey, William, of Dunton 0
4552253 2216660 2216660 defendant Malabre William   591189 591189 Malabre, William, of Dunton 1
4552260 2216662 2216662 defendant Gefferey William   591189 591189 Gefferey, William, of Dunton 0
4552261 2216662 2216662 defendant Malabre William   591189 591189 Malabre, William, of Dunton 1
4557401 2218254 2218254 plaintiff Kyrwen John   591189 591189 Kyrwen, John, of Dunton 0
4562225 2219754 2219754 defendant Paternoster John   591189 591189 Paternoster, John, of Dunton 0
4592849 2229095 2229095 defendant Folieambe John   591189 591189 Folieambe, John, of Dunton 0
4607786 2233548 2233548 defendant Garle William   591189 591189 Garle, William, of Dunton 0
4621285 2237644 2237644 defendant Geffrey William   591189 591189 Geffrey, William, of Dunton 0
4628894 2239967 2239967 defendant Garle William   591189 591189 Garle, William, of Dunton 0
4650129 2246056 2246056 defendant Skony Thomas   591189 591189 Skony, Thomas, of Dunton 2
4680894 2259646 2259646 defendant Neel John   591189 591189 Neel, John, of Dunton, parson 0
4688137 2261860 2261860 defendant Flesshe Thomas butcher 591189 591189 Flesshe, Thomas, of Dunton, butcher 0
4699342 2265259 2265259 defendant Age William husbandman 591189 591189 Age, William, of Dunton, husbandman 0
4699343 2265259 2265259 defendant Paton Thomas husbandman 591189 591189 Paton, Thomas, of Dunton, husbandman 1
4699344 2265259 2265259 defendant Flessh Thomas husbandman 591189 591189 Flessh, Thomas, of Dunton, husbandman 2
4699345 2265259 2265259 defendant Flessh Richard husbandman 591189 591189 Flessh, Richard, of Dunton, husbandman 3
4726019 2273424 2273424 defendant Flesshe Thomas husbandman 591189 591189 Flesshe, Thomas, of Dunton, husbandman 3
4726022 2273424 2273424 defendant Hygon John husbandman 591189 591189 Hygon, John, of Dunton, husbandman 6
4735432 2276226 2276226 defendant Neel John   591189 591189 Neel, John, of Dunton, parson 0
4747685 2279831 2279831 defendant Barbour John husbandman 591189 591189 Barbour, John, of Dunton, husbandman 0
4755795 2282194 2282194 defendant Dyke John husbandman 591189 591189 Dyke, John, of Dunton, husbandman 3
4767576 2285840 2285840 defendant Garle William yeoman 591189 591189 Garle, William, of Dunton, yeoman 0
4767925 2285941 2285941 defendant Hole Nicholas yeoman 591189 591189 Hole, Nicholas, of Dunton, yeoman 2
4777529 2288967 2288967 defendant Rys Thomas tailor 591189 591189 Rys, Thomas, of Dunton, tailor 0
4786839 2291944 2291944 defendant Barbour William husbandman 591189 591189 Barbour, William, of Dunton, husbandman 0
4786840 2291944 2291944 defendant Flessh Thomas husbandman 591189 591189 Flessh, Thomas, of Dunton, husbandman 1
4786842 2291944 2291944 defendant Boxe John husbandman 591189 591189 Boxe, John, of Dunton, husbandman 3
4807070 2298410 2298410 defendant Wryght William husbandman 591189 591189 Wryght, William, of Dunton, husbandman 0
4807071 2298410 2298410 defendant Boxe John husbandman 591189 591189 Boxe, John, of Dunton, husbandman 1
4817294 2301501 2301501 defendant Paton Thomas husbandman 591189 591189 Paton, Thomas, of Dunton, husbandman 0
4822197 2303022 2303022 defendant Wesenham John husbandman 591189 591189 Wesenham, John, of Dunton, 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);