Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Department, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 68551 | 68551 | 1999.479a, b | 0 | 0 | 81379 | Costume Institute 8 | Shoes 5896 | Shoes | Swiss 54 | Designer 5 | Bally of Switzerland | Swiss, founded 1810 | Bally of Switzerland 5694 | Swiss 61 | 1810 | 9999 | ca. 1935 | 1930 | 1940 | silk, leather 15154 | Gift of Ursula G. Korzenik, 1999 | http://www.metmuseum.org/art/collection/search/81379 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
| 82477 | 82477 | 1989.375.9 | 0 | 0 | 113724 | Costume Institute 8 | Watch 557 | Watch | Swiss 54 | Manufacturer 20 | Swatch | Swiss, founded 1983 | Swatch 6623 | Swiss 61 | 1983 | 9999 | ca. 1983 | 1980 | 1985 | plastic 15143 | Gift of Gregory R. Reynolds, 1989 | http://www.metmuseum.org/art/collection/search/113724 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
| 83375 | 83375 | 1979.579.1a, b | 0 | 0 | 115678 | Costume Institute 8 | Oxfords 6210 | Oxfords | Swiss 54 | Designer 5 | Bally of Switzerland | Swiss, founded 1810 | Bally of Switzerland 5694 | Swiss 61 | 1810 | 9999 | ca. 1969 | 1964 | 1974 | leather 15128 | Gift of David Toser, 1979 | http://www.metmuseum.org/art/collection/search/115678 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
| 95503 | 95503 | 2009.300.5998a, b | 0 | 0 | 170191 | Costume Institute 8 | Evening shoes 5884 | Evening shoes | Swiss 54 | Manufacturer 20 | Bally of Switzerland | Swiss, founded 1810 | Bally of Switzerland 5694 | Swiss 61 | 1810 | 9999 | ca. 1963 | 1961 | 1965 | Leather, rhinestones 20109 | Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jane Holzer, 1986 | http://www.metmuseum.org/art/collection/search/170191 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
| 116905 | 116905 | 1974.28.190 | 0 | 1 | 205689 | European Sculpture and Decorative Arts 3 | Welcome panel 8413 | Welcome panel | Swiss 54 | Artist 2 | Anonymous, Swiss | Anonymous, Swiss 11415 | Swiss 61 | 1400 | 2050 | early 17th century | 1600 | 1615 | Stained and enameled glass 23243 | Overall: 16 × 13 3/4 in. (40.6 × 34.9 cm) | Bequest of Irwin Untermyer, 1973 | Glass-Stained 147 | http://www.metmuseum.org/art/collection/search/205689 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 330329 | 330329 | 2000.135 | 0 | 1 | 472854 | The Cloisters 17 | Panel 399 | Stained-Glass Panel with a Coat of Arms and a Female Supporter | Swiss 54 | Artist 2 | Workshop of | Lukas Zeiner | Swiss, active ca. 1480–1510 | Zeiner Lukas 44763 | Swiss 61 | 1480 | 1510 | 1500–1505 | 1500 | 1505 | Pot metal and colorless glass, vitreous paint, and silver stain, lead 49932 | 14 7/8 x 19 7/8 in. (37.8 x 50.5 cm) | Purchase, Bequest of Jane Hayward, by exchange, 2000 | Glass-Stained 147 | http://www.metmuseum.org/art/collection/search/472854 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
| 346857 | 346857 | 89.4.883 | 0 | 1 | 501494 | Musical Instruments 18 | Bassoon in C 15956 | Bassoon in C | Swiss 54 | Maker 1 | Jeanneret workshop | Swiss, La Chaux-du-Milieu before 1764–after 1786 Le Locle | Jeanneret 47702 | Swiss 61 | 1764 | 1786 | 1771 | 1771 | 1771 | Maple, brass 1192 | Length (end to end) 1146 mm, Length of tube +/-2438 mm including crook and reed, Diameter of bell (opening) 76 mm Length of crook +/- 366 mm Length of wing section +/- 495 mm without tenon Length of butt section 425 mm Length of long section +/- 530 mm without tenon Length of bell 215 mm | The Crosby Brown Collection of Musical Instruments, 1889 | La Chaux-du-Milieu (near Le Locle, Neuchatel) 2174 | Switzerland 52 | Aerophone-Reed Vibrated-double reed 911 | http://www.metmuseum.org/art/collection/search/501494 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
| 348687 | 348687 | 1990.222.4 | 0 | 1 | 503395 | Musical Instruments 18 | Clarinet in C 15654 | Clarinet in C | Swiss 54 | Maker 1 | Josef Karl Anton "Charles" Felchlin | Swiss, Schwyz? 1800–1855 Bern? | Felchlin, Charles 47957 | Swiss 61 | 1800 | 1855 | ca. 1825–50 | 1826 | 1851 | Wood, silver, ivory 54612 | L. 59.5 cm (23-7/16 in.) | Purchase, Clara Mertens Bequest, in memory of André Mertens, 1990 | Berne 1079 | Switzerland 52 | Aerophone-Reed Vibrated-single reed cylindrical 953 | http://www.metmuseum.org/art/collection/search/503395 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
| 350637 | 350637 | 58.83 | 0 | 0 | 505606 | Musical Instruments 18 | Music Box 17166 | Music Box | Swiss 54 | Maker 1 | Allard & Sandoz | Swiss | Allard & Sandoz 48417 | Swiss 61 | 1880 | 1880 | 1880 | Wood, metal 6120 | Gift of Richard C. Patterson, Jr., 1958 | Geneva 1152 | Switzerland 52 | Idiophone-Plucked / Depressed 920 | http://www.metmuseum.org/art/collection/search/505606 | 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");