MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 17 rows (hide)

select 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 from MetObjects where "Artist Role" = :p0 order by Repository limit 101

Query parameters

This data as json, CSV

rowid	Object Number	Object ID	Department	Object Name	Title	Culture	Artist Role	Artist Prefix	Artist Display Name	Artist Display Bio	Artist Alpha Sort	Artist Nationality	Artist Begin Date	Artist End Date	Object Date	Object Begin Date	Object End Date	Medium	Credit Line	Link Resource	Metadata Date	Repository
66428	1996.61.11	78952	8	5877	Dress	35	201		Issey Miyake\|Bloomingdale Brothers Inc.\|Miyake Design Studio	Japanese, born 1938\|American, founded 1872\|Japanese	5262	137	1938 \|1872	2038 \|2072	1970	1970	1970	15103	Gift of Roz Gerten Jacobs, 1996	http://www.metmuseum.org/art/collection/search/78952	4/23/2018 8:00:01 AM	1
66717	1996.482.2a, b	79296	8	5876	Suit	35	201		Rei Kawakubo\|Bergdorf Goodman\|Comme des Garçons	Japanese, born 1942\|American, founded 1899\|Japanese, founded 1969	5365	137	1942 \|1899 \|1969	2042 \|9999 \|9999	ca. 1992	1987	1997	15104	Gift of Claudia Payne, 1996	http://www.metmuseum.org/art/collection/search/79296	4/23/2018 8:00:01 AM	1
66729	1996.482.14a–c	79308	8	5875	Ensemble	1	201		Donna Karan\|Bergdorf Goodman\|Donna Karan New York	American, born 1948\|American, founded 1899\|American, founded 1985	5371	101	1948 \|1899 \|1985	2048 \|9999 \|1985	ca. 1991	1986	1996	15202	Gift of Claudia Payne, 1996	http://www.metmuseum.org/art/collection/search/79308	4/23/2018 8:00:01 AM	1
66732	1996.482.17a–c	79311	8	5875	Ensemble	1	201		Donna Karan\|Bergdorf Goodman\|Donna Karan New York	American, born 1948\|American, founded 1899\|American, founded 1985	5371	101	1948 \|1899 \|1985	2048 \|9999 \|1985	ca. 1992	1987	1997	15204	Gift of Claudia Payne, 1996	http://www.metmuseum.org/art/collection/search/79311	4/23/2018 8:00:01 AM	1
66751	1996.487.1a–d	79330	8	5876	Suit	1	201	(a, b)\|(c, d)\|(a, b)	Calvin Klein\|Saks Fifth Avenue\|Calvin Klein, Inc.	American, born Bronx, New York, 1942\|American, founded 1924\|American, founded 1968	5381	101	1942-11-19\|1924 \|1968	2042 \|9999 \|9999	1976	1976	1976	15209	Gift of Nicole H. Breidbart, 1996	http://www.metmuseum.org/art/collection/search/79330	4/23/2018 8:00:01 AM	1
69828	C.I.61.24.1a, b	83541	8	5879	Evening ensemble	7	201		Gabrielle Chanel\|Bonwit Teller & Co.\|House of Chanel	French, Saumur 1883–1971 Paris\|American, founded 1907\|French, founded 1913	5840	182	1883 \|1907 \|1913	1971 \|2050 \|2099	1929–30	1929	1930	15101	Gift of Dorothy N. Lewis, 1961	http://www.metmuseum.org/art/collection/search/83541	4/23/2018 8:00:01 AM	1
70777	1973.301	84817	8	5907	Dinner dress	7	201		Jeanne Lanvin\|I. Magnin & Co.\|House of Lanvin	French, 1867–1946\|American, founded 1876\|French, founded 1889	5966	182	1867 \|1876 \|1889	1946 \|9999	fall/winter 1939–40	1939	1940	15101	Gift of Mrs. Leon Roos, 1973	http://www.metmuseum.org/art/collection/search/84817	4/23/2018 8:00:01 AM	1
71241	1971.6	85693	8	5877	Dress	7	201		Pierre Balmain\|Bergdorf Goodman\|House of Balmain	French, St. Jean de Maurienne 1914–1982 Paris\|American, founded 1899\|French, founded 1945	5987	182	1914 \|1899 \|1945	1982 \|9999 \|9999	1967	1967	1967	15169	Gift of Mrs. Douglas Dillon, 1971	http://www.metmuseum.org/art/collection/search/85693	4/23/2018 8:00:01 AM	1
74438	C.I.61.41.1a, b	94807	8	5877	Dress	7	201		Christian Dior\|Bergdorf Goodman\|House of Dior	French, Granville 1905–1957 Montecatini\|American, founded 1899\|French, founded 1947	6207	182	1905 \|1899 \|1947	1957 \|9999 \|9999	fall/winter 1956–57	1956	1957	15122	Gift of Mrs. Walter C. Baker, 1961	http://www.metmuseum.org/art/collection/search/94807	4/23/2018 8:00:01 AM	1
74579	1988.173	95065	8	5874	Evening dress	7	201		Jacques Fath\|I. Magnin & Co.\|House of Jacques Fath	French, 1912–1954\|American, founded 1876\|French, founded 1937	6229	182	1912 \|1876 \|1937	1954 \|9999	probably 1943–47	1943	1947	15101	Gift of Liso Starrett, 1988	http://www.metmuseum.org/art/collection/search/95065	4/23/2018 8:00:01 AM	1
74934	1975.301.4a–c	96012	8	5881	Beachwear	1	201		Oscar de la Renta\|Saks Fifth Avenue\|Oscar de la Renta, Ltd.	American (born Dominican Republic), Santo Domingo 1932–2014 Kent, Connecticut\|American, founded 1924\|American, founded 1965	6260	222	1932-07-22\|1924 \|1965	2014 \|9999 \|9999	ca. 1972	1967	1977	15100	Gift of Mrs. Mortimer Solomon, 1975	http://www.metmuseum.org/art/collection/search/96012	4/23/2018 8:00:01 AM	1
75061	C.I.62.57.1	96164	8	5874	Evening dress	7	201		Pierre Balmain\|Bergdorf Goodman\|House of Balmain	French, St. Jean de Maurienne 1914–1982 Paris\|American, founded 1899\|French, founded 1945	5987	182	1914 \|1899 \|1945	1982 \|9999 \|9999	fall/winter 1956–57	1956	1957	15113	Gift of Mrs. Samuel I. Newhouse, 1962	http://www.metmuseum.org/art/collection/search/96164	4/23/2018 8:00:01 AM	1
78699	C.I.56.60.12	104770	8	1056	Hat	7	201		Cristobal Balenciaga\|Bergdorf Goodman\|House of Balenciaga	Spanish, Guetaria, San Sebastian 1895–1972 Javea\|American, founded 1899\|French, founded 1937	6493	236	1895-01-21\|1899 \|1937	1972-03-23\|9999 \|9999	spring/summer 1955	1955	1955	15101	Gift of Mrs. Byron C. Foy, 1956	http://www.metmuseum.org/art/collection/search/104770	4/23/2018 8:00:01 AM	1
79115	1986.248.3a, b	105509	8	5875	Ensemble	35	201		Issey Miyake\|Henri Bendel\|Miyake Design Studio	Japanese, born 1938\|American, founded 1895\|Japanese	6519	72	1938 \|1895	2038 \|9999	1974	1974	1974	17675	Gift of Barbara and Gregory Reynolds, 1986	http://www.metmuseum.org/art/collection/search/105509	4/23/2018 8:00:01 AM	1
81447	1975.79.8a–c	110068	8	5875	Ensemble	1	201		Oscar de la Renta\|Bergdorf Goodman\|Oscar de la Renta, Ltd.	American (born Dominican Republic), Santo Domingo 1932–2014 Kent, Connecticut\|American, founded 1899\|American, founded 1965	6574	222	1932-07-22\|1899 \|1965	2014 \|9999 \|9999	1965–75	1965	1975	15101	Gift of Anne Helen Hess, in memory of Audrey S. Hess, 1975	http://www.metmuseum.org/art/collection/search/110068	4/23/2018 8:00:01 AM	1
82484	1989.375.41	113733	8	173	Cap	35	201		Issey Miyake\|Bergdorf Goodman\|Miyake Design Studio	Japanese, born 1938\|American, founded 1899\|Japanese	6625	137	1938 \|1899	2038 \|9999	early 1980s	1980	1985	15104	Gift of Gregory R. Reynolds, 1989	http://www.metmuseum.org/art/collection/search/113733	4/23/2018 8:00:01 AM	1
90962	2009.300.2172	156969	8	5902	Necktie	1	201		Christian Dior\|G. Fox & Company\|House of Dior	French, Granville 1905–1957 Montecatini\|American, founded 1847\|French, founded 1947	7094	182	1905 \|1847 \|1947	1957 \|9999 \|9999	ca. 1963	1961	1965	15101	Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Richard Koopman, 1971	http://www.metmuseum.org/art/collection/search/156969	4/23/2018 8:00:01 AM	1