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 "Department" = :p0 and "Medium" = :p1 order by Dynasty limit 101

Query parameters

This data as json, CSV

rowid	Object Number	Is Highlight	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	City	County	Country	Classification	Link Resource	Metadata Date	Repository
345914	X.308	0	0	500534	18	6840	Horn									19th century	1801	1900	148	L. 13 1/4 in.	Museum Accession				912	http://www.metmuseum.org/art/collection/search/500534	4/23/2018 8:00:01 AM	1
346444	89.4.457	0	1	501075	18	6840	Horn	6229								late 19th century	1850	1900	148	L. 29.8 cm (11-3/4 in.)	The Crosby Brown Collection of Musical Instruments, 1889		888	95	912	http://www.metmuseum.org/art/collection/search/501075	4/23/2018 8:00:01 AM	1
346448	89.4.462	0	1	501080	18	6840	Horn	6233								ca. 1874	1850	1899	148	L. 52 cm (20 1/2 in.); Ovoid at wider end H. 8 cm (3 3/16in) x 6.5 cm (2 9/16in)	The Crosby Brown Collection of Musical Instruments, 1889		889	77	912	http://www.metmuseum.org/art/collection/search/501080	4/23/2018 8:00:01 AM	1
346449	89.4.463	0	1	501081	18	6840	Horn	6234								late 19th century	1850	1900	148	Height: 21 5/8 in. (54.9 cm) Diameter: 2 1/16 in. (5.2 cm)	The Crosby Brown Collection of Musical Instruments, 1889			83	912	http://www.metmuseum.org/art/collection/search/501081	4/23/2018 8:00:01 AM	1
346450	89.4.464	0	1	501082	18	6840	Horn	6234								late 19th century	1850	1900	148	L. 65 x diam. 5.3 cm (25 5/8 x 2 1/8 in)	The Crosby Brown Collection of Musical Instruments, 1889			83	912	http://www.metmuseum.org/art/collection/search/501082	4/23/2018 8:00:01 AM	1
346455	89.4.469	0	1	501087	18	6840	Horn									late 19th century	1850	1900	148	L. 16.5 x Diam.162.6 cm (6 1/2 x 64in.)	The Crosby Brown Collection of Musical Instruments, 1889				912	http://www.metmuseum.org/art/collection/search/501087	4/23/2018 8:00:01 AM	1
346882	89.4.908	0	1	501519	18	15972	Alto Recorder in F	27								18th century	1701	1800	148	L. 19-3/32 in. (492 mm.)	The Crosby Brown Collection of Musical Instruments, 1889			16	965	http://www.metmuseum.org/art/collection/search/501519	4/23/2018 8:00:01 AM	1
346883	89.4.909	1	1	501520	18	15972	Alto Recorder in F	27	1	Johann Benedikt Gahn	German, Nuremberg 1674–1711 Nuremberg	47717	10	1674	1711	ca. 1700	1680	1720	148	Height: 19 1/8 in. (48.6 cm)	The Crosby Brown Collection of Musical Instruments, 1889	1065		16	965	http://www.metmuseum.org/art/collection/search/501520	4/23/2018 8:00:01 AM	1
347361	89.4.1570	0	0	502025	18	16182	Pi Chawa	606								late 19th century	1850	1900	148	8 in. (20.3 cm)	The Crosby Brown Collection of Musical Instruments, 1889			734	911	http://www.metmuseum.org/art/collection/search/502025	4/23/2018 8:00:01 AM	1
347394	89.4.1485	0	1	502060	18	16072	Hunting Horn	470								ca. 1700	1680	1720	148	Length of tube 368 mm, Diam. of bell 48 mm.	The Crosby Brown Collection of Musical Instruments, 1889			518	912	http://www.metmuseum.org/art/collection/search/502060	4/23/2018 8:00:01 AM	1
347539	89.4.1645	0	1	502208	18	16248	Falconer's Horn	3480								18th century	1701	1800	148	Height: 11 15/16 in. (30.3 cm) Diameter (Of bell): 1 5/16 in. (3.3 cm)	The Crosby Brown Collection of Musical Instruments, 1889			679	912	http://www.metmuseum.org/art/collection/search/502208	4/23/2018 8:00:01 AM	1
347626	89.4.1752	0	0	502299	18	6840	Horn	372								late 19th century	1850	1900	148	Length: 12 in. (30.5 cm) Diameter: 3 in. (7.6 cm)	The Crosby Brown Collection of Musical Instruments, 1889			733	912	http://www.metmuseum.org/art/collection/search/502299	4/23/2018 8:00:01 AM	1
347749	89.4.1825	0	0	502424	18	6840	Horn	6193								late 19th Century	1875	1899	148	L. 38.7 x Diam. narrow end ± 1.4 x Oval wide end 4.8 x 5.5 cm (15 1/4 x ±5/8; oval wide end 1 17/16 x 2 1/4 in.)	The Crosby Brown Collection of Musical Instruments, 1889			93	912	http://www.metmuseum.org/art/collection/search/502424	4/23/2018 8:00:01 AM	1
348802	1999.74	1	0	503519	18	16685	Side-blown Trumpet	6598								19th century	1801	1900	148	L. 50 × Diam. Largest 4 3/4 - smallest 1 1/2 in. (127 × 12.1 - 3.8 cm)	Purchase, Bequest of Olive Huber, by exchange, and Brian and Anne Marie Todes Gift, 1999			93	931	http://www.metmuseum.org/art/collection/search/503519	4/23/2018 8:00:01 AM	1
348968	13.139.3	0	0	503691	18	6840	Horn	6193								late 19th century	1875	1899	148	L. 68.6 cm (27 in.)	Gift of Mrs. John Crosby Brown, 1913			887	912	http://www.metmuseum.org/art/collection/search/503691	4/23/2018 8:00:01 AM	1
349181	07.103	0	0	503948	18	14254	Oliphant	27	1	Wilhelm Leberecht Schulz		48143				ca. 1840	1800	1899	148	L. of tube: ca. 164 cm (64-1/4 in.) (w/o mouthpiece); Diam. of bell (widest): 10.8 cm (4-1/4 in.)	The Crosby Brown Collection of Musical Instruments, 1889	2315		16	912	http://www.metmuseum.org/art/collection/search/503948	4/23/2018 8:00:01 AM	1
349922	89.4.2399	0	0	504757	18	17132	Whistle and Writing Pen	141								early 19th century	1800	1825	148	L.: 12.9 cm (5-1/8 in.)	The Crosby Brown Collection of Musical Instruments, 1889			797	1015	http://www.metmuseum.org/art/collection/search/504757	4/23/2018 8:00:01 AM	1
350091	06.194	0	1	504949	18	17203	Flageolet in G	2316	1	De Haze?		48350				17th century	1600	1699	148	L.: 11.4 cm (4-1/2 in.)	Gift of William Loring Andrews, 1906			935	956	http://www.metmuseum.org/art/collection/search/504949	4/23/2018 8:00:01 AM	1
350293	89.4.2701	0	1	505183	18	17288	Racket (reproduction)	27	1	Karl Hermann Voigt	1850–1925	48371		1850	1925	late 19th–early 20th century	1870	1905	148		The Crosby Brown Collection of Musical Instruments, 1889			952	911	http://www.metmuseum.org/art/collection/search/505183	4/23/2018 8:00:01 AM	1
350311	89.4.2730	0	0	505205	18	6840	Horn	6193								19th century	1801	1900	148	L. 88.8 x Diam. 2.5 - ±97 (34 1/16 x diam. 1 x ±3 15/16 in)	The Crosby Brown Collection of Musical Instruments, 1889			953	912	http://www.metmuseum.org/art/collection/search/505205	4/23/2018 8:00:01 AM	1
350312	89.4.2731	0	0	505206	18	6840	Horn									mid 19th–19th century	1850	1899	148	L. 36 × Diam. at larger end 3 in. (91.4 × 7.6 cm)	The Crosby Brown Collection of Musical Instruments, 1889				1021	http://www.metmuseum.org/art/collection/search/505206	4/23/2018 8:00:01 AM	1
350627	89.4.2391a, b	0	1	505587	18	17416	Viol Bridge and Tail-Piece	36								17th century	1600	1699	148	L. 10.2 cm (4 in.)	The Crosby Brown Collection of Musical Instruments, 1889	571		14	1003	http://www.metmuseum.org/art/collection/search/505587	4/23/2018 8:00:01 AM	1
350732	89.4.3391	0	0	505713	18	6840	Horn	6756								19th century	1801	1900	148	L. 37 x Diam. 3 - ovoi H. 5.8 x W. ±4 cm (L. 14 9/16 x diam. 1 1/4 - ovoid H. 2 1/4 x W. ±1 1/2 in)	The Crosby Brown Collection of Musical Instruments, 1889				912	http://www.metmuseum.org/art/collection/search/505713	4/23/2018 8:00:01 AM	1
350819	89.4.3232	0	0	505836	18	17479	Piano model parts	12								late 19th–early 20th Century	1890	1904	148		The Crosby Brown Collection of Musical Instruments, 1889				1020	http://www.metmuseum.org/art/collection/search/505836	4/23/2018 8:00:01 AM	1
350820	89.4.3233	0	0	505837	18	17480	Ivory Tail	12								late 19th–early 20th Century	1890	1904	148		The Crosby Brown Collection of Musical Instruments, 1889				1020	http://www.metmuseum.org/art/collection/search/505837	4/23/2018 8:00:01 AM	1
350821	89.4.3234	0	0	505838	18	17481	Ivory ??	12								late 19th–early 20th Century	1890	1904	148		The Crosby Brown Collection of Musical Instruments, 1889				1020	http://www.metmuseum.org/art/collection/search/505838	4/23/2018 8:00:01 AM	1
350822	89.4.3235	0	0	505839	18	17479	Piano model parts	12								late 19th–early 20th Century	1890	1904	148		The Crosby Brown Collection of Musical Instruments, 1889				1020	http://www.metmuseum.org/art/collection/search/505839	4/23/2018 8:00:01 AM	1