names

323 rows where place_id = 586228

✎ 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
3588215 1863968 1863968 defendant Kervyle Thomas gent 586228 586228 Kervyle, Thomas, of Watlyngton, gent 0
3594154 1865814 1865814 defendant Nesshe William   586228 586228 Nesshe, William, of Watlyngton, tallow chandler 1
3598103 1867035 1867035 defendant Cholfe William husbandman 586228 586228 Cholfe, William, of Watlyngton, husbandman 0
3598105 1867036 1867036 defendant Cholse or Cholfe William husbandman 586228 586228 Cholse or Cholfe, William, of Watlyngton, husbandman 0
3606721 1869779 1869779 defendant Wynsers alias Baker Nicholas yeoman 586228 586228 (Wynsers alias Baker, Nicholas, of Watlyngton, yeoman 1
3607915 1870126 1870126 defendant Noon John   586228 586228 Noon, John, of Watlyngton, tile burner 0
3622385 1874539 1874539 defendant Leke Godwin yeoman 586228 586228 Leke, Godwin, of Watlyngton, yeoman 1
3622386 1874539 1874539 defendant Noon John laborer 586228 586228 Noon, John, of Watlyngton, laborer 2
3622964 1874711 1874711 defendant Gybon Agnes widow 586228 586228 Gybon, Agnes, of Watlyngton, widow 0
3622965 1874711 1874711 defendant Hameldon John weaver 586228 586228 Hameldon, John, of Watlyngton,weaver 1
3623015 1874725 1874725 defendant Mannyng Thomas husbandman 586228 586228 Mannyng, Thomas, of Watlyngton, husbandman 2
3625867 1902942 1902942 defendant Skydmore Thomas gent 586228 586228 Skydmore, Thomas, of Watlyngton, gent 2
3633801 1905386 1905386 defendant Benet Richard chapman 586228 586228 Benet, Richard, of Watlyngton, chapman 0
3633802 1905386 1905386 defendant Dolphyn Richard chapman 586228 586228 Dolphyn, Richard, of Watlyngton,chapman 1
3633803 1905386 1905386 defendant Sallet William husbandman 586228 586228 Sallet, William, of Watlyngton, husbandman 2
3633804 1905386 1905386 defendant Goode William, senior husbandman 586228 586228 Goode, William, senior, of Watlyngton, husbandman 3
3633805 1905386 1905386 defendant Messenger John husbandman 586228 586228 Messenger, John, of Watlyngton, husbandman 4
3635523 1905910 1905910 plaintiff Pate John yeoman 586228 586228 Pate, John, of Watlyngton, yeoman 0
3635524 1905910 1905910 defendant Chollys John hosier 586228 586228 Chollys, John, of Watlyngton, hosier 0
3636068 1906072 1906072 defendant Reynes Margaret widow 586228 586228 Reynes, Margaret, of Watlyngton, widow 3
3637361 1906490 1906490 defendant Benet Richard chapman 586228 586228 Benet, Richard, of Watlyngton, chapman 0
3646903 1909430 1909430 plaintiff Kervyll Thomas, junior gent 586228 586228 Kervyll, Thomas, junior, of Watlyngton, gent 0
3646904 1909430 1909430 defendant Emsall Robert reeder 586228 586228 Emsall, Robert, of Watlyngton, reeder 0
3648970 1910065 1910065 defendant Salett William husbandman 586228 586228 Salett, William, of Watlyngton, husbandman 0
3649496 1910230 1910230 defendant Empson Robert thatcher 586228 586228 Empson, Robert, of Watlyngton, thatcher 3
3650546 1910538 1910538 defendant Crecy Geoffrey reeder 586228 586228 Crecy, Geoffrey, of Watlyngton, reeder 0
3656744 1912363 1912363 defendant Salter John husbandman 586228 586228 Salter, John, of Watlyngton, husbandman 2
3656745 1912363 1912363 defendant Monnyng Robert husbandman 586228 586228 Monnyng, Robert, of Watlyngton, husbandman 3
3656746 1912363 1912363 defendant Seman William husbandman 586228 586228 Seman, William, of Watlyngton, husbandman 4
3659553 1913249 1913249 defendant Cholles John miller 586228 586228 Cholles, John, of Watlyngton, miller 0
3672299 1917337 1917337 defendant Grendon William husbandman 586228 586228 Grendon, William, of Watlyngton, husbandman 0
3676775 1918772 1918772 defendant Benet Richard chapman 586228 586228 Benet, Richard, of Watlyngton, chapman 0
3680268 1919901 1919901 defendant Gollcell Richard esq 586228 586228 Gollcell, Richard, of Watlyngton, esq 0
3680270 1919902 1919902 defendant Gowcell Richard esq 586228 586228 Gowcell, Richard, of Watlyngton, esq 0
3686514 1921933 1921933 defendant Chollys John yeoman 586228 586228 Chollys, John, of Watlyngton, yeoman 0
3690633 1923235 1923235 defendant Newenton John butcher 586228 586228 Newenton, John, of Watlyngton, butcher 0
3693423 1924159 1924159 defendant Stanley Richard yeoman 586228 586228 Stanley, Richard, of Watlyngton, yeoman 0
3693424 1924159 1924159 defendant Gawsell Simon gent 586228 586228 Gawsell, Simon, of Watlyngton, gent 1
3696465 1925121 1925121 defendant Stanley Richard yeoman 586228 586228 Stanley, Richard, of Watlyngton, yeoman 0
3696466 1925121 1925121 defendant Gausell Simon gent 586228 586228 Gausell, Simon, of Watlyngton, gent 1
3705079 1927878 1927878 defendant Bennet Richard mercer 586228 586228 Bennet, Richard, of Watlyngton, mercer 0
3718313 1932012 1932012 defendant Chollys John yeoman 586228 586228 Chollys, John, of Watlyngton, yeoman 0
3753369 1942991 1942991 defendant Benett William husbandman 586228 586228 Benett, William, of Watlyngton, husbandman 0
3757227 1944244 1944244 defendant Gawsell Simon gent 586228 586228 Gawsell, Simon, of Watlyngton, gent 0
3775166 1949967 1949967 defendant Gawsell Simon gent 586228 586228 Gawsell, Simon, of Watlyngton, gent 0
3775168 1949968 1949968 defendant Gawsell Simon gent 586228 586228 Gawsell, Simon, of Watlyngton, gent 0
3781028 1951800 1951800 defendant Gawell Thomas gent 586228 586228 Gawell, Thomas, of Watlyngton, gent 0
3781029 1951800 1951800 defendant Stanley Richard yeoman 586228 586228 Stanley, Richard, of Watlyngton, yeoman 1
3795400 1956433 1956433 defendant Wode John husbandman 586228 586228 Wode, John, of Watlyngton, husbandman 0
3795402 1956434 1956434 defendant Wode John husbandman 586228 586228 Wode, John, of Watlyngton, husbandman 0
3796917 1956915 1956915 defendant Cholles John hosier 586228 586228 Cholles, John, of Watlyngton, hosier 0
3802350 1958634 1958634 defendant Cawsell Simon gent 586228 586228 Cawsell, Simon, of Watlyngton, gent 0
3808918 1960667 1960667 defendant Saller John husbandman 586228 586228 Saller, John, of Watlyngton, husbandman 0
3819805 1964075 1964075 defendant Gawsell Simon gent 586228 586228 Gawsell, Simon, of Watlyngton, gent 0
3819816 1964078 1964078 defendant Gawsell Simon gent 586228 586228 Gawsell, Simon, of Watlyngton, gent 0
3844939 1971963 1971963 defendant Hastybroke Henry husbandman 586228 586228 Hastybroke, Henry, of Watlyngton, husbandman 0
3846112 1972343 1972343 plaintiff Gawcell Richard esq 586228 586228 Gawcell, Richard, of Watlyngton, esq 0
3846143 1972349 1972349 plaintiff Gawsell Richard esq 586228 586228 Gawsell, Richard, of Watlyngton, esq 0
3850052 1973605 1973605 defendant Freman Thomas butcher 586228 586228 Freman, Thomas, of Watlyngton, butcher 3
3861673 1977363 1977363 defendant Goode William baker 586228 586228 Goode, William, of Watlyngton, baker 0
3863928 1978112 1978112 defendant Gawcell Richard gent 586228 586228 Gawcell, Richard, of Watlyngton, gent 0
3863929 1978112 1978112 defendant Mares John laborer 586228 586228 Mares, John, of Watlyngton, laborer 1
3864613 1978361 1978361 defendant Gancell Thomas gent 586228 586228 Gancell, Thomas, of Watlyngton, gent 0
3875872 1982186 1982186 defendant Valenger Robert gent 586228 586228 Valenger, Robert, of Watlyngton, gent 0
3888010 1986240 1986240 defendant Byas John clerk 586228 586228 Byas, John, of Watlyngton, clerk 0
3891777 1987505 1987505 defendant Boller William husbandman 586228 586228 Boller, William, of Watlyngton, husbandman 2
3902322 1991008 1991008 defendant Perche John yeoman 586228 586228 Perche, John, of Watlyngton, yeoman 1
3916961 1996041 1996041 plaintiff Gawsell Richard (legal representative) 586228 586228 Gawsell, Richard, of Watlyngton, esq, executors of 0
3916964 1996042 1996042 plaintiff Gawsell Richard (legal representative) 586228 586228 Gawsell, Richard, of Watlyngton, esq, executors of 0
3916967 1996043 1996043 plaintiff Gawsell Richard (legal representative) 586228 586228 Gawsell, Richard, of Watlyngton, esq, executors of 0
3916971 1996044 1996044 plaintiff Gawsell Richard (legal representative) 586228 586228 Gawsell, Richard, of Watlyngton, esq, executors of 0
3916975 1996045 1996045 plaintiff Gawsell Richard (legal representative) 586228 586228 Gawsell, Richard, of Watlyngton, esq, executors of 0
3924392 1998469 1998469 defendant Buttis William gent 586228 586228 Buttis, William, of Watlyngton, gent 0
3924393 1998469 1998469 defendant Smythe Lawrence yeoman 586228 586228 Smythe, Lawrence, of Watlyngton, yeoman 1
3929382 2000174 2000174 plaintiff Buttes William gent 586228 586228 Buttes, William, of Watlyngton, gent 0
3930311 2000484 2000484 defendant Marham Thomas husbandman 586228 586228 Marham, Thomas, of Watlyngton, husbandman 2
3930315 2000485 2000485 defendant Marham Thomas husbandman 586228 586228 Marham, Thomas, of Watlyngton, husbandman 2
3938576 2003245 2003245 defendant Howse William husbandman 586228 586228 Howse, William, of Watlyngton, husbandman 0
3946487 2005840 2005840 defendant Pyke William tailor 586228 586228 Pyke, William, of Watlyngton, tailor 0
3947002 2006016 2006016 defendant Lyfe Thomas yeoman 586228 586228 Lyfe, Thomas, of Watlyngton, yeoman 0
3947003 2006016 2006016 defendant Nele Edmund laborer 586228 586228 Nele, Edmund, of Watlyngton, laborer 1
3947004 2006016 2006016 defendant Lee Richard   586228 586228 Lee, Richard, of Watlyngton, oatmeal maker 2
3947005 2006016 2006016 defendant Careles Thomas laborer 586228 586228 Careles, Thomas, of Watlyngton, laborer 3
3947006 2006016 2006016 defendant Wylson John laborer 586228 586228 Wylson, John, of Watlyngton, laborer 4
3947007 2006016 2006016 defendant Harryson William laborer 586228 586228 Harryson, William, of Watlyngton, laborer 5
3947752 2006278 2006278 defendant Buck Thomas (legal representative) 586228 586228 Buck, Thomas, of Watlyngton, yeoman, executors of 0
3947753 2006278 2006278 defendant Kervyle Humphrey gent 586228 586228 (Kervyle, Humphrey, of Watlyngton, gent 1
3961645 2011174 2011174 defendant Severall John husbandman 586228 586228 Severall, John, of Watlyngton, husbandman 0
3970973 2014404 2014404 defendant Kervyle Humphrey gent 586228 586228 Kervyle, Humphrey, of Watlyngton, gent 0
3974210 2015546 2015546 plaintiff Harryson Martin clerk 586228 586228 Harryson, Martin, of Watlyngton, clerk 0
3976507 2016358 2016358 defendant Kervyle Humphrey gent 586228 586228 Kervyle, Humphrey, of Watlyngton, gent 1
3992247 2021992 2021992 defendant Watson Henry husbandman 586228 586228 Watson, Henry, of Watlyngton, husbandman 0
3998535 2024215 2024215 defendant Hurrell Richard yeoman 586228 586228 Hurrell, Richard, of Watlyngton, yeoman 0
4017809 2031082 2031082 defendant Karvyle Robert gent 586228 586228 Karvyle, Robert, of Watlyngton, gent 0
4021758 2032508 2032508 defendant Emerey Robert yeoman 586228 586228 Emerey, Robert, of Watlyngton, yeoman 0
4021760 2032509 2032509 defendant Emerey Robert yeoman 586228 586228 Emerey, Robert, of Watlyngton, yeoman 0
4051068 2042820 2042820 defendant Baxter John yeoman 586228 586228 Baxter, John, of Watlyngton, yeoman 0
4106525 2062623 2062623 defendant Fysher William husbandman 586228 586228 Fysher, William, of Watlyngton, husbandman 0
4108229 2063209 2063209 defendant Fever John yeoman 586228 586228 Fever, John, of Watlyngton, yeoman 0
4123083 2068552 2068552 defendant Furner Robert husbandman 586228 586228 Furner, Robert, of Watlyngton, husbandman 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);