names

555 rows where place_id = 585871

✎ 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
3587391 1863700 1863700 defendant Best Richard merchant 585871 585871 Best, Richard, of Taunton, Soms, merchant 1
3587586 1863765 1863765 defendant Best Richard merchant 585871 585871 Best, Richard, of Taunton, Soms, merchant 1
3587590 1863766 1863766 defendant Best Richard merchant 585871 585871 Best, Richard, of Taunton, Soms, merchant 2
3589857 1864468 1864468 defendant Sarger John gent 585871 585871 (Sarger, John, of Taunton, Soms, gent 1
3594209 1865830 1865830 defendant Burton John merchant 585871 585871 Burton, John, of Taunton, Soms, merchant 2
3596344 1866488 1866488 defendant Speler Thomas chapman 585871 585871 Speler, Thomas, of Taunton, Soms, chapman 0
3601042 1867993 1867993 defendant Best John, junior weaver 585871 585871 Best, John, junior, of Taunton, Soms, weaver 0
3601044 1867994 1867994 defendant Best John, junior weaver 585871 585871 Best, John, junior, of Taunton, Soms, weaver 0
3601066 1868000 1868000 plaintiff Adam Lawrence merchant 585871 585871 Adam, Lawrence, of Taunton, Soms, merchant 0
3602425 1868418 1868418 plaintiff Burton Agnes widow 585871 585871 Burton, Agnes, of Taunton, Soms, widow 1
3607297 1869943 1869943 defendant Aubrey William merchant 585871 585871 Aubrey, William, of Taunton, Soms, merchant 0
3614743 1872261 1872261 plaintiff Burton Agnes widow 585871 585871 Burton, Agnes, of Taunton, Soms, widow 1
3614748 1872262 1872262 plaintiff Burton Agnes widow 585871 585871 Burton, Agnes, of Taunton, Soms, widow 1
3620245 1873910 1873910 defendant Sawyer alias Taylour Margaret widow 585871 585871 Sawyer alias Taylour, Margaret, of Taunton, Soms, widow 0
3628939 1903927 1903927 defendant Witlond alias Dowlyn Nicholas merchant 585871 585871 Witlond alias Dowlyn, Nicholas, of Taunton, Soms, merchant 0
3635688 1905962 1905962 defendant Adams John merchant 585871 585871 Adams, John, of Taunton, Soms, merchant 0
3644767 1908768 1908768 defendant Whitlond alias Dowlyng Nicholas merchant 585871 585871 Whitlond alias Dowlyng, Nicholas, of Taunton, Soms, merchant 0
3644769 1908769 1908769 defendant Whitlond alias Dowlyng Nicholas merchant 585871 585871 Whitlond alias Dowlyng, Nicholas, of Taunton, Soms, merchant 0
3646034 1909157 1909157 defendant Adams John, senior merchant 585871 585871 Adams, John, senior, of Taunton, Soms, merchant 0
3646406 1909271 1909271 defendant Adams John merchant 585871 585871 Adams, John, of Taunton, Soms, merchant 0
3653659 1911408 1911408 defendant Baker Roger merchant 585871 585871 Baker, Roger, of Taunton, Soms, merchant 0
3654170 1911566 1911566 defendant Carvanel William merchant 585871 585871 Carvanel, William, of Taunton, Soms, merchant 2
3660769 1913631 1913631 defendant Sarger Walter merchant 585871 585871 Sarger, Walter, of Taunton, Soms, merchant 1
3668203 1916002 1916002 defendant Vynehey William merchant 585871 585871 Vynehey, William, of Taunton, Soms, merchant 0
3668548 1916122 1916122 defendant Fawcet John dyer 585871 585871 Fawcet, John, of Taunton, Soms, dyer 0
3679253 1919575 1919575 defendant James Robert gent 585871 585871 James, Robert, of Taunton, Soms, gent 1
3679701 1919719 1919719 defendant Berewey Alexander weaver 585871 585871 Berewey, Alexander, of taunton, Soms, weaver 0
3684913 1921414 1921414 defendant Vynehay William merchant 585871 585871 Vynehay, William, of Taunton, Soms, merchant 0
3702972 1927201 1927201 defendant Fuller Robert mercer 585871 585871 Fuller, Robert, of Taunton, Soms, mercer 0
3702974 1927202 1927202 defendant Fuller Robert mercer 585871 585871 Fuller, Robert, of Taunton, Soms, mercer 0
3712984 1930384 1930384 defendant Fuller Robert mercer 585871 585871 Fuller, Robert, of Taunton, Soms, mercer 0
3733910 1936851 1936851 defendant Alegh Thomas yeoman 585871 585871 Alegh, Thomas, of Taunton, Soms, yeoman 1
3761895 1945727 1945727 defendant Adams John merchant 585871 585871 Adams, John, of Taunton, Soms, merchant 0
3766915 1947317 1947317 defendant Symond Thomas mercer 585871 585871 Symond, Thomas, of Taunton, Soms, mercer 4
3796052 1956627 1956627 defendant Frank John merchant 585871 585871 Frank, John, of Taunton, Soms, merchant 0
3799153 1957645 1957645 defendant Hamond John chapman 585871 585871 Hamond, John, of Taunton, Soms, chapman 0
3818928 1963820 1963820 defendant Soper John gent 585871 585871 Soper, John, of Taunton, Soms, gent 0
3820195 1964197 1964197 defendant Hill John merchant 585871 585871 Hill, John, of Taunton, Soms, merchant 1
3822690 1964998 1964998 defendant Hyll John merchant 585871 585871 Hyll, John, of Taunton, Soms, merchant 0
3830792 1967512 1967512 defendant Adams John merchant 585871 585871 Adams, John, of Taunton, Soms, merchant 0
3832605 1968121 1968121 defendant Meffelyn Thomas merchant 585871 585871 Meffelyn, Thomas, of Taunton, Soms, merchant 0
3833833 1968513 1968513 defendant Davye William chapman 585871 585871 Davye, William, of Taunton, Soms, chapman 1
3849086 1973311 1973311 defendant Carnvenyall John merchant 585871 585871 Carnvenyall, John, of Taunton, Soms, merchant 0
3854953 1975193 1975193 defendant Stone Thomas embroiderer 585871 585871 Stone, Thomas, of Taunton, Soms, embroiderer 0
3854960 1975194 1975194 defendant Stone Thomas embroiderer 585871 585871 Stone, Thomas, of Taunton, Soms, embroiderer 0
3859752 1976761 1976761 defendant Parke William chapman 585871 585871 Parke, William, of Taunton, Soms, chapman 4
3862614 1977690 1977690 defendant Hill Robert yeoman 585871 585871 Hill, Robert, of Taunton, Soms, yeoman 0
3862616 1977691 1977691 defendant Hyll Robert yeoman 585871 585871 Hyll, Robert, of Taunton, Soms, yeoman 0
3862618 1977692 1977692 defendant Hyll Robert yeoman 585871 585871 Hyll, Robert, of Taunton, Soms, yeoman 0
3862620 1977693 1977693 defendant Hyll Robert yeoman 585871 585871 Hyll, Robert, of Taunton, Soms, yeoman 0
3867071 1979224 1979224 defendant Carvanell John merchant 585871 585871 Carvanell, John, of Taunton, Soms, merchant 2
3874090 1981555 1981555 defendant Collys Richard merchant 585871 585871 Collys, Richard, of Taunton, Soms, merchant 0
3889296 1986657 1986657 defendant Nethway John gent 585871 585871 Nethway, John, of Taunton, Soms, gent 0
3889299 1986658 1986658 defendant Nethway John gent 585871 585871 Nethway, John, of Taunton, Soms, gent 0
3892099 1987609 1987609 defendant Clerke Adam   585871 585871 Clerke, Adam, of Taunton, Soms, "hardarman" 0
3896177 1988924 1988924 defendant Chapleyn Richard merchant 585871 585871 Chapleyn, Richard, of Taunton, Soms, merchant 0
3896179 1988925 1988925 defendant Chapleyn Richard merchant 585871 585871 Chapleyn, Richard, of Taunton, Soms, merchant 0
3900813 1990502 1990502 defendant Phillype David capper 585871 585871 Phillype, David, of Taunton, Soms, capper 0
3907924 1992941 1992941 defendant Sherley John gent 585871 585871 Sherley, John, of Taunton, Soms, gent 1
3924227 1998412 1998412 defendant Kenford William merchant 585871 585871 Kenford, William, of Taunton, Soms, merchant 0
3926396 1999154 1999154 defendant Chaplan William merchant 585871 585871 Chaplan, William, of Taunton, Soms, merchant 0
3929876 2000334 2000334 defendant Lambe Thomas clothier 585871 585871 Lambe, Thomas, of Taunton, Soms, clothier 0
3934495 2001833 2001833 defendant Saull John (legal representative) 585871 585871 Saull, John, of Taunton, Soms, administratrix of 1
3935932 2002334 2002334 defendant Femell John   585871 585871 Femell, John, of Taunton, Soms, gold smith 0
3948414 2006509 2006509 defendant Love Philip merchant 585871 585871 Love, Philip, of Taunton, Soms, merchant 0
3950700 2007318 2007318 defendant Hawkyns William capper 585871 585871 Hawkyns, William, of Taunton, Soms, capper 0
3958712 2010120 2010120 defendant Bryer Walter haberdasher 585871 585871 Bryer, Walter, of Taunton, Soms, haberdasher 0
3966945 2013070 2013070 defendant Garrett Osmund goldsmith 585871 585871 Garrett, Osmund, of Taunton, Soms, goldsmith 1
3973195 2015195 2015195 defendant Chodge or Chedge Robert weaver 585871 585871 Chodge or Chedge, Robert, of Taunton, Soms, weaver 2
3974822 2015759 2015759 defendant Hester Oliver chapman 585871 585871 Hester, Oliver, of Taunton, Soms, chapman 0
3982351 2018462 2018462 defendant Grey Robert yeoman 585871 585871 Grey, Robert, of Taunton, Soms, yeoman 0
3984914 2019362 2019362 plaintiff Tolbridge Thomas tailor 585871 585871 Tolbridge, Thomas, of Taunton, Soms, tailor 0
3988499 2020630 2020630 defendant Alford John mercer 585871 585871 Alford, John, of Taunton, Soms, mercer 0
3989059 2020832 2020832 defendant Lovell William chapman 585871 585871 Lovell, William, of Taunton, Soms, chapman 0
3990512 2021358 2021358 defendant Rawlyns John chapman 585871 585871 Rawlyns, John, of Taunton, Soms, chapman 1
3994740 2022872 2022872 defendant Garrett Osmund yeoman 585871 585871 Garrett, Osmund, of Taunton, Soms, yeoman 0
3996020 2023331 2023331 defendant Goodladd Nicholas clerk 585871 585871 Goodladd, Nicholas, of Taunton, Soms, clerk 2
3996042 2023336 2023336 defendant Goodladd Nicholas clerk 585871 585871 Goodladd, Nicholas, of Taunton, Soms, clerk 2
3999009 2024404 2024404 defendant Bayly John merchant 585871 585871 Bayly, John, of Taunton, Soms, merchant 0
4002685 2025727 2025727 defendant Alfforde John chapman 585871 585871 Alfforde, John, of Taunton, Soms, chapman 0
4002690 2025728 2025728 defendant Wheler Lawrence chapman 585871 585871 Wheler, Lawrence, of Taunton, Soms, chapman 1
4002694 2025729 2025729 defendant Wyllesdon alias Wynstone William merchant 585871 585871 Wyllesdon alias Wynstone, William, of Taunton, Soms, merchant 0
4006219 2026998 2026998 defendant Chalacombe Richard weaver 585871 585871 Chalacombe, Richard, of Taunton, Soms, weaver 0
4007852 2027587 2027587 defendant More Jasper gent 585871 585871 More, Jasper, of Taunton, Soms, gent 2
4011190 2028773 2028773 defendant Tocker alias Penyngton Leonard clothier 585871 585871 Tocker alias Penyngton, Leonard, of Taunton, Soms, clothier 0
4015270 2030153 2030153 defendant Fowelles William chapman 585871 585871 Fowelles, William, of Taunton, Soms, chapman 0
4015459 2030225 2030225 defendant Fowelles William chapman 585871 585871 Fowelles, William, of Taunton, Soms, chapman 0
4015993 2030412 2030412 defendant Chaplyn John merchant 585871 585871 Chaplyn, John, of Taunton, Soms, merchant 0
4015995 2030413 2030413 defendant Chaplyn John merchant 585871 585871 Chaplyn, John, of Taunton, Soms, merchant 0
4023742 2033192 2033192 defendant Toker alias Pemton or Peniton Leonard yeoman 585871 585871 Toker alias Pemton or Peniton, Leonard, of Taunton, Soms, yeoman 1
4024546 2033453 2033453 defendant Porter Mark   585871 585871 Porter, Mark, of Taunton, Soms, chapman, apothecary 0
4024548 2033454 2033454 defendant Portor Mark chapman and apothecary 585871 585871 Portor, Mark, of Taunton, Soms, chapman and apothecary 0
4032609 2036312 2036312 defendant Hawkyns William capper 585871 585871 Hawkyns, William, of Taunton, Soms, capper 0
4032611 2036313 2036313 defendant Hawkyns William capper 585871 585871 Hawkyns, William, of Taunton, Soms, capper 0
4032813 2036390 2036390 defendant Porter Mark   585871 585871 Porter, Mark, of Taunton, Soms, yeoman, apothecary 0
4032816 2036391 2036391 defendant Porter Mark yeoman or apothecary 585871 585871 Porter, Mark, of Taunton, Soms, yeoman or apothecary 0
4040047 2038940 2038940 defendant More Jasper gent 585871 585871 More, Jasper, of Taunton, Soms, gent 0
4040460 2039081 2039081 defendant More Thomas gent 585871 585871 More, Thomas, of Taunton, Soms, gent 0
4047971 2041719 2041719 defendant Portar Martin merchant 585871 585871 Portar, Martin, of Taunton, Soms, merchant 0
4047973 2041720 2041720 defendant Porter Mark merchant 585871 585871 Porter, Mark, of Taunton, Soms, 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);