MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 5 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
345938 89.2.165 0 1 500561 18 15411 Cornemuse 7         1   Joseph Bechonnet Effiat, Puy de Dome, 1820–1900   47636 2 1820 1900 1874 1874 1874 53952 Chanter with bell: 42.1 cm (16-1/2 in.), 3 drones: bass in 3 sections: 77.6 cm (30-5/8 in.), tenor in 2 sections: 317 cm (12-1/2 in.), treble in 2 sections: 75 cm (29-1/2 in.) Gift of Joseph W. Drexel, 1889   2117     9             924   1
346840 89.4.866 0 1 501477 18 15949 Cabrette 7         1   Joseph Bechonnet Effiat, Puy de Dome, 1820–1900 (?) 47636 2 1820 1900 19th century 1801 1900 54312   The Crosby Brown Collection of Musical Instruments, 1889   2117     9             924   1
347328 89.4.1422 0 0 501988 18 16171 Sopranino Clarinet in G 7         1   Charles Mathieu French, Paris before 1890–after 1900   47807 2 1890 1900 ca. 1890 1880 1900 54453 Length 420 mm, Bell diameter 45 mm The Crosby Brown Collection of Musical Instruments, 1889   27     9             953   1
347689 89.4.2166 0 0 502362 18 16297 Musette 7         2   Charles Mathieu French, Paris before 1890–after 1900   47807 2 1890 1900 ca. 1890 1880 1900 54530 L. 32 cm The Crosby Brown Collection of Musical Instruments, 1889   27     9             911   1
349984 89.4.2464 0 1 504827 18 17139 Tenor (Alto) Ophicleide in E-flat 7         1   Couturier French, Lyons active 1812–after 1900 Lyons   48331 2 1812 1900 ca. 1830–50 1830 1850 12 Overall: 16.7 x 92.3cm (6 9/16 x 36 5/16in.) The Crosby Brown Collection of Musical Instruments, 1889   312     9             912   1
Powered by Datasette · Query took 5.868ms · Data license: CC0 · Data source: metmuseum/openaccess