names

940 rows where place_id = 586079

✎ 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
3587880 1863860 1863860 defendant Bures William esq 586079 586079 Bures, William, of Bedford, esq 0
3588790 1864138 1864138 defendant Payn Philip dyer or chapman 586079 586079 Payn, Philip, of Bedford, dyer or chapman 0
3588792 1864139 1864139 defendant Payn Philip dyer or chapman 586079 586079 Payn, Philip, of Bedford, dyer or chapman 0
3590415 1864645 1864645 defendant Cobyn or Covyn John husbandman 586079 586079 Cobyn or Covyn, John, of Bedford, husbandman 1
3590419 1864646 1864646 defendant Colyn John husbandman 586079 586079 Colyn, John, of Bedford, husbandman 1
3593302 1865536 1865536 defendant Gardener William chapman 586079 586079 Gardener, William, of Bedford, chapman 1
3593719 1865675 1865675 defendant Lucas Peter pardoner 586079 586079 Lucas, Peter, of Bedford, pardoner 1
3594027 1865772 1865772 defendant Lambe William yeoman 586079 586079 Lambe, William, of Bedford, yeoman 0
3594942 1866047 1866047 plaintiff Longe William (legal representative) 586079 586079 Longe, William, of Bedford, draper, executors of 0
3601977 1868276 1868276 defendant Doweson Hugh draper 586079 586079 Doweson, Hugh, of Bedford, draper 0
3604386 1869038 1869038 defendant Avewe Margaret widow 586079 586079 Avewe, Margaret, of Bedford, widow 1
3604391 1869039 1869039 defendant Avewe Margaret widow 586079 586079 Avewe, Margaret, of Bedford, widow 3
3604396 1869040 1869040 defendant Avewe Margaret widow 586079 586079 Avewe, Margaret, of Bedford, widow 3
3607855 1870107 1870107 defendant Parson William innholder 586079 586079 Parson, William, of Bedford, innholder 0
3607856 1870107 1870107 defendant Fynoll Robert husbandman 586079 586079 Fynoll, Robert, of Bedford, husbandman 1
3611233 1871189 1871189 defendant Turnour William laborer 586079 586079 Turnour, William, of Bedford, laborer 0
3612955 1871698 1871698 defendant Bulmere John yeoman 586079 586079 Bulmere, John, of Bedford, yeoman 0
3614580 1872210 1872210 defendant Persons William yeoman 586079 586079 Persons, William, of Bedford, yeoman 0
3614581 1872210 1872210 defendant Chapman Richard yeoman 586079 586079 Chapman, Richard, of Bedford, yeoman 1
3614582 1872210 1872210 defendant Couper William grocer 586079 586079 Couper, William, of Bedford, grocer 2
3615297 1872429 1872429 defendant (not given) James rector of Barlawe 586079 586079 Barlawe, James, of Bedford, rector of Hateleport 0
3615299 1872430 1872430 defendant (not given) James rector of Barlowe 586079 586079 Barlowe, James, of Bedford, rector of Hatelepott 0
3615301 1872431 1872431 defendant (not given) James rector of Barlowe 586079 586079 Barlowe, James, of Bedford, rector of Hatteleport 0
3616399 1872768 1872768 plaintiff Derlyng William (legal representative) 586079 586079 Derlyng, William, of Bedford, executors of 0
3616404 1872768 1872768 defendant May Thomas fishmonger 586079 586079 May, Thomas, of Bedford, fishmonger 0
3617366 1873051 1873051 defendant Underwod Thomas woolman 586079 586079 Underwod, Thomas, of Bedford, woolman 0
3617372 1873053 1873053 defendant Underwod Thomas woolman 586079 586079 Underwod, Thomas, of Bedford, woolman 0
3618298 1873352 1873352 defendant Gold Roger brasier 586079 586079 Gold, Roger, of Bedford, brasier 0
3619123 1873584 1873584 defendant Water Robert husbandman 586079 586079 Water, Robert, of Bedford, husbandman 0
3619125 1873585 1873585 defendant Water Robert husbandman 586079 586079 Water, Robert, of Bedford, husbandman 0
3619261 1873627 1873627 defendant May Thomas fishmonger 586079 586079 May, Thomas, of Bedford, fishmonger 0
3620174 1873887 1873887 defendant Burghbrigge John (legal representative) 586079 586079 Burghbrigge, John, of Bedford, executrix of 0
3620175 1873887 1873887 defendant Burghbrigge Elizabeth widow 586079 586079 Burghbrigge, Elizabeth, of Bedford, widow 1
3621857 1874377 1874377 defendant May Thomas fishmonger 586079 586079 (May, Thomas, of Bedford, fishmonger 1
3624435 1875177 1875177 defendant May Thomas dyer 586079 586079 May, Thomas, of Bedford, dyer 0
3639212 1907077 1907077 defendant Tayllour John chapman 586079 586079 Tayllour, John, of Bedford, chapman 3
3645147 1908890 1908890 defendant Barleman Thomas, senior roper 586079 586079 Barleman, Thomas, senior, of Bedford, roper 0
3645154 1908892 1908892 defendant Barleman Thomas, senior roper 586079 586079 Barleman, Thomas, senior, of Bedford, roper 0
3646500 1909303 1909303 defendant Tether Nicholas innholder 586079 586079 Tether, Nicholas, of Bedford, innholder 0
3656670 1912337 1912337 defendant Grey John baker 586079 586079 Grey, John, of Bedford, baker 0
3659842 1913333 1913333 plaintiff Halam Richard master & scrivener 586079 586079 Halam, Richard, of Bedford, master & scrivener 0
3668913 1916210 1916210 defendant Bussheby Henry mercer 586079 586079 Bussheby, Henry, of Bedford, mercer 0
3674033 1917919 1917919 defendant West John yeoman 586079 586079 West, John, of Bedford, yeoman 0
3674034 1917919 1917919 defendant Kyng William yeoman 586079 586079 Kyng, William, of Bedford, yeoman 1
3678115 1919206 1919206 defendant Erby John yeoman 586079 586079 Erby, John, of Bedford, yeoman 0
3684640 1921329 1921329 defendant Erby John yeoman 586079 586079 Erby, John, of Bedford, yeoman 0
3685969 1921769 1921769 defendant Dawes John carpenter 586079 586079 Dawes, John, of Bedford, carpenter 1
3687346 1922221 1922221 defendant Stukeley Robert gent 586079 586079 Stukeley, Robert, of Bedford, gent 0
3688439 1922540 1922540 defendant Comendale Richard dyer 586079 586079 Comendale, Richard, of Bedford, dyer 1
3688613 1922596 1922596 defendant Massam John tailor 586079 586079 Massam, John, of Bedford, tailor 1
3699848 1926178 1926178 defendant Erby John yeoman 586079 586079 Erby, John, of Bedford, yeoman 0
3721322 1932975 1932975 defendant Grey Reginald esq 586079 586079 Grey, Reginald, of Bedford, esq 0
3721742 1933077 1933077 defendant Sale Henry yeoman 586079 586079 Sale, Henry, of Bedford, yeoman 0
3734352 1936982 1936982 defendant Kyng William yeoman 586079 586079 Kyng, William, of Bedford, yeoman 0
3734353 1936982 1936982 defendant Massam John draper 586079 586079 Massam, John, of Bedford, draper 1
3734355 1936983 1936983 defendant Macke Peter yeoman 586079 586079 Macke, Peter, of Bedford, yeoman 0
3734356 1936983 1936983 defendant Masham John draper 586079 586079 Masham, John, of Bedford, draper 1
3734357 1936983 1936983 defendant Irsby John yeoman 586079 586079 Irsby, John, of Bedford, yeoman 2
3737102 1937844 1937844 defendant West Richard yeoman 586079 586079 West, Richard, of Bedford, yeoman 0
3737103 1937844 1937844 defendant Stewkeley Robert gent 586079 586079 Stewkeley, Robert, of Bedford, gent 1
3737115 1937846 1937846 defendant Stewkeley Robert gent 586079 586079 Stewkeley, Robert, of Bedford, gent 1
3737120 1937847 1937847 defendant Macke Peter yeoman 586079 586079 Macke, Peter, of Bedford, yeoman 0
3737121 1937847 1937847 defendant Huckesley William baker 586079 586079 Huckesley, William, of Bedford, baker 1
3737122 1937847 1937847 defendant Erby John yeoman 586079 586079 Erby, John, of Bedford, yeoman 2
3745674 1940555 1940555 defendant Dawys John carpenter 586079 586079 Dawys, John, of Bedford, carpenter 0
3745982 1940648 1940648 defendant Cokke William yeoman 586079 586079 Cokke, William, of Bedford, yeoman 0
3752678 1942766 1942766 defendant Heche Thomas pewterer 586079 586079 Heche, Thomas, of Bedford, pewterer 0
3752693 1942771 1942771 defendant Halom Richard   586079 586079 Halom, Richard, of Bedford, notary 0
3758535 1944667 1944667 defendant Grey Reginald gent 586079 586079 Grey, Reginald, of Bedford, gent 0
3758537 1944668 1944668 defendant Grey Reginald gent 586079 586079 Grey, Reginald, of Bedford, gent 0
3764489 1946556 1946556 defendant Rowthe Thomas chaplain 586079 586079 Rowthe, Thomas, of Bedford, chaplain 0
3769730 1948187 1948187 defendant Kyng William yeoman 586079 586079 Kyng, William, of Bedford, yeoman 1
3769732 1948187 1948187 defendant Makke Peter yeoman 586079 586079 Makke, Peter, of Bedford, yeoman 3
3771736 1948863 1948863 defendant Couper Thomas cooper 586079 586079 Couper, Thomas, of Bedford, cooper 0
3776633 1950437 1950437 defendant Grey Reginald gent 586079 586079 Grey, Reginald, of Bedford, gent 0
3786831 1953679 1953679 defendant Macke Peter yeoman 586079 586079 Macke, Peter, of Bedford, yeoman 0
3786832 1953679 1953679 defendant Massam John draper 586079 586079 Massam, John, of Bedford, draper 1
3787217 1953795 1953795 defendant Halam Richard beer brewer 586079 586079 Halam, Richard, of Bedford, beer brewer 0
3788324 1954147 1954147 plaintiff Smyth Robert yeoman 586079 586079 Smyth, Robert, of Bedford, yeoman 0
3794100 1956021 1956021 defendant Grey Reginald gent 586079 586079 Grey, Reginald, of Bedford, gent 0
3799104 1957629 1957629 defendant Roothe Thomas chapman 586079 586079 Roothe, Thomas, of Bedford, chapman 0
3799130 1957637 1957637 defendant Roothe Thomas chapman 586079 586079 Roothe, Thomas, of Bedford, chapman 0
3803201 1958903 1958903 defendant Dangerfeld Richard husbandman 586079 586079 Dangerfeld, Richard, of Bedford, husbandman 0
3803203 1958904 1958904 defendant Dangerfeld Richard husbandman 586079 586079 Dangerfeld, Richard, of Bedford, husbandman 0
3803208 1958906 1958906 defendant Dangerfeld Richard husbandman 586079 586079 Dangerfeld, Richard, of Bedford, husbandman 0
3804627 1959388 1959388 defendant Massam John draper 586079 586079 Massam, John, of Bedford, draper 0
3804628 1959388 1959388 defendant Irby John yeoman 586079 586079 Irby, John, of Bedford, yeoman 1
3807342 1960199 1960199 defendant Thomas William butcher 586079 586079 Thomas, William, of Bedford, butcher 0
3808657 1960588 1960588 defendant Hatfeld Richard chapman 586079 586079 Hatfeld, Richard, of Bedford, chapman 0
3813491 1962134 1962134 defendant Negose John husbandman 586079 586079 Negose, John, of Bedford, husbandman 1
3813827 1962237 1962237 defendant Rowthe Thomas mercer 586079 586079 Rowthe, Thomas, of Bedford, mercer 1
3814492 1962446 1962446 defendant Manfeld John yeoman 586079 586079 Manfeld, John, of Bedford, yeoman 5
3816627 1963101 1963101 defendant Roothe alias Roothyt Thomas chapman 586079 586079 Roothe alias Roothyt, Thomas, of Bedford, chapman 0
3819428 1963962 1963962 defendant Goodwyn John butcher 586079 586079 Goodwyn, John, of Bedford, butcher 0
3824333 1965482 1965482 defendant Manfeld Henry wheeler 586079 586079 Manfeld, Henry, of Bedford, wheeler 0
3825713 1965894 1965894 defendant Caren David yeoman 586079 586079 Caren, David, of Bedford, yeoman 4
3840766 1970678 1970678 defendant Knyght Richard smith 586079 586079 Knyght, Richard, of Bedford, smith 1
3846022 1972315 1972315 defendant Carre Peter saddler 586079 586079 Carre, Peter, of Bedford, saddler 0
3846024 1972315 1972315 defendant Ledes Robert baker 586079 586079 Ledes, Robert, of Bedford, baker 2
3846025 1972315 1972315 defendant Warner John shoemaker 586079 586079 Warner, John, of Bedford, shoemaker 3

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