musiccaps_details (view)
2 rows where musiccaps_aspects contains "compelling", musiccaps_aspects contains "enthusiastic" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- compelling · 2 ✖
- enthusiastic · 2 ✖
- fast tempo 2
- youthful · 2 ✖
- amplified guitar harmony 1
- amplified instruments 1
- animated piano harmony 1
- clapping 1
- club music 1
- concert 1
- crowd cheering 1
- cymbals 1
- dance groove 1
- dance pop 1
- dance rap 1
- digital drumming 1
- disco rap 1
- electrifying 1
- emphatic vocals 1
- energetic 1
- fans 1
- funk 1
- funk rap 1
- gig 1
- hard rock 1
- heavy metal 1
- hip-hop 1
- hip-hop hits 1
- infectious drumming 1
- intense electric guitar feedback 1
- keyboard accompaniment 1
- live performance 1
- male singer 1
- male vocalist 1
- party music 1
- passionate emotional 1
- persuasive 1
- punchy bass lines 1
- punk rap 1
- rap 1
- rapper 1
- rhythmic patter 1
- rock 1
- singing along 1
- sonic power 1
- street vernacular 1
- string instruments 1
- vigorous drumming 1
- vocal backup 1
musiccaps_names (array) 4 ✖
- Music 2
- Jazz 1
- Rock and roll 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Street King Energy Track #8 by 50 Cent | 50 Cent Music | A male vocalist sings this spirited rap. The tempo is fast with an animated piano accompaniment, groovy bass lines, intense drumming, cymbal rides and vocal backup. The song is youthful, vibrant, vivacious, animated, compelling ,enthusiastic and passionate . This song is contemporary Hip-Hop/Rap. | 2011-10-01T22:36:47Z | 50 Cent | SUBSCRIBE: http://bit.ly/YeOjEy New track by 50 Cent: Track #8 (Freestyle) Street King Energy Track #8 Order Street King at http://orders.streetking.com/ Previously: * 50 Cent - Street King Energy Track #7: http://www.youtube.com/watch?v=smqxZG2MLy0 * 50 Cent - Love, Hate, Love (Street King Energy Track #6): http://www.youtube.com/watch?v=NYjMKEYgAvI Permalink: http://www.thisis50.com/profiles/blogs/50-cent-street-king-energy-track-8 50 Cent - Street King Energy Track #8 About 50 Cent: Curtis James Jackson III, better known by his stage name 50 Cent, is an American rapper, entrepreneur, investor, and actor. This is his official YouTube Music Channel. Connect with 50 Cent Online: Visit 50 Cent Website: http://bit.ly/WM9S21 Like 50 Cent on Facebook: http://on.fb.me/XxuVyR Follow 50 Cent on Twitter: http://bit.ly/Y4XxPY Follow 50 Cent on Instagram: http://bit.ly/VLeAeX Buy 50 Cent Music Online: iTunes: http://bit.ly/1663kwB Amazon: http://amzn.to/14p4Gic Street King Energy Track #8 by 50 Cent | 50 Cent Music http://www.youtube.com/user/50centmusic | ["Jazz", "Music"] | ["male singer", "fast tempo", "rap", "rapper", "dance groove", "club music", "party music", "funk", "dance pop", "dance rap", "disco rap", "hip-hop", "hip-hop hits", "energetic", "enthusiastic", "rhythmic patter", "passionate emotional", "animated piano harmony", "vigorous drumming", "cymbals", "digital drumming", "punchy bass lines", "vocal backup", "street vernacular", "punk rap", "funk rap", "dance groove", "youthful", "compelling", "persuasive"] | 7 | Brc_nOquNbY | 1297 | |
Led Zeppelin - Rock and Roll (Live) | A male vocalist sings this energetic Rock song. The tempo is fast with intense drumming, vigorous electric guitar, funky bass and keyboard harmony. The song is a vibrant, enthusiastic, youthful, animated, spirited, buoyant and electrifying Heavy Metal/Rock. There are sounds of people cheering, clapping and singing along, indicating that this is a live performance. | 2008-03-13T23:04:36Z | Rodolfo Baravalle | Rock and Roll en no sé donde.. Viva la pepa (?) | ["Music", "Roll", "Rock and roll"] | ["male vocalist", "fast tempo", "enthusiastic", "string instruments", "amplified instruments", "sonic power", "infectious drumming", "live performance", "gig", "intense electric guitar feedback", "amplified guitar harmony", "keyboard accompaniment", "emphatic vocals", "concert", "live performance", "hard rock", "heavy metal", "rock", "crowd cheering", "clapping", "singing along", "fans", "enthusiastic", "youthful", "electrifying", "compelling"] | 7 | QvwD7NEg3Mw | 2650 |
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;