names

409 rows where place_id = 586442

✎ 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
3588733 1864119 1864119 defendant Stokeman John baker 586442 586442 Stokeman, John, of Honyton, baker 0
3605300 1869322 1869322 defendant Wolcote William merchant 586442 586442 Wolcote, William, of Honyton, merchant 0
3605945 1869521 1869521 defendant Dune Robert chaplain 586442 586442 Dune, Robert, of Honyton, chaplain 0
3608817 1870419 1870419 defendant Hewe William dyer 586442 586442 Hewe, William, of Honyton, dyer 0
3616887 1872913 1872913 defendant Wode John weaver 586442 586442 Wode, John, of Honyton, weaver 2
3632799 1905069 1905069 defendant Balston John butcher 586442 586442 Balston, John, of Honyton, butcher 0
3633901 1905412 1905412 defendant Waye John mercer 586442 586442 Waye, John, of Honyton, mercer 0
3639339 1907113 1907113 defendant Stone William tucker 586442 586442 Stone, William, of Honyton, tucker 0
3643302 1908330 1908330 defendant Lynacre Thomas   586442 586442 Lynacre, Thomas, of Honyton, surgeon 0
3643455 1908380 1908380 defendant Hoper Nicholas harper 586442 586442 Hoper, Nicholas, of Honyton, harper 1
3657234 1912525 1912525 defendant Reyment John husbandman 586442 586442 Reyment, John, of Honyton, husbandman 0
3668167 1915990 1915990 defendant Baston John miller 586442 586442 Baston, John, of Honyton, miller 0
3668168 1915990 1915990 defendant Goby Thomas baker 586442 586442 Goby, Thomas, of Honyton, baker 1
3668169 1915990 1915990 defendant Smyth John tucker 586442 586442 Smyth, John, of Honyton, tucker 2
3668170 1915990 1915990 defendant Brynte Robert husbandman 586442 586442 Brynte, Robert, of Honyton, husbandman 3
3668171 1915990 1915990 defendant Trerewe Thomas laborer 586442 586442 Trerewe, Thomas, of Honyton, laborer 4
3668177 1915992 1915992 defendant Brent Robert husbandman 586442 586442 Brent, Robert, of Honyton, husbandman 0
3670848 1916847 1916847 defendant Emberley John tanner 586442 586442 Emberley, John, of Honyton, tanner 0
3671235 1916977 1916977 defendant Evys Thomas capper 586442 586442 Evys, Thomas, of Honyton, capper 0
3677767 1919094 1919094 defendant Goby Thomas baker 586442 586442 Goby, Thomas, of Honyton, baker 0
3692376 1923789 1923789 defendant Fyssemere John tucker 586442 586442 Fyssemere, John, of Honyton, tucker 0
3692377 1923789 1923789 defendant Henley William   586442 586442 Henley, William, of Honyton, groom 1
3698290 1925683 1925683 defendant Lyset William painter 586442 586442 Lyset, William, of Honyton, painter 1
3705440 1927990 1927990 defendant Hewe John yeoman 586442 586442 Hewe, John, of Honyton, yeoman 0
3706351 1928275 1928275 defendant Hywes John yeoman 586442 586442 Hywes, John, of Honyton, yeoman 0
3706353 1928276 1928276 defendant Hywes John yeoman 586442 586442 Hywes, John, of Honyton, yeoman 0
3706354 1928276 1928276 defendant Elys John glover 586442 586442 Elys, John, of Honyton, glover 1
3707705 1928705 1928705 defendant Bronscombe Henry yeoman 586442 586442 Bronscombe, Henry, of Honyton, yeoman 1
3709021 1929117 1929117 defendant Hewes John yeoman 586442 586442 Hewes, John, of Honyton, yeoman 0
3710344 1929554 1929554 defendant Hugh William yeoman 586442 586442 Hugh, William, of Honyton, yeoman 0
3710442 1929584 1929584 defendant Hugh John yeoman 586442 586442 Hugh, John, of Honyton, yeoman 1
3711922 1930043 1930043 defendant Apryse William painter 586442 586442 Apryse, William, of Honyton, painter 0
3720226 1932601 1932601 defendant Hugh John yeoman 586442 586442 Hugh, John, of Honyton, yeoman 0
3722910 1933430 1933430 defendant Martyn John   586442 586442 Martyn, John, of Honyton, groom 3
3725056 1934122 1934122 defendant Hugh John dyer 586442 586442 Hugh, John, of Honyton, dyer 0
3725058 1934123 1934123 defendant Hugh John dyer 586442 586442 Hugh, John, of Honyton, dyer 0
3743123 1939706 1939706 defendant Turnebole John innholder 586442 586442 Turnebole, John, of Honyton, innholder 0
3743755 1939930 1939930 defendant Lumman John glover 586442 586442 Lumman, John, of Honyton, glover 0
3766219 1947085 1947085 defendant Balston John butcher 586442 586442 Balston, John, of Honyton, butcher 0
3767401 1947448 1947448 defendant Loman alias Glovyer John yeoman 586442 586442 Loman alias Glovyer, John, of Honyton, yeoman 0
3794336 1956105 1956105 defendant Monke John dyer 586442 586442 Monke, John, of Honyton, dyer 0
3794838 1956256 1956256 defendant Hugh John husbandman 586442 586442 Hugh, John, of Honyton, husbandman 3
3799156 1957646 1957646 defendant Monke John mercer 586442 586442 Monke, John, of Honyton, mercer 0
3801997 1958520 1958520 defendant Northcote Thomas tailor 586442 586442 Northcote, Thomas, of Honyton, tailor 0
3804252 1959262 1959262 defendant Hugh John yeoman 586442 586442 Hugh, John, of Honyton, yeoman 1
3807225 1960156 1960156 defendant Monke John merchant 586442 586442 Monke, John, of Honyton, merchant 1
3807376 1960214 1960214 defendant Monke John merchant 586442 586442 Monke, John, of Honyton, merchant 1
3810687 1961240 1961240 defendant Monke John merchant 586442 586442 Monke, John, of Honyton, merchant 1
3810713 1961250 1961250 defendant Monke John merchant 586442 586442 Monke, John, of Honyton, merchant 0
3818371 1963644 1963644 defendant Moncke John   586442 586442 Moncke, John, of Honyton, franklin 0
3820104 1964166 1964166 defendant Semer John innholder 586442 586442 Semer, John, of Honyton, innholder 0
3823906 1965348 1965348 defendant Pryce William painter 586442 586442 Pryce, William, of Honyton, painter 0
3827219 1966378 1966378 defendant Symme Richard innholder 586442 586442 Symme, Richard, of Honyton, innholder 0
3830795 1967513 1967513 defendant Hewyshe John innholder 586442 586442 Hewyshe, John, of Honyton, innholder 0
3832352 1968036 1968036 defendant Hugh John husbandman 586442 586442 Hugh, John, of Honyton, husbandman 0
3837013 1969488 1969488 defendant Troubylfeld John husbandman 586442 586442 Troubylfeld, John, of Honyton, husbandman 0
3838353 1969915 1969915 defendant Syme Richard innholder 586442 586442 Syme, Richard, of Honyton, innholder 1
3848926 1973257 1973257 defendant Monke John, junior merchant 586442 586442 Monke, John, junior, of Honyton, merchant 0
3848929 1973258 1973258 defendant Symmes Richard innholder 586442 586442 Symmes, Richard, of Honyton, innholder 0
3848931 1973259 1973259 defendant Monke John, junior merchant 586442 586442 Monke, John, junior, of Honyton, merchant 0
3849404 1973411 1973411 defendant Troberfyld John husbandman 586442 586442 Troberfyld, John, of Honyton, husbandman 0
3851961 1974203 1974203 defendant Symmys Richard innholder 586442 586442 Symmys, Richard, of Honyton, innholder 0
3853056 1974575 1974575 defendant Trobylfyld John merchant 586442 586442 Trobylfyld, John, of Honyton, merchant 0
3854551 1975066 1975066 defendant Symme Richard innholder 586442 586442 Symme, Richard, of Honyton, innholder 0
3860821 1977111 1977111 defendant Glovyar alias Loman John glover 586442 586442 Glovyar alias Loman, John, of Honyton, glover 0
3861397 1977282 1977282 defendant Monke Andrew merchant 586442 586442 Monke, Andrew, of Honyton, merchant 0
3861398 1977282 1977282 defendant Monke John merchant 586442 586442 Monke, John, of Honyton, merchant 1
3864701 1978388 1978388 defendant Trobulfeld John merchant 586442 586442 Trobulfeld, John, of Honyton, merchant 0
3867504 1979366 1979366 defendant Trobylfeld John merchant 586442 586442 Trobylfeld, John, of Honyton, merchant 0
3867697 1979432 1979432 defendant Balstone John butcher 586442 586442 Balstone, John, of Honyton, butcher 2
3868341 1979652 1979652 defendant Caloe John (legal representative) 586442 586442 Caloe, John, of Honyton, innholder, executrix of 0
3868342 1979652 1979652 defendant Caloe Florence widow 586442 586442 Caloe, Florence, of Honyton, widow 1
3881256 1983999 1983999 defendant Monke John merchant 586442 586442 Monke, John, of Honyton, merchant 0
3881257 1983999 1983999 defendant Monke Andrew husbandman 586442 586442 Monke, Andrew, of Honyton, husbandman 1
3881490 1984073 1984073 defendant Trobylsferld John merchant 586442 586442 Trobylsferld, John, of Honyton, merchant 0
3882263 1984325 1984325 defendant Monke John merchant 586442 586442 Monke, John, of Honyton, merchant 0
3886330 1985682 1985682 defendant Monke Andrew mercer 586442 586442 Monke, Andrew, of Honyton, mercer 2
3895037 1988549 1988549 defendant Monke John merchant 586442 586442 Monke, John, of Honyton, merchant 1
3897308 1989319 1989319 defendant Monke Andrew merchant 586442 586442 Monke, Andrew, of Honyton, merchant 0
3897309 1989319 1989319 defendant Monke John merchant 586442 586442 Monke, John, of Honyton, merchant 1
3901173 1990619 1990619 defendant Fletcher William chapman 586442 586442 Fletcher, William, of Honyton, chapman 3
3904919 1991906 1991906 defendant Monke Andrew yeoman 586442 586442 Monke, Andrew, of Honyton, yeoman 0
3910903 1993969 1993969 defendant Wescote Edward husbandman 586442 586442 Wescote, Edward, of Honyton, husbandman 0
3918667 1996571 1996571 defendant Monke John yeoman 586442 586442 Monke, John, of Honyton, yeoman 0
3922677 1997900 1997900 defendant Monke John yeoman 586442 586442 Monke, John, of Honyton, yeoman 0
3922678 1997900 1997900 defendant Forde Thomas husbandman 586442 586442 Forde, Thomas, of Honyton, husbandman 1
3925447 1998823 1998823 defendant Monke John merchant 586442 586442 Monke, John, of Honyton, merchant 1
3925970 1999003 1999003 defendant Thyrkyll alias Fleccher William mercer 586442 586442 Thyrkyll alias Fleccher, William, of Honyton, mercer 0
3932012 2001008 2001008 defendant Monke John yeoman 586442 586442 Monke, John, of Honyton, yeoman 0
3935545 2002198 2002198 defendant Mouncke John yeoman 586442 586442 Mouncke, John, of Honyton, yeoman 0
3937459 2002864 2002864 defendant Mouncke John yeoman 586442 586442 Mouncke, John, of Honyton, yeoman 0
3939441 2003496 2003496 defendant Monke John gent 586442 586442 Monke, John, of Honyton, gent 0
3940863 2003952 2003952 defendant Turvervyle Richard clothier 586442 586442 Turvervyle, Richard, of Honyton, clothier 0
3941416 2004136 2004136 defendant Monke John gent 586442 586442 Monke, John, of Honyton, gent 0
3947427 2006173 2006173 defendant Mownke John gent 586442 586442 Mownke, John, of Honyton, gent 3
3948017 2006370 2006370 defendant Lane alias Delande Nicholas husbandman 586442 586442 Lane alias Delande, Nicholas, of Honyton, husbandman 0
3950403 2007223 2007223 defendant Gregorye Thomas merchant 586442 586442 Gregorye, Thomas, of Honyton, merchant 0
3950404 2007223 2007223 defendant Holyngere Richard yeoman 586442 586442 Holyngere, Richard, of Honyton, yeoman 1
3953674 2008362 2008362 defendant Fysshemore William husbandman 586442 586442 Fysshemore, William, of Honyton, husbandman 0
3955346 2008937 2008937 defendant Moncke John merchant 586442 586442 Moncke, John, of Honyton, merchant 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);