names

111 rows where place_id = 593809

✎ 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
3613412 1871842 1871842 defendant Fakys Richard husbandman 593809 593809 Fakys, Richard, of Cleydon, husbandman 1
3618532 1873420 1873420 defendant Gonty or Gouty William husbandman 593809 593809 Gonty or Gouty, William, of Cleydon, husbandman 0
3625446 1875496 1875496 defendant Hill Robert yeoman 593809 593809 Hill, Robert, of Cleydon, yeoman 0
3672062 1917265 1917265 plaintiff Courtenall John   593809 593809 Courtenall, John, of Cleydon 0
3678650 1919384 1919384 defendant Fox John husbandman 593809 593809 Fox, John, of Cleydon, husbandman 1
3760070 1945148 1945148 plaintiff Courtenall John yeoman 593809 593809 Courtenall, John, of Cleydon, yeoman 0
3760377 1945250 1945250 defendant Foxton Robert husbandman 593809 593809 Foxton, Robert, of Cleydon, husbandman 1
3760378 1945250 1945250 defendant Bennett John husbandman 593809 593809 Bennett, John, of Cleydon, husbandman 2
3778558 1951006 1951006 defendant Gage Richard laborer 593809 593809 Gage, Richard, of Cleydon, laborer 2
3790369 1954804 1954804 defendant Cowrtenall John yeoman 593809 593809 Cowrtenall, John, of Cleydon, yeoman 0
3790379 1954808 1954808 defendant Cowrtnall John yeoman 593809 593809 Cowrtnall, John, of Cleydon, yeoman 0
3795599 1956508 1956508 defendant Gawge Richard butcher 593809 593809 Gawge, Richard, of Cleydon, butcher 0
3840118 1970480 1970480 defendant Fox Robert husbandman 593809 593809 Fox, Robert, of Cleydon, husbandman 4
3845949 1972290 1972290 defendant Foxton Robert laborer 593809 593809 Foxton, Robert, of Cleydon, laborer 2
3845950 1972290 1972290 defendant Benet John   593809 593809 Benet, John, of Cleydon, lime burner 3
3903863 1991529 1991529 plaintiff Gyfford George esq 593809 593809 Gyfford, George, of Cleydon, esq 0
3905061 1991956 1991956 defendant Alyn Richard clerk 593809 593809 Alyn, Richard, of Cleydon, clerk 0
3939950 2003662 2003662 defendant Thrusson John fuller 593809 593809 Thrusson, John, of Cleydon, fuller 0
3959270 2010321 2010321 plaintiff Shankford William   593809 593809 Shankford, William, of Cleydon 0
3964841 2012312 2012312 defendant Kempe Robert husbandman 593809 593809 Kempe, Robert, of Cleydon, husbandman 0
4183448 2089689 2089689 defendant Gage William yeoman 593809 593809 Gage, William, of Cleydon, yeoman 3
4248412 2112458 2112458 defendant Gardiner Ralph blacksmith 593809 593809 Gardiner, Ralph, of Cleydon, blacksmith 1
4329193 2140074 2140074 defendant Courtnall Richard yeoman 593809 593809 Courtnall, Richard, of Cleydon, yeoman 3
4452174 2185664 2185664 defendant Botiller Thomas (legal representative) 593809 593809 Botiller, Thomas, of Cleydon, parson, executor of 1
4540809 2213032 2213032 defendant Seymour John   593809 593809 Seymour, John, of Cleydon 0
4631573 2240766 2240766 defendant Sewyn Robert   593809 593809 Sewyn, Robert, of Cleydon, parson 1
4723480 2272652 2272652 defendant Jorge John miller 593809 593809 Jorge, John, of Cleydon, miller 5
4755734 2282177 2282177 defendant Fer Gregory laborer 593809 593809 Fer, Gregory, of Cleydon, laborer 0
4755810 2282200 2282200 defendant Kynge John thatcher 593809 593809 Kynge, John, of Cleydon, thatcher 0
4770685 2286813 2286813 defendant Smyth John husbandman 593809 593809 Smyth, John, of Cleydon, husbandman 0
4770686 2286813 2286813 defendant Smyth William husbandman 593809 593809 Smyth, William, of Cleydon, husbandman 1
4776325 2288589 2288589 defendant atte Hill John yeoman 593809 593809 atte Hill, John, of Cleydon, yeoman 0
4776326 2288589 2288589 defendant Lokte John yeoman 593809 593809 Lokte, John, of Cleydon, yeoman 1
4776327 2288589 2288589 defendant Faux Richard yeoman 593809 593809 Faux, Richard, of Cleydon, yeoman 2
4996222 2355726 2355726 plaintiff Gylberd Michael   593809 593809 Gylberd, Michael, of Cleydon 0
5054098 2372820 2372820 defendant Feket Thomas laborer 593809 593809 Feket, Thomas, of Cleydon, laborer 1
5056206 2373432 2373432 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5062055 2375209 2375209 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5062057 2375210 2375210 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5062570 2375362 2375362 plaintiff Hill John   593809 593809 Hill, John, of Cleydon 0
5062573 2375363 2375363 plaintiff Hill John   593809 593809 Hill, John,of Cleydon 0
5077102 2379652 2379652 defendant Hill John, senior yeoman 593809 593809 Hill, John, senior, of Cleydon, yeoman 0
5077103 2379652 2379652 defendant Hill John, junior laborer 593809 593809 Hill, John, junior, of Cleydon, laborer 1
5077106 2379653 2379653 defendant Hill John, senior yeoman 593809 593809 Hill, John, senior, of Cleydon, yeoman 0
5077107 2379653 2379653 defendant Hill John, junior laborer 593809 593809 Hill, John, junior, of Cleydon, laborer 1
5078079 2379926 2379926 defendant Hill John limeburner 593809 593809 Hill, John, of Cleydon, limeburner 0
5078080 2379926 2379926 defendant Hill John, junior laborer 593809 593809 Hill, John, junior, of Cleydon, laborer 1
5081636 2381014 2381014 defendant Love Nicholas laborer 593809 593809 Love, Nicholas, of Cleydon, laborer 0
5086693 2382499 2382499 defendant Fakyn John   593809 593809 Fakyn, John, of Cleydon, lime burner 2
5086695 2382500 2382500 plaintiff Hill John   593809 593809 Hill, John, of Cleydon 0
5086700 2382501 2382501 plaintiff Hill John   593809 593809 Hill, John, of Cleydon 0
5094985 2384944 2384944 defendant Hill John limeburner 593809 593809 Hill, John, of Cleydon, limeburner 0
5094986 2384944 2384944 defendant Hill John, junior laborer 593809 593809 Hill, John, junior, of Cleydon, laborer 1
5097636 2385735 2385735 defendant Hyll John, senior   593809 593809 Hyll, John, senior, of Cleydon, lime burner 0
5097637 2385735 2385735 defendant Hyll John, junior laborer 593809 593809 Hyll, John, junior, of Cleydon, laborer 1
5097641 2385735 2385735 defendant Martyn John laborer 593809 593809 Martyn, John, of Cleydon, laborer 5
5097643 2385736 2385736 defendant Hyll John, senior yeoman 593809 593809 Hyll, John, senior, of Cleydon, yeoman 0
5097645 2385737 2385737 defendant Hyll John, senior yeoman 593809 593809 Hyll, John, senior, of Cleydon, yeoman 0
5098765 2386068 2386068 defendant atte Hill John husbandman 593809 593809 atte Hill, John, of Cleydon, husbandman 0
5099253 2386208 2386208 defendant Hyll John yeoman 593809 593809 Hyll, John, of Cleydon, yeoman 0
5099261 2386210 2386210 defendant Hyll John yeoman 593809 593809 Hyll, John, of Cleydon, yeoman 0
5099265 2386211 2386211 defendant Hyll John yeoman 593809 593809 Hyll, John, of Cleydon, yeoman 0
5129684 2395170 2395170 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5129837 2395213 2395213 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5142471 2398926 2398926 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5145131 2399718 2399718 defendant Hill John   593809 593809 Hill, John, of Cleydon, lime burner 0
5149049 2400850 2400850 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5149054 2400851 2400851 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5153047 2402036 2402036 defendant Hill John   593809 593809 Hill, John, of Cleydon, lime burner 0
5159285 2403830 2403830 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5159696 2403938 2403938 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 1
5165710 2405715 2405715 defendant Hill John   593809 593809 Hill, John, of Cleydon, lime burner 0
5168123 2406389 2406389 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5174478 2408236 2408236 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5183955 2411040 2411040 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5195187 2414336 2414336 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5195189 2414337 2414337 defendant Hyll John yeoman 593809 593809 Hyll, John, of Cleydon, yeoman 0
5202227 2416415 2416415 defendant Hill John   593809 593809 Hill, John, of Cleydon, lime burner 0
5204022 2416927 2416927 defendant Hyll John yeoman 593809 593809 Hyll, John, of Cleydon, yeoman 0
5204078 2416942 2416942 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5209143 2418402 2418402 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5221518 2421990 2421990 defendant Gowty Joan widow 593809 593809 Gowty, Joan, of Cleydon, widow 3
5235461 2425949 2425949 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 1
5268757 2435981 2435981 defendant Hyll John   593809 593809 Hyll, John, of Cleydon 0
5278801 2438907 2438907 defendant Hill Nichilas yeoman 593809 593809 Hill, Nichilas, of Cleydon,yeoman 1
5300489 2445108 2445108 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5300495 2445111 2445111 defendant Hille Nicholas yeoman 593809 593809 Hille, Nicholas, of Cleydon, yeoman 0
5300497 2445111 2445111 defendant Reynold John laborer 593809 593809 Reynold, John, of Cleydon, laborer 2
5300498 2445111 2445111 defendant meche William laborer 593809 593809 meche, William, of Cleydon, laborer 3
5304155 2446250 2446250 plaintiff Hill John   593809 593809 Hill, John, of Cleydon 0
5304157 2446251 2446251 plaintiff Hill John, sen yeoman 593809 593809 Hill, John, sen, of Cleydon, yeoman 0
5324124 2452300 2452300 defendant Hyll John yeoman 593809 593809 Hyll, John, of Cleydon, yeoman 0
5336998 2456138 2456138 plaintiff Hill John   593809 593809 Hill, John, of Cleydon 0
5354461 2461466 2461466 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5368431 2465740 2465740 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5371382 2466630 2466630 defendant Mate William chaplain 593809 593809 Mate, William, of Cleydon, chaplain 0
5371384 2466631 2466631 defendant Mate William chaplain 593809 593809 Mate, William, of Cleydon, chaplain 0
5373397 2467273 2467273 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5373399 2467274 2467274 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 0
5373401 2467275 2467275 defendant Hill John yeoman 593809 593809 Hill, John, of Cleydon, yeoman 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);