musiccaps_details (view)
3 rows where musiccaps_names contains "Cello" and musiccaps_names contains "Piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- classical music 2
- cello 1
- classical 1
- elevating energy 1
- fresh 1
- gentle 1
- harpsichord 1
- light 1
- live performance 1
- live recording 1
- magical 1
- mellow 1
- orchestra 1
- piano 1
- resolution 1
- soothing 1
- string section 1
- uptempo 1
- viola da gamba 1
- violin 1
- whimsical 1
musiccaps_names (array) 11 ✖
- Bowed string instrument 3
- Cello · 3 ✖
- Piano · 3 ✖
- Double bass 2
- Keyboard (musical) 2
- Violin, fiddle 2
- Classical music 1
- Harpsichord 1
- Music 1
- Musical instrument 1
- String section 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Hiccupping | This audio contains an orchestral classical composition played by string instruments. violins/violas are playing the main melody in a higher key. The piece sounds fast paced and elevating. This song may be playing live sitting in an orchestra performance. | 2009-03-13T02:22:08Z | Nathan Baker | My first project in my film class. Enjoy | ["Cello", "Double bass", "String section", "Keyboard (musical)", "Piano", "Violin, fiddle", "Bowed string instrument"] | ["classical", "orchestra", "string section", "uptempo", "elevating energy"] | 6 | UkTWmyy7ia8 | 2939 |
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;