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 "Medium" = :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 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	State	County	Country	Classification	Link Resource	Metadata Date	Repository
7908	40.89a, b	0	8432	1	900	Teapot with Stand		1	Froggatt, Coldwell and Lean		1121			9999	1770–1800	1770	1800	1275	17 1/2 x 10 3/4 x 5 in. (44.5 x 27.3 x 12.7 cm)	Rogers Fund, 1940	1	84	16	16	4	1	http://www.metmuseum.org/art/collection/search/8432	4/23/2018 8:00:01 AM	1
12298	1990.87.1	1	13403	1	251	Coffeepot	1	6	Thomas Danforth Boardman\|Sherman Boardman	1784–1873\|1787–1861	83		1784 \|1787	1873 \|1861	1854–65	1854	1865	1275	H. 11 5/16 in. (28.7 cm); Diam. 10 in. (25.4 cm)	Bequest of Delight L. Sherwin, 1989	1	26			3	1	http://www.metmuseum.org/art/collection/search/13403	4/23/2018 8:00:01 AM	1
12299	1990.87.2	1	13404	1	26	Teapot	1	6	Thomas Danforth Boardman\|Sherman Boardman	1784–1873\|1787–1861	83		1784 \|1787	1873 \|1861	1854–65	1854	1865	1275	H. 8 9/16 in. (21.7 cm); Diam. 8 3/4 in. (22.2 cm)	Bequest of Delight L. Sherwin, 1989	1	26			3	1	http://www.metmuseum.org/art/collection/search/13404	4/23/2018 8:00:01 AM	1
12300	1990.87.3	1	13405	1	26	Teapot	1	6	Thomas Danforth Boardman\|Sherman Boardman	1784–1873\|1787–1861	83		1784 \|1787	1873 \|1861	1854–65	1854	1865	1275	H. 9 in. (22.9 cm); Diam. 8 3/4 in. (22.2 cm)	Bequest of Delight L. Sherwin, 1989	1	26			3	1	http://www.metmuseum.org/art/collection/search/13405	4/23/2018 8:00:01 AM	1
12301	1990.87.4a, b	1	13406	1	307	Sugar Bowl	1	6	Thomas Danforth Boardman\|Sherman Boardman	1784–1873\|1787–1861	83		1784 \|1787	1873 \|1861	1854–65	1854	1865	1275	H. 7 5/8 in. (19.4 cm); Diam. 7 7/16 in. (18.9 cm)	Bequest of Delight L. Sherwin, 1989	1	26			3	1	http://www.metmuseum.org/art/collection/search/13406	4/23/2018 8:00:01 AM	1
12302	1990.87.5	1	13407	1	112	Slop Bowl	1	6	Thomas Danforth Boardman\|Sherman Boardman	1784–1873\|1787–1861	83		1784 \|1787	1873 \|1861	1854–65	1854	1865	1275	H. 5 1/2 in. (14 cm); Diam. 5 in. (12.7 cm)	Bequest of Delight L. Sherwin, 1989	1	26			3	1	http://www.metmuseum.org/art/collection/search/13407	4/23/2018 8:00:01 AM	1
12303	1990.87.6	1	13408	1	284	Creamer	1	6	Thomas Danforth Boardman\|Sherman Boardman	1784–1873\|1787–1861	83		1784 \|1787	1873 \|1861	1854–65	1854	1865	1275	H. 6 3/16 in. (15.7 cm); Diam. 5 1/8 in. (13 cm)	Bequest of Delight L. Sherwin, 1989	1	26			3	1	http://www.metmuseum.org/art/collection/search/13408	4/23/2018 8:00:01 AM	1
103768	10.69a, b	1	191333	3	7124	Tea urn	2294	1	James Dixon & Sons	British, founded Sheffield, 1806	1165	7	1806	2063	1830–34	1830	1834	1275	16 1/4 × 7 3/4 in. (41.3 × 19.7 cm)	Rogers Fund, 1910						330	http://www.metmuseum.org/art/collection/search/191333	4/23/2018 8:00:01 AM	1
105461	16.116.58	1	193280	3	1240	Claret jug	2294	1	James Dixon & Sons	British, founded Sheffield, 1806	1165	7	1806	2063	ca. 1870–79	1865	1884	1275	Overall: 11 1/4 × 3 3/4 in. (28.6 × 9.5 cm)	Gift of Mr. Robert M. Parmelee and Mrs. William L. Parker, 1916						330	http://www.metmuseum.org/art/collection/search/193280	4/23/2018 8:00:01 AM	1