MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 7 rows (hide)

Query parameters

rowidObject NumberIs HighlightIs Public DomainObject IDDepartmentObject NameTitleCulturePeriodDynastyReignPortfolioArtist RoleArtist PrefixArtist Display NameArtist Display BioArtist SuffixArtist Alpha SortArtist NationalityArtist Begin DateArtist End DateObject DateObject Begin DateObject End DateMediumDimensionsCredit LineGeography TypeCityStateCountyCountryRegionSubregionLocaleLocusExcavationRiverClassificationRights and ReproductionLink ResourceRepository
348744 1995.260 0 0 503461 18 15964 Clarinet in B-flat 7         1   Buffet, Crampon & Cie. founded 1859 (mouthpiece) 47986 2 1859 9999 ca. 1985 1980 1990 20370 Height (With mouthpiece): 26 3/8 in. (67 cm) Gift of William J. Maynard, 1995   27     9             953   1
348771 1997.219.14 0 0 503488 18 16128 Clarinet in E-flat 7         1   Buffet, Crampon & Cie. founded 1859   47986 2 1859 9999 mid to late 19th century 1833 1900 54090 L. 49.3 cm (19-1/2 in.) Gift of William J. Maynard, 1997   27     9             953   1
348797 1998.457 0 0 503514 18 15964 Clarinet in B-flat 7         1   Buffet, Crampon & Cie. founded 1859 (mouthpiece) 47986 2 1859 9999 ca. 1960 1950 1970 54902 Height: 26 3/16 in. (66.5 cm) Gift of William F. Hyland, in memory of Theodore and Margaret Hyland, his parents, 1998   27     9             953   1
348831 2002.343 0 1 503549 18 16696 Clarinet in A 7         1   Buffet, Crampon & Cie. founded 1859   47986 2 1859 9999 1860–65 1860 1865 54922 L. 70.3 cm (27-11/16 in.) Purchase, Robert Alonzo Lehman Bequest, 2002   27     9             953   1
349269 1996.284 0 0 504044 18 15964 Clarinet in B-flat 7         1   Buffet, Crampon & Cie. founded 1859 (mouthpiece) 47986 2 1859 9999 1924 1924 1924 54911 L. 62.9 cm (24 3/4 in.) without mouthpiece Gift of Norman D. Newell, 1996   27     9             953   1
350073 89.4.2534 0 0 504927 18 16842 Alto Clarinet in E-flat 7         1   Buffet, Crampon & Cie. founded 1859   47986 2 1859 9999 ca. 1825–89 1825 1889 54788 Overall: 9.9 x 87.7cm (3 7/8 x 34 1/2in.) The Crosby Brown Collection of Musical Instruments, 1889   27     9             953   1
350548 89.4.3130 0 0 505500 18 17398 Alto Sarrusophone in E-flat 7         1   Buffet, Crampon & Cie. founded 1859   47986 2 1859 9999 after 1885 1885 1910 55469 Overall: 6.5 x 61cm (2 9/16 x 24in.) The Crosby Brown Collection of Musical Instruments, 1889   27     9             911   1
Powered by Datasette · Query took 8.604ms · Data license: CC0 · Data source: metmuseum/openaccess