names

310 rows where place_id = 587089

✎ 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
3590434 1864652 1864652 defendant Ryder John butcher 587089 587089 Ryder, John, of Burton on Trent, butcher 0
3590437 1864653 1864653 defendant Ryder John butcher 587089 587089 Ryder, John, of Burton on Trent, butcher 0
3603364 1868724 1868724 defendant Appulby John butcher 587089 587089 Appulby, John, of Burton on Trent, butcher 1
3605671 1869439 1869439 plaintiff Lambert Thomas (legal representative) 587089 587089 Lambert, Thomas, of Burton on Trent, barker, executors of 0
3609335 1870580 1870580 plaintiff Wylde Thomas (legal representative) 587089 587089 Wylde, Thomas, of Burton on Trent, merchant of the staple, executrix of 0
3609338 1870580 1870580 defendant Glassonbery Thomas   587089 587089 Glassonbery, Thomas, of Burton on Trent, surgeon 1
3617303 1873036 1873036 defendant Meyre Henry yeoman 587089 587089 Meyre, Henry, of Burton on Trent, yeoman 0
3617663 1873150 1873150 plaintiff Fydcoke John   587089 587089 Fydcoke, John, of Burton on Trent 0
3617664 1873150 1873150 defendant Meyr Henry yeoman 587089 587089 Meyr, Henry, of Burton on Trent, yeoman 0
3617665 1873150 1873150 defendant Knosale William yeoman 587089 587089 Knosale, William, of Burton on Trent, yeoman 1
3618141 1873298 1873298 defendant Hyde William, junior yeoman 587089 587089 Hyde, William, junior, of Burton on Trent, yeoman 1
3619250 1873623 1873623 defendant Lyng Thomas yeoman 587089 587089 Lyng, Thomas, of Burton on Trent, yeoman 0
3619251 1873623 1873623 defendant Aston John dyer 587089 587089 Aston, John, of Burton on Trent, dyer 1
3619252 1873623 1873623 defendant Barons John carver 587089 587089 Barons, John, of Burton on Trent, carver 2
3623556 1874896 1874896 defendant Barbour William, junior chapman 587089 587089 Barbour, William, junior, of Burton on Trent, chapman 3
3623904 1875005 1875005 defendant Power Robert glasier 587089 587089 Power, Robert, of Burton on Trent, glasier 0
3630151 1904277 1904277 defendant Potter Humphrey yeoman 587089 587089 Potter, Humphrey, of Burton on Trent, yeoman 0
3634558 1905612 1905612 plaintiff Midelton Robert (legal representative) 587089 587089 Midelton, Robert, of Burton on Trent, draper, executrix of 0
3660525 1913552 1913552 defendant Hunt Thomas painter 587089 587089 Hunt, Thomas, of Burton on Trent, painter 0
3660677 1913603 1913603 defendant Hunt Thomas painter 587089 587089 Hunt, Thomas, of Burton on Trent, painter 0
3672724 1917474 1917474 defendant Pemberton John, junior saddler 587089 587089 Pemberton, John, junior, of Burton on Trent, saddler 2
3672725 1917474 1917474 defendant Pemmerton John, senior saddler 587089 587089 Pemmerton, John, senior, of Burton on Trent, saddler 3
3691887 1923623 1923623 defendant Knesall William butcher 587089 587089 Knesall, William, of Burton on Trent, butcher 0
3691935 1923639 1923639 defendant Hunt Thomas painter 587089 587089 Hunt, Thomas, of Burton on Trent, painter 0
3701094 1926589 1926589 defendant Knesall William butcher 587089 587089 Knesall, William, of Burton on Trent, butcher 0
3701095 1926589 1926589 defendant Russell William butcher 587089 587089 Russell, William, of Burton on Trent, butcher 1
3708289 1928887 1928887 defendant Fysshwyke John draper 587089 587089 Fysshwyke, John, of Burton on Trent, draper 2
3712802 1930320 1930320 defendant Knyghtsall William butcher 587089 587089 Knyghtsall, William, of Burton on Trent, butcher 0
3715566 1931155 1931155 defendant Nevyle Robert, junior esq 587089 587089 Nevyle, Robert, junior, of Burton on Trent, esq 0
3717356 1931710 1931710 defendant Pemmerton John, junior saddler 587089 587089 Pemmerton, John, junior, of Burton on Trent, saddler 1
3721064 1932884 1932884 defendant Baker Richard butcher 587089 587089 Baker, Richard, of Burton on Trent, butcher 0
3721065 1932884 1932884 defendant Turnour Richard butcher 587089 587089 Turnour, Richard, of Burton on Trent, butcher 1
3727235 1934791 1934791 plaintiff Walker Richard carver 587089 587089 Walker, Richard, of Burton on Trent, carver 0
3735034 1937195 1937195 defendant Blount John tanner 587089 587089 Blount, John, of Burton on Trent, tanner 0
3748628 1941502 1941502 defendant Blount John tanner 587089 587089 Blount, John, of Burton on Trent, tanner 0
3755110 1943546 1943546 defendant Knesall William butcher 587089 587089 Knesall, William, of Burton on Trent, butcher 1
3757366 1944282 1944282 defendant Knesall William butcher 587089 587089 Knesall, William, of Burton on Trent, butcher 0
3763075 1946082 1946082 defendant Blount John tanner 587089 587089 Blount, John, of Burton on Trent, tanner 0
3779846 1951429 1951429 defendant Wylkynson Thomas butcher 587089 587089 Wylkynson, Thomas, of Burton on Trent, butcher 2
3781148 1951840 1951840 defendant Bradshawe John baker 587089 587089 Bradshawe, John, of Burton on Trent, baker 0
3782277 1952211 1952211 defendant Evesall William yeoman 587089 587089 Evesall, William, of Burton on Trent, yeoman 0
3790202 1954754 1954754 defendant Knesall William butcher 587089 587089 Knesall, William, of Burton on Trent, butcher 0
3791419 1955153 1955153 defendant Hole William smith 587089 587089 Hole, William, of Burton on Trent, smith 0
3792050 1955366 1955366 defendant Blount Walter gent 587089 587089 Blount, Walter, of Burton on Trent, gent 0
3793080 1955695 1955695 plaintiff Blount John (legal representative) 587089 587089 Blount, John, of Burton on Trent, executors of 0
3801665 1958416 1958416 defendant Knesall William butcher 587089 587089 Knesall, William, of Burton on Trent, butcher 0
3801666 1958416 1958416 defendant Knesall John butcher 587089 587089 Knesall, John, of Burton on Trent, butcher 1
3802369 1958640 1958640 defendant Heyward Thomas husbandman 587089 587089 Heyward, Thomas, of Burton on Trent, husbandman 0
3802372 1958641 1958641 defendant Heyward Thomas husbandman 587089 587089 Heyward, Thomas, of Burton on Trent, husbandman 0
3802592 1958704 1958704 defendant Knesall William butcher 587089 587089 Knesall, William, of Burton on Trent, butcher 0
3809859 1960972 1960972 plaintiff Blount John (legal representative) 587089 587089 Blount, John, of Burton on Trent, executors of 0
3816350 1963023 1963023 defendant Curson William gent 587089 587089 Curson, William, of Burton on Trent, gent 0
3851772 1974143 1974143 defendant Saunders William yeoman 587089 587089 Saunders, William, of Burton on Trent, yeoman 3
3856041 1975515 1975515 defendant Shingil Hames (legal representative) 587089 587089 Shingil, Hames, of Burton on Trent, executors of 0
3856044 1975516 1975516 defendant Shingill James (legal representative) 587089 587089 Shingill, James, of Burton on Trent, executors of 0
3856045 1975516 1975516 defendant Parker Richard   587089 587089 (Parker, Richard, of Burton on Trent, "allobbaster" 1
3856047 1975517 1975517 defendant Shingill James (legal representative) 587089 587089 Shingill, James, of Burton on Trent, executors of 0
3856048 1975517 1975517 defendant Parker Richard   587089 587089 (Parker, Richard, of Burton on Trent, "allobbaster" 1
3856050 1975518 1975518 defendant Shingill James (legal representative) 587089 587089 Shingill, James, of Burton on Trent, executors of 0
3856087 1975526 1975526 defendant Howden Robert husbandman 587089 587089 Howden, Robert, of Burton on Trent, husbandman 1
3861675 1977364 1977364 defendant Gybbons John fletcher 587089 587089 Gybbons, John, of Burton on Trent, fletcher 0
3875771 1982148 1982148 defendant Phellip Thomas glover 587089 587089 Phellip, Thomas, of Burton on Trent, glover 0
3880260 1983650 1983650 defendant Barlee Hugh yeoman 587089 587089 Barlee, Hugh, of Burton on Trent, yeoman 0
3884353 1985035 1985035 defendant Tonley or Touley John husbandman 587089 587089 Tonley or Touley, John, of Burton on Trent, husbandman 1
3905834 1992234 1992234 defendant Archard Thomas shoemaker 587089 587089 Archard, Thomas, of Burton on Trent, shoemaker 1
3926246 1999103 1999103 defendant Hylls William innholder 587089 587089 Hylls, William, of Burton on Trent, innholder 0
3935503 2002182 2002182 defendant Hyll Richard   587089 587089 Hyll, Richard, of Burton on Trent, inn holder 0
3937619 2002913 2002913 defendant Perker John smith 587089 587089 Perker, John, of Burton on Trent, smith 0
3968918 2013752 2013752 defendant Stockdayle John yeoman 587089 587089 Stockdayle, John, of Burton on Trent, yeoman 11
3968956 2013758 2013758 defendant Stockdale John yeoman 587089 587089 Stockdale, John, of Burton on Trent, yeoman 16
4047455 2041541 2041541 defendant Alcock Thomas tailor 587089 587089 Alcock, Thomas, of Burton on Trent, tailor 0
4047458 2041541 2041541 defendant Shepley Charles husbandman 587089 587089 Shepley, Charles, of Burton on Trent, husbandman 3
4047517 2041565 2041565 defendant Alcock Thomas tailor 587089 587089 Alcock, Thomas, of Burton on Trent, tailor 0
4047520 2041565 2041565 defendant Shapley Charles husbandman 587089 587089 Shapley, Charles, of Burton on trent, husbandman 3
4047572 2041580 2041580 defendant Chaplyn Robert yeoman 587089 587089 Chaplyn, Robert, of Burton on Trent, yeoman 0
4047574 2041581 2041581 defendant Chaplyn Robert yeoman 587089 587089 Chaplyn, Robert, of Burton on Trent, yeoman 0
4078417 2052576 2052576 defendant Blunt Edward gent 587089 587089 Blunt, Edward, of Burton on Trent, gent 0
4165354 2083390 2083390 defendant Fynnye John chapman 587089 587089 Fynnye, John, of Burton on trent, chapman 1
4181435 2088984 2088984 defendant Tyler William laborer 587089 587089 Tyler, William, of Burton on Trent, laborer 2
4192992 2093114 2093114 defendant Nevyll John esq 587089 587089 Nevyll, John, of Burton on Trent, esq 0
4200587 2095766 2095766 defendant Dreycote John esq 587089 587089 Dreycote, John, of Burton on Trent, esq 0
4207116 2098033 2098033 defendant Fowler Brian esq 587089 587089 Fowler, Brian, of Burton on Trent, esq 0
4220944 2102819 2102819 defendant Brudde Thomas tailor 587089 587089 Brudde, Thomas, of Burton on Trent, or of Braunson, tailor 1
4331168 2140721 2140721 defendant Smyth John yeoman 587089 587089 Smyth, John, of Burton on Trent, yeoman 0
4445679 2183604 2183604 defendant Abbas Thomas   587089 587089 Abbas, Thomas, of Burton on Trent 0
4456532 2187064 2187064 defendant Lyster Robert   587089 587089 Lyster, Robert, of Burton on Trent 0
4470322 2191366 2191366 plaintiff Brisitowe Margaret de   587089 587089 Brisitowe, Margaret de, of Burton on Trent 0
4470323 2191366 2191366 defendant Balyden John de   587089 587089 Balyden, John de, of Burton on Trent 0
4473190 2192278 2192278 defendant Hecher Richard de   587089 587089 Hecher, Richard de, of Burton on Trent 0
4477419 2193600 2193600 defendant Budworth John   587089 587089 Budworth, John, of Burton on Trent 7
4510647 2203787 2203787 plaintiff Barton John   587089 587089 Barton, John, of Burton on Trent 0
4510649 2203788 2203788 plaintiff Barton John   587089 587089 Barton, John, of Burton on Trent 0
4516858 2205677 2205677 defendant Parys John   587089 587089 Parys, John, of Burton on Trent 0
4517221 2205786 2205786 plaintiff Creghton Roger de   587089 587089 Creghton, Roger de, of Burton on Trent 0
4517704 2205928 2205928 plaintiff Dale William   587089 587089 Dale, William, of Burton on Trent 0
4517706 2205929 2205929 plaintiff Dale William   587089 587089 Dale, William, of Burton on Trent 0
4518990 2206296 2206296 plaintiff Drue Walter   587089 587089 Drue, Walter, of Burton on Trent 0
4522030 2207231 2207231 defendant Leke William skinner 587089 587089 Leke, William, of Burton on Trent, skinner 0
4525015 2208165 2208165 defendant Skynner William   587089 587089 Skynner, William, of Burton on Trent 0
4527975 2209030 2209030 plaintiff Lyng Henry   587089 587089 Lyng, Henry, of Burton on Trent 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);