musiccaps_details (view)

2 rows where musiccaps_aspects contains "dubstep", musiccaps_author = 6 and musiccaps_names contains "Drum and bass"

✎ 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
Optimus Prime (Dubstep dance) In the foreground you can hear a saw wave pad playing along with a sub bass. This sound got some reverb and delay on it. The drums sound electronic and repeat a rhythm that leaves a lot of space for the bass sounds. This song may be played at a dance battle or an underground club. 2010-05-01T18:00:45Z JayGarderis Music: Cookie Monsta - Optimus Prime http://www.facebook.com/JayGarderis ["Drum and bass", "Electronic music", "Music", "Dubstep"] ["dubstep", "industrial", "saw wave pad sounds", "sub bass", "electronic drums", "medium tempo"] 6 Q0KwG3ynscI 2587
Vinyl Scratch - Think Again Loosa This song contains digital, dubstep drums with a straight hi hat playing 8th notes. An aggressive bass sound full of modulation and other samples is playing a melody with a lot of pitch shifts and stutter effects. A voice sample is being used with a lot of reverb and delay as an atmospheric element. Some sounds are being arpeggiated playing a fast melody before leaving the scenario again. This song may be playing in an extreme sports advertisement. 2012-12-27T23:30:08Z YourDailyMusicz ✖ Connect with the Artist YouTube: http://www.youtube.com/user/VinylScratchDjPony Facebook: http://www.facebook.com/VinylScratchOfficial Twitter: https://twitter.com/vinyl_scratchdj ✖ Connect with YDL Network Apply for Partnership & Directorship [No View Minimum] [Music only]: http://bit.ly/OYUZWp Apply for standard Partnership: http://www.yourdailylaughz.tv/apply * Notice: YDM Channel is Not a 'non-copyright' channel. Uploading such materiel from YDM or the Artist themselves will result in infringement upon the third party. --- ["Scratching (performance technique)", "Drum and bass", "Music"] ["dubstep", "digital drums", "synth bass sound", "voice sample", "arpeggios", "medium tempo", "energetic"] 6 dsf3agfkJDY 3823

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;