names

460 rows where place_id = 588557

✎ 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
3594924 1866040 1866040 defendant Lokke William husbandman 588557 588557 Lokke, William, of Tyverton, husbandman 2
3625552 1875528 1875528 defendant Tappescote David tucker 588557 588557 Tappescote, David, of Tyverton Maner, tucker 0
3629282 1904019 1904019 defendant Colman Thomas husbandman 588557 588557 Colman, Thomas, of Tyverton, husbandman 2
3629283 1904019 1904019 defendant Southewode Thomas husbandman 588557 588557 Southewode, Thomas, of Tyverton, husbandman 3
3629561 1904103 1904103 defendant Bery Elias tucker 588557 588557 Bery, Elias, of Tyverton, tucker 0
3634635 1905632 1905632 defendant Benett Richard merchant 588557 588557 Benett, Richard, of Tyverton, merchant 0
3640150 1907366 1907366 defendant Rewe Richard carrier 588557 588557 Rewe, Richard, of Tyverton, carrier 1
3643296 1908329 1908329 defendant Drewe John fuller 588557 588557 Drewe, John, of Tyverton, fuller 0
3643297 1908329 1908329 defendant Nyghyngale Henry tailor 588557 588557 Nyghyngale, Henry, of Tyverton, tailor 1
3643298 1908329 1908329 defendant Bury Thomas husbandman 588557 588557 Bury, Thomas, of Tyverton, husbandman 2
3643299 1908329 1908329 defendant Parkeham Richard merchant 588557 588557 Parkeham, Richard, of Tyverton, merchant 3
3643300 1908329 1908329 defendant Drewe William merchant 588557 588557 Drewe, William, of Tyverton,merchant 4
3643636 1908438 1908438 defendant Greneway John, senior merchant 588557 588557 Greneway, John, senior, of Tyverton, merchant 0
3646397 1909268 1909268 defendant Crugge John husbandman 588557 588557 Crugge, John, of Tyverton, husbandman 0
3664739 1914921 1914921 defendant Bury Thomas yeoman 588557 588557 Bury, Thomas, of Tyverton, yeoman 0
3664740 1914921 1914921 defendant Bury Elias fuller of cloth 588557 588557 Bury, Elias, of Tyverton, fuller of cloth 1
3664741 1914921 1914921 defendant Walsheman John tailor 588557 588557 Walsheman, John, of Tyverton, tailor 2
3686046 1921795 1921795 defendant Sadler John yeoman 588557 588557 Sadler, John, of Tyverton, yeoman 2
3686838 1922043 1922043 defendant Seylake John gent 588557 588557 Seylake, John, of Tyverton, gent 0
3693286 1924110 1924110 defendant Smyth John smith 588557 588557 Smyth, John, of Tyverton, smith 0
3696230 1925041 1925041 defendant Benet Richard yeoman 588557 588557 Benet, Richard, of Tyverton, yeoman 0
3699119 1925933 1925933 defendant Olyver alias Dyer Geoffrey dyer 588557 588557 Olyver alias Dyer, Geoffrey, of Tyverton, dyer 0
3699125 1925935 1925935 defendant Bery Roger tucker 588557 588557 Bery, Roger, of Tyverton, tucker 2
3710279 1929531 1929531 defendant Plemarke Joan widow 588557 588557 Plemarke, Joan, of Tyverton, widow 0
3710280 1929531 1929531 defendant More Richard tanner 588557 588557 More, Richard, of Tyverton, tanner 1
3710281 1929532 1929532 plaintiff Selacke William gent 588557 588557 Selacke, William, of Tyverton, gent 0
3712328 1930172 1930172 defendant Benet John merchant 588557 588557 Benet, John, of Tyverton, merchant 0
3716122 1931331 1931331 defendant Copleston Nicholas gent 588557 588557 Copleston, Nicholas, of Tyverton, gent 0
3717144 1931647 1931647 defendant Coker Hugh husbandman 588557 588557 Coker, Hugh, of Tyverton, husbandman 1
3717145 1931647 1931647 defendant Kene Thomas husbandman 588557 588557 Kene, Thomas, of Tyverton, husbandman 2
3717146 1931647 1931647 defendant Kene Edward   588557 588557 Kene, Edward, of Tyverton 3
3717147 1931647 1931647 defendant Jowder Robert   588557 588557 Jowder, Robert, of Tyverton, groom 4
3717148 1931647 1931647 defendant Basset Alice spinster 588557 588557 Basset, Alice, of Tyverton, spinster 5
3721327 1932977 1932977 defendant Teygdard Thomas chapman 588557 588557 Teygdard, Thomas, of Tyverton, chapman 0
3721328 1932977 1932977 defendant Tegdart Thomas tailor 588557 588557 Tegdart, Thomas, of Tyverton, tailor 1
3726722 1934621 1934621 defendant Benet John merchant 588557 588557 Benet, John, of Tyverton, merchant 1
3726723 1934621 1934621 defendant Sadler John saddler 588557 588557 Sadler, John, of Tyverton, saddler 2
3738302 1938196 1938196 defendant Hagley Richard tucker 588557 588557 Hagley, Richard, of Tyverton, tucker 0
3742438 1939505 1939505 defendant Kyng Hugh husbandman 588557 588557 Kyng, Hugh, of Tyverton, husbandman 0
3742439 1939505 1939505 defendant Turner Agnes widow 588557 588557 Turner, Agnes, of Tyverton, widow 1
3743580 1939867 1939867 defendant Wode Thomas husbandman 588557 588557 Wode, Thomas, of Tyverton, husbandman 0
3745593 1940527 1940527 defendant Haggeley Richard tucker 588557 588557 Haggeley, Richard, of Tyverton, tucker 0
3754764 1943446 1943446 defendant Tanner Agnes widow 588557 588557 Tanner, Agnes, of Tyverton, widow 1
3755945 1943811 1943811 defendant Wormeslond Richard husbandman 588557 588557 Wormeslond, Richard, of Tyverton, husbandman 0
3755946 1943811 1943811 defendant Selake John husbandman 588557 588557 Selake, John, of Tyverton, husbandman 1
3755947 1943811 1943811 defendant Cade William husbandman 588557 588557 Cade, William, of Tyverton, husbandman 2
3758479 1944647 1944647 defendant Haggelegh Richard tucker 588557 588557 Haggelegh, Richard, of Tyverton, tucker 0
3770374 1948410 1948410 plaintiff Shute Robert   588557 588557 Shute, Robert, of Tyverton 0
3770375 1948410 1948410 defendant Jannslyn Thomas   588557 588557 Jannslyn, Thomas, of Tyverton, merchant, administrators of 0
3770376 1948410 1948410 defendant Johns Philip yeoman 588557 588557 (Johns, Philip, of Tyverton, yeoman 1
3793109 1955705 1955705 defendant Land John husbandman 588557 588557 Land, John, of Tyverton, husbandman 0
3795978 1956605 1956605 defendant Toker Edward tucker 588557 588557 Toker, Edward, of Tyverton, tucker 0
3799870 1957877 1957877 defendant Campe John husbandman 588557 588557 Campe, John, of Tyverton, husbandman 0
3804127 1959218 1959218 defendant Kene John mercer 588557 588557 Kene, John, of Tyverton, mercer 0
3804343 1959294 1959294 defendant Hyllyng John, senior tucker 588557 588557 Hyllyng, John, senior, of Tyverton, tucker 0
3804344 1959294 1959294 defendant Hyllyng Robert tucker 588557 588557 Hyllyng, Robert, of Tyverton, tucker 1
3804345 1959294 1959294 defendant Hyllyng John, junior tucker 588557 588557 Hyllyng, John, junior, of Tyverton, tucker 2
3804346 1959294 1959294 defendant Hyllyng Anthony tucker 588557 588557 Hyllyng, Anthony, of Tyverton, tucker 3
3804347 1959294 1959294 defendant Fleccher George weaver 588557 588557 Fleccher, George, of Tyverton, weaver 4
3804348 1959294 1959294 defendant Olborough William tucker 588557 588557 Olborough, William, of Tyverton, tucker 5
3805658 1959712 1959712 defendant Kyng John merchant 588557 588557 Kyng, John, of Tyverton, merchant 0
3806126 1959843 1959843 defendant Fulfford John tailor 588557 588557 Fulfford, John, of Tyverton, tailor 0
3806127 1959843 1959843 defendant Benette Richard yeoman 588557 588557 Benette, Richard, of Tyverton, yeoman 1
3817295 1963320 1963320 defendant Markes Richard merchant 588557 588557 Markes, Richard, of Tyverton, merchant 0
3820444 1964278 1964278 defendant Markys Richard merchant 588557 588557 Markys, Richard, of Tyverton, merchant 0
3822715 1965006 1965006 defendant Cade William husbandman 588557 588557 Cade, William, of Tyverton, husbandman 0
3827503 1966467 1966467 defendant Hoper Roger tucker 588557 588557 Hoper, Roger, of Tyverton, tucker 0
3829761 1967200 1967200 defendant Pytwode Henry husbandman 588557 588557 Pytwode, Henry, of Tyverton, husbandman 0
3834415 1968710 1968710 defendant Southwode Richard weaver 588557 588557 Southwode, Richard, of Tyverton, weaver 0
3834416 1968710 1968710 defendant Berd John tucker 588557 588557 Berd, John, of Tyverton, tucker 1
3835085 1968913 1968913 defendant Mogerugge John tucker 588557 588557 Mogerugge, John, of Tyverton, tucker 0
3837362 1969596 1969596 defendant Greneway Joan widow 588557 588557 Greneway, Joan, of Tyverton, widow 1
3838349 1969914 1969914 defendant Bery Elias merchant 588557 588557 Bery, Elias, of Tyverton, merchant 0
3838350 1969914 1969914 defendant Bery Edward husbandman 588557 588557 Bery, Edward, of Tyverton, husbandman 1
3844819 1971923 1971923 plaintiff Deyman John   588557 588557 Deyman, John, of Tyverton 0
3844954 1971969 1971969 defendant Bowryng John   588557 588557 Bowryng, John, of Tyverton, franklin 0
3844976 1971978 1971978 defendant Herne Richard yeoman 588557 588557 Herne, Richard, of Tyverton, yeoman 4
3846293 1972396 1972396 defendant Prous John husbandman 588557 588557 Prous, John, of Tyverton, husbandman 0
3854547 1975064 1975064 defendant Lee William husbandman 588557 588557 Lee, William, of Tyverton, husbandman 0
3859870 1976805 1976805 defendant Rede John butcher 588557 588557 Rede, John, of Tyverton, butcher 1
3860551 1977023 1977023 defendant Rede John butcher 588557 588557 Rede, John, of Tyverton, butcher 0
3861481 1977300 1977300 defendant Bury Elias merchant 588557 588557 Bury, Elias, of Tyverton, merchant 0
3864784 1978417 1978417 defendant Meryck Henry yeoman 588557 588557 Meryck, Henry, of Tyverton, yeoman 0
3867696 1979432 1979432 defendant Bury Elias tucker 588557 588557 Bury, Elias, of Tyverton, tucker 1
3867700 1979433 1979433 defendant Bury Elias tucker 588557 588557 Bury, Elias, of Tyverton, tucker 1
3870070 1980231 1980231 defendant Bury Elias merchant 588557 588557 Bury, Elias, of Tyverton, merchant 0
3870639 1980421 1980421 defendant Popham Nicholas fuller 588557 588557 Popham, Nicholas, of Tyverton, fuller 0
3870640 1980421 1980421 defendant Style James fuller 588557 588557 Style, James, of Tyverton, fuller 1
3871085 1980583 1980583 defendant Capon Richard yeoman 588557 588557 Capon, Richard, of Tyverton, yeoman 0
3871086 1980583 1980583 defendant Tratte Martin merchant 588557 588557 Tratte, Martin, of Tyverton, merchant 1
3873444 1981334 1981334 defendant Avery alias Lye Thomas merchant 588557 588557 Avery alias Lye, Thomas, of Tyverton, merchant 0
3873995 1981524 1981524 defendant Lawys William merchant 588557 588557 Lawys, William, of Tyverton, merchant 0
3874961 1981848 1981848 defendant Aubre Thomas merchant 588557 588557 Aubre, Thomas, of Tyverton, merchant 1
3875562 1982064 1982064 defendant Bury Elias merchant 588557 588557 Bury, Elias, of Tyverton, merchant 0
3880532 1983746 1983746 defendant Markes Richard merchant 588557 588557 Markes, Richard, of Tyverton, merchant 1
3882696 1984478 1984478 defendant Bury Elias merchant 588557 588557 Bury, Elias, of Tyverton, merchant 0
3882697 1984478 1984478 defendant Bury Edward husbandman 588557 588557 Bury, Edward, of Tyverton, husbandman 1
3882714 1984482 1984482 defendant Bury Elias merchant 588557 588557 Bury, Elias, of Tyverton, merchant 0
3882716 1984483 1984483 defendant Bury Edward husbandman 588557 588557 Bury, Edward, of Tyverton, husbandman 0
3890682 1987149 1987149 defendant Skynner John merchant 588557 588557 Skynner, John, of Tyverton, merchant 1

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