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 "Artist Role" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	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	City	Classification	Link Resource	Metadata Date	Repository
225077	26.56.3	0	352671	11	97	Geschichte Friedrichs des Grossen	2869	Written by\|Printed by\|Published by	Franz Kugler\|Adolph Menzel\|F. A. Brockhaus, Leipzig\|J. J. Weber'sche Buchhandlung	1808–1858\|German, Breslau 1815–1905 Berlin\|German	, Leipzig	26714	924	1808 \|1815	1858 \|1905	1840	1840	1840	29987	Overall: 9 15/16 x 6 11/16 x 1 5/8 in. (25.2 x 17 x 4.2 cm)	Harris Brisbane Dick Fund, 1926		442	http://www.metmuseum.org/art/collection/search/352671	4/23/2018 8:00:01 AM	1
225078	35.40.1	0	352672	11	97	Geschichte Friedrichs des Grossen	2869	Written by\|Printed by\|Published by	Franz Kugler\|Adolph Menzel\|F. A. Brockhaus, Leipzig\|J. J. Weber'sche Buchhandlung	1808–1858\|German, Breslau 1815–1905 Berlin\|German	, Leipzig	26714	924	1808 \|1815	1858 \|1905	1840	1840	1840		Overall: 10 5/8 x 6 15/16 x 1 5/8 in. (27 x 17.7 x 4.1 cm)	Harris Brisbane Dick Fund, 1935		442	http://www.metmuseum.org/art/collection/search/352672	4/23/2018 8:00:01 AM	1
267523	32.35(134)	1	396566	11	731	Hudibras Vanquished by Trulla (Twelve Large Illustrations for Samuel Butler's Hudibras, Plate 5)	2869	Illustrates	Samuel Butler\|William Hogarth\|Philip Overton\|John Cooper	British, baptized Strensham, Worcestershire 1613–1680 Covent Garden\|British, London 1697–1764 London\|British, active from 1707, died 1744\|London		39492	177	1580 \|1697 \|1700 \|1700	1680 \|1764 \|1744 \|1800	February 1725–26	1725	1726	39698	sheet: 9 7/8 x 12 7/8 in. (25.1 x 32.7 cm) (trimmed within platemark)	Harris Brisbane Dick Fund, 1932		13	http://www.metmuseum.org/art/collection/search/396566	4/23/2018 8:00:01 AM	1
301663	22.72.4bis	0	431442	11	97	Das Buch Granatapfel, im latin genant Melogranatus [...]	2869		Johann Geiler von Kaisersberg\|Hans Burgkmair\|Johann Otmar\|Georg Diemar	German (born Switzerland), Schaffhausen 1445–1510 Strasbourg\|German, Augsburg 1473–1531 Augsburg\|German, Augsburg, 1502–1514\|German, Augsburg		43043	924	1445 \|1473 \|1502	1510 \|1531 \|1514	1510	1510	1510	44327	Overall: 9 5/8 × 7 1/4 × 1 3/4 in. (24.4 × 18.4 × 4.4 cm)	Purchase, Jacob H. Schiff Bequest, 1922	424	442	http://www.metmuseum.org/art/collection/search/431442	4/23/2018 8:00:01 AM	1
301669	22.72.4bis(1)	0	431448	11	731	Christ in the House of Lazarus, Martha and Mary, from Das Buch Granatapfel, im latin genant Melogranatus [...]	2869		Johann Geiler von Kaisersberg\|Hans Burgkmair\|Johann Otmar\|Georg Diemar	German (born Switzerland), Schaffhausen 1445–1510 Strasbourg\|German, Augsburg 1473–1531 Augsburg\|German, Augsburg, 1502–1514\|German, Augsburg		43043	924	1445 \|1473 \|1502	1510 \|1531 \|1514	1510	1510	1510	44327	Sheet: 6 3/4 × 4 13/16 in. (17.2 × 12.2 cm)	Purchase, Jacob H. Schiff Bequest, 1922	424	13	http://www.metmuseum.org/art/collection/search/431448	4/23/2018 8:00:01 AM	1
301671	22.72.4bis(2)	0	431450	11	731	The Destruction of the Pharoah in the Red Sea, from Das Buch Granatapfel, im latin genant Melogranatus [...]	2869		Johann Geiler von Kaisersberg\|Hans Burgkmair\|Johann Otmar\|Georg Diemar	German (born Switzerland), Schaffhausen 1445–1510 Strasbourg\|German, Augsburg 1473–1531 Augsburg\|German, Augsburg, 1502–1514\|German, Augsburg		43043	924	1445 \|1473 \|1502	1510 \|1531 \|1514	1510	1510	1510	44327	Plate: 6 3/4 × 4 13/16 in. (17.1 × 12.2 cm)	Purchase, Jacob H. Schiff Bequest, 1922	424	13	http://www.metmuseum.org/art/collection/search/431450	4/23/2018 8:00:01 AM	1
301673	22.72.4bis(3)	0	431452	11	731	Saint Elizabeth of Hungary Spinning, from Das Buch Granatapfel, im latin genant Melogranatus [...]	2869		Johann Geiler von Kaisersberg\|Hans Burgkmair\|Johann Otmar\|Georg Diemar	German (born Switzerland), Schaffhausen 1445–1510 Strasbourg\|German, Augsburg 1473–1531 Augsburg\|German, Augsburg, 1502–1514\|German, Augsburg		43043	924	1445 \|1473 \|1502	1510 \|1531 \|1514	1510	1510	1510	44327	Plate: 6 3/4 × 4 3/4 in. (17.2 × 12.1 cm)	Purchase, Jacob H. Schiff Bequest, 1922	424	13	http://www.metmuseum.org/art/collection/search/431452	4/23/2018 8:00:01 AM	1
301676	22.72.4bis(4)	0	431455	11	731	A Cook Disembowling a Hare, from Das Buch Granatapfel, im latin genant Melogranatus [...]	2869		Johann Geiler von Kaisersberg\|Hans Burgkmair\|Johann Otmar\|Georg Diemar	German (born Switzerland), Schaffhausen 1445–1510 Strasbourg\|German, Augsburg 1473–1531 Augsburg\|German, Augsburg, 1502–1514\|German, Augsburg		43043	924	1445 \|1473 \|1502	1510 \|1531 \|1514	1510	1510	1510	44327	Plate: 6 3/4 × 4 13/16 in. (17.1 × 12.2 cm)	Purchase, Jacob H. Schiff Bequest, 1922	424	13	http://www.metmuseum.org/art/collection/search/431455	4/23/2018 8:00:01 AM	1
301677	22.72.4bis(5)	0	431456	11	731	Seven Demons with Swords, from Das Buch Granatapfel, im latin genant Melogranatus [...]	2869		Johann Geiler von Kaisersberg\|Hans Burgkmair\|Johann Otmar\|Georg Diemar	German (born Switzerland), Schaffhausen 1445–1510 Strasbourg\|German, Augsburg 1473–1531 Augsburg\|German, Augsburg, 1502–1514\|German, Augsburg		43043	924	1445 \|1473 \|1502	1510 \|1531 \|1514	1510	1510	1510	44327	Plate: 6 3/4 × 4 3/4 in. (17.1 × 12.1 cm)	Purchase, Jacob H. Schiff Bequest, 1922	424	13	http://www.metmuseum.org/art/collection/search/431456	4/23/2018 8:00:01 AM	1
301680	22.72.4bis(6)	0	431459	11	731	Seven Scabbards as the Seven Cardinal Virtues, from Das Buch Granatapfel, im latin genant Melogranatus [...]	2869		Johann Geiler von Kaisersberg\|Hans Burgkmair\|Johann Otmar\|Georg Diemar	German (born Switzerland), Schaffhausen 1445–1510 Strasbourg\|German, Augsburg 1473–1531 Augsburg\|German, Augsburg, 1502–1514\|German, Augsburg		43043	924	1445 \|1473 \|1502	1510 \|1531 \|1514	1510	1510	1510	44327	Plate: 6 3/4 × 4 13/16 in. (17.1 × 12.2 cm)	Purchase, Jacob H. Schiff Bequest, 1922	424	13	http://www.metmuseum.org/art/collection/search/431459	4/23/2018 8:00:01 AM	1