names

334 rows where place_id = 586656

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589314 1864300 1864300 defendant Fabyan Joan widow 586656 586656 Fabyan, Joan, of Coggeshale, widow 1
3589987 1864509 1864509 defendant Dorday Thomas yeoman 586656 586656 Dorday, Thomas, of Coggeshale, yeoman 0
3617868 1873212 1873212 plaintiff Gerard John scrivener 586656 586656 Gerard, John, of Coggeshale, scrivener 0
3617869 1873212 1873212 defendant Clerke Thomas (legal representative) 586656 586656 Clerke, Thomas, of Coggeshale, fuller, executors of 0
3617871 1873213 1873213 plaintiff Gerard John scrivener 586656 586656 Gerard, John, of Coggeshale, scrivener 0
3617872 1873213 1873213 defendant Clerke Thomas (legal representative) 586656 586656 Clerke, Thomas, of Coggeshale, fuller, executors of 0
3669128 1916281 1916281 defendant Cokerell Thomas husbandman 586656 586656 Cokerell, Thomas, of Coggeshale, husbandman 0
3747076 1941002 1941002 defendant Fynche Ralph shoemaker 586656 586656 Fynche, Ralph, of Coggeshale, shoemaker 0
3750515 1942075 1942075 defendant Jakson Thomas glover 586656 586656 Jakson, Thomas, of Coggeshale, glover 0
3750516 1942075 1942075 defendant Pannymer Robert fuller 586656 586656 Pannymer, Robert, of Coggeshale, fuller 1
3751268 1942321 1942321 plaintiff Myles Robert   586656 586656 Myles, Robert, of Coggeshale 0
3830859 1967532 1967532 defendant Sperke Thomas shoemaker 586656 586656 Sperke, Thomas, of Coggeshale, shoemaker 0
3906827 1992572 1992572 defendant Brykehede Anthony cutler 586656 586656 Brykehede, Anthony, of Coggeshale, cutler 1
3914855 1995316 1995316 defendant Okeley John husbandman 586656 586656 Okeley, John, of Coggeshale, husbandman 0
3916876 1996009 1996009 defendant Colman William clothier 586656 586656 Colman, William, of Coggeshale, clothier 0
4441407 2182253 2182253 defendant Skynnere Walter   586656 586656 Skynnere, Walter, of Coggeshale 0
4441409 2182254 2182254 defendant Skynnere Walter   586656 586656 Skynnere, Walter, of Coggeshale 0
4445842 2183643 2183643 plaintiff Sewale John   586656 586656 Sewale, John, of Coggeshale 1
4454791 2186509 2186509 defendant Dyn Aunice   586656 586656 Dyn, Aunice, of Coggeshale 0
4455801 2186829 2186829 plaintiff Mot John   586656 586656 Mot, John, of Coggeshale 0
4455803 2186829 2186829 defendant atte Hell William   586656 586656 atte Hell, William, of Coggeshale 0
4459493 2188022 2188022 plaintiff Sadelere John   586656 586656 Sadelere, John, of Coggeshale 0
4459495 2188023 2188023 plaintiff Sadelere John   586656 586656 Sadelere, John, of Coggeshale 0
4459497 2188024 2188024 plaintiff Sadelere John   586656 586656 Sadelere, John, of Coggeshale 0
4459499 2188024 2188024 defendant Smyth Walter   586656 586656 Smyth, Walter, of Coggeshale 0
4460153 2188234 2188234 plaintiff Sewale John   586656 586656 Sewale, John, of Coggeshale 0
4460158 2188235 2188235 plaintiff Sewale John   586656 586656 Sewale, John, of Coggeshale 0
4460161 2188236 2188236 plaintiff Sewale John   586656 586656 Sewale, John, of Coggeshale 0
4460166 2188237 2188237 plaintiff Sewale John   586656 586656 Sewale, John, of Coggeshale 0
4460170 2188238 2188238 plaintiff Sewale John   586656 586656 Sewale, John, of Coggeshale 0
4462599 2188997 2188997 defendant Strogel Ralph   586656 586656 Strogel, Ralph, of Coggeshale 0
4463665 2189333 2189333 defendant Skynnere Walter   586656 586656 Skynnere, Walter, of Coggeshale 7
4463677 2189334 2189334 defendant skynnenre Walter   586656 586656 skynnenre, Walter, of Coggeshale 7
4463764 2189348 2189348 defendant Skynnere Walter   586656 586656 Skynnere, Walter, of Coggeshale 7
4466443 2190174 2190174 plaintiff Alaperle William   586656 586656 Alaperle, William, of Coggeshale 0
4466445 2190175 2190175 plaintiff Alapert William   586656 586656 Alapert, William, of Coggeshale 0
4466453 2190177 2190177 defendant Sewale Robert   586656 586656 Sewale, Robert, of Coggeshale 0
4466454 2190177 2190177 defendant Messager Roger   586656 586656 Messager, Roger, of Coggeshale 1
4474802 2192790 2192790 defendant Dyere William   586656 586656 Dyere, William, of Coggeshale 1
4477277 2193560 2193560 plaintiff Graunger or Craunger Robert   586656 586656 Graunger or Craunger, Robert, of Coggeshale 0
4481702 2194978 2194978 plaintiff Makell William   586656 586656 Makell, William, of Coggeshale 0
4481705 2194979 2194979 plaintiff Makell William   586656 586656 Makell, William, of Coggeshale 0
4485182 2196066 2196066 defendant (illegible) John   586656 586656 ---, John, of Coggeshale 5
4488488 2197120 2197120 defendant Stoure Thomas goldsmith 586656 586656 Stoure, Thomas, of Coggeshale, goldsmith 0
4491172 2197924 2197924 defendant Warderober Simon   586656 586656 Warderober, Simon, of Coggeshale 0
4492703 2198419 2198419 plaintiff Alapert John   586656 586656 Alapert, John, of Coggeshale 0
4492750 2198433 2198433 plaintiff Ald-ert John   586656 586656 Ald-ert, John, of Coggeshale 0
4501439 2201053 2201053 defendant Scrogull Richard   586656 586656 Scrogull, Richard, of Coggeshale 2
4504652 2201998 2201998 defendant Sewale Robert   586656 586656 Sewale, Robert, of Coggeshale 0
4507039 2202672 2202672 defendant Bret John dyer 586656 586656 Bret, John, of Coggeshale, dyer 1
4534823 2211174 2211174 defendant Turnour William   586656 586656 Turnour, William, of Coggeshale 0
4549747 2215858 2215858 defendant Aleyn William   586656 586656 Aleyn, William, of Coggeshale 2
4554763 2217418 2217418 defendant Neuman Simon   586656 586656 Neuman, Simon, of Coggeshale 0
4585009 2226739 2226739 defendant Swetyng John   586656 586656 Swetyng, John, of Coggeshale 0
4585598 2226919 2226919 defendant Fuller Robert   586656 586656 Fuller, Robert, of Coggeshale 0
4588183 2227699 2227699 defendant Tyler Thomas   586656 586656 Tyler, Thomas, of Coggeshale 2
4588185 2227699 2227699 defendant Hegyn John   586656 586656 Hegyn, John, of Coggeshale 4
4588187 2227699 2227699 defendant Coweman John   586656 586656 Coweman, John, of Coggeshale 6
4598558 2230785 2230785 defendant Tilere Thomas   586656 586656 Tilere, Thomas, of Coggeshale 4
4604245 2232499 2232499 plaintiff Nyweman Simon   586656 586656 Nyweman, Simon, of Coggeshale 1
4606494 2233141 2233141 defendant Coweman John   586656 586656 Coweman, John, of Coggeshale 2
4607568 2233476 2233476 defendant Bakere John   586656 586656 Bakere, John, of Coggeshale 0
4607572 2233476 2233476 defendant Peddere Joan   586656 586656 Peddere, Joan, of Coggeshale, formerly wife of John 4
4611580 2234684 2234684 defendant Crosseman William   586656 586656 Crosseman, William, of Coggeshale 0
4612818 2235072 2235072 defendant Sayer Thomas dyer 586656 586656 Sayer, Thomas, of Coggeshale, dyer 1
4612822 2235073 2235073 defendant Sayer Thomas dyer 586656 586656 Sayer, Thomas, of Coggeshale, dyer 1
4613008 2235127 2235127 defendant Hygyn John   586656 586656 Hygyn, John, of Coggeshale 0
4618910 2236908 2236908 defendant Taylour Alexander   586656 586656 Taylour, Alexander, of Coggeshale 1
4618921 2236909 2236909 defendant Weylete John   586656 586656 Weylete, John, of Coggeshale 4
4620516 2237396 2237396 defendant Cary John   586656 586656 Cary, John, of Coggeshale 0
4630481 2240447 2240447 defendant Bernesdale Robert   586656 586656 Bernesdale, Robert, of Coggeshale 0
4630945 2240569 2240569 plaintiff Swetyng John, sen   586656 586656 Swetyng, John, sen, of Coggeshale 0
4630947 2240569 2240569 defendant Syred John   586656 586656 Syred, John, of Coggeshale 1
4639743 2243133 2243133 defendant Sayer Thomas   586656 586656 Sayer, Thomas, of Coggeshale 2
4639789 2243141 2243141 defendant Sheldrake John fuller 586656 586656 Sheldrake, John, of Coggeshale, fuller 2
4642614 2243957 2243957 defendant Fullere William   586656 586656 Fullere, William, of Coggeshale 0
4643287 2244142 2244142 defendant Hygyn John   586656 586656 Hygyn, John, of Coggeshale 3
4646339 2244996 2244996 defendant Baker John   586656 586656 Baker, John, of Coggeshale 1
4647708 2245388 2245388 plaintiff Smyth John fuller 586656 586656 Smyth, John, of Coggeshale, fuller 0
4647710 2245388 2245388 defendant Cook John butcher 586656 586656 Cook, John, of Coggeshale, butcher 1
4660645 2249152 2249152 plaintiff Derby Joan   586656 586656 Derby, Joan, of Coggeshale 0
4660646 2249152 2249152 defendant Paycok Thomas butcher 586656 586656 Paycok, Thomas, of Coggeshale, butcher 0
4660939 2249247 2249247 defendant Bakere John baker 586656 586656 Bakere, John, of Coggeshale, baker 0
4660940 2249247 2249247 defendant Cook John butcher 586656 586656 Cook, John, of Coggeshale, butcher 1
4668701 2255926 2255926 plaintiff Benecroft John   586656 586656 Benecroft, John, of Coggeshale 0
4668703 2255926 2255926 defendant Cook John butcher 586656 586656 Cook, John, of Coggeshale, butcher 0
4673278 2257283 2257283 defendant Kebyll John tailor 586656 586656 Kebyll, John, of Coggeshale, tailor 2
4673296 2257287 2257287 defendant Kebyll John tailor 586656 586656 Kebyll, John, of Coggeshale, tailor 2
4681068 2259705 2259705 defendant Sayer Thmas   586656 586656 Sayer, Thmas, of Coggeshale 2
4683892 2260571 2260571 defendant Twene Walter dyer 586656 586656 Twene, Walter, of Coggeshale, dyer 0
4690545 2262596 2262596 defendant Hegyn John yeoman 586656 586656 Hegyn, John, of Coggeshale, yeoman 0
4690546 2262596 2262596 defendant Coweman John yeoman 586656 586656 Coweman, John, of Coggeshale, yeoman 1
4690547 2262596 2262596 defendant Cary Joan widow 586656 586656 Cary, Joan, of Coggeshale, widow 2
4694349 2263733 2263733 defendant Clerk Roger butcher 586656 586656 Clerk, Roger, of Coggeshale, butcher 0
4701072 2265742 2265742 defendant Blake Johnm brewer 586656 586656 Blake, Johnm, of Coggeshale, brewer 0
4703374 2266435 2266435 defendant Clerk Roger butcher 586656 586656 Clerk, Roger, of Coggeshale, butcher 0
4705011 2266942 2266942 defendant Cary John (legal representative) 586656 586656 Cary, John, of Coggeshale, executor of 0
4712851 2269330 2269330 defendant Hegyn John yeoman 586656 586656 Hegyn, John, of Coggeshale, yeoman 1
4719026 2271298 2271298 defendant Hegyn John yeoman 586656 586656 Hegyn, John, of coggeshale, yeoman 0
4723267 2272587 2272587 defendant Hegyn John yeoman 586656 586656 Hegyn, John, of Coggeshale, yeoman 2

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