names

87 rows where place_id = 586787

✎ 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
3589617 1864394 1864394 defendant Hervy William butcher 586787 586787 Hervy, William, of Chesterfeld, Derbs, butcher 0
3597405 1866809 1866809 defendant Brodehed Richard draper 586787 586787 Brodehed, Richard, of Chesterfeld, Derbs, draper 0
3602520 1868447 1868447 defendant Harvy William dyer 586787 586787 Harvy, William, of Chesterfeld, Derbs, dyer 0
3602522 1868448 1868448 defendant Harvy William dyer 586787 586787 Harvy, William, of Chesterfeld, Derbs, dyer 0
3623540 1874890 1874890 defendant Hethcote John mercer 586787 586787 Hethcote, John, of Chesterfeld, Derbs, mercer 0
3660388 1913506 1913506 plaintiff Hethecote Richard (legal representative) 586787 586787 Hethecote, Richard, of Chesterfeld, Derbs, executrix of 0
3683241 1920878 1920878 defendant Heithcot John dyer 586787 586787 Heithcot, John, of Chesterfeld, Derbs, dyer 0
3703473 1927357 1927357 defendant Hethcote Ralph bellfounder 586787 586787 Hethcote, Ralph, of Chesterfeld, Derbs, bellfounder 0
3706858 1928432 1928432 defendant Skynner Nicholas brasier 586787 586787 Skynner, Nicholas, of Chesterfeld, Derbs, brasier 3
3708215 1928864 1928864 defendant Mason alias Johnson Robert glover 586787 586787 Mason alias Johnson, Robert, of Chesterfeld, Derbs, glover 0
3725735 1934338 1934338 defendant Rotheram William butcher 586787 586787 Rotheram, William, of Chesterfeld, Derbs, butcher 2
3732153 1936292 1936292 defendant Delaper John   586787 586787 Delaper, John, of Chesterfeld, Derbs, physician 0
3753808 1943133 1943133 defendant Belaper John   586787 586787 Belaper, John, of Chesterfeld, Derbs, physician 0
3761749 1945685 1945685 defendant Parker George gent 586787 586787 Parker, George, of Chesterfeld, Derbs, gent 0
3761751 1945686 1945686 defendant Parker George gent 586787 586787 Parker, George, of Chesterfeld, Derbs, gent 0
3779160 1951205 1951205 defendant Lache William butcher 586787 586787 Lache, William, of Chesterfeld, Derbs, butcher 0
3782122 1952161 1952161 defendant Harryson Robert dyer 586787 586787 Harryson, Robert, of Chesterfeld, Derbs, dyer 0
3785745 1953331 1953331 defendant Brodehed Robert chapman 586787 586787 Brodehed, Robert, of Chesterfeld, Derbs, chapman 1
3796253 1956693 1956693 defendant Lache William butcher 586787 586787 Lache, William, of Chesterfeld, Derbs, butcher 0
3798796 1957536 1957536 defendant Haryson Robert dyer 586787 586787 Haryson, Robert, of Chesterfeld, Derbs, dyer 0
3822745 1965015 1965015 defendant Harryson Robert dyer 586787 586787 Harryson, Robert, of Chesterfeld, Derbs, dyer 0
3859115 1976539 1976539 defendant Pyllesley Richard yeoman or potter 586787 586787 Pyllesley, Richard, of Chesterfeld, Derbs, yeoman or potter 1
3867633 1979410 1979410 defendant Hethcote Thomas yeoman 586787 586787 Hethcote, Thomas, of Chesterfeld, Derbs, yeoman 0
3872762 1981104 1981104 defendant Asshe John chapman 586787 586787 Asshe, John, of Chesterfeld, Derbs, chapman 2
3909172 1993366 1993366 defendant Asshe Richard tanner 586787 586787 Asshe, Richard, of Chesterfeld, Derbs, tanner 0
3909174 1993366 1993366 defendant Clayworth Hugh tanner 586787 586787 Clayworth, Hugh, of Chesterfeld, Derbs, tanner 2
3935499 2002181 2002181 defendant Sely Thomas chapman 586787 586787 Sely, Thomas, of Chesterfeld, Derbs, chapman 0
3950603 2007282 2007282 defendant Heathecott Mary   586787 586787 Heathecott, Mary, of Chesterfeld, Derbs, widow of Thomas Heathecott, of Chesterfeld 0
3954649 2008692 2008692 defendant Foliambe Godfrey gent 586787 586787 Foliambe, Godfrey, of Chesterfeld, Derbs, gent 1
3990708 2021431 2021431 defendant Foliambe Godfrey esq 586787 586787 Foliambe, Godfrey, of Chesterfeld, Derbs, esq, son of Godfrey Foliambe, of Skegby, Notts, esq 0
4039180 2038638 2038638 defendant Hethcote Ralph butcher 586787 586787 Hethcote, Ralph, of Chesterfeld, Derbs, yeoman, butcher 0
4138702 2074209 2074209 defendant Fletcher Robert (legal representative) 586787 586787 Fletcher, Robert, of Chesterfeld, Derbs, gent, executor of 0
4139478 2074481 2074481 defendant Cade Robert butcher 586787 586787 Cade, Robert, of Chesterfeld, Derbs, butcher 0
4150013 2078139 2078139 defendant Bretlande Reginald tanner 586787 586787 Bretlande, Reginald, of Chesterfeld, Derbs, tanner 0
4150503 2078307 2078307 defendant Bolsover Thomas merchant 586787 586787 Bolsover, Thomas, of Chesterfeld, Derbs, merchant 1
4165480 2083428 2083428 defendant Rathebond Richard gent 586787 586787 Rathebond, Richard, of Chesterfeld, Derbs, gent 1
4168244 2084381 2084381 defendant Webster William mercer 586787 586787 Webster, William, of Chesterfeld, Derbs, mercer 0
4168249 2084382 2084382 defendant Webster William mercer 586787 586787 Webster, William, of Chesterfeld, Derbs, mercer 0
4175066 2086743 2086743 defendant Heathcot Ralph butcher 586787 586787 Heathcot, Ralph, of Chesterfeld, Derbs, butcher 0
4175266 2086815 2086815 defendant Bolsover Thomas merchant 586787 586787 Bolsover, Thomas, of Chesterfeld, Derbs, merchant 0
4188390 2091436 2091436 defendant Eyer Robert gent 586787 586787 Eyer, Robert, of Chesterfeld, Derbs, gent 1
4207380 2098135 2098135 defendant Foxe Richard cordwainer 586787 586787 Foxe, Richard, of Chesterfeld, Derbs, cordwainer 0
4215625 2100962 2100962 defendant Clarke William tanner 586787 586787 Clarke, William, of Chesterfeld, Derbs, tanner 0
4215627 2100963 2100963 defendant Clarke William tanner 586787 586787 Clarke, William, of Chesterfeld, Derbs, tanner 0
4389350 2161065 2161065 defendant Smyth Roger yeoman 586787 586787 Smyth, Roger, of Chesterfeld, Derbs, yeoman 3
4655538 2247626 2247626 defendant Lese Thomas chapman 586787 586787 Lese, Thomas, of Chesterfeld, Derbs, chapman 0
4655542 2247627 2247627 defendant Lese Thomas chapman 586787 586787 Lese, Thomas, of Chesterfeld, Derbs, chapman 0
4689488 2262268 2262268 defendant Boler Roger yeoman 586787 586787 Boler, Roger, of Chesterfeld, Derbs, yeoman 0
4748235 2279991 2279991 defendant Boure Thurstan esq 586787 586787 Boure, Thurstan, of Chesterfeld, Derbs, esq 0
4820837 2302606 2302606 defendant Brampton William merchant 586787 586787 Brampton, William, of Chesterfeld, Derbs, merchant 1
4869791 2317523 2317523 defendant Grenelef John mercer 586787 586787 Grenelef, John, of Chesterfeld, Derbs, mercer 0
4886516 2322645 2322645 defendant Grenelef John mercer 586787 586787 Grenelef, John, of Chesterfeld, Derbs, mercer 3
4945432 2340551 2340551 defendant Forster Geoffrey dyer 586787 586787 Forster, Geoffrey, of Chesterfeld, Derbs, dyer 0
4962346 2345639 2345639 defendant Moldson John, junior leadmonger 586787 586787 Moldson, John, junior, of Chesterfeld, Derbs, leadmonger 0
4971146 2348309 2348309 defendant Carre Richard esq 586787 586787 Carre, Richard, of Chesterfeld, Derbs, esq 0
5009839 2359753 2359753 defendant Northwode John miller 586787 586787 Northwode, John, of Chesterfeld, Derbs, miller 1
5014880 2361231 2361231 defendant Glover William glover 586787 586787 Glover, William, of Chesterfeld, Derbs, glover 1
5028993 2365349 2365349 defendant Car Richard yeoman 586787 586787 Car, Richard, of Chesterfeld, Derbs, yeoman 0
5047006 2370728 2370728 defendant Car Richard yeoman 586787 586787 Car, Richard, of Chesterfeld, Derbs, yeoman 3
5067226 2376714 2376714 defendant Swalowe Thomas merchant 586787 586787 Swalowe, Thomas, of Chesterfeld, Derbs, merchant 0
5067230 2376715 2376715 defendant Swalowe Thomas merchant 586787 586787 Swalowe, Thomas, of Chesterfeld, Derbs, merchant 0
5067250 2376718 2376718 defendant Calcroft Thomas merchant 586787 586787 Calcroft, Thomas, of Chesterfeld, Derbs, merchant 5
5111251 2389681 2389681 defendant Shentawe John dyer 586787 586787 Shentawe, John, of Chesterfeld, Derbs, dyer 0
5142316 2398872 2398872 defendant Moldeson John   586787 586787 Moldeson, John, of Chesterfeld, Derbs, scythe smith 1
5216693 2420618 2420618 defendant Walker Thomas chapman 586787 586787 (Walker, Thomas, of Chesterfeld, Derbs, chapman 1
5232871 2425198 2425198 defendant Postelford John smith 586787 586787 Postelford, John, of Chesterfeld, Derbs, smith 1
5303956 2446188 2446188 defendant Rygot J_ chapman 586787 586787 Rygot, J_, of Chesterfeld, Derbs, chapman 0
5313897 2449178 2449178 defendant Scryven Alan mercer 586787 586787 Scryven, Alan, of Chesterfeld, Derbs, mercer 3
5379163 2469079 2469079 defendant Paynter Alexander yeoman 586787 586787 Paynter, Alexander, of Chesterfeld, Derbs, yeoman 4
5399833 2475043 2475043 defendant Crochelowe Richard   586787 586787 Crochelowe, Richard, of Chesterfeld, Derbs, shoe maker 7
5410896 2478211 2478211 defendant Selyok Richard (legal representative) 586787 586787 Selyok, Richard, of Chesterfeld, Derbs, executrix of 0
5436865 2485956 2485956 defendant Wepo or Wroo William shoemaker 586787 586787 Wepo or Wroo, William, of Chesterfeld, Derbs, shoemaker 1
5451469 2490313 2490313 defendant Wroo William shoemaker 586787 586787 Wroo, William, of Chesterfeld, Derbs, shoemaker 1
5465512 2494593 2494593 defendant Trygge Thomas dyer 586787 586787 Trygge, Thomas, of Chesterfeld, Derbs, dyer 0
5474809 2497451 2497451 defendant Whyte Thomas mercer 586787 586787 Whyte, Thomas, of Chesterfeld, Derbs, mercer 1
5475169 2497559 2497559 defendant Trygge Thomas dyer 586787 586787 Trygge, Thomas, of Chesterfeld, Derbs, dyer 0
5477021 2498134 2498134 defendant Trygge Thomas dyer 586787 586787 Trygge, Thomas, of Chesterfeld, Derbs, dyer 0
5488550 2501460 2501460 defendant Trygge Thomas dyer 586787 586787 Trygge, Thomas, of Chesterfeld, Derbs, dyer 0
5488554 2501461 2501461 defendant Trygge Thomas dyer 586787 586787 Trygge, Thomas, of Chesterfeld, Derbs, dyer 0
5499192 2504705 2504705 defendant Dorant Thomas, junior gent 586787 586787 Dorant, Thomas, junior, of Chesterfeld, Derbs, gent 0
5499199 2504706 2504706 defendant Dorant Thomas, junior gent 586787 586787 Dorant, Thomas, junior, of Chesterfeld, Derbs, gent 0
5506324 2506890 2506890 defendant Harvye Thomas butcher 586787 586787 Harvye, Thomas, of Chesterfeld, Derbs, butcher 2
5536826 2516005 2516005 defendant White Robert draper 586787 586787 White, Robert, of Chesterfeld, Derbs, draper 0
5567297 2525013 2525013 defendant Skynner Nicholas brasier 586787 586787 Skynner, Nicholas, of Chesterfeld, Derbs, brasier 0
5589346 2531670 2531670 defendant Durrant Thomas, senior gent 586787 586787 Durrant, Thomas, senior, of Chesterfeld, Derbs, gent 0
5589350 2531671 2531671 defendant Durraunt Thomas, senior gent 586787 586787 Durraunt, Thomas, senior, of Chesterfeld, Derbs, gent 0
5627797 2552665 2552665 defendant Pees Roger draper 586787 586787 Pees, Roger, of Chesterfeld, Derbs, draper 0

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