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 "Geography Type" = :p0 and "Object Name" = :p1 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	Object Number	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	Geography Type	City	State	County	Country	Classification	Link Resource	Metadata Date	Repository
5689	51.171.162	1	6077	1	356	Plate	3									1837–40	1837	1840	218	Diam. 6 1/2 in. (16.5 cm)	Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951	3				6	3	http://www.metmuseum.org/art/collection/search/6077	4/23/2018 8:00:01 AM	1
5690	51.171.163	1	6078	1	356	Plate	3									1842–45	1842	1845	218	Diam. 4 3/4 in. (12.1 cm)	Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951	3				6	3	http://www.metmuseum.org/art/collection/search/6078	4/23/2018 8:00:01 AM	1
5691	51.171.164	1	6079	1	356	Plate	3									ca. 1837–40	1834	1840	218	Diam. 5 1/4 in. (13.3 cm)	Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951	3				6	3	http://www.metmuseum.org/art/collection/search/6079	4/23/2018 8:00:01 AM	1
5707	14.102.320	1	6095	1	356	Plate	2	1		Anthony Shaw	active ca. 1851–82	853		1848	1882	ca. 1851	1848	1851	119	Diam. 10 1/2 in. (26.7 cm)	Bequest of Mary Mandeville Johnston, from the collection of Mr. and Mrs. Edward W. S. Johnston, 1914	3	224	49	49	44	5	http://www.metmuseum.org/art/collection/search/6095	4/23/2018 8:00:01 AM	1
5713	62.89.19	1	6101	1	356	Plate	1	1	Probably	Thomas Byles	ca. 1685–1771	857		1682	1771	1711–71	1711	1771	104	Diam. 9 in. (22.9 cm)	Gift of Mrs. Stephen S. FitzGerald, 1962	3	228			8	1	http://www.metmuseum.org/art/collection/search/6101	4/23/2018 8:00:01 AM	1
5739	41.34.46	1	6127	1	356	Plate	1	1		Thomas Danforth, III	1756–1840	481		1756	1840	1777–1818	1777	1818	104	H. 1 1/2 in. (3.8 cm); Diam. 6 1/8 in. (15.6 cm)	Gift of Mrs. J. Insley Blair, in memory of her husband, 1941	3	229			8	1	http://www.metmuseum.org/art/collection/search/6127	4/23/2018 8:00:01 AM	1
5740	1978.339.2	1	6128	1	356	Plate	1	1		Christian Dorflinger	1828–1915	232	2	1828	1915	ca. 1856–85	1853	1885	381	H. 7/8 in. (2.2 cm); Diam. 6 1/16 in. (15.4 cm)	Gift of Mrs. Edwin M. Berol, 1978	3	163	17	17	8	3	http://www.metmuseum.org/art/collection/search/6128	4/23/2018 8:00:01 AM	1
5763	43.162.31	1	6151	1	356	Plate	1	1		Jehiel Johnson	ca. 1784–1833	868		1781	1833	1815–25	1815	1825	104	H. 1/2 in. (1.3 cm); Diam. 8 in. (20.3 cm)	Gift of Joseph France, 1943	3	151			8	1	http://www.metmuseum.org/art/collection/search/6151	4/23/2018 8:00:01 AM	1
5766	43.162.33	1	6154	1	356	Plate	1	6		Richard Lee\|Richard Lee Jr.	1747–1823\|1775–ca. 1858	869		1747 \|1775	1823 \|1858	1788–1820	1788	1820	104	H. 1/2 in. (1.3 cm); Diam. 5 1/2 in. (14 cm)	Gift of Joseph France, 1943	3	192			8	1	http://www.metmuseum.org/art/collection/search/6154	4/23/2018 8:00:01 AM	1
5827	43.162.41	1	6215	1	356	Plate	1	1		Henry Will	1734–ca. 1802	394		1734	1802	1761–93	1761	1793	104	H. 5/8 in. (1.6 cm); Diam. 8 in. (20.3 cm)	Gift of Joseph France, 1943	3	139			8	1	http://www.metmuseum.org/art/collection/search/6215	4/23/2018 8:00:01 AM	1