names

649 rows where place_id = 585864

✎ 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
3587384 1863695 1863695 defendant Andrewson Robert fuller 585864 585864 Andrewson, Robert, of Cranebroke, fuller 1
3587393 1863701 1863701 defendant Draner or Draver John clothmaker 585864 585864 Draner or Draver, John, of Cranebroke, clothmaker 0
3590560 1864688 1864688 defendant Bisshop Robert clothmaker 585864 585864 Bisshop, Robert, of Cranebroke, clothmaker 0
3591369 1864925 1864925 defendant Bassok William clothmaker 585864 585864 Bassok, William, of Cranebroke, clothmaker 2
3591371 1864925 1864925 defendant Gebon Henry clothmaker 585864 585864 Gebon, Henry, of Cranebroke, clothmaker 4
3591736 1865035 1865035 plaintiff Everynden William   585864 585864 Everynden, William, of Cranebroke 0
3595349 1866177 1866177 defendant Andrewson Robert fuller 585864 585864 Andrewson, Robert, of Cranebroke, fuller 1
3595352 1866178 1866178 defendant Bysshop Bartholomew clothmaker 585864 585864 Bysshop, Bartholomew, of Cranebroke, clothmaker 1
3595355 1866179 1866179 defendant Bysshop Bartholomew clothmaker 585864 585864 Bysshop, Bartholomew, of Cranebroke, clothmaker 1
3596527 1866548 1866548 defendant Holstok Robert clothmaker 585864 585864 Holstok, Robert, of Cranebroke, clothmaker 0
3597259 1866763 1866763 defendant Jury Richard   585864 585864 Jury, Richard, of Cranebroke, mason 1
3597949 1866982 1866982 defendant Everynden William weaver 585864 585864 Everynden, William, of Cranebroke, weaver 2
3598714 1867224 1867224 defendant Bassok William clothmaker 585864 585864 Bassok, William, of Cranebroke, clothmaker 0
3599810 1867586 1867586 defendant Hale John yeoman 585864 585864 Hale, John, of Cranebroke, yeoman 1
3599813 1867587 1867587 defendant Hale John yeoman 585864 585864 Hale, John, of Cranebroke, yeoman 1
3600080 1867674 1867674 defendant Bettenham Stephen (legal representative) 585864 585864 Bettenham, Stephen, of Cranebroke, gent, executor of 0
3600081 1867674 1867674 defendant Bettenham William gent 585864 585864 Bettenham, William, of Cranebroke, gent 1
3601870 1868239 1868239 plaintiff Bettenham William (legal representative) 585864 585864 Bettenham, William, of Cranebroke, gent, executors of 0
3602736 1868521 1868521 defendant Bettenham William (legal representative) 585864 585864 Bettenham, William, of Cranebroke, gent, executors of 0
3602737 1868521 1868521 defendant Swafham John yeoman 585864 585864 (Swafham, John, of Cranebroke, yeoman 1
3602744 1868524 1868524 defendant Benet William butcher 585864 585864 Benet, William, of Cranebroke, butcher 0
3603302 1868706 1868706 defendant Bysshop Robert husbandman 585864 585864 Bysshop, Robert, of Cranebroke, husbandman 0
3603679 1868819 1868819 defendant Bysshop Robert clothmaker 585864 585864 Bysshop, Robert, of Cranebroke, clothmaker 1
3604895 1869197 1869197 defendant Attehale John husbandman 585864 585864 Attehale, John, of Cranebroke, husbandman 0
3608312 1870257 1870257 defendant Sandyr Robert laborer 585864 585864 Sandyr, Robert, of Cranebroke, laborer 1
3613019 1871722 1871722 defendant Benet William husbandman 585864 585864 Benet, William, of Cranebroke, husbandman 0
3615027 1872345 1872345 defendant Everynden Thomas weaver 585864 585864 Everynden, Thomas, of Cranebroke, weaver 0
3615028 1872345 1872345 defendant Everynden Ralph weaver 585864 585864 Everynden, Ralph, of Cranebroke, weaver 1
3615059 1872354 1872354 defendant Blybery John yeoman 585864 585864 Blybery, John, of Cranebroke, yeoman 2
3615267 1872421 1872421 defendant West Walter cordwainer 585864 585864 West, Walter, of Cranebroke, cordwainer 0
3615594 1872516 1872516 defendant Pekynden George laborer 585864 585864 Pekynden, George, of Cranebroke, laborer 2
3616731 1872863 1872863 defendant Harynden James husbandman 585864 585864 Harynden, James, of Cranebroke, husbandman 0
3618046 1873266 1873266 defendant Lynche Ralph clothmaker 585864 585864 Lynche, Ralph, of Cranebroke, clothmaker 0
3618120 1873291 1873291 plaintiff Gough William   585864 585864 Gough, William, of Cranebroke 0
3618121 1873291 1873291 defendant Ricard Thomas butcher 585864 585864 Ricard, Thomas, of Cranebroke, butcher 0
3620006 1873829 1873829 defendant Benet William husbandman 585864 585864 Benet, William, of Cranebroke, husbandman 1
3620280 1873923 1873923 defendant Brekynden John clothmaker 585864 585864 Brekynden, John, of Cranebroke, clothmaker 0
3620582 1874014 1874014 defendant Batheherst John butcher 585864 585864 Batheherst, John, of Cranebroke, butcher 1
3620872 1874090 1874090 defendant Batehurst John butcher 585864 585864 Batehurst, John, of Cranebroke, butcher 1
3620873 1874090 1874090 defendant Bronger or Brouger John   585864 585864 Bronger or Brouger, John, of Cranebroke, "rypyer" 2
3623563 1874898 1874898 defendant Benden John butcher 585864 585864 Benden, John, of Cranebroke, butcher 0
3624655 1875246 1875246 defendant Brekynden John clothmaker 585864 585864 Brekynden, John, of Cranebroke, clothmaker 0
3626557 1903156 1903156 defendant Benet William butcher 585864 585864 Benet, William, of Cranebroke, butcher 0
3629968 1904226 1904226 defendant Chetynden Stephen husbandman 585864 585864 Chetynden, Stephen, of Cranebroke, husbandman 1
3629969 1904226 1904226 defendant Hunte John butcher 585864 585864 Hunte, John, of Cranebroke, butcher 2
3629970 1904226 1904226 defendant Burges William butcher 585864 585864 Burges, William, of Cranebroke, butcher 3
3629974 1904227 1904227 defendant Chotynden Stephen husbandman 585864 585864 Chotynden, Stephen, of Cranebroke, husbandman 1
3629975 1904227 1904227 defendant Hunte John butcher 585864 585864 Hunte, John, of Cranebroke, butcher 2
3629976 1904227 1904227 defendant Burges William butcher 585864 585864 Burges, William, of Cranebroke, butcher 3
3631392 1904629 1904629 defendant Lynche Thomas yeoman 585864 585864 Lynche, Thomas, of Cranebroke, yeoman 0
3632240 1904900 1904900 defendant Fayerwey Robert clothmaker 585864 585864 Fayerwey, Robert, of Cranebroke, clothmaker 1
3632272 1904913 1904913 defendant Ham John yeoman 585864 585864 Ham, John, of Cranebroke, yeoman 0
3639913 1907298 1907298 defendant Bassok John yeoman 585864 585864 Bassok, John, of Cranebroke, yeoman 0
3639923 1907301 1907301 defendant Bassok John clothmaker 585864 585864 Bassok, John, of Cranebroke, clothmaker 1
3639925 1907301 1907301 defendant Hubbard John husbandman 585864 585864 Hubbard, John, of Cranebroke, husbandman 3
3642940 1908245 1908245 defendant Maplisden Thomas butcher 585864 585864 Maplisden, Thomas, of Cranebroke, butcher 0
3642941 1908245 1908245 defendant Garrard William fuller 585864 585864 Garrard, William, of Cranebroke, fuller 1
3642942 1908245 1908245 defendant Okeherst Simon weaver 585864 585864 Okeherst, Simon, of Cranebroke, weaver 2
3642943 1908245 1908245 defendant Symons Robert smith 585864 585864 Symons, Robert, of Cranebroke, smith 3
3642944 1908245 1908245 defendant Browne Richard laborer 585864 585864 Browne, Richard, of Cranebroke, laborer 4
3642945 1908245 1908245 defendant Fyssynden Simon laborer 585864 585864 Fyssynden, Simon, of Cranebroke, laborer 5
3642946 1908245 1908245 defendant Holewey John brewer 585864 585864 Holewey, John, of Cranebroke, brewer 6
3642947 1908245 1908245 defendant Grenestrete Thomas weaver 585864 585864 Grenestrete, Thomas, of Cranebroke, weaver 7
3642948 1908245 1908245 defendant Horsle John sherman 585864 585864 Horsle, John, of Cranebroke, sherman 8
3642949 1908245 1908245 defendant Gouter Edmund fuller 585864 585864 Gouter, Edmund, of Cranebroke, fuller 9
3642950 1908245 1908245 defendant Fletcher John fletcher 585864 585864 Fletcher, John, of Cranebroke, fletcher 10
3642951 1908245 1908245 defendant Brykynden William fuller 585864 585864 Brykynden, William, of Cranebroke, fuller 11
3650489 1910521 1910521 defendant Benett William butcher 585864 585864 Benett, William, of Cranebroke, butcher 0
3650490 1910521 1910521 defendant Clerke Henry cordwainer 585864 585864 Clerke, Henry, of Cranebroke, cordwainer 1
3650790 1910610 1910610 defendant Brykkynden William tailor 585864 585864 Brykkynden, William, of Cranebroke, tailor 0
3653075 1911291 1911291 defendant Dowle John butcher 585864 585864 Dowle, John, of Cranebroke, butcher 0
3653077 1911291 1911291 defendant Strayton Thomas butcher 585864 585864 Strayton,Thomas, of Cranebroke, butcher 2
3653555 1911380 1911380 defendant Everynden Richard weaver 585864 585864 Everynden, Richard, of Cranebroke, weaver 0
3654776 1911752 1911752 plaintiff Barre Richard clothier 585864 585864 Barre, Richard, of Cranebroke, clothier 0
3654809 1911764 1911764 defendant Patching Henry weaver 585864 585864 Patching, Henry, of Cranebroke, weaver 0
3654813 1911764 1911764 defendant Hovynden (illegible) fuller 585864 585864 Hovynden, --, of Cranebroke, fuller 4
3660440 1913525 1913525 defendant Brygenden Robert   585864 585864 Brygenden, Robert, of Cranebroke 0
3665808 1915246 1915246 defendant Jenyns John weaver 585864 585864 Jenyns, John, of Cranebroke, weaver 2
3665991 1915297 1915297 defendant Batherst Lawrence weaver 585864 585864 Batherst, Lawrence, of Cranebroke, weaver 0
3667255 1915693 1915693 defendant Carkerege John yeoman 585864 585864 Carkerege, John, of Cranebroke, yeoman 0
3672356 1917356 1917356 defendant Wardaker Edward fuller 585864 585864 Wardaker, Edward, of Cranebroke, fuller 0
3672911 1917541 1917541 plaintiff Draner Stephen clothman 585864 585864 Draner, Stephen, of Cranebroke, clothman 0
3672914 1917541 1917541 defendant Fowle William tailor 585864 585864 Fowle, William, of Cranebroke, tailor 2
3676068 1918550 1918550 defendant Mapysden William butcher 585864 585864 Mapysden, William, of Cranebroke, butcher 0
3676474 1918687 1918687 defendant Marbyll Thomas smith 585864 585864 Marbyll, Thomas, of Cranebroke, carpenter: Jacob, John, of Maydeston, smith 0
3677071 1918868 1918868 defendant Scranton Simon clothier 585864 585864 Scranton, Simon, of Cranebroke, clothier 0
3678658 1919388 1919388 defendant Weller Thomas yeoman 585864 585864 Weller, Thomas, of Cranebroke, yeoman 0
3678660 1919389 1919389 defendant Weller Thomas yeoman 585864 585864 Weller, Thomas, of Cranebroke, yeoman 0
3679106 1919531 1919531 defendant Page Richard clothmaker 585864 585864 Page, Richard, of Cranebroke, clothmaker 0
3679545 1919671 1919671 defendant Bassok Robert fuller 585864 585864 Bassok, Robert, of Cranebroke, fuller 1
3680403 1919954 1919954 defendant Drayner Stephen clothier 585864 585864 Drayner, Stephen, of Cranebroke, clothier 0
3680984 1920132 1920132 defendant Dowle John butcher 585864 585864 Dowle, John, of Cranebroke, butcher 1
3682495 1920628 1920628 defendant Lesden Henry weaver 585864 585864 Lesden, Henry, of Cranebroke, weaver 2
3686361 1921892 1921892 defendant Marvyll Thomas carpenter 585864 585864 Marvyll, Thomas, of Cranebroke, carpenter 0
3687329 1922216 1922216 defendant Bassok John yeoman 585864 585864 Bassok, John, of Cranebroke, yeoman 0
3688134 1922441 1922441 plaintiff Courthop Alexander clothmaker 585864 585864 Courthop, Alexander, of Cranebroke, clothmaker 0
3688138 1922441 1922441 defendant Bysshopp Richard clothmaker 585864 585864 Bysshopp, Richard, of Cranebroke, clothmaker 3
3688923 1922696 1922696 plaintiff Draner Stephen yeoman 585864 585864 Draner, Stephen, of Cranebroke, yeoman 0
3691804 1923597 1923597 defendant Grene Agnes widow 585864 585864 Grene, Agnes, of Cranebroke, widow 2
3693197 1924083 1924083 defendant Stacye John weaver 585864 585864 Stacye, John, of Cranebroke, weaver 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);