MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 16 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 "Culture" = :p0 and "Department" = :p1 order by City 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 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
334364	1978.300.1	0	481775	4	30	Side Chair: Model #398	184	20	Gebrüder Thonet GmbH		45003	10			ca. 1905–11	1905	1911	77	34 × 16 1/2 × 22 7/8 in. (86.4 × 41.9 × 58.1 cm)	Purchase, 1917	4	http://www.metmuseum.org/art/collection/search/481775	4/23/2018 8:00:01 AM	1
334440	1978.508	1	481852	4	15111	"Schankelsofa" (Rocking Sofa)	184	5	Unknown Designer		44800				ca. 1880	1875	1885	51030	H. 67, W. 20-1/2 in. (170.2 x 52.1 cm.)	Gift of Calder Loth, in memory of Moritz Agost Rust, 1978	321	http://www.metmuseum.org/art/collection/search/481852	4/23/2018 8:00:01 AM	1
334442	1978.522	0	481857	4	15112	"Schlafsofa" (Sleeping Sofa)	184	3	Unknown Designer\|Gebrüder Thonet GmbH		45037	10			ca. 1888	1883	1903	51030	H. 43, W. 72, D. 26-1/2 in. (109.2 x 182.9 x 67.3 cm.)	Gift of Ruth and Frank Stanton, 1978	321	http://www.metmuseum.org/art/collection/search/481857	4/23/2018 8:00:01 AM	1
336071	1984.533.4ab	0	483595	4	15164	Comb case and comb	184	18	Wiener Werkstätte\|Unknown Designer		45505				ca. 1900	1900	1900	51441	H. 4-5/8, W. 2-1/8 in. (11.7 x 5.4 cm.)	Gift of Mr. and Mrs. Michael Chow, 1984	778	http://www.metmuseum.org/art/collection/search/483595	4/23/2018 8:00:01 AM	1
337600	1988.388.1	0	485176	4	15214	Mounted vase	184	18	Loetz\|Unknown Designer	Austrian	45922	66			ca. 1900	1900	1900	51877	H. 4-3/4, W. 6-5/8 in. (12.1 x 16.8 cm.)	Gift of Cynthia Hazen Polsky, 1988	3	http://www.metmuseum.org/art/collection/search/485176	4/23/2018 8:00:01 AM	1
339557	22.188ab	0	487228	4	100	Bird	184	4	Dagobert Peche\|Wiener Werkstätte	Austrian, St. Michael im Lungau 1887–1923 Mödling bei Wien	33914	66	1887	1923	1920	1920	1920	5711	7 3/8 x 4 3/4 x 2 1/4 in. (18.7 x 12.1 x 5.7 cm)	Purchase, Edward C. Moore Jr. Gift, 1922	313	http://www.metmuseum.org/art/collection/search/487228	4/23/2018 8:00:01 AM	1
339665	23.38.1	0	487356	4	1129	Pendant	184	18	Wiener Werkstätte in America\|Dagobert Peche	Austrian, St. Michael im Lungau 1887–1923 Mödling bei Wien	46469	66	1887	1923	20th century	1900	1920	148	H. 2-1/4, W. 1-1/8 in. (5.7 x 2.9 cm)	Purchase, Edward C. Moore Jr. Gift, 1923	10	http://www.metmuseum.org/art/collection/search/487356	4/23/2018 8:00:01 AM	1
339666	23.38.2	0	487357	4	1129	Pendant	184	18	Wiener Werkstätte in America\|Dagobert Peche	Austrian, St. Michael im Lungau 1887–1923 Mödling bei Wien	46469	66	1887	1923	20th century	1900	1920	148	H. 2, W. 1 inches (5.1 x 2.5 cm)	Purchase, Edward C. Moore Jr. Gift, 1923	10	http://www.metmuseum.org/art/collection/search/487357	4/23/2018 8:00:01 AM	1
340869	54.197.1	0	488792	4	1119	Album	184	18	Wiener Werkstätte\|Unknown Designers		46839				early 20th Century	1900	1924	52649	H. 8-1/2, W. 9 to 14 inches (21.6 x 22.9 to 35.6 cm.)	Rogers Fund, 1954	239	http://www.metmuseum.org/art/collection/search/488792	4/23/2018 8:00:01 AM	1
340870	54.197.2	0	488793	4	1119	Album	184	18	Wiener Werkstätte\|Unknown Designers		46839				early 20th Century	1900	1925	52649	Approximately: H. 8-1/2, W. 12 inches (21.6 x 30.5 cm.)	Rogers Fund, 1954	239	http://www.metmuseum.org/art/collection/search/488793	4/23/2018 8:00:01 AM	1
340871	54.197.3	0	488794	4	1119	Album	184	18	Wiener Werkstätte\|Unknown Designers		46839				early 20th Century	1900	1925	52649	Greatest:H. 8-1/8, W. 8-1/2 inches (21 x 21.6 cm.)	Rogers Fund, 1954	239	http://www.metmuseum.org/art/collection/search/488794	4/23/2018 8:00:01 AM	1
340872	54.197.4	0	488795	4	1119	Album	184	18	Wiener Werkstätte\|Unknown Designers		46839				early 20th Century	1900	1925	165	Greatest: H. 8, W. 9 inches (20.3 x 22.9 cm.)	Rogers Fund, 1954	239	http://www.metmuseum.org/art/collection/search/488795	4/23/2018 8:00:01 AM	1
340873	54.197.5	0	488796	4	1119	Album	184	18	Wiener Werkstätte\|Unknown Designers		46839				early 20th Century	1900	1925	2631	Approximately:H. 4-3/4, W. 7 inches (12.1 x 17.8 cm.)	Rogers Fund, 1954	239	http://www.metmuseum.org/art/collection/search/488796	4/23/2018 8:00:01 AM	1
340874	54.197.6	0	488797	4	1119	Album	184	18	Wiener Werkstätte\|Unknown Designers		46839				early 20th Century	1900	1925	165	Greatest: H. 4-1/2, W. 7 inches (11.4 x 17.8 cm.)	Rogers Fund, 1954	239	http://www.metmuseum.org/art/collection/search/488797	4/23/2018 8:00:01 AM	1
340875	54.197.7	0	488798	4	1119	Album	184	18	Wiener Werkstätte\|Unknown Designers		46839				early 20th Century	1900	1925	2294	Each: H. 5, W. 6-1/4 inches (12.7 x 15.9 cm.)	Rogers Fund, 1954	239	http://www.metmuseum.org/art/collection/search/488798	4/23/2018 8:00:01 AM	1
340876	54.197.8	0	488799	4	1119	Album	184	18	Wiener Werkstätte\|Unknown Designers		46839				early 20th Century	1900	1925	2631	H. 4-5/8, W. 6 inches (11.7 x 15.2 cm.)	Rogers Fund, 1954	239	http://www.metmuseum.org/art/collection/search/488799	4/23/2018 8:00:01 AM	1