names

125 rows where place_id = 590227

✎ 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
3600298 1867739 1867739 plaintiff Wodward John   590227 590227 Wodward, John, of Shelton 0
3630734 1904436 1904436 defendant Machon Roger yeoman 590227 590227 Machon, Roger, of Shelton, yeoman 1
3655749 1912057 1912057 defendant Trews Thomas cooper 590227 590227 Trews, Thomas, of Shelton, cooper 1
3680905 1920111 1920111 defendant Dymes Thomas (legal representative) 590227 590227 Dymes, Thomas, of Shelton, executors of 0
3712242 1930141 1930141 defendant Hole Robert husbandman 590227 590227 Hole, Robert, of Shelton, husbandman 0
3718162 1931967 1931967 defendant Boleyn Edward   590227 590227 Boleyn, Edward, of Shelton, knight 0
3733608 1936757 1936757 defendant Bowyer John yeoman 590227 590227 Bowyer, John, of Shelton, yeoman 0
3733610 1936757 1936757 defendant Machyn Thomas husbandman 590227 590227 Machyn, Thomas, of Shelton, husbandman 2
3733611 1936757 1936757 defendant Turner Roger husbandman 590227 590227 Turner, Roger, of Shelton, husbandman 3
3775068 1949934 1949934 defendant Sawston John husbandman 590227 590227 Sawston, John, of Shelton, husbandman 0
3775069 1949934 1949934 defendant Dawson Ralph husbandman 590227 590227 Dawson, Ralph, of Shelton, husbandman 1
3795604 1956509 1956509 defendant Boleyn Edward   590227 590227 Boleyn, Edward, of Shelton, knight 0
3800208 1957985 1957985 defendant Crewe Robert yeoman 590227 590227 Crewe, Robert, of Shelton, yeoman 0
3800210 1957986 1957986 defendant Crewe Robert yeoman 590227 590227 Crewe, Robert, of Shelton, yeoman 0
3801607 1958401 1958401 defendant Cruwe Robert husbandman 590227 590227 Cruwe, Robert, of Shelton, husbandman 2
3805212 1959576 1959576 defendant Dawson Ralph carpenter 590227 590227 Dawson, Ralph, of Shelton, carpenter 0
3812828 1961910 1961910 defendant Boleyn Edward   590227 590227 Boleyn, Edward, of Shelton, knight 0
3826922 1966271 1966271 defendant Byman John husbandman 590227 590227 Byman, John, of Shelton, husbandman 0
3827542 1966476 1966476 defendant Benet John husbandman 590227 590227 Benet, John, of Shelton, husbandman 0
3842000 1971054 1971054 defendant Collett Thomas yeoman 590227 590227 Collett, Thomas, of Shelton, yeoman 2
3861911 1977443 1977443 defendant Hasyll Robert yeoman 590227 590227 Hasyll, Robert, of Shelton, yeoman 0
3862252 1977560 1977560 defendant Hasyll Robert yeoman 590227 590227 Hasyll, Robert, of Shelton, yeoman 0
3862255 1977561 1977561 defendant Hasyll Robert yeoman 590227 590227 Hasyll, Robert, of Shelton, yeoman 0
3876101 1982257 1982257 defendant Skelton William gent 590227 590227 Skelton, William, of Shelton, gent 1
3906163 1992353 1992353 defendant Shelton Ralph, junior gent 590227 590227 Shelton, Ralph, junior, of Shelton, gent 0
3922093 1997716 1997716 defendant Ward Roger husbandman 590227 590227 Ward, Roger, of Shelton, husbandman 2
3928088 1999733 1999733 defendant Dawson George yeoman 590227 590227 Dawson, George, of Shelton, yeoman 0
3937829 2002985 2002985 defendant Balden Ralph husbandman 590227 590227 Balden, Ralph, of Shelton, husbandman 1
3942608 2004536 2004536 defendant Fayerclough Thomas butcher 590227 590227 Fayerclough, Thomas, of Shelton, butcher 0
3943539 2004858 2004858 defendant Shellton Margaret widow 590227 590227 Shellton, Margaret, of Shelton, widow 0
3943540 2004858 2004858 defendant Godsalve Anne esq 590227 590227 Godsalve, Anne, of Shelton, widow of William Godsalve, esq 1
3948419 2006511 2006511 defendant Shelton John (legal representative) 590227 590227 Shelton, John, of Shelton, knight, executrix of 0
3948420 2006511 2006511 defendant Shelton Margaret widow 590227 590227 Shelton, Margaret, of Shelton, widow 1
3952615 2007986 2007986 defendant Dawson George yeoman 590227 590227 Dawson, George, of Shelton, yeoman 0
3957299 2009617 2009617 defendant Crystofte Robert yeoman 590227 590227 Crystofte, Robert, of Shelton, yeoman 0
3959710 2010486 2010486 defendant Shall William yeoman 590227 590227 Shall, William, of Shelton, yeoman 2
3959774 2010511 2010511 defendant Shall William yeoman 590227 590227 Shall, William, of Shelton, yeoman 2
3967517 2013274 2013274 defendant Holland Henry yeoman 590227 590227 Holland, Henry, of Shelton, yeoman 1
3972824 2015067 2015067 defendant Randolffe John yeoman 590227 590227 Randolffe, John, of Shelton, yeoman 3
3974200 2015542 2015542 defendant Sotheake or Sowthikk John gent 590227 590227 Sotheake or Sowthikk, John, of Shelton, Cumber, gent 0
4025382 2033737 2033737 plaintiff Brockhurste Thomas yeoman 590227 590227 Brockhurste, Thomas, of Shelton, yeoman 0
4104772 2061983 2061983 defendant Blackshawe Richard husbandman 590227 590227 Blackshawe, Richard, of Shelton, husbandman 0
4121691 2068055 2068055 defendant Shelton Thomas esq 590227 590227 Shelton, Thomas, of Shelton, esq 0
4141540 2075205 2075205 defendant Sholles or Shelles Philip yeoman 590227 590227 Sholles or Shelles, Philip, of Shelton, yeoman 3
4143064 2075741 2075741 defendant Turmoore John yeoman 590227 590227 Turmoore, John, of Shelton, yeoman 1
4149433 2077928 2077928 defendant Dawson Ralph yeoman 590227 590227 Dawson, Ralph, of Shelton, yeoman 2
4149434 2077928 2077928 defendant Johnson William tailor 590227 590227 Johnson, William, of Shelton, tailor 3
4149437 2077929 2077929 defendant Dashe Edward (legal representative) 590227 590227 Dashe, Edward, of Shelton, fletcher, administratrix of 1
4153566 2079340 2079340 defendant Baillie Robert husbandman 590227 590227 Baillie, Robert, of Shelton under Hareley, husbandman 1
4153567 2079340 2079340 defendant Blackshawe Randolph husbandman 590227 590227 Blackshawe, Randolph, of Shelton under Harele, husbandman 2
4156109 2080212 2080212 defendant Blackshawe Richard husbandman 590227 590227 Blackshawe, Richard, of Shelton Under Hareley, husbandman 0
4159122 2081261 2081261 defendant Case Ralph laborer 590227 590227 Case, Ralph, of Shelton, laborer 1
4180394 2088618 2088618 defendant Gylbert John husbandman 590227 590227 Gylbert, John, of Shelton, husbandman 0
4186213 2090662 2090662 defendant Shelton Thomas esq 590227 590227 Shelton, Thomas, of Shelton, esq 0
4189888 2091964 2091964 defendant Hill John, junior yeoman 590227 590227 Hill, John, junior, of Shelton, yeoman 0
4189889 2091964 2091964 defendant Wright John, junior yeoman 590227 590227 Wright, John, junior, of Shelton, yeoman 1
4190427 2092193 2092193 defendant Shelton Thomas esq 590227 590227 Shelton, Thomas, of Shelton, esq 1
4191874 2092715 2092715 defendant Tunstall Richard yeoman 590227 590227 Tunstall, Richard, of Shelton, yeoman 1
4194277 2093545 2093545 defendant Bayly Robert yeoman 590227 590227 Bayly, Robert, of Shelton under Hareley, yeoman 0
4198833 2095148 2095148 defendant Jackson Edmund laborer 590227 590227 Jackson, Edmund, of Shelton, laborer 1
4208989 2098694 2098694 defendant Duncton Francis husbandman 590227 590227 Duncton, Francis, of Shelton, husbandman 0
4256472 2115132 2115132 defendant Brette or Bretten Thomas husbandman 590227 590227 Brette or Bretten, Thomas, of Shelton, husbandman 2
4276940 2121865 2121865 defendant Bartlett John yeoman 590227 590227 Bartlett, John, of Shelton, yeoman 2
4288212 2125829 2125829 defendant Flatman Robert, junior joiner 590227 590227 Flatman, Robert, junior, of Shelton, joiner 1
4310154 2133706 2133706 defendant Turmore or Turnore John yeoman 590227 590227 Turmore or Turnore, John, of Shelton, yeoman 0
4310155 2133706 2133706 defendant Meare Henry yeoman 590227 590227 Meare, Henry, of Shelton, or of Stoke in Trent, yeoman 1
4315472 2135521 2135521 defendant Turmor or Turnor John yeoman 590227 590227 Turmor or Turnor, John, of Shelton, yeoman 1
4324942 2138726 2138726 defendant Johnson John miller 590227 590227 Johnson, John, of Shelton, miller 1
4324945 2138727 2138727 defendant Sutton Thomas husbandman 590227 590227 Sutton, Thomas, of Shelton, husbandman 0
4337411 2142820 2142820 defendant Plymley William weaver 590227 590227 Plymley, William, of Shelton under Hareley, weaver 2
4355533 2149157 2149157 defendant Ames John yeoman 590227 590227 Ames, John, of Shelton, yeoman 0
4375006 2156121 2156121 defendant Markham Robert, junior gent 590227 590227 Markham, Robert, junior, of Shelton, gent 0
4386667 2160217 2160217 defendant Walter Roger husbandman 590227 590227 Walter, Roger, of Shelton, or of Swindon, husbandman 0
4405286 2166352 2166352 defendant Markham John gent 590227 590227 Markham, John, of Shelton, gent 0
4405287 2166352 2166352 defendant Upton Robert husbandman 590227 590227 Upton, Robert, of Shelton, husbandman 1
4405291 2166353 2166353 defendant Markham John gent 590227 590227 Markham, John, of Shelton, gent 0
4405292 2166353 2166353 defendant Upton Robert husbandman 590227 590227 Upton, Robert, of Shelton, husbandman 1
4447555 2184150 2184150 defendant Fyneux Thomas   590227 590227 Fyneux, Thomas, of Shelton 0
4454820 2186520 2186520 defendant Smyth Richard   590227 590227 Smyth, Richard, of Shelton 0
4469453 2191110 2191110 plaintiff Bole John   590227 590227 Bole, John, of Shelton 0
4576078 2224015 2224015 defendant atte Redy John, sen   590227 590227 atte Redy, John, sen, of Shelton 0
4594109 2229418 2229418 defendant atte Halle Thomas   590227 590227 atte Halle, Thomas, of Shelton 0
4598947 2230893 2230893 defendant Shelton John   590227 590227 Shelton, John, of Shelton 1
4602315 2231940 2231940 defendant Wakefeld John   590227 590227 Wakefeld, John, of Shelton 3
4621383 2237681 2237681 defendant Eppes John   590227 590227 Eppes, John, of Shelton, parson 1
4621388 2237682 2237682 defendant Eppes John   590227 590227 Eppes, John, of Shelton 1
4643747 2244272 2244272 defendant Eppes John   590227 590227 Eppes, John, of Shelton, parson 1
4685482 2261054 2261054 defendant Heppe John   590227 590227 Heppe, John, of Shelton, parson 0
4696774 2264469 2264469 defendant Blessot John husbandman 590227 590227 Blessot, John, of Shelton, husbandman 1
4696775 2264469 2264469 defendant Adyngton William husbandman 590227 590227 Adyngton, William, of Shelton, husbandman 2
4756741 2282472 2282472 defendant Waryng Simon husbandman 590227 590227 Waryng, Simon, of Shelton, husbandman 0
4841020 2308726 2308726 defendant Stretton Thomas   590227 590227 Stretton, Thomas, of Shelton, parson 1
4885759 2322417 2322417 defendant Salter John yeoman 590227 590227 Salter, John, of Shelton, yeoman 7
4931851 2336349 2336349 plaintiff Waryng Simon   590227 590227 Waryng, Simon, of Shelton 0
4961246 2345330 2345330 plaintiff Blaker alias Barton Richard   590227 590227 Blaker alias Barton, Richard, of Shelton 0
5005045 2358375 2358375 defendant Nicole John husbandman 590227 590227 Nicole, John, of Shelton, husbandman 0
5021260 2363117 2363117 defendant Fannur Robert husbandman 590227 590227 Fannur, Robert, of Shelton, husbandman 4
5030611 2365823 2365823 defendant del Mere Henry husbandman 590227 590227 del Mere, Henry, of Shelton, husbandman 3
5030612 2365823 2365823 defendant Turnemore Thomas husbandman 590227 590227 Turnemore, Thomas, of Shelton, husbandman 4
5030613 2365823 2365823 defendant Bircheore Richard husbandman 590227 590227 Bircheore, Richard, of Shelton, husbandman 5

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