MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 15 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 Title 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
74955	1989.376.6	96037	8	5953	Blouse	7	200		Karl Lagerfeld\|Chloé\|Saks Fifth Avenue	French, born Hamburg, 1938\|French, founded 1952\|American, founded 1924	5264	136	1938 \|1952 \|1924	2038 \|9999 \|9999	1970–80s	1970	1989	15101	Gift of Estate of Stella M. Saltonstall, 1989	http://www.metmuseum.org/art/collection/search/96037	4/23/2018 8:00:01 AM	1
79042	1975.239	105392	8	5877	Dress	1	200		Rudi Gernreich\|Harmon Knitwear\|Lord & Taylor	American (born Austria), Vienna 1922–1985 Los Angeles, California\|American\|American, founded 1826	6517	189	1922 \|1826	1985 \|2050	1967–69	1967	1969	15104	Gift of Gabriele Knecht, 1975	http://www.metmuseum.org/art/collection/search/105392	4/23/2018 8:00:01 AM	1
68232	1993.510.1a, b	81027	8	5875	Ensemble	1	200		Donna Karan\|Donna Karan New York\|Bergdorf Goodman	American, born 1948\|American, founded 1985\|American, founded 1899	5652	101	1948 \|1985 \|1899	2048 \|1985 \|9999	1985	1985	1985	15104	Gift of Amy Fine Collins, 1993	http://www.metmuseum.org/art/collection/search/81027	4/23/2018 8:00:01 AM	1
74948	1985.361.2a–d	96029	8	5875	Ensemble	7	200	Attributed to	Karl Lagerfeld\|Chloé\|Saks Fifth Avenue	French, born Hamburg, 1938\|French, founded 1952\|American, founded 1924	5264	136	1938 \|1952 \|1924	2038 \|9999 \|9999	1982–83	1982	1983	15118	Gift of Mrs. Henry W. Breyer III, 1985	http://www.metmuseum.org/art/collection/search/96029	4/23/2018 8:00:01 AM	1
74949	1984.601.10a, b	96030	8	5875	Ensemble	7	200		Karl Lagerfeld\|Chloé\|Henri Bendel	French, born Hamburg, 1938\|French, founded 1952\|American, founded 1895	6262	142	1938 \|1952 \|1895	2038 \|9999 \|9999	spring/summer 1977	1977	1977	15101	Gift of Mrs. Howard L. Ross, 1984	http://www.metmuseum.org/art/collection/search/96030	4/23/2018 8:00:01 AM	1
74888	C.I.57.29.8	95478	8	5920	Evening coat	7	200		Cristobal Balenciaga\|House of Balenciaga\|Bergdorf Goodman	Spanish, Guetaria, San Sebastian 1895–1972 Javea\|French, founded 1937\|American, founded 1899	6250	220	1895-01-21\|1937 \|1899	1972-03-23\|9999 \|9999	fall/winter 1954–55	1954	1955	15101	Gift of Mrs. Byron C. Foy, 1957	http://www.metmuseum.org/art/collection/search/95478	4/23/2018 8:00:01 AM	1
66431	1996.61.15	78956	8	5874	Evening dress	7	200		Karl Lagerfeld\|Chloé\|Saks Fifth Avenue	French, born Hamburg, 1938\|French, founded 1952\|American, founded 1924	5264	136	1938 \|1952 \|1924	2038 \|9999 \|9999	1975–79	1975	1979	15101	Gift of Roz Gerten Jacobs, 1996	http://www.metmuseum.org/art/collection/search/78956	4/23/2018 8:00:01 AM	1
74825	1984.55a, b	95410	8	5874	Evening dress	7	200		Cristobal Balenciaga\|House of Balenciaga\|Bergdorf Goodman	Spanish, Guetaria, San Sebastian 1895–1972 Javea\|French, founded 1937\|American, founded 1899	6250	220	1895-01-21\|1937 \|1899	1972-03-23\|9999 \|9999	1947	1947	1947	16239	Gift of René Dubos, 1984	http://www.metmuseum.org/art/collection/search/95410	4/23/2018 8:00:01 AM	1
75714	1983.296.2a–c	97193	8	5879	Evening pajamas	7	200		Yves Saint Laurent\|Yves Saint Laurent, Paris\|Bergdorf Goodman	French (born Algeria) Oran 1936–2008 Paris\|French, founded 1961\|American, founded 1899	6334	164	1936 \|1961 \|1899	2008 \|9999 \|9999	1977	1977	1977	15101	Gift of Mrs. Charles Wrightsman, 1983	http://www.metmuseum.org/art/collection/search/97193	4/23/2018 8:00:01 AM	1
77107	1986.517.10	100628	8	1056	Hat	7	200		Marc Bohan\|House of Dior\|Bergdorf Goodman	French, born 1926\|French, founded 1947\|American, founded 1899	6430	164	1926-08-22\|1947 \|1899	2026 \|9999 \|9999	1963	1963	1963	15933	Gift of Betty Furness, 1986	http://www.metmuseum.org/art/collection/search/100628	4/23/2018 8:00:01 AM	1
74929	1985.361.1	96007	8	4399	Jacket	1	200		Bill Blass\|Bill Blass Ltd.\|Saks Fifth Avenue	American, Fort Wayne, Indiana 1922–2002 New Preston, Connecticut\|American, founded 1970\|American, founded 1924	6259	101	1922-08-22\|1970 \|1924	2002-06-12\|9999 \|9999	1979	1979	1979	15128	Gift of Mrs. Henry W. Breyer III, 1985	http://www.metmuseum.org/art/collection/search/96007	4/23/2018 8:00:01 AM	1
68943	2000.369.3	81823	8	5956	Jumpsuit	1	200		Donna Karan\|Donna Karan New York\|Bergdorf Goodman	American, born 1948\|American, founded 1985\|American, founded 1899	5652	101	1948 \|1985 \|1899	2048 \|1985 \|9999	spring/summer 1986	1986	1986	3340	Gift of Peter R. Feuchtwanger, 2000	http://www.metmuseum.org/art/collection/search/81823	4/23/2018 8:00:01 AM	1
86262	1978.36.3	121723	8	5902	Necktie	1	200		Elsa Schiaparelli\|House of Schiaparelli\|B. Altman & Co.	Italian, 1890–1973\|French, founded 1928\|American, 1865–1990	6731	250	1890 \|1928 \|1865	1973 \|9999 \|1990	1940s	1940	1949	15101	Gift of Mrs. Doris E. Grossman, 1978	http://www.metmuseum.org/art/collection/search/121723	4/23/2018 8:00:01 AM	1
66427	1996.61.10a, b	78951	8	5876	Suit	7	200		Karl Lagerfeld\|Chloé\|I. Magnin & Co.	French, born Hamburg, 1938\|French, founded 1952\|American, founded 1876	5261	136	1938 \|1952 \|1876	2038 \|9999	1973–77	1973	1977	15104	Gift of Roz Gerten Jacobs, 1996	http://www.metmuseum.org/art/collection/search/78951	4/23/2018 8:00:01 AM	1
68183	1998.484.3a, b	80965	8	5876	Suit	1	200		Donna Karan\|Donna Karan New York\|Bergdorf Goodman	American, born 1948\|American, founded 1985\|American, founded 1899	5652	101	1948 \|1985 \|1899	2048 \|1985 \|9999	1990s	1990	1998	15104	Gift of Anne H. Bass, 1998	http://www.metmuseum.org/art/collection/search/80965	4/23/2018 8:00:01 AM	1