Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Object Name, Title, Culture, Credit Line, Classification
| 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 | Metadata Date | Repository |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100682 | 100682 | 97.2.65 | 0 | 1 | 188100 | European Sculpture and Decorative Arts 3 | Spoon 78 | Spoon | German, Augsburg 126 | Maker 1 | Michael Hafner | r. 1665–1700 | HAFNER MICHAEL 8232 | 1665 | 1700 | 1674 | 1674 | 1674 | Silver-gilt 20506 | Overall: 5 1/2 × 1 1/2 in. (14 × 3.8 cm) | Gift of Mrs. Samuel P. Avery, 1897 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/188100 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 101363 | 101363 | 03.40 | 0 | 0 | 188874 | European Sculpture and Decorative Arts 3 | Spoon 78 | Coronation spoon | British, after British original 2085 | Maker 1 | JW and ECW | (partnership) | JW and ECW 8379 | 1902–3 | 1902 | 1903 | Silver-gilt 20506 | L. 10 in. (25.4 cm.) | Gift of John Wells, 1903 | Metalwork-Electrotype 136 | http://www.metmuseum.org/art/collection/search/188874 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
| 104279 | 104279 | 12.85 | 0 | 1 | 191896 | European Sculpture and Decorative Arts 3 | Tankard 888 | Tankard | Austrian, Eger 2523 | Maker 1 | I. B. (Austrian) | 17th century | B. I. 8765 | 1600 | 1699 | early 17th century | 1600 | 1615 | Silver-gilt 20506 | Height: 8 in. (20.3 cm) | Gift of Victor G. Fischer, 1912 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/191896 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 112307 | 112307 | 49.7.92, .93 | 0 | 1 | 200580 | European Sculpture and Decorative Arts 3 | Fruit dishes 7109 | Pair of fruit dishes | British, London 222 | Maker 1 | Thomas Heming | active 1745–73 | Heming Thomas 9930 | 1745 | 1773 | 1766–67 | 1766 | 1767 | Silver-gilt 20506 | .92, wt. confirmed: 5 1/8 × 19 1/8 in., 6 lb. (13 × 48.6 cm, 2744.262g) .93, wt. confirmed: 5 1/4 × 19 1/8 in., 6 lb. (13.3 × 48.6 cm, 2721.582g) | The Jules Bache Collection, 1949 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/200580 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 116360 | 116360 | 68.141.303 | 0 | 1 | 205060 | European Sculpture and Decorative Arts 3 | Wager cup 7593 | Wager cup (one of a pair) | British, London 222 | Maker 1 | J. A. or I. A., London | early 19th century | A. J. or I. 11291 | 1800 | 1815 | probably early 19th century | 1800 | 1815 | Silver-gilt 20506 | Height: 6 1/8 in. (15.6 cm) | Gift of Irwin Untermyer, 1968 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/205060 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 116506 | 116506 | 1970.131.33 | 0 | 1 | 205221 | European Sculpture and Decorative Arts 3 | Bowl 106 | Bowl | British, London 222 | Maker 1 | George Wickes | British, Bury St Edmunds, Suffolk 1698–1761 Thurston, Suffolk | Wickes George 8815 | 1698 | 1761 | 1744/45 | 1744 | 1745 | Silver-gilt 20506 | 3 × 6 3/8 in. (7.6 × 16.2 cm) | Gift of Irwin Untermyer, 1970 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/205221 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 121743 | 121743 | 00.19.49 | 0 | 0 | 211428 | European Sculpture and Decorative Arts 3 | Souvenir spoon 7049 | Souvenir spoon with finial in form of John Bull | British, London 222 | Maker 1 | Saunders & Shepherd | British, 1869–present | Saunders & Shepherd 12270 | 1869 | 9999 | 1894–95 | 1894 | 1895 | Silver-gilt 20506 | Length: 4 1/2 in. (11.4 cm) | Gift of Sir William H. Redding, in memory of his wife, 1900 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/211428 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 139654 | 139654 | 2008.543.1 | 0 | 1 | 236504 | European Sculpture and Decorative Arts 3 | Tankard 888 | Tankard | Estonian, Tallinn (Reval) 3941 | Maker 1 | Ludwig Wachman | mentioned 1632 | Wachman Ludwig 12743 | 1632 | 1632 | 1640–50 | 1640 | 1650 | Silver-gilt 20506 | Overall (confirmed): 9 1/8 x 7 3/4 x 5 3/8 in., 38.025oz. (23.2 x 19.7 x 13.7 cm, 1078g) | Gift of Mrs. Charles Wrightsman, 2008 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/236504 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 139655 | 139655 | 2008.543.2a, b | 0 | 1 | 236505 | European Sculpture and Decorative Arts 3 | Double beaker 9098 | Double beaker | German, Nuremberg 147 | Maker 1 | Peter Wiber | master 1603, freeman 1605, sworn 1623–27, died 1641 | Wiber Peter 8116 | 1541 | 1641 | 1609–29 | 1609 | 1629 | Silver-gilt 20506 | Overall (confirmed): 8 1/8 × 4 3/16 × 4 3/16 in., 15.184oz. (20.6 × 10.6 × 10.6 cm, 430.508g) | Gift of Mrs. Charles Wrightsman, 2008 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/236505 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 139657 | 139657 | 2008.543.4a, b | 0 | 1 | 236507 | European Sculpture and Decorative Arts 3 | Double beaker 9098 | Double beaker | German, Nuremberg 147 | Maker 1 | Nicholaus I Emmerling | active 1587–1606 | Emmerling Nicholaus I 12745 | 1587 | 1606 | 1603–9 | 1603 | 1609 | Silver-gilt 20506 | Overall (confirmed): 4 7/16 × 2 9/16 × 2 9/16 in., 6.243oz. (11.3 × 6.5 × 6.5 cm, 177.006g) | Gift of Mrs. Charles Wrightsman, 2008 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/236507 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 139658 | 139658 | 2008.543.5 | 0 | 1 | 236508 | European Sculpture and Decorative Arts 3 | Beaker 58 | Beaker | French, Strasbourg 258 | Maker 1 | Jean-Jacques Kirstein | master 1760, active 1798 | Kirstein Jean-Jacques 10480 | 1760 | 1798 | ca. 1770 | 1765 | 1775 | Silver-gilt 20506 | Overall (confirmed): 4 3/16 × 3 11/16 × 2 7/8 in., 7.83oz. (10.6 × 9.4 × 7.3 cm, 222g) | Gift of Mrs. Charles Wrightsman, 2008 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/236508 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
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");