names

194 rows where place_id = 588211

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593755 1865683 1865683 defendant Thirsall John yeoman 588211 588211 Thirsall, John, of Ledes, yeoman 7
3595358 1866180 1866180 defendant Smyth John laborer 588211 588211 Smyth, John, of Ledes, laborer 1
3598302 1867098 1867098 defendant Thirsall John yeoman 588211 588211 Thirsall, John, of Ledes, yeoman 7
3615268 1872421 1872421 defendant Catelyn John glover 588211 588211 Catelyn, John, of Ledes, glover 1
3616732 1872863 1872863 defendant Cadelyn John glover 588211 588211 Cadelyn, John, of Ledes, glover 1
3621072 1874146 1874146 defendant Bank Richard yeoman 588211 588211 Bank, Richard, of Ledes, yeoman 0
3621073 1874146 1874146 defendant Rodes John walker 588211 588211 Rodes, John, of Ledes, walker 1
3624429 1875175 1875175 defendant Sheffeld Thomas fletcher 588211 588211 Sheffeld, Thomas, of Ledes, fletcher 0
3651548 1910842 1910842 defendant Benden John butcher 588211 588211 Benden, John, of Ledes, butcher 0
3680319 1919920 1919920 defendant Sergeauntson John chapman 588211 588211 Sergeauntson, John, of Ledes, chapman 4
3684022 1921135 1921135 defendant Rawdon William clothier 588211 588211 Rawdon, William, of Ledes, clothier 0
3687335 1922218 1922218 defendant Lymden Valentine clothman 588211 588211 Lymden, Valentine, of Ledes, yeoman, son of Lymden, Henry, clothman 0
3702381 1927004 1927004 defendant Myller Stephen carpenter 588211 588211 Myller, Stephen, of Ledes, or of Stapleherst, Kent, carpenter 0
3721202 1932932 1932932 defendant Coke John yeoman or fuller 588211 588211 Coke, John, of Ledes, yeoman or fuller 0
3735016 1937187 1937187 defendant Alcok John clothmaker 588211 588211 Alcok, John, of Ledes, clothmaker 1
3783529 1952603 1952603 plaintiff Lambe Robert   588211 588211 Lambe, Robert, of Ledes 0
3791398 1955145 1955145 defendant Fawxe Anthony fuller 588211 588211 Fawxe, Anthony, of Ledes, fuller 0
3813626 1962176 1962176 defendant Colett Christopher clothmaker 588211 588211 Colett, Christopher, of Ledes, clothmaker 0
3835107 1968919 1968919 defendant Paslowe George gent 588211 588211 Paslowe, George, of Ledes, gent 0
3836117 1969211 1969211 defendant Paterdale John dyer 588211 588211 Paterdale, John, of Ledes, dyer 0
3854329 1974994 1974994 defendant Kyrke Nicholas clothmaker 588211 588211 Kyrke, Nicholas, of Ledes, clothmaker 0
3854330 1974994 1974994 defendant Ambeler Henry clothmaker 588211 588211 Ambeler, Henry, of Ledes, clothmaker 1
3854331 1974994 1974994 defendant Watterton Thomas clothmaker 588211 588211 Watterton, Thomas, of Ledes, clothmaker 2
3949804 2007008 2007008 plaintiff Feild Robert cordwainer 588211 588211 Feild, Robert, of Ledes, cordwainer 0
3956347 2009285 2009285 defendant Cowper George clothier 588211 588211 Cowper, George, of Ledes, clothier 0
3956348 2009285 2009285 defendant Cowper Richard clothier 588211 588211 Cowper, Richard, of Ledes, clothier 1
3956349 2009285 2009285 defendant Robynson George clothier 588211 588211 Robynson, George, of Ledes, clothier 2
3956350 2009285 2009285 defendant Cawlbecke Edward clothier 588211 588211 Cawlbecke, Edward, of Ledes, clothier 3
3956362 2009288 2009288 defendant Wyse William baker 588211 588211 Wyse, William, of Ledes, baker 0
3956363 2009288 2009288 defendant Yles Edward clothier 588211 588211 Yles, Edward, of Ledes, clothier 1
3956364 2009288 2009288 defendant Martyn Henry clothier 588211 588211 Martyn, Henry, of Ledes, clothier 2
3956365 2009288 2009288 defendant Fentyman Elizabeth widow 588211 588211 Fentyman, Elizabeth, of Ledes, widow 3
3968522 2013623 2013623 defendant Symson Richard   588211 588211 Symson, Richard, of Ledes, linen draper 1
4000692 2025019 2025019 defendant Judson Robert husbandman 588211 588211 Judson, Robert, of Ledes, husbandman 0
4000693 2025019 2025019 defendant Wood Lawrence husbandman 588211 588211 Wood, Lawrence, of Ledes, husbandman 1
4000694 2025019 2025019 defendant Goodayle John husbandman 588211 588211 Goodayle, John, of Ledes, husbandman 2
4000695 2025019 2025019 defendant Hewytt John husbandman 588211 588211 Hewytt, John, of Ledes, husbandman 3
4000701 2025020 2025020 defendant Ambler Henry, senior yeoman 588211 588211 Ambler, Henry, senior, of Ledes, yeoman 1
4009683 2028232 2028232 defendant Fawconer Robert yeoman 588211 588211 Fawconer, Robert, of Ledes, yeoman 0
4009684 2028232 2028232 defendant Leadbeater Christopher draper 588211 588211 Leadbeater, Christopher, of Ledes, draper 1
4009685 2028232 2028232 defendant Baynes Brian yeoman 588211 588211 Baynes, Brian, of Ledes, yeoman 2
4009686 2028232 2028232 defendant Waddesworth William merchant 588211 588211 Waddesworth, William, of Ledes, merchant 3
4021567 2032440 2032440 defendant Leadbetter Robert draper 588211 588211 Leadbetter, Robert, of Ledes, draper 0
4053222 2043539 2043539 defendant Barnerd Thomas clothier 588211 588211 Barnerd, Thomas, of Ledes, clothier 0
4053223 2043539 2043539 defendant Strickland Lawrence clothier 588211 588211 Strickland, Lawrence, of Ledes, clothier 1
4053224 2043539 2043539 defendant Herle Thomas clothier 588211 588211 Herle, Thomas, of Ledes, clothier 2
4053225 2043539 2043539 defendant Herle William clothier 588211 588211 Herle, William, of Ledes, clothier 3
4053227 2043540 2043540 defendant Killingbeck John, senior clothier 588211 588211 Killingbeck, John, senior, of Ledes, clothier 0
4053228 2043540 2043540 defendant Killingbeck George clothier 588211 588211 Killingbeck, George, of Ledes, clothier 1
4053238 2043541 2043541 defendant Kyllyngbeck John, senior clothier 588211 588211 together with Kyllyngbeck, John, senior, of Ledes, clothier 3
4053239 2043541 2043541 defendant Kyllyngbecke George clothier 588211 588211 Kyllyngbecke, George, of Ledes, clothier 4
4053240 2043541 2043541 defendant Kyllyngbecke Christopher clothier 588211 588211 Kyllyngbecke, Christopher, of Ledes, clothier 5
4118841 2067022 2067022 defendant Cowper James butcher 588211 588211 Cowper, James, of Ledes, butcher 1
4138639 2074186 2074186 defendant Fyrne Christopher clothier 588211 588211 Fyrne, Christopher, of Ledes, clothier 1
4148197 2077503 2077503 defendant Throwley John   588211 588211 Throwley, John, of Ledes, pale maker 2
4173023 2086019 2086019 defendant Wethered or Wetherheade John clothier 588211 588211 Wethered or Wetherheade, John, of Ledes, clothier 0
4234507 2107613 2107613 defendant Foster Ralph yeoman 588211 588211 Foster, Ralph, of Ledes, yeoman 0
4274299 2120956 2120956 defendant Dixon Christopher husbandman 588211 588211 Dixon, Christopher, of Ledes, husbandman 0
4308954 2133285 2133285 defendant Bumbey Thomas clothier 588211 588211 Bumbey, Thomas, of Ledes, clothier 0
4308956 2133286 2133286 defendant Bumbey Thomas clothier 588211 588211 Bumbey, Thomas, of Ledes, clothier 0
4316175 2135770 2135770 defendant Tayler Edward yeoman 588211 588211 Tayler, Edward, of Ledes, yeoman 0
4316176 2135770 2135770 defendant Longe Henry yeoman 588211 588211 Longe, Henry, of Ledes, yeoman 1
4395232 2162989 2162989 defendant Wylson John clothier 588211 588211 Wylson, John, of Ledes, clothier 0
4402000 2165261 2165261 defendant Gylberd Henry tailor 588211 588211 Gylberd, Henry, of Ledes, tailor 2
4444681 2183315 2183315 plaintiff Colton William clerk & protonotary 588211 588211 Colton, William, of Ledes, clerk & protonotary 0
4444684 2183316 2183316 plaintiff Colton William   588211 588211 Colton, William, of Ledes, clerk, portionarius or joint holder of a benefice which Thomas Burley, clerk formerly had, in the church of St Probus 0
4460915 2188482 2188482 plaintiff Snell William   588211 588211 Snell, William, of Ledes 0
4500229 2200698 2200698 defendant Stanley John dyer 588211 588211 Stanley, John, of Ledes, dyer 0
4513613 2204683 2204683 plaintiff Brounyng John   588211 588211 Brounyng, John, of Ledes 0
4544007 2214036 2214036 defendant Hyde William butcher 588211 588211 Hyde, William, of Ledes, butcher 0
4595826 2229950 2229950 plaintiff Robynson William   588211 588211 Robynson, William, of Ledes 0
4595827 2229950 2229950 defendant Warter Joan   588211 588211 Warter, Joan, of Ledes 0
4595828 2229950 2229950 defendant Chapman Joan   588211 588211 Chapman, Joan, of Ledes 1
4601906 2231822 2231822 defendant Vyncent John   588211 588211 Vyncent, John, of Ledes 1
4641021 2243467 2243467 defendant Fourneux John   588211 588211 Fourneux, John, of Ledes 4
4660544 2249123 2249123 plaintiff Dene John   588211 588211 Dene, John, of Ledes 0
4660547 2249123 2249123 defendant Mawedeleyn John smith 588211 588211 Mawedeleyn, John, of Ledes, smith 2
4662365 2249706 2249706 defendant Paslewe Robert gent 588211 588211 Paslewe, Robert, of Ledes, gent 0
4676180 2258162 2258162 defendant Tymble John yeoman 588211 588211 Tymble, John, of Ledes, yeoman 1
4725092 2273145 2273145 defendant Paslowe Robert gent 588211 588211 Paslowe, Robert, of Ledes, gent 0
4729454 2274425 2274425 plaintiff Ledes William   588211 588211 Ledes, William, of Ledes 0
4730348 2274691 2274691 defendant Ledes William gent 588211 588211 Ledes, William, of Ledes, gent 0
4734492 2275954 2275954 defendant Fournes John yeoman 588211 588211 Fournes, John, of Ledes, yeoman 0
4737773 2276919 2276919 defendant atte Hale William draper 588211 588211 atte Hale, William, of Ledes, draper 0
4742136 2278191 2278191 defendant Fournes John yeoman 588211 588211 Fournes, John, of Ledes, yeoman 3
4750403 2280599 2280599 defendant Byrche Robert butcher 588211 588211 Byrche, Robert, of ledes, butcher 3
4776820 2288739 2288739 defendant de Rome Peter gent 588211 588211 de Rome, Peter, of Ledes, gent 0
4776823 2288739 2288739 defendant Stoppe or Scoppe John tailor 588211 588211 Stoppe or Scoppe, John, of Ledes, tailor 3
4780470 2289888 2289888 plaintiff Burman Hugh   588211 588211 Burman, Hugh, of Ledes 0
4784224 2291066 2291066 plaintiff Dene John (legal representative) 588211 588211 Dene, John, of Ledes, executors of 0
4784229 2291066 2291066 defendant Maudelyn John smith 588211 588211 Maudelyn, John, of Ledes, smith 2
4787194 2292061 2292061 defendant Rome John gent 588211 588211 Rome, John, of Ledes, gent 1
4793133 2293945 2293945 defendant Tymble John yeoman 588211 588211 Tymble, John, of Ledes, yeoman 0
4793143 2293949 2293949 defendant Tymble John   588211 588211 Tymble, John, of Ledes 0
4793145 2293950 2293950 defendant Tymble John yeoman 588211 588211 Tymble, John, of Ledes, yeoman 0
4793147 2293951 2293951 defendant Tymble John yeoman 588211 588211 Tymble, John, of Ledes, yeoman 0
4799755 2296110 2296110 plaintiff Tymble John   588211 588211 Tymble, John, of Ledes 0
4802625 2297008 2297008 defendant Cliderowe Henry   588211 588211 Cliderowe, Henry, of Ledes, parish clerk 0
4802977 2297117 2297117 defendant Nowenham John husbandman 588211 588211 Nowenham, John, of Ledes, husbandman 0
4809766 2299217 2299217 defendant Thomas Agnes widow & formerly wife of John Thomas 588211 588211 Thomas, Agnes, of Ledes, widow & formerly wife of John Thomas 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);