MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 10 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 "Object Name" = :p0 and ([Artist End Date] is not null or ([Artist End Date] is null and rowid > :p1)) order by [Artist End Date], rowid limit 101

Query parameters

This data as json, CSV

rowid	Object Number	Is Public Domain	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	Dimensions	Credit Line	City	County	Country	Region	River	Classification	Link Resource	Metadata Date	Repository
350759	89.4.2390	0	505746	18	6840	Horn										19th century	1800	1899	55520	Length, 8-1/4"	The Crosby Brown Collection of Musical Instruments, 1889						912	http://www.metmuseum.org/art/collection/search/505746	4/23/2018 8:00:01 AM	1
434424	GK.341	0	722263	10	6840	Conch Trumpet	4341									A.D. 250-–400	250	400	61488	11 9/16 × 5 1/4 in. (29.3 × 13.4 cm)	Kimbell Art Museum, Fort Worth, Texas (AP 1984.11)			2	761		566	http://www.metmuseum.org/art/collection/search/722263	4/23/2018 8:00:01 AM	1
99301	83.18.211	1	186637	3	6840	Horn	2202	6	After an original by	Elkington & Co.\|Jacob Mores	British, Birmingham, 1829–1963\|Hamburg, 1540–ca. 1612, master 1579	8031	7	1829 \|1540	1963 \|1617	19th century, after 1597–1609 original	1800	1899	20525	Overall (confirmed): 13 13/16 × 19 1/8 × 4 1/2 in. (35.1 × 48.6 × 11.4 cm)	Gift of Henry G. Marquand, 1883						136	http://www.metmuseum.org/art/collection/search/186637	4/23/2018 8:00:01 AM	1
192294	1978.412.1000	0	311456	10	6840	Horn	4572	2		Biain		17092		1920	2020	mid-20th century	1900	2000	3967	H. 30 1/2 in. (77.5 cm)	The Michael C. Rockefeller Memorial Collection; Gift of Nelson A. Rockefeller and Mrs. Mary C. Rockefeller, 1965	830	395	106		105	519	http://www.metmuseum.org/art/collection/search/311456	4/23/2018 8:00:01 AM	1
192296	1978.412.1002	0	311458	10	6840	Horn	4572	2		Watur possibly		17093		1920	2020	mid-20th century	1900	2000	3967	H. 14 in. (35.6 cm)	The Michael C. Rockefeller Memorial Collection; Gift of Nelson A. Rockefeller and Mrs. Mary C. Rockefeller, 1965	828	395	106		105	519	http://www.metmuseum.org/art/collection/search/311458	4/23/2018 8:00:01 AM	1
192302	1978.412.1008	0	311464	10	6840	Horn	4572	2		Avamu		17096		1920	2020	mid-20th century	1900	2000	3967	H. 16 3/8 in. (41.6 cm)	The Michael C. Rockefeller Memorial Collection; Gift of Nelson A. Rockefeller and Mrs. Mary C. Rockefeller, 1965	810	395	106		76	519	http://www.metmuseum.org/art/collection/search/311464	4/23/2018 8:00:01 AM	1
192308	1978.412.1014	0	311470	10	6840	Horn	4572	2		Bifarji		17097		1920	2020	mid-20th century	1900	2000	27071	H. 25 in. (63.5 cm)	The Michael C. Rockefeller Memorial Collection; Gift of Nelson A. Rockefeller and Mrs. Mary C. Rockefeller, 1965	771	395	106		71	519	http://www.metmuseum.org/art/collection/search/311470	4/23/2018 8:00:01 AM	1
192309	1978.412.1015	0	311471	10	6840	Horn	4572	2		Shuw		17098		1920	2020	mid-20th century	1900	2000	3967	Height 15-1/4 in.	The Michael C. Rockefeller Memorial Collection; Gift of Nelson A. Rockefeller and Mrs. Mary C. Rockefeller, 1965	771	395	106		71	519	http://www.metmuseum.org/art/collection/search/311471	4/23/2018 8:00:01 AM	1
192310	1978.412.1016	0	311472	10	6840	Horn	4572	2		Shuw		17098		1920	2020	mid-20th century	1900	2000	3967	H. 14 1/4 in. (36.2 cm)	The Michael C. Rockefeller Memorial Collection; Gift of Nelson A. Rockefeller and Mrs. Mary C. Rockefeller, 1965	771	395	106		71	519	http://www.metmuseum.org/art/collection/search/311472	4/23/2018 8:00:01 AM	1
192313	1978.412.1019	0	311475	10	6840	Horn	4572	13		Ndojokor\|Bati		17100		1920	2020	mid-20th century	1900	2000	3967	H. 23 1/4 in. (59.1 cm)	The Michael C. Rockefeller Memorial Collection; Gift of Nelson A. Rockefeller and Mrs. Mary C. Rockefeller, 1965	771	395	106		71	519	http://www.metmuseum.org/art/collection/search/311475	4/23/2018 8:00:01 AM	1