musiccaps_details (view)
4 rows where musiccaps_aspects contains "aggressive energy"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| TACTICAL PANANTUKAN - Alexander Plaksin ( R A P T ) Kali-Silat | This song contains loud acoustic drums with a groove on the ride. An e-bass and e-guitar are playing along in the lower register. A deeper male voice is singing/screaming with a delay on his voice. his voice is doubled. This song may be playing for an action packed youtube video. | 2012-10-28T05:57:23Z | Alexander Plaksin | Master Alexander Plaksin, Head Instructor Andrey Baklanov - SPINDLE PANANTUKAN TACTICAL ( MOSCOW CLUB 8 905 7779991 ) | ["Music", "Angry music"] | ["rock", "acoustic drums", "e-bass", "e-guitar", "male deeper voice singing/screaming", "aggressive energy", "medium tempo"] | 6 | Le4aGNS8e0c | 2210 | |
| METALLIZER ML-7 | Someone is playing a metal riff on a fully distorted and overdriven e-guitar. This is an amateur recording. This song may be playing while practicing with the band. | 2011-08-14T20:58:06Z | lehasV7 | Это клевая примочка от известной фирмы TUBELINE, Смотрите обзоры на сайте www.git-gid.ru | ["Reverberation", "Heavy metal", "Music"] | ["metal-rock", "fully distorted e-guitar", "uptempo", "aggressive energy", "amateur recording"] | 6 | XFuw-m2gYOQ | 3170 | |
| Behind Me Lies Another Fallen Soldier - As I Lay Dying | E-guitars are fingerpicking two different melodies in an arpeggio fashion while another distorted e-guitar is playing the main melody along with a -ebass breaking into the next part with the drums playing a loud groove with toms and crash cymbals. Before that part a male voice was talking before breaking into loud screaming in a deeper voice. This song may be playing live at a rock concert. | 2012-12-27T08:41:07Z | Bunnie | Don't own the song. Obviously. Enjoy c: | ["Music", "Angry music"] | ["hard-rock", "e-guiatars", "e-bass", "acoustic drums", "male deeper voice talking/screaming", "melancholic", "aggressive energy"] | 6 | dPCj4WhTZ3c | 3783 | |
| Electric Callboy - We Are The Mess (OFFICIAL VIDEO) | This song is a mixture of punk rock with acoustic drums with crash hits, e-guitar playing low notes along with the bassline, a male voice aggressively, loud screaming and digital higher pitched sample sounds being panned to the left and right side of the speakers. This song may be playing at a live concert in an underground club. | 2013-11-29T08:17:57Z | Electric Callboy | New Single "We Are The Mess" - Out Now! iTunes: http://bit.ly/1cFo7bM Amazon Digital: http://amzn.to/1egxoch "We Are The Mess" taken from the upcoming album "We are The Mess"! Street Date: 10th January 2014. GET MERCHANDISE: http://www.electriccallboy.com (worldwide shipping) Thanks for your support!!! Video Production: Directed by Eskimo Callboy & Oliver Schillo Edit and VFX by Oliver Schillo & Pascal Schillo Sound Design by Pascal Schillo Music & Lyrics by Electric Callboy Produced by Daniel Haniß and Pascal Schillo Recorded by Electric Callboy Mixed by Daniel Haniß and Pascal Schillo Mastered by Kristian "Kohle" Kohlmannslehner at Kohlekeller Studio Published by BMG Rights Management. Redfield Records 2014. Lyrcis: We don't wanna be sober anymore let's get fucked up with those bitches and whores We don't wanna be sober anymore, let's get fucked up with those bitches and whores Baby let me be your bartender let's get fucked up that we can't remember last night I'm alright when you're here with me I'm alright when you're here with me We are looking for some trouble tonight We wanna party like a g6 looking for those hot chicks I said get out the way I wanna rock the dance floor I got the moves you got the keys for the backdoor Life is a party Why are you so serious ? We make you look ridiculous Ladies get naughty! Gentlemen are in da club Sing along let's get fucked up! Baby let me be your bartender let's get fucked up that we can't remember last night I'm alright when you're here with me I'm alright when you're here with me Baby let me be your bartender let's get fucked up that we can't remember last night I'm alright when you're here with me I'm alright when you're here with me We break the girl's hearts still before we have a drink We're smoking the last cigarette before your girlfriends show us pink and you can't fuck with us and you can't fuck with me We are the new kids from the block and you're just cheesy Life is a party why are you so serious ? We make you look ri… | ["Singing", "Music", "Angry music"] | ["punkrock/electronic", "electronic sounds", "e-guitar", "e-bass", "acoustic drums", "male voice streaming", "aggressive energy", "medium to uptempo"] | 6 | hj7VJnNq6A4 | 4131 |
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;