musiccaps_details (view)
1 row where musiccaps_aspects contains "echoing passionate male vocal", musiccaps_aspects contains "electro pop", musiccaps_aspects contains "punchy snare" and musiccaps_aspects contains "snare roll"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Maroon 5 - Sugar (Karboncopy Remix) [Premiere] | The low quality recording features an electro pop song that consists of an echoing passionate male vocal singing over groovy synth keys chord progression, punchy snare hits, followed by snare roll, wide laser synths and reversed crash riser. It sounds exciting and energetic - like a build up section of the song. | 2015-04-22T16:00:01Z | Proximity | •Proximity - Your favorite music you haven't heard yet. » Facebook: http://bit.ly/FBProximity » Twitter: http://bit.ly/ProximityTwitter I love the original track. Vocals are super catchy and Adam Levine is a great singer. When Karboncopy approached me with this remix remix I instantly fell in love with it. Hope you guys enjoy this one as always! :) •Maroon 5: http://www.maroon5.com/v-tour https://www.facebook.com/maroon5 https://twitter.com/maroon5 •Karboncopy: https://soundcloud.com/karboncopy https://www.facebook.com/karboncopyofficial https://twitter.com/!/KarbonCopy Picture by: https://www.behance.net/boksysocks If you'd like to submit a picture, you can send it here: http://pandoric.com/contact Use the new template if you would like to submit a picture! :) http://goo.gl/yoEGNg | ["Disco", "Music"] | ["low quality", "electro pop", "punchy snare", "wide laser synth", "snare roll", "echoing passionate male vocal", "groovy synth keys chord progression", "reversed crash riser", "exciting", "energetic", "build up"] | 4 | 0q-80dzp6PU | 212 |
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;