MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 14 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 "Culture" = :p0 and "Department" = :p1 order by Country 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 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	Classification	Rights and Reproduction	Link Resource	Metadata Date	Repository
336712	1985.437.1	0	484250	4	206	Champagne glass	462	3	Robert Gruen\|Unknown Manufacturer	American, 1913–1999	45611	1	1913	1999	1940	1940	1940	31	H.4, Diam.3-1/2 in. (10.2 x 8.9 cm.); Base Diam. 2-1/2 in. (6.4 cm.)	Gift of Robert Gruen, 1985	3		http://www.metmuseum.org/art/collection/search/484250	4/23/2018 8:00:01 AM	1
336713	1985.437.2	0	484251	4	978	Wine glass	462	3	Robert Gruen\|Unknown Manufacturer	American, 1913–1999	45611	1	1913	1999	1940	1940	1940	31	H.4-1/2, Diam. 2-5/8 in. (11.4 x 6.7 cm.); base Diam. 2-1/4 inches (5.7 cm.)	Gift of Robert Gruen, 1985	3		http://www.metmuseum.org/art/collection/search/484251	4/23/2018 8:00:01 AM	1
336714	1985.437.3	0	484252	4	978	Wine glass	462	3	Robert Gruen\|Unknown Manufacturer	American, 1913–1999	45611	1	1913	1999	1940	1940	1940	31	H. 4-7/8, Diam. 2-3/4 in. (12.4 x 7 cm.); base Diam. 2-3/8 inches (6 cm.)	Gift of Robert Gruen, 1985	3		http://www.metmuseum.org/art/collection/search/484252	4/23/2018 8:00:01 AM	1
336715	1985.437.4	0	484253	4	6806	Glass	462	3	Robert Gruen\|Unknown Manufacturer	American, 1913–1999	45611	1	1913	1999	1940	1940	1940	31	H. 5-7/8, Diam. 3-1/4 in. (14.9 x 8.3 cm.); base Diam. 2-1/2 inches (6.4 cm.)	Gift of Robert Gruen, 1985	3		http://www.metmuseum.org/art/collection/search/484253	4/23/2018 8:00:01 AM	1
339690	24.176.1	1	487385	4	106	Bowl	462	3	Simon Gate\|Orrefors Glasbruk	Swedish, Södra Fägeläs 1883–1945 Orrefors	46475	819	1883	1945	1918	1918	1918	52443	H. 4-5/8, Diam. 8-3/8 inches (11.7 x 21.3 cm.)	Purchase, Edward C. Moore Jr. Gift, 1924	3		http://www.metmuseum.org/art/collection/search/487385	4/23/2018 8:00:01 AM	1
339729	25.81	0	487454	4	100	The Secret	462	3	Vicken Von Post\|Rörstrand Factory	American (born Sweden), Stockholm 1886–1940\|Swedish	46490	3451	1886	1940	1920s	1920	1929	109	H. 7-1/8, w. 5-5/8 in. (18.1 x 14.3 cm.)	Purchase, Edward C. Moore Jr. Gift, 1925	307		http://www.metmuseum.org/art/collection/search/487454	4/23/2018 8:00:01 AM	1
339901	30.134.4	0	487680	4	106	Bowl	462	3	Simon Gate\|Orrefors Glasbruk	Swedish, Södra Fägeläs 1883–1945 Orrefors	46475	819	1883	1945	1929	1929	1929	31	H. 7-3/16, Diam. 9-5/8 in. (18.3 x 24.4 cm.)	Purchase, Edward C. Moore Jr. Gift, 1930	3		http://www.metmuseum.org/art/collection/search/487680	4/23/2018 8:00:01 AM	1
339950	34.101.3ab	0	487745	4	15275	Bonbon box with cover	462	3	Erik Herman Fleming\|Borgila Studio	Swedish, 1894–1954\|Stockholm, Sweden	46574	31	1894	1954	1933	1933	1933	2	3 1/4 x 4 3/4 in. (8.3 x 12.1 cm)	Purchase, Edward C. Moore Jr. Gift, 1934	313		http://www.metmuseum.org/art/collection/search/487745	4/23/2018 8:00:01 AM	1
339951	34.101.4	0	487746	4	8421	Toilet mirror	462	3	Erik Herman Fleming\|Borgila Studio	Swedish, 1894–1954\|Stockholm, Sweden	46574	31	1894	1954	1934	1934	1934	2	9 7/16 x 4 7/8 in. (24 x 12.4 cm)	Purchase, Edward C. Moore Jr. Gift, 1934	313		http://www.metmuseum.org/art/collection/search/487746	4/23/2018 8:00:01 AM	1
339955	34.106	0	487750	4	7	Vase	462	3	Wilhelm Kåge\|Gustafsberg Manufactory	Swedish, 1889–1960\|Swedish	46575	819	1889 \|0	1960 \|0	late 1920s–1930s	1925	1939	21	H. 8, Diam. 7-7/8 in. (20.3 cm.)	Purchase, Edward C. Moore Jr. Gift, 1934	314	© 2018 Artists Rights Society (ARS), New York	http://www.metmuseum.org/art/collection/search/487750	4/23/2018 8:00:01 AM	1
339957	34.145.1	0	487754	4	7	Vase	462	3	Viktor Lindstrand\|Orrefors Glasbruk	Swedish, Gothenburg 1904–1983 Kosta	46576	819	1904	1983	1934	1934	1934	31	H. 7-7/8, Diam. 5-3/4 in. (20 x 14.6 cm.)	Purchase, Edward C. Moore Jr. Gift, 1934	3		http://www.metmuseum.org/art/collection/search/487754	4/23/2018 8:00:01 AM	1
339958	34.145.2	0	487755	4	7	Vase	462	18	Orrefors Glasbruk\|Viktor Lindstrand	Swedish, Gothenburg 1904–1983 Kosta	46577	819	1904	1983	ca. 1934	1934	1934	31	H. 3-3/16 in. (8.1 cm.); Sq. 6 inches	Purchase, Edward C. Moore Jr. Gift, 1934	3		http://www.metmuseum.org/art/collection/search/487755	4/23/2018 8:00:01 AM	1
340064	39.154.1	0	487875	4	7	Vase	462	3	Gerda (Helga Elisabet) Strömberg\|Strömberg Glassworks	Swedish, Klavreström 1874–1960 Växjö\|Swedish	46613	819	1874 \|0	1960 \|0	1936	1936	1936	31	H. 7-3/4 in. (19.7 cm.)	Purchase, Edward C. Moore Jr. Gift, 1939	3		http://www.metmuseum.org/art/collection/search/487875	4/23/2018 8:00:01 AM	1
340067	39.154.4	0	487878	4	7	Vase	462	3	Viktor Lindstrand\|Orrefors Glasbruk	Swedish, Gothenburg 1904–1983 Kosta	46576	819	1904	1983	1939	1939	1939	31	H. 8-1/16 in. (20.5 cm.)	Purchase, Edward C. Moore Jr. Gift, 1939	3		http://www.metmuseum.org/art/collection/search/487878	4/23/2018 8:00:01 AM	1