MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 8 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 Alpha Sort" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	Object Number	Object ID	Department	Object Name	Title	Culture	Artist Role	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
66661	1996.387.1a–h	79233	8	5875	Ensemble	7	202	Gianfranco Ferré\|House of Dior	Italian, 1944–2007\|French, founded 1947	5351	148	1944 \|1947	2007 \|9999	spring/summer 1993	1993	1993	15186	Gift of Christian Dior, 1996	http://www.metmuseum.org/art/collection/search/79233	4/23/2018 8:00:01 AM	1
66662	1996.387.2a–g	79234	8	5875	Ensemble	7	202	Gianfranco Ferré\|House of Dior	Italian, 1944–2007\|French, founded 1947	5351	148	1944 \|1947	2007 \|9999	fall/winter 1993–94	1993	1994	15187	Gift of Christian Dior, 1996	http://www.metmuseum.org/art/collection/search/79234	4/23/2018 8:00:01 AM	1
66663	1996.387.3a–l	79235	8	5875	Ensemble	7	202	Gianfranco Ferré\|House of Dior	Italian, 1944–2007\|French, founded 1947	5351	148	1944 \|1947	2007 \|9999	spring/summer 1994	1994	1994	15188	Gift of Christian Dior, 1996	http://www.metmuseum.org/art/collection/search/79235	4/23/2018 8:00:01 AM	1
66664	1996.387.4a–c	79236	8	5902	Necktie	7	202	Gianfranco Ferré\|House of Dior	Italian, 1944–2007\|French, founded 1947	5351	148	1944 \|1947	2007 \|9999	fall/winter 1995–96	1995	1996	15101	Gift of Christian Dior, 1996	http://www.metmuseum.org/art/collection/search/79236	4/23/2018 8:00:01 AM	1
66665	1996.387.5a–d	79237	8	5902	Necktie	7	202	Gianfranco Ferré\|House of Dior	Italian, 1944–2007\|French, founded 1947	5351	148	1944 \|1947	2007 \|9999	early 1990s	1990	1995	15101	Gift of Christian Dior, 1996	http://www.metmuseum.org/art/collection/search/79237	4/23/2018 8:00:01 AM	1
66863	1997.59.28	79451	8	5909	Brassiere	7	202	Gianfranco Ferré\|House of Dior	Italian, 1944–2007\|French, founded 1947	5351	148	1944 \|1947	2007 \|9999	1990–97	1990	1997	15247	Gift of the Estate of Luciana Martinez de la Rosa, 1997	http://www.metmuseum.org/art/collection/search/79451	4/23/2018 8:00:01 AM	1
67532	1995.76a, b	80214	8	5900	Evening pumps	7	202	Gianfranco Ferré\|House of Dior	Italian, 1944–2007\|French, founded 1947	5351	148	1944 \|1947	2007 \|9999	1991	1991	1991	15390	Gift of Victor Patiño, 1995	http://www.metmuseum.org/art/collection/search/80214	4/23/2018 8:00:01 AM	1
72135	2002.553.1a–c	87862	8	5875	Ensemble	7	202	Gianfranco Ferré\|House of Dior	Italian, 1944–2007\|French, founded 1947	5351	148	1944 \|1947	2007 \|9999	1996	1996	1996	15926	Gift of Andrew Tilberis, in memory of Liz Tilberis, 2002	http://www.metmuseum.org/art/collection/search/87862	4/23/2018 8:00:01 AM	1