musiccaps_details (view)

1 row where musiccaps_aspects contains "electronic music", musiccaps_aspects contains "programmed song", musiccaps_names contains "Effects unit" 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
Dark Sad Emotional Ambient Electronic Cinematic Music This electronic music features no voices. All the parts of this song are programmed. The main melody is played by a simulated plucked instrument. This is accompanied by electronic sounds in the background sounding like an alien spaceship. There are ambient sounds in the background filling the musicscape. The song has an ambient feel. This song can be played in a movie where there is travel to outer space. 2012-12-31T08:23:36Z Digital Flashback Check out my new dark & mystical composition here: https://www.youtube.com/watch?v=Y50xrA6_GsQ ►TRACK: Phantom ►COMPOSER: Digital Flashback Buy Music | Albums | Untagged Beats (not for profit): http://digitalflashback.bandcamp.com/ Web | Beat Store | Blog | Music Libraries: http://www.digitalflashbackmusic.com/ Follow Me: ►Facebook: https://www.facebook.com/DigitalFlashback ►Soundcloud: https://soundcloud.com/digital-flashback ►Twitter: https://twitter.com/DomDigiFlash ►Google Plus: https://plus.google.com/+DigitalFlashbackBeats For all purchase inquiries including buying rights to beats please contact: info@digitalflashbackmusic.com Stay tuned and SUBSCRIBE If you like my channel! Thanks for all of your support! ["Effects unit", "Music", "Ambient music", "Electronica"] ["electronic music", "synth music", "instrumental", "no voices", "ambient sounds", "moderate tempo", "plucked instrument", "programmed song"] 0 yhS-6Y8ToR8 5430

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;