musiccaps_details (view)
2 rows where musiccaps_aspects contains "live recording" and musiccaps_aspects contains "soothing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- live recording · 2 ✖
- soothing · 2 ✖
- calming 1
- clarinet 1
- classical music 1
- emotional 1
- fresh 1
- harpsichord 1
- light 1
- live performance 1
- magical 1
- piano 1
- viola da gamba 1
- whimsical 1
musiccaps_names (array) 10 ✖
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 | |
2) Guy Dangain Master Class en Turquie Concertino Opus 26 de weber pour clarinette | Here we have a gentle and soothing instrumental piece on the piano and clarinet. The pianist plays an accompaniment to the lead melody of the clarinet - which feels like a relaxing afternoon at the beach. This is a live recording. | 2009-10-13T19:03:42Z | MICHELMUSIK123 | Concertino Opus 26 de weber pour clarinette Guy Dangain Master Class en Turquie Académie de Musique UMA Urla Guy Dangain est clarinettiste, concertiste international, Professeur au Conservatoire National Supérieur de Musique de Paris, Professeur à l'Ecole Normale de Musique de Paris - Soliste à l'Orchestre National de France. Il est aussi Directeur de l'Académie du Haut-Bugey en Rhône Alpes. UMA URLA Müzik Akademisi le 29 septembre 2009. Ont également participé à cette Académie de Musique: Andras Adorjan Professeur de flûte à Munich (Professor in München - Flöte) Hans Jörg Schellenberger Hautboïste à l'Orchestre Philharmonique de Berlin (Oboe im Berliner Philharmoniker) Heidi Litschauer violoncelliste (Cello) au Mozarteum de Salzbourg Andrée Sommer pianiste (Klavier) au CNSM de Paris. Vidéo de M. Guy Dangain | ["Brass instrument", "Clarinet", "Wind instrument, woodwind instrument"] | ["clarinet", "piano", "live recording", "calming", "soothing", "emotional"] | 3 | PRRcVdXsBQg | 2536 |
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;