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	Is Highlight	Is Public Domain	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	Classification	Link Resource	Metadata Date	Repository
10332	50.220.1	0	1	11205	2	69	Little Girl with Flowers (Amelia Palmer)	2	Charles Cromwell Ingham	American (born Ireland), Dublin 1786–1863 New York	1531	37	1786	1863	ca. 1830	1827	1830	953	67 7/8 x 53 1/4 in. (172.4 x 135.3 cm)	Gift of Courtlandt Palmer, 1950	11	http://www.metmuseum.org/art/collection/search/11205	4/23/2018 8:00:01 AM	1
10333	37.161	0	1	11206	2	73	Benjamin Moore McVickar	2	Charles Cromwell Ingham	American (born Ireland), Dublin 1786–1863 New York	1531	37	1786	1863	ca. 1825	1822	1825	620	3 3/16 x 3 3/16 in. (8.1 x 8.1 cm)	Fletcher Fund, 1937	11	http://www.metmuseum.org/art/collection/search/11206	4/23/2018 8:00:01 AM	1
10334	02.7.1	1	1	11207	2	69	The Flower Girl	2	Charles Cromwell Ingham	American (born Ireland), Dublin 1786–1863 New York	1531	37	1786	1863	1846	1846	1846	953	36 x 28 3/8 in. (91.4 x 72.1 cm)	Gift of William Church Osborn, 1902	11	http://www.metmuseum.org/art/collection/search/11207	4/23/2018 8:00:01 AM	1
10335	22.45.2	0	1	11208	2	69	Mrs. David Cadwallader Colden	2	Charles Cromwell Ingham	American (born Ireland), Dublin 1786–1863 New York	1531	37	1786	1863	1830	1830	1830	953	28 3/4 x 23 3/4 in. (73 x 60.3 cm)	Bequest of Grace Wilkes, 1922	11	http://www.metmuseum.org/art/collection/search/11208	4/23/2018 8:00:01 AM	1
10337	1977.182.8	0	1	11210	2	23	Shipwreck	2	Charles Cromwell Ingham	American (born Ireland), Dublin 1786–1863 New York	1531	37	1786	1863		1796	1863	37	4 1/4 x 6 5/8 in. (10.8 x 16.8 cm)	Gift of Erving Wolf Foundation, in memory of Diane R. Wolf, 1977	9	http://www.metmuseum.org/art/collection/search/11210	4/23/2018 8:00:01 AM	1
13920	2006.235.92	0	1	15087	2	73	Portrait of a Lady	2	Charles Cromwell Ingham	American (born Ireland), Dublin 1786–1863 New York	1531	37	1786	1863	ca. 1836–38	1836	1838	620	3 1/4 x 2 1/2 in. (8.3 x 6.5 cm)	Dale T. Johnson Fund, 2006	11	http://www.metmuseum.org/art/collection/search/15087	4/23/2018 8:00:01 AM	1
13921	2006.235.91	0	1	15088	2	73	Uncle Charles	2	Charles Cromwell Ingham	American (born Ireland), Dublin 1786–1863 New York	1531	37	1786	1863	1844	1844	1844	620	4 1/8 x 3 1/8 in. (10.5 x 8 cm)	Gift of Gloria Manney, 2006	11	http://www.metmuseum.org/art/collection/search/15088	4/23/2018 8:00:01 AM	1
13922	2006.235.90	0	1	15089	2	73	Aunt Rhoda	2	Charles Cromwell Ingham	American (born Ireland), Dublin 1786–1863 New York	1531	37	1786	1863	1844	1844	1844	620	4 1/8 x 3 1/8 in. (10.5 x 8 cm)	Gift of Gloria Manney, 2006	11	http://www.metmuseum.org/art/collection/search/15089	4/23/2018 8:00:01 AM	1