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 Date] > :p2 or ([Object Date] = :p2 and rowid > :p1)) order by [Object Date], 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	Country	Classification	Link Resource	Metadata Date	Repository
8482	46.140.531	1	9122	1	60	Tumbler	1	1	Probably	New England Glass Company	American, East Cambridge, Massachusetts, 1818–1888	10	1818	1888	ca. 1883–88	1880	1888	168	H. 4 3/16 in. (10.6 cm); Diam. 2 1/4 in. (5.7 cm)	Gift of Mrs. Emily Winthrop Miles, 1946	1	6	3	3	http://www.metmuseum.org/art/collection/search/9122	4/23/2018 8:00:01 AM	1
8483	46.140.532	1	9123	1	60	Tumbler	1	1	Probably	New England Glass Company	American, East Cambridge, Massachusetts, 1818–1888	10	1818	1888	ca. 1883–88	1880	1888	168	H. 4 3/16 in. (10.6 cm); Diam. 2 1/4 in. (5.7 cm)	Gift of Mrs. Emily Winthrop Miles, 1946	1	6	3	3	http://www.metmuseum.org/art/collection/search/9123	4/23/2018 8:00:01 AM	1
9206	46.140.525	1	9922	1	978	Wine Glass	1	1	Probably	New England Glass Company	American, East Cambridge, Massachusetts, 1818–1888	10	1818	1888	ca. 1883–88	1880	1888	168	H. 4 11/16 in. (11.9 cm)	Gift of Mrs. Emily Winthrop Miles, 1946	1	6	3	3	http://www.metmuseum.org/art/collection/search/9922	4/23/2018 8:00:01 AM	1
9207	46.140.526	1	9923	1	978	Wine Glass	1	1	Probably	New England Glass Company	American, East Cambridge, Massachusetts, 1818–1888	10	1818	1888	ca. 1883–88	1880	1888	168	H. 4 11/16 in. (11.9 cm)	Gift of Mrs. Emily Winthrop Miles, 1946	1	6	3	3	http://www.metmuseum.org/art/collection/search/9923	4/23/2018 8:00:01 AM	1
6963	46.140.527	1	7433	1	798	Sherry Glass	1	1	Probably	New England Glass Company	American, East Cambridge, Massachusetts, 1818–1888	10	1818	1888	ca. 1888	1885	1888	168	H. 4 3/8 in. (11.1 cm)	Gift of Mrs. Emily Winthrop Miles, 1946	1	6	3	3	http://www.metmuseum.org/art/collection/search/7433	4/23/2018 8:00:01 AM	1
6964	46.140.528	1	7434	1	798	Sherry Glass	1	1	Probably	New England Glass Company	American, East Cambridge, Massachusetts, 1818–1888	10	1818	1888	ca. 1888	1885	1888	168	H. 4 3/8 in. (11.1 cm)	Gift of Mrs. Emily Winthrop Miles, 1946	1	6	3	3	http://www.metmuseum.org/art/collection/search/7434	4/23/2018 8:00:01 AM	1
8902	46.140.486	0	9571	1	7	Vase	1	6	Attributed to\|Possibly	New England Glass Company\|Mount Washington Glass Company	American, East Cambridge, Massachusetts, 1818–1888\|1837–1958	1208	1818 \|1837	1888 \|1958	ca. 1888	1885	1888	168	H. 6 1/4 in. (15.9 cm)	Gift of Mrs. Emily Winthrop Miles, 1946	1	6	3	3	http://www.metmuseum.org/art/collection/search/9571	4/23/2018 8:00:01 AM	1
8903	46.140.487	0	9572	1	7	Vase	1	6	Attributed to\|Possibly	New England Glass Company\|Mount Washington Glass Company	American, East Cambridge, Massachusetts, 1818–1888\|1837–1958	1208	1818 \|1837	1888 \|1958	ca. 1888	1885	1888	168	H. 6 1/4 in. (15.9 cm)	Gift of Mrs. Emily Winthrop Miles, 1946	1	6	3	3	http://www.metmuseum.org/art/collection/search/9572	4/23/2018 8:00:01 AM	1