names

363 rows where place_id = 586528

✎ 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
3588955 1864194 1864194 defendant Byrche John yeoman 586528 586528 Byrche, John, of Ware, Herts, yeoman 0
3588958 1864195 1864195 defendant Byrche John yeoman 586528 586528 Byrche, John, of Ware, Herts, yeoman 0
3591120 1864846 1864846 defendant Thawyte Richard blacksmith 586528 586528 Thawyte, Richard, of Ware, Herts, blacksmith 0
3591660 1865011 1865011 defendant Fadyr William husbandman 586528 586528 Fadyr, William, of Ware, Herts, husbandman 0
3591665 1865012 1865012 defendant Fadyr William husbandman 586528 586528 Fadyr, William, of Ware, Herts, husbandman 0
3591670 1865013 1865013 defendant Fadyr William husbandman 586528 586528 Fadyr, William, of Ware, Herts, husbandman 0
3592679 1865324 1865324 defendant Byrche John yeoman 586528 586528 Byrche, John, of Ware, Herts, yeoman 1
3592682 1865325 1865325 defendant Byrche John yeoman 586528 586528 Byrche, John, of Ware, Herts, yeoman 1
3595137 1866110 1866110 defendant Chapman Simon chapman 586528 586528 Chapman, Simon, of Ware, Herts, chapman 2
3600430 1867781 1867781 defendant Byrche John yeoman 586528 586528 Byrche, John, of Ware, Herts, yeoman 0
3601075 1868003 1868003 defendant Clerk William yeoman 586528 586528 Clerk, William, of Ware, Herts, yeoman 2
3605942 1869520 1869520 defendant Denton John chaplain 586528 586528 Denton, John, of Ware, Herts, chaplain 0
3606511 1869709 1869709 plaintiff Nodwell Charles esq 586528 586528 Nodwell, Charles, of Ware, Herts, esq 0
3612931 1871691 1871691 defendant Ronde John innholder 586528 586528 Ronde, John, of Ware, Herts, innholder 0
3612939 1871693 1871693 defendant Ronde or Roude John innholder 586528 586528 Ronde or Roude, John, of Ware, Herts, innholder 0
3613484 1871865 1871865 defendant Barbour Alexander butcher 586528 586528 Barbour, Alexander, of Ware, Herts, butcher 0
3618737 1873481 1873481 defendant Rande John innholder 586528 586528 Rande, John, of Ware, Herts, innholder 3
3618859 1873511 1873511 defendant Clerk William innholder 586528 586528 Clerk, William, of Ware, Herts, innholder 0
3627576 1903482 1903482 defendant Gynne William butcher 586528 586528 Gynne, William, of Ware, Herts, butcher 1
3651053 1910695 1910695 defendant Burch Thomas yeoman 586528 586528 Burch, Thomas, of Ware, Herts, yeoman 0
3651061 1910697 1910697 defendant Birch Thomas yeoman 586528 586528 Birch, Thomas, of Ware, Herts, yeoman 4
3653974 1911508 1911508 defendant Galowey Christopher smith 586528 586528 Galowey, Christopher, of Ware, Herts, smith 0
3657193 1912514 1912514 defendant Poyier Thomas barber 586528 586528 Poyier, Thomas, of Ware, Herts, barber 5
3668038 1915942 1915942 defendant Kay Ralph innholder 586528 586528 Kay, Ralph, of Ware, Herts, innholder 0
3672141 1917284 1917284 defendant Rodys Roger pointer 586528 586528 Rodys, Roger, of Ware, Herts, pointer 3
3683629 1921010 1921010 defendant Wynshippe William courser 586528 586528 Wynshippe, William, of Ware, Herts, courser 2
3714931 1930964 1930964 defendant Longe Robert yeoman 586528 586528 Longe, Robert, of Ware, Herts, yeoman 0
3720147 1932577 1932577 defendant Key Ralph innkeeper 586528 586528 (Key, Ralph, of Ware, Herts, innkeeper 1
3722205 1933204 1933204 defendant Fawkener alias Cotaige William husbandman 586528 586528 Fawkener alias Cotaige, William, of Ware, Herts, husbandman 0
3730458 1935757 1935757 defendant Shepard Robert cooper 586528 586528 Shepard, Robert, of Ware, Herts, cooper 0
3736182 1937558 1937558 defendant Poynar Thomas barber 586528 586528 Poynar, Thomas, of Ware, Herts, barber 1
3737283 1937897 1937897 defendant Funten William painter 586528 586528 Funten, William, of Ware, Herts, painter 0
3738077 1938126 1938126 defendant Couper Roger chandler 586528 586528 (Couper, Roger, of Ware, herts, chandler 1
3740418 1938863 1938863 defendant Hornclyff William yeoman 586528 586528 Hornclyff, William, of Ware, Herts, yeoman 4
3745964 1940645 1940645 defendant Ive Robert gent 586528 586528 Ive, Robert, of Ware, Herts, gent 0
3749658 1941804 1941804 defendant Abbot John butcher 586528 586528 Abbot, John, of Ware, Herts, butcher 1
3764714 1946627 1946627 defendant Rokes Gilbert gent 586528 586528 Rokes, Gilbert, of Ware, Herts, gent 1
3769693 1948177 1948177 plaintiff Rookes Gilbert gent 586528 586528 Rookes, Gilbert, of Ware, Herts, gent 0
3769747 1948192 1948192 plaintiff Roves or Robes Gilbert gent 586528 586528 Roves or Robes, Gilbert, of Ware, Herts, gent 0
3775095 1949942 1949942 defendant Johnson Richard goldsmith 586528 586528 Johnson, Richard, of Ware, Herts, goldsmith 1
3785855 1953365 1953365 defendant Marten John yeoman 586528 586528 Marten, John, of Ware, Herts, yeoman 0
3785860 1953367 1953367 defendant Marten John yeoman 586528 586528 Marten, John, of Ware, Herts, yeoman 1
3795854 1956568 1956568 defendant Osborne alias Clerke Christopher cordwainer 586528 586528 Osborne alias Clerke, Christopher, of Ware, Herts, cordwainer 1
3795857 1956569 1956569 defendant Osborne alias Clerke Christopher cordwainer 586528 586528 Osborne alias Clerke, Christopher, of Ware, Herts, cordwainer 1
3808273 1960461 1960461 defendant Colynwode John blacksmith 586528 586528 Colynwode, John, of Ware, Herts, blacksmith 0
3808276 1960462 1960462 defendant Dane Richard smith 586528 586528 Dane, Richard, of Ware, Herts, smith 0
3818091 1963571 1963571 defendant Kent Edward dyer 586528 586528 Kent, Edward, of Ware, Herts, dyer 1
3822867 1965059 1965059 defendant Denton John fuller 586528 586528 Denton, John, of Ware, Herts, fuller 2
3822869 1965060 1965060 defendant Purce Thomas yeoman 586528 586528 Purce, Thomas, of Ware, Herts, yeoman 0
3833989 1968572 1968572 defendant Hormede Thomas husbandman 586528 586528 Hormede, Thomas, of Ware, Herts, husbandman 1
3855897 1975468 1975468 defendant Harte John yeoman 586528 586528 Harte, John, of Ware, Herts, yeoman 0
3865281 1978597 1978597 defendant Abraham alias Vele Thomas innholder 586528 586528 Abraham alias Vele, Thomas, of Ware, Herts, innholder 0
3868543 1979720 1979720 defendant Pellam Thomas   586528 586528 Pellam, Thomas, of Ware, Herts, "coryer" 4
3868549 1979721 1979721 defendant Pellam Thomas currier 586528 586528 Pellam, Thomas, of Ware, Herts, currier 4
3871439 1980693 1980693 defendant Shurley Richard gent 586528 586528 Shurley, Richard, of Ware, Herts, gent 3
3890185 1986957 1986957 defendant Kent Edward dyer 586528 586528 Kent, Edward, of Ware, Herts, dyer 1
3904353 1991704 1991704 defendant Kent Edward dyer 586528 586528 Kent, Edward, of Ware, Herts, dyer 2
3917875 1996338 1996338 defendant Boughton John butcher 586528 586528 Boughton, John, of Ware, Herts, butcher 0
3917902 1996349 1996349 defendant Kent Edward dyer 586528 586528 Kent, Edward, of Ware, Herts, dyer 2
3930604 2000579 2000579 defendant Mede Michaell   586528 586528 Mede, Michaell, of Ware, Herts, inn holder 0
3936679 2002595 2002595 plaintiff Mede Michaell   586528 586528 Mede, Michaell, of Ware, Herts, inn holder 0
3945907 2005646 2005646 defendant Adred William yeoman 586528 586528 Adred, William, of Ware, Herts, yeoman 0
3948955 2006701 2006701 defendant Athered William innholder 586528 586528 Athered, William, of Ware, Herts, innholder 0
3954967 2008800 2008800 defendant Abbott John (legal representative) 586528 586528 Abbott, John, of Ware, Herts, innholder, administratrix of 0
3966841 2013037 2013037 defendant Hixe William chapman 586528 586528 Hixe, William, of Ware, Herts, chapman 0
3976909 2016492 2016492 defendant Spenser Robert yeoman 586528 586528 Spenser, Robert, of Ware, Herts, yeoman 6
3987342 2020222 2020222 defendant Awdrid William innholder 586528 586528 Awdrid, William, of Ware, Herts, innholder 0
4001234 2025221 2025221 defendant Brownes Francis   586528 586528 Brownes, Francis, of Ware, Herts, basket maker 0
4004434 2026365 2026365 defendant Shelley Henry gent 586528 586528 Shelley, Henry, of Ware, Herts, gent 0
4004598 2026418 2026418 defendant Abbot Joan widow 586528 586528 Abbot, Joan, of Ware, Herts, widow 0
4019004 2031532 2031532 defendant Bradley Robert yeoman 586528 586528 Bradley, Robert, of Ware, Herts, yeoman 1
4019007 2031533 2031533 defendant Bradley Robert yeoman 586528 586528 Bradley, Robert, of Ware, Herts, yeoman 1
4019594 2031733 2031733 defendant Crosse Robert chapman 586528 586528 Crosse, Robert, of Ware, Herts, chapman 0
4025586 2033806 2033806 plaintiff Brooke Richard   586528 586528 Brooke, Richard, of Ware, Herts, yeoman, administrators of 0
4040004 2038929 2038929 defendant Harvie John fuller 586528 586528 Harvie, John, of Ware, Herts, fuller 0
4042006 2039629 2039629 plaintiff Osboston Thomas glover 586528 586528 Osboston, Thomas, of Ware, Herts, glover 0
4042422 2039771 2039771 plaintiff Parnell John merchant 586528 586528 Parnell, John, of Ware, Herts, or of London, merchant 0
4051971 2043125 2043125 defendant Thirkell John innholder 586528 586528 Thirkell, John, of Ware, Herts, innholder 0
4052002 2043138 2043138 defendant Thyrkell John innholder 586528 586528 Thyrkell, John, of Ware, Herts, innholder 0
4068795 2049130 2049130 defendant Aldred William yeoman 586528 586528 Aldred, William, of Ware, Herts, yeoman 0
4075923 2051692 2051692 defendant Payler William innkeeper 586528 586528 Payler, William, of Ware, Herts, yeoman, or of Stylton, Hunts, innkeeper 0
4106725 2062698 2062698 defendant Aldred William innholder 586528 586528 Aldred, William, of Ware, Herts, innholder 0
4108502 2063296 2063296 plaintiff Pyckeringe Robert hackneyman 586528 586528 Pyckeringe, Robert, of Ware, Herts, hackneyman 0
4113662 2065169 2065169 defendant Aldred Roger innholder 586528 586528 Aldred, Roger, of Ware, Herts, innholder 1
4115044 2065669 2065669 defendant Chapman John shoemaker 586528 586528 Chapman, John, of Ware, Herts, shoemaker 0
4151172 2078535 2078535 defendant Meade Humphrey innholder 586528 586528 Meade, Humphrey, of Ware, Herts, innholder 0
4158536 2081055 2081055 defendant Chapman John yeoman 586528 586528 Chapman, John, of Ware, Herts, yeoman 0
4165540 2083448 2083448 defendant Meade Edward yeoman 586528 586528 Meade, Edward, of Ware, Herts, yeoman 0
4191590 2092620 2092620 defendant Chapman John gent 586528 586528 Chapman, John, of Ware, Herts, gent 1
4194227 2093532 2093532 defendant Haggard Edward chapman 586528 586528 Haggard, Edward, of Ware, Herts, chapman 0
4197629 2094726 2094726 defendant Thirkeld John innholder 586528 586528 Thirkeld, John, of Ware, Herts, innholder 2
4204143 2097002 2097002 defendant Burcheley Francis chapman 586528 586528 Burcheley, Francis, of Ware, Herts, chapman 1
4208254 2098437 2098437 defendant Rogers William chapman 586528 586528 Rogers, William, of Ware, Herts, chapman 1
4209330 2098817 2098817 defendant Chapman John gent 586528 586528 Chapman, John, of Ware, Herts, gent 0
4228721 2105530 2105530 defendant Bedell Christopher yeoman 586528 586528 Bedell, Christopher, of Ware, Herts, yeoman 1
4240517 2109811 2109811 defendant Campyon Thomas yeoman 586528 586528 Campyon, Thomas, of Ware, Herts, yeoman 2
4258747 2115891 2115891 defendant Brooke alias Yaxley Richard yeoman 586528 586528 Brooke alias Yaxley, Richard, of Ware, Herts, yeoman 0
4258749 2115892 2115892 defendant Brooke alias Yaxley Richard yeoman 586528 586528 Brooke alias Yaxley, Richard, of Ware, Herts, yeoman 0
4260997 2116641 2116641 defendant Hill Richard maltman 586528 586528 Hill, Richard, of Ware, Herts, maltman 0
4263477 2117447 2117447 defendant Campyon Thomas yeoman 586528 586528 Campyon, Thomas, of Ware, Herts, yeoman 2

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