names

506 rows where place_id = 587331

✎ 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
3591108 1864842 1864842 defendant Soule or Sonle John yeoman 587331 587331 Soule or Sonle, John, of Causton, yeoman 0
3596979 1866682 1866682 defendant Gryme William yeoman 587331 587331 Gryme, William, of Causton, yeoman 0
3596980 1866682 1866682 defendant Skeny or Skevy John husbandman 587331 587331 Skeny or Skevy, John, of Causton, husbandman 1
3599932 1867634 1867634 defendant Herward Bartholomew husbandman 587331 587331 Herward, Bartholomew, of Causton, husbandman 0
3603430 1868740 1868740 plaintiff Denne William gent 587331 587331 Denne, William, of Causton, gent 0
3603431 1868740 1868740 defendant Soule John yeoman 587331 587331 Soule, John, of Causton, yeoman 0
3616369 1872759 1872759 plaintiff Denne William   587331 587331 Denne, William, of Causton 0
3616686 1872848 1872848 defendant Purry William husbandman 587331 587331 Purry, William, of Causton, husbandman 0
3621227 1874180 1874180 defendant Glover Robert husbandman 587331 587331 Glover, Robert, of Causton, husbandman 2
3625756 1875594 1875594 defendant Galt James husbandman 587331 587331 Galt, James, of Causton, husbandman 0
3633425 1905268 1905268 defendant Dawys Thomas butcher 587331 587331 Dawys, Thomas, of Causton, butcher 2
3635229 1905809 1905809 defendant Browne Thomas yeoman 587331 587331 Browne, Thomas, of Causton, yeoman 1
3635230 1905809 1905809 defendant Dawes Thomas yeoman 587331 587331 Dawes, Thomas, of Causton, yeoman 2
3638833 1906968 1906968 plaintiff Valenger Stephen (legal representative) 587331 587331 Valenger, Stephen, of Causton, executors of 0
3648277 1909862 1909862 defendant Rypplyngham Richard gent 587331 587331 Rypplyngham, Richard, of Causton, gent 0
3648611 1909953 1909953 defendant York Richard husbandman 587331 587331 York, Richard, of Causton, husbandman 2
3650185 1910427 1910427 defendant Lumney Robert yeoman 587331 587331 (Lumney, Robert, of Causton, yeoman 2
3667902 1915901 1915901 defendant Brett Thomas husbandman 587331 587331 Brett, Thomas, of Causton, husbandman 0
3672602 1917428 1917428 defendant Some Robert laborer 587331 587331 Some, Robert, of Causton, laborer 2
3673580 1917765 1917765 defendant Legge John (legal representative) 587331 587331 Legge, John, of Causton, gent, administratrix of 0
3673581 1917765 1917765 defendant Legge Elizabeth widow 587331 587331 Legge, Elizabeth, of Causton, widow 1
3673586 1917767 1917767 defendant Replyngham Richard gent 587331 587331 Replyngham, Richard, of Causton, gent 0
3680718 1920050 1920050 defendant Goldell Thomas shoemaker 587331 587331 Goldell, Thomas, of Causton, shoemaker 3
3680723 1920051 1920051 defendant Goldell Thomas shoemaker 587331 587331 Goldell, Thomas, of Causton, shoemaker 2
3684605 1921317 1921317 defendant Pygot Fulk yeoman 587331 587331 Pygot, Fulk, of Causton, yeoman 0
3686931 1922079 1922079 defendant Grene Robert husbandman 587331 587331 Grene, Robert, of Causton, husbandman 0
3692251 1923746 1923746 defendant Kent John   587331 587331 Kent, John, of Causton, worsted weaver 0
3692280 1923755 1923755 defendant Kent John   587331 587331 Kent, John, of Causton, worsted weaver 0
3697893 1925563 1925563 defendant Hovell Richard yeoman 587331 587331 Hovell, Richard, of Causton, yeoman 3
3700766 1926492 1926492 defendant Pygotte Fulk yeoman 587331 587331 Pygotte, Fulk, of Causton, yeoman 0
3703516 1927373 1927373 defendant Thrower Henry butcher 587331 587331 Thrower, Henry, of Causton, butcher 0
3707347 1928588 1928588 defendant Sussen or Suffen Thomas   587331 587331 Sussen or Suffen, Thomas, of Causton, worsted weaver 1
3718939 1932204 1932204 defendant Weyg John husbandman 587331 587331 Weyg, John, of Causton, husbandman 1
3726617 1934584 1934584 defendant Aggys John husbandman 587331 587331 Aggys, John, of Causton, husbandman 3
3726634 1934589 1934589 defendant Goodwyn Thomas warrener 587331 587331 Goodwyn, Thomas, of Causton, warrener 0
3734275 1936958 1936958 defendant Harvy Edmund husbandman 587331 587331 Harvy, Edmund, of Causton, husbandman 3
3742205 1939431 1939431 defendant Cretyng John yeoman 587331 587331 Cretyng, John, of Causton, yeoman 0
3742206 1939431 1939431 defendant Bellyngay Gilbert husbandman 587331 587331 Bellyngay, Gilbert, of Causton, husbandman 1
3742207 1939431 1939431 defendant Smyth William husbandman 587331 587331 Smyth, William, of Causton, husbandman 2
3742642 1939568 1939568 defendant Harryson John baker 587331 587331 Harryson, John, of Causton, baker 1
3748040 1941308 1941308 defendant Lombe Simon husbandman 587331 587331 Lombe, Simon, of Causton, husbandman 0
3751032 1942256 1942256 plaintiff Mone Clement   587331 587331 Mone, Clement, of Causton 0
3754245 1943279 1943279 defendant Kent John husbandman 587331 587331 Kent, John, of Causton, husbandman 0
3762026 1945769 1945769 defendant Lombe Simon husbandman 587331 587331 Lombe, Simon, of Causton, husbandman 0
3763880 1946345 1946345 defendant Aggys John husbandman 587331 587331 Aggys, John, of Causton, husbandman 2
3764338 1946509 1946509 defendant Bourger Simon husbandman 587331 587331 Bourger, Simon, of Causton, husbandman 0
3768266 1947715 1947715 defendant Harvy Edmund woolman 587331 587331 Harvy, Edmund, of Causton, woolman 0
3789580 1954569 1954569 defendant Aggys John husbandman 587331 587331 Aggys, John, of Causton, husbandman 0
3805723 1959735 1959735 defendant Goodwyn Thomas warrener 587331 587331 Goodwyn, Thomas, of Causton, warrener 0
3836761 1969396 1969396 defendant Randall William   587331 587331 Randall, William, of Causton, worsted weaver 2
3838900 1970092 1970092 defendant Brom Robert husbandman 587331 587331 Brom, Robert, of Causton, husbandman 0
3847900 1972918 1972918 defendant Umfrey John laborer 587331 587331 Umfrey, John, of Causton, laborer 3
3856279 1975583 1975583 defendant Lome John smith 587331 587331 Lome, John, of Causton, smith 1
3867181 1979260 1979260 defendant Randell William   587331 587331 Randell, William, of Causton, worsted weaver 1
3869061 1979897 1979897 defendant Umfrey John laborer 587331 587331 Umfrey, John, of Causton, laborer 3
3869749 1980122 1980122 defendant Harpour Robert husbandman 587331 587331 Harpour, Robert, of Causton, husbandman 0
3899638 1990098 1990098 defendant Borage Richard   587331 587331 Borage, Richard, of Causton, shepherd 0
3899639 1990098 1990098 defendant Larwood Richard butcher 587331 587331 Larwood, Richard, of Causton, butcher 1
3899642 1990098 1990098 defendant Palmer John   587331 587331 Palmer, John, of Causton, worsted weaver 4
3899643 1990098 1990098 defendant Eston Thomas   587331 587331 Eston, Thomas, of Causton, worsted weaver 5
3899649 1990101 1990101 defendant Pakeman Nicholas husbandman 587331 587331 Pakeman, Nicholas, of Causton, husbandman 0
3903443 1991377 1991377 defendant Plarner alias Potter Robert husbandman 587331 587331 Plarner alias Potter, Robert, of Causton, husbandman 4
3904244 1991664 1991664 defendant Davyll Robert miller 587331 587331 Davyll, Robert, of Causton, miller 3
3908224 1993049 1993049 defendant Larke John tailor 587331 587331 Larke, John, of Causton, tailor 0
3908440 1993118 1993118 defendant Walker John butcher 587331 587331 Walker, John, of Causton, butcher 0
3920912 1997339 1997339 defendant Fuller Ralph butcher 587331 587331 Fuller, Ralph, of Causton, butcher 0
3920914 1997340 1997340 defendant Fuller Ralph butcher 587331 587331 Fuller, Ralph, of Causton, butcher 0
3924041 1998350 1998350 defendant Abbys Thomas merchant 587331 587331 Abbys, Thomas, of Causton, merchant 0
3924217 1998409 1998409 defendant Sawer alias Harvy Edmund baker 587331 587331 Sawer alias Harvy, Edmund, of Causton, baker 0
3924218 1998409 1998409 defendant Browne Robert mercer 587331 587331 Browne, Robert, of Causton, mercer 1
3924604 1998544 1998544 defendant Albys Thomas merchant 587331 587331 Albys, Thomas, of Causton, merchant 0
3928779 1999960 1999960 defendant Wolby Martin   587331 587331 Wolby, Martin, of Causton, shoe maker 0
3932592 2001192 2001192 defendant Bulman Edmund weaver 587331 587331 Bulman, Edmund, of Causton, weaver 0
3933120 2001369 2001369 defendant Fuller Ralph butcher 587331 587331 Fuller, Ralph, of Causton, butcher 0
3933121 2001369 2001369 defendant Rent Robert husbandman 587331 587331 Rent, Robert, of Causton, husbandman 1
3933122 2001369 2001369 defendant Bulman Edmuns husbandman 587331 587331 Bulman, Edmuns, of Causton, husbandman 2
3941762 2004258 2004258 defendant Warner alias Potter Hugh yeoman 587331 587331 Warner alias Potter, Hugh, of Causton, yeoman 1
3944004 2005012 2005012 defendant Leveryngton William blacksmith 587331 587331 Leveryngton, William, of Causton, blacksmith 2
3944009 2005013 2005013 defendant Leveryngton William blacksmith 587331 587331 Leveryngton, William, of Causton, blacksmith 2
3946910 2005987 2005987 defendant Ynglett John yeoman 587331 587331 Ynglett, John, of Causton, yeoman 3
3947272 2006115 2006115 defendant Browne Robert (legal representative) 587331 587331 Browne, Robert, of Causton, "meryer", executors of 0
3954791 2008744 2008744 defendant Lowthe Nicholas yeoman 587331 587331 Lowthe, Nicholas, of Causton, yeoman 0
3954904 2008781 2008781 defendant Warde William yeoman 587331 587331 Warde, William, of Causton, yeoman 0
3958690 2010113 2010113 defendant Marsha Edmund (legal representative) 587331 587331 Marsha, Edmund, of Causton, worsted weaver, administratrix of 2
3958691 2010113 2010113 defendant Marsham Katherine widow 587331 587331 Marsham, Katherine, of Causton, widow 3
3959632 2010462 2010462 defendant Causton Robert   587331 587331 Causton, Robert, of Causton, shepherd 1
3960673 2010833 2010833 plaintiff Sympton or Sympson Robert   587331 587331 Sympton or Sympson, Robert, of Causton 0
3960676 2010834 2010834 plaintiff Sympton or Sympson Robert   587331 587331 Sympton or Sympson, Robert, of Causton 0
3960680 2010835 2010835 defendant Rente Robert yeoman 587331 587331 Rente, Robert, of Causton, yeoman 0
3960890 2010907 2010907 defendant Wryght Anne widow 587331 587331 Wryght, Anne, of Causton, widow 1
3960893 2010908 2010908 defendant Wright Anne widow 587331 587331 Wright, Anne, of Causton, widow 1
3979805 2017532 2017532 defendant Certeyne Robert clerk 587331 587331 Certeyne, Robert, of Causton, clerk 0
3983255 2018784 2018784 defendant Lowth Nicholas yeoman 587331 587331 Lowth, Nicholas, of Causton, yeoman 0
4013650 2029619 2029619 defendant Wade John tailor 587331 587331 Wade, John, of Causton, tailor 1
4015252 2030148 2030148 plaintiff Smyth Edward yeoman 587331 587331 Smyth, Edward, of Causton, yeoman 0
4015443 2030220 2030220 plaintiff Smythe Edward yeoman 587331 587331 Smythe, Edward, of Causton, yeoman 0
4052115 2043180 2043180 defendant Pryor Thomas husbandman 587331 587331 Pryor, Thomas, of Causton, husbandman 0
4052119 2043180 2043180 defendant Fuller Ralph butcher 587331 587331 Fuller, Ralph, of Causton, butcher 4
4052129 2043181 2043181 defendant Certen Robert clerk 587331 587331 Certen, Robert, of Causton, clerk 2
4052131 2043181 2043181 defendant Fuller Ralph butcher 587331 587331 Fuller, Ralph, of Causton, butcher 4

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