MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 57 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 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	Geography Type	City	State	County	Country	Classification	Link Resource	Metadata Date	Repository
34	1970.289.6	0	1	34	1	6	Acorn Clock	1	1		Forestville Manufacturing Company	1835–1853	6		1835	1853	1847–50	1847	1850	6	24 3/8 x 14 5/8 x 5 1/8 in. (61.9 x 37.1 x 13 cm)	Gift of Mrs. Paul Moore, 1970	1	2			3	4	http://www.metmuseum.org/art/collection/search/34	4/23/2018 8:00:01 AM	1
327	52.77.21	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	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	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	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	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	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	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	0	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	0	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	0	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	0	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	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	0	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	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	0	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	0	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	0	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
12904	14.26	1	1	14049	1	1007	Embroidered Sampler	1	1		Patty Coggeshall	1780–1797	2081	1	1780	1797	ca. 1792	1789	1792	2266	19 1/2 x 16 5/8 in. (49.5 x 42.2 cm)	Rogers Fund, 1914	1	2			3	16	http://www.metmuseum.org/art/collection/search/14049	4/23/2018 8:00:01 AM	1
12946	1984.331.12	0	1	14091	1	1007	Embroidered Sampler	1	1		Margaret (Peggy) Ingraham	1778–1818	2118		1778	1818	ca. 1792	1787	1797	2281	16 1/4 x 12 1/2 in. (41.3 x 31.8 cm)	Gift of Barbara Schiff Sinauer, 1984	1	2			3	16	http://www.metmuseum.org/art/collection/search/14091	4/23/2018 8:00:01 AM	1
217377	55.560.2	0	0	344869	11	97	Catalogue of Silver Plated Hollwware		41		American Silver Co.	Bristol, Connecticut	21139	1	1890	1950	July 1908	1908	1908			The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1955		2				442	http://www.metmuseum.org/art/collection/search/344869	4/23/2018 8:00:01 AM	1
217378	55.560.1	0	0	344870	11	97	Illustrated Catalogue of Silverware		41		American Silver Co.	Bristol, Connecticut	21139	1	1890	1950	early 20th century	1901	1935			The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1955		2				442	http://www.metmuseum.org/art/collection/search/344870	4/23/2018 8:00:01 AM	1
220099	36.2.9	0	0	347630	11	97	Third List from the Bookshop of Douglas Cleverdon		2125	Vignette on cover by	Jean-Émile Laboureur\|Douglas Cleverdon	French, Nantes 1877–1943 Penestin\|British, Bristol 1903–1987 London	23058	229	1877 \|1903	1943 \|1987	1927	1927	1927		Overall: 9 3/4 x 6 3/4 x 1/2 in. (24.8 x 17.1 x 1.3 cm)	Gift of Harold Bell, 1936		2				442	http://www.metmuseum.org/art/collection/search/347630	4/23/2018 8:00:01 AM	1
221357	53.653.2	0	0	348905	11	97	The Druggist's Printer Vol. 2, No. 3		41		U. S. Label Printing Establishment	Bristol, Pennsylvania	23896	1	1850	1950	April 1870	1870	1870	34903	9 3/16 x 5 13/16 in. (23.3 x 14.7 cm)	The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1953		2				442	http://www.metmuseum.org/art/collection/search/348905	4/23/2018 8:00:01 AM	1
248011	30.3	0	0	376313	11	97	Engravings by Eric Gill: A Selection of Engravings on Wood and Metal Representative of His Work to the End of the Year 1927...		4215	Preface and illustrations by\|Self-portrait of	Douglas Cleverdon\|The Fanfare Press\|Eric Gill\|Eric Gill	British, Bristol 1903–1987 London\|London\|British, Brighton, Sussex 1882–1940 Uxbridge, London\|British, Brighton, Sussex 1882–1940 Uxbridge, London	35102	177	1903 \|1900 \|1882 \|1882	1987 \|2100 \|1940 \|1940	1929	1929	1929	34832	13 3/4 x 11 1/16 x 1 13/16 in. (34.9 x 28.1 x 4.6 cm)	Harris Brisbane Dick Fund, 1930		2				442	http://www.metmuseum.org/art/collection/search/376313	4/23/2018 8:00:01 AM	1