musiccaps_details (view)
3 rows where musiccaps_aspects contains "classical music", musiccaps_author = 9 and musiccaps_names contains "Piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- classical music · 3 ✖
- baroque 1
- basset horn 1
- bassoon 1
- cello 1
- clarinet 1
- contrabass 1
- gentle 1
- harpsichord 1
- inauthentic 1
- instrumental 1
- live performance 1
- major key 1
- medieval sounding 1
- mellow 1
- no singer 1
- oboe 1
- orchestra 1
- piano 1
- positive 1
- resolution 1
- violin 1
- virtual sounds 1
- winds 1
musiccaps_names (array) 12 ✖
- Keyboard (musical) 3
- Piano · 3 ✖
- Bowed string instrument 1
- Brass instrument 1
- Cello 1
- Clarinet 1
- Classical music 1
- Double bass 1
- Music 1
- Musical instrument 1
- Violin, fiddle 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cristofori Piano: Sonata K.9 by Domenico Scarlatti | This is the live performance of a classical music piece. The piece is being performed with a harpsichord. It is in the minor key. The piece is medieval sounding. It could fit perfectly in the soundtrack of a historical drama that takes place in the medieval era. | 2013-06-06T22:24:58Z | The Met | Dongsok Shin performs the Sonata in d minor, K.9 by Domenico Scarlatti (1685-1757) on the earliest known surviving piano, made by the instrument's inventor, Bartolomeo Cristofori (1655-1731), in Florence, 1720. Scarlatti's keyboard compositions were performed on both the harpsichord and the early piano. Production support was provided by The Donna and Marvin Schwartz Foundation A production of the Digital Media Department The Metropolitan Museum of Art Produced and Directed by Christopher Noey Edited by Kate Farrell Camera by Kelly Richardson and Jessica Glass Lighting by Ned Hallick Sound Recording and Post-Production Audio by David Raymond Production Coordinator: Stephanie Wuertz Production Assistants: Sarah Cowan, Maureen Coyle Organized by the Department of Musical Instruments J. Kenneth Moore, Frederick P. Rose Curator-in-Charge Jayson Kerr Dobney, Associate Curator and Administrator E. Bradley Strauchen-Scherer, Associate Curator Susana Caldeira, Assistant Conservator Dongsok Shin, keyboard technician Joseph Peknik III, Principal Technician Pamela Summey, Programs Coordinator Marian Eines, Associate for Administration | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Classical music"] | ["classical music", "live performance", "baroque", "harpsichord", "medieval sounding"] | 9 | A2WdjyKQ57A | 1060 | |
J. Raff - Cavatina | This is a classical music piece performed by a trio of the violin, the cello and the piano. The melody being played is a gentle one and there is a feeling of resolution in this section of the piece. This piece could be used in the soundtrack of a drama TV series during the closing scenes. | 2007-05-24T15:12:34Z | erasmustrio | Erasmus Trio Amsterdam | ["Cello", "Double bass", "Keyboard (musical)", "Piano", "Violin, fiddle", "Bowed string instrument"] | ["classical music", "violin", "cello", "piano", "gentle", "mellow", "resolution"] | 9 | BkSCfcTBMRY | 1285 | |
Sibelius 7 Sounds - 3. Winds | This is a classical music piece played with the virtual sounds of a wind orchestra. The orchestra is composed of the oboe, the clarinet, the basset horn, the bassoon and the contrabass. The piece is in major key which gives the piece a more positive aura in general, but the virtual sounds make it feel inauthentic. | 2011-11-26T01:00:19Z | OrchestrationOnline | Third in a series of reviews of the new sound set from Sibelius 7. Please watch full-screen with high fidelity sound. Many thanks to special guest Justus Rozemond, contrabass clarinetist. | ["Brass instrument", "Clarinet", "Keyboard (musical)", "Piano", "Wind instrument, woodwind instrument"] | ["classical music", "no singer", "instrumental", "virtual sounds", "orchestra", "winds", "oboe", "clarinet", "basset horn", "bassoon", "contrabass", "major key", "positive", "inauthentic"] | 9 | GMFWnMRtfNI | 1711 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;