names

288 rows where place_id = 585975

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587611 1863771 1863771 defendant Tolcherd Geoffrey glover 585975 585975 Tolcherd, Geoffrey, of Shaftesbury, glover 2
3589440 1864335 1864335 defendant Shayll William innholder 585975 585975 Shayll, William, of Shaftesbury, innholder 0
3618661 1873463 1873463 defendant Shoyle William innholder 585975 585975 Shoyle, William, of Shaftesbury, innholder 0
3654223 1911582 1911582 defendant Anketyll William esq 585975 585975 Anketyll, William, of Shaftesbury, esq 0
3654224 1911582 1911582 defendant Anketyll William, junior gent 585975 585975 Anketyll, William, junior, of Shaftesbury, gent 1
3654225 1911582 1911582 defendant Michell John miller 585975 585975 Michell, John, of Shaftesbury, miller 2
3654226 1911582 1911582 defendant Nevet David yeoman 585975 585975 Nevet, David, of Shaftesbury, yeoman 3
3667862 1915889 1915889 plaintiff Zouche Elizabeth   585975 585975 Zouche, Elizabeth, of Shaftesbury, abbess of the Monastery of the BVM & King Edward, saint & Martyr 0
3668374 1916056 1916056 defendant Shoyle Philip yeoman 585975 585975 Shoyle, Philip, of Shaftesbury, yeoman 0
3736492 1937661 1937661 defendant Adys John plumber and innholder 585975 585975 Adys, John, of Shaftesbury, plumber and innholder 0
3736493 1937661 1937661 defendant Blacker Thomas innholder 585975 585975 Blacker, Thomas, of Shaftesbury, innholder 1
3786646 1953618 1953618 defendant Gilbert Edward butcher 585975 585975 Gilbert, Edward, of Shaftesbury, butcher 0
3786647 1953618 1953618 defendant Trepyn Thomas butcher 585975 585975 Trepyn, Thomas, of Shaftesbury, butcher 1
3788808 1954302 1954302 defendant Inkepen Richard gent 585975 585975 Inkepen, Richard, of Shaftesbury, gent 1
3799397 1957732 1957732 defendant Adys John innholder 585975 585975 Adys, John, of Shaftesbury, innholder 0
3841544 1970937 1970937 defendant Vyncent John smith 585975 585975 Vyncent, John, of Shaftesbury, smith 0
3907350 1992747 1992747 defendant Bygges William glover 585975 585975 Bygges, William, of Shaftesbury, glover 0
3907351 1992747 1992747 defendant Beamount John glover 585975 585975 Beamount, John, of Shaftesbury, glover 1
3944693 2005242 2005242 defendant Tyrrell John smith 585975 585975 Tyrrell, John, of Shaftesbury, smith 0
3959963 2010583 2010583 plaintiff Spencer John (legal representative) 585975 585975 Spencer, John, of Shaftesbury, yeoman, executrix of 0
3961548 2011139 2011139 plaintiff Tyder Robert   585975 585975 Tyder, Robert, of Shaftesbury 0
3969797 2014042 2014042 plaintiff Cressett Mary   585975 585975 Cressett, Mary, of Shaftesbury 0
3973416 2015273 2015273 defendant Lambe Thomas vintner 585975 585975 Lambe, Thomas, of Shaftesbury, vintner 0
3978610 2017095 2017095 defendant Payne Richard shoemaker 585975 585975 Payne, Richard, of Shaftesbury, shoemaker 0
3982769 2018609 2018609 defendant Were Christopher yeoman 585975 585975 Were, Christopher, of Shaftesbury, yeoman 0
3983660 2018924 2018924 defendant Were Christopher yeoman 585975 585975 Were, Christopher, of Shaftesbury, yeoman 1
3987674 2020339 2020339 defendant Harman Robert currier 585975 585975 Harman, Robert, of Shaftesbury, currier 0
3987675 2020339 2020339 defendant Cradocke Nicholas yeoman 585975 585975 Cradocke, Nicholas, of Shaftesbury, yeoman 1
3987676 2020339 2020339 defendant Palmer Gilbert tailor 585975 585975 Palmer, Gilbert, of Shaftesbury, tailor 2
3989041 2020825 2020825 defendant Broke David yeoman 585975 585975 Broke, David, of Shaftesbury, yeoman 0
3992128 2021948 2021948 defendant Wyett William husbandman 585975 585975 Wyett, William, of Shaftesbury, husbandman 0
4004142 2026255 2026255 defendant Rugge William haberdasher 585975 585975 Rugge, William, of Shaftesbury, or of Stower Estowe, Dorset, haberdasher 0
4005583 2026772 2026772 defendant Spyller John gent 585975 585975 Spyller, John, of Shaftesbury, gent 1
4024396 2033403 2033403 defendant Poker John clerk 585975 585975 Poker, John, of Shaftesbury, clerk 1
4045849 2040961 2040961 plaintiff Senyor Morgan mercer 585975 585975 Senyor, Morgan, of Shaftesbury, mercer 0
4070050 2049577 2049577 defendant Spighte James innholder 585975 585975 Spighte, James, of Shaftesbury, innholder 0
4084684 2054794 2054794 defendant Maunsell Thomas shoemaker 585975 585975 Maunsell, Thomas, of Shaftesbury, shoemaker 0
4104941 2062044 2062044 defendant Skudamore Thomas innholder 585975 585975 Skudamore, Thomas, of Shaftesbury, innholder 0
4112571 2064753 2064753 defendant Skidmore Thomas gent 585975 585975 Skidmore, Thomas, of Shaftesbury, gent 0
4131134 2071452 2071452 defendant Mynterne John gent 585975 585975 Mynterne, John, of Shaftesbury, or of Middle Temple, London, gent 1
4134210 2072559 2072559 defendant Barnarde Randolph beer brewer 585975 585975 Barnarde, Randolph, of Shaftesbury, beer brewer 0
4134211 2072559 2072559 defendant Hilsonne alias Burge Peter yeoman 585975 585975 Hilsonne alias Burge, Peter, of Shaftesbury, yeoman 1
4147489 2077264 2077264 defendant Rapson John butcher 585975 585975 Rapson, John, of Shaftesbury, butcher 0
4152678 2079048 2079048 defendant Sherwood James gent 585975 585975 Sherwood, James, of Shaftesbury, gent 2
4163368 2082713 2082713 defendant Skydamore Thomas innholder 585975 585975 Skydamore, Thomas, of Shaftesbury, innholder 0
4193294 2093221 2093221 defendant Hartrye Gregory husbandman 585975 585975 Hartrye, Gregory, of Shaftesbury, or of West Camell, Soms, husbandman 0
4193295 2093221 2093221 defendant Moone Thomas husbandman 585975 585975 Moone, Thomas, of Shaftesbury, or of Charlton, Soms, husbandman 1
4193296 2093221 2093221 defendant Gyles John husbandman 585975 585975 Gyles, John, of Shaftesbury, or of Langporte Estover, Soms, husbandman 2
4193298 2093222 2093222 defendant Moone Thomas husbandman 585975 585975 Moone, Thomas, of Shaftesbury, or of Charlton, Soms, husbandman 0
4193299 2093222 2093222 defendant Moone John husbandman 585975 585975 Moone, John, of Shaftesbury, husbandman 1
4193300 2093222 2093222 defendant Hartrye Gregory husbandman 585975 585975 Hartrye, Gregory, of Shaftesbury, or of West Camell, Soms, husbandman 2
4194095 2093488 2093488 defendant Kynge Thomas yeoman 585975 585975 Kynge, Thomas, of Shaftesbury, or of Girston, Wilts, yeoman 0
4205989 2097641 2097641 defendant Hacker Thomas weaver 585975 585975 Hacker, Thomas, of Shaftesbury, or of Sherington, Wilts, weaver 0
4205990 2097641 2097641 defendant Tucker Thomas miller 585975 585975 Tucker, Thomas, of Shaftesbury, or of Westberye, miller 1
4205991 2097641 2097641 defendant Williams Henry miller 585975 585975 Williams, Henry, of Shaftesbury, or of Hill Deverell, miller 2
4218310 2101901 2101901 defendant Jennyng Thomas miller 585975 585975 Jennyng, Thomas, of Shaftesbury, miller 0
4290550 2126679 2126679 defendant Spiller or Spellor Elias gent 585975 585975 Spiller or Spellor, Elias, of Shaftesbury, gent 1
4309554 2133501 2133501 defendant Daccombe John gent 585975 585975 Daccombe, John, of Shaftesbury, gent 0
4332275 2141086 2141086 defendant Asheley Henry esq 585975 585975 Asheley, Henry, of Shaftesbury, or of Wymborne St Gyles, esq 0
4333753 2141568 2141568 defendant Upwood or Upwarde Robert yeoman 585975 585975 Upwood or Upwarde, Robert, of Shaftesbury, or of East orchard, yeoman 0
4367726 2153509 2153509 defendant Wemore John chapman 585975 585975 Wemore, John, of Shaftesbury, chapman 2
4382854 2158971 2158971 defendant Senyor Morgan merchant 585975 585975 Senyor, Morgan, of Shaftesbury, merchant 0
4385131 2159714 2159714 defendant Senyor Morgan mercer 585975 585975 Senyor, Morgan, of Shaftesbury, mercer 2
4399705 2164490 2164490 defendant Bastard Robert cutler 585975 585975 Bastard, Robert, of Shaftesbury, cutler 0
4399706 2164490 2164490 defendant Senyor Morgan vintner 585975 585975 Senyor, Morgan, of Shaftesbury, vintner 1
4399707 2164490 2164490 defendant Senyor John   585975 585975 Senyor, John, of Shaftesbury, mercer, his son 2
4404474 2166062 2166062 defendant Senyor Morgan vintner 585975 585975 Senyor, Morgan, of Shaftesbury, vintner 0
4404475 2166062 2166062 defendant Senyorm John chapman 585975 585975 Senyorm John, of Shaftesbury, chapman 1
4405170 2166307 2166307 defendant Garnett Thomas clerk 585975 585975 Garnett, Thomas, of Shaftesbury, clerk 0
4405171 2166307 2166307 defendant Luffe Charles yeoman 585975 585975 Luffe, Charles, of Shaftesbury, yeoman 1
4405172 2166307 2166307 defendant Clement Jerome husbandman 585975 585975 Clement, Jerome, of Shaftesbury, husbandman 2
4405173 2166307 2166307 defendant Rabbett William shoemaker 585975 585975 Rabbett, William, of Shaftesbury, shoemaker 3
4409709 2167848 2167848 defendant Moores Thomas husbandman 585975 585975 Moores, Thomas, of Shaftesbury, husbandman 0
4415913 2169860 2169860 defendant Bertilot Robert   585975 585975 Bertilot, Robert, of Shaftesbury 1
4442775 2182697 2182697 defendant Coleyl Thomas   585975 585975 Coleyl, Thomas, of Shaftesbury 0
4447631 2184179 2184179 defendant Croxhale Hugh   585975 585975 Croxhale, Hugh, of Shaftesbury 0
4447633 2184180 2184180 defendant Croxhale Hugh   585975 585975 Croxhale, Hugh, of Shaftesbury 0
4460176 2188240 2188240 plaintiff Seward Thomas   585975 585975 Seward, Thomas, of Shaftesbury 0
4460179 2188241 2188241 plaintiff Seward Thomas   585975 585975 Seward, Thomas, of Shaftesbury 0
4468106 2190697 2190697 defendant Coppedok Richard   585975 585975 Coppedok, Richard, of Shaftesbury 0
4477142 2193513 2193513 defendant Eyan John   585975 585975 Eyan, John, of Shaftesbury 0
4479500 2194246 2194246 defendant Hikkes John   585975 585975 Hikkes, John, of Shaftesbury 3
4480476 2194556 2194556 defendant Hosteler John   585975 585975 Hosteler, John, of Shaftesbury 3
4495988 2199422 2199422 defendant atte Aysche William   585975 585975 atte Aysche, William, of Shaftesbury 2
4502845 2201466 2201466 defendant Stoure Richard   585975 585975 Stoure, Richard, of Shaftesbury 0
4507086 2202684 2202684 defendant Hakkins John chapman 585975 585975 Hakkins, John, of Shaftesbury, chapman 4
4508512 2203136 2203136 defendant Gervays Thomas draper 585975 585975 Gervays, Thomas, of Shaftesbury, draper 2
4526636 2208609 2208609 defendant Hickes John   585975 585975 Hickes, John, of Shaftesbury 0
4532565 2210451 2210451 defendant Cambo Peter   585975 585975 Cambo, Peter, of Shaftesbury 0
4547340 2215100 2215100 defendant Osmond John   585975 585975 Osmond, John, of Shaftesbury 2
4547344 2215101 2215101 defendant Esmond John   585975 585975 Esmond, John, of Shaftesbury 2
4553590 2217051 2217051 defendant Hikkes John   585975 585975 Hikkes, John, of Shaftesbury 3
4553597 2217052 2217052 defendant Hikkes John   585975 585975 Hikkes, John, of Shaftesbury 3
4556229 2217887 2217887 plaintiff Hosyere Richard   585975 585975 Hosyere, Richard, of Shaftesbury 0
4556232 2217887 2217887 defendant Thresshere John   585975 585975 Thresshere, John, of Shaftesbury 2
4577488 2224473 2224473 defendant Barbour John   585975 585975 Barbour, John, of Shaftesbury 0
4579252 2224993 2224993 defendant Taillour Richard baker 585975 585975 Taillour, Richard, of Shaftesbury, baker 0
4590048 2228246 2228246 defendant Wyse Thomas   585975 585975 Wyse, Thomas, of Shaftesbury 0
4608466 2233755 2233755 defendant Hosyer alias Draper John   585975 585975 Hosyer alias Draper, John, of Shaftesbury 0
4610131 2234253 2234253 plaintiff Cammell Thomas   585975 585975 Cammell, Thomas, of Shaftesbury 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);