names

225 rows where place_id = 591227

✎ 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
3591567 1864988 1864988 defendant Goodman John husbandman 591227 591227 Goodman, John, of Hope under Dynmore, husbandman 1
3591568 1864988 1864988 defendant Grene John husbandman 591227 591227 Grene, John, of Hope under Dynmore, husbandman 2
3598967 1867306 1867306 defendant Goodman John   591227 591227 Goodman, John, of Hope under Dynnemore 2
3603777 1868851 1868851 defendant Wodrose Edmund gent 591227 591227 Wodrose, Edmund, of Hope, gent, son of Wodrose, Oliver, of Hope, gent 0
3603778 1868851 1868851 defendant Staley Christopher yeoman 591227 591227 Staley, Christopher, of Hope, yeoman 1
3603780 1868852 1868852 defendant Wodrose Edmund gent 591227 591227 Wodrose, Edmund, of Hope, gent, son of Wodrose, Oliver, of Hope, gent 0
3603781 1868852 1868852 defendant Staley Christopher yeoman 591227 591227 Staley, Christopher, of Hope, yeoman 1
3610228 1870864 1870864 defendant Eyre Nicholas gent 591227 591227 Eyre, Nicholas, of Hope, gent 2
3611983 1871408 1871408 defendant Eyre Nicholas gent 591227 591227 Eyre, Nicholas, of Hope, gent 0
3611984 1871408 1871408 defendant Lee Randolph gent 591227 591227 Lee, Randolph, of Hope, gent 1
3611985 1871408 1871408 defendant Treket Ralph husbandman 591227 591227 Treket, Ralph, of Hope, husbandman 2
3611986 1871408 1871408 defendant Eyre Richard husbandman 591227 591227 Eyre, Richard, of Hope, husbandman 3
3611987 1871408 1871408 defendant Dun Roger husbandman 591227 591227 Dun, Roger, of Hope, husbandman 4
3611988 1871408 1871408 defendant Slake Oliver laborer 591227 591227 Slake, Oliver, of Hope, laborer 5
3611989 1871408 1871408 defendant Slake John husbandman 591227 591227 Slake, John, of Hope, husbandman 6
3611990 1871408 1871408 defendant Eyre William husbandman 591227 591227 Eyre, William, of Hope, husbandman 7
3611991 1871408 1871408 defendant Treket John husbandman 591227 591227 Treket, John, of Hope, husbandman 8
3611994 1871408 1871408 defendant Bokkyng William husbandman 591227 591227 Bokkyng, William, of Hope, husbandman 11
3611995 1871408 1871408 defendant Bokkyng Denis laborer 591227 591227 Bokkyng, Denis, of Hope, laborer 12
3611997 1871408 1871408 defendant Slake Ralph husbandman 591227 591227 Slake, Ralph, of Hope, husbandman 14
3611998 1871408 1871408 defendant Bokkyng John laborer 591227 591227 Bokkyng, John, of Hope, laborer 15
3611999 1871408 1871408 defendant Treket Thomas husbandman 591227 591227 Treket, Thomas, of Hope, husbandman 16
3612000 1871408 1871408 defendant Marchall Roger husbandman 591227 591227 Marchall, Roger, of Hope, husbandman 17
3612001 1871408 1871408 defendant Hethcote Thomas husbandman 591227 591227 Hethcote, Thomas, of Hope, husbandman 18
3612002 1871408 1871408 defendant Bore Henry husbandman 591227 591227 Bore, Henry, of Hope, husbandman 19
3612005 1871409 1871409 defendant Eyre Nicholas gent 591227 591227 Eyre, Nicholas, of Hope, gent 0
3612006 1871409 1871409 defendant Lee Randolph gent 591227 591227 Lee, Randolph, of Hope, gent 1
3612007 1871409 1871409 defendant Treket Ralph husbandman 591227 591227 Treket, Ralph, of Hope, husbandman 2
3612008 1871409 1871409 defendant Eyre Richard husbandman 591227 591227 Eyre, Richard, of Hope, husbandman 3
3612009 1871409 1871409 defendant Dun Roger husbandman 591227 591227 Dun, Roger, of Hope, husbandman 4
3612027 1871410 1871410 defendant Eyre Nicholas gent 591227 591227 Eyre, Nicholas, of Hope, gent 0
3612028 1871410 1871410 defendant Lee Randolph gent 591227 591227 Lee, Randolph, of Hope, gent 1
3612029 1871410 1871410 defendant Treket Ralph husbandman 591227 591227 Treket, Ralph, of Hope, husbandman 2
3612030 1871410 1871410 defendant Eyre Richard husbandman 591227 591227 Eyre, Richard, of Hope, husbandman 3
3612031 1871410 1871410 defendant Dun Roger husbandman 591227 591227 Dun, Roger, of Hope, husbandman 4
3617047 1872954 1872954 defendant Helom John smith 591227 591227 Helom, John, of Hope, smith 1
3638217 1906773 1906773 defendant Vernon Humphrey gent 591227 591227 Vernon, Humphrey, of Hope, gent 0
3638219 1906774 1906774 defendant Vernon Humphrey gent 591227 591227 Vernon, Humphrey, of Hope, gent 0
3642003 1907948 1907948 defendant Davyes Hugh husbandman 591227 591227 Davyes, Hugh, of Hope under Dynmore, husbandman 4
3650855 1910633 1910633 defendant Marshall Humphrey husbandman 591227 591227 Marshall, Humphrey, of Hope, husbandman 0
3654686 1911724 1911724 defendant Wodddroff Katherine widow 591227 591227 Wodddroff, Katherine, of Hope, widow 3
3654687 1911724 1911724 defendant Holdfynd Katherine spinster 591227 591227 Holdfynd, Katherine, of Hope, spinster 4
3666450 1915457 1915457 defendant Weston John husbandman 591227 591227 Weston, John, of Hope under Dinmore, husbandman 0
3682910 1920766 1920766 defendant Smyth John husbandman 591227 591227 Smyth, John, of Hope, husbandman 0
3682911 1920766 1920766 defendant Halle Thomas husbandman 591227 591227 Halle, Thomas, of Hope, husbandman 1
3682912 1920766 1920766 defendant (not given) George churchwardens of Wylson 591227 591227 Wylson, George, of Hope, husbandman, churchwardens of Hope 2
3686906 1922068 1922068 defendant Androwes John tiler 591227 591227 Androwes, John, of Hope under Dynmore, tiler 0
3735756 1937421 1937421 defendant Bery Thomas husbandman 591227 591227 Bery, Thomas, of Hope, husbandman 1
3779824 1951421 1951421 defendant Bagshawe William clerk 591227 591227 Bagshawe, William, of Hope, clerk 0
3779826 1951422 1951422 defendant Bagshawe William clerk 591227 591227 Bagshawe, William, of Hope, clerk 0
3839296 1970218 1970218 defendant Ewlyn Thomas husbandman 591227 591227 Ewlyn, Thomas, of Hope, husbandman 3
3841043 1970770 1970770 defendant Haghe Robert husbandman 591227 591227 Haghe, Robert, of Hope, husbandman 0
3845265 1972081 1972081 defendant Eyre Nicholas gent 591227 591227 Eyre, Nicholas, of Hope, gent 0
3855714 1975422 1975422 defendant Gwelym John yeoman 591227 591227 Gwelym, John, of Hope under Dynmore, yeoman 1
3861150 1977207 1977207 defendant Eyre Nicholas gent 591227 591227 Eyre, Nicholas, of Hope, gent 0
3861151 1977207 1977207 defendant Balgye Thomas gent 591227 591227 Balgye, Thomas, of Hope, gent 1
3892306 1987677 1987677 defendant Bowmford Edward   591227 591227 Bowmford, Edward, of Hope, pedlar 1
3892307 1987677 1987677 defendant Marshall Thrustan husbandman 591227 591227 Marshall, Thrustan, of Hope, husbandman 2
3893013 1987907 1987907 defendant Parkyns John yeoman 591227 591227 Parkyns, John, of Hope, yeoman 2
3897513 1989382 1989382 defendant Hardy William husbandman 591227 591227 Hardy, William, of Hope, husbandman 0
3897514 1989382 1989382 defendant Hardy Henry husbandman 591227 591227 Hardy, Henry, of Hope, husbandman 1
3929456 2000197 2000197 defendant Wall John yeoman 591227 591227 Wall, John, of Hope under Dynmore, yeoman 0
3929458 2000198 2000198 defendant Awall John husbandman 591227 591227 Awall, John, of Hope under Dinmore, husbandman 0
3929461 2000199 2000199 defendant Goodman William yeoman 591227 591227 Goodman, William, of Hope under Dynmore, yeoman 0
3939559 2003533 2003533 defendant Woodroff Thomas   591227 591227 Woodroff, Thomas, of Hope, gent, son & heir apparent of George 1
3939562 2003534 2003534 defendant Woodroff Thomas   591227 591227 Woodroff, Thomas, of Hope, gent, son & heir apparent of George 1
3960688 2010837 2010837 defendant Edward David husbandman 591227 591227 Edward, David, of Hope under Dynmore, husbandman 1
3972690 2015022 2015022 defendant Eyre Robert gent 591227 591227 Eyre, Robert, of Hope, gent 1
3981830 2018259 2018259 defendant Hall George husbandman 591227 591227 Hall, George, of Hope, husbandman 1
3981831 2018259 2018259 defendant Kyrke Arnold husbandman 591227 591227 Kyrke, Arnold, of Hope, husbandman 2
3983863 2019000 2019000 defendant Heathcote Ralph husbandman 591227 591227 Heathcote, Ralph, of Hope, husbandman 0
3991750 2021806 2021806 defendant Dunne Lewis husbandman 591227 591227 Dunne, Lewis, of Hope Bowdler, husbandman 2
4029624 2035233 2035233 defendant Greves John plumber 591227 591227 Greves, John, of Hope, plumber 0
4037254 2037988 2037988 defendant Thurston Tristram yeoman 591227 591227 Thurston, Tristram, of Hope, yeoman 1
4037261 2037991 2037991 defendant Thurston Tristram yeoman 591227 591227 Thurston, Tristram, of Hope, yeoman 1
4042062 2039649 2039649 plaintiff Owen Richard yeoman 591227 591227 Owen, Richard, of Hope, yeoman 0
4042064 2039650 2039650 plaintiff Owen Richard yeoman 591227 591227 Owen, Richard, of Hope, yeoman 0
4052745 2043413 2043413 defendant Phillippes alias Bucknyll John husbandman 591227 591227 Phillippes alias Bucknyll, John, of Hope Boudler, husbandman 0
4059166 2045677 2045677 defendant Phyllypp Philip weaver 591227 591227 Phyllypp, Philip, of Hope Bowdeler, weaver 2
4059170 2045678 2045678 defendant Phyllypps Philip weaver 591227 591227 Phyllypps, Philip, of Hope Bowdeler, weaver 2
4071718 2050185 2050185 defendant Woodrove Nicholas gent 591227 591227 Woodrove, Nicholas, of Hope, gent 0
4080415 2053306 2053306 defendant Ar- John husbandman 591227 591227 Ar-, John, of Hope, husbandman 1
4093512 2057995 2057995 defendant Thornell Elias yeoman 591227 591227 Thornell, Elias, of Hope, yeoman 0
4093513 2057995 2057995 defendant Thornell Nicholas yeoman 591227 591227 Thornell, Nicholas, of Hope, yeoman 1
4109867 2063788 2063788 defendant Woodrowe Nicholas gent 591227 591227 Woodrowe, Nicholas, of Hope, gent 1
4115933 2065984 2065984 defendant Hetchcott William yeoman 591227 591227 Hetchcott, William, of Hope, yeoman 2
4118483 2066903 2066903 defendant Sucker John, senior husbandman 591227 591227 Sucker, John, senior, of Hope under Dymmor, husbandman 0
4147405 2077233 2077233 defendant Perkyns John yeoman 591227 591227 Perkyns, John, of Hope, yeoman 0
4150703 2078385 2078385 defendant Hattersley Hugh miller 591227 591227 Hattersley, Hugh, of Hope, miller 3
4155589 2080036 2080036 defendant ap David Robert, junior yeoman 591227 591227 ap David, Robert, junior, of Hope, yeoman 1
4168883 2084608 2084608 defendant Woodroufe Edmund gent 591227 591227 Woodroufe, Edmund, of Hope, gent 0
4174904 2086688 2086688 defendant Bowman George laborer 591227 591227 Bowman, George, of Hope, laborer 0
4178205 2087850 2087850 defendant Screven Peter clerk 591227 591227 Screven, Peter, of Hope Bowdeler, clerk 0
4181936 2089162 2089162 defendant Slacke Ralph husbandman 591227 591227 Slacke, Ralph, of Hope, husbandman 0
4189744 2091908 2091908 defendant Woodrove Edmund, senior gent 591227 591227 Woodrove, Edmund, senior, of Hope, gent 0
4194689 2093700 2093700 defendant Woodruff Edmund gent 591227 591227 Woodruff, Edmund, of Hope, gent 1
4201328 2096021 2096021 defendant Vernon Henry gent 591227 591227 Vernon, Henry, of Hope, gent 1
4201329 2096021 2096021 defendant Chapman Elias yeoman 591227 591227 Chapman, Elias, of Hope, yeoman 2
4201331 2096021 2096021 defendant Stere Francis yeoman 591227 591227 Stere, Francis, of Hope, yeoman 4
4201500 2096071 2096071 defendant Screven Peter clerk 591227 591227 Screven, Peter, of Hope Bowedeler, clerk 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);