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 "Country" = :p0 and "Department" = :p1 order by Culture limit 101

Query parameters

This data as json, CSV

rowid	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	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	State	County	Country	Classification	Link Resource	Metadata Date	Repository
425	83.2.283	0	481	2	70	Cameo Medallion of Benjamin Franklin	1	Possibly	Josiah Wedgwood and Sons	1759–present	124		1759	9999	1776–1800	1776	1800	155	Diam. 2 1/2 in. (6.4 cm)	Gift of William H. Huntington, 1883	2	1	1	4	12	http://www.metmuseum.org/art/collection/search/481	4/23/2018 8:00:01 AM	1
9798	1984.231	1	10572	2	198	The Ohio River near Wheeling, West Virginia	2		Lefevre James Cranstone	active United States, 1859–60	1366	7	1810	1910	1859–60	1859	1860	1496	12 x 18 in. (30.5 x 45.7 cm)	Purchase, Gifts of Mrs. Louise Lamson and Mrs. Alfred N. Lawrence, by exchange, 1984	1			4	9	http://www.metmuseum.org/art/collection/search/10572	4/23/2018 8:00:01 AM	1
10404	1981.446.1	1	11280	2	198	Trenton Falls, New York	2		Robert Jones	active 1822–ca. 1848	1548	7	1822	1851	1836	1836	1836	1669	16 1/4 x 10 1/2 in. (41.3 x 26.7 cm)	Gift of Mr. and Mrs. Stuart P. Feld, 1981	1			4	9	http://www.metmuseum.org/art/collection/search/11280	4/23/2018 8:00:01 AM	1
11611	1970.9.3	1	12623	2	198	Wood Carrier, near Amalfi (from Cropsey Album)	2		George Snell	1820–1893	1799		1820	1893	1878	1878	1878	1903	7 1/2 x 5 3/8 in. (19.1 x 13.7 cm)	Purchase, Charles and Anita Blatt Gift, 1970	5			4	9	http://www.metmuseum.org/art/collection/search/12623	4/23/2018 8:00:01 AM	1
11885	46.50.1	1	12921	2	73	John Isham									1750	1750	1750	620	1 5/16 x 1 3/16 in. (3.3 x 3 cm)	Rogers Fund, 1946	1			4	11	http://www.metmuseum.org/art/collection/search/12921	4/23/2018 8:00:01 AM	1
13284	26.216.10	1	14445	2	23	Farm Landscape (from McGuire Scrapbook)	2		Thomas Sidney Cooper	British, Canterbury, Kent 1803–1902 Harbledown	2194	7	1803	1902		1803	1902	37	6 1/2 x 7 11/16 in. (16.5 x 19.5 cm)	Gift of James C. McGuire, 1926	1			4	9	http://www.metmuseum.org/art/collection/search/14445	4/23/2018 8:00:01 AM	1
13299	26.216.82	1	14460	2	23	Child in a Landscape (from McGuire Scrapbook)	2		Charles Robert Leslie	British, London 1794–1859 London	1327	7	1794	1859	1794–1859	1794	1859	37	4 5/16 x 5 7/16 in. (11 x 13.8 cm)	Gift of James C. McGuire, 1926	1			4	9	http://www.metmuseum.org/art/collection/search/14460	4/23/2018 8:00:01 AM	1
13300	26.216.7	1	14461	2	23	Village Landscape (from McGuire Scrapbook)	2		Thomas Sidney Cooper	British, Canterbury, Kent 1803–1902 Harbledown	2194	7	1803	1902	1831	1831	1831	37	6 7/8 x 7 in. (17.5 x 17.8 cm)	Gift of James C. McGuire, 1926	1			4	9	http://www.metmuseum.org/art/collection/search/14461	4/23/2018 8:00:01 AM	1
13301	26.216.73	1	14462	2	23	Study of a Boy (from McGuire Scrapbook)	2		Thomas Sidney Cooper	British, Canterbury, Kent 1803–1902 Harbledown	2194	7	1803	1902		1803	1902	37	4 1/4 x 3 5/8 in. (10.8 x 9.2 cm)	Gift of James C. McGuire, 1926	1			4	9	http://www.metmuseum.org/art/collection/search/14462	4/23/2018 8:00:01 AM	1