Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 426013 | 426013 | SL.24.2016.1.1 | 0 | 0 | 707487 | Islamic Art 9 | Dish 110 | Dis | Artist|Manufacturer 26 | William E. Hentschel|Rookwood Pottery | 1892–1962|American, Cincinnati, Ohio, 1880–1967 | Hentschel, William E.|Rookwood Pottery 54340 | 1892 |1880 | 1962 |1967 | 1924 | 1924 | 1924 | Ceramic 161 | Diam. 10 in. (25.4 cm) | Collection of Dr. Marilyn Jenkins-Madina | Made in 1 | Cincinnati 41 | Ohio 351 | United States of America 718 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/707487 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
| 442164 | 442164 | 57.662.3(30) | 0 | 0 | 739084 | Drawings and Prints 11 | Album Drawings Ornament & Architecture 13871 | Four designs for bracelets with stylized leaves and pearls | Artist|Manufacturer 26 | F. Mellerio Borgnis|Mellerio dits Meller | Mellerio, Borgnis F.|Mellerio dits Meller 56399 | 1600 | ca. 1830 - 1870 | 1825 | 1875 | Graphite, pen and black, green, and yellow ink, and gray wash 62041 | Album: 8 11/16 × 12 1/8 × 1 9/16 in. (22 × 30.8 × 4 cm) | Gift of Raphael Esmerian, 1957 | Albums|Drawings|Ornament & Architecture 667 | http://www.metmuseum.org/art/collection/search/739084 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
| 442169 | 442169 | 57.662.3(31) | 0 | 0 | 739089 | Drawings and Prints 11 | Album Drawings Ornament & Architecture 13871 | Six designs for brooches with stylized leaves, scrolls, ribbons, and pearls | Artist|Manufacturer 26 | F. Mellerio Borgnis|Mellerio dits Meller | Mellerio, Borgnis F.|Mellerio dits Meller 56399 | 1600 | ca. 1830 - 1870 | 1825 | 1875 | Graphite and gray wash 29339 | Album: 8 11/16 × 12 1/8 × 1 9/16 in. (22 × 30.8 × 4 cm) | Gift of Raphael Esmerian, 1957 | Albums|Drawings|Ornament & Architecture 667 | http://www.metmuseum.org/art/collection/search/739089 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
| 444656 | 444656 | 2016.708.14 | 0 | 0 | 742619 | Drawings and Prints 11 | Ephemera 1142 | Tin Advertisement Plate for A. V. Benoit, Manufacturer and Importer of Artist and Drawing Material, New York | Artist|Manufacturer 26 | For | Sentenne & Greene|A. V. Benoit | American, active New York late 19th and early 20th century | , 146 and 148 Fulton Street, NY | Sentenne & Greene|Benoit, A. V. 56605 | late 19th century | 1880 | 1900 | Color lithograph on tin 62182 | 13 11/16 × 19 3/4 in. (34.7 × 50.2 cm) | Gift of Morrison Heckscher, 2016 | Ephemera 24 | http://www.metmuseum.org/art/collection/search/742619 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
| 446788 | 446788 | ES.110 | 0 | 0 | 747684 | Modern and Contemporary Art 4 | Necklace 237 | Necklac | Artist|Manufacturer 26 | Robert Venturi|Cleto Munari | American, born Philadelphia, Pennsylvania, 1925 | Venturi, Robert|Cleto Munari 57074 | 1925 | 2025 | 1982–1986 | 1982 | 1986 | Gold, turquoise, white onyx, black onyx, lapis lazuli, red agate, green agate 62455 | Collection of Kim and Al Eiber | Jewelry 10 | Venturi, Scott Brown and Associates, Inc | http://www.metmuseum.org/art/collection/search/747684 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
| 446809 | 446809 | ES.111 | 0 | 0 | 747718 | Modern and Contemporary Art 4 | Rocchetto or Reel | Artist|Manufacturer 26 | Ettore Sottsass|Bitossi, Montelupo Fiorentino | Italian (born Austria), Innsbruck 1917–2007 Milan|Italian | Sottsass, Ettore|Bitossi, Montelupo Fiorentino 57080 | 1917 | 2007 | 1959 | 1959 | 1959 | Ceramic 161 | 5 11/16 × 6 5/16 in. (14.5 × 16 cm) | Collection of Rob Beyer | Vases 410 | Studio Ettore Sottsass Srl | http://www.metmuseum.org/art/collection/search/747718 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
| 447176 | 447176 | ES.123 | 0 | 0 | 748289 | Modern and Contemporary Art 4 | Cabinet 149 | Vetrinetta di Famiglia | Artist|Manufacturer 26 | Ettore Sottsass|Studio Alchymia | Italian (born Austria), Innsbruck 1917–2007 Milan|Italian | Sottsass, Ettore|STUDIO ALCHYMIA 45817 | 1917 | 2007 | 1979 | 1979 | 1979 | metal, glass, laminate 62506 | Courtesy of Friedman Benda, New York | Furniture 4 | Studio Ettore Sottsass Srl | http://www.metmuseum.org/art/collection/search/748289 | 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");