MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 20 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
347209 89.4.1301 0 1 501867 18 16127 Tenor Slide Trombone in B-flat 13         1   José Ramis Spanish, Madrid, active 1843–51   47797   1800 1900 early 19th century 1801 1825 12 Length 42-15/16 in. (109 cm), Diam. of bell mouth opens 6-11/16 in. (17 cm.), Diam. of bore 0.495 in. (12.57 mm) The Crosby Brown Collection of Musical Instruments, 1889   467     5             931   1
350060 89.4.2511 0 0 504906 18 64 Bell 13         1   Juan Perez     48343       1773 1773 1773 772 H.: 62 cm (24-1/2 in.); Diam. 55 cm (21-3/4 in.) Gift of Mrs. Thomas J. Owen, 1884   2291     5             945   1
12699 Inst.63.7.16a–c 0 1 13844 1 1070 Piece 62         1   Charles E. Barber 1840–1917   2030   1840 1917 1700–1800 1700 1800 2130 115 3/4 x 23 1/4 in. (294 x 59.1 cm) Gift of Harcourt Amory, 1963 2       5             16   1
348994 2004.38 0 0 503719 18 15942 Tabor Pipe 13         1   Pau Reols Spanish, late 20th century   48075   1950 2050 2002–3 2002 2003 6120 L. 2.5 cm (1 in.) x Diam. 24.3 cm (9 9/16 in.) Purchase, Amati Gifts and funds from various donors, 2004       129 5             965   1
308474 85.13.1 0 1 443165 9 4586 Architectural Model Based on the Alhambra           1   Rafael Contreras   , Spain 44045       19th century (?) 1800 1899 44731 H. 15 1/2 in. (39.4 cm) W. 8 1/2 in. (21.6 cm) Gift of Richard M. Hunt, 1885 1       5             227   1
308478 86.15.1 0 1 443169 9 13996 Architectural Model Based on the Alhambra           1   Rafael Contreras   , Spain 44045       19th century (?) 1800 1899 44735 H. 9 1/4 in. (23.5 cm) W. 14 1/2 in. (36.8 cm) Gift of Richard M. Hunt, 1886 1       5             227   1
308479 86.15.2 0 1 443170 9 13996 Architectural Model Based on the Alhambra           1   Rafael Contreras   , Spain 44045       19th century (?) 1800 1899 44735 H. 16 1/2 in. (41.9 cm) W. 11 5/8 in. (29.5 cm) D. 1 1/8 in. (2.9 cm) Gift of Richard M. Hunt, 1886 1       5             227   1
308480 86.15.3 0 1 443171 9 13996 Architectural Model based on the Alhambra           1   Rafael Contreras   , Spain 44045       19th century (?) 1800 1899 44736 H. 14 1/2 in. (36.8 cm) W. 13 in. (33 cm) Gift of Richard M. Hunt, 1886 1       5             227   1
347819 89.4.1916 0 0 502496 18 16347 Bandurria 13         1   Hermanos, Sentchordi Spanish, Valencia active ca. 1861–1905 Valencia   47848 76 1861 1905 19th century 1801 1900 54582 L. 1 ft. 9 in., W. 10-1/2 in. The Crosby Brown Collection of Musical Instruments, 1889   1185     5             921   1
348576 1986.353.2 1 1 503283 18 15412 Guitar 13         1 Workshop of Manuel Ramírez Spanish, Alhama de Aragon, 1864–1916   47920 76 1864 1916 1912 1901 1925 54814 Height (Total): 38 in. (96.5 cm) Width (At lower bouts): 10 9/16 in. (26.9 cm) Gift of Emilita Segovia, Marquessa of Salobreña, 1986   467     5             921   1
348682 1990.220 0 1 503390 18 15412 Guitar 13         1   José Massague Spanish, Barcelona 1690–1764 Barcelona   47952 76 1690 1764 ca. 1755–60 1745 1770 54848   Purchase, Clara Mertens Bequest, in memory of André Mertens, 1990   613     5             921   1
348683 1990.221 0 1 503391 18 15412 Guitar 13         1   Benito Sanchez de Aguilera Spanish, Madrid, active 1790–1800   47953 76 1790 1800 1797 1797 1797 54849   Purchase, Clara Mertens Bequest, in memory of André Mertens, 1990   467     5             921   1
348714 1992.1.2 0 1 503430 18 15412 Guitar 13         1   Joseph Benedid Cadiz, 1760–1836   47972 76 1760 1836 1787 1787 1787 54859   Purchase, Clara Mertens Bequest, in memory of André Mertens, 1992   2291     5             921   1
348716 1992.46a, b 0 1 503432 18 15412 Guitar 13         1   Pedro Fuentes Spanish, Zaragoza active ca. 1860s   47973 76 1860 1870 before 1858 1800 1858 54861   Purchase, Clara Mertens Bequest, in memory of André Mertens, 1992   2292     5             921   1
348723 1992.279 1 1 503440 18 15412 Guitar 13         1 Attributed to Joseph de Frías Spanish, active Seville and Cadiz, ca. 1775–1800   47977 76     ca. 1780 1760 1800 54865 Height: 37 5/16 in. (94.7 cm) Width (of lower bouts): 11 in. (27.9 cm) Depth (at tail): 4 3/4 in. (12.1 cm) Purchase, Clara Mertens Bequest, in memory of André Mertens, 1992   577     5             921   1
348996 2004.40a–g 0 0 503721 18 16773 Sac de Gemecs 13         1   Jordy Aixala     48076       2002–3 2002 2003 55006 W. 78.7 cm (31 in.) x D. 7.6 cm (3 in.) x L. 139.7 cm (55 in.) Purchase, Murtogh D. Guinness Bequest, 2004       129 5             924   1
349661 2005.421a–c 0 0 504450 18 15873 Castanets 13         1   José Tárrega Peiró founded 1890   48277   1890   late 20th century 1990 1999 55213 Each castanet about L. 9.6 x 7.3 cm (3 3/4 x 2 7/8 in); Box: 20.3 x 14.2 x 5.8 cm (8 x 5 3/4 x 2 3/4 in) Gift of Lucero Tena, 2005         5             929   1
351091 2010.420 0 0 506729 18 15412 Guitar 13         1   Ignacio Fleta Spanish, Huesca, Spain 1897–1977 Barcelona   48473 76 1897 1977 1953 1953 1953 55586 Height: 38 7/16 in. (97.7 cm) Width (Lower bouts): 14 9/16 in. (37 cm) Depth (At tail): 3 7/8 in. (9.8 cm) Partial and Promised Gift of The Jonathan & Faye Kellerman Foundation, 2010   613     5             921   1
351096 2010.502 0 0 506777 18 15412 Guitar 13         1 Workshop of José Ramirez III Spanish, Madrid 1922–1995   48474   1922-05 1995 1967 1967 1967 55589 Height: 39 3/4 in. (100.9 cm) Width: 14 5/8 in. (37.1 cm) Depth: 4 1/8 in. (10.4 cm) Gift of Michal and Ilse McClure, in honor of Christopher Parkening, classical guitarist, and David Thomas, recording producer, 2010   467     5             921   1
444672 2016.787a, b 0 1 742642 18 16936 Flamenco Guitar 13         1   Santos Hernández Spanish, 1874–1943   56609   1874 1943 1924 1924 1924 62184 19 1/16 × 14 3/8 × 3 3/4 in. (48.4 × 36.5 × 9.5 cm) Gift of Steve Kahn, 2016   467     5             921   1
Powered by Datasette · Query took 25.365ms · Data license: CC0 · Data source: metmuseum/openaccess