names

109 rows where place_id = 590610

✎ 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
3601780 1868214 1868214 defendant Chumme Richard husbandman 590610 590610 Chumme, Richard, of Hempsted, husbandman 2
3601784 1868215 1868215 defendant Chumme Richard husbandman 590610 590610 Chumme, Richard, of Hempsted, husbandman 2
3601788 1868216 1868216 defendant Chumme Richard husbandman 590610 590610 Chumme, Richard, of Hempsted, husbandman 2
3622316 1874516 1874516 defendant Penkeney Benedict yeoman 590610 590610 Penkeney, Benedict, of Hempsted, yeoman 0
3629045 1903962 1903962 defendant Crosse George gent 590610 590610 Crosse, George, of Hempsted, gent 0
3637331 1906479 1906479 defendant Hunt Robert husbandman 590610 590610 (Hunt, Robert, of Hempsted, husbandman 1
3648859 1910032 1910032 defendant Gurney Thomas esq 590610 590610 Gurney, Thomas, of Hempsted, esq 0
3651043 1910691 1910691 defendant Henlyng Robert husbandman 590610 590610 Henlyng, Robert, of Hempsted, husbandman 1
3665755 1915236 1915236 defendant Hache William husbandman 590610 590610 Hache, William, of Hempsted, husbandman 1
3665762 1915237 1915237 defendant Hache William husbandman 590610 590610 Hache, William, of Hempsted, husbandman 1
3668395 1916064 1916064 defendant Hatche William husbandman 590610 590610 Hatche, William, of Hempsted, husbandman 0
3671570 1917092 1917092 defendant Waterson James smith 590610 590610 Waterson, James, of Hempsted, smith 2
3676401 1918664 1918664 defendant Rose Edmund husbandman 590610 590610 Rose, Edmund, of Hempsted, husbandman 0
3687350 1922222 1922222 defendant Emes Robert yeoman 590610 590610 Emes, Robert, of Hempsted, yeoman 2
3692259 1923749 1923749 defendant Hatche William husbandman 590610 590610 Hatche, William, of Hempsted, husbandman 0
3692260 1923749 1923749 defendant Hatche Henry husbandman 590610 590610 Hatche, Henry, of Hempsted, husbandman 1
3692263 1923750 1923750 defendant Rose Edmund husbandman 590610 590610 Rose, Edmund, of Hempsted, husbandman 0
3694531 1924493 1924493 defendant Aleyn Robert husbandman 590610 590610 Aleyn, Robert, of Hempsted, husbandman 0
3705132 1927893 1927893 defendant Hawkyns John husbandman 590610 590610 Hawkyns, John, of Hempsted, husbandman 0
3706985 1928467 1928467 defendant Kybytt Henry husbandman 590610 590610 Kybytt, Henry, of Hempsted, husbandman 2
3712602 1930257 1930257 defendant Rogers John husbandman 590610 590610 Rogers, John, of Hempsted, husbandman 0
3732875 1936510 1936510 defendant Pope William maltman 590610 590610 Pope, William, of Hempsted, maltman 0
3766381 1947139 1947139 defendant Remarse Thomas smith 590610 590610 Remarse, Thomas, of Hempsted, smith 2
3780438 1951616 1951616 defendant Aleyn Robert husbandman 590610 590610 Aleyn, Robert, of Hempsted, husbandman 2
3784475 1952929 1952929 plaintiff Mason Nicholas   590610 590610 Mason, Nicholas, of Hempsted 0
3785024 1953097 1953097 defendant Alen John yeoman 590610 590610 Alen, John, of Hempsted, yeoman 2
3808455 1960522 1960522 defendant Westley George husbandman 590610 590610 Westley, George, of Hempsted, husbandman 1
3809556 1960874 1960874 defendant Wodde Robert clerk 590610 590610 Wodde, Robert, of Hempsted, clerk 1
3821953 1964760 1964760 defendant Hopson Walter butcher 590610 590610 Hopson, Walter, of Hempsted, butcher 2
3821978 1964765 1964765 defendant Polle John husbandman 590610 590610 Polle, John, of Hempsted, husbandman 0
3849260 1973361 1973361 defendant Lyster William gent 590610 590610 Lyster, William, of Hempsted, gent 2
3862799 1977750 1977750 defendant Man William mariner 590610 590610 Man, William, of Hempsted, mariner 1
3893089 1987935 1987935 defendant Yarham Henry clerk 590610 590610 Yarham, Henry, of Hempsted, clerk 0
3894318 1988318 1988318 plaintiff Robkyn Thomas   590610 590610 Robkyn, Thomas, of Hempsted 0
3897992 1989534 1989534 defendant Johnson Peter mariner 590610 590610 Johnson, Peter, of Hempsted, mariner 2
3897997 1989535 1989535 defendant Johnson Peter mariner 590610 590610 Johnson, Peter, of Hempsted, mariner 2
3901037 1990575 1990575 defendant Allen Robert husbandman 590610 590610 Allen, Robert, of Hempsted, husbandman 1
3906707 1992537 1992537 plaintiff Mordaunt Robert esq 590610 590610 Mordaunt, Robert, of Hempsted, esq 0
3908516 1993147 1993147 plaintiff Robkyn Thomas   590610 590610 Robkyn, Thomas, of Hempsted 0
3941194 2004058 2004058 defendant Annyson alias Shig Henry mariner 590610 590610 Annyson alias Shig, Henry, of Hempsted, mariner 0
3941195 2004058 2004058 defendant Barker Robert mariner 590610 590610 Barker, Robert, of Hempsted, mariner 1
3947524 2006206 2006206 plaintiff Coll Edmund   590610 590610 Coll, Edmund, of Hempsted, husbandman, aministrators of 0
3966676 2012982 2012982 plaintiff Bretyngham Nicholas   590610 590610 Bretyngham, Nicholas, of Hempsted, worsted weaver 0
3989087 2020839 2020839 defendant Byrry Richard husbandman 590610 590610 Byrry, Richard, of Hempsted, husbandman 1
4004768 2026483 2026483 plaintiff Johnsons Robert singleman 590610 590610 Johnsons, Robert, of Hempsted, singleman 0
4036455 2037725 2037725 plaintiff Hunte Edmund gent 590610 590610 Hunte, Edmund, of Hempsted, gent 0
4036458 2037726 2037726 plaintiff Hunte Edmund gent 590610 590610 Hunte, Edmund, of Hempsted, gent 0
4038028 2038246 2038246 plaintiff Kynge William yeoman 590610 590610 Kynge, William, of Hempsted, yeoman 0
4066499 2048309 2048309 defendant Cattam Nicholas yeoman 590610 590610 Cattam, Nicholas, of Hempsted, yeoman 2
4068978 2049192 2049192 defendant Grixe John tanner 590610 590610 Grixe, John, of Hempsted, tanner 0
4073403 2050774 2050774 defendant Thurkell James tanner 590610 590610 Thurkell, James, of Hempsted, tanner 0
4073404 2050774 2050774 defendant Gryxe or Eryxe John tanner 590610 590610 Gryxe or Eryxe, John, of Hempsted, tanner 1
4091018 2057077 2057077 defendant Westweeke John husbandman 590610 590610 Westweeke, John, of Hempsted, husbandman 0
4160789 2081850 2081850 defendant Barker John husbandman 590610 590610 Barker, John, of Hempsted, husbandman 3
4174114 2086400 2086400 defendant Spilman Godfrey husbandman 590610 590610 Spilman, Godfrey, of Hempsted, husbandman 0
4175026 2086732 2086732 defendant Hart Stephen husbandman 590610 590610 Hart, Stephen, of Hempsted, husbandman 3
4182347 2089301 2089301 defendant Morgan Arthur yeoman 590610 590610 Morgan, Arthur, of Hempsted, yeoman 0
4196766 2094416 2094416 defendant Kynge William yeoman 590610 590610 Kynge, William, of Hempsted, yeoman 0
4205256 2097389 2097389 defendant Symes John husbandman 590610 590610 Symes, John, of Hempsted, husbandman 1
4213664 2100299 2100299 defendant Pope Thomas shoemaker 590610 590610 Pope, Thomas, of Hempsted, shoemaker 1
4214016 2100422 2100422 defendant Cooke Edmund carpenter 590610 590610 Cooke, Edmund, of Hempsted, carpenter 2
4214018 2100423 2100423 defendant Cicelyson alias Busshoppe Robert carpenter 590610 590610 Cicelyson alias Busshoppe, Robert, of Hempsted, carpenter 0
4223785 2103804 2103804 defendant Goslynge John yeoman 590610 590610 Goslynge, John, of Hempsted, yeoman 1
4260715 2116550 2116550 defendant Hart Stephen yeoman 590610 590610 Hart, Stephen, of Hempsted, yeoman 3
4265594 2118129 2118129 defendant Bishop Robert carpenter 590610 590610 Bishop, Robert, of Hempsted, carpenter 2
4274411 2120995 2120995 defendant Longe Richard butcher 590610 590610 Longe, Richard, of Hempsted, butcher 0
4275583 2121403 2121403 defendant Moores Francis miller 590610 590610 Moores, Francis, of Hempsted, miller 0
4279707 2122820 2122820 defendant Blysse Richard laborer 590610 590610 Blysse, Richard, of Hempsted, laborer 0
4279708 2122821 2122821 defendant Turnor Roger   590610 590610 Turnor, Roger, of Hempsted, tallow chandler 0
4290543 2126677 2126677 defendant Waterson Abraham husbandman 590610 590610 Waterson, Abraham, of Hempsted, husbandman 0
4311611 2134204 2134204 defendant Cockeston Robert blacksmith 590610 590610 Cockeston, Robert, of Hempsted, blacksmith 0
4311612 2134204 2134204 defendant Cycelyson alias Byshop Robert carpenter 590610 590610 Cycelyson alias Byshop, Robert, of Hempsted, carpenter 1
4320695 2137331 2137331 defendant Robbes Nicholas yeoman 590610 590610 Robbes, Nicholas, of Hempsted, yeoman 1
4323229 2138184 2138184 defendant Bugdon William   590610 590610 Bugdon, William, of Hempsted, oatmeal maker 1
4323830 2138382 2138382 defendant Baye John miller 590610 590610 Baye, John, of Hempsted, miller 2
4333122 2141366 2141366 defendant Baker John chapman 590610 590610 Baker, John, of Hempsted, chapman 1
4334563 2141832 2141832 defendant Budyen William   590610 590610 Budyen, William, of Hempsted, oatmeal maker 1
4335617 2142188 2142188 defendant Ulf Nicholas baker 590610 590610 Ulf, Nicholas, of Hempsted, baker 0
4336432 2142476 2142476 defendant Wright William carpenter 590610 590610 Wright, William, of Hempsted, carpenter 3
4345469 2145686 2145686 defendant Sassert Henry Herts, chapman 590610 590610 Sassert. Henry, of Hempsted, Herts, chapman 2
4377709 2157099 2157099 defendant Guilford Henry esq 590610 590610 Guilford, Henry, of Hempsted, esq 0
4394018 2162600 2162600 defendant Guildford Henry   590610 590610 Guildford, Henry, of Hempsted, Kent esq 0
4394477 2162749 2162749 defendant Becker William cordwainer 590610 590610 Becker, William, of Hempsted, cordwainer 0
4405604 2166445 2166445 defendant Pemerton Grimbol brewer 590610 590610 Pemerton, Grimbol, of Hempsted, brewer 0
4405605 2166445 2166445 defendant Baker John tailor 590610 590610 Baker, John, of Hempsted, tailor 1
4406474 2166730 2166730 defendant Allyn John yeoman 590610 590610 Allyn, John, of Hempsted, yeoman 0
4406475 2166730 2166730 defendant Paynell John yeoman 590610 590610 Paynell, John, of Hempsted, yeoman 1
4410373 2168067 2168067 defendant Longe Richard butcher 590610 590610 Longe, Richard, of Hempsted, butcher 3
4532144 2210319 2210319 defendant Shyryngham Edmund de   590610 590610 Shyryngham, Edmund de, of Hempsted 0
4698559 2265022 2265022 plaintiff Dalton John   590610 590610 Dalton, John, of Hempsted 0
4715510 2270184 2270184 defendant Walkelyn Robert husbandman 590610 590610 Walkelyn, Robert, of Hempsted, husbandman 2
4725999 2273418 2273418 defendant Smyth Robert   590610 590610 Smyth, Robert, of Hempsted, parson 2
4827046 2304500 2304500 defendant Randolf William yeoman & son of Nicholas Randolf 590610 590610 Randolf, William, of Hempsted, yeoman & son of Nicholas Randolf 3
4933591 2336889 2336889 defendant Trenche John yeoman 590610 590610 Trenche, John, of Hempsted, yeoman 0
5282778 2440023 2440023 defendant Caye Thomas clerk 590610 590610 Caye, Thomas, of Hempsted, clerk 1
5376661 2468294 2468294 defendant Tayllard John chaplain 590610 590610 Tayllard, John, of Hempsted, chaplain 0
5393086 2473092 2473092 defendant Bertford John husbandman 590610 590610 Bertford, John, of Hempsted, husbandman 3
5488432 2501432 2501432 plaintiff Westley Thomas (legal representative) 590610 590610 Westley, Thomas, of Hempsted, executors of 0
5488437 2501433 2501433 plaintiff Westley Thomas (legal representative) 590610 590610 Westley, Thomas, of Hempsted, executors of 0
5502796 2505788 2505788 defendant Mighill John husbandman 590610 590610 Mighill, John, of Hempsted, 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);