musiccaps_details (view)
3 rows where musiccaps_aspects contains "poprock"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Sonic Adventure DX Music: BELIEVE IN MYSELF | The female voice sings in the mid range. The drums is playing a fast rock/hiphop groove along with an acoustic bass breaking along with it into another part of the song. One of the e-guitars is playing some chords running through a strong tremolo effect. While the other guitar sounds distorted and takes the lead. One is panned to the left, the other to the right side of the speakers. This song may be playing at a birthday party. | 2007-02-09T02:50:55Z | sonicKAI | This is Miles "Tails" Prower's theme tune in Sonic Adventure DX. The song is "Believe In Myself" by Karen Brake. | ["Music", "Exciting music"] | ["poprock", "e-bass", "e-guitars", "acoustic drums", "female singer", "uptempo"] | 6 | 0DizopdPMBw | 134 | |
| 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 | |
| "Pepsi Football Splash" กิจกรรมสุดมันส์ที่สวนน้ำ Cartoon Network Amazone | This song contains acoustic drums playing a simple rhythm along with an e-bass. The same rhythmic pattern gets played by an acoustic guitar and e-guitar strumming chords. In the background female voices are happily screaming to the sound of waves. This song may be playing for an advertisement. | 2016-07-18T02:45:54Z | Pepsi Thailand | ชวนแก๊งเพื่อนให้พร้อม แล้วมามันส์กับ "Pepsi Football Splash" กิจกรรมใหม่ล่าสุดจาก Pepsi และสวนน้ำ Cartoon Network Amazone เพียงซื้อแก้ว Pepsi Tumbler ที่สวนน้ำ Cartoon Network Amazone พัทยา ก็รับสิทธิ์ร่วมกิจกรรมฟรี! พร้อมลุ้นรับรางวัลอีกมากมาย รีบมามันส์กันได้เลยตลอดทั้งเดือนกรกฎาคม 2559 | ["Music", "Slosh"] | ["poprock", "acoustic drums", "acoustic guitar", "e-guitar", "e-bass backround noises", "uptempo"] | 6 | iP46w2o_HCk | 4180 |
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;