musiccaps_details (view)
3 rows where musiccaps_aspects contains "baroque", musiccaps_aspects contains "instrumental" and musiccaps_author = 9
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Canon In D - Harp Wedding Music - Magdalene Wong | This is a classical music piece belonging to the baroque period. The piece is being performed with a harp. There is a catchy tune being played with a positive aura. This piece could suit well as wedding music. It could be used in the soundtrack of a documentary. It could also be playing in the background of a classy restaurant or a museum. | 2008-04-19T15:05:55Z | singaporeharpist | Canon In D composed by Johann Pachelbel arranged and performed by Singapore harpist Magdalene Wong. Harp model is Aoyama Special Blue and Gold Musa. | ["Music", "Wedding music"] | ["classical", "baroque", "canon", "single instrument", "instrumental", "harp", "catchy", "iconic", "calming", "hopeful", "positive", "wedding music"] | 9 | -OUIEnuNd1I | 42 | |
J.S.Bach 2 parts invention n.4 in D minor | This is a classical music piece from the baroque era. The piece is being performed by a harpsichord. There is a mysterious atmosphere and a medieval feel to this piece. The music could fit very well in the soundtrack of a gothic horror movie, especially where we are witnessing a scene of exposition. | 2007-05-13T22:21:29Z | musiclover63 | J.S.Bach 2 parts invention n.4 in D minor | ["Harpsichord", "Keyboard (musical)"] | ["classical music", "no singer", "instrumental", "baroque", "harpsichord", "mysterious", "enigmatic", "eccentric", "medieval sounding"] | 9 | 0zolXzR9Oi4 | 226 | |
G.F. Handel - Suite No. 7 in G minor, HWV 432 - Passacaille | This is a live performance of a classical music piece from the baroque era. The piece is being performed on a harpsichord. There is a medieval sound to the piece. The atmosphere is dramatic. This piece could be used in the soundtrack of a historical drama movie moments before a face-off or a battle. | 2013-03-16T19:51:17Z | Gabriella Di Laccio | Fernando Cordella - Harpsichord Crown Court Church London, Covent Garden march 2013 | ["Harpsichord", "Keyboard (musical)"] | ["classical music", "baroque", "live performance", "instrumental", "harpsichord", "medieval sounding", "dramatic", "epic", "intense"] | 9 | y5I5pq0bXmg | 5381 |
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;