names

1,509 rows where place_id = 587136

✎ 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
3590569 1864691 1864691 defendant Baker John clerk 587136 587136 Baker, John, of Derby, clerk 0
3590573 1864693 1864693 defendant Baker John clerk 587136 587136 Baker, John, of Derby, clerk 0
3594134 1865809 1865809 defendant Bowyer John bowyer 587136 587136 Bowyer, John, of Derby, bowyer 0
3597368 1866798 1866798 defendant Mounford Richard draper 587136 587136 Mounford, Richard, of Derby, draper 0
3598348 1867113 1867113 defendant Bower John bowyer 587136 587136 Bower, John, of Derby, bowyer 0
3598350 1867114 1867114 defendant Dey Richard mercer 587136 587136 Dey, Richard, of Derby, mercer 0
3598352 1867115 1867115 defendant Dey Richard mercer 587136 587136 Dey, Richard, of Derby, mercer 0
3598356 1867117 1867117 defendant Bower William bowyer 587136 587136 Bower, William, of Derby, bowyer 0
3598929 1867293 1867293 defendant Illyngworth Ralph esq 587136 587136 Illyngworth, Ralph, of Derby, esq 0
3598931 1867294 1867294 defendant Illyngworth Ralph esq 587136 587136 Illyngworth, Ralph, of Derby, esq 0
3600335 1867749 1867749 defendant Longford Nicholas (legal representative) 587136 587136 Longford, Nicholas, of Derby, knight, executrix of 0
3601396 1868097 1868097 defendant Baker John butcher 587136 587136 Baker, John, of Derby, butcher 9
3601765 1868210 1868210 defendant Spenser John chaplain 587136 587136 Spenser, John, of Derby, chaplain 1
3602436 1868420 1868420 defendant Strynger John mercer 587136 587136 Strynger, John, of Derby, mercer 0
3603946 1868903 1868903 defendant Broun Richard   587136 587136 Broun, Richard, of Derby, scythe smith 0
3604625 1869109 1869109 defendant Broun Richard   587136 587136 Broun, Richard, of Derby, scythe smith 1
3604626 1869109 1869109 defendant Pryour Henry weaver 587136 587136 Pryour, Henry, of Derby, weaver 2
3611440 1871254 1871254 defendant Lont or Lout Elizabeth widow 587136 587136 Lont or Lout, Elizabeth, of Derby, widow 0
3616916 1872920 1872920 defendant Cok Ralph chapman 587136 587136 Cok, Ralph, of Derby, chapman 0
3616917 1872920 1872920 defendant Harper Richard chapman 587136 587136 Harper, Richard, of Derby, chapman 1
3616918 1872920 1872920 defendant Mounford Richard chapman 587136 587136 Mounford, Richard, of Derby, chapman 2
3616951 1872925 1872925 defendant Wulwat Thomas chapman 587136 587136 Wulwat, Thomas, of Derby, chapman 0
3620912 1874103 1874103 defendant Cochet John   587136 587136 Cochet, John, of Derby, scythe smith 2
3620913 1874103 1874103 defendant Baker John chaplain 587136 587136 Baker, John, of Derby, chaplain 3
3623984 1875033 1875033 defendant Robynson Richard draper 587136 587136 Robynson, Richard, of Derby, draper 0
3624348 1875148 1875148 defendant Strelley Thomas tailor 587136 587136 Strelley, Thomas, of Derby, tailor 3
3625831 1875613 1875613 plaintiff Byrd John   587136 587136 Byrd, John, of Derby 3
3626268 1903071 1903071 defendant Joly William yeoman 587136 587136 Joly, William, of Derby, yeoman 0
3626272 1903073 1903073 defendant Wright Agnes widow 587136 587136 Wright, Agnes, of Derby, widow 0
3630377 1904337 1904337 defendant More Roger draper 587136 587136 More, Roger, of Derby, draper 1
3630378 1904337 1904337 defendant Frebank Edmund yeoman 587136 587136 Frebank, Edmund, of Derby, yeoman 2
3634127 1905472 1905472 defendant Birde Margaret widow 587136 587136 Birde, Margaret, of Derby, widow 0
3634560 1905612 1905612 defendant Quorneby John yeoman 587136 587136 Quorneby, John, of Derby, yeoman 0
3639355 1907118 1907118 defendant Strynger Margery widow 587136 587136 Strynger, Margery, of Derby, widow 0
3639356 1907118 1907118 defendant Strynger William yeoman 587136 587136 Strynger, William, of Derby, yeoman 1
3644776 1908772 1908772 defendant Wolfett William mercer 587136 587136 Wolfett, William, of Derby, mercer 0
3645164 1908895 1908895 defendant Thacker Oliver merchant of the staple 587136 587136 Thacker, Oliver, of Derby, merchant of the staple 0
3654618 1911707 1911707 defendant Legge Richard butcher 587136 587136 Legge, Richard, of Derby, butcher 0
3655361 1911936 1911936 defendant More William   587136 587136 More, William, of Derby, dr aper 0
3658884 1913035 1913035 defendant Stokys Helen widow 587136 587136 Stokys, Helen, of Derby, widow 0
3660185 1913447 1913447 defendant Glover William glover 587136 587136 Glover, William, of Derby, glover 1
3661785 1913966 1913966 defendant FitzHerberd Robert gent 587136 587136 FitzHerberd, Robert, of Derby, gent 1
3661788 1913967 1913967 defendant Fitzherbert Robert gent 587136 587136 Fitzherbert, Robert, of Derby, gent 1
3662801 1914283 1914283 defendant More William yeoman 587136 587136 More, William, of Derby, yeoman 1
3665136 1915047 1915047 defendant Moore William draper 587136 587136 Moore, William, of Derby, draper 0
3665138 1915048 1915048 defendant More William draper 587136 587136 More, William, of Derby, draper 0
3665535 1915171 1915171 defendant Sympson Ellis yeoman 587136 587136 Sympson, Ellis, of Derby, yeoman 3
3668556 1916123 1916123 defendant Orcherd Nicholas saddler 587136 587136 Orcherd, Nicholas, of Derby, saddler 2
3670464 1916720 1916720 defendant Love Vincent esq 587136 587136 Love, Vincent, of Derby, esq 0
3674052 1917926 1917926 defendant Thakker Christopher mercer 587136 587136 Thakker, Christopher, of Derby, mercer 0
3676538 1918706 1918706 defendant Thakker Christopher mercer 587136 587136 Thakker, Christopher, of Derby, mercer 0
3682178 1920531 1920531 defendant More Roger draper 587136 587136 More, Roger, of Derby, draper 0
3682179 1920531 1920531 defendant Dey Margery widow 587136 587136 Dey, Margery, of Derby, widow 1
3682183 1920532 1920532 defendant Glasyer William yeoman 587136 587136 (Glasyer, William, of Derby, yeoman 1
3687935 1922385 1922385 defendant Holbroke Richard shoemaker 587136 587136 Holbroke, Richard, of Derby, shoemaker 3
3689001 1922719 1922719 defendant Radford James chapman 587136 587136 Radford, James, of Derby, chapman 0
3691769 1923585 1923585 defendant Spon or Sponer John chapman 587136 587136 Spon or Sponer, John, of Derby, chapman 0
3692438 1923813 1923813 plaintiff Joly William   587136 587136 Joly, William, of Derby 0
3696829 1925231 1925231 defendant Heyther John dyer 587136 587136 Heyther, John, of Derby, dyer 0
3697070 1925303 1925303 defendant Thakker Christopher mercer 587136 587136 Thakker, Christopher, of Derby, mercer 0
3697071 1925303 1925303 defendant Thakker James mercer 587136 587136 Thakker, James, of Derby, mercer 1
3697072 1925303 1925303 defendant Hatfeld Gilbert mercer 587136 587136 Hatfeld, Gilbert, of Derby, mercer 2
3704029 1927548 1927548 defendant Jelly alias Glover William glover 587136 587136 Jelly alias Glover, William, of Derby, glover 0
3706704 1928382 1928382 defendant Strynger Henry baker 587136 587136 Strynger, Henry, of Derby, baker 0
3707834 1928748 1928748 defendant Mowre William draper 587136 587136 Mowre, William, of Derby, draper 0
3711223 1929815 1929815 defendant Strynger Henry yeoman 587136 587136 Strynger, Henry, of Derby, yeoman 0
3711226 1929816 1929816 defendant Jakson John (legal representative) 587136 587136 Jakson, John, of Derby, yeoman, executrix of 0
3711227 1929816 1929816 defendant Glasyer Margery   587136 587136 Glasyer, Margery, of Derby, widow, formtely Jakson, Margery 1
3714001 1930676 1930676 defendant Myller Thomas glover 587136 587136 Myller, Thomas, of Derby, glover 0
3718228 1931983 1931983 defendant Robynson Thomas miller 587136 587136 Robynson, Thomas, of Derby, miller 0
3725471 1934256 1934256 defendant Radford James mercer 587136 587136 Radford, James, of Derby, mercer 0
3725472 1934256 1934256 defendant Hatfeld William mercer 587136 587136 Hatfeld, William, of Derby, mercer 1
3725473 1934256 1934256 defendant Spone John mercer 587136 587136 Spone, John, of Derby, mercer 2
3730821 1935867 1935867 defendant Thacker Christopher mercer 587136 587136 Thacker, Christopher, of Derby, mercer 1
3743330 1939786 1939786 defendant More Roger draper 587136 587136 More, Roger, of Derby, draper 1
3743331 1939786 1939786 defendant Farryngton John   587136 587136 Farryngton, John, of Derby, wax chandler 2
3745196 1940403 1940403 defendant Ilseley Richard butcher 587136 587136 Ilseley, Richard, of Derby, butcher 0
3752733 1942783 1942783 defendant Strynger Henry baker 587136 587136 Strynger, Henry, of Derby, baker 0
3755404 1943643 1943643 defendant More Roger draper 587136 587136 More, Roger, of Derby, draper 0
3756639 1944058 1944058 defendant Hether Thomas dyer 587136 587136 Hether, Thomas, of Derby, dyer 0
3756678 1944066 1944066 defendant Gylbard William butcher 587136 587136 Gylbard, William, of Derby, butcher 6
3756680 1944066 1944066 defendant Joly William yeoman 587136 587136 Joly, William, of Derby, yeoman 8
3756681 1944066 1944066 defendant Netham Philip yeoman 587136 587136 Netham, Philip, of Derby, yeoman 9
3757655 1944373 1944373 defendant Newton Thomas gent 587136 587136 Newton, Thomas, of Derby, gent 1
3760758 1945365 1945365 defendant Deyn Agnes widow 587136 587136 Deyn, Agnes, of Derby, widow 1
3766046 1947046 1947046 defendant Jolye William courser 587136 587136 Jolye, William, of Derby, courser 2
3767270 1947404 1947404 defendant Thakker Christopher mercer 587136 587136 Thakker, Christopher, of Derby, mercer 0
3768316 1947731 1947731 defendant Tacker Christopher chapman 587136 587136 Tacker, Christopher, of Derby, chapman 5
3770267 1948371 1948371 defendant Yorke Robert yeoman 587136 587136 Yorke, Robert, of Derby, yeoman 0
3770268 1948371 1948371 defendant Cowper Elias   587136 587136 Cowper, Elias, of Derby, rope maker 1
3772681 1949149 1949149 defendant Walker William butcher 587136 587136 Walker, William, of Derby, butcher 0
3779573 1951341 1951341 defendant Hobson William yeoman 587136 587136 Hobson, William, of Derby, yeoman 0
3779575 1951342 1951342 defendant Hobson William yeoman 587136 587136 Hobson, William, of Derby, yeoman 0
3784588 1952967 1952967 defendant More William, junior draper 587136 587136 More, William, junior, of Derby, draper 1
3784594 1952968 1952968 defendant More William, junior draper 587136 587136 More, William, junior, of Derby, draper 1
3787872 1953996 1953996 defendant Walker Hugh butcher 587136 587136 Walker, Hugh, of Derby, butcher 0
3788539 1954212 1954212 defendant Thakker Christopher mercer 587136 587136 Thakker, Christopher, of Derby, mercer 0
3791841 1955293 1955293 defendant Archer Nicholas saddler 587136 587136 Archer, Nicholas, of Derby, saddler 0
3797188 1957004 1957004 defendant Newton Thomas gent 587136 587136 Newton, Thomas, of Derby, gent 0
3797206 1957008 1957008 defendant Newton Thomas gent 587136 587136 Newton, Thomas, of Derby, gent 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);