MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 27 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 Alpha Sort" = :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	Period	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	Classification	Link Resource	Metadata Date	Repository
31057	JP198	1	36675	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	5th month, 1736	1736	1736	7352	11 1/4 x 5 13/16 in. (28.6 x 14.8 cm)	Rogers Fund, 1914	13	http://www.metmuseum.org/art/collection/search/36675	4/23/2018 8:00:01 AM	1
31084	JP230	1	36702	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1748	1738	1758	7352	10 1/2 x 5 17/32 in. (26.7 x 14.1 cm)	Rogers Fund, 1918	13	http://www.metmuseum.org/art/collection/search/36702	4/23/2018 8:00:01 AM	1
31085	JP231	1	36703	7	3907		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1748	1738	1758	7352	12 1/32 x 5 5/8 in. (30.6 x 14.3 cm)	Rogers Fund, 1918	13	http://www.metmuseum.org/art/collection/search/36703	4/23/2018 8:00:01 AM	1
31086	JP232	1	36704	7	3907		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	dated 1749	1749	1749	7352	10 17/32 x 5 1/2 in. (26.8 x 14.0 cm)	Rogers Fund, 1918	13	http://www.metmuseum.org/art/collection/search/36704	4/23/2018 8:00:01 AM	1
31479	JP651	1	37101	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1705	1695	1715	7352	12 x 20 3/8 in. (30.5 x 51.8 cm)	The Francis Lathrop Collection, Purchase, Frederick C. Hewitt Fund, 1911	13	http://www.metmuseum.org/art/collection/search/37101	4/23/2018 8:00:01 AM	1
31480	JP652	1	37102	7	3907		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1705	1695	1715	7352	21 7/8 x 12 3/4 in. (55.6 x 32.4 cm)	The Francis Lathrop Collection, Purchase, Frederick C. Hewitt Fund, 1911	13	http://www.metmuseum.org/art/collection/search/37102	4/23/2018 8:00:01 AM	1
31481	JP653	1	37103	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1713	1703	1723	7352	20 31/32 x 12 5/8 in. (53.3 x 32.1 cm)	The Francis Lathrop Collection, Purchase, Frederick C. Hewitt Fund, 1911	13	http://www.metmuseum.org/art/collection/search/37103	4/23/2018 8:00:01 AM	1
31482	JP654	1	37104	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1710	1700	1720	7352	20 3/4 x 12 5/8 in. (52.7 x 32.1 cm)	The Francis Lathorp Collection, Purchase, Frederick C. Hewitt Fund, 1911	13	http://www.metmuseum.org/art/collection/search/37104	4/23/2018 8:00:01 AM	1
31513	JP688	1	37135	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1730	1720	1740	7352	12 1/8 x 5 3/4 in. (30.8 x 14.6 cm)	The Francis Lathrop Collection, Purchase, Frederick C. Hewitt Fund, 1911	13	http://www.metmuseum.org/art/collection/search/37135	4/23/2018 8:00:01 AM	1
31514	JP689	1	37136	7	3907		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1750	1740	1760	7352	12 1/2 x 5 7/8 in. (31.8 x 14.9 cm)	The Francis Lathrop Collection, Purchase, Frederick C. Hewitt Fund, 1911	13	http://www.metmuseum.org/art/collection/search/37136	4/23/2018 8:00:01 AM	1
31515	JP690	1	37137	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1755	1745	1765	7352	11 3/8 x 5 7/32 in. (28.9 x 13.3 cm)	The Francis Lathrop Collection, Purchase, Frederick C. Hewitt Fund, 1911	13	http://www.metmuseum.org/art/collection/search/37137	4/23/2018 8:00:01 AM	1
31643	JP821	1	37265	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1730	1720	1740	7398	13 1/10 x 6 1/8 in. (33.3 x 15.6 cm)	Gift of Estate of Samuel Isham, 1914	13	http://www.metmuseum.org/art/collection/search/37265	4/23/2018 8:00:01 AM	1
31644	JP822	1	37266	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1735	1725	1745	7398	Overall: 12 1/4 x 5 7/8in. (31.1 x 14.9cm)	Gift of Estate of Samuel Isham, 1914	13	http://www.metmuseum.org/art/collection/search/37266	4/23/2018 8:00:01 AM	1
31645	JP823	1	37267	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1745	1735	1755	7352	12 11/32 x 5 7/8 in. (31.4 x 14.9 cm)	Gift of Estate of Samuel Isham, 1914	13	http://www.metmuseum.org/art/collection/search/37267	4/23/2018 8:00:01 AM	1
38877	JP3073	1	45052	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1712	1702	1722	9282	12 1/4 x 6 in. (31.1 x 15.2 cm)	Harris Brisbane Dick Fund and Rogers Fund, 1949	13	http://www.metmuseum.org/art/collection/search/45052	4/23/2018 8:00:01 AM	1
38878	JP3099	1	45053	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1712	1702	1722	9283	22 1/2 x 12 1/4 in. (57.2 x 31.1 cm)	Harris Brisbane Dick Fund and Rogers Fund, 1949	13	http://www.metmuseum.org/art/collection/search/45053	4/23/2018 8:00:01 AM	1
38879	JP3100	1	45054	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1716	1706	1726	9284	23 1/4 x 12 1/4 in. (59.1 x 31.1 cm)	Harris Brisbane Dick Fund and Rogers Fund, 1949	13	http://www.metmuseum.org/art/collection/search/45054	4/23/2018 8:00:01 AM	1
39003	JP3072	1	45247	7	731	Kairaishi\|The Actor Ichimura Takenojo VIII in the Role of a Puppeteer, showing Puppets to a Courtesan	46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1715	1705	1725	7389	11 x 16 in. (27.9 x 40.6 cm)	Harris Brisbane Dick Fund and Rogers Fund, 1914	13	http://www.metmuseum.org/art/collection/search/45247	4/23/2018 8:00:01 AM	1
46850	JP824	1	54478	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1745	1735	1755	7352	H. 12 3/8 in. (31.4 cm); W. 5 3/4 in. (14.6 cm)	Gift of Estate of Samuel Ishma, 1914	13	http://www.metmuseum.org/art/collection/search/54478	4/23/2018 8:00:01 AM	1
46851	JP825	1	54479	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1748	1738	1758	7352	H. 12 3/8 in. (31.4 cm); W. 5 7/8 in. (14.9 cm)	Gift of Estate of Samuel Isham, 1914	13	http://www.metmuseum.org/art/collection/search/54479	4/23/2018 8:00:01 AM	1
46852	JP826	1	54480	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1748	1738	1758	7352	H. 12 3/8 in. (31.4 cm); W. 5 3/4 in. (14.6 cm)	Gift of Estate of Samuel Isham, 1914	13	http://www.metmuseum.org/art/collection/search/54480	4/23/2018 8:00:01 AM	1
46853	JP827	1	54481	7	3907		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1752	1742	1762	7352	H. 12 1/2 in. (31.8 cm); W. 5 7/8 in. (14.9 cm)	Gift of Estate of Samuel Isham, 1914	13	http://www.metmuseum.org/art/collection/search/54481	4/23/2018 8:00:01 AM	1
47399	JP1110	1	55035	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1745	1735	1755	7352	H. 12 1/2 in. (31.8 cm); W. 5 1/2 in. (14 cm)	Rogers Fund, 1919	13	http://www.metmuseum.org/art/collection/search/55035	4/23/2018 8:00:01 AM	1
48103	JP1599	1	55763	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716		1696	1716	7352	H. 12 1/8 in. (30.8 cm); W. 5 3/4 in. (14.6 cm)	H. O. Havemeyer Collection, Bequest of Mrs. H. O. Havemeyer, 1929	13	http://www.metmuseum.org/art/collection/search/55763	4/23/2018 8:00:01 AM	1
48885	JP2583	1	56728	7	3910		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	12th month, 1743 or 1st month, 1744	1743	1744	11842	12 1/2 x 5 3/4 in. (31.8 x 14.6 cm)	The Howard Mansfield Collection, Purchase, Rogers Fund, 1936	13	http://www.metmuseum.org/art/collection/search/56728	4/23/2018 8:00:01 AM	1
48886	JP2584	1	56729	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1734	1724	1744	11842	11 1/2 x 5 3/4 in. (29.2 x 14.6 cm)	The Howard Mansfield Collection, Purchase, Rogers Fund, 1936	13	http://www.metmuseum.org/art/collection/search/56729	4/23/2018 8:00:01 AM	1
48887	JP2585	1	56730	7	731		46	Edo period (1615–1868)	2	Torii Kiyomasu I	Japanese, active 1696–1716	3472	74	1696	1716	ca. 1741	1731	1751	7352	12 3/4 x 5 3/4 in. (32.4 x 14.6 cm)	The Howard Mansfield Collection, Purchase, Rogers Fund, 1936	13	http://www.metmuseum.org/art/collection/search/56730	4/23/2018 8:00:01 AM	1