names

82 rows where place_id = 596054

✎ 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
3622922 1874699 1874699 defendant Sterre John husbandman 596054 596054 Sterre, John, of Chedder, husbandman 0
3622929 1874700 1874700 defendant Sterre John husbandman 596054 596054 Sterre, John, of Chedder, husbandman 1
3623759 1874965 1874965 defendant Lovell John husbandman 596054 596054 Lovell, John, of Chedder, husbandman 0
3677646 1919051 1919051 defendant Founteyn Walter chaplain 596054 596054 Founteyn, Walter, of Chedder, chaplain 0
3688038 1922421 1922421 defendant Harper Thomas husbandman 596054 596054 Harper, Thomas, of Chedder, husbandman 0
3704668 1927747 1927747 defendant Fenell John husbandman 596054 596054 Fenell, John, of Chedder, husbandman 0
3709974 1929430 1929430 defendant Croker Thomas, junior husbandman 596054 596054 Croker, Thomas, junior, of Chedder, husbandman 3
3755243 1943595 1943595 defendant Harper Thomas husbandman 596054 596054 Harper, Thomas, of Chedder, husbandman 0
3755245 1943596 1943596 defendant Harper Thomas husbandman 596054 596054 Harper, Thomas, of Chedder, husbandman 0
3755246 1943596 1943596 defendant Cole Walter husbandman 596054 596054 Cole, Walter, of Chedder, husbandman 1
3755247 1943596 1943596 defendant Cole William husbandman 596054 596054 Cole, William, of Chedder, husbandman 2
3775982 1950230 1950230 defendant Jamys Thomas miner 596054 596054 Jamys, Thomas, of Chedder, miner 11
3776029 1950248 1950248 defendant Storre Henry husbandman 596054 596054 Storre, Henry, of Chedder, husbandman 0
3793759 1955912 1955912 defendant Croker John husbandman 596054 596054 Croker, John, of Chedder, husbandman 3
3829412 1967087 1967087 defendant Harper Thomas husbandman 596054 596054 Harper, Thomas, of Chedder, husbandman 0
3856223 1975566 1975566 defendant Harper Thomas husbandman 596054 596054 Harper, Thomas, of Chedder, husbandman 3
3856272 1975581 1975581 defendant Harper Thomas husbandman 596054 596054 Harper, Thomas, of Chedder, husbandman 0
3856273 1975581 1975581 defendant Cole Walter husbandman 596054 596054 Cole, Walter, of Chedder, husbandman 1
3856274 1975581 1975581 defendant Cole William husbandman 596054 596054 Cole, William, of Chedder, husbandman 2
3857930 1976122 1976122 defendant Beke alias Hasell John husbandman 596054 596054 Beke alias Hasell, John, of Chedder, husbandman 1
3864151 1978198 1978198 plaintiff Kyrton Richard gent 596054 596054 Kyrton, Richard, of Chedder, gent 0
3875828 1982170 1982170 defendant Rogers Thomas   596054 596054 Rogers, Thomas, of Chedder, "ledemoyner" 0
3883965 1984907 1984907 defendant Harper Thomas husbandman 596054 596054 Harper, Thomas, of Chedder, husbandman 0
3883966 1984907 1984907 defendant Cole Walter husbandman 596054 596054 Cole, Walter, of Chedder, husbandman 1
3883967 1984907 1984907 defendant Cole William husbandman 596054 596054 Cole, William, of Chedder, husbandman 2
3903219 1991301 1991301 plaintiff Fuller William yeoman 596054 596054 Fuller, William, of Chedder, yeoman 0
3911060 1994027 1994027 defendant Cole John husbandman 596054 596054 Cole, John, of Chedder, husbandman 0
3911061 1994027 1994027 defendant Ryve Thomas husbandman 596054 596054 Ryve, Thomas, of Chedder, husbandman 1
3937874 2002999 2002999 defendant Huntley William gent 596054 596054 Huntley, William, of Chedder, gent 0
4059213 2045693 2045693 defendant Huntley William gent 596054 596054 Huntley, William, of Chedder, gent 0
4092748 2057716 2057716 defendant Palmer Simon husbandman 596054 596054 Palmer, Simon, of Chedder, husbandman 1
4092750 2057716 2057716 defendant Rogers Christopher husbandman 596054 596054 Rogers, Christopher, of Chedder, husbandman 3
4109237 2063563 2063563 defendant Style Thomas husbandman 596054 596054 Style, Thomas, of Chedder, husbandman 0
4125650 2069458 2069458 defendant Hyppesley John husbandman 596054 596054 Hyppesley, John, of Chedder, husbandman 0
4125651 2069458 2069458 defendant Sadge or Sage Richard husbandman 596054 596054 Sadge or Sage, Richard, of Chedder, husbandman 1
4144950 2076393 2076393 defendant Jefferys William husbandman 596054 596054 Jefferys, William, of Chedder, husbandman 3
4150411 2078273 2078273 defendant Sage Richard husbandman 596054 596054 Sage, Richard, of Chedder, husbandman 1
4167340 2084076 2084076 defendant Chycke John husbandman 596054 596054 Chycke, John, of Chedder, husbandman 3
4255834 2114925 2114925 defendant Sadge Richard husbandman 596054 596054 Sadge, Richard, of Chedder, husbandman 3
4261164 2116703 2116703 defendant Richard William   596054 596054 Richard, William, of Chedder, husbandman, sons of Robert Richardes, of Chedder 1
4261168 2116704 2116704 defendant Richard William   596054 596054 Richard, William, of Chedder, husbandman, son of Robert Rychards, of Chedder 1
4290269 2126571 2126571 defendant Larder James yeoman 596054 596054 Larder, James, of Chedder, yeoman 0
4301236 2130553 2130553 defendant Spencer John   596054 596054 Spencer, John, of Chedder husbandman 1
4301237 2130553 2130553 defendant Danyell George husbandman 596054 596054 Danyell, George, of Chedder, husbandman 2
4301238 2130553 2130553 defendant Hopper Thomas husbandman 596054 596054 Hopper, Thomas, of Chedder, husbandman 3
4305876 2132194 2132194 defendant Wyllyams John husbandman 596054 596054 Wyllyams, John, of Chedder, husbandman 0
4308752 2133211 2133211 defendant Lane William husbandman 596054 596054 Lane, William, of Chedder, husbandman 0
4308933 2133276 2133276 defendant Kyrton Henry gent 596054 596054 Kyrton, Henry, of Chedder, gent 1
4369224 2154056 2154056 defendant Rogers Christopher weaver 596054 596054 Rogers, Christopher, of Chedder, weaver 0
4370612 2154541 2154541 defendant Lane William husbandman 596054 596054 Lane, William, of Chedder, husbandman 0
4474971 2192840 2192840 defendant Brigge Edward   596054 596054 Brigge, Edward, of Chedder 0
4476172 2193210 2193210 defendant Boteler John   596054 596054 Boteler, John, of Chedder 2
4598222 2230682 2230682 defendant Carpentere John   596054 596054 Carpentere, John, of Chedder 4
4657257 2248157 2248157 defendant Morys Nicholas merchant 596054 596054 Morys, Nicholas, of Chedder, merchant 0
4672292 2256982 2256982 defendant Beveham or Beneham Thomas   596054 596054 Beveham or Beneham, Thomas, of Chedder, vicar, formerly parson of Lambhythe, surr 0
4709236 2268256 2268256 defendant Wethir John fuller 596054 596054 Wethir, John, of Chedder, fuller 1
4709237 2268256 2268256 defendant Moton John husbandman 596054 596054 Moton, John, of Chedder, husbandman 2
4721672 2272112 2272112 defendant Kellane Lewis clerk 596054 596054 Kellane, Lewis, of Chedder, clerk 1
4817930 2301690 2301690 defendant Fynell Thomas laborer 596054 596054 Fynell, Thomas, of Chedder, laborer 4
4824169 2303634 2303634 defendant Maynston William husbandman 596054 596054 Maynston, William, of Chedder, husbandman 0
4824258 2303655 2303655 defendant Bocher Thomas butcher 596054 596054 Bocher, Thomas, of Chedder, butcher 0
4824259 2303655 2303655 defendant Ray John laborer 596054 596054 Ray, John, of Chedder, laborer 1
4824261 2303655 2303655 defendant Broune John   596054 596054 Broune, John, of Chedder, groom 3
4874694 2319029 2319029 defendant Neuman Thomas butcher 596054 596054 Neuman, Thomas, of Chedder, butcher 0
4904695 2328077 2328077 defendant Heyward John husbandman 596054 596054 Heyward, John, of Chedder, husbandman 0
4929265 2335570 2335570 defendant Fenell Richard laborer 596054 596054 Fenell, Richard, of Chedder, laborer 4
4998316 2356367 2356367 defendant Lange John husbandman 596054 596054 Lange, John, of Chedder, husbandman 0
5022082 2363352 2363352 defendant Wodeward Thomas husbandman 596054 596054 Wodeward, Thomas, of Chedder, husbandman 1
5031628 2366113 2366113 defendant Evell or Gnell John husbandman 596054 596054 Evell or Gnell, John, of Chedder, husbandman 2
5070604 2377703 2377703 defendant Haukyn Henry husbandman 596054 596054 Haukyn, Henry, of Chedder, husbandman 2
5086828 2382544 2382544 defendant Lange Thomas husbandman 596054 596054 Lange, Thomas, of Chedder, husbandman 1
5240239 2427352 2427352 defendant Cole John husbandman 596054 596054 Cole, John, of Chedder, husbandman 2
5242259 2427938 2427938 defendant Peke Robert goldsmith 596054 596054 Peke, Robert, of Chedder, goldsmith 0
5274800 2437708 2437708 defendant Fouke John fuller 596054 596054 Fouke, John, of Chedder, fuller 0
5308130 2447458 2447458 defendant More Thomas husbandman 596054 596054 More, Thomas, of Chedder, husbandman 0
5308132 2447459 2447459 defendant More Thomas husbandman 596054 596054 More, Thomas, of Chedder, husbandman 0
5308134 2447460 2447460 defendant More Thomas husbandman 596054 596054 More, Thomas, of Chedder, husbandman 0
5341167 2457429 2457429 defendant Roo Henry gent 596054 596054 Roo, Henry, of Chedder, gent 0
5341168 2457429 2457429 defendant Roo William gent 596054 596054 Roo, William, of Chedder, gent 1
5530570 2514078 2514078 defendant Cokkys German husbandman 596054 596054 Cokkys, German, of Chedder, husbandman 0
5545481 2518667 2518667 defendant Cheyny John   596054 596054 Cheyny, John, of Chedder, freemason 0
5577832 2528136 2528136 defendant Plumley Nicholas yeoman 596054 596054 Plumley, Nicholas, of Chedder, yeoman 1

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