musiccaps_details (view)
2 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "melancholic", musiccaps_names contains "Music" and musiccaps_names contains "Strum"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Chris Thile - Bach: Sonata No. 1 in G Minor, BWV 1001 (Complete) | A male ukulele player plays this emotional solo. The song is medium tempo with no other instrumentation than an ukulele playing. The song is emotional and poignant. The song is an instrumental tune. | 2013-10-14T17:44:07Z | ChrisThile | Chris Thile performs Bach's Sonata No. 1 in G Minor, BWV 1001 in full. Also featured on his album Bach: Sonatas and Partitas, Vol. I, available now on CD & vinyl from Nonesuch Records: http://punchbrothers.kungfustore.com/categories/553-bach-sonatas-and-partitas http://www.nonesuch.com/store/chris-thile iTunes: http://www.smarturl.it/thilebachitunes See Chris live on tour this fall: http://punchbrothers.com/thiletour | ["Banjo", "Music", "Mandolin", "Strum"] | ["ukulele", "ukulele player", "medium tempo", "music video", "romantic", "no percussion instruments", "music demo", "moody blues", "melancholic", "western classical music", "instrumental music", "soloist", "poignant", "entertaining", "emotional", "no percussion instruments", "home video"] | 1 | j3lH_Tevw5o | 4231 | |
Berceuse - Lullaby | The song is an instrumental. The tempo is slow with a classical guitar playing harmony style with a subtle bass line and no other instrumentation. The song is emotional and relaxing. The audio quality is worth average. | 2009-01-13T21:16:18Z | bernard vdd | Compo perso pour Timeo. Play with a gibson j45. For stereo sound try this link: http://fr.youtube.com/watch?v=jS9u6X6TQmk&fmt=18 | ["Guitar", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["guitar harmony", "splits", "classic guitars music", "average audio quality", "melancholic", "nostalgia", "soothing", "virtuosos playing", "instrumental music", "subtle bass line", "guitar harmony", "slow tempo", "acoustic guitar session", "home music video", "emotional", "pensive", "moody", "relaxing", "emotional"] | 1 | jS9u6X6TQmk | 4255 |
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;