musiccaps_details (view)
1 row where musiccaps_aspects contains "e-bass", musiccaps_author = 6 and "youtube_published" is on date 2013-11-29
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;