names

1,389 rows where place_id = 586368

✎ 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
3588534 1864058 1864058 plaintiff Beste Richard merchant 586368 586368 Beste, Richard, of Taunton, merchant 0
3588535 1864058 1864058 defendant Arnsdot Richard merchant 586368 586368 Arnsdot, Richard, of Taunton, merchant 0
3588587 1864075 1864075 defendant Nicholas John pewterer 586368 586368 Nicholas, John, of Taunton, pewterer 0
3589519 1864359 1864359 defendant Aubrey William mercer 586368 586368 Aubrey, William, of Taunton, mercer 0
3589601 1864387 1864387 defendant Laurens John   586368 586368 Laurens, John, of Taunton 0
3589603 1864388 1864388 defendant Laurens John dyer 586368 586368 Laurens, John, of Taunton, dyer 0
3589858 1864468 1864468 defendant Sarger Walter gent 586368 586368 Sarger, Walter, of Taunton, gent 2
3591232 1864882 1864882 defendant Pounde Thomas   586368 586368 Pounde, Thomas, of Taunton, hat maker 0
3591381 1864929 1864929 plaintiff Durstone Thomas tucker 586368 586368 Durstone, Thomas, of Taunton, tucker 0
3594694 1865970 1865970 defendant Bisshop Henry merchant 586368 586368 Bisshop, Henry, of Taunton, merchant 0
3597383 1866803 1866803 plaintiff Roper John merchant 586368 586368 Roper, John, of Taunton, merchant 0
3597387 1866804 1866804 defendant A Wode John dyer 586368 586368 A Wode, John, of Taunton, dyer 0
3598255 1867085 1867085 plaintiff Smyth Richard mercer 586368 586368 Smyth, Richard, of Taunton, mercer 0
3599947 1867639 1867639 plaintiff Burton Richard   586368 586368 Burton, Richard, of Taunton 1
3601070 1868002 1868002 plaintiff Adams Lawrence merchant 586368 586368 Adams, Lawrence, of Taunton, merchant 0
3602424 1868418 1868418 plaintiff Burton Richard (legal representative) 586368 586368 Burton, Richard, of Taunton, executor of Wayneflete, William, Bishop of Winchester, executrix of 0
3606455 1869688 1869688 defendant House Robert tailor 586368 586368 House, Robert, of Taunton, tailor 0
3607808 1870094 1870094 defendant Rumsey John tucker 586368 586368 Rumsey, John, of Taunton, tucker 0
3610631 1870993 1870993 defendant Mershefeld Richard tucker 586368 586368 Mershefeld, Richard, of Taunton, tucker 1
3610632 1870993 1870993 defendant Bone Henry laborer 586368 586368 Bone, Henry, of Taunton, laborer 2
3611155 1871165 1871165 defendant Irysshe Walter tucker 586368 586368 Irysshe, Walter, of Taunton, tucker 0
3612341 1871493 1871493 defendant Eston John merchant 586368 586368 Eston, John, of Taunton, merchant 0
3612779 1871647 1871647 defendant Archer Thomas dyer 586368 586368 Archer, Thomas, of Taunton, dyer 0
3614742 1872261 1872261 plaintiff Burton Richard (legal representative) 586368 586368 Burton, Richard, of Taunton, executor of Wayneflete, William, Bishop of Winchester, executrix of 0
3614747 1872262 1872262 plaintiff Burton Richard (legal representative) 586368 586368 Burton, Richard, of Taunton, executor of Waynesflete, Bishop of Winchester, executrix of 0
3614752 1872263 1872263 plaintiff Burton Richard (legal representative) 586368 586368 Burton, Richard, of Taunton, executrix of 0
3614755 1872264 1872264 plaintiff Burton Richard (legal representative) 586368 586368 Burton, Richard, of Taunton, executrix of 0
3617973 1873247 1873247 defendant Foke John tucker 586368 586368 Foke, John, of Taunton, tucker 0
3620019 1873833 1873833 defendant Burnerd John saddler 586368 586368 Burnerd, John, of Taunton, saddler 0
3620020 1873833 1873833 defendant Saddeler Thomas yeoman 586368 586368 Saddeler, Thomas, of Taunton, yeoman 1
3622323 1874518 1874518 defendant Drever or Drener John merchant 586368 586368 Drever or Drener, John, of Taunton, merchant 0
3626254 1903067 1903067 defendant Adams John, senior tucker 586368 586368 Adams, John, senior, of Taunton, tucker 0
3627324 1903396 1903396 plaintiff Bockthofte John merchant 586368 586368 Bockthofte, John, of Taunton, merchant 0
3629617 1904116 1904116 defendant Baker Roger merchant 586368 586368 Baker, Roger, of Taunton, merchant 1
3633687 1905347 1905347 plaintiff Laurens Henry (legal representative) 586368 586368 Laurens, Henry, of Taunton, roper, executors of 0
3635956 1906041 1906041 defendant Mefflyn Thomas   586368 586368 Mefflyn, Thomas, of Taunton merchant 0
3640811 1907572 1907572 defendant Serle John, junior chaplain 586368 586368 Serle, John, junior, of Taunton, chaplain 0
3641365 1907753 1907753 defendant Howley Thopmas husbandman 586368 586368 Howley, Thopmas, of Taunton, husbandman 0
3646391 1909265 1909265 defendant Gybbes John painter 586368 586368 Gybbes, John, of Taunton, painter 0
3648739 1909992 1909992 defendant Fox Thomas capper 586368 586368 Fox, Thomas, of Taunton, capper 0
3652966 1911259 1911259 defendant Cokkes John husbandman 586368 586368 Cokkes, John, of Taunton, husbandman 0
3654131 1911554 1911554 defendant Bold Isabel widow 586368 586368 Bold, Isabel, of Taunton, widow 1
3654845 1911774 1911774 defendant Pycher Thomas merchant 586368 586368 Pycher, Thomas, of Taunton, merchant 0
3660240 1913465 1913465 defendant Adam Roger merchant 586368 586368 Adam, Roger, of Taunton, merchant 0
3669424 1916375 1916375 defendant Mors William butcher 586368 586368 Mors, William, of Taunton, butcher 0
3675746 1918448 1918448 defendant Adams Roger fuller 586368 586368 Adams, Roger, of Taunton, fuller 0
3676269 1918624 1918624 defendant Adams Roger fuller 586368 586368 Adams, Roger, of Taunton, fuller 0
3677603 1919034 1919034 defendant Vaughan Thomas husbandman 586368 586368 Vaughan, Thomas, of Taunton, husbandman 1
3679702 1919719 1919719 defendant Baker Richard carrier 586368 586368 Baker, Richard, of Taunton, carrier 1
3682198 1920537 1920537 defendant Baker John tanner 586368 586368 Baker, John, of Taunton, tanner 0
3683001 1920797 1920797 defendant Stone John embroiderer 586368 586368 Stone, John, of Taunton, embroiderer 0
3683002 1920797 1920797 defendant Adams Roger tucker 586368 586368 Adams, Roger, of Taunton, tucker 1
3683003 1920797 1920797 defendant Shirforde John laborer 586368 586368 Shirforde, John, of Taunton, laborer 2
3695076 1924671 1924671 defendant Collerd William   586368 586368 Collerd, William, of Taunton, parish clerk 0
3695078 1924672 1924672 defendant Collerd William   586368 586368 Collerd, William, of Taunton, parish clerk 0
3696113 1925008 1925008 defendant Horre John clerk 586368 586368 Horre, John, of Taunton, clerk 0
3726833 1934662 1934662 defendant Fyssher Alexander merchant 586368 586368 Fyssher, Alexander, of Taunton, merchant 0
3733911 1936851 1936851 defendant Alegh William merchant 586368 586368 Alegh, William, of Taunton, merchant 2
3749552 1941773 1941773 defendant Walrond Osmund gent 586368 586368 Walrond, Osmund, of Taunton, gent 1
3756071 1943854 1943854 defendant Bolvye John tucker 586368 586368 Bolvye, John, of Taunton, tucker 1
3761896 1945727 1945727 defendant Warman William weaver 586368 586368 Warman, William, of Taunton, weaver 1
3761898 1945727 1945727 defendant Swyng Anne widow 586368 586368 Swyng, Anne, of Taunton, widow 3
3780433 1951615 1951615 plaintiff Garrett John goldsmith 586368 586368 Garrett, John, of Taunton, goldsmith 0
3782312 1952220 1952220 defendant Gore John merchant 586368 586368 Gore, John, of Taunton, merchant 0
3787510 1953882 1953882 defendant Barbor John saddler 586368 586368 Barbor, John, of Taunton, saddler 0
3793758 1955912 1955912 defendant Shomaker Lewis cordwainer 586368 586368 Shomaker, Lewis, of Taunton, cordwainer 2
3806415 1959917 1959917 defendant Love Richard goldsmith 586368 586368 Love, Richard, of Taunton, goldsmith 0
3816100 1962936 1962936 plaintiff Hewet John (legal representative) 586368 586368 Hewet, John, of Taunton, executors of 0
3819632 1964018 1964018 defendant Aly Thomas merchant 586368 586368 Aly, Thomas, of Taunton, merchant 1
3826951 1966280 1966280 defendant Hatter John yeoman 586368 586368 Hatter, John, of Taunton, yeoman 0
3826953 1966280 1966280 defendant Bacon John yeoman 586368 586368 Bacon, John, of Taunton, yeoman 2
3827148 1966353 1966353 defendant Mawteney John capper 586368 586368 Mawteney, John, of Taunton, capper 1
3830861 1967533 1967533 defendant Skabell John goldsmith 586368 586368 Skabell, John, of Taunton, goldsmith 0
3832411 1968058 1968058 defendant Androse John tucker 586368 586368 Androse, John, of Taunton, tucker 0
3832413 1968059 1968059 defendant Horssey William merchant 586368 586368 Horssey, William, of Taunton, merchant 0
3832488 1968082 1968082 defendant Rendall John innholder 586368 586368 Rendall, John, of Taunton, innholder 1
3832490 1968082 1968082 defendant Chaplyn Thomas husbandman 586368 586368 Chaplyn, Thomas, of Taunton, husbandman 3
3836004 1969173 1969173 defendant Stone John (legal representative) 586368 586368 Stone, John, of Taunton, chapman, executrix of 1
3836558 1969336 1969336 defendant Mawteney John capper 586368 586368 Mawteney, John, of Taunton, capper 1
3838263 1969885 1969885 defendant Browne John weaver 586368 586368 Browne, John, of Taunton, weaver 0
3843697 1971559 1971559 defendant Horsey William clothman 586368 586368 Horsey, William, of Taunton, clothman 0
3845272 1972083 1972083 defendant Colys Richard mercer 586368 586368 Colys, Richard, of Taunton, mercer 1
3848624 1973153 1973153 defendant Monybe Thomas yeoman 586368 586368 Monybe, Thomas, of Taunton, yeoman 1
3848923 1973256 1973256 defendant Davy William mercer 586368 586368 Davy, William, of Taunton, mercer 0
3850193 1973651 1973651 defendant Davy William mercer 586368 586368 Davy, William, of Taunton, mercer 0
3850313 1973685 1973685 plaintiff Messelyn or Meffelyn Walter merchant 586368 586368 Messelyn or Meffelyn, Walter, of Taunton, merchant 0
3850314 1973685 1973685 defendant Davy William merchant 586368 586368 Davy, William, of Taunton, merchant 0
3855300 1975293 1975293 defendant Shyrcombe William   586368 586368 Shyrcombe, William, of Taunton, millward 0
3856715 1975730 1975730 defendant Davy William mercer 586368 586368 Davy, William, of Taunton, mercer 0
3864144 1978194 1978194 defendant Davy William mercer 586368 586368 Davy, William, of Taunton, mercer 0
3865072 1978520 1978520 plaintiff Meffelyn Thomas merchant 586368 586368 Meffelyn, Thomas, of Taunton, merchant 0
3865073 1978520 1978520 defendant Davy William mercer 586368 586368 Davy, William, of Taunton, mercer 0
3878491 1983051 1983051 defendant Barbour William barber 586368 586368 Barbour, William, of Taunton, barber 1
3881134 1983960 1983960 defendant Nosse Thomas butcher 586368 586368 Nosse, Thomas, of Taunton, butcher 0
3881135 1983960 1983960 defendant Bocher Thomas buthcer 586368 586368 Bocher, Thomas, of Taunton, buthcer 1
3882099 1984270 1984270 defendant Tompson Robert bowyer 586368 586368 Tompson, Robert, of Taunton, bowyer 1
3888733 1986485 1986485 plaintiff Fennell Richard goldsmith 586368 586368 Fennell, Richard, of Taunton, goldsmith 0
3890477 1987071 1987071 defendant Pytt John weaver 586368 586368 Pytt, John, of Taunton, weaver 1
3892760 1987829 1987829 defendant Tanner John yeoman 586368 586368 Tanner, John, of Taunton, yeoman 0
3896438 1989014 1989014 defendant Belamye Barnard pewterer 586368 586368 Belamye, Barnard, of Taunton, pewterer 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);