Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Department, Object Name, Artist Role, Artist Prefix, Dimensions, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 415 | 415 | 83.2.232 | 0 | 1 | 471 | American Decorative Arts 1 | Painting 69 | Plaque Portrait of Benjamin Franklin | Maker 1 | After | Jean-Baptiste Nini | Italian, Urbino 1717–1786 Chaumont-sur-Loire | Nini, Jean-Baptiste 119 | Italian 6 | 1717 | 1786 | 1776–1883 | 1776 | 1883 | Ivory 148 | 2 5/8 x 2 in. (6.7 x 5.1 cm) | Gift of William H. Huntington, 1883 | Made in 1 | France 9 | Paintings 11 | http://www.metmuseum.org/art/collection/search/471 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
| 116425 | 116425 | 69.174 | 0 | 1 | 205131 | European Sculpture and Decorative Arts 3 | Statuette 14 | Madonna and Child | probably French 203 | Artist 2 | After a composition by | Alessandro Algardi | Italian, Bologna 1598–1654 Rome | Algardi, Alessandro 8588 | Italian 6 | 1598 | 1654 | probably mid-17th century | 1630 | 1665 | Ivory 148 | Height: 7 in. (17.8 cm) | Bequest of Caroline W. Funk, in memory of her brother, George, 1969 | Sculpture-Miniature 311 | http://www.metmuseum.org/art/collection/search/205131 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
| 117652 | 117652 | 1976.422.5 | 0 | 1 | 206575 | European Sculpture and Decorative Arts 3 | Plaque 75 | Virgin adoring the Christ Child | Italian, Reggio Emilia 360 | Artist 2 | After a composition by | Lelio Orsi (called Lelio da Novellara) | Italian, Novellara 1508/11–1587 Novellara | Orsi, Lelio (Lelio da Novellara) 11536 | Italian 6 | 1508 | 1587 | probably 17th century | 1600 | 1699 | Ivory 148 | Height: 3 1/4 in. (8.3 cm) | Gift of Alfred and Victoria Harris, 1976 | Sculpture-Miniature 311 | http://www.metmuseum.org/art/collection/search/206575 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
| 305692 | 305692 | 42.53.2 | 0 | 1 | 435575 | European Paintings 15 | Painting, miniature 73 | Jérôme Bonaparte (1784–1860), King of Westphalia | Artist 2 | Giacomo Andreoli | Italian, active ca. 1808 | Andreoli, Giacomo 43378 | Italian 6 | 1808 | 1808 | 1803 | 1813 | Ivory 148 | 2 3/8 x 1 7/8 in. (60 x 48 mm) | Gift of Helen O. Brice, 1942 | Miniatures 771 | http://www.metmuseum.org/art/collection/search/435575 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
| 305826 | 305826 | 1972.145.7 | 0 | 1 | 435726 | European Paintings 15 | Painting, miniature 73 | Count Alexander Ivanovich Sollogoub (1788–1844) | Artist 2 | Domenico Bossi | Italian, Venetian, 1765–1853 | Bossi, Domenico 43434 | Italian 6 | 1765 | 1853 | 1810 | 1810 | 1810 | Ivory 148 | Oval, 2 3/8 x 1 7/8 in. (60 x 47 mm) | Gift of Humanities Fund Inc., 1972 | Miniatures 771 | http://www.metmuseum.org/art/collection/search/435726 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 305928 | 305928 | 32.75.7 | 0 | 1 | 435845 | European Paintings 15 | Painting, miniature 73 | Portrait of a Woman | Artist 2 | F. Carbonara | Italian, early 19th century | Carbonara, F. 43462 | Italian 6 | 1800 | 1829 | 1800 | 1829 | Ivory 148 | Diameter 2 5/8 in. (66 mm) | The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932 | Miniatures 771 | http://www.metmuseum.org/art/collection/search/435845 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
| 305936 | 305936 | 49.122.2 | 0 | 1 | 435854 | European Paintings 15 | Painting, miniature 73 | Portrait of a Man | Artist 2 | Rosalba Carriera | Italian, Venice 1673–1757 Venice | Carriera, Rosalba 43466 | Italian 6 | 1673 | 1757 | ca. 1710 | 1705 | 1715 | Ivory 148 | Oval, 3 x 2 1/4 in. (76 x 59 mm) | Rogers Fund, 1949 | Miniatures 771 | http://www.metmuseum.org/art/collection/search/435854 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 306490 | 306490 | 26.168.33 | 0 | 1 | 436501 | European Paintings 15 | Painting, miniature 73 | Francesca Ghirardi Lechi (1773–1806) | Artist 2 | Giovanni Battista Gigola | Italian, Brescian, 1767–1841 | Gigola, Giovanni Battista 43575 | Italian 6 | 1767 | 1841 | 1789 | 1841 | Ivory 148 | Diameter 2 5/8 in. (66 mm) | Bequest of Collis P. Huntington, 1900 | Miniatures 771 | http://www.metmuseum.org/art/collection/search/436501 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
| 306719 | 306719 | 68.156 | 0 | 1 | 436765 | European Paintings 15 | Painting, miniature 73 | A Patrician and His Wife | Artist 2 | Italian (Venetian) Painter | 1730 or later | Italian (Venetian) Painter 43637 | Italian 6 | 1730 | 1735 | Ivory 148 | Inside lid and bottom of ivory box, 3 x 2 1/4 in. (77 x 55 mm) and 2 7/8 x 2 1/8 in. (73 x 53 mm) | Victor Wilbour Memorial Fund, 1968 | Miniatures 771 | http://www.metmuseum.org/art/collection/search/436765 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
| 306907 | 306907 | 1992.104 | 0 | 1 | 436977 | European Paintings 15 | Painting, miniature 73 | Napoléon I (1769–1821) on Horseback | Artist 2 | Luigi Marta | Italian, Neapolitan, 1790–1858 | Marta, Luigi 43702 | Italian 6 | 1790 | 1858 | 1830 | 1830 | 1830 | Ivory 148 | 5 3/4 x 7 1/2 in. (146 x 191 mm) | Gift of Gloria Zicht, 1992 | Miniatures 771 | http://www.metmuseum.org/art/collection/search/436977 | 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");