names

168 rows where place_id = 586615

✎ 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
3589219 1864270 1864270 defendant Bonde Thomas husbandman 586615 586615 Bonde, Thomas, of Croxton, husbandman 2
3597921 1866972 1866972 defendant Hoose John husbandman 586615 586615 Hoose, John, of Croxton, husbandman 0
3597943 1866981 1866981 plaintiff Pyke John   586615 586615 Pyke, John, of Croxton 1
3613046 1871732 1871732 defendant Gonneld John   586615 586615 Gonneld, John, of Croxton 0
3613198 1871782 1871782 defendant Porter William yeoman 586615 586615 Porter, William, of Croxton, yeoman 1
3658035 1912768 1912768 defendant Laxham John, junior   586615 586615 Laxham, John, junior, of Croxton, shepherd 0
3658036 1912768 1912768 defendant Maryatt John husbandman 586615 586615 Maryatt, John, of Croxton, shepherd: Trapet, Robert, of Hepworth, Suff, husbandman 1
3713799 1930615 1930615 defendant Gloucestre Roger gent 586615 586615 Gloucestre, Roger, of Croxton, gent 2
3748424 1941440 1941440 defendant West Thomas husbandman 586615 586615 West, Thomas, of Croxton, husbandman 0
3755694 1943740 1943740 defendant Lucas William husbandman 586615 586615 Lucas, William, of Croxton, husbandman 0
3801724 1958433 1958433 defendant Glocester Roger gent 586615 586615 Glocester, Roger, of Croxton, gent 1
3814768 1962531 1962531 defendant Bulmer Edward husbandman 586615 586615 Bulmer, Edward, of Croxton, husbandman 0
3836723 1969387 1969387 defendant Clerke Thomas husbandman 586615 586615 Clerke, Thomas, of Croxton, husbandman 0
3849050 1973298 1973298 defendant Lyle Thomas   586615 586615 Lyle, Thomas, of Croxton, knight 0
3853291 1974649 1974649 defendant Wylson Thomas husbandman 586615 586615 Wylson, Thomas, of Croxton, husbandman 1
3865636 1978726 1978726 defendant Lucas John husbandman 586615 586615 Lucas, John, of Croxton, husbandman 1
3943240 2004759 2004759 plaintiff Alford Thomas yeoman 586615 586615 Alford, Thomas, of Croxton, yeoman 0
4012862 2029324 2029324 defendant Saunderson Richard laborer 586615 586615 Saunderson, Richard, of Croxton, laborer 1
4076383 2051851 2051851 defendant Farray Robert husbandman 586615 586615 Farray, Robert, of Croxton, husbandman 0
4077960 2052420 2052420 defendant Willson William yeoman 586615 586615 Willson, William, of Croxton, yeoman 0
4102197 2061079 2061079 defendant Sowthe Edward gent 586615 586615 Sowthe, Edward, of Croxton, gent 0
4143914 2076037 2076037 defendant Farrowe Robert husbandman 586615 586615 Farrowe, Robert, of Croxton, husbandman 0
4143915 2076037 2076037 defendant Suggden John husbandman 586615 586615 Suggden, John, of Croxton, husbandman 1
4145946 2076737 2076737 defendant Hornsey John yeoman 586615 586615 Hornsey, John, of Croxton, yeoman 1
4175288 2086824 2086824 defendant Hogon Thomas yeoman 586615 586615 Hogon, Thomas, of Croxton, yeoman 1
4214184 2100479 2100479 defendant Nevall Edmund shingler 586615 586615 Nevall, Edmund, of Croxton, shingler 1
4214588 2100608 2100608 defendant Fassytt or Fassett Thomas yeoman 586615 586615 Fassytt or Fassett, Thomas, of Croxton, yeoman 0
4214591 2100609 2100609 defendant Drewrye William husbandman 586615 586615 Drewrye, William, of Croxton, husbandman 0
4219467 2102309 2102309 defendant Davys Edward yeoman 586615 586615 Davys, Edward, of Croxton, yeoman 1
4222353 2103308 2103308 defendant Barton John husbandman 586615 586615 Barton, John, of Croxton, husbandman 0
4223473 2103699 2103699 defendant Yardeley William carpenter 586615 586615 Yardeley, William, of Croxton, carpenter 2
4241039 2109986 2109986 defendant Drewrye William husbandman 586615 586615 Drewrye, William, of Croxton, husbandman 0
4273372 2120656 2120656 defendant Cossen Jerome yeoman 586615 586615 Cossen, Jerome, of Croxton, yeoman 1
4281982 2123598 2123598 defendant Thurlowe John husbandman 586615 586615 Thurlowe, John, of Croxton, husbandman 0
4282034 2123616 2123616 defendant Thurslowe John husbandman 586615 586615 Thurslowe, John, of Croxton, husbandman 1
4326079 2139092 2139092 defendant Leed Thomas gent 586615 586615 Leed, Thomas, of Croxton, gent 1
4331532 2140842 2140842 defendant Barton John husbandman 586615 586615 Barton, John, of Croxton, husbandman 0
4342087 2144514 2144514 defendant Clement alias Newe William clerk 586615 586615 Clement alias Newe, William, of Croxton, clerk 0
4343948 2145160 2145160 defendant Henrey Bowber laborer 586615 586615 Henrey, Bowber, of Croxton, laborer 3
4344246 2145266 2145266 defendant Bidwell William (legal representative) 586615 586615 Bidwell, William, of Croxton, yeoman, executor of 0
4344247 2145266 2145266 defendant Bydwell Thomas yeoman 586615 586615 Bydwell, Thomas, of Croxton, yeoman 1
4345966 2145851 2145851 defendant Gratewood William, junior husbandman 586615 586615 Gratewood, William, junior, of Croxton, husbandman 0
4345967 2145851 2145851 defendant Tayler Thomas husbandman 586615 586615 Tayler, Thomas, of Croxton, husbandman 1
4350787 2147530 2147530 defendant Barton John yeoman 586615 586615 Barton, John, of Croxton, yeoman 0
4353345 2148393 2148393 defendant Gratewoode William, junior husbandman 586615 586615 Gratewoode, William, junior, of Croxton, husbandman 1
4353348 2148394 2148394 defendant Gratewoode William, junior husbandman 586615 586615 Gratewoode, William, junior, of Croxton, husbandman 1
4373908 2155739 2155739 defendant Gonell Robert   586615 586615 Gonell, Robert, of Croxton, gent, "scholler" 0
4384411 2159476 2159476 defendant Nicklyn Roger laborer 586615 586615 Nicklyn, Roger, of Croxton, laborer 0
4384876 2159630 2159630 defendant Gratewood William husbandman 586615 586615 Gratewood, William, of Croxton, husbandman 1
4385847 2159960 2159960 defendant Edmund Francis husbandman 586615 586615 Edmund, Francis, of Croxton, husbandman 0
4385848 2159960 2159960 defendant Mallesent Francis tailor 586615 586615 Mallesent, Francis, of Croxton, tailor 1
4391393 2161738 2161738 defendant Slacke or Slake Francis clerk 586615 586615 Slacke or Slake, Francis, of Croxton, clerk 0
4392831 2162218 2162218 defendant Clement alias Newe William clerk 586615 586615 Clement alias Newe, William, of Croxton, clerk 0
4399209 2164322 2164322 defendant Slacke Francis clerk 586615 586615 Slacke, Francis, of Croxton, clerk 0
4399888 2164551 2164551 defendant Crowne Robert   586615 586615 Crowne, Robert, of Croxton, shepherd 0
4400196 2164656 2164656 defendant Bootche Thomas husbandman 586615 586615 Bootche, Thomas, of Croxton, husbandman 0
4400197 2164656 2164656 defendant Slacke Francis clerk 586615 586615 Slacke, Francis, of Croxton, clerk 1
4402274 2165348 2165348 defendant Chester alias Lyn Thomas laborer 586615 586615 Chester alias Lyn, Thomas, of Croxton, laborer 0
4402275 2165348 2165348 defendant Nevell John laborer 586615 586615 Nevell, John, of Croxton, laborer 1
4402277 2165348 2165348 defendant Nevall Thomas husbandman 586615 586615 Nevall, Thomas, of Croxton, husbandman 3
4402279 2165349 2165349 defendant Walker James laborer 586615 586615 Walker, James, of Croxton, laborer 0
4402280 2165349 2165349 defendant Grococke Humphrey laborer 586615 586615 Grococke, Humphrey, of Croxton, laborer 1
4402282 2165349 2165349 defendant Allatt Thomas yeoman 586615 586615 Allatt, Thomas, of Croxton, yeoman 3
4402284 2165350 2165350 defendant Chester alias Lyn Thomas laborer 586615 586615 Chester alias Lyn, Thomas, of Croxton, laborer 0
4402285 2165350 2165350 defendant Chester alias Lyn Edward laborer 586615 586615 Chester alias Lyn, Edward, of Croxton, laborer 1
4402287 2165350 2165350 defendant Snelson or Snelston John husbandman 586615 586615 Snelson or Snelston, John, of Croxton, husbandman 3
4402297 2165352 2165352 defendant Harper William laborer 586615 586615 Harper, William, of Croxton, laborer 3
4410618 2168141 2168141 defendant Dymmock Hugh laborer 586615 586615 Dymmock, Hugh, of Croxton, laborer 0
4413393 2169067 2169067 defendant Gonnyld Robert   586615 586615 Gonnyld, Robert, of Croxton 0
4429664 2174069 2174069 defendant Grauncourt John de   586615 586615 Grauncourt, John de, of Croxton 0
4445570 2183567 2183567 defendant Frane of Frave John   586615 586615 Frane of Frave, John, of Croxton 0
4445571 2183568 2183568 plaintiff Croxton John   586615 586615 Croxton, John, of Croxton, parson 0
4449602 2184823 2184823 defendant Estmoor John   586615 586615 Estmoor, John, of Croxton 0
4452736 2185867 2185867 defendant Hare William   586615 586615 Hare, William, of Croxton 0
4458770 2187789 2187789 defendant (not given) William de vicar of Coston 586615 586615 Coston, William de, of Croxton, vicar of the church 0
4465588 2189910 2189910 defendant Charyte John   586615 586615 Charyte, John, of Croxton 0
4465592 2189912 2189912 defendant Charyte John   586615 586615 Charyte, John, of Croxton 0
4474058 2192541 2192541 defendant Proktour John   586615 586615 Proktour, John, of Croxton 0
4474175 2192575 2192575 defendant Wotton Thomas de (legal representative) 586615 586615 Wotton, Thomas de, of Croxton, executors of 0
4479711 2194316 2194316 plaintiff Jonesson Thomas   586615 586615 Jonesson, Thomas, of Croxton 0
4487549 2196824 2196824 plaintiff Smyth Thomas   586615 586615 Smyth, Thomas, of Croxton 0
4493320 2198614 2198614 defendant Payn John   586615 586615 Payn, John, of Croxton 1
4497816 2199959 2199959 defendant Dey Robert   586615 586615 Dey, Robert, of Croxton 0
4499035 2200342 2200342 plaintiff Grantham John   586615 586615 Grantham, John, of Croxton, abbot 0
4503111 2201543 2201543 defendant Suthuby John (legal representative) 586615 586615 Suthuby, John, of Croxton, senior, executors of 0
4503112 2201543 2201543 defendant Suthuby John   586615 586615 (Suthuby, John, of Croxton 1
4503116 2201544 2201544 defendant Suthuby John, senior (legal representative) 586615 586615 Suthuby, John, senior, of Croxton, executors of 0
4503117 2201544 2201544 defendant Suthuby John   586615 586615 (Suthuby, John, of Croxton 1
4548542 2215486 2215486 defendant Coltesworth John   586615 586615 Coltesworth, John, of Croxton 0
4552999 2216882 2216882 defendant Hayward Richard   586615 586615 Hayward, Richard, of Croxton 0
4599754 2231144 2231144 defendant Shymyng William   586615 586615 Shymyng, William, of Croxton 1
4606886 2233264 2233264 defendant Clerk John   586615 586615 Clerk, John, of Croxton 3
4606887 2233264 2233264 defendant Hardy Richard   586615 586615 Hardy, Richard, of Croxton 4
4624818 2238742 2238742 defendant Hardy Richard   586615 586615 Hardy, Richard, of Croxton 8
4643016 2244064 2244064 defendant Smyth Thomas   586615 586615 Smyth, Thomas, of Croxton 2
4643021 2244065 2244065 defendant Smyth Thomas   586615 586615 Smyth, Thomas, of Croxton 2
4645694 2244808 2244808 defendant Hardy Richard   586615 586615 Hardy, Richard, of Croxton 1
4665363 2250651 2250651 defendant Tomlynson John husbandman 586615 586615 Tomlynson, John, of Croxton, husbandman 6
4683516 2260446 2260446 defendant Pverton William   586615 586615 Pverton, William, of Croxton, abbot 0
4685921 2261189 2261189 plaintiff West John   586615 586615 West, John, of Croxton 1

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