musiccaps_details (view)

1 row where musiccaps_aspects contains "electro", musiccaps_aspects contains "punchy kick", musiccaps_aspects contains "reverberant reversed piano melody" and musiccaps_aspects contains "shimmering hi hat"

✎ 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
EvenS - News [Free Download] The Electro song features a reverberant reversed piano melody and synth bass with a modulated filter effect on it, over which there is a white noise riser that leads into the short snippet of drop that consists of layered punchy kick and shimmering hi hat. Right before the drop, there is a filtered, echoing male vocal too. It sounds emotional and exciting. 2012-03-04T16:00:07Z 17tumba Some fresh talent from Norway :) Utterly beautiful stuff... EvenS - News [Free Download] Follow EvenS here: http://www.facebook.com/pages/EvenS/107088966080022?ref=ts http://soundcloud.com/evens (Download) http://www.youtube.com/user/EvenSofficial The visualizer/equalizer is made by Mocarg: http://www.youtube.com/user/mocarg Stalk me: Facebook http://www.facebook.com/17tumbaMusic Twitter: https://twitter.com/#!/17tumba YouTube http://www.youtube.com/user/17tumba Soundcloud http://soundcloud.com/17tumbaFollow me on facebook: http://full.sc/1djiYtN Follow 17tumba on Goole+ https://www.google.com/+17tumbaOfficial Follow Elevate Sounds: https://www.facebook.com/17tumba https://soundcloud.com/17tumba https://plus.google.com/+17tumbaOfficial Second/backup channel: https://www.youtube.com/user/17tumbaMusic ▼All Elevate Sounds uploads in playlists▼ Latest (Uploads 600-800) https://www.youtube.com/playlist?list=PL8TWxe78E9Wvic0-RjHRzwEcaQXuaGJQn Uploads 400-600: https://www.youtube.com/playlist?list=PL71FE81BCCA633E53 Uploads 200-400: https://www.youtube.com/playlist?list=PLDF43E25745757558 Uploads 1-200: https://www.youtube.com/playlist?list=PL60038DE2D1B1A21C ["Singing bowl"] ["reverberant reversed piano melody", "filtered synth bass", "white noise riser", "filtered echoing male vocal", "exciting", "punchy kick", "shimmering hi hat", "emotional", "electro"] 4 UkqayNnk00w 2941

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;