musiccaps_details (view)
3 rows where musiccaps_aspects contains "catchy", musiccaps_aspects contains "hip-hop" and musiccaps_aspects contains "male vocalist"
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- catchy · 3 ✖
- hip-hop · 3 ✖
- male vocalist · 3 ✖
- energetic 2
- fast tempo 2
- rap 2
- upbeat 2
- youthful 2
- amplified piano 1
- beat boxing 1
- button accordion 1
- crossover musical style 1
- dance rhythm 1
- drum pads 1
- electronic beats 1
- emotional 1
- emphatic 1
- engaging 1
- enthusiastic 1
- enthusiastic drumming 1
- exciting 1
- experimental hip-hop 1
- experimental music 1
- folk music 1
- folk tropics 1
- folktronic 1
- funky 1
- fusion music 1
- groovy 1
- groovy bass lines 1
- intense 1
- medium tempo 1
- melody keyboard 1
- mimicking drum machine 1
- musical duo 1
- no instrumentation 1
- objectionable lyrics 1
- passionate 1
- persuasive 1
- playful accordion harmony 1
- rhythmic 1
- rhythmic patter 1
- rhythmic speech 1
- rock elements 1
- slang 1
- steady drumming 1
- thick accent 1
- unconventional 1
- unique 1
- vocal drum simulation 1
- vocal percussion 1
musiccaps_names (array) 5 ✖
- Music 3
- Beatboxing 1
- Funk 1
- Hip hop music 1
- Rapping 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Attwenger - shakin my brain (official music video) | A male vocalist sings this enthusiastic song in a foreign language. The tempo is fast with infectious drumming and an animated button accordion melody. The song is a fusion of hip-hop with folk music making it unique,unconventional and experimental. It is youthful, buoyant, catchy, engaging and funky with electronic beats. This song is a fusion of Hip-Hop. | 2011-04-05T11:57:57Z | KM FILM | Flimmit: http://www.flimmit.com/attwenger-adventure Attwenger Adventure, 90 Min. Musikfilm/Rockumentary ansehen: http://www.attwenger.at http://www.trikont.de http://www.kmfilm.at http://www.facebook.com/KMFilm Gedreht im Februar 2011 in der KAPU Linz. | ["Funk", "Music"] | ["male vocalist", "fast tempo", "musical duo", "folktronic", "enthusiastic drumming", "playful accordion harmony", "button accordion", "folk music", "hip-hop", "crossover musical style", "experimental music", "unique", "unconventional", "folk tropics", "experimental hip-hop", "fusion music", "electronic beats", "rock elements", "funky", "youthful", "catchy", "upbeat", "energetic", "engaging", "thick accent"] | 7 | 5UmoK5WAW8Y | 663 | |
R.A The Rugged Man - Midnight Thud | A male vocalist sings this passionate Rap. The tempo is medium with steady drumming, keyboard harmony, amplified piano accompaniment, and groovy bass lines . The song is emotional, intense, persuasive, intense and has a catchy groove. This song is contemporary Rap/Hip-Hop. | 2008-09-10T09:04:15Z | Markus Priebe Jakobsson | The song Midnight Thud by the rugged man, with lyrics. | ["Music", "Rapping", "Hip hop music"] | ["male vocalist", "medium tempo", "hip-hop", "rap", "rhythmic patter", "rhythmic speech", "slang", "objectionable lyrics", "passionate", "emotional", "intense", "emphatic", "persuasive", "catchy", "youthful", "steady drumming", "melody keyboard", "amplified piano", "groovy bass lines"] | 7 | CrbZHPkHeV4 | 1407 | |
HARLEM SHAKE BEATBOX:: electro :: ChrizpyBBX | A male musician vocalises this energetic rhythm. The tempo is fast with rhythmic beats. The music has no instrumentation. It is youthful, energetic, groovy, enthusiastic and upbeat.This music is a Vocal percussion imitation. | 2013-02-12T21:44:34Z | oOchrizpyOo | Guys my name is Chrizpy, I am a beatboxer based out of B.C. I hope you all enjoy my videos and my new age style of beatboxing. Please show some support and subscibe to my channel!! I love you all!!! Please like my Facebook page: https://www.facebook.com/Chizpy.Beatbox?ef=hl Check out my YouTube channel: https://www.youtube.com/use/oOchizpyOo Follow me on Twitter: https://twitter.com/ChrizpyBBX Vine: @ChisGouchie Instagram: @ChrizpyBBX Bookings: chrizpybookings@hotmail.com | ["Beatboxing", "Music"] | ["male vocalist", "fast tempo", "beat boxing", "exciting", "enthusiastic", "energetic", "dance rhythm", "hip-hop", "rap", "no instrumentation", "vocal percussion", "mimicking drum machine", "vocal drum simulation", "groovy", "upbeat", "catchy", "rhythmic", "drum pads"] | 7 | y9hdu9iMBG8 | 5387 |
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;