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 Prefix" = :p0 and "Classification" = :p1 and "Geography Type" = :p2 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 Suffix	Artist Alpha Sort	Artist Begin Date	Artist End Date	Object Date	Object Begin Date	Object End Date	Medium	Dimensions	Credit Line	Geography Type	City	Country	Classification	Link Resource	Metadata Date	Repository
495	14.11.3	1	553	1	96	Flask	1	1	Probably	United States Pottery Company	1852–58		75	1852	1852	ca. 1853–58	1850	1858	118	7 5/8 x 5 5/8 in. (19.4 x 14.3 cm)	Rogers Fund, 1914	2	25	3	5	http://www.metmuseum.org/art/collection/search/553	4/23/2018 8:00:01 AM	1
2289	39.115.4a, b	1	2473	1	304	Covered slop jar	1	23	Probably	United States Pottery Company\|Lyman, Fenton & Co.	1852–58\|1849–52	or	389	1852 \|1849	1852 \|1849	1849–58	1849	1849	21	H. 19 1/2 in. (49.5 cm)	Gift of Mrs. J. Insley Blair, 1939	2	25	3	5	http://www.metmuseum.org/art/collection/search/2473	4/23/2018 8:00:01 AM	1
5235	14.11.8	1	5607	1	15	Frame	1	1	Probably	United States Pottery Company	1852–58		75	1852	1852	1853–58	1853	1858	118	6 5/8 x 7 1/2 in. (16.8 x 19.1 cm)	Rogers Fund, 1914	2	25	3	5	http://www.metmuseum.org/art/collection/search/5607	4/23/2018 8:00:01 AM	1
5464	14.102.381	1	5840	1	296	Pitcher	1	1	Probably	Pyatt	active 1849–79		820	1849	1879	ca. 1849–79	1846	1879	118	H. 7 5/8 in. (19.4 cm)	Bequest of Mary Mandeville Johnston, from the collection of Mr. and Mrs. Edward W. S. Johnston, 1914	2	57	3	5	http://www.metmuseum.org/art/collection/search/5840	4/23/2018 8:00:01 AM	1
5481	41.135.2	1	5858	1	296	Pitcher	1	1	Probably	United States Pottery Company	1852–58		75	1852	1852	1849–58	1849	1858	118	H. 9 7/8 in. (25.1 cm)	Rogers Fund, 1941	2	25	3	5	http://www.metmuseum.org/art/collection/search/5858	4/23/2018 8:00:01 AM	1
5482	41.135.5	1	5859	1	296	Pitcher	1	1	Probably	United States Pottery Company	1852–58		75	1852	1852	1849–58	1849	1858	118	H. 6 1/8 in. (15.6 cm)	Rogers Fund, 1941	2	25	3	5	http://www.metmuseum.org/art/collection/search/5859	4/23/2018 8:00:01 AM	1
5501	1984.423	1	5879	1	296	Pitcher	1	20	Probably	Woodward and Blakely Company	1848–57		826	1848	1848	1848–57	1848	1848	21	H. 11 3/4 in. (29.8 cm)	Friends of the American Wing Fund, 1984	2	70	3	5	http://www.metmuseum.org/art/collection/search/5879	4/23/2018 8:00:01 AM	1
6244	48.25.1	1	6641	1	722	Poodle	1	1	Probably	United States Pottery Company	1852–58		75	1852	1852	1849–58	1849	1858	103	8 1/2 x 9 x 4 3/8 in. (21.6 x 22.9 x 11.1 cm)	Gift of Dr. Charles W. Green, 1948	2	25	3	5	http://www.metmuseum.org/art/collection/search/6641	4/23/2018 8:00:01 AM	1
6245	48.25.2	1	6642	1	9	Standing poodle	1	20	Probably	United States Pottery Company	1852–58		75	1852	1852	1849–58	1849	1858	103	8 1/2 x 9 x 4 3/8 in. (21.6 x 22.9 x 11.1 cm)	Gift of Dr. Charles W. Green, 1948	2	25	3	5	http://www.metmuseum.org/art/collection/search/6642	4/23/2018 8:00:01 AM	1
9049	17.203.1	0	9757	1	955	Watercooler	1	1	Probably	United States Pottery Company	1852–58		75	1852	1852	ca. 1849–58	1846	1858	118	H. 19 1/4 in. (48.9 cm)	Rogers Fund, 1917	2	25	3	5	http://www.metmuseum.org/art/collection/search/9757	4/23/2018 8:00:01 AM	1