musiccaps_details (view)

1 row where musiccaps_aspects contains "dubstep song", musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Electronica"

✎ 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
Checkout the Best Dubstep Music Software 2013! Sick DEMO! This song starts with a descending phrase played on a synth. This is followed by an ascending phrase on another synth. This is accompanied by simple programmed percussion playing the hi-hat on the first two counts and the fourth count of each bar. The snare is played on the third count of each bar. After four bars, the percussion plays a roll and the bass plays one note two times. The synth sounds in the background get louder when the roll is played. There are no voices in this song. This song can be played in a night club. 2013-06-30T05:56:18Z theDRDRUM23 DISCOUNTED LINK: http://tinyurl.com/DRDRUM23 Ever wanted to create beats but just found everything FAR too complicated and expensive? Maybe you have tried beat making software before only to be left scratching your head after 4 hours of playing with it and getting nowhere fast? http://tinyurl.com/DRDRUM23 Well that's why Dr Drum was created, it's the first software that's been designed for ease of use without compromising on quality or features. Unlike other software you will be banging out your first beats within minutes of downloading it and best of all it costs WAY less. http://tinyurl.com/DRDRUM23 Head over there now and check it out for yourself. software to make beats, make a beat software, software make beats, the best beat making software, make beats software, make beat software, software for making beats, making beats software, beats making software, make drum beat, dr drum beat, creating drum beats, dr drum software, dr drum beat making, the best beat maker software, making beats program, program for making beats, creating beats software, make beats program, software to create beats, dr beat software, create beats software, beats making program, making beats programs, beats creating software ["Music", "Musical instrument", "Dubstep", "Drum machine", "Hip hop music", "Electronica"] ["dubstep song", "synth sounds", "programmed percussion", "hand claps", "booming bass", "no voice", "instrumental", "slow tempo"] 0 OyRtTtTSXuM 2486

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;