names

2,368 rows where place_id = 586958

✎ 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
3590089 1864541 1864541 defendant Aston John pinner 586958 586958 Aston, John, of Gloucester, pinner 0
3590095 1864542 1864542 defendant Aston John pinner 586958 586958 Aston, John, of Gloucester, pinner 0
3591530 1864977 1864977 defendant Sawyer William tailor 586958 586958 Sawyer, William, of Gloucester, tailor 0
3592557 1865289 1865289 defendant Heyth Thomas   586958 586958 Heyth, Thomas, of Gloucester, administrators of 0
3592558 1865289 1865289 defendant Heth Joan widow 586958 586958 (Heth, Joan, of Gloucester, widow 1
3592559 1865289 1865289 defendant Snethall John bowyer 586958 586958 Snethall, John, of Gloucester, bowyer 2
3593260 1865525 1865525 defendant Kent Robert mercer 586958 586958 Kent, Robert, of Gloucester, mercer 1
3595284 1866158 1866158 defendant Colyns Thomas spurrier 586958 586958 Colyns, Thomas, of Gloucester, spurrier 0
3595285 1866158 1866158 defendant Smert Henry butcher 586958 586958 Smert, Henry, of Gloucester, butcher 1
3595288 1866158 1866158 defendant Wayte William skinner 586958 586958 Wayte, William, of Gloucester, skinner 4
3596634 1866581 1866581 defendant Pole John gent 586958 586958 Pole, John, of Gloucester, gent 0
3597651 1866890 1866890 defendant Hartlond alias Porter John   586958 586958 Hartlond alias Porter, John, of Gloucester, card maker 0
3597652 1866890 1866890 defendant Wyght John tiler 586958 586958 Wyght, John, of Gloucester, tiler 1
3598469 1867150 1867150 defendant Cole John chapman 586958 586958 Cole, John, of Gloucester, chapman 2
3599504 1867486 1867486 defendant Wymer William   586958 586958 Wymer, William, of Gloucester, malt maker 0
3601837 1868232 1868232 defendant Heywarde Thomas yeoman 586958 586958 Heywarde, Thomas, of Gloucester, yeoman 2
3601839 1868232 1868232 defendant Elyottis John merchant 586958 586958 Elyottis, John, of Gloucester, merchant 4
3602152 1868338 1868338 defendant Arnold Thomas saddler 586958 586958 Arnold, Thomas, of Gloucester, saddler 0
3602154 1868339 1868339 defendant Arnold Thomas saddler 586958 586958 Arnold, Thomas, of Gloucester, saddler 0
3605055 1869246 1869246 defendant Apresse John gent 586958 586958 Apresse, John, of Gloucester, gent 0
3605678 1869441 1869441 defendant Bentham William gent 586958 586958 Bentham, William, of Gloucester, gent 0
3605683 1869442 1869442 defendant Bentham William gent 586958 586958 Bentham, William, of Gloucester, gent 0
3606749 1869786 1869786 defendant Wyght John brewer 586958 586958 Wyght, John, of Gloucester, brewer 2
3609702 1870703 1870703 plaintiff Roudon Walter gent 586958 586958 Roudon, Walter, of Gloucester, gent 0
3610427 1870921 1870921 defendant Hope Nicholas weaver 586958 586958 Hope, Nicholas, of Gloucester, weaver 0
3615659 1872542 1872542 plaintiff Colyns Joan widow 586958 586958 Colyns, Joan, of Gloucester, widow 0
3615660 1872542 1872542 defendant Wyght John yeoman 586958 586958 Wyght, John, of Gloucester, yeoman 0
3615661 1872543 1872543 plaintiff Colyns Joan widow 586958 586958 Colyns, Joan, of Gloucester, widow 0
3615662 1872543 1872543 defendant Wyght John yeoman 586958 586958 Wyght, John, of Gloucester, yeoman 0
3622812 1874665 1874665 defendant Acton John chapman 586958 586958 Acton, John, of Gloucester, chapman 0
3622814 1874666 1874666 defendant Cole John chapman 586958 586958 Cole, John, of Gloucester, chapman 0
3626059 1903008 1903008 defendant Gloucetur Thomas merchant 586958 586958 Gloucetur, Thomas, of Gloucester, merchant 0
3626061 1903009 1903009 defendant Gloucetur Thomas merchant 586958 586958 Gloucetur, Thomas, of Gloucester, merchant 0
3632443 1904964 1904964 defendant Bell William capper 586958 586958 Bell, William, of Gloucester, capper 1
3634530 1905602 1905602 defendant Gloucester Thomas dyer 586958 586958 Gloucester, Thomas, of Gloucester, dyer 0
3635268 1905820 1905820 defendant Astell William   586958 586958 Astell, William, of Gloucester, card maker 0
3636745 1906287 1906287 defendant Lane Agnes widow 586958 586958 Lane, Agnes, of Gloucester, widow 0
3636746 1906287 1906287 defendant Lane John brewer 586958 586958 Lane, John, of Gloucester, brewer 1
3636751 1906288 1906288 defendant Woddeward Robert butcher 586958 586958 Woddeward, Robert, of Gloucester, butcher 0
3636752 1906288 1906288 defendant Predyth Margaret widow 586958 586958 Predyth, Margaret, of Gloucester, widow 1
3636765 1906292 1906292 defendant Turbut Richard draper 586958 586958 Turbut, Richard, of Gloucester, draper 0
3637126 1906411 1906411 defendant Beke or Keke John spurrier 586958 586958 Beke or Keke, John, of Gloucester, spurrier 0
3637127 1906411 1906411 defendant Langford Richard barber 586958 586958 Langford, Richard, of Gloucester, barber 1
3637292 1906467 1906467 defendant Gloucester Thomas dyer 586958 586958 Gloucester, Thomas, of Gloucester, dyer 0
3639293 1907100 1907100 defendant A Dene John yeoman 586958 586958 A Dene, John, of Gloucester, yeoman 1
3639628 1907202 1907202 defendant Wodwell Thomas butcher 586958 586958 Wodwell, Thomas, of Gloucester, butcher 0
3639629 1907202 1907202 defendant Wellowe Richard baker 586958 586958 Wellowe, Richard, of Gloucester, baker 1
3639633 1907204 1907204 defendant Lane William husbandman 586958 586958 Lane, William, of Gloucester, husbandman 0
3639634 1907204 1907204 defendant Panter Thomas yeoman 586958 586958 Panter, Thomas, of Gloucester, yeoman 1
3640445 1907443 1907443 defendant Gloucetur Thomas merchant 586958 586958 Gloucetur, Thomas, of Gloucester, merchant 0
3642128 1907987 1907987 defendant Clackeston alias Clarkson Christopher (legal representative) 586958 586958 Clackeston alias Clarkson, Christopher, of Gloucester, mercer, executors of 0
3642916 1908237 1908237 defendant Lane John brewer 586958 586958 Lane, John, of Gloucester, brewer 0
3645160 1908894 1908894 defendant Cookys William chapman 586958 586958 Cookys, William,of Gloucester, chapman 0
3645680 1909051 1909051 defendant Colet William sherman 586958 586958 Colet, William, of Gloucester, sherman 0
3645696 1909058 1909058 defendant Welcheman John carrier 586958 586958 Welcheman, John, of Gloucester, carrier 0
3645697 1909058 1909058 defendant ap Richardys John pewterer 586958 586958 ap Richardys, John, of Gloucester, pewterer 1
3645698 1909058 1909058 defendant Beman David carrier 586958 586958 Beman, David, of Gloucester, carrier 2
3645701 1909059 1909059 defendant Welcheman John carrier 586958 586958 Welcheman, John, of Gloucester, carrier 0
3645702 1909059 1909059 defendant ap Richardys John pewterer 586958 586958 ap Richardys, John, of Gloucester, pewterer 1
3645703 1909059 1909059 defendant Beman David carrier 586958 586958 Beman, David, of Gloucester, carrier 2
3646341 1909248 1909248 defendant Dawse Thomas yeoman 586958 586958 Dawse, Thomas, of Gloucester, yeoman 1
3647161 1909502 1909502 defendant Morewode John clothier 586958 586958 Morewode, John, of Gloucester, clothier 4
3650752 1910599 1910599 defendant Gloucestre Thomas dyer 586958 586958 Gloucestre, Thomas, of Gloucester, dyer 0
3651768 1910908 1910908 plaintiff Teylowe Thomas clothier 586958 586958 Teylowe, Thomas, of Gloucester, clothier 0
3651769 1910908 1910908 defendant Prydith Thomas brewer 586958 586958 Prydith, Thomas, of Gloucester, brewer 0
3653043 1911282 1911282 defendant ap Howell Hugh tailor 586958 586958 ap Howell, Hugh, of Gloucester, tailor 0
3653084 1911294 1911294 defendant Cooke William mercer 586958 586958 Cooke, William, of Gloucester, mercer 0
3654063 1911534 1911534 defendant French alias Lane John brewer 586958 586958 French alias Lane, John, of Gloucester, brewer 0
3654065 1911534 1911534 defendant Hoper William butcher 586958 586958 Hoper, William, of Gloucester, butcher 2
3654066 1911534 1911534 defendant Tasker William   586958 586958 Tasker, William, of Gloucester, malt maker 3
3654067 1911534 1911534 defendant Sergeant William butcher 586958 586958 Sergeant, William, of Gloucester, butcher 4
3654194 1911572 1911572 defendant Cogley John husbandman 586958 586958 Cogley, John, of Gloucester, husbandman 0
3655820 1912076 1912076 defendant Proud John merchant 586958 586958 Proud, John, of Gloucester, merchant 1
3656858 1912401 1912401 defendant Berkeley Thomas   586958 586958 (Berkeley, Thomas, of Gloucester, knight 1
3659125 1913112 1913112 defendant ap Harry James gent 586958 586958 ap Harry, James, of Gloucester, gent 4
3662667 1914242 1914242 defendant Woodwell Thomas butcher 586958 586958 Woodwell, Thomas, of Gloucester, butcher 0
3663328 1914454 1914454 plaintiff Parker William   586958 586958 Parker, William, of Gloucester, Abbot of St Peter's Monastery 0
3663332 1914455 1914455 plaintiff Parker William   586958 586958 Parker, William, of Gloucester, Abbot of St Peter's Monastery 0
3663333 1914455 1914455 defendant Woodwell Thomas butcher 586958 586958 Woodwell, Thomas, of Gloucester, butcher 0
3663335 1914456 1914456 defendant Wodwall Thomas butcher 586958 586958 Wodwall, Thomas, of Gloucester, butcher 0
3664448 1914827 1914827 defendant Prydyth John gent 586958 586958 Prydyth, John, of Gloucester, gent 0
3669678 1916455 1916455 defendant Wodewale Thomas butcher 586958 586958 Wodewale, Thomas, of Gloucester, butcher 1
3671246 1916981 1916981 defendant Predy John yeoman 586958 586958 Predy, John, of Gloucester, yeoman 0
3674251 1917988 1917988 defendant Balkreve Thomas chapman 586958 586958 Balkreve, Thomas, of Gloucester, chapman 0
3675931 1918509 1918509 plaintiff Hoper Thomas vintner 586958 586958 Hoper, Thomas, of Gloucester, vintner 0
3676644 1918733 1918733 defendant Hoper Thomas vintner 586958 586958 Hoper, Thomas, of Gloucester, vintner 0
3677086 1918871 1918871 defendant Jones John   586958 586958 Jones, John, of Gloucester 0
3677605 1919035 1919035 defendant Huntley William gent 586958 586958 Huntley, William, of Gloucester, gent 0
3678172 1919222 1919222 defendant Ardern Christopher butcher 586958 586958 Ardern, Christopher, of Gloucester, butcher 0
3681173 1920195 1920195 defendant Hoper Thomas vintner 586958 586958 Hoper, Thomas, of Gloucester, vintner 0
3681604 1920338 1920338 defendant Baker Roger baker 586958 586958 Baker, Roger, of Gloucester, baker 0
3682755 1920705 1920705 defendant Cole Edmund mercer 586958 586958 Cole, Edmund, of Gloucester, mercer 0
3682757 1920706 1920706 defendant Cole Edmund mercer 586958 586958 Cole, Edmund, of Gloucester, mercer 0
3682931 1920773 1920773 defendant Porter Roger gent 586958 586958 Porter, Roger, of Gloucester, gent 0
3683823 1921076 1921076 defendant Bostok William gent 586958 586958 Bostok, William, of Gloucester, gent 2
3691374 1923461 1923461 defendant Webbe Robert tailor 586958 586958 Webbe, Robert, of Gloucester, tailor 2
3691504 1923500 1923500 defendant Atkys William clerk 586958 586958 Atkys, William, of Gloucester, clerk 0
3693779 1924252 1924252 defendant Alen Thomas, junior tanner 586958 586958 Alen, Thomas, junior, of Gloucester, tanner 0
3693781 1924252 1924252 defendant Wynfild Thomas butcher 586958 586958 Wynfild, Thomas, of Gloucester, butcher 2
3694044 1924342 1924342 defendant Hawardyne Robert, senior innholder 586958 586958 Hawardyne, Robert, senior, of Gloucester, innholder 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);