names

239 rows where place_id = 589769

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598681 1867212 1867212 defendant Havyn or Hanyn John thatcher 589769 589769 Havyn or Hanyn, John, of Sandon, thatcher 2
3598683 1867213 1867213 defendant Havyn John thatcher 589769 589769 Havyn, John, of Sandon, thatcher 0
3602422 1868417 1868417 defendant Burre Richard   589769 589769 Burre, Richard, of Sandon, administrators of 0
3602423 1868417 1868417 defendant Malpas John husbandman 589769 589769 (Malpas, John, of Sandon, husbandman 1
3614076 1872067 1872067 defendant Sander Robert   589769 589769 Sander, Robert, of Sandon 0
3639823 1907267 1907267 defendant Neuport Robert husbandman 589769 589769 Neuport, Robert, of Sandon, husbandman 0
3642147 1907991 1907991 defendant Sandon William tailor 589769 589769 Sandon, William, of Sandon, tailor 4
3645094 1908874 1908874 defendant Nicoll Thomas laborer 589769 589769 Nicoll, Thomas, of Sandon, laborer 1
3645098 1908875 1908875 defendant Nycoll Thomas laborer 589769 589769 Nycoll, Thomas, of Sandon, laborer 1
3646493 1909300 1909300 defendant Lorymer John husbandman 589769 589769 Lorymer, John, of Sandon, husbandman 3
3662303 1914125 1914125 defendant Mathewe Thomas husbandman 589769 589769 Mathewe, Thomas, of Sandon, husbandman 0
3668174 1915991 1915991 defendant Tayllour John laborer 589769 589769 Tayllour, John, of Sandon, laborer 1
3668175 1915991 1915991 defendant Kyng William husbandman 589769 589769 Kyng, William, of Sandon, husbandman 2
3668998 1916234 1916234 defendant Butler John yeoman 589769 589769 Butler, John, of Sandon, yeoman 1
3670016 1916568 1916568 defendant Manch or Mauch William laborer 589769 589769 Manch or Mauch, William, of Sandon, laborer 1
3670020 1916569 1916569 defendant Manch William laborer 589769 589769 Manch, William, of Sandon, laborer 1
3678635 1919378 1919378 defendant Butler John   589769 589769 Butler, John, of Sandon 0
3678812 1919441 1919441 defendant Boteler John yeoman 589769 589769 Boteler, John, of Sandon, yeoman 1
3694297 1924420 1924420 defendant Botteler John   589769 589769 Botteler, John, of Sandon 0
3695399 1924784 1924784 defendant Kympton Richard   589769 589769 Kympton, Richard, of Sandon, husbandman, administrators of 2
3700877 1926520 1926520 defendant Butler John gent 589769 589769 Butler, John, of Sandon, gent 0
3702506 1927050 1927050 defendant Brown John husbandman 589769 589769 Brown, John, of Sandon, husbandman 1
3722962 1933446 1933446 defendant Lorymer John husbandman 589769 589769 Lorymer, John, of Sandon, husbandman 2
3723917 1933761 1933761 defendant Browne John laborer 589769 589769 Browne, John, of Sandon, laborer 2
3723919 1933761 1933761 defendant Crede William laborer 589769 589769 Crede, William, of Sandon, laborer 4
3724024 1933797 1933797 defendant Edwardes Thomas laborer 589769 589769 Edwardes, Thomas, of Sandon, laborer 2
3729487 1935469 1935469 defendant Butler John yeoman 589769 589769 Butler, John, of Sandon, yeoman 1
3738831 1938350 1938350 defendant Lorymer John husbandman 589769 589769 Lorymer, John, of Sandon, husbandman 3
3763020 1946065 1946065 defendant Tayllour John laborer 589769 589769 Tayllour, John, of Sandon, laborer 0
3766308 1947115 1947115 defendant Bocher John husbandman 589769 589769 Bocher, John, of Sandon, husbandman 0
3766310 1947116 1947116 defendant Moyne Thomas potter 589769 589769 Moyne, Thomas, of Sandon, potter 0
3771903 1948904 1948904 defendant Smyth Richard husbandman 589769 589769 Smyth, Richard, of Sandon, husbandman 1
3779495 1951309 1951309 defendant Taylour John laborer or maltman 589769 589769 Taylour, John, of Sandon, laborer or maltman 0
3779497 1951310 1951310 defendant Taylour John laborer or maltman 589769 589769 Taylour, John, of Sandon, laborer or maltman 0
3785395 1953219 1953219 defendant Tayler John husbandman 589769 589769 Tayler, John, of Sandon, husbandman 1
3809593 1960887 1960887 defendant Tayllour John husbandman 589769 589769 Tayllour, John, of Sandon, husbandman 0
3812986 1961964 1961964 defendant Layson Thomas laborer 589769 589769 Layson, Thomas, of Sandon, laborer 0
3891985 1987570 1987570 plaintiff Madeson Launcelot yeoman 589769 589769 Madeson, Launcelot, of Sandon, yeoman 0
3891999 1987575 1987575 plaintiff Madyson Launcelet yeoman 589769 589769 Madyson, Launcelet, of Sandon, yeoman 0
3906088 1992326 1992326 defendant Duffeld Nicholas husbandman 589769 589769 Duffeld, Nicholas, of Sandon, husbandman 1
3911768 1994262 1994262 defendant Crede William husbandman 589769 589769 Crede, William, of Sandon, husbandman 0
3914454 1995178 1995178 defendant Latham William gent 589769 589769 Latham, William, of Sandon, gent 0
3914455 1995178 1995178 defendant Slyng Robert yeoman 589769 589769 Slyng, Robert, of Sandon, yeoman 1
3914458 1995179 1995179 defendant Latham William gent 589769 589769 Latham, William, of Sandon, gent 0
3914459 1995179 1995179 defendant Slyng Robert yeoman 589769 589769 Slyng, Robert, of Sandon, yeoman 1
3918225 1996430 1996430 defendant Newport John, senior esq 589769 589769 Newport, John, senior, of Sandon, esq 0
3918705 1996586 1996586 defendant Newport John, senior esq 589769 589769 Newport, John, senior, of Sandon, esq 0
3942871 2004619 2004619 defendant Crosse Edward yeoman 589769 589769 Crosse, Edward, of Sandon, yeoman 1
3953254 2008206 2008206 defendant Awoode John yeoman 589769 589769 Awoode, John, of Sandon, yeoman 0
3953255 2008206 2008206 defendant Russell alias Chytyng John laborer 589769 589769 Russell alias Chytyng, John, of Sandon, laborer 1
3953256 2008206 2008206 defendant Felde Richard laborer 589769 589769 Felde, Richard, of Sandon, laborer 2
3953258 2008207 2008207 defendant Newport Robert gent 589769 589769 Newport, Robert, of Sandon, gent 0
4040501 2039095 2039095 defendant Harvey John husbandman 589769 589769 Harvey, John, of Sandon, husbandman 1
4040502 2039095 2039095 defendant Harvye Simon   589769 589769 Harvye, Simon, of Sandon, husbandman, son of Simon 2
4048590 2041944 2041944 defendant Nesfelde Peter husbandman 589769 589769 Nesfelde, Peter, of Sandon, husbandman 0
4063687 2047303 2047303 defendant Edward Mathew yeoman 589769 589769 Edward, Mathew, of Sandon, yeoman 2
4063688 2047303 2047303 defendant Crede George husbandman 589769 589769 Crede, George, of Sandon, husbandman 3
4086737 2055545 2055545 defendant Downes Thomas yeoman 589769 589769 Downes, Thomas, of Sandon, yeoman 1
4102667 2061254 2061254 defendant Crede George yeoman 589769 589769 Crede, George, of Sandon, yeoman 0
4102669 2061254 2061254 defendant Harvy Thomas yeoman 589769 589769 Harvy, Thomas, of Sandon, yeoman 2
4102670 2061254 2061254 defendant Weston alias Joyner William yeoman 589769 589769 Weston alias Joyner, William, of Sandon, yeoman 3
4104045 2061720 2061720 defendant Arrundell alias Pamphelyn Walter yeoman 589769 589769 Arrundell alias Pamphelyn, Walter, of Sandon, yeoman 1
4145750 2076667 2076667 defendant Blee Giles yeoman 589769 589769 Blee, Giles, of Sandon, yeoman 1
4153976 2079484 2079484 defendant Arundell alias Pamphelyn Walter yeoman 589769 589769 Arundell alias Pamphelyn, Walter, of Sandon, yeoman 0
4161734 2082172 2082172 defendant Turner Henry yeoman 589769 589769 Turner, Henry, of Sandon, yeoman 0
4161735 2082172 2082172 defendant Hide William, senior (legal representative) 589769 589769 Hide, William, senior, of Sandon, esq, executrix of 1
4161736 2082172 2082172 defendant Hyde Lucy widow 589769 589769 Hyde, Lucy, of Sandon, widow 2
4170634 2085230 2085230 defendant Clowe Giles husbandman 589769 589769 Clowe, Giles, of Sandon, husbandman 2
4172705 2085912 2085912 defendant Bawnett Robert miller 589769 589769 Bawnett, Robert, of Sandon, or of Barkwaye, miller 0
4190295 2092114 2092114 defendant Harvye John husbandman 589769 589769 Harvye, John, of Sandon, husbandman 1
4219726 2102404 2102404 defendant Bugbye George yeoman 589769 589769 Bugbye, George, of Sandon, yeoman 0
4232685 2106937 2106937 defendant Lorymer William husbandman 589769 589769 Lorymer, William, of Sandon, husbandman 0
4235447 2107966 2107966 defendant Sturgyon Philemon yeoman 589769 589769 Sturgyon, Philemon, of Sandon, yeoman 1
4236122 2108204 2108204 defendant Gyll Hugh yeoman 589769 589769 Gyll, Hugh, of Sandon, yeoman 1
4237185 2108592 2108592 defendant Partridge Thomas husbandman 589769 589769 Partridge, Thomas, of Sandon, husbandman 1
4237186 2108592 2108592 defendant Arthur John yeoman 589769 589769 Arthur, John, of Sandon, yeoman 2
4237187 2108592 2108592 defendant Glasier Thomas husbandman 589769 589769 Glasier, Thomas, of Sandon, husbandman 3
4239838 2109569 2109569 defendant Blowe Giles yeoman 589769 589769 Blowe, Giles, of Sandon, yeoman 1
4275131 2121251 2121251 defendant Glasier Thomas husbandman 589769 589769 Glasier, Thomas, of Sandon, husbandman 0
4275132 2121251 2121251 defendant Solme or Soline or Some Ralph yeoman 589769 589769 Solme or Soline or Some, Ralph, of Sandon, yeoman 1
4278041 2122253 2122253 defendant Wigston Thomas yeoman 589769 589769 Wigston, Thomas, of Sandon, yeoman 0
4278715 2122490 2122490 defendant Gyll John yeoman 589769 589769 Gyll, John, of Sandon, yeoman 0
4278717 2122491 2122491 defendant Gyll John yeoman 589769 589769 Gyll, John, of Sandon, yeoman 0
4279138 2122634 2122634 defendant Hollingworth William gent 589769 589769 Hollingworth, William, of Sandon, gent 0
4279612 2122787 2122787 defendant Glasier Thomas husbandman 589769 589769 Glasier, Thomas, of Sandon, husbandman 0
4279613 2122787 2122787 defendant Solme or Soline Ralph yeoman 589769 589769 Solme or Soline, Ralph, of Sandon, yeoman 1
4280119 2122957 2122957 defendant Loryman William yeoman 589769 589769 Loryman, William, of Sandon, yeoman 0
4283148 2124005 2124005 defendant Glasier Thomas husbandman 589769 589769 Glasier, Thomas, of Sandon, husbandman 2
4313468 2134818 2134818 defendant Bygrave Richard husbandman 589769 589769 Bygrave, Richard, of Sandon, or of Dounton, Beds, husbandman 2
4317465 2136225 2136225 defendant Clowe William husbandman 589769 589769 Clowe, William, of Sandon, husbandman 0
4317952 2136391 2136391 defendant Loryaman William yeoman 589769 589769 Loryaman, William, of Sandon, yeoman 0
4336370 2142456 2142456 defendant Wigson Thomas maltman 589769 589769 Wigson, Thomas, of Sandon, maltman 0
4350234 2147342 2147342 defendant Arthure Robert yeoman 589769 589769 Arthure, Robert, of Sandon, yeoman 0
4357224 2149754 2149754 defendant Lincoln Alexander husbandman 589769 589769 Lincoln, Alexander, of Sandon, husbandman 1
4365169 2152599 2152599 defendant Glasier Thomas husbandman 589769 589769 Glasier, Thomas, of Sandon, husbandman 0
4379734 2157846 2157846 defendant Blowe Giles husbandman 589769 589769 Blowe, Giles, of Sandon, husbandman 0
4388785 2160881 2160881 defendant Wigson Thomas loader 589769 589769 Wigson, Thomas, of Sandon, loader 1
4393085 2162297 2162297 defendant Arter Robert gent 589769 589769 Arter, Robert, of Sandon, gent 0
4401850 2165216 2165216 defendant Wigson Thomas husbandman 589769 589769 Wigson, Thomas, of Sandon, husbandman 0
4430980 2174444 2174444 defendant Russel John   589769 589769 Russel, John, of Sandon 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);