musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "positive energy" and musiccaps_aspects contains "uptempo" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- acoustic drums 3
- e-bass 3
- positive energy · 3 ✖
- uptempo · 3 ✖
- e-guitar 2
- accordion 1
- acoustic guitar 1
- background-noises 1
- backing voices 1
- country/folk 1
- female teen voice singing 1
- harmonica 1
- male voice singing 1
- poprock 1
- rock/ska 1
- synth sounds 1
musiccaps_names (array) 8 ✖
- Music 3
- Ska 2
- Funk 1
- Happy music 1
- Independent music 1
- Music of Africa 1
- Music of Latin America 1
- Reggae 1
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 | |
Casar Hum Hum Gino e Geno Part Felipe Borges 2013 | A male voice is singing/shouting phrases while an acoustic drum is playing a dance groove along with an e-bass. On top of that a acoustic guitar is playing a melody and another one is strumming chords while an accordion is playing a loud melody that seems to be the lead. The drum fill-ins are panned to the left and right side of the speakers. This song sounds like the people are having fun. This song may be playing at a dance event in the countryside. | 2013-05-16T00:23:52Z | W Comunicação | Nova Música do Gino e Geno Lançamento | ["Music of Africa", "Music", "Ska", "Music of Latin America"] | ["country/folk", "acoustic drums", "e-bass", "accordion", "acoustic guitar", "male voice singing", "uptempo", "positive energy"] | 6 | Fv9swdLA-lo | 1674 | |
Bad Manners - Don't Knock The Bald Head (Live) Part 3 | An acoustic drum is playing a faster groove along with a bassline and a harmonica playing a chord on the offbeat and in a lower key. A e-guitar is playing a melody in the mid range. There are some background noises that remind me of someone brushing his/her teeth. This song may be playing live at a bar. | 2009-04-09T13:42:52Z | OxBlood66 | 3 tracks from Don't Knock The Bald Head. Skaville UK, Walking In The Sunshine, King Ska/FA. | ["Funk", "Music", "Independent music", "Reggae", "Ska"] | ["rock/ska", "e-bass", "acoustic drums", "e-guitar", "harmonica", "background-noises", "uptempo", "positive energy"] | 6 | KdNhYvN4Xoo | 2101 |
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;