MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 9 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 date("Artist End Date") = :p0 and "Culture" = :p1 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	Object Number	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	Classification	Link Resource	Metadata Date	Repository
103643	09.165.4	191199	3	148	Portrait of Henry Irving, the actor	27	2	Medalist:	Wolfgang Lauer	German	8681		1850	1950	1891	1891	1891	20482	Diameter: 2 3/8 in. (6 cm)	Gift of Mr. and Mrs. Frederick S. Wait, 1909	306	http://www.metmuseum.org/art/collection/search/191199	4/23/2018 8:00:01 AM	1
139739	2009.266	236724	3	148	Landing of Zeppelin XVI in Lunéville	27	2	Medalist:	Karl Goetz	German, 1875–1950	12760	10	1875	1950	1913	1913	1913	23	Diameter: 50 mm	Gift of Stephen K. Scher, 2009	306	http://www.metmuseum.org/art/collection/search/236724	4/23/2018 8:00:01 AM	1
139741	2009.268	236726	3	148	Pope Benedict XV's Support	27	2	Medalist:	Karl Goetz	German, 1875–1950	12760	10	1875	1950	1914	1914	1914	23	Diameter: 57.7 mm	Gift of Stephen K. Scher, 2009	306	http://www.metmuseum.org/art/collection/search/236726	4/23/2018 8:00:01 AM	1
139742	2009.269	236727	3	148	Refusal of German Peace Overtures	27	2	Medalist:	Karl Goetz	German, 1875–1950	12760	10	1875	1950	1916	1916	1916	23	Diameter: 57.7 mm	Gift of Stephen K. Scher, 2009	306	http://www.metmuseum.org/art/collection/search/236727	4/23/2018 8:00:01 AM	1
139743	2009.270	236728	3	148	Abdication of Czar Nicholas II	27	2	Medalist:	Karl Goetz	German, 1875–1950	12760	10	1875	1950	1917	1917	1917	23	Diameter: 57.7 mm	Gift of Stephen K. Scher, 2009	306	http://www.metmuseum.org/art/collection/search/236728	4/23/2018 8:00:01 AM	1
139744	2009.271	236729	3	148	Armistice on the Eastern Front	27	2	Medalist:	Karl Goetz	German, 1875–1950	12760	10	1875	1950	1917	1917	1917	23	Diameter: 58.5 mm	Gift of Stephen K. Scher, 2009	306	http://www.metmuseum.org/art/collection/search/236729	4/23/2018 8:00:01 AM	1
139745	2009.272	236730	3	148	Oh Old Imperial Glory	27	2	Medalist:	Karl Goetz	German, 1875–1950	12760	10	1875	1950	1918	1918	1918	23	Diameter: 59 in.	Gift of Stephen K. Scher, 2009	306	http://www.metmuseum.org/art/collection/search/236730	4/23/2018 8:00:01 AM	1
139746	2009.273	236731	3	148	Hitler's Putsch in Munich	27	2	Medalist:	Karl Goetz	German, 1875–1950	12760	10	1875	1950	ca. 1923	1918	1928	23	Diameter: 59 mm	Gift of Stephen K. Scher, 2009	306	http://www.metmuseum.org/art/collection/search/236731	4/23/2018 8:00:01 AM	1
139747	2009.274	236732	3	148	The Heroic Song of Stalingrad	27	2	Medalist:	Karl Goetz	German, 1875–1950	12760	10	1875	1950	1943	1943	1943	23	Diameter: 109 mm	Gift of Stephen K. Scher, 2009	306	http://www.metmuseum.org/art/collection/search/236732	4/23/2018 8:00:01 AM	1