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	Geography Type	City	Country	Classification	Link Resource	Metadata Date	Repository
2318	1982.440.2a, b	1	2503	1	307	Covered Sugar Bowl	1	1		Chelsea Keramic Art Works	1872–1889	390	1872	1889	1879–83	1879	1883	21	H. 4 1/4 in. (10.8 cm); Diam. 3 1/2 in. (8.9 cm)	Gift of Mr. and Mrs. I. Wistar Morris III, 1982	1	56	3	5	http://www.metmuseum.org/art/collection/search/2503	4/23/2018 8:00:01 AM	1
2659	1982.440.3a, b	1	2856	1	285	Cup and Saucer	1	1		Chelsea Keramic Art Works	1872–1889	390	1872	1889	1879–83	1879	1883	21	H. 2 1/2 in. (6.4 cm); Diam. 4 3/4 in. (12.1 cm)	Gift of Mr. and Mrs. I. Wistar Morris III, 1982	1	56	3	5	http://www.metmuseum.org/art/collection/search/2856	4/23/2018 8:00:01 AM	1
2660	1982.440.4a, b	1	2857	1	285	Cup and Saucer	1	1		Chelsea Keramic Art Works	1872–1889	390	1872	1889	1879–83	1879	1883	21	H. 2 1/2 in. (6.4 cm); Diam. 4 3/4 in. (12.1 cm)	Gift of Mr. and Mrs. I. Wistar Morris III, 1982	1	56	3	5	http://www.metmuseum.org/art/collection/search/2857	4/23/2018 8:00:01 AM	1
7840	1982.440.1a, b	1	8362	1	26	Teapot	1	1		Chelsea Keramic Art Works	1872–1889	390	1872	1889	1879–83	1879	1883	21	H. 4 3/4 in. (12.1 cm); Diam. 3 3/4 in. (9.5 cm)	Gift of Mr. and Mrs. I. Wistar Morris III, 1982	1	56	3	5	http://www.metmuseum.org/art/collection/search/8362	4/23/2018 8:00:01 AM	1
8676	69.35	1	9323	1	7	Vase	1	1		Chelsea Keramic Art Works	1872–1889	390	1872	1889	1876–80	1876	1880	115	H. 12 3/4 in. (32.4 cm); Diam. 3 1/4 in. (8.3 cm)	Purchase, The Edgar J. Kaufmann Foundation Gift, 1969	1	56	3	5	http://www.metmuseum.org/art/collection/search/9323	4/23/2018 8:00:01 AM	1
8677	69.38.2	1	9324	1	7	Vase	1	1		Chelsea Keramic Art Works	1872–1889	390	1872	1889	1876–80	1876	1880	115	H. 7 1/2 (19.1 cm); Diam. 3 3/4 in. (9.5 cm)	Purchase, The Edgar J. Kaufmann Foundation Gift, 1969	1	56	3	5	http://www.metmuseum.org/art/collection/search/9324	4/23/2018 8:00:01 AM	1
13334	1992.231	1	14495	1	7	Vase	1	1		Chelsea Keramic Art Works	1872–1889	390	1872	1889	ca. 1886–89	1883	1889	21	H. 5 11/16 in. (14.4 cm); Diam. 3 1/8 in. (7.9 cm)	Gift of Betty G. Hut and Robert A. Hut, 1992	1	56	3	5	http://www.metmuseum.org/art/collection/search/14495	4/23/2018 8:00:01 AM	1
15311	1999.67	1	16579	1	7	Vase	1	20	Manufactured by	Chelsea Keramic Art Works	1872–1889	390	1872	1889	ca. 1884–89	1884	1889	2616	H. 8 1/4 in. (21 cm)	Purchase, Dr. and Mrs. Burton P. Fabricand Gift, 1999	1	56	3	5	http://www.metmuseum.org/art/collection/search/16579	4/23/2018 8:00:01 AM	1
15809	2002.142a, b	1	17230	1	26	Teapot	1	20	Manufactured by	Chelsea Keramic Art Works	1872–1889	390	1872	1889	1879–83	1879	1883	161	7 x 9 in. (17.8 x 22.9 cm)	Gift of Barrie and Deedee Wigmore, 2002	1	56	3	5	http://www.metmuseum.org/art/collection/search/17230	4/23/2018 8:00:01 AM	1