musiccaps_details (view)

1 row where musiccaps_aspects contains "acoustic kick", musiccaps_aspects contains "synthpop" and musiccaps_names contains "Music of Africa"

✎ 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
City Of Night (Miracle Of Sound Music Video) A male voice is singing with a mid-melody. Different synthesizer sounds are playing arpeggios being used as bassline and other sounds as melody in the mid range and higher register. An acoustic sounding kick is playing on every beat. This song may be playing in a synth retro movie. 2013-05-25T13:36:57Z Jevanimation So basically I was doing my final major project in college and long story short I had to drop my first film idea with 3 weeks until the deadline. So after finding out I couldn't afford the flight to Mexico I decided yo make an animation. After 3 weeks (I think) this is what I ended up with. I know the animation is a bit rough but it was a bit rushed towards the end because I'm lazy and didn't do much in the first two weeks. But anyway, huge thanks to Miracle Of Sound for letting me use this track, if you haven't heard his music look him up on youtube he makes awesome game and movie related original songs. Hope you guys enjoy :) Also kudos for actually reading all the description, what a kind soul! ["Music of Africa", "Music", "Tender music"] ["synthpop", "male singer", "mid-range", "synthesizer sounds", "arpeggios", "acoustic kick", "medium tempo"] 6 nc6h6rC3wdk 4564

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;