musiccaps_details (view)
1 row where musiccaps_aspects contains "amateur production", musiccaps_aspects contains "heavily compressed drum samples" and musiccaps_names contains "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 |
---|---|---|---|---|---|---|---|---|---|---|
Make It Pop | ‘Looking For Love’ Official Music Video #2 | Nick | Empowering youthful music with heavily processed female vocals and compressed drum samples. big claps on the backbeat and a funky electric bass part accompany. The production aims at high fidelity but comes across sounding over produced and ultimately amateur. | 2015-04-29T16:00:01Z | Nickelodeon | Check out the new song ‘Looking For Love’ from Nickelodeon's newest show, Make It Pop! Don’t miss the season 2 premiere of Make It Pop on Monday, January 4th at 7pm/6c! Subscribe if you love Nickelodeon and want to see more! https://at.nick.com/Subscribe Welcome to the official channel for Nickelodeon! We have hilarious clips from Spongebob Squarepants, Teenage Mutant Ninja Turtles, Legend of Korra, Sam & Cat, Breadwinners, and all your favorites! Subscribe to see special behind the scenes videos, trailers, sneak peeks, and interviews. Be sure to visit nick.com for games, full episodes, online radio and more! More from Nickelodeon: Official Nickelodeon Website: https://at.nick.com/Official/?xid=YTdesc Official Nickelodeon App: https://at.nick.com/Official/app?xid=YTdesc Like Nickelodeon: https://www.facebook.com/nickelodeon?xid=YTdesc Follow Nickelodeon: https://twitter.com/NickelodeonTV?xid=YTdesc Nickelodeon Tumblr: http://nickelodeon.tumblr.com?xid=YTdesc Nickelodeon Instagram: http://instagram.com/nickelodeontv?xid=YTdesc | ["Singing", "Music", "Pop music", "Song"] | ["heavily processed female vocals", "funky electric bass", "clap", "big backbeat", "heavily compressed drum samples", "empowering", "youthful", "amateur production", "over produced"] | 8 | K9zE9x2ccJk | 2061 |
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;