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 "Artist Nationality" = :p0 and "Medium" = :p1 order by [Object End Date] limit 101

Query parameters

This data as json, CSV

rowid	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Culture	Period	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	Classification	Link Resource	Metadata Date	Repository
51509	1985.399.18	1	59660	7	4245		46		2	Attributed to	Rensai		4632	74				0	0	148	H. 1/2 in. (1.3 cm); W. 1 5/8 in. (4.1 cm)	Gift of Alvin H. Schechter, 1985	203	http://www.metmuseum.org/art/collection/search/59660	4/23/2018 8:00:01 AM	1
51706	10.211.192	1	59880	7	4245		46		2	Formerly Attributed to	Garaku	Japanese, active second half of the 18th century	4638	74	1750	1799	18th century	1700	1799	148	H. 13/16 in. (2.1 cm); W. 1 1/2 in. (3.8 cm); L. 1 13/16 in. (4.6 cm)	Gift of Mrs. Russell Sage, 1910	203	http://www.metmuseum.org/art/collection/search/59880	4/23/2018 8:00:01 AM	1
52146	10.211.1271	1	60329	7	4245	草花螳螂牙彫根付\|Flowers and Grasses with a Praying-Mantis	46	Edo period (1615–1868)	2	Attributed to	Ryūsa	Japanese, active late 18th century	4653	74	1767	1799	late 18th century	1767	1799	148	H. 7/8 in. (2.2 cm); Diam. 2 1/8 in. (5.4 cm)	Gift of Mrs. Russell Sage, 1910	203	http://www.metmuseum.org/art/collection/search/60329	4/23/2018 8:00:01 AM	1
52193	10.211.1436	1	60382	7	4245	狸牙彫根付\|Tanuki (Japanese Racoon Dog) with a Sake Bottle and Bills for Sake	46	Edo period (1615–1868)	2		Garaku	Japanese, active second half of the 18th century	4638	74	1750	1799	second half of the 18th century	1750	1799	148	H. 2 3/4 in. (7 cm); W. 1 5/8 in. (4.1 cm); D. 1 in. (2.5 cm)	Gift of Mrs. Russell Sage, 1910	203	http://www.metmuseum.org/art/collection/search/60382	4/23/2018 8:00:01 AM	1
51016	81.1.40	1	59162	7	4245	牛牙彫根付\|Ox	46	Edo period (1615–1868)	2		Tomotada	Japanese, active late 18th–early 19th century	4613	74	1777	1833	late 18th–early 19th century	1777	1833	148	H. 1 in. (2.5 cm); W. 2 1/4 in. (5.7 cm); D. 1 1/8 in. (2.9 cm)	Bequest of Stephen Whitney Phoenix, 1881	203	http://www.metmuseum.org/art/collection/search/59162	4/23/2018 8:00:01 AM	1
51034	81.1.91	1	59180	7	4245	猪牙彫根付\|Boar	46	Edo period (1615–1868)	2		Tomotada	Japanese, active late 18th–early 19th century	4613	74	1777	1833	late 18th–early 19th century	1767	1833	148	H. 1 in. (2.5 cm); W. 2 1/8 in. (5.4 cm); D. 1 1/4 in. (3.2 cm)	Bequest of Stephen Whitney Phoenix, 1881	203	http://www.metmuseum.org/art/collection/search/59180	4/23/2018 8:00:01 AM	1
51508	1985.399.17	1	59659	7	4245		46		2		Shūōsai		4631	74			early 19th century	1800	1833	148	H. 9/16 in. (1.4 cm); W. 1 1/2 in. (3.8 cm)	Gift of Alvin H. Schechter, 1985	203	http://www.metmuseum.org/art/collection/search/59659	4/23/2018 8:00:01 AM	1
52196	10.211.1441	1	60386	7	4245	東方朔仙人牙彫根付\|Daoist Immortal Tōbōsaku Sennin	46	Edo period (1615–1868)	2		Ryūminsai	Japanese, active late 18th–early 19th century	4656	74	1767	1833	late 18th–early 19th century	1767	1833	148	H. 3 1/4 in. (8.3 cm); W. 1 1/2 in. (3.8 cm); D. 1 in. (2.5 cm)	Gift of Mrs. Russell Sage, 1910	203	http://www.metmuseum.org/art/collection/search/60386	4/23/2018 8:00:01 AM	1
51025	81.1.72	1	59171	7	4245		46	Edo period (1615–1868)	2		Rantei	Japanese,	4614	74			late 18th–early 19th century	1771	1835	148	H. 1 1/2 in. (3.8 cm); W. 1 1/8 in. (2.9 cm); D. 1 3/8 in. (3.5 cm)	Bequest of Stephen Whitney Phoenix, 1881	203	http://www.metmuseum.org/art/collection/search/59171	4/23/2018 8:00:01 AM	1
52107	10.211.1106	1	60290	7	4245	犬牙彫根付\|Dog	46	Edo period (1615–1868)	2		Tomotada	Japanese, active late 18th–early 19th century	4613	74	1777	1833	late 18th century–early 19th century	1771	1835	148	H. 2 1/2 in. (6.4 cm); W. 1 1/4 in. (3.2 cm); D. 1/2 in. (1.3 cm)	Gift of Mrs. Russell Sage, 1910	203	http://www.metmuseum.org/art/collection/search/60290	4/23/2018 8:00:01 AM	1
52122	10.211.1154	1	60305	7	4245	枝豆牙彫根付\|Edamame (Soy Beans)	46	Edo period (1615–1868)	2		Okatomo	Japanese, active late 18th–early 19th century	4655	74	1767	1833	late 18th–early 19th century	1771	1835	148	H. 3/4 in. (1.9 cm); W. 2 1/4 in. (5.7 cm); D. 1 1/2 in. (3.8 cm)	Gift of Mrs. Russell Sage, 1910	203	http://www.metmuseum.org/art/collection/search/60305	4/23/2018 8:00:01 AM	1
51827	10.211.513	1	60002	7	4245		46	Edo period (1615–1868)	2		Shūōsai		4631	74			first half 19th century	1800	1850	148	H. 1 3/4 in. (4.5 cm); W. 1 7/16 in. (3.7 cm); D. 9/16 in. (1.5 cm)	Gift of Mrs. Russell Sage, 1910	203	http://www.metmuseum.org/art/collection/search/60002	4/23/2018 8:00:01 AM	1
51533	91.1.975	1	59689	7	4245		46	Edo period (1615–1868)	2		Mitsuhiro Ōhara	Japanese, 1810–1875	4636	74	1810	1875	mid-19th century	1825	1875	148	H. 1 in. (2.5 cm); W. 1 in. (2.5 cm); D. 1 3/4 in. (4.4 cm)	Edward C. Moore Collection, Bequest of Edward C. Moore, 1891	203	http://www.metmuseum.org/art/collection/search/59689	4/23/2018 8:00:01 AM	1
51650	10.211.107	1	59824	7	4245	文房具牙彫根付\|Writing Utensils	46	Edo period (1615–1868)	2		Ryūsen	Japanese, active mid–19th century	4637	74	1834	1866	mid-19th century	1825	1875	148	H. 1 1/2 in. (3.8 cm); W. 1 3/8 in. (3.5 cm)	Gift of Mrs. Russell Sage, 1910	203	http://www.metmuseum.org/art/collection/search/59824	4/23/2018 8:00:01 AM	1
50893	1985.399.27	1	59039	7	4245		46		2		Anraku	Japanese	4608	74			late 19th century	1871	1899	148	H. 3/4 in. (1.9 cm); W. 1 7/16 in. (3.7 cm)	Gift of Alvin H. Schechter, 1985	203	http://www.metmuseum.org/art/collection/search/59039	4/23/2018 8:00:01 AM	1
52083	10.211.1001	1	60266	7	4245		46		2		Ryūsa	Japanese, active late 18th century	4653	74	1767	1799	19th century	1800	1899	148	H. 1 3/16 in. (3 cm); W. 9/16 in. (1.4 cm); L. 1 3/8 in. (3.5 cm)	Gift of Mrs. Russell Sage, 1910	203	http://www.metmuseum.org/art/collection/search/60266	4/23/2018 8:00:01 AM	1
52144	10.211.1262	1	60327	7	4245		46		2		Ryūsa	Japanese, active late 18th century	4653	74	1767	1799	19th century	1800	1899	148	H. 3/4 in. (1.9 cm); Diam. 1 7/8 in. (4.8 cm)	Gift of Mrs. Russell Sage, 1910	203	http://www.metmuseum.org/art/collection/search/60327	4/23/2018 8:00:01 AM	1