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 "Portfolio" = :p0 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	Portfolio	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
206778	49.55.155	1	334122	11	731	Polin	30	2	Henri de Toulouse-Lautrec	French, Albi 1864–1901 Saint-André-du-Bois	17312	2	1864	1901	1898	1898	1898	29116	image: 11 5/16 x 9 1/8 in. (28.7 x 23.2 cm) sheet: 15 1/4 x 12 3/8 in. (38.8 x 31.4 cm)	Alfred Stieglitz Collection, 1949	13	http://www.metmuseum.org/art/collection/search/334122	4/23/2018 8:00:01 AM	1
206779	49.55.156	1	334123	11	731	Marie-Louise Marsy	30	2	Henri de Toulouse-Lautrec	French, Albi 1864–1901 Saint-André-du-Bois	17312	2	1864	1901	1898	1898	1898		Sheet: 15 3/8 x 12 7/16 in. (39 x 31.6 cm) Image: 11 5/8 x 9 1/16 in. (29.5 x 23 cm)	Alfred Stieglitz Collection, 1949	13	http://www.metmuseum.org/art/collection/search/334123	4/23/2018 8:00:01 AM	1
206780	49.55.159	1	334124	11	731	Jane Hading	30	2	Henri de Toulouse-Lautrec	French, Albi 1864–1901 Saint-André-du-Bois	17312	2	1864	1901	1898	1898	1898	29115	sheet: 15 3/8 x 12 7/16 in. (39 x 31.6 cm) image: 11 5/8 x 9 1/16 in. (29.5 x 23 cm)	Alfred Stieglitz Collection, 1949	13	http://www.metmuseum.org/art/collection/search/334124	4/23/2018 8:00:01 AM	1
207390	49.55.161	1	334743	11	731	Sybil Sanderson	30	2	Henri de Toulouse-Lautrec	French, Albi 1864–1901 Saint-André-du-Bois	17312	2	1864	1901	1898	1898	1898	29115	image: 11 5/8 x 9 1/4 in. (29.5 x 23.5 cm) sheet: 15 3/8 x 12 7/16 in. (39 x 31.6 cm)	Alfred Stieglitz Collection, 1949	13	http://www.metmuseum.org/art/collection/search/334743	4/23/2018 8:00:01 AM	1
207392	49.55.157	1	334745	11	731	Coquelin Aîné	30	2	Henri de Toulouse-Lautrec	French, Albi 1864–1901 Saint-André-du-Bois	17312	2	1864	1901	1898	1898	1898	29115	sheet: 15 7/16 x 12 7/16 in. (39.2 x 31.6 cm) image: 11 5/8 x 9 1/16 in. (29.5 x 23 cm)	Alfred Stieglitz Collection, 1949	13	http://www.metmuseum.org/art/collection/search/334745	4/23/2018 8:00:01 AM	1
207393	49.55.158	1	334746	11	731	Lucien Guitry	30	2	Henri de Toulouse-Lautrec	French, Albi 1864–1901 Saint-André-du-Bois	17312	2	1864	1901	1898	1898	1898	29115	sheet: 14 13/16 x 12 7/16 in. (37.7 x 31.6 cm) image: 11 5/8 x 9 7/16 in. (29.5 x 24 cm)	Alfred Stieglitz Collection, 1949	13	http://www.metmuseum.org/art/collection/search/334746	4/23/2018 8:00:01 AM	1
206783	49.55.328	1	334127	11	731	May Belfort	30	821	Henri de Toulouse-Lautrec\|May Belfort	French, Albi 1864–1901 Saint-André-du-Bois\|Irish, 1872–1929	17385	2	1864 \|1865	1901 \|1929	1898	1898	1898	29119	sheet: 11 7/16 x 9 7/16 in. (29.1 x 24 cm)	Alfred Stieglitz Collection, 1949	13	http://www.metmuseum.org/art/collection/search/334127	4/23/2018 8:00:01 AM	1
206777	49.55.154	1	334121	11	731	May Belfort	30	972	Henri de Toulouse-Lautrec\|May Belfort	French, Albi 1864–1901 Saint-André-du-Bois\|Irish, 1872–1929	17385	2	1864 \|1865	1901 \|1929	1898	1898	1898	29115	sheet: 15 7/16 x 12 7/16 in. (39.2 x 31.6 cm) image: 11 3/4 x 9 7/16 in. (29.8 x 24 cm)	Alfred Stieglitz Collection, 1949	13	http://www.metmuseum.org/art/collection/search/334121	4/23/2018 8:00:01 AM	1