MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 17 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 "Geography Type" = :p1 order by [Is Highlight] 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	State	County	Country	Classification	Link Resource	Metadata Date	Repository
805	41.154	1	881	1	112	Slop Bowl	19									ca. 1780	1777	1780	109	H. 3 in. (7.6 cm); Diam. 6 1/4 in. (15.9 cm)	Gift of Mrs. Ernest R. Adee, 1941	5	27			9	5	http://www.metmuseum.org/art/collection/search/881	4/23/2018 8:00:01 AM	1
2583	51.171.29	0	2778	1	107	Cup										1800–1900	1800	1900	218	H. 1 3/4 in. (4.4 cm)	Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951	5				9	3	http://www.metmuseum.org/art/collection/search/2778	4/23/2018 8:00:01 AM	1
2584	51.171.46	0	2779	1	107	Cup										1800–1900	1800	1900	616	H. 1 3/4 in. (4.4 cm)	Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951	5				9	3	http://www.metmuseum.org/art/collection/search/2779	4/23/2018 8:00:01 AM	1
2604	41.127.5, .6	1	2801	1	285	Cup and Saucer	19									ca. 1780	1777	1783	109	Cup: H. 2 5/8 in. (6.7 cm); Diam. 2 5/8 in. (6.7 cm) Saucer: Diam. 5 1/8 in. (13 cm)	Gift of Miss Edith Johnson, 1941	5	27			9	5	http://www.metmuseum.org/art/collection/search/2801	4/23/2018 8:00:01 AM	1
2605	41.127.7, .8	1	2802	1	285	Cup and Saucer	19									ca. 1780	1777	1783	109	Cup: H. 2 1/4 in. (5.7 cm); Diam. 3 1/8 in. (7.9 cm) Saucer: Diam. 5 1/8 in. (13 cm)	Gift of Miss Edith Johnson, 1941	5	27			9	5	http://www.metmuseum.org/art/collection/search/2802	4/23/2018 8:00:01 AM	1
2606	41.127.9, .10	1	2803	1	285	Cup and Saucer	19									ca. 1780	1777	1783	109	Cup: H. 2 1/4 in. (5.7 cm); Diam. 3 1/8 in. (7.9 cm) Saucer: Diam. 5 1/8 in. (13 cm)	Gift of Miss Edith Johnson, 1941	5	27			9	5	http://www.metmuseum.org/art/collection/search/2803	4/23/2018 8:00:01 AM	1
2607	41.129.1, .3	1	2804	1	285	Cup and Saucer	19									ca. 1780	1777	1780	109	Cup: H. 2 1/4 in. (5.7 cm); Diam. 3 1/8 in. (7.9 cm) Saucer: Diam. 5 in. (12.7 cm)	Gift of Miss Louisa Verplanck Richards, 1941	5	27			9	5	http://www.metmuseum.org/art/collection/search/2804	4/23/2018 8:00:01 AM	1
2608	41.129.2, .4	1	2805	1	285	Cup and Saucer	19									ca. 1780	1777	1780	109	Cup: H. 2 1/2 in. (6.4 cm); Diam. 2 1/2 in. (6.4 cm) Saucer: Diam. 5 in. (12.7 cm)	Gift of Miss Louisa Verplanck Richards, 1941	5	27			9	5	http://www.metmuseum.org/art/collection/search/2805	4/23/2018 8:00:01 AM	1
2609	41.130.3, .4	1	2806	1	285	Cup and Saucer	19									ca. 1780	1777	1780	109	Cup: H. 2 1/4 in. (5.7 cm); Diam. 3 7/8 in. (9.8 cm) Saucer: Diam. 5 1/8 in. (13 cm)	Gift of Mrs. Alice Richards Sorbo and Guy Richards, 1941	5	27			9	5	http://www.metmuseum.org/art/collection/search/2806	4/23/2018 8:00:01 AM	1
2610	41.132.1, .2	1	2807	1	285	Cup and Saucer	19									ca. 1780	1777	1780	109	Cup: H. 2 1/4 in. (5.7 cm); Diam. 3 1/8 in. (7.9 cm) Saucer: Diam. 5 1/8 in. (13 cm)	Gift of W. Everett Verplanck, 1941	5	27			9	5	http://www.metmuseum.org/art/collection/search/2807	4/23/2018 8:00:01 AM	1
3107	41.127.4	1	3325	1	110	Dish	19									ca. 1780	1777	1783	109	Diam. 6 3/16 in. (15.7 cm)	Gift of Miss Edith Johnson, 1941	5	27			9	5	http://www.metmuseum.org/art/collection/search/3325	4/23/2018 8:00:01 AM	1
3144	11.109	1	3365	1	363	Door Knob										1800–1830	1800	1830	672	H. 2 3/4 in. (7 cm)	Gift of Edward A. Penniman, as an addition to the Huntington Collection, 1911	5				9	3	http://www.metmuseum.org/art/collection/search/3365	4/23/2018 8:00:01 AM	1
3696	83.2.144	1	3950	1	72	George Washington	7									1776–1800	1776	1800	150	Diam. 4 in. (10.2 cm)	Gift of William H. Huntington, 1883	5	176	41	41	9	5	http://www.metmuseum.org/art/collection/search/3950	4/23/2018 8:00:01 AM	1
3702	83.2.151	1	3956	1	75	George Washington	7	1		Antoine Bonnefoy	French	567	2			1776–1800	1776	1800	781	Diam. 15 in. (38.1 cm)	Gift of William H. Huntington, 1883	5	177	42	42	9	5	http://www.metmuseum.org/art/collection/search/3956	4/23/2018 8:00:01 AM	1
5851	41.127.3	1	6245	1	152	Cake Plate	19									ca. 1780	1777	1783	109	Diam. 8 3/4 in. (22.2 cm)	Gift of Miss Edith Johnson, 1941	5	27			9	5	http://www.metmuseum.org/art/collection/search/6245	4/23/2018 8:00:01 AM	1
6408	04.12	1	6854	1	75	Plaque of Benjamin Franklin		1	Attributed to	Jean Martin Renaud	French, Sarreguemines 1746–1821 Paris	123	2	1746	1821	1776–1821	1776	1821	23	2 3/4 x 1 7/8 in. (7 x 4.8 cm)	Gift of John L. Cadwalader, 1904	5	27			9	1	http://www.metmuseum.org/art/collection/search/6854	4/23/2018 8:00:01 AM	1
7496	41.127.2	1	7984	1	307	Sugar Bowl	19									ca. 1780	1777	1783	109	H. 3 3/8 in. (8.6 cm); Diam. 4 in. (10.2 cm)	Gift of Miss Edith Johnson, 1941	5	27			9	5	http://www.metmuseum.org/art/collection/search/7984	4/23/2018 8:00:01 AM	1