names

345 rows where place_id = 588465

✎ 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
3594583 1865937 1865937 defendant Slyngesby William gent 588465 588465 Slyngesby, William, of Wellys, gent 0
3595473 1866219 1866219 plaintiff Mayowe John mercer 588465 588465 Mayowe, John, of Wellys, mercer 0
3598919 1867289 1867289 defendant Goldsmyth alias Wysselyn Herman goldsmith 588465 588465 Goldsmyth alias Wysselyn, Herman, of Wellys, goldsmith 0
3600349 1867753 1867753 defendant Manton or Mauton Richard vintner 588465 588465 Manton or Mauton, Richard, of Wellys, vintner 1
3602627 1868485 1868485 plaintiff Carton alias Ketylston Rose (legal representative) 588465 588465 Carton alias Ketylston, Rose, of Wellys, executor of 0
3602757 1868529 1868529 defendant Cheselet John yeoman 588465 588465 Cheselet, John, of Wellys, yeoman 1
3615191 1872397 1872397 defendant thrope George tycker 588465 588465 thrope, George, of Wellys, tycker 0
3616530 1872806 1872806 defendant Savyn or Sabyn John brewer 588465 588465 Savyn or Sabyn, John, of Wellys, brewer 0
3620901 1874100 1874100 defendant Atwyll William tanner 588465 588465 Atwyll, William, of Wellys, tanner 0
3621408 1874237 1874237 defendant Crosse William yeoman 588465 588465 Crosse, William, of Wellys, yeoman 0
3625166 1875407 1875407 defendant Thornton Nicholas yeoman 588465 588465 Thornton, Nicholas, of Wellys, yeoman 1
3625837 1875615 1875615 defendant Draper Julia widow 588465 588465 Draper, Julia, of Wellys, widow 1
3625841 1875616 1875616 defendant Draper Julia widow 588465 588465 Draper, Julia, of Wellys, widow 1
3628213 1903682 1903682 defendant Lyng John   588465 588465 Lyng, John, of Wellys 0
3638768 1906945 1906945 plaintiff Tyler John yeoman 588465 588465 Tyler, John, of Wellys, yeoman 0
3638769 1906945 1906945 defendant Mortymer Nicholas dyer 588465 588465 Mortymer, Nicholas, of Wellys, dyer 0
3638770 1906946 1906946 plaintiff Tyler John yeoman 588465 588465 Tyler, John, of Wellys, yeoman 0
3638771 1906946 1906946 defendant Mortymer Nicholas dyer 588465 588465 Mortymer, Nicholas, of Wellys, dyer 0
3641178 1907692 1907692 defendant Colwey Thomas butcher 588465 588465 Colwey, Thomas, of Wellys, butcher 0
3663290 1914444 1914444 plaintiff Parker Lewis weaver 588465 588465 Parker, Lewis, of Wellys, weaver 0
3671529 1917077 1917077 defendant Merfeld Richard husbandman 588465 588465 Merfeld, Richard, of Wellys, husbandman 3
3671530 1917077 1917077 defendant Tourner Walter husbandman 588465 588465 Tourner, Walter, of Wellys, husbandman 4
3673145 1917613 1917613 plaintiff Edmundys John (legal representative) 588465 588465 Edmundys, John, of Wellys, clerk, executors of 0
3673154 1917613 1917613 defendant Adys John plumber 588465 588465 Adys, John, of Wellys, plumber 4
3676834 1918793 1918793 defendant Goldsmyth Thomas husbandman 588465 588465 Goldsmyth, Thomas, of Wellys, husbandman 4
3695830 1924930 1924930 defendant Roche Humphrey husbandman 588465 588465 Roche, Humphrey, of Wellys, husbandman 0
3696202 1925034 1925034 defendant Smyth Richard husbandman 588465 588465 Smyth, Richard, of Wellys, husbandman 0
3696203 1925034 1925034 defendant Turner William husbandman 588465 588465 Turner, William, of Wellys, husbandman 1
3697601 1925472 1925472 defendant Lydeyard William brasier 588465 588465 Lydeyard, William, of Wellys, brasier 0
3700593 1926431 1926431 defendant Badcocke John smith 588465 588465 Badcocke, John, of Wellys, smith 2
3700594 1926431 1926431 defendant Burne Richard plumber 588465 588465 Burne, Richard, of Wellys, plumber 3
3700595 1926431 1926431 defendant Olyver Thomas clerk 588465 588465 Olyver, Thomas, of Wellys, clerk 4
3702715 1927122 1927122 defendant Cornysche Henry baker 588465 588465 Cornysche, Henry, of Wellys, baker 0
3702716 1927122 1927122 defendant Lyne John baker 588465 588465 Lyne, John, of Wellys, baker 1
3706251 1928242 1928242 defendant Awnyge William   588465 588465 Awnyge, William, of Wellys, freemason 4
3709973 1929430 1929430 defendant Turner Walter husbandman 588465 588465 Turner, Walter, of Wellys, husbandman 2
3709993 1929434 1929434 defendant Smyth Richard husbandman 588465 588465 Smyth, Richard, of Wellys, husbandman 0
3712434 1930206 1930206 plaintiff Welshott John (legal representative) 588465 588465 Welshott, John, of Wellys, mercer, executors of 0
3712438 1930207 1930207 plaintiff Welshott John (legal representative) 588465 588465 Welshott, John, of Wellys, mercer, executors of 0
3712441 1930208 1930208 plaintiff Welshotte John (legal representative) 588465 588465 Welshotte, John, of Wellys, mercer, executors of 0
3712445 1930209 1930209 plaintiff Welshotte John (legal representative) 588465 588465 Welshotte, John, of Wellys, mercer, executors of 0
3712449 1930209 1930209 defendant Whytyng Alice widow 588465 588465 Whytyng, Alice, of Wellys, widow 2
3713010 1930392 1930392 defendant Savyne or Sabyne William yeoman 588465 588465 Savyne or Sabyne, William, of Wellys, yeoman 1
3714954 1930973 1930973 defendant Pecoke Henry pewterer 588465 588465 Pecoke, Henry, of Wellys, pewterer 0
3715568 1931156 1931156 defendant Boyle Thomas draper 588465 588465 Boyle, Thomas, of Wellys, draper 0
3723121 1933497 1933497 defendant Jekler John husbandman 588465 588465 Jekler, John, of Wellys, husbandman 0
3724475 1933942 1933942 defendant Smyth Richard husbandman 588465 588465 Smyth, Richard, of Wellys, husbandman 0
3724476 1933942 1933942 defendant Turnor Walter husbandman 588465 588465 Turnor, Walter, of Wellys, husbandman 1
3732324 1936348 1936348 defendant Goldsmyth Thomas husbandman 588465 588465 Goldsmyth, Thomas, of Wellys, husbandman 0
3734401 1937001 1937001 defendant Clement Richard husbandman 588465 588465 Clement, Richard, of Wellys, husbandman 1
3746243 1940733 1940733 defendant Clement Richard   588465 588465 Clement, Richard, of Wellys, "caryer" 1
3746961 1940968 1940968 defendant Storyge Henry yeoman 588465 588465 Storyge, Henry, of Wellys, yeoman 0
3747971 1941283 1941283 defendant Caselyght Peter clerk 588465 588465 Caselyght, Peter, of Wellys, clerk 0
3747972 1941283 1941283 defendant Battyswell William yeoman 588465 588465 Battyswell, William, of Wellys, yeoman 1
3749352 1941719 1941719 defendant Beckham Robert courtholder 588465 588465 Beckham, Robert, of Wellys, courtholder 0
3749353 1941719 1941719 defendant Foxe Robert tucker 588465 588465 Foxe, Robert, of Wellys, tucker 1
3764575 1946576 1946576 defendant Gregan Jenan husbandman 588465 588465 Gregan, Jenan, of Wellys, husbandman 3
3764578 1946577 1946577 defendant Hawkyns John husbandman 588465 588465 Hawkyns, John, of Wellys, husbandman 1
3769992 1948272 1948272 defendant Foxe Robert tucker 588465 588465 Foxe, Robert, of Wellys, tucker 0
3772417 1949063 1949063 defendant Turner Henry yeoman 588465 588465 Turner, Henry, of Wellys, yeoman 0
3772418 1949063 1949063 defendant Turner Walter husbandman 588465 588465 Turner, Walter, of Wellys, husbandman 1
3773218 1949332 1949332 defendant Deverell John yeoman 588465 588465 (Deverell, John, of Wellys, yeoman 1
3777999 1950829 1950829 defendant Goldsmyth Thomas husbandman 588465 588465 Goldsmyth, Thomas, of Wellys, husbandman 0
3778225 1950897 1950897 defendant Marshall John butcher 588465 588465 Marshall, John, of Wellys, butcher 0
3778881 1951109 1951109 defendant Ryngsted Christopher yeoman 588465 588465 Ryngsted, Christopher, of Wellys, yeoman 0
3783108 1952472 1952472 defendant Clement Richard husbandman 588465 588465 Clement, Richard, of Wellys, husbandman 0
3787122 1953766 1953766 defendant Goldsmyth Thomas husbandman 588465 588465 Goldsmyth, Thomas, of Wellys, husbandman 0
3787128 1953767 1953767 defendant Goldsmyth Thomas husbandman 588465 588465 Goldsmyth, Thomas, of Wellys, husbandman 1
3790094 1954719 1954719 defendant Penaunt John clerk 588465 588465 Penaunt, John, of Wellys, clerk 0
3792351 1955468 1955468 defendant Fox John   588465 588465 Fox, John, of Wellys, Soms. clothmaker 4
3798719 1957512 1957512 defendant Turner William husbandman 588465 588465 Turner, William, of Wellys, husbandman 0
3799248 1957678 1957678 defendant Bawdon alias A Salysbury John butcher 588465 588465 Bawdon alias A Salysbury, John, of Wellys, butcher 0
3799535 1957774 1957774 defendant Godwyn John, senior weaver 588465 588465 Godwyn, John, senior, of Wellys, weaver 0
3799536 1957775 1957775 plaintiff Johns John   588465 588465 Johns, John, of Wellys 0
3799537 1957775 1957775 defendant Godwyn John, senior weaver 588465 588465 Godwyn, John, senior, of Wellys, weaver 0
3799593 1957794 1957794 defendant Buttermar Roland summoner 588465 588465 Buttermar, Roland, of Wellys, summoner 0
3799898 1957885 1957885 defendant Goldsmyth Thomas yeoman 588465 588465 Goldsmyth, Thomas, of Wellys, yeoman 0
3803393 1958962 1958962 defendant Goldsmyth Thomas husbandman 588465 588465 Goldsmyth, Thomas, of Wellys, husbandman 0
3806390 1959909 1959909 defendant Dean William carrier 588465 588465 Dean, William, of Wellys, carrier 0
3806392 1959910 1959910 defendant Deane William carrier 588465 588465 Deane, William, of Wellys, carrier 0
3807128 1960122 1960122 defendant Millet William yeoman 588465 588465 Millet, William, of Wellys, yeoman 1
3811985 1961656 1961656 defendant Cary Richard glover 588465 588465 Cary, Richard, of Wellys, glover 0
3811986 1961656 1961656 defendant Baron John   588465 588465 Baron, John, of Wellys, soap maker 1
3812066 1961684 1961684 defendant Sarger Walter clothman 588465 588465 Sarger, Walter, of Wellys, clothman 2
3816403 1963039 1963039 defendant Cary Roger glover 588465 588465 Cary, Roger, of Wellys, glover 0
3816404 1963039 1963039 defendant Dytty John clothier 588465 588465 Dytty, John, of Wellys, clothier 1
3818748 1963767 1963767 defendant Stephyns Roger husbandman 588465 588465 Stephyns, Roger, of Wellys, husbandman 0
3821245 1964535 1964535 defendant Turner Walter husbandman 588465 588465 Turner, Walter, of Wellys, husbandman 1
3836712 1969383 1969383 defendant Lacye William innholder 588465 588465 Lacye, William, of Wellys, innholder 0
3842981 1971338 1971338 defendant Thyrgate Thomas husbandman 588465 588465 Thyrgate, Thomas, of Wellys, husbandman 4
3845994 1972303 1972303 defendant Marler John   588465 588465 Marler, John, of Wellys, lime burner 0
3846148 1972350 1972350 defendant Turner Walter husbandman 588465 588465 Turner, Walter, of Wellys, husbandman 0
3847956 1972936 1972936 defendant Brodcoke John smith 588465 588465 Brodcoke, John, of Wellys, smith 0
3847957 1972936 1972936 defendant Maynard Maurice tailor 588465 588465 Maynard, Maurice, of Wellys, tailor 1
3853178 1974613 1974613 defendant Karver Richard carver 588465 588465 Karver, Richard, of Wellys, carver 0
3855200 1975258 1975258 defendant Jakluffe Thomas mariner 588465 588465 Jakluffe, Thomas, of Wellys, mariner 1
3858812 1976435 1976435 defendant Everode John, junior brasier 588465 588465 Everode, John, junior, of Wellys, brasier 0
3858813 1976435 1976435 defendant Fryers John shomeaker 588465 588465 Fryers, John, of Wellys, shomeaker 1
3865160 1978552 1978552 defendant Jekelar John yeoman 588465 588465 Jekelar, John, of Wellys, yeoman 0
3865162 1978553 1978553 defendant Jekeler John yeoman 588465 588465 Jekeler, John, of Wellys, yeoman 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);