names

332 rows where place_id = 587792

✎ 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
3592116 1865151 1865151 defendant Grenelef Robert   587792 587792 Grenelef, Robert, of Debenham, tile maker 0
3592117 1865151 1865151 defendant Tyler William   587792 587792 Tyler, William, of Debenham, tile maker 1
3592119 1865152 1865152 defendant Grenelef Robert   587792 587792 Grenelef, Robert, of Debenham, tile maker 0
3592120 1865152 1865152 defendant Tyler William   587792 587792 Tyler, William, of Debenham, tile maker 1
3592122 1865153 1865153 defendant Grenelef Robert   587792 587792 Grenelef, Robert, of Debenham, tile maker 0
3592123 1865153 1865153 defendant Tyler William   587792 587792 Tyler, William, of Debenham, tile maker 1
3592455 1865255 1865255 defendant Lathered Richard smith 587792 587792 Lathered, Richard, of Debenham, smith 0
3592456 1865255 1865255 defendant Runketill Robert butcher 587792 587792 Runketill, Robert, of Debenham, butcher 1
3597197 1866747 1866747 defendant Wode Robert mercer 587792 587792 Wode, Robert, of Debenham, mercer 0
3597200 1866748 1866748 defendant Woode John husbandman 587792 587792 Woode, John, of Debenham, husbandman 0
3597380 1866801 1866801 defendant Buk Thomas, senior husbandman 587792 587792 Buk, Thomas, senior, of Debenham, husbandman 4
3597433 1866815 1866815 defendant Buk Thomas, senior husbandman 587792 587792 Buk, Thomas, senior, of Debenham, husbandman 3
3600329 1867748 1867748 defendant Mannyng John, junior laborer 587792 587792 Mannyng, John, junior, of Debenham, laborer 2
3600330 1867748 1867748 defendant Symond John cooper 587792 587792 Symond, John, of Debenham, cooper 3
3616507 1872799 1872799 defendant Talmage Thomas husbandman 587792 587792 Talmage, Thomas, of Debenham, husbandman 0
3651026 1910686 1910686 defendant Bonde John yeoman 587792 587792 Bonde, John, of Debenham, yeoman 4
3654572 1911692 1911692 defendant Thrower Robert, senior husbandman 587792 587792 Thrower, Robert, senior, of Debenham, husbandman 1
3656193 1912184 1912184 defendant Huberd alias Cosyn John beer brewer 587792 587792 Huberd alias Cosyn, John, of Debenham, beer brewer 0
3657778 1912684 1912684 defendant Newton William yeoman 587792 587792 Newton, William, of Debenham, yeoman 0
3658868 1913028 1913028 defendant Bukke Thomas husbandman 587792 587792 Bukke, Thomas, of Debenham, husbandman 0
3658870 1913029 1913029 defendant Bulle Thomas husbandman 587792 587792 Bulle, Thomas, of Debenham, husbandman 0
3661840 1913988 1913988 defendant Huberd alias Cosyn John beer brewer 587792 587792 Huberd alias Cosyn, John, of Debenham, beer brewer 0
3662963 1914328 1914328 defendant Runketyll Agnes widow 587792 587792 Runketyll, Agnes, of Debenham, widow 0
3670409 1916700 1916700 defendant Haryson Alice widow 587792 587792 Haryson, Alice, of Debenham, widow 2
3679511 1919662 1919662 plaintiff Petyt Robert (legal representative) 587792 587792 Petyt, Robert, of Debenham, administratrix of 0
3687280 1922202 1922202 defendant Buck Thomas husbandman 587792 587792 Buck, Thomas, of Debenham, husbandman 0
3689930 1923009 1923009 defendant Newton William yeoman 587792 587792 Newton, William, of Debenham, yeoman 0
3699178 1925955 1925955 defendant Brown Robert gent 587792 587792 Brown, Robert, of Debenham, gent 0
3699320 1926003 1926003 defendant Broun John husbandman 587792 587792 Broun, John, of Debenham, husbandman 0
3704759 1927777 1927777 defendant Newton William husbandman 587792 587792 Newton, William, of Debenham, husbandman 0
3704796 1927791 1927791 defendant Newton William yeoman 587792 587792 Newton, William, of Debenham, yeoman 0
3714742 1930912 1930912 plaintiff Bonde John singleman 587792 587792 Bonde, John, of Debenham, singleman 0
3719671 1932419 1932419 defendant Hekelyngham Richard husbandman 587792 587792 Hekelyngham, Richard, of Debenham, husbandman 1
3737899 1938073 1938073 defendant Harrison William draper 587792 587792 Harrison, William, of Debenham, draper 1
3737903 1938074 1938074 defendant Harryson William draper 587792 587792 Harryson, William, of Debenham, draper 1
3746531 1940827 1940827 defendant Inglyssh John butcher 587792 587792 Inglyssh, John, of Debenham, butcher 0
3750218 1941986 1941986 plaintiff Launde Robert   587792 587792 Launde, Robert, of Debenham 0
3750221 1941986 1941986 defendant Bocher John tailor 587792 587792 Bocher, John, of Debenham, tailor 2
3751435 1942366 1942366 defendant Alen John husbandman 587792 587792 Alen, John, of Debenham, husbandman 0
3752441 1942685 1942685 defendant Harryson William draper 587792 587792 Harryson, William, of Debenham, draper 1
3762384 1945879 1945879 defendant Bardwell William smith 587792 587792 Bardwell, William, of Debenham, smith 0
3765589 1946902 1946902 plaintiff Launde Robert   587792 587792 Launde, Robert, of Debenham 0
3771658 1948834 1948834 defendant Lone or Love John yeoman 587792 587792 Lone or Love, John, of Debenham, yeoman 0
3783948 1952757 1952757 defendant Thrower Robert glover 587792 587792 Thrower, Robert, of Debenham, glover 0
3784577 1952963 1952963 defendant Ivu Richard fletcher 587792 587792 Ivu, Richard, of Debenham, fletcher 3
3796682 1956845 1956845 plaintiff Ferman Augustine   587792 587792 Ferman, Augustine, of Debenham 0
3796683 1956845 1956845 defendant Hervy John fuller 587792 587792 Hervy, John, of Debenham, fuller 0
3798369 1957389 1957389 defendant Celysto William tailor 587792 587792 Celysto, William, of Debenham, tailor 0
3799950 1957905 1957905 defendant Clase Derreck shoemaker 587792 587792 Clase, Derreck, of Debenham, shoemaker 0
3805638 1959706 1959706 defendant Lone or Love John, senior husbandman 587792 587792 Lone or Love, John, senior, of Debenham, husbandman 0
3819411 1963956 1963956 defendant Aloone John husbandman 587792 587792 Aloone, John, of Debenham, husbandman 1
3825033 1965703 1965703 defendant Weymonde Robert (legal representative) 587792 587792 Weymonde, Robert, of Debenham, husbandman, executors of 0
3829846 1967226 1967226 defendant Bonde John draper 587792 587792 Bonde, John, of Debenham, draper 0
3829852 1967228 1967228 defendant Lone alias Alone John, senior yeoman 587792 587792 Lone alias Alone, John, senior, of Debenham, yeoman 0
3829853 1967228 1967228 defendant Lone alias Alone John, junior singleman 587792 587792 Lone alias Alone, John, junior, of Debenham, singleman 1
3852690 1974449 1974449 defendant Harryson William draper 587792 587792 Harryson, William, of Debenham, draper 0
3862634 1977698 1977698 defendant Byrde Edward   587792 587792 Byrde, Edward, of Debenham, collar maker 0
3862635 1977698 1977698 defendant Alone John, junior husbandman 587792 587792 Alone, John, junior, of Debenham, husbandman 1
3862636 1977698 1977698 defendant Fenne George clerk 587792 587792 Fenne, George, of Debenham, clerk 2
3862637 1977698 1977698 defendant Golston Stephen butcher 587792 587792 Golston, Stephen, of Debenham, butcher 3
3871749 1980787 1980787 defendant Herryson William draper 587792 587792 Herryson, William, of Debenham, draper 1
3872399 1980992 1980992 defendant Hutton Lawrence weaver 587792 587792 Hutton, Lawrence, of Debenham, weaver 0
3872400 1980992 1980992 defendant Sawyer Thomas laborer 587792 587792 Sawyer, Thomas, of Debenham, laborer 1
3878267 1982980 1982980 defendant Kyng John saddler 587792 587792 Kyng, John, of Debenham, saddler 1
3888986 1986557 1986557 plaintiff Framlyngham Francis esq 587792 587792 Framlyngham, Francis, of Debenham, esq 0
3897970 1989527 1989527 defendant Savage John butcher 587792 587792 Savage, John, of Debenham, butcher 3
3899693 1990113 1990113 defendant Parke Robert baker 587792 587792 Parke, Robert, of Debenham, baker 0
3905555 1992126 1992126 defendant Kyng John shoemaker 587792 587792 Kyng, John, of Debenham, shoemaker 1
3906309 1992397 1992397 defendant Tomlyn Humphrey husbandman 587792 587792 Tomlyn, Humphrey, of Debenham, husbandman 0
3909641 1993532 1993532 defendant Cheke Robert esq 587792 587792 Cheke, Robert, of Debenham, esq 0
3922484 1997836 1997836 defendant Harvye Edmund husbandman 587792 587792 Harvye, Edmund, of Debenham, husbandman 0
3923214 1998075 1998075 defendant Chester Robert yeoman 587792 587792 Chester, Robert, of Debenham, yeoman 1
3929528 2000224 2000224 plaintiff Campe John husbandman 587792 587792 Campe, John, of Debenham, husbandman 0
3929529 2000224 2000224 defendant Lone John yeoman 587792 587792 Lone, John, of Debenham, yeoman 0
3931266 2000749 2000749 plaintiff Dawes William yeoman 587792 587792 Dawes, William, of Debenham, yeoman 0
3931267 2000749 2000749 defendant Lone John yeoman 587792 587792 Lone, John, of Debenham, yeoman 0
3931270 2000750 2000750 defendant Lone or Lane John yeoman 587792 587792 Lone or Lane, John, of Debenham, yeoman 0
3932008 2001006 2001006 defendant Chester Robert yeoman 587792 587792 Chester, Robert, of Debenham, yeoman 0
3932010 2001007 2001007 defendant Chester Robert yeoman 587792 587792 Chester, Robert, of Debenham, yeoman 0
3932283 2001101 2001101 defendant Chester Robert yeoman 587792 587792 Chester, Robert, of Debenham, yeoman 0
3941477 2004159 2004159 defendant Blaker Geoffrey gent 587792 587792 Blaker, Geoffrey, of Debenham, gent 0
3959680 2010478 2010478 defendant Chester Robert yeoman 587792 587792 Chester, Robert, of Debenham, yeoman 0
3959686 2010479 2010479 defendant Chester Robert yeoman 587792 587792 Chester, Robert, of Debenham, yeoman 0
4017825 2031088 2031088 defendant Sherman Thomas grocer 587792 587792 Sherman, Thomas, of Debenham, grocer 1
4017851 2031095 2031095 defendant Sherman Thomas grocer 587792 587792 Sherman, Thomas, of Debenham, grocer 1
4019804 2031812 2031812 defendant Bardwell James blacksmith 587792 587792 Bardwell, James, of Debenham, blacksmith 3
4026089 2033979 2033979 defendant Myles John carpenter 587792 587792 Myles, John, of Debenham, carpenter 1
4040656 2039153 2039153 defendant Beamond John   587792 587792 Beamond, John, of Debenham, surgeon 2
4072852 2050587 2050587 defendant Savadge George butcher 587792 587792 Savadge, George, of Debenham, butcher 0
4106347 2062560 2062560 defendant Lorde Robert yeoman 587792 587792 Lorde, Robert, of Debenham, yeoman 0
4106348 2062560 2062560 defendant Corbolde Thomas yeoman 587792 587792 Corbolde, Thomas, of Debenham, yeoman 1
4125527 2069414 2069414 defendant Savage George butcher 587792 587792 Savage, George, of Debenham, butcher 0
4126030 2069595 2069595 defendant Slade Thomas weaver 587792 587792 Slade, Thomas, of Debenham, weaver 1
4149182 2077841 2077841 defendant Slade Thomas weaver 587792 587792 Slade, Thomas, of Debenham, weaver 1
4159731 2081471 2081471 defendant Gold John cordwainer 587792 587792 Gold, John, of Debenham, cordwainer 0
4182158 2089237 2089237 defendant Savadge George butcher 587792 587792 Savadge, George, of Debenham, butcher 0
4194051 2093473 2093473 defendant Savage George butcher 587792 587792 Savage, George, of Debenham, butcher 0
4194053 2093473 2093473 defendant Baker Agnes spinster 587792 587792 Baker, Agnes, of Debenham, spinster 2
4199314 2095315 2095315 defendant Whayman William husbandman 587792 587792 Whayman, William, of Debenham, husbandman 0
4205769 2097566 2097566 defendant Helwys Geoffrey vintner 587792 587792 Helwys, Geoffrey, of Debenham, vintner 2

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