musiccaps_details (view)
1 row where musiccaps_aspects contains "autotune", musiccaps_aspects contains "pop" and musiccaps_aspects contains "vocal hocketing"
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 |
---|---|---|---|---|---|---|---|---|---|---|
"Best Love Song" by T-Pain, feat Chris Brown - cover by CIMORELLI! | Heavily processed girl band with multiple female singers in a pop or R&B style, using autotune, vocal hocketing, and melisma with multiple synthesizers accompanying. | 2011-05-22T14:30:21Z | Cimorelli | We answer our messages on Patreon! Join the family and get close with us 😁❤️ https://www.patreon.com/Cimorelli Our original song "Million Bucks" is currently playing on SiriusXM's channel 20 on 20!!! Request it HERE: www.bit.ly/SiriusXMVote Thanks!!!!!!!!!! Our EP reached #6 on the US iTunes pop charts!!! Thank you guys so much! :D Purchase HERE: http://itunes.apple.com/us/album/cimfam-ep/id482598948 http://facebook.com/cimorelliband We LOVE this song! Hope you like our arrangement of it! LINKS: http://twitter.com/cimorelliband http://facebook.com/cimorelliband http://cimorellimusic.com http://youtube.com/xxooxxoo8993 MERCH: http://cimorellimusic.com/store We have individual twitters as well (@ChristinaCim @KathCim @LisaCim @AmyCim @LaurenCimorelli @Danicim :) Honors for this video (39) #28 - Most Discussed (Today) #1 - Most Discussed (Today) - Music #32 - Most Discussed (This Week) - Music #37 - Most Viewed (Today) - Germany #124 - Most Viewed (Today) - United Kingdom #75 - Most Viewed (Today) #183 - Most Viewed (Today) - Spain #192 - Most Viewed (Today) - France #116 - Most Viewed (Today) - Netherlands #191 - Most Viewed (Today) - Sweden #131 - Most Viewed (Today) - Australia #31 - Most Viewed (Today) - Canada #171 - Most Viewed (Today) - Ireland #138 - Most Viewed (Today) - Israel #77 - Most Viewed (Today) - New Zealand #197 - Most Viewed (Today) - Music - Egypt #64 - Most Viewed (Today) - Music - Czech Republic #4 - Most Viewed (Today) - Music - Germany #20 - Most Viewed (Today) - Music - United Kingdom #19 - Most Viewed (Today) - Music #35 - Most Viewed (Today) - Music - Spain #69 - Most Viewed (Today) - Music - Mexico #45 - Most Viewed (Today) - Music - France #35 - Most Viewed (Today) - Music - Italy #17 - Most Viewed (Today) - Music - Netherlands #56 - Most Viewed (Today) - Music - Poland #63 - Most Viewed (Today) - Music - Brazil #28 - Most Viewed (Today) - Music - Sweden #158 - Most Viewed (Today) - Music - Jordan #76 - Most Viewed (Today) - Music - Saudi Arabia #25 - Most Viewed (Today) - M… | ["Singing", "Music of Asia"] | ["multiple female singers", "autotune", "vocal hocketing", "pop", "r&b", "accompanying", "melisma", "heavy vocal processing", "girl band"] | 8 | xydcedfPePM | 5373 |
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;