musiccaps_details (view)
1 row where musiccaps_aspects contains "magical" and musiccaps_names contains "Classical music" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- classical music 1
- fresh 1
- harpsichord 1
- light 1
- live performance 1
- live recording 1
- magical · 1 ✖
- soothing 1
- viola da gamba 1
- whimsical 1
musiccaps_names (array) 7 ✖
- Bowed string instrument 1
- Cello 1
- Classical music · 1 ✖
- Harpsichord 1
- Music 1
- Musical instrument 1
- Piano 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;