MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 8 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 "City" = :p0 and "Object End Date" = :p1 order by Region 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 Alpha Sort	Object Date	Object Begin Date	Object End Date	Medium	Dimensions	Credit Line	Geography Type	City	State	County	Country	Classification	Link Resource	Metadata Date	Repository
561	52.77.41	1	622	1	48	Bottle	6					1760–70	1760	1770	200	H. 5 1/8 in. (13 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/622	4/23/2018 8:00:01 AM	1
563	52.77.43	1	624	1	48	Bottle	6					1760–70	1760	1770	131	H. 4 1/8 in. (10.5 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/624	4/23/2018 8:00:01 AM	1
1216	52.77.38	1	1313	1	163	Candlestick	6	1	Possibly	Michael Edkins	234	1760–70	1760	1770	131	H. 8 15/16 in. (22.7 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/1313	4/23/2018 8:00:01 AM	1
1217	52.77.39a, b	1	1314	1	163	Candlestick	6	1	Possibly	Michael Edkins	234	1760–70	1760	1770	131	9 5/16 × 4 11/16 × 4 11/16 in. (23.7 × 11.9 × 11.9 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/1314	4/23/2018 8:00:01 AM	1
2164	52.77.26a, b	1	2346	1	282	Tea Caddy	6	1	Possibly	Michael Edkins	234	1760–70	1760	1770	131	H. 5 5/16 in. (13.5 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/2346	4/23/2018 8:00:01 AM	1
2165	52.77.27a, b	1	2347	1	282	Tea Caddy	6	1	Possibly	Michael Edkins	234	1760–70	1760	1770	131	H. 5 1/4 in. (13.3 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/2347	4/23/2018 8:00:01 AM	1
6779	52.77.40	1	7238	1	326	Saucer	6					1760–70	1760	1770	131	Diam. 6 in. (15.2 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/7238	4/23/2018 8:00:01 AM	1
7744	52.77.37a, b	1	8251	1	890	Taperstick	6	1	Possibly	Michael Edkins	234	1760–70	1760	1770	131	H. 6 1/8 in. (15.6 cm); Diam. 3 3/8 in. (8.6 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/8251	4/23/2018 8:00:01 AM	1