MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 42 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 Suffix" = :p0 and "Department" = :p1 order by Repository 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 Suffix	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
179497	2005.100.382 (1-85)	1	283076	13	1119	[Emma Charlotte Dillwyn Llewelyn's Album]	825		John Dillwyn Llewelyn\|Thereza Dillwyn Llewelyn\|Jane Martha St. John\|James Knight\|Miss Bush\|Peter Wickens Fry\|M.D.	British, Swansea, Wales 1810–1882 Swansea, Wales\|British, 1803–1882\|British\|British, active 19th century\|British, Compton Bishop, Somerset 1795–1860 London	, et al	15723	599	1810 \|1803 \|1795	1882 \|1882 \|1860-08-29	1853–56	1853	1856	26330	28.8 × 22.3 cm (11 5/16 × 8 3/4 in.)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	441	http://www.metmuseum.org/art/collection/search/283076	4/23/2018 8:00:01 AM	1
182219	2005.100.505.1 (1-48)	1	285940	13	1119	[Chinese and Japanese Portraits]	53		Raimund von Stillfried\|Unknown\|Suzuki Shin'ichi	Austrian, 1839–1911\|Japanese, 1835–1919	, et al	16062	636	1839 \|1835	1911 \|1919	1870s	1870	1879	26191	28 x 35.3 x 4.8 cm (11 x 13 7/8 x 1 7/8 in.)	Gilman Collection, Museum Purchase, 2005	441	http://www.metmuseum.org/art/collection/search/285940	4/23/2018 8:00:01 AM	1
182356	2005.100.864	0	286095	13	1119	[Portraits of Princess Katherine Mikhailovna Dolgoruka]	2	Possibly by	Sergei Luvovich Levitsky	Russian, 1819–1898	, et al	16082	57	1819	1898	1866–67	1866	1867	26061	Image: 3 1/4 × 2 1/16 in. (8.3 × 5.2 cm) Mount: 5 7/8 in. × 4 1/8 in. (15 × 10.5 cm)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	441	http://www.metmuseum.org/art/collection/search/286095	4/23/2018 8:00:01 AM	1
182364	2005.100.494.1–.105	0	286104	13	1119	[Views of China]	189		John Thomson\|Milton M. Miller\|Lai Fong\|Tung Hing	British, Edinburgh, Scotland 1837–1921 London\|American, active China, 1830–1899\|Chinese, 1839–1890\|Chinese, active 1870s	, et al	16086	638	1837 \|1830 \|1839	1921 \|1899 \|1890	ca. 1869	1867	1871	26191		Gilman Collection, Purchase, Robert Rosenkranz Gift, 2005	441	http://www.metmuseum.org/art/collection/search/286104	4/23/2018 8:00:01 AM	1
182409	2005.100.410 (1-9)	1	286154	13	1119	[Duc de Morny Album]	386	Painted and retouched by\|Commissioned by	Pierre-Louis Pierson\|Marck\|Charles-Auguste-Louis-Joseph de Morny, duc de Morny	French, 1822–1913\|French (born Switzerland) 1811–1865 Paris	, et al	16096	356	1822 \|1811	1913 \|1865	before 1865	1855	1865	26416	38 x 31.5 x 8.5 cm (14 15/16 x 12 3/8 x 3 3/8 in.) Album 35 CDVs approximately 8.6 x 5.1 cm 6 photographs various sizes from 10.1 x 7.1 cm to 16.9 x 11.9 cm	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	441	http://www.metmuseum.org/art/collection/search/286154	4/23/2018 8:00:01 AM	1
184091	2005.100.410 (1)	1	288141	13	997	[Duchesse de Morny]	815	Painted and retouched by\|Person in photograph	Pierre-Louis Pierson\|Marck\|Sophie Troubetzkoi, duchesse de Morny	French, 1822–1913\|Russian, Moscow 1838–1896	, et al	16260	660	1822 \|1838	1913 \|1896	before 1865	1855	1865	26091	Image: 6 5/16 × 4 3/4 in. (16 × 12 cm) Mount: 14 3/16 in. × 11 in. (36 × 28 cm)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288141	4/23/2018 8:00:01 AM	1
184105	2005.100.410 (2a)	1	288155	13	997	[Unknown Sitter]	13	Painted and retouched by	Pierre-Louis Pierson\|Marck	French, 1822–1913	, et al	16274	2	1822	1913	before 1865	1855	1865	26091	Image: 6 5/16 × 4 3/4 in. (16 × 12 cm) Mount: 14 3/16 in. × 11 in. (36 × 28 cm)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288155	4/23/2018 8:00:01 AM	1
184106	2005.100.410 (2b)	1	288156	13	997	[Marie de Morny]	13	Painted and retouched by	Pierre-Louis Pierson\|Marck	French, 1822–1913	, et al	16274	2	1822	1913	before 1865	1855	1865	26091	Window: 7 1/2 × 5 1/2 in. (19 × 14 cm) Image: 4 in. × 2 13/16 in. (10.2 × 7.2 cm)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288156	4/23/2018 8:00:01 AM	1
184107	2005.100.410 (3a)	1	288157	13	997	[Countess de Castiglione as the Queen of Etruria]	815	Painted and retouched by\|Person in photograph	Pierre-Louis Pierson\|Marck\|Countess Virginia Oldoini Verasis di Castiglione	French, 1822–1913\|1835–1899	, et al	16275	2	1822 \|1835	1913 \|1899	before 1865	1855	1865	26091	Window: 7 1/2 × 5 1/2 in. (19 × 14 cm) Image: 4 in. × 2 13/16 in. (10.2 × 7.2 cm)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288157	4/23/2018 8:00:01 AM	1
184108	2005.100.410 (3b)	1	288158	13	997	[Countess de Castiglione as Anne Boleyn]	815	Painted and retouched by\|Person in photograph	Pierre-Louis Pierson\|Marck\|Countess Virginia Oldoini Verasis di Castiglione	French, 1822–1913\|1835–1899	, et al	16275	2	1822 \|1835	1913 \|1899	before 1865	1855	1865	26091	Window: 7 1/2 × 5 1/2 in. (19 × 14 cm) Image: 4 in. × 2 13/16 in. (10.2 × 7.2 cm)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288158	4/23/2018 8:00:01 AM	1
184109	2005.100.410 (4)	1	288159	13	997	[Empress Eugénie as an Odalisque]	815	Painted and retouched by\|Person in photograph	Pierre-Louis Pierson\|Marck\|Empress Eugénie de Montijo	French, 1822–1913\|French (born Spain), Granada 1826–1920 Madrid	, et al	16276	667	1822 \|1826	1913 \|1920	1861–65	1861	1865	26467	Image: 17 x 12 cm (6 11/16 x 4 3/4 in.) Mount: 38 x 28 cm (14 15/16 x 11 in.)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288159	4/23/2018 8:00:01 AM	1
184110	2005.100.410 (5a-d)	1	288160	13	13011	[Unknown Sitters and Duchesse de Morny]	13	Painted and retouched by	Pierre-Louis Pierson\|Marck	French, 1822–1913	, et al	16274	2	1822	1913	before 1865	1855	1865	26416	Image: 3 3/8 in. × 2 in. (8.6 × 5.1 cm) (each)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288160	4/23/2018 8:00:01 AM	1
184111	2005.100.410 (5e-h)	1	288161	13	13011	[Pourtalès, Metternich, Grande Duchesse de Mecklemboury, and Unknown Sitter]	13	Painted and retouched by	Pierre-Louis Pierson\|Marck	French, 1822–1913	, et al	16274	2	1822	1913	before 1865	1855	1865	26416	Image: 3 3/8 in. × 2 in. (8.6 × 5.1 cm) (each)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288161	4/23/2018 8:00:01 AM	1
184112	2005.100.410 (6a-d)	1	288162	13	13011	[Anna Murat and Unknown Sitters]	13	Painted and retouched by	Pierre-Louis Pierson\|Marck	French, 1822–1913	, et al	16274	2	1822	1913	before 1865	1855	1865	26416	Image: 3 3/8 in. × 2 in. (8.6 × 5.1 cm) (each)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288162	4/23/2018 8:00:01 AM	1
184113	2005.100.410 (6e-h)	1	288163	13	13011	[Comtesse Walewska and Princesse Jaochim Murat]	13	Painted and retouched by	Pierre-Louis Pierson\|Marck	French, 1822–1913	, et al	16274	2	1822	1913	before 1865	1855	1865	26416	Image: 3 3/8 in. × 2 in. (8.6 × 5.1 cm) (each)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288163	4/23/2018 8:00:01 AM	1
184114	2005.100.410 (7a-d)	1	288164	13	13011	[Unknown Sitters]	13	Painted and retouched by	Pierre-Louis Pierson\|Marck	French, 1822–1913	, et al	16274	2	1822	1913	before 1865	1855	1865	26416	Image: 3 3/8 in. × 2 in. (8.6 × 5.1 cm) (each)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288164	4/23/2018 8:00:01 AM	1
184115	2005.100.410 (7e-h)	1	288165	13	13011	[Unknown Sitters]	13	Painted and retouched by	Pierre-Louis Pierson\|Marck	French, 1822–1913	, et al	16274	2	1822	1913	before 1865	1855	1865	26416	Image: 3 3/8 in. × 2 in. (8.6 × 5.1 cm) (each)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288165	4/23/2018 8:00:01 AM	1
184116	2005.100.410 (8a-d)	1	288166	13	13011	[Unknown Sitters]	13	Painted and retouched by	Pierre-Louis Pierson\|Marck	French, 1822–1913	, et al	16274	2	1822	1913	before 1865	1855	1865	26416	Image: 3 3/8 in. × 2 in. (8.6 × 5.1 cm) (each)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288166	4/23/2018 8:00:01 AM	1
184117	2005.100.410 (8e-g)	1	288167	13	13011	[Madame Demidoff and Unknown Sitters]	13	Painted and retouched by	Pierre-Louis Pierson\|Marck	French, 1822–1913	, et al	16274	2	1822	1913	before 1865	1855	1865	26416	Image: 3 3/8 in. × 2 in. (8.6 × 5.1 cm) (each)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288167	4/23/2018 8:00:01 AM	1
184118	2005.100.410 (9a-d)	1	288168	13	13011	[Duchesse d'Albe, Unknown Sitter, Duchesse de Morny, and Duc de Morny]	885	Painted and retouched by\|Person in photograph\|Person in photograph	Pierre-Louis Pierson\|Marck\|Sophie Troubetzkoi, duchesse de Morny\|Charles-Auguste-Louis-Joseph de Morny, duc de Morny	French, 1822–1913\|Russian, Moscow 1838–1896\|French (born Switzerland) 1811–1865 Paris	, et al	16277	668	1822 \|1838 \|1811	1913 \|1896 \|1865	before 1865	1855	1865	26416	Image: 3 3/8 in. × 2 in. (8.6 × 5.1 cm) (each)	Gilman Collection, Gift of The Howard Gilman Foundation, 2005	21	http://www.metmuseum.org/art/collection/search/288168	4/23/2018 8:00:01 AM	1
428666	2005.100.1033	1	711640	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711640	4/23/2018 8:00:01 AM	1
428667	2005.100.1034	1	711641	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711641	4/23/2018 8:00:01 AM	1
428668	2005.100.1035	1	711642	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711642	4/23/2018 8:00:01 AM	1
428669	2005.100.1036	1	711643	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711643	4/23/2018 8:00:01 AM	1
428670	2005.100.1037	1	711644	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711644	4/23/2018 8:00:01 AM	1
428671	2005.100.1038	1	711645	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711645	4/23/2018 8:00:01 AM	1
428672	2005.100.1039	1	711646	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711646	4/23/2018 8:00:01 AM	1
428673	2005.100.1040	1	711647	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711647	4/23/2018 8:00:01 AM	1
428674	2005.100.1041	1	711648	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711648	4/23/2018 8:00:01 AM	1
428675	2005.100.1042	1	711649	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711649	4/23/2018 8:00:01 AM	1
428676	2005.100.1043	1	711650	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711650	4/23/2018 8:00:01 AM	1
428677	2005.100.1044	1	711651	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711651	4/23/2018 8:00:01 AM	1
428678	2005.100.1045	1	711652	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711652	4/23/2018 8:00:01 AM	1
428679	2005.100.1046	1	711653	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711653	4/23/2018 8:00:01 AM	1
428680	2005.100.1047	1	711654	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711654	4/23/2018 8:00:01 AM	1
428681	2005.100.1048	1	711655	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711655	4/23/2018 8:00:01 AM	1
428682	2005.100.1049	1	711656	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711656	4/23/2018 8:00:01 AM	1
428683	2005.100.1050	1	711657	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711657	4/23/2018 8:00:01 AM	1
428684	2005.100.1051	0	711658	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711658	4/23/2018 8:00:01 AM	1
428685	2005.100.1052	0	711659	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711659	4/23/2018 8:00:01 AM	1
428686	2005.100.1053	0	711660	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711660	4/23/2018 8:00:01 AM	1
428687	2005.100.1054	1	711661	13	997	[Civil War View]	2		Thomas C. Roche	American, 1826–1895	, et al	15758		1826	1895	1860s	1860	1869	26061		Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005	21	http://www.metmuseum.org/art/collection/search/711661	4/23/2018 8:00:01 AM	1