Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Highlight, Is Public Domain, Department, Object Name, Artist Role, Artist Prefix, Medium, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181942 | 181942 | 2005.100.196 | 0 | 1 | 285607 | Photographs 13 | Photograph 997 | [Portrait in a White Dress] | Artist|Artist|Person in Photograph 815 | Painted and retouched by | Pierre-Louis Pierson|Aquilin Schad|Countess Virginia Oldoini Verasis di Castiglione | French, 1822–1913|Austrian, 1817–1866|1835–1899 | Pierson, Pierre-Louis|Schad, Aquilin|Castiglione, di, Virginia Oldoini Verasis Countess 16005 | French|Austrian 629 | 1822 |1817 |1835 | 1913 |1866 |1899 | 1856–57, printed 1861–66 | 1856 | 1866 | Salted paper print from glass negative with applied color 26090 | Image: 32.5 x 27 cm (12 13/16 x 10 5/8 in.) Mount: 39.1 x 29.7 cm (15 3/8 x 11 11/16 in.) Mat: 61 x 50.8 cm (24 x 20 in.) | Gilman Collection, Gift of The Howard Gilman Foundation, 2005 | Photographs 21 | http://www.metmuseum.org/art/collection/search/285607 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 207358 | 207358 | 1998.21 | 1 | 1 | 334710 | Drawings and Prints 11 | Drawing 23 | The Kaunitz Sisters (Leopoldine, Caroline, and Ferdinandine) | Artist|Patron 370 | commissioned by | Jean Auguste Dominique Ingres|Prince Wenzel von Kaunitz-Rietberg | French, Montauban 1780–1867 Paris|Austrian Ambassador to Rome 1818 | Ingres, Jean Auguste Dominique|Kaunitz-Rietberg, Prince Wenzel von 17717 | French|Austrian 629 | 1780 |1818 | 1867 |1818 | 1818 | 1818 | 1818 | Graphite on laid paper 29440 | Sheet: 11 7/8 × 8 3/4 in. (30.2 × 22.2 cm) | Gift of Mrs. Charles Wrightsman, in honor of Philippe de Montebello, 1998 | Drawings 9 | http://www.metmuseum.org/art/collection/search/334710 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 227835 | 227835 | 59.587.2 | 0 | 0 | 355457 | Drawings and Prints 11 | Book 97 | Garten-Verschoenerungen, oder Entwverfe zu geschmackvollen Gartengebaeuden und Zierden.. | Author|Publisher 44 | Benedikt Piringer|Heinrich Friederich Müller, Vienna | French 1780–1826 Paris | Piringer, Benedikt|Müller, Heinrich Friederich 28655 | French|Austrian 629 | 1780 |1800 | 1826 |1900 | ca. 1825–30 | 1820 | 1835 | Engraving 7208 | Overall: 11 1/8 x 15 1/16 x 1/2 in. (28.2 x 38.2 x 1.2 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959 | Books 442 | http://www.metmuseum.org/art/collection/search/355457 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 247652 | 247652 | 2007.49.381 | 0 | 0 | 375946 | Drawings and Prints 11 | Print 731 | Portrait of Maria Anna of Bavaria | Artist|Sitter 972 | Portrait of | Jean Frosne|Maria Anna Christine Victoria von Wittelsbach | French, 1623–after 1676|Munich 1660–1690 Versailles | Frosne, Jean|Wittelsbach, Maria Anna Christine Victoria von 34996 | French|Austrian 629 | 1623 |1660 | 1700 |1690 | ca. 1676–90 | 1671 | 1695 | Engraving 7208 | plate: 8 1/2 x 5 9/16 in. (21.6 x 14.1 cm) sheet: 9 1/4 x 6 1/2 in. (23.5 x 16.5 cm) | Bequest of William S. Lieberman, 2005 | Prints 13 | http://www.metmuseum.org/art/collection/search/375946 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 264460 | 264460 | 24.63.1074 | 0 | 1 | 393420 | Drawings and Prints 11 | Print 731 | Anne of Austria | Artist|Sitter 972 | Portrait of | Claude Mellan|Anne of Austria, Queen of France | French, Abbeville 1598–1688 Paris|Spanish, Valladolid 1601–1666 Paris | Mellan, Claude|Anne of Austria, Queen of France 38639 | French|Austrian 629 | 1598 |1601 | 1688 |1666 | ca. 1645 | 1640 | 1650 | Engraving; second state of two (BN) 42397 | sheet: 14 1/4 x 9 3/4 in. (36.2 x 24.8 cm) plate: 13 11/16 x 9 1/4 in. (34.7 x 23.5 cm) | Gift of Georgiana W. Sargent, in memory of John Osborne Sargent, 1924 | Prints 13 | http://www.metmuseum.org/art/collection/search/393420 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 287671 | 287671 | 23.59.30 | 0 | 0 | 416985 | Drawings and Prints 11 | Print 731 | Facsimile Reproduction of Le Jardin, appelé aussi Le Marais (The Garden, also called The Marsh), from Les Quatre Paysages (The Four Landscapes) | Les Quatre Paysages 1981 | Author|Artist|Publisher 1302 | Author of Meisterwerke der Graphik in XVIII jahrhundert | Alfred Stix|Jacques Callot|Artur Wolf | French, Nancy 1592–1635 Nancy|Vienna | Stix, Alfred|Callot, Jacques|Wolf, Artur 41541 | French|Austrian 629 | 1592 |1900 | 1635 |1950 | 20th century | 1900 | 1920 | Etching; facsimile of first state of two (Lieure) 43736 | Sheet: 5 1/4 x 10 in. (13.3 x 25.4 cm) Plate: 3 9/16 x 8 3/8 in. (9 x 21.3 cm) | Transferred from library, 1923 | Prints 13 | http://www.metmuseum.org/art/collection/search/416985 | 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");