musiccaps_details (view)
1 row where musiccaps_aspects contains "emotional", musiccaps_aspects contains "heartbreak" and musiccaps_aspects contains "powerful"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Adele - Set Fire To The Rain (Live) Itunes Festival HD | This song carries a powerful air of conviction with it that is aided by the singer's soulful performance. It's a heartbreak song and although it feels sad, it also feels like a reclamation of power. It's a live performance with a full band including guitarists, violinists, a pianist and a drummer who plays a pop beat. The genre for this song could be classified as pop-soul. | 2011-07-08T10:35:19Z | Monique Corrêa | Adele - Set Fire To The Rain (Live) Itunes Festival. --- 01. Hometown Glory (http://www.youtube.com/watch?v=v-3S-9Q5wG4) 02. I'll Be Waiting (http://www.youtube.com/watch?v=MsdP5NzWZg8) 03. Don't You Remember(http://www.youtube.com/watch?v=ksNJyZ2I6II) 04. Turning Tables (http://www.youtube.com/watch?v=oBYYiIHm90I) 05. Set Fire To The Rain http://www.youtube.com/watch?v=qknDM3pcoD0 06. If It Hadn't Been For Love (http://www.youtube.com/watch?v=pmKgplM2BTo) 07. My Same (http://www.youtube.com/watch?v=vFbdmBbKAaw) 08. Take It All (http://www.youtube.com/watch?v=snU9vQNOkHw) 09. Rumour Has It (http://www.youtube.com/watch?v=yJ6GlkY5R2o) 10. Right As Rain (http://www.youtube.com/watch?v=AK2x6TPTUgo) 11. One And Only (http://www.youtube.com/watch?v=os5z7XZPXys) 12. Lovesong (The Cure cover) (http://www.youtube.com/watch?v=i5bpYECjPJ4) 13. Chasing Pavements (http://www.youtube.com/watch?v=Wdtz0GRqKng) 14. I Can't Make You Love Me (Bonnie Raitt cover) (http://www.youtube.com/watch?v=sLfWPLLn-QI) 15. Make You Feel My Love (Bob Dylan cover) (http://www.youtube.com/watch?v=LZXjqwOxH4g) 16. Rolling In The Deep (http://www.youtube.com/watch?v=7QexZ-vmVV0) 17. Someone Like You (http://www.youtube.com/watch?v=Ew-9r_6MABg) | ["Singing", "Music", "Independent music"] | ["live performance", "soulful song", "soulful female singer", "electric guitars", "violins", "piano", "simple pop drum beat", "emotional", "heartbreak", "conviction", "powerful"] | 3 | qknDM3pcoD0 | 4812 |
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;