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 date("Artist Begin Date") = :p0 and "Department" = :p1 order by [Object Name] limit 101

Query parameters

This data as json, CSV

rowid	Object Number	Object ID	Department	Object Name	Title	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	Dimensions	Credit Line	Geography Type	City	Country	Classification	Rights and Reproduction	Link Resource	Metadata Date	Repository
429161	SL.32.2016.1.7a, b	712277	9		Books for the Road (Two books)	2	Zarina	American, born Aligarh, India, 1937	47587		1937	2037	1998	1998	1998	61115	4 x 4 x 4 inches	On loan from Zarina				1		http://www.metmuseum.org/art/collection/search/712277	4/23/2018 8:00:01 AM	1
429162	SL.32.2016.1.8	712279	9		Houses	2	Zarina	American, born Aligarh, India, 1937	47587		1937	2037	1982	1982	1982	61116	Height: 4 1/2 in. (11.4 cm) Width: 13 1/2 in. (34.3 cm) Depth: 2 1/2 in. (6.4 cm)	On loan from Zarina				1		http://www.metmuseum.org/art/collection/search/712279	4/23/2018 8:00:01 AM	1
429163	SL.32.2016.1.9	712280	9		Roofs	2	Zarina	American, born Aligarh, India, 1937	47587		1937	2037	1982	1982	1982	61117	Height: 10 in. (25.4 cm) Width: 9 in. (22.9 cm) Depth: 3 in. (7.6 cm)					1		http://www.metmuseum.org/art/collection/search/712280	4/23/2018 8:00:01 AM	1
429165	SL.32.2016.1.10a–g	712284	9		Atlas of My World (Six Works)	2	Zarina	American, born Aligarh, India, 1937	47587		1937	2037	2001	2001	2001	61119	Sheet size: 25.5 x 19.5 inches Image size: Variable	Promised Gift from Zarina				13		http://www.metmuseum.org/art/collection/search/712284	4/23/2018 8:00:01 AM	1
436731	SL.32.2016.2.13	726796	9		Paris, 1963-67	2	Zarina	American, born Aligarh, India, 1937	47587		1937	2037	1997	1997	1997	26137	Height: 21 in. (53.3 cm) Width: 19 in. (48.3 cm)	On loan from Krishna Reddy	9	27	9	779		http://www.metmuseum.org/art/collection/search/726796	4/23/2018 8:00:01 AM	1
389387	2014.299.1, .2	640046	9	69	Callilgraphic Drawing 1 and 2, Untitled	2	Faramarz Pilaram	Iranian, Tehran 1937–1982 Tehran	49688	92	1937	1982	1979	1954	2004	47664	H. 8 in. (20.32 cm) W. 8 in. (20.32 cm)	Purchase, 2012 NoRuz at The Met Benefit, 2014				11		http://www.metmuseum.org/art/collection/search/640046	4/23/2018 8:00:01 AM	1
320654	2012.39	457770	9	100	Poet Turning Into Heech	2	Parviz Tanavoli	Iranian, born Tehran, 1937	44297	92	1937	2037	2007	1982	2032	23	H. 89 13/16 in. (228.1 cm) W. 22 13/16 in. (57.9 cm) D. 25 1/2 in. (64.8 cm) Wt. 594 lbs. (269.4 kg)	Purchase, 2011 NoRuz at The Met Benefit, 2012	1	1832	10	12	© Parviz Tanavoli	http://www.metmuseum.org/art/collection/search/457770	4/23/2018 8:00:01 AM	1
429166	SL.32.2016.1.11	712285	9	7532	Travels with Rani	2	Zarina	American, born Aligarh, India, 1937	47587		1937	2037	2008	2008	2008	61120	Sheet size: 24 x 20 inches Image size: 14.5 x 13 inches	Promised Gift from Zarina				13		http://www.metmuseum.org/art/collection/search/712285	4/23/2018 8:00:01 AM	1
437005	SL.32.2016.1.12	727076	9	7532	Man	2	Zarina	American, born Aligarh, India, 1937	47587		1937	2037		0	0	61654		On loan from Zarina				13		http://www.metmuseum.org/art/collection/search/727076	4/23/2018 8:00:01 AM	1
429154	SL.32.2016.1.1	712270	9	27078	Tasbih	2	Zarina	American, born Aligarh, India, 1937	47587		1937	2037	2001	1901	2001	61113	500 units, Each unit: 1 x .625 x .5 inches Total length: 258 inches	On loan from Zarina				536		http://www.metmuseum.org/art/collection/search/712270	4/23/2018 8:00:01 AM	1
429155	SL.32.2016.1.2	712271	9	27079	I Went on a Journey I	2	Zarina	American, born Aligarh, India, 1937	47587		1937	2037	1991	1991	1991	61114	Height: 11 1/2 in. (29.2 cm) Width: 6 in. (15.2 cm) Depth: 6 in. (15.2 cm)	On loan from Zarina				1		http://www.metmuseum.org/art/collection/search/712271	4/23/2018 8:00:01 AM	1
429156	SL.32.2016.1.3	712272	9	27079	I Went on a Journey III	2	Zarina	American, born Aligarh, India, 1937	47587		1937	2037	1991	1991	1991	61114	10.5 x 5 x 5 inches	On loan from Zarina				1		http://www.metmuseum.org/art/collection/search/712272	4/23/2018 8:00:01 AM	1
429158	SL.32.2016.1.4	712274	9	27079	I Went on a Journey V	2	Zarina	American, born Aligarh, India, 1937	47587		1937	2037	1991	1991	1991	61114	7 x 5 x 5 inches	On loan from Zarina				1		http://www.metmuseum.org/art/collection/search/712274	4/23/2018 8:00:01 AM	1
429159	SL.32.2016.1.5	712275	9	27080	Moving House II	2	Zarina	American, born Aligarh, India, 1937	47587		1937	2037	1991	1991	1991	61114	Height: 6 1/4 in. (15.9 cm) Width: 4 1/4 (10.8 cm) Depth: 1/2 in. (1.3 cm)	On loan from Zarina				1		http://www.metmuseum.org/art/collection/search/712275	4/23/2018 8:00:01 AM	1
429160	SL.32.2016.1.6	712276	9	27080	Moving House VI	2	Zarina	American, born Aligarh, India, 1937	47587		1937	2037	1992	1992	1992	61114	Height: 10 in. (25.4 cm) Width: 8 in.(20.3 cm) Depth: 3/4 in. (1.9 cm)	On loan from Zarina				1		http://www.metmuseum.org/art/collection/search/712276	4/23/2018 8:00:01 AM	1