MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 9 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 "Artist Alpha Sort" = :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	Classification	Link Resource	Metadata Date	Repository
101251	02.6.262, .263	1	188758	3	285	Cup and saucer	2384	328		Gotha	German, 1757–1900	8334	1757	1900	ca. 1780	1775	1785	572	Height (cup .262): 2 1/4 in. (5.7 cm); Diameter (saucer .263): 5 in. (12.7 cm)	Gift of Alfred Duane Pell, 1902	307	http://www.metmuseum.org/art/collection/search/188758	4/23/2018 8:00:01 AM	1
101259	02.6.275	1	188766	3	107	Cup	2384	328		Gotha	German, 1757–1900	8334	1757	1900	late 18th century	1785	1799	572	Height: 2 3/8 in. (6 cm)	Gift of Alfred Duane Pell, 1902	307	http://www.metmuseum.org/art/collection/search/188766	4/23/2018 8:00:01 AM	1
101260	02.6.276	1	188767	3	326	Saucer	2386	328	Possibly	Gotha	German, 1757–1900	8334	1757	1900	late 18th century	1785	1799	572	Diameter: 5 in. (12.7 cm)	Gift of Alfred Duane Pell, 1902	307	http://www.metmuseum.org/art/collection/search/188767	4/23/2018 8:00:01 AM	1
101467	06.337a, b	1	188981	3	285	Cup and saucer	2384	328		Gotha	German, 1757–1900	8334	1757	1900	late 18th century	1785	1799	572	Height (cup .337a): 2 1/2 in. (6.4 cm); Diameter (saucer .337b): 5 1/4 in. (13.3 cm)	Rogers Fund, 1906	307	http://www.metmuseum.org/art/collection/search/188981	4/23/2018 8:00:01 AM	1
111044	42.205.240a, b	1	199265	3	4355	Bowl with cover	2384	328		Gotha	German, 1757–1900	8334	1757	1900	late 18th century	1785	1799	572	Height: 3 3/8 in. (8.6 cm)	The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941	307	http://www.metmuseum.org/art/collection/search/199265	4/23/2018 8:00:01 AM	1
111045	42.205.241a, b	1	199266	3	251	Coffeepot	2384	328		Gotha	German, 1757–1900	8334	1757	1900	18th century	1700	1799	572	Height: 6 3/4 in. (17.1 cm)	The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941	307	http://www.metmuseum.org/art/collection/search/199266	4/23/2018 8:00:01 AM	1
111050	42.205.247	1	199271	3	318	Cream jug	2384	328		Gotha	German, 1757–1900	8334	1757	1900	ca. 1770–80	1765	1785	572	Height: 3 3/4 in. (9.5 cm)	The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941	307	http://www.metmuseum.org/art/collection/search/199271	4/23/2018 8:00:01 AM	1
111051	42.205.248	1	199272	3	768	Tray	2384	328		Gotha	German, 1757–1900	8334	1757	1900	ca. 1770–80	1765	1785	572	11 7/8 × 8 7/8 in. (30.2 × 22.5 cm)	The George B. McClellan Collection, Gift of Mrs. George B. McClellan, 1941	307	http://www.metmuseum.org/art/collection/search/199272	4/23/2018 8:00:01 AM	1
113415	54.147.5a, b	1	201716	3	7459	Milk jug with cover	2384	328		Gotha	German, 1757–1900	8334	1757	1900	ca. 1780	1775	1785	572	Height: 4 3/8 in. (11.1 cm)	Gift of R. Thornton Wilson, in memory of Florence Ellsworth Wilson, 1954	307	http://www.metmuseum.org/art/collection/search/201716	4/23/2018 8:00:01 AM	1