musiccaps_details (view)

1 row where musiccaps_aspects contains "positive energy", musiccaps_aspects contains "synth sounds", musiccaps_aspects contains "uptempo" and musiccaps_names contains "Happy music"

✎ View and edit SQL

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
School of Rock | 'Party Like a Zombie' Official Music Video | Nick A female teen voice is singing along with backing voices and screams. While acoustic drums are playing along with a simple bassline. The e-guitar is playing the suiting chords on top along with a high pitched sound coming out from a digital piano or organ. This song may be playing in a movie for the whole family. 2016-10-08T14:00:01Z Nickelodeon School of Rock is jamming out with a brand new Halloween song! Go behind the scenes with the cast (Breanna Yde, Ricardo Hurtado, Jade Pettyjohn, Lance Lim, Aidan Miner, Tony Cavalero) as they perform their spooky new single "Party Like a Zombie!" Catch more School of Rock on Nick! Subscribe if you love Nickelodeon and want to see more! https://at.nick.com/Subscribe Nickelodeon is the number-one brand for kids with original cartoons, sitcoms, movies, award shows, products, and more! Here on our Nickelodeon YouTube channel you’ll find the shows and animated series you know and love like SpongeBob SquarePants, The Loud House, Teenage Mutant Ninja Turtles, Henry Danger, ALVINNN!!! and The Chipmunks, and more! You’ll also get exclusive access to our digital original series like The JoJo & BowBow Show Show, Inside Nick, and Nia Sioux’s Slumber Party plus fun Nick recipes, DIY projects, how-tos, and a behind the scenes look at the lives of your favorite Nick stars including JoJo Siwa and Jace Norman! What more could you ask for? Join the fun! Need to know when your favorite TV show is on? Go to: https://at.nick.com/TVSchedule For even more fun, games, and full episodes log on to www.nick.com 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 Nickelodeon Snapchat: http://at.nick.com/snapchat The Splat! Snapchat: http://at.nick.com/TheSplatChat NickSportsTV Snapchat: http://at.nick.com/NickSportsTVsnapchat ["Music", "Happy music"] ["poprock", "e-guitar", "e-bass", "acoustic drums", "backing voices", "synth sounds", "female teen voice singing", "uptempo", "positive energy"] 6 A9ECxUIqw6s 1074

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;