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, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, City, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
345938 | 345938 | 89.2.165 | 0 | 1 | 500561 | Musical Instruments 18 | Cornemuse 15411 | Cornemuse | French 7 | Maker 1 | Joseph Bechonnet | Effiat, Puy de Dome, 1820–1900 | Bechonnet, Joseph 47636 | French 2 | 1820 | 1900 | 1874 | 1874 | 1874 | Wood, ivory, sheep or cowhide, leather, velvet 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 | Effiat, Puy-de-Dôme 2117 | France 9 | Aerophone-Reed Vibrated-bagpipe 924 | http://www.metmuseum.org/art/collection/search/500561 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
346840 | 346840 | 89.4.866 | 0 | 1 | 501477 | Musical Instruments 18 | Cabrette 15949 | Cabrette | French 7 | Maker 1 | Joseph Bechonnet | Effiat, Puy de Dome, 1820–1900 | (?) | Bechonnet, Joseph 47636 | French 2 | 1820 | 1900 | 19th century | 1801 | 1900 | various materials 54312 | The Crosby Brown Collection of Musical Instruments, 1889 | Effiat, Puy-de-Dôme 2117 | France 9 | Aerophone-Reed Vibrated-bagpipe 924 | http://www.metmuseum.org/art/collection/search/501477 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
346898 | 346898 | 89.4.925 | 0 | 1 | 501535 | Musical Instruments 18 | Transverse Flute in C 15985 | Transverse Flute in C | British 6 | Maker|Maker 6 | Possibly by | Thomas Prowse|Clementi & Co. | British, active London, 1816–1868 | Prowse, Thomas|Clementi & Co. 47725 | British 7 | 1800 | 1900 | ca. 1825 | 1815 | 1835 | Ivory, silver, brass 6243 | L. 657 mm., Embouchure length 582 mm. | The Crosby Brown Collection of Musical Instruments, 1889 | London 14 | England 865 | United Kingdom 720 | Aerophone-Blow Hole-side-blown flute (transverse) 941 | http://www.metmuseum.org/art/collection/search/501535 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||
346912 | 346912 | 89.4.941a, b | 0 | 1 | 501551 | Musical Instruments 18 | Double Bass and Bow 15996 | Double Bass and Bow | French 7 | Maker 1 | Probably by | Charles Plumerel | French, mid-19th century | Plumerel, Charles 47728 | 1800 | 1900 | mid to late 18th century | 1733 | 1800 | wood, brass 17235 | 89.4.491 a: Body length: 1125/1120 cm (top/back) (442.9/440.9 in.); Upper bouts: 530/520 cm (208.66/204.72 in.): Center bouts: 357/348 cm (140.55/137.01in.); Lower bouts: 658/645 cm (259.1/253.9in.); Rib heights: 156/200/197 cm (upper/center/tail) (61.4/78.7/77.6 in.); Max. Ht. arching 256 cm (100.8 in.); String length 1070 cm (421.26 in.) | The Crosby Brown Collection of Musical Instruments, 1889 | Mirecourt 2179 | France 9 | Chordophone-Lute-bowed-unfretted 925 | http://www.metmuseum.org/art/collection/search/501551 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
347007 | 347007 | 89.4.1071 | 0 | 0 | 501652 | Musical Instruments 18 | Harp Lyre 16034 | Harp Lyre | French 7 | Maker 1 | J. F. Salomon | French, Paris, 19th century | Salomon, J. F. 47748 | 1800 | 1900 | 19th century | 1801 | 1900 | Wood, ebony, ivory, metal, mother of pearl 54364 | L. 3 ft. 4 in., W. of sound-board 1 ft. 4 in. | The Crosby Brown Collection of Musical Instruments, 1889 | France 9 | Chordophone 907 | http://www.metmuseum.org/art/collection/search/501652 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
347030 | 347030 | 89.4.1098 | 0 | 1 | 501676 | Musical Instruments 18 | Trumpet in G 16048 | Trumpet in G | German 27 | Maker 1 | Michael Saurle | German, active München, 1799–1872 | Saurle, Michael 47759 | 1775 | 1900 | 1829 | 1829 | 1829 | Brass 12 | L. without mouthpiece 51.4 cm., Diam. of bell 12.7 cm., Diam. of bore 0.387 in. within larger slide socket | The Crosby Brown Collection of Musical Instruments, 1889 | Munich 426 | Germany 16 | Aerophone-Lip Vibrated-trumpet / trombone 931 | http://www.metmuseum.org/art/collection/search/501676 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
347035 | 347035 | 89.4.1103 | 0 | 0 | 501681 | Musical Instruments 18 | Cavalry Trumpet in E-flat 16052 | Cavalry Trumpet in E-flat | German 27 | Maker 1 | Michael Saurle | German, active München, 1799–1872 | Saurle, Michael 47759 | 1775 | 1900 | after 1826 | 1826 | 1860 | Brass 12 | Length without mouthpiece 37.9 cm., Diam. of bell 10.8 cm., Diam. of bore 0.439 in. within receiver | The Crosby Brown Collection of Musical Instruments, 1889 | Munich 426 | Germany 16 | Aerophone-Lip Vibrated-trumpet / trombone 931 | http://www.metmuseum.org/art/collection/search/501681 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
347071 | 347071 | 89.4.1143 | 0 | 1 | 501718 | Musical Instruments 18 | Hunting Horn in D 16062 | Hunting Horn in D | French 7 | Maker 1 | Raoux Family | French, ca. 1695–1900 | Family | Raoux Family 47771 | 1680 | 1900 | after 1866 | 1866 | 1900 | Brass, leather, lead 54376 | Length ca. 452 mm, Diam. of bell 145 mm | The Crosby Brown Collection of Musical Instruments, 1889 | Paris 27 | France 9 | Aerophone-Lip Vibrated-horn 912 | http://www.metmuseum.org/art/collection/search/501718 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
347209 | 347209 | 89.4.1301 | 0 | 1 | 501867 | Musical Instruments 18 | Tenor Slide Trombone in B-flat 16127 | Tenor Slide Trombone in B-flat | Spanish 13 | Maker 1 | José Ramis | Spanish, Madrid, active 1843–51 | Ramis, José 47797 | 1800 | 1900 | early 19th century | 1801 | 1825 | Brass 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 | Madrid 467 | Spain 5 | Aerophone-Lip Vibrated-trumpet / trombone 931 | http://www.metmuseum.org/art/collection/search/501867 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
347328 | 347328 | 89.4.1422 | 0 | 0 | 501988 | Musical Instruments 18 | Sopranino Clarinet in G 16171 | Sopranino Clarinet in G | French 7 | Maker 1 | Charles Mathieu | French, Paris before 1890–after 1900 | Mathieu, Charles 47807 | French 2 | 1890 | 1900 | ca. 1890 | 1880 | 1900 | pewter, nickel-silver 54453 | Length 420 mm, Bell diameter 45 mm | The Crosby Brown Collection of Musical Instruments, 1889 | Paris 27 | France 9 | Aerophone-Reed Vibrated-single reed cylindrical 953 | http://www.metmuseum.org/art/collection/search/501988 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
347392 | 347392 | 89.4.1483 | 0 | 1 | 502058 | Musical Instruments 18 | Ichigen-kin 15495 | Ichigen-kin | Japanese 35 | Maker 1 | Kasuke Satake | Japanese, 19th century | Satake, Kasuke 47809 | 1800 | 1900 | 19th century | 1801 | 1900 | Wood, ivory, shell, coral, gut 54466 | 12 3/8 × 47 1/4 × 5 1/2 in. (31.5 × 120 × 14 cm) | The Crosby Brown Collection of Musical Instruments, 1889 | Kochi 2210 | Hachi district 936 | Japan 15 | Shikoku Island 590 | Chordophone-Zither-plucked-long zither 913 | http://www.metmuseum.org/art/collection/search/502058 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
347524 | 347524 | 89.4.1630 | 0 | 1 | 502193 | Musical Instruments 18 | Serpent in C 16125 | Serpent in C | German 27 | Maker 1 | W. Schmidt | German, active Mainz, early 19th century | Schmidt, W. 47820 | 1800 | 1900 | ca. 1805 | 1775 | 1805 | Wood, leather, brass 144 | Length 67.1 cm, Length of tube ca. 197 cm without mouthpipe, Diameter of bell: oval 13.5 cm x 10.5 cm, Diameter of bore: 0.540 in. at mouthpiece socket, 0.875 in. mouthpiece socket For complete measurements see departmental files. | The Crosby Brown Collection of Musical Instruments, 1889 | Mainz 1064 | Germany 16 | Aerophone-Lip Vibrated-horn 912 | http://www.metmuseum.org/art/collection/search/502193 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
347689 | 347689 | 89.4.2166 | 0 | 0 | 502362 | Musical Instruments 18 | Musette 16297 | Musette | French 7 | Artist 2 | Charles Mathieu | French, Paris before 1890–after 1900 | Mathieu, Charles 47807 | French 2 | 1890 | 1900 | ca. 1890 | 1880 | 1900 | pewter 54530 | L. 32 cm | The Crosby Brown Collection of Musical Instruments, 1889 | Paris 27 | France 9 | Aerophone-Reed Vibrated-double reed 911 | http://www.metmuseum.org/art/collection/search/502362 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
348731 | 348731 | 1993.292 | 0 | 1 | 503448 | Musical Instruments 18 | Grand Piano 16100 | Grand Piano | German 27 | Maker 1 | Carl Bechstein | Gotha 1826–1900 Berlin | Bechstein, Carl 47983 | German 10 | 1826 | 1900 | ca. 1893 | 1883 | 1903 | Wood, metal, various materials 53940 | L. 219.5 cm (86-1/2 in.); W. 153.8 cm (60-5/8 in.); H. 99.5 cm including lid (39 in.); D. of case 35.5 cm w/o lid (14 in.); 3-octave span 49.2 cm (19-3/8 in.) | Gift of Schonberger Family Foundation, 1993 | Berlin 120 | Germany 16 | Chordophone-Zither-struck-piano 928 | http://www.metmuseum.org/art/collection/search/503448 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
348746 | 348746 | 1995.369.2a–c | 0 | 0 | 503463 | Musical Instruments 18 | Clarinet in B-flat 15964 | Clarinet in B-flat | British 6 | Maker 1 | Thomas Prowse | British, active London, 1816–1868 | Prowse, Thomas 47988 | British 7 | 1800 | 1900 | 1832–68 | 1832 | 1868 | Boxwood, brass, ivory 54085 | Height: 23 1/16 in. (58.5 cm) | Purchase, Robert Alonzo Lehman Gift, 1995 | London 14 | England 865 | United Kingdom 720 | Aerophone-Reed Vibrated-single reed cylindrical 953 | http://www.metmuseum.org/art/collection/search/503463 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
348830 | 348830 | 2002.342 | 0 | 1 | 503548 | Musical Instruments 18 | Clarinet in B-flat 15964 | Clarinet in B-flat | French 7 | Maker 1 | Charles Roth | French, active Strasbourg ca. 1844–81 | Roth Charles 48026 | 1800 | 1900 | 1840–45 | 1840 | 1845 | Boxwood, ivory, ebony, nickel-silver 54921 | Height: 25 1/4 in. (64.1 cm) | Purchase, Robert Alonzo Lehman Bequest, 2002 | Strasbourg 481 | France 9 | Aerophone-Reed Vibrated-single reed cylindrical 953 | http://www.metmuseum.org/art/collection/search/503548 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
349067 | 349067 | 2004.200 | 0 | 1 | 503804 | Musical Instruments 18 | Valve Trumpet in B-flat 15917 | Valve Trumpet in B-flat | American 1 | Manufacturer 20 | David C. Hall | American, Lyme, New Hampshire 1822–1900 Boston | Hall D. C. 48101 | American 1 | 1822 | 1900 | 1862–65 | 1862 | 1865 | Brass 12 | 6 11/16 × 4 3/4 × 16 15/16 in. (17 × 12 × 43 cm) | Purchase, Robert Alonzo Lehman Bequest, 2004 | Boston 8 | Massachusetts 169 | United States 3 | Aerophone-Lip Vibrated-trumpet / trombone 931 | http://www.metmuseum.org/art/collection/search/503804 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
349108 | 349108 | 89.4.2144 | 0 | 1 | 503847 | Musical Instruments 18 | Tenor Valve Trombone in B-flat 16822 | Tenor Valve Trombone in B-flat | Italian 36 | Maker 1 | Pietro Borsari | active late 19th century | Borsari Pietro 48118 | Italian 6 | 1850 | 1900 | late 19th century | 1880 | 1899 | Brass, nickel-silver 54086 | Length: 95cm (37 3/8in.) Diameter of bell: 17cm (6 11/16in.) | The Crosby Brown Collection of Musical Instruments, 1889 | Bologna 661 | Italy 14 | Aerophone-Lip Vibrated-trumpet / trombone 931 | http://www.metmuseum.org/art/collection/search/503847 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
349120 | 349120 | 89.4.2145 | 0 | 1 | 503859 | Musical Instruments 18 | Tenor Valve Trombone in B-flat 16822 | Tenor Valve Trombone in B-flat | Italian 36 | Maker 1 | Pietro Borsari | active late 19th century | Borsari Pietro 48118 | Italian 6 | 1850 | 1900 | late 19th Century | 1850 | 1900 | Brass, nickel-silver 54086 | Length: 78cm (30 11/16in.) Diameter of bell: 17.2cm (6 3/4in.) | The Crosby Brown Collection of Musical Instruments, 1889 | Bologna 661 | Italy 14 | Aerophone-Lip Vibrated-trumpet / trombone 931 | http://www.metmuseum.org/art/collection/search/503859 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
349121 | 349121 | 89.4.2146 | 0 | 1 | 503860 | Musical Instruments 18 | Tenor Valve Trombone in B-flat 16822 | Tenor Valve Trombone in B-flat | Italian 36 | Maker 1 | Pietro Borsari | active late 19th century | Borsari Pietro 48118 | Italian 6 | 1850 | 1900 | ca. 1870 | 1865 | 1875 | brass, nickel-silver 55048 | 31 1/16 × 7 × 10 1/2 in. (78.8 × 17.8 × 26.7 cm) Diameter (Of bell): 7 3/4 in. (19.7 cm) | The Crosby Brown Collection of Musical Instruments, 1889 | Bologna 661 | Italy 14 | Aerophone-Lip Vibrated-trumpet / trombone 931 | http://www.metmuseum.org/art/collection/search/503860 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
349385 | 349385 | 89.4.2110 | 0 | 0 | 504162 | Musical Instruments 18 | Mandoline 15403 | Mandoline | Italian 36 | Maker 1 | Alberto Olmi | Italian, Siena, active 19th century | Olmi Alberto 48215 | Italian 6 | 1801 | 1900 | 19th century | 1850 | 1899 | Wood, mother of pearl, strings, ebony 55145 | Overall: W. 21.6 x L 55.9cm (8 1/2 x 22in.) | The Crosby Brown Collection of Musical Instruments, 1889 | Siena 421 | Italy 14 | Chordophone-Lute-plucked 960 | http://www.metmuseum.org/art/collection/search/504162 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
349402 | 349402 | 1987.97.1 | 0 | 1 | 504179 | Musical Instruments 18 | Flageolet 15592 | Flageolet | American 1 | Maker 1 | Frederick Riley | American, active New York, 1845–51 | Riley, Frederick 48221 | 1800 | 1900 | 1844–50 | 1830 | 1860 | Boxwood, ivory, brass 54090 | L. 49.7 cm Speaking L. 44.4 cm | Rogers Fund, 1987 | United States 3 | Aerophone-Whistle Flute-flageolet 956 | http://www.metmuseum.org/art/collection/search/504179 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
349720 | 349720 | 89.4.3124 | 0 | 0 | 504531 | Musical Instruments 18 | Bass Clarinet in B-flat 16953 | Bass Clarinet in B-flat | Italian 36 | Maker 1 | Giacinto Riva | Italian, active 1839–72 | Riva, Giacinto 48288 | Italian 6 | 1800 | 1900 | mid-19th century | 1838 | 1865 | boxwood, ebony, nickel-silver 55234 | L. end to end (excluding ring on butt end). 665 mm; Bell Diam. 135 mm.; Tube L. ca. 1037 mm; Mouthpiece: 92 mm; Crook. ca. 200 mm; Upper right (bassoon: 'wing' section) 238 mm; Butt section 270 mm; Upper left (bassoon: 'long' section) 282 mm; Bell 184 mm. | The Crosby Brown Collection of Musical Instruments, 1889 | Persiceto 2340 | Italy 14 | Aerophone-Reed Vibrated-single reed cylindrical 953 | http://www.metmuseum.org/art/collection/search/504531 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
349984 | 349984 | 89.4.2464 | 0 | 1 | 504827 | Musical Instruments 18 | Tenor (Alto) Ophicleide in E-flat 17139 | Tenor (Alto) Ophicleide in E-flat | French 7 | Maker 1 | Couturier | French, Lyons active 1812–after 1900 Lyons | Couturier 48331 | French 2 | 1812 | 1900 | ca. 1830–50 | 1830 | 1850 | Brass 12 | Overall: 16.7 x 92.3cm (6 9/16 x 36 5/16in.) | The Crosby Brown Collection of Musical Instruments, 1889 | Lyon 312 | France 9 | Aerophone-Lip Vibrated-horn 912 | http://www.metmuseum.org/art/collection/search/504827 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
350026 | 350026 | 89.4.2232 | 0 | 0 | 504872 | Musical Instruments 18 | Violin case 17171 | Violin case | Italian 36 | Maker 1 | Gaspar Otto Michele | Italian, active 19th century | Michele, Gaspar Otto 48337 | Italian 6 | 1801 | 1900 | 19th Century | 1800 | 1899 | Wood 25 | Overall: 26.7 x 10.2cm (10 1/2 x 4in.) | The Crosby Brown Collection of Musical Instruments, 1889 | Italy 14 | Accessory 256 | http://www.metmuseum.org/art/collection/search/504872 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
350050 | 350050 | 06.1309 | 0 | 1 | 504896 | Musical Instruments 18 | Kemençe 17184 | Kemençe | Turkish 68 | Maker 1 | probably | Baron Baronak | Armenian, 1834?–1900 | Baronak, Baron 48341 | Armenian 409 | 1834 | 1900 | 19th century | 1800 | 1899 | wood, pearl, tortoise shell 55312 | Diam. 14.3 x L. 39.4cm (5 5/8 x 15 1/2in.) | Gift of Miss Hewitt, 1906 | Turkey 61 | Chordophone-Lute-bowed-unfretted 925 | http://www.metmuseum.org/art/collection/search/504896 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
350149 | 350149 | 13.139.1 | 0 | 0 | 505013 | Musical Instruments 18 | Violon avec Clavier 17222 | Violon avec Clavier | French 7 | Maker 1 | Joseph Poussot | French, 19th century | Poussot, Joseph 48355 | 1800 | 1900 | ca. 1890 | 1880 | 1900 | Wood, various materials 53943 | Total L.: 144.8 cm (57 in.); Maximum W.: 30.3 cm (12 in.); Total H: 69.4 cm (27-3/8 in.); Keyboard span: 34 cm (13-3/8 in.) | The Crosby Brown Collection of Musical Instruments, 1889 | Meurthe-et-Moselle? 2354 | France 9 | Chordophone-Bowed keyboard 992 | http://www.metmuseum.org/art/collection/search/505013 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
350494 | 350494 | 89.4.2908 | 0 | 1 | 505416 | Musical Instruments 18 | Violon avec Clavier 17222 | Violon avec Clavier | French 7 | Maker 1 | Attributed to | Joseph Poussot | French, 19th century | Poussot, Joseph 48355 | 1800 | 1900 | ca. 1890 | 1885 | 1895 | Wood, various materials 53943 | Total Length 78.8cm | The Crosby Brown Collection of Musical Instruments, 1889 | France 9 | Chordophone-Bowed keyboard 992 | http://www.metmuseum.org/art/collection/search/505416 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
350554 | 350554 | 89.4.3145 | 0 | 0 | 505506 | Musical Instruments 18 | Tastengitarre (Keyed Guitar) 17401 | Tastengitarre (Keyed Guitar) | German 27 | Maker|Maker 6 | Franz Fiala|Matteo (Mathias) Sprenger | German, ca. 1800–1900|German | Fiala, Franz|Sprenger, Matteo (Mathias) 48410 | German 10 | 1800 | 1900 | 1843 | 1843 | 1843 | Ebony, metal, strings, varnish 55471 | The Crosby Brown Collection of Musical Instruments, 1889 | Karlsruhe 1278 | Germany 16 | Chordophone-Lute-plucked-fretted 921 | http://www.metmuseum.org/art/collection/search/505506 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
351099 | 351099 | 2011.205 | 0 | 0 | 506782 | Musical Instruments 18 | Transverse Flute 15633 | Transverse Flute | British 6 | Maker 1 | Thomas Prowse | British, active London, 1816–1868 | Prowse, Thomas 47988 | British 7 | 1800 | 1900 | ca. 1844 | 1834 | 1844 | Rosewood, silver 55156 | L. 25 7/8 in. (65.7 cm) | Purchase, Robert Alonzo Lehman Bequest, 2011 | London 14 | England 4 | Aerophone-Blow Hole-side-blown flute (transverse) 941 | http://www.metmuseum.org/art/collection/search/506782 | 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");