musiccaps_details (view)
4 rows where musiccaps_aspects contains "classical music" and musiccaps_names contains "Piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- classical music · 4 ✖
- harpsichord 2
- live performance 2
- baroque 1
- basset horn 1
- bassoon 1
- cello 1
- clarinet 1
- contrabass 1
- fresh 1
- gentle 1
- inauthentic 1
- instrumental 1
- light 1
- live recording 1
- magical 1
- major key 1
- medieval sounding 1
- mellow 1
- no singer 1
- oboe 1
- orchestra 1
- piano 1
- positive 1
- resolution 1
- soothing 1
- viola da gamba 1
- violin 1
- virtual sounds 1
- whimsical 1
- winds 1
musiccaps_names (array) 13 ✖
- Piano · 4 ✖
- Keyboard (musical) 3
- Bowed string instrument 2
- Cello 2
- Classical music 2
- Music 2
- Musical instrument 2
- Brass instrument 1
- Clarinet 1
- Double bass 1
- Harpsichord 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 | |
Forqueray: Pièces de viole avec la basse continue | Lorenzo y Vittorio Ghielmi | This is a classical music piece played on the viola da gamba and the harpsichord. The performance is live, and the song has a refreshing, light and fun "Spring" feel to it. | 2014-12-05T11:36:32Z | FUNDACIÓN JUAN MARCH | Antoine Forqueray, competidor de Marais en los ambientes cortesanos, tuvo siempre el apoyo de Luis XIV. Fue admirado por su virtuosismo en la viola da gamba, a la que quiso trasladar la agilidad y la técnica de los violinistas italianos. Buena muestra de ello son las piezas que interpretan Vittorio y Lorenzo Ghielmi, y que proceden de su colección más conocida: las Pièces pour le viole, publicadas en 1747. Antoine Forqueray: Pièces de viole avec la basse continue (selección) Lorenzo Ghielmi, clave y Vittorio Ghielmi, viola da gamba Extracto de "El canto del cisneon", segundo cierto del ciclo “Origen y esplendor de la viola da gamba” http://www.march.es/musica/detalle.aspx?p5=11030&l=1 14 de mayo de 2014 Fundación Juan March, Madrid http://www.march.es/videos/?p0=4678&l=1 | ["Cello", "Harpsichord", "Music", "Musical instrument", "Piano", "Classical music", "Bowed string instrument"] | ["live performance", "classical music", "live recording", "viola da gamba", "harpsichord", "soothing", "whimsical", "magical", "light", "fresh"] | 3 | ECP7EJka6N8 | 1538 | |
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;