names

124 rows where place_id = 608735

✎ 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
3675134 1918251 1918251 defendant Whithorne John dyer 608735 608735 Whithorne, John, of Charde, Soms, dyer 1
3695209 1924722 1924722 defendant Ivery John baker 608735 608735 Ivery, John, of Charde, Soms, baker 0
3698663 1925799 1925799 defendant Ivery John baker 608735 608735 Ivery, John, of Charde, Soms, baker 0
3712584 1930251 1930251 defendant Cagon Nicholas chapman 608735 608735 Cagon, Nicholas, of Charde, Soms, chapman 0
3717756 1931855 1931855 defendant Appoyll Robert husbandman 608735 608735 Appoyll, Robert, of Charde, Soms, husbandman 0
3720528 1932702 1932702 defendant Whythorne William dyer 608735 608735 Whythorne, William, of Charde, Soms, dyer 0
3724608 1933978 1933978 defendant Huyshe John yeoman 608735 608735 Huyshe, John, of Charde, Soms, yeoman 1
3736314 1937599 1937599 defendant Whythorne William dyer 608735 608735 Whythorne, William, of Charde, Soms, dyer 0
3736316 1937600 1937600 defendant Cogan Nicholas mercer 608735 608735 Cogan, Nicholas, of Charde, Soms, mercer 0
3882692 1984477 1984477 defendant Cogan Nicholas chapman 608735 608735 Cogan, Nicholas, of Charde, Soms, chapman 2
3887152 1985967 1985967 plaintiff Cogan Richard merchant 608735 608735 Cogan, Richard, of Charde, Soms, merchant 0
3888552 1986430 1986430 defendant Coghen Robert chapman 608735 608735 Coghen, Robert, of Charde, Soms, chapman 2
3914937 1995346 1995346 plaintiff Cogeyn Richard merchant 608735 608735 Cogeyn, Richard, of Charde, Soms, merchant 0
3915869 1995686 1995686 defendant Bruer John, senior merchant 608735 608735 Bruer, John, senior, of Charde, Soms, merchant 0
3915870 1995686 1995686 defendant Bruer John, junior merchant 608735 608735 Bruer, John, junior, of Charde, Soms, merchant 1
3928611 1999907 1999907 defendant Baylly John, junior merchant 608735 608735 Baylly, John, junior, of Charde, Soms, merchant 0
3928613 1999908 1999908 defendant Baylly John, junior merchant 608735 608735 Baylly, John, junior, of Charde, Soms, merchant 0
3942392 2004468 2004468 defendant Hill Richard draper 608735 608735 Hill, Richard, of Charde, Soms, draper 0
3945338 2005453 2005453 defendant Clapp Oliver merchant 608735 608735 Clapp, Oliver, of Charde, Soms, merchant 0
3947429 2006174 2006174 defendant Clapp Nicholas yeoman 608735 608735 Clapp, Nicholas, of Charde, Soms, yeoman 0
3948192 2006430 2006430 defendant Gregory John merchant 608735 608735 Gregory, John, of Charde, Soms, merchant 0
3959136 2010282 2010282 plaintiff Selwood Thomas gent 608735 608735 Selwood, Thomas, of Charde, Soms, gent 0
3961929 2011268 2011268 defendant More alias Brewer Thomas merchant 608735 608735 More alias Brewer, Thomas, of Charde, Soms, merchant 0
3962892 2011615 2011615 defendant Walrond Humphrey gent 608735 608735 Walrond, Humphrey, of Charde, Soms, gent 0
3963456 2011824 2011824 defendant Walrond Humphrey gent 608735 608735 Walrond, Humphrey, of Charde, Soms, gent 0
3966149 2012789 2012789 plaintiff Bobett John merchant 608735 608735 Bobett, John, of Charde, Soms, merchant 0
3968854 2013735 2013735 plaintiff Cogan Thomas merchant 608735 608735 Cogan, Thomas, of Charde, Soms, merchant 0
3968858 2013736 2013736 plaintiff Cogan Thomas merchant 608735 608735 Cogan, Thomas, of Charde, Soms, merchant 0
3968863 2013737 2013737 defendant Clappe John merchant 608735 608735 Clappe, John, of Charde, Soms, merchant 2
3973199 2015196 2015196 defendant Selwoode Thomas merchant 608735 608735 Selwoode, Thomas, of Charde, Soms, merchant 2
3978106 2016918 2016918 defendant Gregorye John merchant 608735 608735 Gregorye, John, of Charde, Soms, merchant 0
3982379 2018471 2018471 plaintiff Samford Richard merchant 608735 608735 Samford, Richard, of Charde, Soms, or of Sydbery, merchant 0
3992977 2022241 2022241 defendant Howell John merchant 608735 608735 Howell, John, of Charde, Soms, merchant 9
3994400 2022750 2022750 plaintiff Cogan Thomas clothier 608735 608735 Cogan, Thomas, of Charde, Soms, clothier 0
3994402 2022751 2022751 plaintiff Cogan Thomas merchant 608735 608735 Cogan, Thomas, of Charde, Soms, merchant 0
3994404 2022752 2022752 plaintiff Cogan Thomas merchant 608735 608735 Cogan, Thomas, of Charde, Soms, merchant 0
3994406 2022753 2022753 plaintiff Cogan Thomas merchant 608735 608735 Cogan, Thomas, of Charde, Soms, merchant 0
3994408 2022754 2022754 plaintiff Cogan Thomas merchant 608735 608735 Cogan, Thomas, of Charde, Soms, merchant 0
3994410 2022755 2022755 plaintiff Cogan Thomas merchant 608735 608735 Cogan, Thomas, of Charde, Soms, merchant 0
4005729 2026824 2026824 defendant Simmes Thomas clothier 608735 608735 Simmes, Thomas, of Charde, Soms, clothier 0
4009097 2028021 2028021 plaintiff Mychell Richard merchant 608735 608735 Mychell, Richard, of Charde, Soms, merchant 0
4027895 2034628 2034628 plaintiff Cogan Thomas merchant 608735 608735 Cogan, Thomas, of Charde, Soms, merchant 0
4033592 2036663 2036663 defendant Eldron Wiilliam merchant 608735 608735 (Eldron, Wiilliam, of Charde, Soms, merchant 4
4047154 2041429 2041429 defendant Huddie John gent 608735 608735 Huddie, John, of Charde, Soms, gent 0
4047158 2041430 2041430 defendant Huddye John gent 608735 608735 Huddye, John, of Charde, Soms, gent 0
4056079 2044562 2044562 plaintiff Bourman Henry merchant 608735 608735 Bourman, Henry, of Charde, Soms, merchant 0
4059027 2045626 2045626 plaintiff Cogan Thomas clothier 608735 608735 Cogan, Thomas, of Charde, Soms, clothier 0
4059029 2045627 2045627 plaintiff Cogan Thomas clothier 608735 608735 Cogan, Thomas, of Charde, Soms, clothier 0
4061371 2046470 2046470 defendant Woulmyngton Robert clothier 608735 608735 Woulmyngton, Robert, of Charde, Soms, clothier 0
4061372 2046470 2046470 defendant Parker William clothier 608735 608735 Parker, William, of Charde, Soms, clothier 1
4063865 2047359 2047359 defendant Alstone James   608735 608735 Alstone, James, of Charde, Soms, linen draper 3
4064490 2047579 2047579 defendant Clape Nicholas clothier 608735 608735 Clape, Nicholas, of Charde, Soms, clothier 0
4077120 2052099 2052099 defendant Bagge Roger innholder 608735 608735 Bagge, Roger, of Charde, Soms, innholder 0
4082581 2054075 2054075 defendant Wulmyngton Robert clothier 608735 608735 Wulmyngton, Robert, of Charde, Soms, clothier 0
4086680 2055525 2055525 defendant Kyrforde Richard clothier 608735 608735 Kyrforde, Richard, of Charde, Soms, clothier 0
4088104 2056042 2056042 defendant Courte alias Harrys John yeoman 608735 608735 Courte alias Harrys, John, of Charde, Soms, yeoman 3
4088133 2056048 2056048 defendant Grobham Thomas baker 608735 608735 Grobham, Thomas, of Charde, Soms, baker 1
4089267 2056446 2056446 defendant Sandford Richard merchant 608735 608735 Sandford, Richard, of Charde, Soms, merchant 0
4093425 2057965 2057965 defendant Sprake John clothier 608735 608735 Sprake, John, of Charde, Soms, clothier 0
4098949 2059949 2059949 defendant Sandford Richard merchant 608735 608735 Sandford, Richard, of Charde, Soms, merchant 0
4099455 2060134 2060134 defendant Sprake John clothier 608735 608735 Sprake, John, of Charde, Soms, clothier 0
4102935 2061340 2061340 defendant Baylie Humphrey   608735 608735 Baylie, Humphrey, of Charde, Soms, gent, son of John Baylie 0
4111797 2064468 2064468 defendant Frye William chapman 608735 608735 Frye, William, of Charde, Soms, yeoman, chapman 0
4116312 2066121 2066121 defendant Wyatt John miller 608735 608735 Wyatt, John, of Charde, Soms, miller 0
4126125 2069633 2069633 defendant Blagge Roger innholder 608735 608735 Blagge, Roger, of Charde, Soms, innholder 0
4135792 2073129 2073129 defendant Cogan John, junior merchant 608735 608735 Cogan, John, junior, of Charde, Soms, merchant 0
4156521 2080356 2080356 defendant Wolmyngton William merchant 608735 608735 Wolmyngton, William, of Charde, Soms, merchant 0
4159873 2081519 2081519 defendant Cogan John, junior merchant 608735 608735 Cogan, John, junior, of Charde, Soms, merchant 0
4162839 2082542 2082542 defendant Kyrford William gent 608735 608735 Kyrford, William, of Charde, Soms, gent 25
4168652 2084522 2084522 defendant Bagge Roger innholder 608735 608735 Bagge, Roger, of Charde, Soms, innholder 0
4168663 2084527 2084527 defendant Grymstede Thomas clothier 608735 608735 Grymstede, Thomas, of Charde, Soms, clothier 0
4175314 2086834 2086834 defendant Pulman William merchant 608735 608735 Pulman, William, of Charde, Soms, merchant 0
4180953 2088816 2088816 defendant Parris John merchant 608735 608735 Parris, John, of Charde, Soms, merchant 0
4181091 2088861 2088861 defendant Sandforde Richard gent 608735 608735 Sandforde, Richard, of Charde, Soms, gent 2
4181830 2089125 2089125 defendant Sprake John clothier 608735 608735 Sprake, John, of Charde, Soms, clothier 0
4181867 2089137 2089137 defendant Cole Brian clothier 608735 608735 Cole, Brian, of Charde, Soms, clothier 1
4186775 2090863 2090863 defendant Raymond Thomas gent 608735 608735 Raymond, Thomas, of Charde, Soms, gent 0
4192096 2092797 2092797 defendant Pytcher Robert tailor 608735 608735 Pytcher, Robert, of Charde, Soms, tailor 0
4192116 2092805 2092805 defendant Grymstede Thomas clothier 608735 608735 Grymstede, Thomas, of Charde, Soms, clothier 0
4192118 2092806 2092806 defendant Grymstede Thomas clothier 608735 608735 Grymstede, Thomas, of Charde, Soms, clothier 0
4197476 2094676 2094676 defendant Burton Thomas merchant 608735 608735 Burton, Thomas, of Charde, Soms, merchant 0
4206297 2097750 2097750 defendant Bagge Roger innholder 608735 608735 Bagge, Roger, of Charde, Soms, innholder 0
4206901 2097956 2097956 defendant Ledore alias James William baker 608735 608735 Ledore alias James, William, of Charde, Soms, or of Weymouth Melcom Regis, baker 0
4207231 2098077 2098077 defendant Sanforde Richard merchant 608735 608735 Sanforde, Richard, of Charde, Soms, merchant 0
4210175 2099120 2099120 defendant Grymsted Thomas clothier 608735 608735 Grymsted, Thomas, of Charde, Soms, clothier 1
4210424 2099204 2099204 defendant Cole Brian   608735 608735 Cole, Brian, of Charde, Soms, merchent 0
4210453 2099213 2099213 defendant Webbe William pewterer 608735 608735 Webbe, William, of Charde, Soms, pewterer 1
4213680 2100303 2100303 defendant Burton Thomas chapman 608735 608735 Burton, Thomas, of Charde, Soms, chapman 3
4214062 2100437 2100437 defendant Deane Lancelot clothier 608735 608735 Deane, Lancelot, of Charde, Soms, clothier 0
4215643 2100970 2100970 defendant Webbe William pewterer 608735 608735 Webbe, William, of Charde, Soms, pewterer 0
4219823 2102438 2102438 defendant Banton John tucker 608735 608735 Banton, John, of Charde, Soms, tucker 0
4241798 2110247 2110247 defendant Webbe William pewterer 608735 608735 Webbe, William, of Charde, Soms, pewterer 0
4246369 2111764 2111764 defendant Cole Brian chapman 608735 608735 Cole, Brian, of Charde, Soms, chapman 0
4246877 2111930 2111930 defendant Grymster or Grymstead Thomas clothier 608735 608735 Grymster or Grymstead, Thomas, of Charde, Soms, clothier 0
4270877 2119833 2119833 defendant Cole Brian chapman 608735 608735 Cole, Brian, of Charde, Soms, chapman 0
4278347 2122366 2122366 defendant Pytcher Andrew chapman 608735 608735 Pytcher, Andrew, of Charde, Soms, chapman 0
4287317 2125520 2125520 defendant Doughtye Edward clerk 608735 608735 Doughtye, Edward, of Charde, Soms, clerk 0
4287816 2125689 2125689 defendant Cogan Thomas merchant 608735 608735 Cogan, Thomas, of Charde, Soms, merchant 1
4288823 2126057 2126057 defendant Wolmyngton Robert chapman 608735 608735 Wolmyngton, Robert, of Charde, Soms, chapman 1
4292262 2127298 2127298 defendant Gale Richard vintner 608735 608735 Gale, Richard, of Charde, Soms, vintner 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);