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 [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
14362	1996.95	1	15547	1	7	Century Vase	1	3	Designed by	Karl L. H. Müller\|Union Porcelain Works	ca. 1820–1887\|1863–ca. 1922	273	1	1817 \|1863	1890 \|1922	1876	1876	1876	109	Overall: H. 22 1/4 in. (56.5 cm); Diam. 17 3/8 in. (44.1 cm) Lip: Diam. 13 1/8 in. (33.3 cm)	Purchase, Mr. and Mrs. Edward J. Scheider Gift, 1996	1	48	3	5	http://www.metmuseum.org/art/collection/search/15547	4/23/2018 8:00:01 AM	1
1420	69.194.1	1	1531	1	7	Century Vase	1	3	Designed by\|Manufactured by	Karl L. H. Müller\|Union Porcelain Works	ca. 1820–1887\|1863–ca. 1922	273	1	1817 \|1863	1890 \|1922	ca. 1876	1873	1876	109	H. 12 3/4 in. (32.4 cm)	Gift of Mr. and Mrs. Franklin Chace, 1969	1	48	3	5	http://www.metmuseum.org/art/collection/search/1531	4/23/2018 8:00:01 AM	1
1421	69.194.2	1	1532	1	7	Century Vase	1	3	Designed by\|Manufactured by	Karl L. H. Müller\|Union Porcelain Works	ca. 1820–1887\|1863–ca. 1922	273	1	1817 \|1863	1890 \|1922	ca. 1876	1873	1876	109	H. 12 3/4 in. (32.4 cm)	Gift of Mr. and Mrs. Franklin Chace, 1969	1	48	3	5	http://www.metmuseum.org/art/collection/search/1532	4/23/2018 8:00:01 AM	1
2322	69.194.7a, b	1	2507	1	307	Sugar bowl	1	3	Designed by\|Manufactured by	Karl L. H. Müller\|Union Porcelain Works	ca. 1820–1887\|1863–ca. 1922	273	1	1817 \|1863	1890 \|1922	ca. 1876	1873	1876	109	4 3/4 x 4 1/2 in. (12.1 x 11.4 cm)	Gift of Mr. and Mrs. Franklin Chace, 1969	1	48	3	5	http://www.metmuseum.org/art/collection/search/2507	4/23/2018 8:00:01 AM	1
2497	69.194.14	1	2691	1	284	Creamer	1	3	Designed by\|Manufactured by	Karl L. H. Müller\|Union Porcelain Works	ca. 1820–1887\|1863–ca. 1922	273	1	1817 \|1863	1890 \|1922	ca. 1876	1873	1876	109	H. 3 7/8 in. (9.8 cm); Diam. 3 1/4 in. (8.3 cm)	Gift of Mr. and Mrs. Franklin Chace, 1969	1	48	3	5	http://www.metmuseum.org/art/collection/search/2691	4/23/2018 8:00:01 AM	1
5194	68.99.1a–d	1	5563	1	684	Centennial Pedestal	1	3	Designed by\|Manufactured by	Karl L. H. Müller\|Union Porcelain Works	ca. 1820–1887\|1863–ca. 1922	273	1	1817 \|1863	1890 \|1922	1876	1876	1876	109	H. 42 1/2 in. (108 cm); Diam. 16 3/8 in. (41.6 cm)	Purchase, Anonymous Gift, 1968	1	48	3	5	http://www.metmuseum.org/art/collection/search/5563	4/23/2018 8:00:01 AM	1
7779	69.194.9, .10	1	8297	1	898	Teacup and saucer	1	3	Designed by\|Manufactured by	Karl L. H. Müller\|Union Porcelain Works	ca. 1820–1887\|1863–ca. 1922	273	1	1817 \|1863	1890 \|1922	ca. 1876	1873	1876	109	Cup: H. 2 in. (5.1 cm); Diam. 2 7/8 in. (7.3 cm) Saucer: Diam. 5 1/16 in. (12.9 cm)	Gift of Mr. and Mrs. Franklin Chace, 1969	1	48	3	5	http://www.metmuseum.org/art/collection/search/8297	4/23/2018 8:00:01 AM	1
7780	69.194.11, .12	1	8298	1	898	Teacup and saucer	1	3	Designed by\|Manufactured by	Karl L. H. Müller\|Union Porcelain Works	ca. 1820–1887\|1863–ca. 1922	273	1	1817 \|1863	1890 \|1922	ca. 1876	1873	1876	109	Cup: H. 2 in. (5.1 cm); Diam. 2 7/8 in. (7.3 cm) Saucer: Diam. 5 1/16 in. (12.9 cm)	Gift of Mr. and Mrs. Franklin Chace, 1969	1	48	3	5	http://www.metmuseum.org/art/collection/search/8298	4/23/2018 8:00:01 AM	1
13332	1992.196	1	14493	1	49	Mug	1	3	Designed by\|Manufactured by	Karl L. H. Müller\|Union Porcelain Works	ca. 1820–1887\|1863–ca. 1922	273	1	1817 \|1863	1890 \|1922	ca. 1863	1863	1863	109	H. 5 5/8 in. (14.3 cm)	Friends of the American Wing Fund, 1992	1	48	3	5	http://www.metmuseum.org/art/collection/search/14493	4/23/2018 8:00:01 AM	1