Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, 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, Credit Line, City, County, Country, Classification
Link | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
348690 | 348690 | 1991.15 | 0 | 1 | 503399 | Musical Instruments 18 | Trumpet in E-flat 16646 | Trumpet in E-flat | British 6 | Maker 1 | Henry Keat & Sons | Henry Keat & Sons 47960 | 1894 | 1894 | 1894 | Silver 2 | Height (Without mouthpiece): 25 5/8 in. (65.1 cm) Diameter (Of bell): 4 3/8 in. (11.1 cm) | Purchase, Clara Mertens Bequest, in memory of André Mertens, and The Barrington Foundation Inc., Laura Benedek and Mrs. Kay Krechmer Gifts, 1991 | London 14 | England 865 | United Kingdom 720 | Aerophone-Lip Vibrated-trumpet / trombone 931 | http://www.metmuseum.org/art/collection/search/503399 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
349072 | 349072 | 2004.269a–e | 0 | 1 | 503810 | Musical Instruments 18 | Keyed Bugle 16806 | Keyed Bugle | American 1 | Maker 1 | Elbridge G. Wright | Ashby, Massachusetts 1811–1871 Boston, Massachusetts | Wright Elbridge G. 48029 | American 1 | 1839 | 1871 | 1854 | 1854 | 1854 | Silver 2 | Length (Overall, without tuning slide): 13 1/8 in. (33.4 cm) Diameter (Of bell): 4 1/2 in. (11.4 cm) | Purchase, Robert Alonzo Lehman Bequest, 2004 | Boston 8 | Massachusetts 169 | United States 3 | Aerophone-Lip Vibrated 1012 | http://www.metmuseum.org/art/collection/search/503810 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
349196 | 349196 | 54.32.1 | 0 | 1 | 503968 | Musical Instruments 18 | Natural Trumpet 16872 | Natural Trumpet | German 27 | Maker 1 | Johann Wilhelm Haas | German, Nuremberg 1649–1723 Nuremberg | Haas Johann Wilhelm 48150 | German 10 | 1649 | 1723 | ca. 1700 | 1690 | 1710 | Silver 2 | Height: 28 in. (71.1 cm) Diameter (Of bell): 4 /58 in. (11.7 cm) | Funds from various donors, 1954 | Nürnberg 1065 | Germany 16 | Aerophone-Lip Vibrated 1012 | http://www.metmuseum.org/art/collection/search/503968 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
349215 | 349215 | 2000.67 | 0 | 1 | 503988 | Musical Instruments 18 | Transverse Flute 15633 | Transverse Flute | French 7 | Maker 1 | Clair Godfroy aine | Clair Godfroy aine 48155 | French 2 | ca. 1855 | 1850 | 1869 | Silver 2 | L. 26-5/6 in. (68.2 cm) | Purchase, Robert Alonzo Lehman Bequest, 2000 | Paris 27 | France 9 | Aerophone-Blow Hole-side-blown flute (transverse) 941 | http://www.metmuseum.org/art/collection/search/503988 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
349300 | 349300 | 1991.349.1 | 0 | 0 | 504076 | Musical Instruments 18 | Flute 5809 | Flute | French 7 | Maker 1 | Louis Lot | French, La Couture 1807–1896 Chatou | Lot Louis 48165 | French 2 | 1807 | 1896 | late 19th–early 20th century | 1875 | 1925 | Silver 2 | 673mm/598mm | Gift of Robert Alonzo Lehman, 1991 | Paris 27 | France 9 | Aerophone-Blow Hole-side-blown flute (transverse) 941 | http://www.metmuseum.org/art/collection/search/504076 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
349302 | 349302 | 1991.349.3 | 0 | 0 | 504078 | Musical Instruments 18 | Flute 5809 | Flute | American 1 | Maker 1 | William S. Haynes Co. | Haynes Co. William S. 48174 | 1929 | 1900 | 1940 | Silver 2 | 671mm/600mm | Gift of Robert Alonzo Lehman, 1991 | Boston 8 | Massachusetts 169 | Aerophone-Blow Hole-side-blown flute (transverse) 941 | http://www.metmuseum.org/art/collection/search/504078 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
349366 | 349366 | 1991.349.70 | 0 | 0 | 504143 | Musical Instruments 18 | Miniature fox or coach horn 16924 | Miniature fox or coach horn | British 6 | ca. 1875-1900 | 1870 | 1880 | Silver 2 | 12 1/8 × 1 3/8 × 1 3/8 in. (30.8 × 3.5 × 3.5 cm) | Gift of Robert Alonzo Lehman, 1991 | England 4 | Aerophone-Lip Vibrated-horn 912 | http://www.metmuseum.org/art/collection/search/504143 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||
349367 | 349367 | 1991.349.71 | 0 | 0 | 504144 | Musical Instruments 18 | Coach or Post Horn 16925 | Miniature fox or coach horn | Maker 1 | Tiffany & Co. | 1837–present | Tiffany & Co. 193 | 1837 | 9999 | 19th century (?) | 1800 | 1899 | Silver 2 | 11 13/16 × 1 5/16 × 1 5/16 in. (30 × 3.3 × 3.3 cm) | Gift of Robert Alonzo Lehman, 1991 | New York 3 | New York 126 | United States 3 | Aerophone-Lip Vibrated 1012 | http://www.metmuseum.org/art/collection/search/504144 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
349432 | 349432 | 1985.190 | 0 | 0 | 504211 | Musical Instruments 18 | Transverse Flute 15633 | Transverse Flute | American 1 | Manufacturer 20 | Theodore Berteling & Co. | Theodore Berteling & Co. 48185 | ca. 1890 | 1850 | 1900 | Silver 2 | Total length: 71 cm Embouchure length: 62.5 cm | Purchase, Gift of George Barrie, by exchange, Lowell S. Smith and Sally Sanford Gift, Mrs. Harold H. Krechmer Gift, in memory of her husband, and funds from various donors, 1985 | New York 3 | New York 126 | United States 3 | Aerophone-Blow Hole-panpipe 944 | http://www.metmuseum.org/art/collection/search/504211 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
349495 | 349495 | 1971.265a–c | 0 | 0 | 504282 | Musical Instruments 18 | Transverse Flute in C 15985 | Transverse Flute in C | French 7 | Maker 1 | Louis Lot | French, La Couture 1807–1896 Chatou | Lot Louis 48165 | French 2 | 1807 | 1896 | after 1860 | 1860 | 1880 | Silver 2 | Length: 67.8 cm. (26 11/16 in) Embouchure L: 60.1 cm (23 ¾ in.) | Gift of Janos Scholz, 1971 | France 9 | Aerophone-Blow Hole-side-blown flute (transverse) 941 | http://www.metmuseum.org/art/collection/search/504282 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
350211 | 350211 | 23.153a, b | 0 | 1 | 505093 | Musical Instruments 18 | Flute 5809 | Flute | American 1 | Maker 1 | Alfred G. Badger | American, Connecticut 1814/15–1892 Brooklyn, New York | Badger, Alfred G. 48188 | American 1 | 1815 | 1892 | 1860–65 | 1860 | 1868 | Silver 2 | L.: 72.6 cm (28-5/8 in.); Embouchure L.: 63.2 cm (24-7/8 in.) | Gift of Dr. W. P. Northrup, 1923 | New York 3 | New York 126 | United States 3 | Aerophone-Blow Hole-side-blown flute (transverse) 941 | http://www.metmuseum.org/art/collection/search/505093 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
351119 | 351119 | 2012.571.1 | 0 | 0 | 506851 | Musical Instruments 18 | Clarinet in A 15962 | Clarinet in A | American 1 | Maker 1 | William S. Haynes Co. | Haynes Co. William S. 48174 | 1930 | 1925 | 1935 | Silver 2 | L. 25 in. (63.5 cm) | Purchase, Robert Alonzo Lehman Bequest, 2012 | Boston 8 | Massachusetts 169 | United States 3 | Aerophone-Reed Vibrated-single reed cylindrical 953 | http://www.metmuseum.org/art/collection/search/506851 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
351120 | 351120 | 2012.571.2, .3 | 0 | 0 | 506852 | Musical Instruments 18 | Clarinet in B-flat 15964 | Clarinet in B-flat | American 1 | Maker 1 | William S. Haynes Co. | Haynes Co. William S. 48174 | 1930 | 1925 | 1935 | Silver 2 | Height: 22 in. (55.9 cm) | Purchase, Robert Alonzo Lehman Bequest, 2012 | Boston 8 | United States 3 | Aerophone-Reed Vibrated-single reed cylindrical 953 | http://www.metmuseum.org/art/collection/search/506852 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
433208 | 433208 | 2016.502a–g | 0 | 0 | 719644 | Musical Instruments 18 | Keyed bugle in E-flat 27117 | Keyed bugle in E-flat | American 1 | Maker 1 | Henry Sibley | American | Sibley, Henry 55227 | 1840 | 1840 | 1840 | Silver 2 | 6 3/4 × 4 1/2 × 17 7/16 in. (17.1 × 11.4 × 44.3 cm) | Purchase, Amati Gifts, 2016 | Boston 8 | Massachusetts 169 | United States 3 | Aerophone-Lip Vibrated-horn 912 | http://www.metmuseum.org/art/collection/search/719644 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
CREATE TABLE "MetObjects" ( "Object Number" TEXT, "Is Highlight" INTEGER, "Is Public Domain" INTEGER, "Object ID" INTEGER, "Department" INTEGER, "Object Name" INTEGER, "Title" TEXT, "Culture" INTEGER, "Period" REAL, "Dynasty" INTEGER, "Reign" INTEGER, "Portfolio" INTEGER, "Artist Role" INTEGER, "Artist Prefix" REAL, "Artist Display Name" TEXT, "Artist Display Bio" TEXT, "Artist Suffix" REAL, "Artist Alpha Sort" INTEGER, "Artist Nationality" INTEGER, "Artist Begin Date" TEXT, "Artist End Date" TEXT, "Object Date" TEXT, "Object Begin Date" INTEGER, "Object End Date" INTEGER, "Medium" INTEGER, "Dimensions" TEXT, "Credit Line" TEXT, "Geography Type" INTEGER, "City" INTEGER, "State" INTEGER, "County" INTEGER, "Country" INTEGER, "Region" INTEGER, "Subregion" INTEGER, "Locale" INTEGER, "Locus" INTEGER, "Excavation" INTEGER, "River" INTEGER, "Classification" INTEGER, "Rights and Reproduction" REAL, "Link Resource" TEXT, "Metadata Date" TEXT, "Repository" INTEGER , FOREIGN KEY ("Department") REFERENCES [Department](id), FOREIGN KEY ("Object Name") REFERENCES [Object Name](id), FOREIGN KEY ("Culture") REFERENCES [Culture](id), FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id), FOREIGN KEY ("Reign") REFERENCES [Reign](id), FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id), FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id), FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id), FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id), FOREIGN KEY ("Medium") REFERENCES [Medium](id), FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id), FOREIGN KEY ("City") REFERENCES [City](id), FOREIGN KEY ("State") REFERENCES [State](id), FOREIGN KEY ("County") REFERENCES [County](id), FOREIGN KEY ("Country") REFERENCES [Country](id), FOREIGN KEY ("Region") REFERENCES [Region](id), FOREIGN KEY ("Subregion") REFERENCES [Subregion](id), FOREIGN KEY ("Locale") REFERENCES [Locale](id), FOREIGN KEY ("Locus") REFERENCES [Locus](id), FOREIGN KEY ("Excavation") REFERENCES [Excavation](id), FOREIGN KEY ("River") REFERENCES [River](id), FOREIGN KEY ("Classification") REFERENCES [Classification](id), FOREIGN KEY ("Repository") REFERENCES [Repository](id)); CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department"); CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name"); CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture"); CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty"); CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign"); CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio"); CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role"); CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort"); CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality"); CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium"); CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type"); CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City"); CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State"); CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County"); CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country"); CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region"); CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion"); CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale"); CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus"); CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation"); CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River"); CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification"); CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository"); CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight"); CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain"); CREATE INDEX metobjects_Department ON MetObjects("Department"); CREATE INDEX metobjects_Culture ON MetObjects("Culture"); CREATE INDEX metobjects_Period ON MetObjects("Period"); CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty"); CREATE INDEX metobjects_Medium ON MetObjects("Medium"); CREATE INDEX metobjects_City ON MetObjects("City"); CREATE INDEX metobjects_State ON MetObjects("State"); CREATE INDEX metobjects_County ON MetObjects("County"); CREATE INDEX metobjects_Country ON MetObjects("Country"); CREATE INDEX metobjects_Region ON MetObjects("Region"); CREATE INDEX metobjects_Subregion ON MetObjects("Subregion"); CREATE INDEX metobjects_Locale ON MetObjects("Locale"); CREATE INDEX metobjects_Locus ON MetObjects("Locus"); CREATE INDEX metobjects_Excavation ON MetObjects("Excavation"); CREATE INDEX metobjects_River ON MetObjects("River");