MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 49 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 "State" = :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	Culture	Artist Role	Artist Prefix	Artist Display Name	Artist Display Bio	Artist Alpha Sort	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
327	52.77.21	1	373	1	58	Beaker	6								ca. 1765	1762	1765	131	H. 8 in. (20.3 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/373	4/23/2018 8:00:01 AM	1
328	52.77.22	1	374	1	58	Beaker	6								1760–65	1760	1765	131	H. 7 1/4 in. (18.4 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/374	4/23/2018 8:00:01 AM	1
363	52.77.3	1	417	1	58	Beaker	6								1760–65	1760	1765	131	H. 7 1/8 in. (18.1 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/417	4/23/2018 8:00:01 AM	1
364	52.77.4	1	418	1	58	Beaker	6								1760–65	1760	1765	131	6 3/4 × 4 × 4 in. (17.1 × 10.2 × 10.2 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/418	4/23/2018 8:00:01 AM	1
556	52.77.9	1	617	1	48	Bottle	6								ca. 1760	1757	1760	131	H. 3 1/2 in. (8.9 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/617	4/23/2018 8:00:01 AM	1
557	52.77.10	1	618	1	48	Bottle	6								18th century	1700	1800	199	H. 5 in. (12.7 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/618	4/23/2018 8:00:01 AM	1
559	52.77.35	1	620	1	48	Bottle	6								ca. 1760	1757	1760	131	H. 4 in. (10.2 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/620	4/23/2018 8:00:01 AM	1
560	52.77.36	1	621	1	48	Bottle	6								ca. 1760	1757	1760	131	H. 4 5/16 in. (11 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/621	4/23/2018 8:00:01 AM	1
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
562	52.77.42	1	623	1	48	Bottle	6								ca. 1760	1757	1760	131	H. 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/623	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
574	52.77.30	1	636	1	48	Bottle	6								ca. 1760	1757	1760	131	H. 4 5/8 in. (11.7 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/636	4/23/2018 8:00:01 AM	1
575	52.77.31	1	637	1	48	Bottle	6								ca. 1760	1757	1760	131	H. 4 5/8 in. (11.7 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/637	4/23/2018 8:00:01 AM	1
576	18.110.48b	0	638	1	48	Bottle	15								1700–1800	1700	1800	186	Dimensions unavailable	John Stewart Kennedy Fund, 1918	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/638	4/23/2018 8:00:01 AM	1
577	18.110.48c	0	639	1	48	Bottle	15								1700–1800	1700	1800	186	Dimensions unavailable	John Stewart Kennedy Fund, 1918	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/639	4/23/2018 8:00:01 AM	1
578	18.110.48d	0	640	1	48	Bottle	15								1700–1800	1700	1800	186	Dimensions unavailable	John Stewart Kennedy Fund, 1918	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/640	4/23/2018 8:00:01 AM	1
579	18.110.48e	0	641	1	48	Bottle	15								1700–1800	1700	1800	186	Dimensions unavailable	John Stewart Kennedy Fund, 1918	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/641	4/23/2018 8:00:01 AM	1
580	18.110.48f	0	642	1	48	Bottle	15								1700–1800	1700	1800	186	Dimensions unavailable	John Stewart Kennedy Fund, 1918	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/642	4/23/2018 8:00:01 AM	1
581	18.110.48g	0	643	1	48	Bottle	15								1700–1800	1700	1800	186	Dimensions unavailable	John Stewart Kennedy Fund, 1918	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/643	4/23/2018 8:00:01 AM	1
629	37.169	1	691	1	106	Bowl	6								1750–60	1750	1760	193	H. 5 5/8 in. (14.3 cm); Diam. 13 13/16 in. (35.1 cm)	Purchase, Anita M. Linzee Bequest, 1937	1	2	2	2	4	5	http://www.metmuseum.org/art/collection/search/691	4/23/2018 8:00:01 AM	1
643	44.110.16	1	708	1	106	Bowl	2								ca. 1760	1757	1760	193	H. 5 1/8 in. (13 cm); Diam. 12 in. (30.5 cm)	Gift of Mrs. Russell S. Carter, 1944	1	2	2	2	4	5	http://www.metmuseum.org/art/collection/search/708	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
1957	27.17.15a, b	0	2127	1	251	Coffeepot	6								ca. 1770–81	1767	1767	543	H. 7 3/4 in. (19.7 cm)	Rogers Fund, 1927	1	2	2	2	4	5	http://www.metmuseum.org/art/collection/search/2127	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
2375	52.77.20a, b	1	2562	1	7	Covered Vase	6								ca. 1760	1757	1760	131	9 1/2 × 4 5/16 × 4 5/16 in. (24.1 × 11 × 11 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/2562	4/23/2018 8:00:01 AM	1
2551	52.77.19a–k	1	2746	1	323	Cruet	6								ca. 1765	1762	1765	131	H. 7 7/8 in. (20 cm); Diam. 7 1/8 in. (18.1 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/2746	4/23/2018 8:00:01 AM	1
3276	52.77.32	1	3509	1	371	Egg Cup	6								ca. 1760	1757	1760	131	H. 2 5/8 in. (6.7 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/3509	4/23/2018 8:00:01 AM	1
3277	52.77.33	1	3510	1	371	Egg Cup	6								ca. 1760	1757	1760	131	H. 2 5/8 in. (6.7 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/3510	4/23/2018 8:00:01 AM	1
3371	52.77.13	1	3606	1	418	Finger Bowl	6								ca. 1760	1757	1760	131	H. 2 in. (5.1 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/3606	4/23/2018 8:00:01 AM	1
4771	07.280.13	1	5128	1	148	George Washington Commemorative Medal		1	Possibly	Joseph S. and Alfred Wyon	active 18th–19th century	708	1700	1900	1800–1907	1800	1907	23	Diam. 1 1/4 in. (3.2 cm)	Gift of Mr. and Mrs. Frederick S. Wait, 1907	2	2	2	2	4	1	http://www.metmuseum.org/art/collection/search/5128	4/23/2018 8:00:01 AM	1
6352	35.14	1	6793	1	298	Punch Bowl	6								1730–50	1730	1750	193	H. 6 1/2 in. (16.5 cm); Diam. 12 in. (30.5 cm)	Rogers Fund, 1935	1	2	2	2	4	5	http://www.metmuseum.org/art/collection/search/6793	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
6865	52.77.44	1	7331	1	775	Scent Bottle	6								1779	1779	1779	131	H. 2 3/4 in. (7 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/7331	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
8523	52.77.45a–e	1	9164	1	48	Bottle	6								ca. 1775	1772	1775	1306	H. 2 in. (5.1 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/9164	4/23/2018 8:00:01 AM	1
8644	52.77.1	1	9291	1	7	Vase	6								1760–65	1760	1765	131	H. 6 1/4 in. (15.9 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/9291	4/23/2018 8:00:01 AM	1
8645	52.77.2	1	9292	1	7	Vase	6								1760–65	1760	1765	131	H. 6 3/8 in. (16.2 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/9292	4/23/2018 8:00:01 AM	1
8646	52.77.5	1	9293	1	7	Vase	6								1760–65	1760	1765	131	H. 9 3/8 in. (23.8 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/9293	4/23/2018 8:00:01 AM	1
8647	52.77.6	1	9294	1	7	Vase	6								1760–65	1760	1765	131	H. 7 3/4 in. (19.7 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/9294	4/23/2018 8:00:01 AM	1
8648	52.77.7	1	9295	1	7	Vase	6								1760–65	1760	1765	131	H. 7 1/16 in. (17.9 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/9295	4/23/2018 8:00:01 AM	1
8649	52.77.8	1	9296	1	7	Vase	6								ca. 1760	1757	1760	131	6 3/16 × 3 5/8 × 3 5/8 in. (15.7 × 9.2 × 9.2 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/9296	4/23/2018 8:00:01 AM	1
8650	52.77.11	1	9297	1	7	Vase	6								ca. 1760	1757	1760	131	H. 5 1/2 in. (14 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/9297	4/23/2018 8:00:01 AM	1
8653	52.77.23	1	9300	1	7	Vase	6								1755–65	1755	1765	131	H. 5 in. (12.7 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/9300	4/23/2018 8:00:01 AM	1
8654	52.77.24	0	9301	1	7	Vase	6								1755–65	1755	1765	131	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/9301	4/23/2018 8:00:01 AM	1
8655	52.77.25	1	9302	1	7	Vase	6								1755–65	1755	1765	131	6 7/8 × 4 1/16 × 4 1/16 in. (17.5 × 10.3 × 10.3 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/9302	4/23/2018 8:00:01 AM	1
8657	52.77.29a, b	1	9304	1	7	Vase	6								ca. 1760	1757	1760	131	H. 7 1/2 in. (19.1 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/9304	4/23/2018 8:00:01 AM	1
8658	52.77.34	1	9305	1	7	Vase	6								ca. 1760	1757	1760	131	H. 4 in. (10.2 cm)	Bequest of Mrs. J. Insley Blair, 1951	2	2	2	2	4	3	http://www.metmuseum.org/art/collection/search/9305	4/23/2018 8:00:01 AM	1