MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 16 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 "Object Name" = :p0 and "State" = :p1 order by [Is Highlight] limit 101

Query parameters

This data as json, CSV

rowid	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Culture	Object Date	Object Begin Date	Object End Date	Medium	Dimensions	Credit Line	Geography Type	City	State	County	Country	Classification	Link Resource	Metadata Date	Repository
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
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