names

143 rows where place_id = 597441

✎ 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
3628589 1903815 1903815 defendant Hog Richard laborer 597441 597441 Hog, Richard, of Leeke, laborer 0
3684092 1921160 1921160 defendant Balle John yeoman 597441 597441 Balle, John, of Leeke, yeoman 1
3684753 1921368 1921368 defendant Brassyngton Richard yeoman 597441 597441 Brassyngton, Richard, of Leeke, yeoman 1
3708088 1928830 1928830 defendant Peek Thomas yeoman 597441 597441 Peek, Thomas, of Leeke, yeoman 2
3861499 1977308 1977308 defendant Sleford Hugh yeoman 597441 597441 Sleford, Hugh, of Leeke, yeoman 1
3861500 1977308 1977308 defendant Smyth Thomas yeoman 597441 597441 Smyth, Thomas, of Leeke, yeoman 2
3875577 1982071 1982071 defendant Hudson William, senior fisher 597441 597441 Hudson, William, senior, of Leeke, fisher 0
3878447 1983037 1983037 defendant Fendyke John chaplain 597441 597441 Fendyke, John, of Leeke, chaplain 1
3882328 1984348 1984348 defendant Wragg William fisher 597441 597441 (Wragg, William, of Leeke, fisher 1
3882329 1984348 1984348 defendant Wragg Elizabeth widow 597441 597441 Wragg, Elizabeth, of Leeke, widow 2
3882472 1984400 1984400 defendant Gryscroft William carpenter 597441 597441 Gryscroft, William, of Leeke, carpenter 0
3882474 1984401 1984401 defendant Fynne William fisher 597441 597441 Fynne, William, of Leeke, fisher 0
3882476 1984402 1984402 defendant Roper William husbandman 597441 597441 Roper, William, of Leeke, husbandman 0
3888312 1986355 1986355 defendant Fissher Thomas carpenter 597441 597441 Fissher, Thomas, of Leeke, carpenter 0
3888313 1986355 1986355 defendant Maltson John fisher 597441 597441 Maltson, John, of Leeke, fisher 1
3927052 1999386 1999386 defendant Wastler Thomas   597441 597441 Wastler, Thomas, of Leeke 0
3932521 2001167 2001167 defendant Frankysshe John husbandman 597441 597441 Frankysshe, John, of Leeke, husbandman 0
3932522 2001167 2001167 defendant Wastler Thomas husbandman 597441 597441 Wastler, Thomas, of Leeke, husbandman 1
3943129 2004715 2004715 defendant Yate Henry laborer 597441 597441 Yate, Henry, of Leeke, laborer 2
3944302 2005105 2005105 defendant Crowder John tanner 597441 597441 Crowder, John, of Leeke, tanner 0
3944303 2005105 2005105 defendant Armytt Francis husbandman 597441 597441 Armytt, Francis, of Leeke, husbandman 1
3947226 2006096 2006096 defendant Allenson Richard husbandman 597441 597441 Allenson, Richard, of Leeke, husbandman 0
3948990 2006712 2006712 defendant Spycer William husbandman 597441 597441 Spycer, William, of Leeke, husbandman 3
3951741 2007667 2007667 defendant Malkyn John yeoman 597441 597441 Malkyn, John, of Leeke, yeoman 0
3968945 2013758 2013758 defendant Pattrycke William butcher 597441 597441 Pattrycke, William, of Leeke, butcher 5
3972468 2014948 2014948 defendant Marom Richard butcher 597441 597441 Marom, Richard, of Leeke, butcher 0
3981829 2018259 2018259 defendant Asshenhurst Ralph yeoman 597441 597441 Asshenhurst, Ralph, of Leeke, yeoman 0
4029958 2035359 2035359 defendant Dicconson John yeoman 597441 597441 Dicconson, John, of Leeke, yeoman 1
4029961 2035360 2035360 defendant Dicconson John yeoman 597441 597441 Dicconson, John, of Leeke, yeoman 1
4035162 2037255 2037255 defendant Sonnevolt or Sonnevell Jasper Wyllyamsone Dutchman 597441 597441 Sonnevolt or Sonnevell, Jasper Wyllyamsone, of Leeke, yeoman, Dutchman 1
4035163 2037255 2037255 defendant Barnestone Reginald Dutcheman 597441 597441 Barnestone, Reginald, of Leeke, yeoman, Dutcheman 2
4035166 2037256 2037256 defendant Sonnevelt Jasper Wyllyamsone yeoman 597441 597441 Sonnevelt, Jasper Wyllyamsone, of Leeke, yeoman 1
4035167 2037256 2037256 defendant Barnesone Reginald Dutchman 597441 597441 Barnesone, Reginald, of Leeke, yeoman, Dutchman 2
4059817 2045905 2045905 defendant Clulowe Robert husbandman 597441 597441 Clulowe, Robert, of Leeke, husbandman 0
4059818 2045905 2045905 defendant Cowall John husbandman 597441 597441 Cowall, John, of Leeke, husbandman 1
4059819 2045905 2045905 defendant Harryson John husbandman 597441 597441 Harryson, John, of Leeke, husbandman 2
4064119 2047445 2047445 defendant Brunt John, junior husbandman 597441 597441 Brunt, John, junior, of Leeke, husbandman 0
4064120 2047445 2047445 defendant Fynney William husbandman 597441 597441 Fynney, William, of Leeke, husbandman 1
4064122 2047445 2047445 defendant Meatt Lawrence husbandman 597441 597441 Meatt, Lawrence, of Leeke, husbandman 3
4066577 2048340 2048340 defendant Clulowe Robert husbandman 597441 597441 Clulowe, Robert, of Leeke, husbandman 0
4066579 2048341 2048341 defendant Clulowe Robert husbandman 597441 597441 Clulowe, Robert, of Leeke, husbandman 0
4075424 2051513 2051513 defendant Clyff Henry husbandman 597441 597441 Clyff, Henry, of Leeke, husbandman 0
4075426 2051514 2051514 defendant Plante Thomas yeoman 597441 597441 Plante, Thomas, of Leeke, yeoman 0
4075427 2051514 2051514 defendant Janny Richard husbandman 597441 597441 Janny, Richard, of Leeke, husbandman 1
4075428 2051514 2051514 defendant Tatton William husbandman 597441 597441 Tatton, William, of Leeke, husbandman 2
4075429 2051514 2051514 defendant Edge Peter husbandman 597441 597441 Edge, Peter, of Leeke, husbandman 3
4080650 2053394 2053394 defendant Fynney William husbandman 597441 597441 Fynney, William, of Leeke, husbandman 0
4080651 2053394 2053394 defendant Berche Thomas husbandman 597441 597441 Berche, Thomas, of Leeke, husbandman 1
4080652 2053394 2053394 defendant Fynney Robert husbandman 597441 597441 Fynney, Robert, of Leeke, husbandman 2
4080654 2053394 2053394 defendant Bullocke Thomas husbandman 597441 597441 Bullocke, Thomas, of Leeke, husbandman 4
4080655 2053394 2053394 defendant Cowall John husbandman 597441 597441 Cowall, John, of Leeke, husbandman 5
4099938 2060304 2060304 defendant Bradley Peter husbandman 597441 597441 Bradley, Peter, of Leeke, husbandman 0
4099939 2060304 2060304 defendant Cowapp Richard weaver 597441 597441 Cowapp, Richard, of Leeke, weaver 1
4099940 2060304 2060304 defendant Watson Richard husbandman 597441 597441 Watson, Richard, of leeke, husbandman 2
4108943 2063454 2063454 defendant Foxe John tanner 597441 597441 Foxe, John, of Leeke, or of Stone, tanner 0
4111895 2064503 2064503 defendant Clulowe James husbandman 597441 597441 Clulowe, James, of Leeke, husbandman 2
4116185 2066081 2066081 defendant Foxe William husbandman 597441 597441 Foxe, William, of Leeke, husbandman 0
4116186 2066081 2066081 defendant Bullocke Thomas husbandman 597441 597441 Bullocke, Thomas, of Leeke, husbandman 1
4116187 2066081 2066081 defendant Cowapp Richard husbandman 597441 597441 Cowapp, Richard, of Leeke, husbandman 2
4116188 2066081 2066081 defendant Cowapp John husbandman 597441 597441 Cowapp, John, of Leeke, husbandman 3
4116503 2066191 2066191 defendant Heathe Bennet widow 597441 597441 Heathe, Bennet, of Leeke, widow 1
4116505 2066192 2066192 defendant Heath Robert (legal representative) 597441 597441 Heath, Robert, of Leeke, carpenter, administratrix of 0
4116508 2066193 2066193 defendant Shippulbothume Lawrence husbandman 597441 597441 Shippulbothume, Lawrence, of Leeke, husbandman 0
4116510 2066193 2066193 defendant Hardinge John husbandman 597441 597441 Hardinge, John, of Leeke, husbandman 2
4116511 2066193 2066193 defendant Jauncy Richard husbandman 597441 597441 Jauncy, Richard, of Leeke, husbandman 3
4120671 2067672 2067672 defendant Cade Peter husbandman 597441 597441 Cade, Peter, of Leeke, husbandman 0
4127590 2070160 2070160 defendant Hughe William tailor 597441 597441 Hughe, William, of Leeke, tailor 0
4136005 2073213 2073213 defendant Sutton Vincent yeoman 597441 597441 Sutton, Vincent, of Leeke, yeoman 1
4155288 2079943 2079943 defendant Gibson Thomas yeoman 597441 597441 Gibson, Thomas, of Leeke, yeoman 0
4155289 2079943 2079943 defendant Turnocke William yeoman 597441 597441 Turnocke, William, of Leeke, yeoman 1
4155291 2079944 2079944 defendant Bradshawe Henry yeoman or weaver 597441 597441 Bradshawe, Henry, of Leeke, or of the Pettels, yeoman or weaver 0
4156846 2080474 2080474 defendant Warklowe Lawrence husbandman 597441 597441 Warklowe, Lawrence, of Leeke, husbandman 0
4156847 2080474 2080474 defendant Moseley Robert husbandman 597441 597441 Moseley, Robert, of Leeke, husbandman 1
4162555 2082464 2082464 defendant Holme George husbandman 597441 597441 Holme, George, of Leeke, husbandman 0
4162556 2082464 2082464 defendant Gybbons Oliver husbandman 597441 597441 Gybbons, Oliver, of Leeke, husbandman 1
4162557 2082464 2082464 defendant Fynney William yeoman 597441 597441 Fynney, William, of Leeke, yeoman 2
4162558 2082464 2082464 defendant Wolley Thomas blacksmith 597441 597441 Wolley, Thomas, of Leeke, blacksmith 3
4167631 2084176 2084176 defendant Stanley William butcher 597441 597441 Stanley, William, of Leeke, butcher 1
4168617 2084508 2084508 defendant Broun Richard laborer 597441 597441 Broun, Richard, of Leeke, laborer 1
4168620 2084509 2084509 defendant Broun Richard laborer 597441 597441 Broun, Richard, of Leeke, laborer 1
4178323 2087889 2087889 defendant Sutton Vincent husbandman 597441 597441 Sutton, Vincent, of Leeke, husbandman 0
4178324 2087889 2087889 defendant Holme John weaver 597441 597441 Holme, John, of Leeke, weaver 1
4183716 2089792 2089792 defendant Leeke Thomas yeoman 597441 597441 Leeke, Thomas, of Leeke, yeoman 1
4184324 2090019 2090019 defendant Mountgumbery Nicholas gent 597441 597441 Mountgumbery, Nicholas, of Leeke, gent 0
4184326 2090019 2090019 defendant Bullocke Thomas butcher 597441 597441 Bullocke, Thomas, of Leeke, butcher 2
4185437 2090418 2090418 defendant Stanley William yeoman 597441 597441 Stanley, William, of Leeke, yeoman 0
4185438 2090418 2090418 defendant Turner alias Statham John yeoman 597441 597441 Turner alias Statham, John, of Leeke, yeoman 1
4212801 2100013 2100013 defendant Daye Thomas yeoman 597441 597441 Daye, Thomas, of Leeke, yeoman 2
4212802 2100013 2100013 defendant Braddocke Richard yeoman 597441 597441 Braddocke, Richard, of Leeke, yeoman 3
4212805 2100014 2100014 defendant Clyffe Henry yeoman 597441 597441 Clyffe, Henry, of Leeke, yeoman 1
4212806 2100014 2100014 defendant Hardinge John yeoman 597441 597441 Hardinge, John, of Leeke, yeoman 2
4214444 2100560 2100560 defendant Fermhalghe Roger husbandman 597441 597441 Fermhalghe, Roger, of Leeke, husbandman 0
4216849 2101392 2101392 defendant Porter Lawrence yeoman 597441 597441 Porter, Lawrence, of Leeke, yeoman 0
4216850 2101392 2101392 defendant Porter John yeoman 597441 597441 Porter, John, of Leeke, yeoman 1
4217892 2101747 2101747 defendant Sillitoe Humphrey husbandman 597441 597441 Sillitoe, Humphrey, of Leeke, husbandman 2
4219296 2102245 2102245 defendant Fernihoughe Thomas yeoman 597441 597441 Fernihoughe, Thomas, of Leeke, yeoman 0
4219297 2102245 2102245 defendant Fernyhoughe William yeoman 597441 597441 Fernyhoughe, William, of Leeke, yeoman 1
4221893 2103154 2103154 defendant Porter Lawrence yeoman 597441 597441 Porter, Lawrence, of Leeke, or of Dunwood, yeoman 0
4223426 2103684 2103684 defendant Overton Richard husbandman 597441 597441 Overton, Richard, of Leeke, husbandman 1
4232613 2106911 2106911 defendant Fernyhaughe Roger yeoman 597441 597441 Fernyhaughe, Roger, of Leeke, 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);