MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 24 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 Nationality" = :p0 and "Medium" = :p1 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	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	City	Country	Classification	Link Resource	Metadata Date	Repository
107188	24.80.93	0	1	195123	3	14	Virgin and Child Enthroned	27	2	Manner of	Christoph Angermair	German, ca. 1580–1633	9485	10	1580	1633	ca. 1600	1595	1605	148	Overall (confirmed): 11 1/2 × 6 11/16 × 2 7/8 in. (29.2 × 17 × 7.3 cm)	Bequest of Mary Clark Thompson, 1923			311	http://www.metmuseum.org/art/collection/search/195123	4/23/2018 8:00:01 AM	1
306421	41.68	0	1	436421	15	73	Maria Louisa (1745–1792), Empress of Austria		2		Heinrich Friedrich Füger	German, Heilbronn 1751–1818 Vienna	17782	10	1751	1818	ca. 1790	1785	1795	148	Octagonal, 1 1/4 x 7/8 in. (31 x 22 mm)	Fletcher Fund, 1941			771	http://www.metmuseum.org/art/collection/search/436421	4/23/2018 8:00:01 AM	1
306455	26.168.63	0	1	436460	15	73	Portrait of a Man		2		German Painter	ca. 1790–1800	12004	10				1790	1800	148	Octagonal, 1 1/8 x 3/4 in. (29 x 19 mm)	Bequest of Collis P. Huntington, 1900			771	http://www.metmuseum.org/art/collection/search/436460	4/23/2018 8:00:01 AM	1
306456	26.168.64	0	1	436461	15	73	Portrait of a Woman		2		German Painter	ca. 1790–1800	12004	10				1790	1800	148	Octagonal, 1 1/8 x 3/4 in. (29 x 19 mm)	Bequest of Collis P. Huntington, 1900			771	http://www.metmuseum.org/art/collection/search/436461	4/23/2018 8:00:01 AM	1
306457	26.168.65	0	1	436462	15	73	Portrait of a Child		2		German Painter	ca. 1790–1800	12004	10				1790	1800	148	Octagonal, 1 1/8 x 3/4 in. (29 x 19 mm)	Bequest of Collis P. Huntington, 1900			771	http://www.metmuseum.org/art/collection/search/436462	4/23/2018 8:00:01 AM	1
306458	26.168.66	0	1	436463	15	73	Portrait of a Child		2		German Painter	ca. 1790–1800	12004	10				1790	1800	148	Octagonal, 1 1/8 x 3/4 in. (29 x 19 mm)	Bequest of Collis P. Huntington, 1900			771	http://www.metmuseum.org/art/collection/search/436463	4/23/2018 8:00:01 AM	1
306459	26.168.67	0	1	436464	15	73	Portrait of a Man		2		German Painter	ca. 1790–1800	12004	10				1790	1800	148	Octagonal, 1 1/8 x 3/4 in. (29 x 19 mm)	Bequest of Collis P. Huntington, 1900			771	http://www.metmuseum.org/art/collection/search/436464	4/23/2018 8:00:01 AM	1
306460	26.168.68	0	1	436465	15	73	Caroline Maria Therese of Parma (1770–1804)		2		German Painter	ca. 1790–1800	12004	10				1790	1800	148	Octagonal, 1 1/8 x 3/4 in. (29 x 19 mm)	Bequest of Collis P. Huntington, 1900			771	http://www.metmuseum.org/art/collection/search/436465	4/23/2018 8:00:01 AM	1
306461	26.168.69	0	1	436466	15	73	Portrait of a Child		2		German Painter	ca. 1790–1800	12004	10				1790	1800	148	Octagonal, 1 1/8 x 3/4 in. (29 x 19 mm)	Bequest of Collis P. Huntington, 1900			771	http://www.metmuseum.org/art/collection/search/436466	4/23/2018 8:00:01 AM	1
306462	26.168.70	0	1	436467	15	73	Portrait of a Child		2		German Painter	ca. 1790–1800	12004	10				1790	1800	148	Octagonal, 1 1/8 x 3/4 in. (29 x 19 mm)	Bequest of Collis P. Huntington, 1900			771	http://www.metmuseum.org/art/collection/search/436467	4/23/2018 8:00:01 AM	1
306463	62.122.129	0	1	436469	15	73	Portrait of a Woman		2		German Painter	ca. 1810	12004	10				1805	1815	148	Oval, 2 1/4 x 1 7/8 in. (59 x 49 mm)	Bequest of Millie Bruhl Fredrick, 1962			771	http://www.metmuseum.org/art/collection/search/436469	4/23/2018 8:00:01 AM	1
306464	62.122.118	0	1	436470	15	73	Portrait of a Man		2		German Painter	ca. 1810	12004	10				1805	1815	148	Oval, 2 1/4 x 1 7/8 in. (59 x 49 mm)	Bequest of Millie Bruhl Fredrick, 1962			771	http://www.metmuseum.org/art/collection/search/436470	4/23/2018 8:00:01 AM	1
306465	15.43.307	0	1	436471	15	73	Portrait of a Man, Said to Be Alexander von Humboldt (1769–1859)		2		German Painter	ca. 1815	12004	10				1810	1820	148	Oval, 2 1/2 x 2 in. (64 x 52 mm)	Bequest of Mary Anna Palmer Draper, 1914			771	http://www.metmuseum.org/art/collection/search/436471	4/23/2018 8:00:01 AM	1
306614	95.14.52	0	1	436633	15	73	Ali Pasha (born about 1741, died 1822)		2		Jacob Ritter von Hartmann	German, 1795–1873	43602	10	1795	1873	1822	1822	1822	148	Oval, 4 1/8 x 3 1/4 in. (105 x 84 mm)	The Moses Lazarus Collection, Gift of Josephine and Sarah Lazarus, in memory of their father, 1888–95			771	http://www.metmuseum.org/art/collection/search/436633	4/23/2018 8:00:01 AM	1
306620	41.191.3	0	1	436639	15	73	Henriette Sontag (1806–1854)		2		Franz Napoleon Heigel	German, 1813–1888	43606	10	1813	1888	ca. 1835	1830	1840	148	Oval, 2 7/8 x 2 3/8 in. (73 x 60 mm)	Gift of Mrs. Thomas Hunt, 1941			771	http://www.metmuseum.org/art/collection/search/436639	4/23/2018 8:00:01 AM	1
306621	42.53.3	0	1	436640	15	73	Lola Montez (1818–1861)		2	Attributed to	Josef Heigel	German, 1780–1837	43607	10	1780	1837		1800	1837	148	Oval, 2 1/2 x 2 1/8 in. (65 x 54 mm)	Gift of Helen O. Brice, 1942			771	http://www.metmuseum.org/art/collection/search/436640	4/23/2018 8:00:01 AM	1
306985	51.160	0	1	437068	15	73	The Vision of Saint Anthony of Padua		2		Anton Raphael Mengs	German, Ústi nad Labem (Aussig) 1728–1779 Rome	17819	10	1728	1779		1758	1758	148	5 1/8 x 3 3/4 in. (130 x 96 mm)	Gift of Harry G. Friedman, 1951			771	http://www.metmuseum.org/art/collection/search/437068	4/23/2018 8:00:01 AM	1
306993	95.14.78	0	1	437076	15	73	Hannah Mahady		2		Jeremiah Meyer	German, Tübingen 1735–1789 Kew	43746	10	1735	1789	ca. 1760	1755	1765	148	Oval, 7/8 x 5/8 in. (22 x 16 mm)	The Moses Lazarus Collection, Gift of Josephine and Sarah Lazarus, in memory of their father, 1888–95			771	http://www.metmuseum.org/art/collection/search/437076	4/23/2018 8:00:01 AM	1
307127	95.14.66	0	1	437224	15	73	Portrait of a Man		2		Johann Esaias Nilson	German, Augsburg 1721–1788 Augsburg	18076	10	1721	1788		1741	1788	148	Oval, 1 7/8 x 1 1/2 in. (49 x 37 mm)	The Moses Lazarus Collection, Gift of Josephine and Sarah Lazarus, in memory of their father, 1888–95			771	http://www.metmuseum.org/art/collection/search/437224	4/23/2018 8:00:01 AM	1
307484	95.14.85	0	1	437632	15	73	Joseph and Karl August von Klein		2		Heinrich Franz Schalck	German, 1791–1832	43867	10	1791	1832	ca. 1810–15	1810	1815	148	4 5/8 x 5 1/8 in. (117 x 131 mm)	The Moses Lazarus Collection, Gift of Josephine and Sarah Lazarus, in memory of their father, 1888–95			771	http://www.metmuseum.org/art/collection/search/437632	4/23/2018 8:00:01 AM	1
307503	24.80.511	0	1	437653	15	73	Portrait of a Woman		2		Carl August Senff	German, 1770–1838	43876	10	1770	1838	1808	1808	1808	148	Oval, 2 3/8 x 2 in. (60 x 50 mm)	Bequest of Mary Clark Thompson, 1923			771	http://www.metmuseum.org/art/collection/search/437653	4/23/2018 8:00:01 AM	1
307574	62.122.154	0	1	437752	15	73	Portrait of a Man		2	Attributed to	Theodor Friedrich Stein	German, active ca. 1750–88	43895	10	1750	1788		1750	1788	148	1 5/8 x 2 1/4 in. (41 x 62 mm)	Bequest of Millie Bruhl Fredrick, 1962			771	http://www.metmuseum.org/art/collection/search/437752	4/23/2018 8:00:01 AM	1
307581	50.57	0	1	437761	15	73	Portrait of a Woman		2		Peter Edward Stroely	German, 1768–after 1826	43898	10	1768	1826	ca. 1800	1795	1805	148	Octagonal, 3 3/8 x 2 5/8 in. (87 x 67 mm)	Rogers Fund, 1950			771	http://www.metmuseum.org/art/collection/search/437761	4/23/2018 8:00:01 AM	1
346883	89.4.909	1	1	501520	18	15972	Alto Recorder in F	27	1		Johann Benedikt Gahn	German, Nuremberg 1674–1711 Nuremberg	47717	10	1674	1711	ca. 1700	1680	1720	148	Height: 19 1/8 in. (48.6 cm)	The Crosby Brown Collection of Musical Instruments, 1889	1065	16	965	http://www.metmuseum.org/art/collection/search/501520	4/23/2018 8:00:01 AM	1