MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

13 rows where Artist Role = 1 and Object Name = 116

View and edit SQL

Suggested facets: Is Public Domain, Title, Artist Display Bio, Artist Nationality, Artist Begin Date, Object Date, Object Begin Date, Medium, Credit Line

Artist Role

  • Maker · 13
Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
871 22.186a, b 0 0 948 American Decorative Arts 1 Jar 116 Covered jar American 1         Maker 1   Marie Zimmermann American, Brooklyn, New York 1879–1972 Punta Gorda, Florida   Zimmermann, Marie 194 American 1 1879 1972 1905–15 1905 1915 Silver, gold, jade, crystal, and rubies 260 Overall: 6 1/2 x 3 5/16 x 2 3/8 in. (16.5 x 8.4 x 6 cm); 12 oz. 1 dwt. (375 g) Body: H. 3 1/4 in. (8.3 cm); 8 oz. 5 dwt. (256.1 g) Cover: H. 3 3/8 in. (8.6 cm); 3 oz. 16 dwt. (118.9 g) Purchase, Edward C. Moore Jr. Gift, 1922 Made in 1 New York 3     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
2222 46.140.298a, b 0 1 2405 American Decorative Arts 1 Jar 116 Covered Owl Jar American 1         Maker 1   Atterbury and Company ca. 1867–1893   Atterbury and Company  374   1864 1893 1880–90 1880 1890 Pressed blue glass 282 H. 6 3/4 in. (17.1 cm) Gift of Mrs. Emily Winthrop Miles, 1946 Made in 1 Pittsburgh 32     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
2223 46.140.299a, b 0 1 2406 American Decorative Arts 1 Jar 116 Covered Owl Jar American 1         Maker 1   Atterbury and Company ca. 1867–1893   Atterbury and Company  374   1864 1893 1880–90 1880 1890 Pressed blue glass 282 H. 6 3/4 in. (17.1 cm) Gift of Mrs. Emily Winthrop Miles, 1946 Made in 1 Pittsburgh 32     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
2226 46.140.483a, b 0 1 2409 American Decorative Arts 1 Jar 116 Covered jar American 1         Maker 1   New England Glass Company American, East Cambridge, Massachusetts, 1818–1888   New England Glass Company  10   1818 1888 1883–88 1883 1888 Blown Amberina glass 584 H. 8 3/8 in. (21.3 cm); Diam. 4 1/4 in. (10.8 cm) Gift of Mrs. Emily Winthrop Miles, 1946 Made in 1 East Cambridge 6     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
2228 34.100.159a, b 0 1 2412 American Decorative Arts 1 Jar 116 Covered jar American 1         Maker 1 Attributed to Jacob Scholl 1781–1851   Scholl, Jacob 380   1781 1851 ca. 1830–40 1830 1840 Earthenware; Redware with sgraffito decoration 585 H. 8 1/2 in. (21.6 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Montgomery County 28 Montgomery County 28 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4174 1986.451 0 1 4505 American Decorative Arts 1 Jar 116 Jar American 1         Maker 1 Attributed to Philip Kline active ca. 1806–34   Kline, Philip 599   1806 1834 1809 1809 1809 Earthenware; Redware with sgraffito decoration 585 9 1/8 x 4 1/2 in. (23.2 x 11.4 cm) Anonymous Gift, 1986 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
13119 1991.26.1 0 1 14267 American Decorative Arts 1 Jar 116 Covered Jar American 1         Maker 1   George Duncan and Sons 1874–1891   Duncan and Sons George 309   1874 1891 ca. 1881–90 1878 1890 Pressed glass 5 5 15/16 x 3 1/8 in. (15.1 x 7.9 cm) Bequest of Marguerite Raeder Laporte, 1991 Made in 1 Pittsburgh 32     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
13328 1992.87a, b 0 1 14489 American Decorative Arts 1 Jar 116 Jar American 1         Maker 1   John M. Safford 1811–1880   Safford, John M. 2200   1811 1880 1838 1838 1838 Earthenware; Redware with stamped decoration 2356 H. 10 7/8 in. (27.6 cm); Diam. 8 in. (20.3 cm) Friends of the American Wing Fund, 1992 Made in 1 Monmouth 372     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
16050 2002.475 0 1 17503 American Decorative Arts 1 Jar 116 Jar American 1         Maker 1   Paul Cushman 1767–1833   Cushman, Paul 2472 American 1 1767 1833 1805–33 1805 1805 Stoneware 209 14 1/8 x 11 1/4 in. (35.9 x 28.6 cm) Gift of Paul Cushman Jr., 2002 Made in 1 Albany 40     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
16944 2011.321.29a, b 0 1 20748 American Decorative Arts 1 Jar 116 Jar American 1         Maker 1   Susan S. G. Frackelton 1848–1932   Frackelton, Susan S. G. 2631   1848 1932 1896–1900 1896 1900 Stoneware 209 5 in. (12.7 cm) Gift of Emma and Jay Lewis, 2011 Made in 1 Milwaukee 404     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
111422 45.128.1 0 1 199670 European Sculpture and Decorative Arts 3 Jar 116 Jar Italian, Naples 427         Maker 1   Gaetano Lottini Italian, ca. 1755   Lottini, Gaetano 10272   1725 1785 mid-18th century 1730 1765 Earthenware 21 Height: 39 in. (99.1 cm) Bequest of Helen Hay Whitney, 1944                       Ceramics-Porcelain 307   Metropolitan Museum of Art, New York, NY 1
111997 48.187.268 0 1 200266 European Sculpture and Decorative Arts 3 Jar 116 Jar French, Paris 114         Maker 1   Claude Dargent born ca. 1698, master 1722, retired 1755, recorded 1771   DARGENT CLAUDE 10491   1698 1798 1739–40 1739 1740 Silver 2 Height: 5 in. (12.7 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
140530 2013.239.7 0 1 239486 European Sculpture and Decorative Arts 3 Jar 116 Jar with four birds British, Southall, London 3984         Maker 1   R. W. Martin and Brothers British, 1873–1915   R. W. Martin and Brothers 12896 British 7 1873 1915 1892 1892 1892 Stoneware 209 Overall (confirmed, irregular diameter): 8 5/16 × 6 × 6 1/8 in. (21.1 × 15.2 × 15.6 cm) Robert A. Ellison Jr. Collection, Gift of Robert A. Ellison Jr., 2013                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 4203.276ms · Data license: CC0 · Data source: metmuseum/openaccess