MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 4 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	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	Credit Line	Classification	Link Resource	Metadata Date	Repository
167499	55.570	269777	13	1119	[Scrapbook of 16 photographs and 3 waxed paper negative by John Forbes White]	2	John White	British, Scotland 1831–1904	14957	8	1831	1904	1850s	1850	1859		Gift of Dr. Laurence S. Kubie, 1955	441	http://www.metmuseum.org/art/collection/search/269777	4/23/2018 8:00:01 AM	1
167506	55.570.15	269784	13	13037	[The Brig O'Baigownie, Aberdeen]	2	John White	British, Scotland 1831–1904	14957	8	1831	1904	1857	1857	1857	26249	Gift of Dr. Lawrence S. Kubie, 1955	451	http://www.metmuseum.org/art/collection/search/269784	4/23/2018 8:00:01 AM	1
167507	55.570.16	269785	13	13037	[Cathedral Portal with Man Seated on Steps]	2	John White	British, Scotland 1831–1904	14957	8	1831	1904	ca. 1857	1855	1859	26249	Gift of Dr. Lawrence S. Kubie, 1955	451	http://www.metmuseum.org/art/collection/search/269785	4/23/2018 8:00:01 AM	1
167508	55.570.17	269786	13	13037	[Mill Outside Aberdeen]	2	John White	British, Scotland 1831–1904	14957	8	1831	1904	ca. 1857	1855	1859	26249	Gift of Dr. Lawrence S. Kubie, 1955	451	http://www.metmuseum.org/art/collection/search/269786	4/23/2018 8:00:01 AM	1