names

358 rows where place_id = 587629

✎ 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
3591987 1865108 1865108 defendant Flyntard John husbandman 587629 587629 Flyntard, John, of Chesthunt, husbandman 0
3593181 1865498 1865498 defendant Chare Edmund maltman 587629 587629 Chare, Edmund, of Chesthunt, maltman 0
3612304 1871481 1871481 defendant Godfrey William maltman 587629 587629 Godfrey, William, of Chesthunt, maltman 1
3612305 1871481 1871481 defendant Lawen Peter brewer 587629 587629 Lawen, Peter, of Chesthunt, brewer 2
3612306 1871481 1871481 defendant Wellys William smith 587629 587629 Wellys, William, of Chesthunt, smith 3
3617935 1873233 1873233 defendant Dent John draper 587629 587629 Dent, John, of Chesthunt, draper 0
3618129 1873294 1873294 defendant Eglysse William yeoman 587629 587629 Eglysse, William, of Chesthunt, yeoman 2
3625000 1875352 1875352 defendant Doo Robert husbandman 587629 587629 Doo, Robert, of Chesthunt, husbandman 0
3626962 1903288 1903288 defendant Chaury Margaret   587629 587629 Chaury, Margaret, of Chesthunt 0
3627759 1903542 1903542 defendant Garnet William miller 587629 587629 Garnet, William, of Chesthunt, miller 2
3632359 1904941 1904941 defendant Curets John, senior yeoman 587629 587629 Curets, John, senior, of Chesthunt, yeoman 3
3632360 1904941 1904941 defendant Mundy John yeoman 587629 587629 Mundy, John, of Chesthunt, yeoman 4
3642628 1908138 1908138 defendant Bedyll William esq 587629 587629 Bedyll, William, of Chesthunt, esq 0
3642974 1908252 1908252 defendant Bosell John yeoman 587629 587629 Bosell, John, of Chesthunt, yeoman 1
3642975 1908252 1908252 defendant Thomas John smith 587629 587629 Thomas, John, of Chesthunt, smith 2
3642976 1908252 1908252 defendant Scott John laborer 587629 587629 Scott, John, of Chesthunt, laborer 3
3642977 1908252 1908252 defendant Herd John yeoman 587629 587629 Herd, John, of Chesthunt, yeoman 4
3645093 1908874 1908874 defendant Curteys John baker 587629 587629 Curteys, John, of Chesthunt, baker 0
3645097 1908875 1908875 defendant Curteys John baker 587629 587629 Curteys, John, of Chesthunt, baker 0
3660282 1913477 1913477 defendant Pytcher Edward yeoman 587629 587629 Pytcher, Edward, of Chesthunt, yeoman 1
3660283 1913477 1913477 defendant Percy John laborer 587629 587629 Percy, John, of Chesthunt, laborer 2
3662679 1914246 1914246 defendant Woodhall William tiler 587629 587629 Woodhall, William, of Chesthunt, tiler 2
3662743 1914268 1914268 defendant Mundy John laborer 587629 587629 Mundy, John, of Chesthunt, laborer 0
3670544 1916749 1916749 defendant Adams Thomas collier 587629 587629 Adams, Thomas, of Chesthunt, collier 0
3703252 1927288 1927288 defendant Wylkynson John butcher 587629 587629 Wylkynson, John, of Chesthunt, butcher 0
3715327 1931078 1931078 defendant Nevell Charles brewer 587629 587629 Nevell, Charles, of Chesthunt, brewer 0
3716173 1931350 1931350 defendant Lokkey John yeoman 587629 587629 Lokkey, John, of Chesthunt, yeoman 0
3739534 1938575 1938575 defendant Holder Edward maltman 587629 587629 Holder, Edward, of Chesthunt, maltman 2
3759141 1944846 1944846 defendant Curle William maltman 587629 587629 Curle, William, of Chesthunt, maltman 2
3770526 1948466 1948466 plaintiff Smyth John   587629 587629 Smyth, John, of Chesthunt 0
3771656 1948833 1948833 defendant Cressy Robert husbandman 587629 587629 Cressy, Robert, of Chesthunt, husbandman 2
3777164 1950610 1950610 defendant Toker Thomas butcher 587629 587629 Toker, Thomas, of Chesthunt, butcher 0
3794897 1956271 1956271 defendant Clerke William yeoman 587629 587629 Clerke, William, of Chesthunt, yeoman 0
3796438 1956757 1956757 defendant Cressy Robert husbandman 587629 587629 Cressy, Robert, of Chesthunt, husbandman 0
3796439 1956757 1956757 defendant Smyth Thomas maltman 587629 587629 Smyth, Thomas, of Chesthunt, maltman 1
3798964 1957588 1957588 defendant Poker Thomas butcher 587629 587629 Poker, Thomas, of Chesthunt, butcher 0
3801611 1958402 1958402 defendant Cressy Robert yeoman 587629 587629 Cressy, Robert, of Chesthunt, yeoman 0
3802468 1958671 1958671 defendant Poker Thomas butcher 587629 587629 Poker, Thomas, of Chesthunt, butcher 0
3809713 1960926 1960926 defendant Blythe John gent 587629 587629 Blythe, John, of Chesthunt, gent 0
3819440 1963964 1963964 defendant Stevyns John   587629 587629 Stevyns, John, of Chesthunt, organ player 4
3820136 1964175 1964175 defendant Master Robert maltman 587629 587629 Master, Robert, of Chesthunt, maltman 2
3846045 1972324 1972324 defendant Curtes Margaret widow 587629 587629 Curtes, Margaret, of Chesthunt, widow 0
3846046 1972324 1972324 defendant Brown Agnes spinster 587629 587629 Brown, Agnes, of Chesthunt, spinster 1
3846047 1972324 1972324 defendant Harryson Thomas husbandman 587629 587629 Harryson, Thomas, of Chesthunt, husbandman 2
3846048 1972324 1972324 defendant Brown Thomas laborer 587629 587629 Brown, Thomas, of Chesthunt, laborer 3
3851642 1974101 1974101 defendant Brykyt Hugh yeoman 587629 587629 Brykyt, Hugh, of Chesthunt, yeoman 0
3851643 1974101 1974101 defendant Aboon Kerevyn laborer 587629 587629 Aboon, Kerevyn, of Chesthunt, laborer 1
3851644 1974101 1974101 defendant Smyth Edward laborer 587629 587629 Smyth, Edward, of Chesthunt, laborer 2
3851645 1974101 1974101 defendant Cledge Thomas fisher 587629 587629 Cledge, Thomas, of Chesthunt, fisher 3
3874580 1981721 1981721 defendant Cordell Henry laborer 587629 587629 Cordell, Henry, of Chesthunt, laborer 0
3874581 1981721 1981721 defendant Cordell John laborer 587629 587629 Cordell, John, of Chesthunt, laborer 1
3882479 1984403 1984403 defendant Gryndyll Robert tailor 587629 587629 Gryndyll, Robert, of Chesthunt, tailor 1
3885014 1985247 1985247 defendant Bussey Thomas husbandman 587629 587629 Bussey, Thomas, of Chesthunt, husbandman 0
3903283 1991321 1991321 defendant Garrett William butcher 587629 587629 Garrett, William, of Chesthunt, butcher 2
3912723 1994589 1994589 defendant Adams William husbandman 587629 587629 Adams, William, of Chesthunt, husbandman 1
3914832 1995307 1995307 plaintiff Clercke William   587629 587629 Clercke, William, of Chesthunt 1
3942086 2004367 2004367 defendant Ought William maltman 587629 587629 Ought, William, of Chesthunt, maltman 2
3942090 2004368 2004368 defendant Bosshewe Simon yeoman 587629 587629 Bosshewe, Simon, of Chesthunt, yeoman 2
3968127 2013477 2013477 defendant Fletcher John husbandman 587629 587629 Fletcher, John, of Chesthunt, husbandman 0
3969387 2013898 2013898 defendant Fletcher Christopher yeoman 587629 587629 Fletcher, Christopher, of Chesthunt, yeoman 0
3969388 2013898 2013898 defendant Ivott William laborer 587629 587629 Ivott, William, of Chesthunt, laborer 1
3972495 2014957 2014957 defendant Lowen Simon carpenter 587629 587629 Lowen, Simon, of Chesthunt, carpenter 2
4027238 2034389 2034389 defendant Sturman John husbandman 587629 587629 Sturman, John, of Chesthunt, husbandman 2
4055919 2044497 2044497 plaintiff Bonde Michael (legal representative) 587629 587629 Bonde, Michael, of Chesthunt, or of Braughing, yeoman, executors of 0
4123900 2068847 2068847 defendant Chare Robert yeoman 587629 587629 Chare, Robert, of Chesthunt, yeoman 2
4123901 2068847 2068847 defendant Shelley John yeoman 587629 587629 Shelley, John, of Chesthunt, yeoman 3
4124678 2069120 2069120 defendant Norton Lawrence yeoman 587629 587629 Norton, Lawrence, of Chesthunt, yeoman 0
4235089 2107828 2107828 defendant Shellye John loader 587629 587629 Shellye, John, of Chesthunt, yeoman, loader 0
4262354 2117079 2117079 defendant Dutton Adam yeoman 587629 587629 Dutton, Adam, of Chesthunt, yeoman 2
4262358 2117080 2117080 defendant Dutton Adam yeoman 587629 587629 Dutton, Adam, of Chesthunt, yeoman 2
4319979 2137092 2137092 defendant Greene Gilbert yeoman 587629 587629 Greene, Gilbert, of Chesthunt, yeoman 2
4339707 2143661 2143661 defendant Royse Thomas husbandman 587629 587629 Royse, Thomas, of Chesthunt, husbandman 3
4340695 2144018 2144018 defendant Cockerell Ralph maltman 587629 587629 Cockerell, Ralph, of Chesthunt, maltman 0
4362805 2151756 2151756 defendant Leake Robert maltman 587629 587629 Leake, Robert, of Chesthunt, maltman 0
4363040 2151845 2151845 defendant Wardrop alias Hearde Humphrey husbandman 587629 587629 Wardrop alias Hearde, Humphrey, of Chesthunt, husbandman 2
4363041 2151845 2151845 defendant Royse Thomas husbandman 587629 587629 Royse, Thomas, of Chesthunt, husbandman 3
4370650 2154555 2154555 defendant Norton Lawrence tailor 587629 587629 Norton, Lawrence, of Chesthunt, tailor 0
4394362 2162713 2162713 defendant Clarcke Henry miller 587629 587629 Clarcke, Henry, of Chesthunt, yeoman, miller 0
4394364 2162714 2162714 defendant Clarcke William miller 587629 587629 Clarcke, William, of Chesthunt, yeoman, miller 0
4398434 2164057 2164057 defendant Norton Lawrence tailor 587629 587629 Norton, Lawrence, of Chesthunt, tailor 0
4401369 2165055 2165055 defendant Geales Roger yeoman 587629 587629 Geales, Roger, of Chesthunt, yeoman 0
4431212 2174523 2174523 plaintiff Bergh Martin de   587629 587629 Bergh, Martin de, of Chesthunt 0
4431213 2174523 2174523 defendant Bocher Robert   587629 587629 Bocher, Robert, of Chesthunt 0
4456417 2187028 2187028 plaintiff Northorn Thomas   587629 587629 Northorn, Thomas, of Chesthunt 0
4494224 2198884 2198884 defendant Mawer Thomas   587629 587629 Mawer, Thomas, of Chesthunt 0
4502193 2201284 2201284 defendant Milward John, junior   587629 587629 Milward, John, junior, of Chesthunt 1
4502207 2201288 2201288 defendant Baker John   587629 587629 Baker, John, of Chesthunt 1
4503359 2201623 2201623 plaintiff Payntour Andrew   587629 587629 Payntour, Andrew, of Chesthunt 0
4508511 2203136 2203136 defendant Merston John esq 587629 587629 Merston, John, of Chesthunt, esq 1
4513602 2204679 2204679 defendant Norman Robert   587629 587629 Norman, Robert, of Chesthunt, formerly parson of Ledenham 0
4526598 2208596 2208596 defendant Palmer Walter   587629 587629 Palmer, Walter, of Chesthunt 1
4546425 2214814 2214814 plaintiff Breton John   587629 587629 Breton, John, of Chesthunt 0
4551046 2216270 2216270 plaintiff Donvere William   587629 587629 Donvere, William, of Chesthunt 0
4551047 2216270 2216270 defendant Westhey William   587629 587629 Westhey, William, of Chesthunt 0
4559389 2218886 2218886 defendant Kynge John   587629 587629 Kynge, John, of Chesthunt 2
4559390 2218886 2218886 defendant Bysburgh John   587629 587629 Bysburgh, John, of Chesthunt 3
4559391 2218886 2218886 defendant Flyntehard Peter   587629 587629 Flyntehard, Peter, of Chesthunt 4
4559392 2218886 2218886 defendant Baker John   587629 587629 Baker, John, of Chesthunt 5
4559394 2218886 2218886 defendant Bolton Thomas, sen   587629 587629 Bolton, Thomas, sen, of Chesthunt 7
4561767 2219614 2219614 defendant Creek William   587629 587629 Creek, William, of Chesthunt 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);