MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 11 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 "Medium" = :p0 order by [Artist Suffix] 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	Geography Type	Country	Classification	Rights and Reproduction	Link Resource	Metadata Date	Repository
430	83.2.248	1	486	1	69	Portrait of Benjamin Franklin									1776–1883	1776	1883	157	13 3/8 x 10 7/8 in. (34 x 27.6 cm)	Gift of William H. Huntington, 1883	1	15	11		http://www.metmuseum.org/art/collection/search/486	4/23/2018 8:00:01 AM	1
22113	29.158.449	0	26971	5	2635	Lining for Tilting Heaume	27								1500	1500	1500	157		Bashford Dean Memorial Collection, Funds from various donors, 1929			64		http://www.metmuseum.org/art/collection/search/26971	4/23/2018 8:00:01 AM	1
125529	09.50.179	0	215580	3	8806	Peasant costume fragment	3645								18th–19th century	1700	1899	157	L. 5 1/2 x W. 6 1/2 inches (14 x 16.5 cm)	Rogers Fund, 1909			187		http://www.metmuseum.org/art/collection/search/215580	4/23/2018 8:00:01 AM	1
125538	09.50.188	0	215589	3	8806	Peasant costume fragment	3645								18th–19th century	1700	1899	157	L. 7 x W. 5 3/4 inches (17.8 x 14.6 cm)	Rogers Fund, 1909			187		http://www.metmuseum.org/art/collection/search/215589	4/23/2018 8:00:01 AM	1
125555	09.50.206	0	215606	3	8806	Peasant costume fragment	3645								18th–19th century	1700	1899	157	L. 4 1/4 x W. 4 1/4 inches (10.8 x 10.8 cm)	Rogers Fund, 1909			187		http://www.metmuseum.org/art/collection/search/215606	4/23/2018 8:00:01 AM	1
126686	09.50.2444	1	217114	3	486	Fragment	462								early 19th century	1800	1815	157	L. 7 5/8 x W. 7 3/8 inches 19.4 x 18.7 cm	Rogers Fund, 1909			187		http://www.metmuseum.org/art/collection/search/217114	4/23/2018 8:00:01 AM	1
126892	09.50.2804	1	217399	3	1025	Hanging	195								late 17th–early 18th century	1685	1724	157	H. 146 x W. 31 inches 370.8 x 78.7 cm	Rogers Fund, 1909			198		http://www.metmuseum.org/art/collection/search/217399	4/23/2018 8:00:01 AM	1
130486	26.56.149	1	221775	3	1441	Mask	122								ca. 1750	1745	1755	157	H. 6 1/2 x W. 8 1/2 inches (16.5 x 21.6 cm)	Rogers Fund, 1926			381		http://www.metmuseum.org/art/collection/search/221775	4/23/2018 8:00:01 AM	1
130487	26.56.150	1	221776	3	1441	Mask	122								ca. 1750	1745	1755	157	H. 6 1/2 x W. 8 inches (16.5 x 20.3 cm)	Rogers Fund, 1926			381		http://www.metmuseum.org/art/collection/search/221776	4/23/2018 8:00:01 AM	1
136645	57.122.605	0	228528	3	1007	Sampler	27								19th century	1800	1899	157	H. 24 1/4 x W. 14 1/2 inches (61.6 x 36.8 cm) With rosettes: H. 25 x W. 15 1/2 inches (63.5 x 39.4 cm)	From the Collection of Mrs. Lathrop Colgate Harper, Bequest of Mabel Herbert Harper, 1957			187		http://www.metmuseum.org/art/collection/search/228528	4/23/2018 8:00:01 AM	1
411433	2015.237	0	678067	4	1143	Tone-bar room map		2	Robert Overby	American, Harvey, Illinois 1935–1993 Los Angeles	51928	1	1935	1993	1972	1972	1972	157	106 1/2 × 116 in. (270.5 × 294.6 cm)	Purchase, Lila Acheson Wallace Gift, 2015			16	© Robert Overby	http://www.metmuseum.org/art/collection/search/678067	4/23/2018 8:00:01 AM	1