MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

17 rows where Medium = 54188

View and edit SQL

Suggested facets: Is Public Domain, Culture, Artist Role, 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 Repository
346542 89.4.560a, b 0 1 501176 Musical Instruments 18 Frame Drum 15801 Frame Drum Native American (Dakota) 6275                           19th century 1801 1900 wood, various materials 54188 D. 3 9/16 × Head Diam. 16 9/16 × Max. Diam. 18 11/16 × Stick L.18 11/16 in. (9 × 42 × 47.5 × 47.5 cm) The Crosby Brown Collection of Musical Instruments, 1889         United States 3             Membranophone-single-headed / frame drum 932   Metropolitan Museum of Art, New York, NY 1
347004 89.2.151 0 1 501649 Musical Instruments 18 Mandoline 15403 Mandoline Italian 36                           18th century 1701 1800 wood, various materials 54188 L. 53.3 cm (21 in.); W. 14 cm (5 1/2 in.) Gift of Joseph W. Drexel, 1889   Naples 436     Italy 14             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
347009 89.4.1075 0 0 501654 Musical Instruments 18 Harp Guitar 16029 Harp Guitar Italian 36                           19th century 1801 1900 wood, various materials 54188 L. 3 ft. 1 in. The Crosby Brown Collection of Musical Instruments, 1889         Italy 14             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
347010 89.4.1076 0 1 501655 Musical Instruments 18 Harp Lute 16035 Harp Lute British 6         Maker 1   Edward Light British, London ca. 1747–ca. 1832 London   Light Edward 47741 English 3496 1747 1832 ca. 1800 1790 1810 wood, various materials 54188 Overall: 34.7 x 13.1 x 82.3 cm (13 11/16 x 5 3/16 x 32 3/8 in.) The Crosby Brown Collection of Musical Instruments, 1889       England 865 United Kingdom 720             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
347141 89.4.1231 0 1 501797 Musical Instruments 18 Harpsichord 8383 Harpsichord Italian 36                           16th or 17th century 1501 1700 wood, various materials 54188 Inner Instrument L. 195.2 cm 76.85 in. W. 85.9 33.82 D. 21.6 8.50 3-octave span 51.7 20.35 Sounding length (longer of pair, far plucking point) AA 152.0 10.6 c2 26.6 6.1 e3 9.5 4.0 The Crosby Brown Collection of Musical Instruments, 1889   Naples? 2201     Italy 14             Chordophone-Zither-plucked-harpsichord|Paintings 997   Metropolitan Museum of Art, New York, NY 1
347234 89.4.1326 0 0 501892 Musical Instruments 18 Halam 16136 Halam Moroccan 451                           late 19th century 1850 1900 wood, various materials 54188 L. 3 ft. 1 in., Diam. 6 in. The Crosby Brown Collection of Musical Instruments, 1889         Morocco 75             Chordophone-Lute-plucked-unfretted 905   Metropolitan Museum of Art, New York, NY 1
347266 89.4.1358 0 0 501924 Musical Instruments 18 Guitar 15412 Guitar                             late 19th century 1875 1899 wood, various materials 54188   The Crosby Brown Collection of Musical Instruments, 1889                       Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
347283 89.4.1375 0 0 501941 Musical Instruments 18 Zurna 15682 Zurna North Coast Africa 6273                           late 19th century 1850 1900 wood, various materials 54188 L. 1 ft. The Crosby Brown Collection of Musical Instruments, 1889                       Aerophone-Reed Vibrated-double reed 911   Metropolitan Museum of Art, New York, NY 1
347292 89.4.1384 0 0 501950 Musical Instruments 18 Tanbour 16017 Tanbour Northern Africa 6404                           late 19th century 1850 1900 wood, various materials 54188 L. 2 ft. 6-1/2 in., W. 6 in. The Crosby Brown Collection of Musical Instruments, 1889                       Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
347438 89.4.1529 0 0 502104 Musical Instruments 18 Calascione 16210 Calascione Italian 36                           18th century 1701 1800 wood, various materials 54188 Length 3 ft. 3 in., Width 8-1/2 in. The Crosby Brown Collection of Musical Instruments, 1889         Italy 14             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
347484 89.4.1587 0 1 502151 Musical Instruments 18 Pochette 15415 Pochette European 12                           18th century 1701 1800 wood, various materials 54188 L. 1 ft. 9-1/2 in., W. 1-1/2 in. The Crosby Brown Collection of Musical Instruments, 1889                       Chordophone-Lute-bowed-unfretted 925   Metropolitan Museum of Art, New York, NY 1
348943 89.4.1567 0 1 503666 Musical Instruments 18 Portable Harp 16037 Portable Harp British 6         Maker 1   Joseph George Morley British, London 1847–1922 London   Morley, Joseph George 48060 British 7 1847 1922 late 19th century 1875 1899 wood, various materials 54188 Height: extreme: 114.0 cm length of pillar: 111.0 above soundboard: 91.0 cm Soundboard: resonating length: 89.5 cm greatest width: 21.0 cm Strings (sounding length): longest: 101.0 cm Shortest: 9.0 cm c2 (missing?) The Crosby Brown Collection of Musical Instruments, 1889   London 14   England 865 United Kingdom 720             Chordophone-Harp 967   Metropolitan Museum of Art, New York, NY 1
348985 89.4.3166 0 1 503709 Musical Instruments 18 Harp 1196 Harp German or French 402                           ca. 1760 1760 1760 wood, various materials 54188   The Crosby Brown Collection of Musical Instruments, 1889 | 33   | 96   France|Germany 40             Chordophone-Harp 967   Metropolitan Museum of Art, New York, NY 1
349422 89.4.2137a–d 0 1 504200 Musical Instruments 18 Serinette 16004 Serinette French 7         Maker 1   Ch. Denis     Denis Ch. 48230       ca. 1800 1795 1805 wood, various materials 54188 Overall: H. 27.1 x W. 37.3 x L. perpendicular to barrel 26.2cm (10 11/16 x 14 11/16 x 10 5/16in.) The Crosby Brown Collection of Musical Instruments, 1889       Mirecourt, Vosges 1004 France 9             Aerophone-Automatic 990   Metropolitan Museum of Art, New York, NY 1
349827 1978.274 0 0 504659 Musical Instruments 18 Banjo-form Mandolin called a "Bandonian" 17084 Banjo-form Mandolin called a "Bandonian" American 1         Maker 1   William H. De Wick     De Wick William H. 48307       ca. 1912 1910 1915 wood, various materials 54188 Diam. 27.4 x L. 58.5 cm (10 13/16 x 23 1/16 in.) Gift of Mr. and Mrs. Harry C. Wolfson, 1978   Brooklyn 48   New York 126 United States 3             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
349829 1978.291.1 0 1 504661 Musical Instruments 18 Pedal Harp 16038 Pedal Harp British 6         Manufacturer 20   Erard Freres et Co Paris (1788) and London (1792) until 1826   Erard Freres et Co 48308 Paris and London 3525 1788 1883 ca. 1815–20 1810 1825 wood, various materials 54188 H. 66 13/16 x W. 14 3/16 in. (169.7 x 36 cm) Gift of Mildred Dilling from her harp collection, 1978   London 14     United Kingdom 720             Chordophone-Harp 967   Metropolitan Museum of Art, New York, NY 1
350315 89.4.2741 0 1 505209 Musical Instruments 18 Claviorganum 17298 Claviorganum German 27         Maker 1   Herman Willenbrock     Willenbrock Herman 48377       1712 1712 1712 wood, various materials 54188 W. 31 9/16 x D. 9 1/4 x L. 89 3/8 in. (80.2 x 23.5 x 227 cm) c-b2 19 1/2 (49.5 cm) The Crosby Brown Collection of Musical Instruments, 1889   Hannover 2374     Germany 16             Chordophone and Aerophone-struck piano/ free reed keyboard|Paintings 1024   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 143.972ms · Data license: CC0 · Data source: metmuseum/openaccess