names

439 rows where place_id = 587631

✎ 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
3591997 1865111 1865111 defendant Durraunt Thomas, senior gent 587631 587631 Durraunt, Thomas, senior, of Chesterfeld, gent 0
3591998 1865111 1865111 defendant Durraunt Thomas, junior gent 587631 587631 Durraunt, Thomas, junior, of Chesterfeld, gent 1
3591999 1865111 1865111 defendant Hoppas Robert husbandman 587631 587631 Hoppas, Robert, of Chesterfeld, husbandman 2
3592001 1865112 1865112 defendant Hethcote Richard potter 587631 587631 Hethcote, Richard, of Chesterfeld, potter 0
3592002 1865112 1865112 defendant Hethcote John mercer 587631 587631 Hethcote, John, of Chesterfeld, mercer 1
3592003 1865112 1865112 defendant Harper Thomas chaplain 587631 587631 Harper, Thomas, of Chesterfeld, chaplain 2
3592004 1865112 1865112 defendant Brodehede Richard draper 587631 587631 Brodehede, Richard, of Chesterfeld, draper 3
3592005 1865112 1865112 defendant Landesdale Richard draper 587631 587631 Landesdale, Richard, of Chesterfeld, draper 4
3596157 1866427 1866427 defendant Penyston William bowyer 587631 587631 Penyston, William, of Chesterfeld, bowyer 0
3597406 1866809 1866809 defendant Brodehed George yeoman 587631 587631 Brodehed, George, of Chesterfeld, yeoman 1
3600640 1867847 1867847 defendant Shirbroke Nicholas yeoman 587631 587631 Shirbroke, Nicholas, of Chesterfeld, yeoman 4
3603944 1868902 1868902 defendant Whitte Thomas chapman 587631 587631 Whitte, Thomas, of Chesterfeld, chapman 4
3610097 1870824 1870824 defendant Shirbroke Nicholas yeoman 587631 587631 Shirbroke, Nicholas, of Chesterfeld, yeoman 4
3611043 1871132 1871132 defendant Camme William butcher 587631 587631 Camme, William, of Chesterfeld, butcher 1
3611044 1871132 1871132 defendant Wode Alexander laborer 587631 587631 Wode, Alexander, of Chesterfeld, laborer 2
3611045 1871132 1871132 defendant Paynter Alexander tailor 587631 587631 Paynter, Alexander, of Chesterfeld, tailor 3
3611046 1871132 1871132 defendant Bromhede William cardmaker 587631 587631 Bromhede, William, of Chesterfeld, cardmaker 4
3617332 1873044 1873044 defendant Turnour John yeoman 587631 587631 Turnour, John, of Chesterfeld, yeoman 2
3617339 1873045 1873045 defendant Turnour John yeoman 587631 587631 Turnour, John, of Chesterfeld, yeoman 2
3617344 1873046 1873046 defendant Leek Thomas gent 587631 587631 Leek, Thomas, of Chesterfeld, gent 0
3617358 1873049 1873049 defendant Togood Robert laborer 587631 587631 Togood, Robert, of Chesterfeld, laborer 7
3617359 1873049 1873049 defendant Togood Thomas laborer 587631 587631 Togood, Thomas, of Chesterfeld, laborer 8
3622747 1874643 1874643 defendant Durram Thomas, senior gent 587631 587631 Durram, Thomas, senior, of Chesterfeld, gent 0
3622749 1874644 1874644 defendant Durrante Thomas, junior   587631 587631 Durrante, Thomas, junior, of Chesterfeld, gent, son of Durrante, Thomas, senior, 0
3626763 1903218 1903218 defendant Hadfeld Robert smith 587631 587631 Hadfeld, Robert, of Chesterfeld, smith 0
3630762 1904447 1904447 plaintiff Foliambe Thomas gent 587631 587631 Foliambe, Thomas, of Chesterfeld, gent 0
3632484 1904980 1904980 defendant Chay Thurstan butcher 587631 587631 Chay, Thurstan, of Chesterfeld, butcher 0
3632485 1904980 1904980 defendant Leche Alan butcher 587631 587631 Leche, Alan, of Chesterfeld, butcher 1
3632486 1904980 1904980 defendant Greve Philip weaver 587631 587631 Greve, Philip, of Chesterfeld, weaver 2
3632487 1904980 1904980 defendant Gregory John yeoman 587631 587631 Gregory, John, of Chesterfeld, yeoman 3
3632539 1904993 1904993 defendant Tapyer John laborer 587631 587631 Tapyer, John, of Chesterfeld, laborer 5
3633674 1905343 1905343 defendant Mellour William baker 587631 587631 Mellour, William, of Chesterfeld, baker 0
3633675 1905343 1905343 defendant Hasylhurste Robert carter 587631 587631 Hasylhurste, Robert, of Chesterfeld, carter 1
3658749 1912990 1912990 defendant Rotheram William butcher 587631 587631 Rotheram, William, of Chesterfeld, butcher 0
3660385 1913504 1913504 defendant Skynner Nicholas glover 587631 587631 Skynner, Nicholas, of Chesterfeld, glover 0
3665384 1915127 1915127 defendant Heyworth Hugh draper 587631 587631 Heyworth, Hugh, of Chesterfeld, draper 1
3665385 1915127 1915127 defendant Croslond John draper 587631 587631 Croslond, John, of Chesterfeld, draper 2
3665386 1915127 1915127 defendant Meykyng Thomas weaver 587631 587631 Meykyng, Thomas, of Chesterfeld, weaver 3
3665387 1915127 1915127 defendant Leder Thomas weaver 587631 587631 Leder, Thomas, of Chesterfeld, weaver 4
3668876 1916198 1916198 defendant Brodeheld Robert draper 587631 587631 Brodeheld, Robert, of Chesterfeld, draper 0
3668877 1916198 1916198 defendant benson Nicholas draper 587631 587631 benson, Nicholas, of Chesterfeld, draper 1
3671306 1916999 1916999 defendant Durrant Richard yeoman 587631 587631 Durrant, Richard, of Chesterfeld, yeoman 0
3680919 1920114 1920114 defendant Asshe Agnes widow 587631 587631 Asshe, Agnes, of Chesterfeld, widow 0
3681601 1920337 1920337 defendant Hethcote William brasier 587631 587631 Hethcote, William, of Chesterfeld, brasier 0
3681602 1920337 1920337 defendant Pyllysley Richard brasier 587631 587631 Pyllysley, Richard, of Chesterfeld, brasier 1
3683242 1920878 1920878 defendant Matlok John dyer 587631 587631 Matlok, John, of Chesterfeld, dyer 1
3684067 1921150 1921150 defendant Brodhed Robert draper 587631 587631 Brodhed, Robert, of Chesterfeld, draper 0
3686927 1922077 1922077 defendant Shemeld John sherman 587631 587631 Shemeld, John, of Chesterfeld, sherman 0
3686929 1922078 1922078 defendant Wyllye William butcher 587631 587631 Wyllye, William, of Chesterfeld, butcher 0
3689366 1922839 1922839 plaintiff Grene William   587631 587631 Grene, William, of Chesterfeld 4
3689372 1922840 1922840 plaintiff Grene William   587631 587631 Grene, William, of Chesterfeld 4
3689378 1922841 1922841 plaintiff Grene William   587631 587631 Grene, William, of Chesterfeld 4
3689384 1922842 1922842 plaintiff Grene William   587631 587631 Grene, William, of Chesterfeld 4
3689390 1922843 1922843 plaintiff Grene William   587631 587631 Grene, William, of Chesterfeld 4
3689396 1922844 1922844 plaintiff Grene William   587631 587631 Grene, William, of Chesterfeld 4
3689402 1922845 1922845 plaintiff Grene William   587631 587631 Grene, William, of Chesterfeld 4
3689408 1922846 1922846 plaintiff Grene William   587631 587631 Grene, William, of Chesterfeld 4
3689414 1922847 1922847 plaintiff Grene William   587631 587631 Grene, William, of Chesterfeld 4
3691574 1923522 1923522 defendant Bate Ralph yeoman 587631 587631 Bate, Ralph, of Chesterfeld, yeoman 0
3692146 1923713 1923713 defendant Wylly William butcher 587631 587631 Wylly, William, of Chesterfeld, butcher 0
3692724 1923912 1923912 defendant Wyllye William butcher 587631 587631 Wyllye, William, of Chesterfeld, butcher 0
3696270 1925053 1925053 defendant Wyllye William butcher 587631 587631 Wyllye, William, of Chesterfeld, butcher 0
3702023 1926887 1926887 defendant Shemeld John sherman 587631 587631 Shemeld, John, of Chesterfeld, sherman 0
3704974 1927848 1927848 defendant Harryson Robert dyer 587631 587631 Harryson, Robert, of Chesterfeld, dyer 0
3706990 1928469 1928469 defendant Byngley Henry weaver 587631 587631 Byngley, Henry, of Chesterfeld, weaver 0
3706992 1928470 1928470 defendant Shemell John sherman 587631 587631 Shemell, John, of Chesterfeld, sherman 0
3708216 1928864 1928864 defendant Bate Ralph mercer 587631 587631 Bate, Ralph, of Chesterfeld, mercer 1
3709775 1929372 1929372 defendant Rotherham William butcher 587631 587631 Rotherham, William, of Chesterfeld, butcher 0
3709777 1929373 1929373 defendant Rotherham William butcher 587631 587631 Rotherham, William, of Chesterfeld, butcher 0
3709907 1929413 1929413 defendant Rotherham William butcher 587631 587631 Rotherham, William, of Chesterfeld, butcher 0
3724341 1933900 1933900 defendant Rotherham William husbandman 587631 587631 Rotherham, William, of Chesterfeld, husbandman 0
3724948 1934090 1934090 defendant Tappetur Thomas saddler 587631 587631 Tappetur, Thomas, of Chesterfeld, saddler 0
3725736 1934338 1934338 defendant Wedowson Richard yeoman 587631 587631 Wedowson, Richard, of Chesterfeld, yeoman 3
3725737 1934338 1934338 defendant Rigott Ralph yeoman 587631 587631 Rigott, Ralph, of Chesterfeld, yeoman 4
3730608 1935808 1935808 defendant Couper Richard laborer 587631 587631 Couper, Richard, of Chesterfeld, laborer 0
3730611 1935808 1935808 defendant Crosseland Alan butcher 587631 587631 (Crosseland, Alan, of Chesterfeld, butcher 3
3742862 1939620 1939620 defendant Crawe Robert carpenter 587631 587631 Crawe, Robert, of Chesterfeld, carpenter 0
3744876 1940296 1940296 defendant Logge William butcher 587631 587631 Logge, William, of Chesterfeld, butcher 0
3747565 1941156 1941156 defendant Abbot William butcher 587631 587631 Abbot, William, of Chesterfeld, butcher 0
3756684 1944066 1944066 defendant Rogotte Ralph husbandman 587631 587631 Rogotte, Ralph, of Chesterfeld, husbandman 12
3762392 1945880 1945880 defendant Abbot William butcher 587631 587631 Abbot, William, of Chesterfeld, butcher 3
3764797 1946655 1946655 defendant Watkynson William husbandman 587631 587631 Watkynson, William, of Chesterfeld, husbandman 0
3771706 1948851 1948851 defendant Legge William gent 587631 587631 Legge, William, of Chesterfeld, gent 0
3771707 1948851 1948851 defendant Layche William yeoman 587631 587631 Layche, William, of Chesterfeld, yeoman 1
3771708 1948851 1948851 defendant Wydeweston Richard collier 587631 587631 Wydeweston, Richard, of Chesterfeld, collier 2
3772672 1949146 1949146 plaintiff Warde John   587631 587631 Warde, John, of Chesterfeld 0
3776044 1950251 1950251 defendant Clyff William upholsterer 587631 587631 Clyff, William, of Chesterfeld, upholsterer 3
3781913 1952091 1952091 plaintiff Hethcot Richard (legal representative) 587631 587631 Hethcot, Richard, of Chesterfeld, administrator of 0
3783726 1952674 1952674 defendant Barlowe Richard yeoman 587631 587631 Barlowe, Richard, of Chesterfeld, yeoman 0
3787470 1953871 1953871 defendant Abbot William butcher 587631 587631 Abbot, William,of Chesterfeld, butcher 0
3792731 1955580 1955580 plaintiff Baxter William tanner 587631 587631 Baxter, William, of Chesterfeld, tanner 0
3792733 1955580 1955580 defendant Worth John yeoman 587631 587631 Worth, John, of Chesterfeld, yeoman 1
3792735 1955580 1955580 defendant Herryson Robert yeoman 587631 587631 Herryson, Robert, of Chesterfeld, yeoman 3
3793128 1955711 1955711 defendant Cade Robert tanner 587631 587631 Cade, Robert, of Chesterfeld, tanner 1
3793421 1955808 1955808 plaintiff Brailesford William butcher 587631 587631 Brailesford, William, of Chesterfeld, butcher 0
3793423 1955808 1955808 defendant Worth John yeoman 587631 587631 Worth, John, of Chesterfeld, yeoman 1
3793425 1955808 1955808 defendant Herryson Robert yeoman 587631 587631 Herryson, Robert, of Chesterfeld, yeoman 3
3795840 1956565 1956565 defendant Batte Ralph mercer 587631 587631 Batte, Ralph, of Chesterfeld, mercer 0
3795841 1956565 1956565 defendant Mason alias Johnson Robert glover 587631 587631 Mason alias Johnson, Robert, of Chesterfeld, glover 1
3796875 1956900 1956900 defendant Worth John yeoman 587631 587631 Worth, John, of Chesterfeld, yeoman 1

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