musiccaps_details (view)
1 row where musiccaps_aspects contains "energetic", musiccaps_aspects contains "gypsy guitar music", musiccaps_aspects contains "hooting" and musiccaps_aspects contains "instrumental music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Tommy Emmanuel - The best acoustic guitar live blues! | The song is an instrumental. The song is fast tempo with soloists playing an enthusiastic guitar strumming and harmony. The song is energetic and entertaining. The audio is poor and the song is played in front of a live audience that is cheering and hooting in approval. | 2010-03-03T19:34:12Z | kolipas | Firstly, I do not upload such kind of videos as I have only uploaded gaming (runescape) videos so far. However, I was totally hooked by this blues improvisation and it would be a crime if I didn't share it. So here it is. If you are interested about this artist, here is his official website. www.tommyemmanuel.com You can download his music there. If this video will get enough views and rates, I might upload similar ones in the future. Enjoy. acoustic guitar blues 12 bars runescape best ever funny awsome epic increadible sick improvisation freestyle live | ["Folk music", "Music"] | ["poor audio quality", "instrumental music", "virtuous guitarist", "classic guitar hits", "adrenaline rush", "people cheering", "groovy", "hooting", "guitar player", "soloist", "fast strumming rhythm", "energetic", "passionate", "dance rhythm", "groovy music", "jazz blues", "gypsy guitar music", "blues music", "fast tempo"] | 1 | E3F9bzeCgTQ | 1528 |
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;