names

197 rows where place_id = 586406

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588644 1864090 1864090 defendant Ryngbell Thomas husbandman 586406 586406 Ryngbell, Thomas, of Hopton, husbandman 2
3589399 1864324 1864324 defendant Bee John husbandman 586406 586406 Bee, John, of Hopton, husbandman 1
3601152 1868024 1868024 defendant Well Richard husbandman 586406 586406 Well, Richard, of Hopton, husbandman 1
3626075 1903014 1903014 defendant Prest Robert husbandman 586406 586406 Prest, Robert, of Hopton, husbandman 0
3638905 1906993 1906993 defendant Geell John yeoman 586406 586406 Geell, John, of Hopton, yeoman 0
3638907 1906994 1906994 defendant Geell John yeoman 586406 586406 Geell, John, of Hopton, yeoman 0
3638908 1906994 1906994 defendant Geell Ralph   586406 586406 Geell, Ralph, of Hopton, single man 1
3638910 1906995 1906995 defendant Geell Ralph singleman 586406 586406 Geell, Ralph, of Hopton, singleman 0
3643558 1908416 1908416 defendant Salman John husbandman 586406 586406 Salman, John, of Hopton, husbandman 1
3678555 1919350 1919350 defendant Rydge Thomas tailor 586406 586406 Rydge, Thomas, of Hopton, tailor 4
3683163 1920851 1920851 defendant Polle Stephen yeoman 586406 586406 Polle, Stephen, of Hopton, yeoman 1
3686453 1921916 1921916 defendant Henne Agnes widow 586406 586406 Henne, Agnes, of Hopton, widow 5
3700400 1926360 1926360 defendant Fox William yeoman 586406 586406 Fox, William, of Hopton, yeoman 0
3719211 1932294 1932294 defendant Prest Robert husbandman 586406 586406 Prest, Robert, of Hopton, husbandman 3
3732319 1936347 1936347 defendant Bebbe alias at Heth Richard yeoman 586406 586406 Bebbe alias at Heth, Richard, of Hopton, yeoman 0
3735007 1937185 1937185 defendant Prest Robert husbandman 586406 586406 Prest, Robert, of Hopton, husbandman 0
3736599 1937699 1937699 defendant Lynde William yeoman 586406 586406 Lynde, William, of Hopton, yeoman 0
3736600 1937699 1937699 defendant Wayte William husbandman 586406 586406 Wayte, William, of Hopton, husbandman 1
3745134 1940384 1940384 defendant Prest Robert husbandman 586406 586406 Prest, Robert, of Hopton, husbandman 2
3749828 1941858 1941858 defendant Prast Robert husbandman 586406 586406 Prast, Robert, of Hopton, husbandman 0
3757370 1944284 1944284 defendant Boys Thomas husbandman 586406 586406 Boys, Thomas, of Hopton, husbandman 0
3758103 1944520 1944520 defendant Lynde William yeoman 586406 586406 Lynde, William, of Hopton, yeoman 0
3761440 1945592 1945592 defendant Prast Robert husbandman 586406 586406 Prast, Robert, of Hopton, husbandman 0
3765292 1946809 1946809 defendant Caldwell Robert husbandman 586406 586406 Caldwell, Robert, of Hopton, husbandman 2
3765294 1946809 1946809 defendant Roberdson William husbandman 586406 586406 Roberdson, William, of Hopton, husbandman 4
3775763 1950171 1950171 defendant Prest Robert husbandman 586406 586406 Prest, Robert, of Hopton, husbandman 0
3783117 1952476 1952476 defendant Martyn Thomas husbandman 586406 586406 Martyn, Thomas, of Hopton, husbandman 1
3787778 1953966 1953966 defendant Ederych Peter husbandman 586406 586406 Ederych, Peter, of Hopton, husbandman 6
3793312 1955767 1955767 defendant Hoott John husbandman 586406 586406 Hoott, John, of Hopton, husbandman 1
3797702 1957178 1957178 defendant Stevynson Thomas husbandman 586406 586406 Stevynson, Thomas, of Hopton, husbandman 4
3799517 1957767 1957767 defendant Prest Henry husbandman 586406 586406 Prest, Henry, of Hopton, husbandman 2
3799518 1957767 1957767 defendant Prest Robert husbandman 586406 586406 Prest, Robert, of Hopton, husbandman 3
3814851 1962560 1962560 plaintiff Gower John   586406 586406 Gower, John, of Hopton 0
3822172 1964832 1964832 defendant Rede William tanner 586406 586406 Rede, William, of Hopton, tanner 2
3827365 1966423 1966423 defendant Prast Henry husbandman 586406 586406 Prast, Henry, of Hopton, husbandman 1
3827366 1966423 1966423 defendant Prast Robert husbandman 586406 586406 Prast, Robert, of Hopton, husbandman 2
3831105 1967613 1967613 defendant Angold Edmund husbandman 586406 586406 Angold, Edmund, of Hopton, husbandman 2
3831106 1967613 1967613 defendant Gylson Peter   586406 586406 Gylson, Peter, of Hopton, paten maker 3
3832551 1968101 1968101 defendant Prest John husbandman 586406 586406 Prest, John, of Hopton, husbandman 0
3836349 1969276 1969276 plaintiff Rede William tanner 586406 586406 Rede, William, of Hopton, tanner 0
3839329 1970227 1970227 defendant Hopton Richard gent 586406 586406 Hopton, Richard, of Hopton, gent 2
3846180 1972361 1972361 defendant Eyton Elizabeth widow 586406 586406 Eyton, Elizabeth, of Hopton, widow 0
3846181 1972361 1972361 defendant Eyton Ralph husbandman 586406 586406 Eyton, Ralph, of Hopton, husbandman 1
3846188 1972363 1972363 plaintiff Gelle Ralph   586406 586406 Gelle, Ralph, of Hopton 0
3847418 1972755 1972755 defendant Cok Edmund laborer 586406 586406 Cok, Edmund, of Hopton, laborer 1
3861815 1977413 1977413 plaintiff Gell Ralph   586406 586406 Gell, Ralph, of Hopton 0
3861821 1977414 1977414 plaintiff Gell Ralph   586406 586406 Gell, Ralph, of Hopton 0
3861825 1977415 1977415 plaintiff Gell Ralph   586406 586406 Gell, Ralph, of Hopton 0
3875905 1982195 1982195 plaintiff Gell Ralph gent 586406 586406 Gell, Ralph, of Hopton, gent 0
3888419 1986389 1986389 defendant Taylour Ralph shoemaker 586406 586406 Taylour, Ralph, of Hopton, shoemaker 0
3903455 1991382 1991382 plaintiff Gell Ralph gent 586406 586406 Gell, Ralph, of Hopton, gent 0
3905314 1992045 1992045 defendant Harvy Thomas husbandman 586406 586406 Harvy, Thomas, of Hopton, husbandman 1
3914634 1995237 1995237 defendant Rede William tanner 586406 586406 Rede, William, of Hopton, tanner 0
3914635 1995237 1995237 defendant Gylle Robert husbandman 586406 586406 Gylle, Robert, of Hopton, husbandman 1
3923462 1998154 1998154 defendant Reynold Henry husbandman 586406 586406 Reynold, Henry, of Hopton, husbandman 0
3923464 1998155 1998155 defendant Wylden alias Wyly Thomas smith 586406 586406 Wylden alias Wyly, Thomas, of Hopton, smith 0
3928485 1999866 1999866 defendant Barnebye William husbandman 586406 586406 Barnebye, William, of Hopton, husbandman 0
3937381 2002840 2002840 defendant Turnour Peter beer brewer 586406 586406 Turnour, Peter, of Hopton, beer brewer 1
3938966 2003365 2003365 defendant Fassett Richard husbandman 586406 586406 Fassett, Richard, of Hopton, husbandman 1
3941583 2004198 2004198 defendant Hopton William gent 586406 586406 Hopton, William, of Hopton, gent 0
3946836 2005962 2005962 plaintiff Cawdell John   586406 586406 Cawdell, John, of Hopton 0
3946838 2005963 2005963 plaintiff Cawdell John   586406 586406 Cawdell, John, of Hopton 0
3950719 2007325 2007325 plaintiff Gell Ralph gent 586406 586406 Gell, Ralph, of Hopton, gent 0
3953553 2008314 2008314 defendant Neewham Robert husbandman 586406 586406 Neewham, Robert, of Hopton, or of Holmehale, husbandman 0
3955048 2008830 2008830 defendant Bennett Edward gent 586406 586406 Bennett, Edward, of Hopton, gent 2
3966183 2012802 2012802 defendant Lynsey Robert shoemaker 586406 586406 Lynsey, Robert, of Hopton, shoemaker 0
3970129 2014153 2014153 defendant Buckley Henry yeoman 586406 586406 Buckley, Henry, of Hopton, yeoman 0
3997241 2023783 2023783 defendant Boyse John yeoman 586406 586406 Boyse, John, of Hopton, yeoman 0
4011313 2028822 2028822 defendant Borowes William husbandman 586406 586406 Borowes, William, of Hopton, husbandman 0
4047393 2041524 2041524 defendant Boyse Anthony   586406 586406 Boyse, Anthony, of Hopton, husbandman, his son 1
4055145 2044233 2044233 defendant Hyde Richard gent 586406 586406 Hyde, Richard, of Hopton, gent 2
4057560 2045082 2045082 defendant Herne Peter yeoman 586406 586406 Herne, Peter, of Hopton, yeoman 0
4058225 2045325 2045325 defendant Knight John husbandman 586406 586406 Knight, John, of Hopton, husbandman 0
4058227 2045326 2045326 defendant Spurgion Richard husbandman 586406 586406 Spurgion, Richard, of Hopton, husbandman 0
4058228 2045326 2045326 defendant Knight John husbandman 586406 586406 Knight, John, of Hopton, husbandman 1
4058229 2045326 2045326 defendant Cock Robert husbandman 586406 586406 Cock, Robert, of Hopton, husbandman 2
4071338 2050048 2050048 defendant Henne James husbandman 586406 586406 Henne, James, of Hopton, husbandman 5
4079768 2053063 2053063 defendant Churche Thomas yeoman 586406 586406 Churche, Thomas, of Hopton, yeoman 0
4128304 2070406 2070406 defendant Clark Edmund husbandman 586406 586406 Clark, Edmund, of Hopton, husbandman 0
4128408 2070451 2070451 defendant Londe William yeoman 586406 586406 Londe, William, of Hopton, yeoman 3
4148582 2077630 2077630 defendant Alsoppe Lawrence yeoman 586406 586406 Alsoppe, Lawrence, of Hopton, yeoman 0
4149587 2077980 2077980 defendant Alsoppe Lawrence yeoman 586406 586406 Alsoppe, Lawrence, of Hopton, yeoman 1
4171644 2085547 2085547 defendant Londe William husbandman 586406 586406 Londe, William, of Hopton, husbandman 1
4171645 2085547 2085547 defendant Master Robert husbandman 586406 586406 Master, Robert, of Hopton, husbandman 2
4183138 2089584 2089584 defendant Bennett Edward gent 586406 586406 Bennett, Edward, of Hopton, or of Haggarnell, gent 2
4213889 2100378 2100378 defendant Steple Roland miner 586406 586406 Steple, Roland, of Hopton, miner 2
4231972 2106682 2106682 defendant Foxe Edward yeoman 586406 586406 Foxe, Edward, of Hopton, yeoman 0
4237071 2108547 2108547 defendant Wyman William husbandman 586406 586406 Wyman, William, of Hopton, husbandman 1
4258035 2115658 2115658 defendant Ledgerd Robert yeoman 586406 586406 Ledgerd, Robert, of Hopton, yeoman 1
4270109 2119587 2119587 defendant Ledgerd Robert yeoman 586406 586406 Ledgerd, Robert, of Hopton, yeoman 1
4298544 2129582 2129582 defendant Berte Robert yeoman 586406 586406 Berte, Robert, of Hopton, yeoman 0
4299339 2129856 2129856 defendant Alsope Lawrence gent 586406 586406 Alsope, Lawrence, of Hopton, or of Chesterfeld, gent 0
4315245 2135449 2135449 defendant Wyman William husbandman 586406 586406 Wyman, William, of Hopton, husbandman 0
4328644 2139894 2139894 defendant Bennett George gent 586406 586406 Bennett, George, of Hopton, gent 2
4331770 2140920 2140920 defendant Berte Robert yeoman 586406 586406 Berte, Robert, of Hopton, yeoman 0
4332713 2141225 2141225 defendant Lownds Thomas husbandman 586406 586406 Lownds, Thomas, of Hopton, husbandman 2
4337220 2142747 2142747 defendant Rygby Arthur yeoman 586406 586406 Rygby, Arthur, of Hopton, yeoman 1
4351984 2147929 2147929 defendant Clatworthy Thomas yeoman 586406 586406 Clatworthy, Thomas, of Hopton, yeoman 1
4408904 2167578 2167578 defendant Baggett William husbandman 586406 586406 Baggett, William, of Hopton, husbandman 0
4408905 2167578 2167578 defendant Crispe Edmund gent 586406 586406 Crispe, Edmund, of Hopton, gent 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);