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 Alpha Sort] > :p2 or ([Artist Alpha Sort] = :p2 and rowid > :p1)) order by [Artist Alpha Sort], 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 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	River	Classification	Link Resource	Metadata Date	Repository
192300	1978.412.1006	0	311462	10	6840	Horn	4572	2	Dosen		17095				mid-20th century	1900	2000	3967	H. 17 1/2 in. (44.5 cm)	The Michael C. Rockefeller Memorial Collection; Gift of Nelson A. Rockefeller and Mrs. Mary C. Rockefeller, 1965	778	395	106	75	519	http://www.metmuseum.org/art/collection/search/311462	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
192311	1978.412.1017	0	311473	10	6840	Horn	4572	2	Ndojokor		17099				mid-20th century	1900	2000	3967	H. 20 in. (50.8 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/311473	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
346447	89.4.461	1	501079	18	6840	Horn	6232	1	Bakutu		47667	3484			late 19th century	1850	1900	54157	L. 50.8 cm (20 in.)	The Crosby Brown Collection of Musical Instruments, 1889			93		912	http://www.metmuseum.org/art/collection/search/501079	4/23/2018 8:00:01 AM	1
346454	89.4.468	1	501086	18	6840	Horn	6237	1	Mayumba people	Congo	47668	3485			late 19th century	1850	1900	25	L. 63.5 cm (25 in.); Diam. of large end 9.8 cm (3-7/8 in.)	The Crosby Brown Collection of Musical Instruments, 1889			768		912	http://www.metmuseum.org/art/collection/search/501086	4/23/2018 8:00:01 AM	1
347543	89.4.1651	0	502214	18	6840	Horn	6432	1	Ashanti (Asante)		47670	3487			late 19th century	1850	1900	54517	L. 1 ft. 9-1/2 in.	The Crosby Brown Collection of Musical Instruments, 1889					912	http://www.metmuseum.org/art/collection/search/502214	4/23/2018 8:00:01 AM	1