musiccaps_details (view)

1 row where musiccaps_aspects contains "trippy", musiccaps_names contains "Drum machine", musiccaps_names contains "Electronica" and musiccaps_names contains "Synthesizer"

✎ 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
Make your own dubstep beats fast and easy - Try the software today This is a simple dubstep piece. Electronic drums and percussion are played at the rhythmic background at 120 BPM. There is a high-pitched synth and a fuzzy synth bass playing a simple melody. The all-around quality of the sounds are a bit old-fashioned, reminiscing of the early 2000s. The piece has a danceable, trippy feel to it. It could be used in a retro-themed venue. 2013-12-30T09:53:19Z Nanette Arenivas http://tinyurl.com/lruc8hy Make your own dubstep beats fast and easy - Try the software today Today audio fidelity and clarity is more important than ever before, since just about everybody has speakers or a set of headphones with which the difference is clearly noticeable. Artists can't get away with settling for whatever is "good enough" anymore, because the only thing good enough now is the absolute best. ["Music", "Techno", "Dubstep", "Drum machine", "Synthesizer", "Electronica"] ["dubstep", "electronic drums", "electronic percussion", "synth bass", "sound effects", "high-pitched synth", "lo-res", "mid-tempo", "trippy", "fuzzy", "dance"] 9 SkIDF7iNJQE 2785

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;