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
347024 89.4.1092 0 1 501670 18 16043 Bass Saxhorn or Euphonium in B-flat 7         1   Gautrot     47756       1845–84 1845 1884 17229 L. 605 mm.; Diam. of bell 230 mm. The Crosby Brown Collection of Musical Instruments, 1889   27     9             912   1
347039 89.4.1109 0 1 501685 18 16056 Bass saxtuba in E-flat 7         1   Adolphe (Antoine Joseph) Sax Belgian, Dinant, Belgium 1814–1894 Paris   47764 3497 1814-11-06 1894-02-07 1855 1855 1855 17229 51 × 36 1/2 × 12 1/2 in. (129.5 × 92.7 × 31.8 cm) The Crosby Brown Collection of Musical Instruments, 1889   27     9             912   1
347070 89.4.1142 0 1 501717 18 16076 Signal Horn in B 7                           early 19th century 1801 1825 17229 Length ca. 593 mm, Diam. of bell 157 mm. The Crosby Brown Collection of Musical Instruments, 1889         9             912   1
347263 89.4.1355 0 0 501921 18 16048 Trumpet in G 7                           19th century 1801 1900 17229 L. (w/o m.p.): 38-3/8 in. (97.5 cm), Diam. of bell; 5-5/8 in. (14.3 cm) The Crosby Brown Collection of Musical Instruments, 1889         9             931   1
347686 89.4.2150 0 1 502359 18 16303 Soprano Sarrusophone in B-flat 7         1   Gautrot-Marquet French, Paris 1875–1884   47835 2 1875 1884 late 19th century 1867 1900 17229 L. w/o reed 26.25 in.; Diam. of bell 2.25 in.; Diam. of bore inside crook tenon .200 in.; Diam. of bore - small end of crook .127 in. The Crosby Brown Collection of Musical Instruments, 1889   27     9             911   1
Powered by Datasette · Query took 12.221ms · Data license: CC0 · Data source: metmuseum/openaccess