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 "Medium" = :p0 and "Object Name" = :p1 order by [Artist Role] 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
3079	14.102.103	1	3297	1	110	Dish	2	1	Job & John Jackson	active 1831–35	486		1831	1835	ca. 1831–ca. 1835	1828	1838	119	9 3/4 x 11 7/8 in. (24.8 x 30.2 cm)	Bequest of Mary Mandeville Johnston, from the collection of Mr. and Mrs. Edward W. S. Johnston, 1914	1		1	1	4	5	http://www.metmuseum.org/art/collection/search/3297	4/23/2018 8:00:01 AM	1
3088	14.102.220	1	3306	1	110	Dish	2	1	William Ridgway, Son & Co.	active ca. 1836–48	490		1833	1848	ca. 1844–ca. 1846	1841	1849	119	Diam. 9 5/8 in. (24.4 cm)	Bequest of Mary Mandeville Johnston, from the collection of Mr. and Mrs. Edward W. S. Johnston, 1914	1		1	1	4	5	http://www.metmuseum.org/art/collection/search/3306	4/23/2018 8:00:01 AM	1
3090	10.57.14	0	3308	1	110	Dish	2	1	Joseph Stubbs	active ca. 1822–36	492		1819	1836	ca. 1822–ca. 1836	1819	1839	119	Diam. 7 in. (17.8 cm)	Gift of Mrs. Abraham Lansing, 1910	1	79	1	1	4	5	http://www.metmuseum.org/art/collection/search/3308	4/23/2018 8:00:01 AM	1
3097	14.102.305	1	3315	1	110	Dish	2	1	William Adams & Sons	British, active ca. 1819–present	496	7	1814	2063	ca. 1830–ca. 1840	1827	1843	119	11 x 9 in. (27.9 x 22.9 cm)	Bequest of Mary Mandeville Johnston, from the collection of Mr. and Mrs. Edward W. S. Johnston, 1914	1	79	1	1	4	5	http://www.metmuseum.org/art/collection/search/3315	4/23/2018 8:00:01 AM	1
3099	14.102.26	1	3317	1	110	Dish	2	1	Enoch Wood & Sons	British, active Burslem, 1818–46	347	7	1818	1846	ca. 1818–ca. 1846	1815	1849	119	Diam. 8 3/8 in. (21.3 cm)	Bequest of Mary Mandeville Johnston, from the collection of Mr. and Mrs. Edward W. S. Johnston, 1914	1	79	1	1	4	5	http://www.metmuseum.org/art/collection/search/3317	4/23/2018 8:00:01 AM	1
3100	14.102.102	1	3318	1	110	Dish	2	1	Enoch Wood & Sons	British, active Burslem, 1818–46	347	7	1818	1846	ca. 1821–ca. 1846	1818	1849	119	8 5/8 x 11 1/2 in. (21.9 x 29.2 cm)	Bequest of Mary Mandeville Johnston, from the collection of Mr. and Mrs. Edward W. S. Johnston, 1914	1		1	1	4	5	http://www.metmuseum.org/art/collection/search/3318	4/23/2018 8:00:01 AM	1
3101	14.102.114	1	3319	1	110	Dish	2	1	Enoch Wood & Sons	British, active Burslem, 1818–46	347	7	1818	1846	ca. 1818–ca. 1846	1815	1849	119	Diam. 10 1/4 in. (26 cm)	Bequest of Mary Mandeville Johnston, from the collection of Mr. and Mrs. Edward W. S. Johnston, 1914	1		1	1	4	5	http://www.metmuseum.org/art/collection/search/3319	4/23/2018 8:00:01 AM	1
5746	14.102.251	1	6134	1	110	Dish	2	1	Joseph Heath	active ca. 1845–53	866		1842	1853	ca. 1845–ca. 1853	1842	1856	119	Diam. 7 5/8 in. (19.4 cm)	Bequest of Mary Mandeville Johnston, from the collection of Mr. and Mrs. Edward W. S. Johnston, 1914	1		1	1	4	5	http://www.metmuseum.org/art/collection/search/6134	4/23/2018 8:00:01 AM	1