musiccaps_details (view)

1 row where musiccaps_aspects contains "rap", musiccaps_author = 7 and "youtube_published" is on date 2011-10-01

✎ View and edit SQL

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
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;