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 "Artist Role" = :p0 and "Object Name" = :p1 order by [Artist Prefix] 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 Nationality	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
339525	22.163.1	1	487195	4	106	Bowl		18		Georg Jensen\|Johan Rohde	Danish, Rådvad 1866–1935 Hellerup\|Danish, Randers 1856–1935 Hellerup	46417	349	1866 \|1856	1935 \|1935	1918	1918	1918	2	H. 5-1/2, W. 7-1/2 in. (14 x 19.1 cm)	Purchase, Edward C. Moore Jr. Gift, 1922				313	http://www.metmuseum.org/art/collection/search/487195	4/23/2018 8:00:01 AM	1
339558	22.189	1	487229	4	106	Bowl		18		Arbekai Pottery\|Isidore Falkoff	American\|America (born Russia) 1896–1923	46427	5	1896	1923	ca. 1922	1922	1922	161	H. 3-3/4, Diam. 10-1/8 in. (9.5 x 25.7 cm)	Purchase, Edward C. Moore Jr. Gift, 1922				314	http://www.metmuseum.org/art/collection/search/487229	4/23/2018 8:00:01 AM	1
339845	27.96.10	0	487587	4	106	Graal Glass		18		Orrefors Glasbruk\|Edward Hald	Swedish, Stockholm 1883–1980	46531	819	1883	1980	1926	1926	1926	52470	H. 3, Diam. 6-3/4 in. (7.6 x 17.1 cm.)	Purchase, Edward C. Moore Jr. Gift, 1927				3	http://www.metmuseum.org/art/collection/search/487587	4/23/2018 8:00:01 AM	1
339859	27.96.9	0	487602	4	106	Graal Glass		18		Orrefors Glasbruk\|Edward Hald	Swedish, Stockholm 1883–1980	46531	819	1883	1980	1926	1926	1926	31	H. 3, Diam. 7-3/4 in. (7.6 x 19.7 cm.)	Purchase, Edward C. Moore Jr. Gift, 1927				3	http://www.metmuseum.org/art/collection/search/487602	4/23/2018 8:00:01 AM	1
339999	36.126.9	0	487800	4	106	"Warwick" Bowl		18		Corning Glass Works, Steuben Division\|Frederick Carder	Corning, New York\|American (born England) Brierley, Staffordshire, England 1863–1963 Corning, New York	44868	16	1863	1963	ca. 1932	1932	1932	31	H. 7-1/8, Diam. 7-7/8 inches (18.1 x 20 cm.)	Purchase, Edward C. Moore Jr. Gift, 1936				3	http://www.metmuseum.org/art/collection/search/487800	4/23/2018 8:00:01 AM	1
342019	1999.70	1	490252	4	106	"Slottsglas" Footed Bowl		18		Orrefors Glasbruk\|Simon Gate	Swedish, Södra Fägeläs 1883–1945 Orrefors	46781	819	1883	1945	1918	1918	1918	31	H. 7, Diam. 7 5/8 in. (17.8 x 19.4 cm)	Purchase, The Horace W. Goldsmith Foundation Gift, 1999				3	http://www.metmuseum.org/art/collection/search/490252	4/23/2018 8:00:01 AM	1
342224	1998.537.22	0	490871	4	106	"Ruba Rombic" Bowl		18		Consolidated Lamp and Glass Company, Art Glassware Division, Coraopolis, PA\|Reuben Haley	American, Pittsburgh, Pennsylvania 1872–1933 Beaver, Pennsylvania	46390	5	1872	1933	1928	1928	1928	31	H. 4-1/2, Diam. 8-1/2 in. (11.4 x 21.6 cm) (irregular)	John C. Waddell Collection, Gift of John C. Waddell, 1998				3	http://www.metmuseum.org/art/collection/search/490871	4/23/2018 8:00:01 AM	1
2132	54.65.1a, b	1	2310	1	106	Covered Bowl	1	18	Manufactured by\|Designed by	Redwood Glass Company\|Charles A. Cornwall	1828–1868	366		1828	1868 \|9999	ca. 1833–68	1830	1868	186	H. 5 1/2 in. (14 cm)	Rogers Fund, 1954	1	126	3	3	http://www.metmuseum.org/art/collection/search/2310	4/23/2018 8:00:01 AM	1