musiccaps_details (view)

1 row where musiccaps_aspects contains "orchestral music", musiccaps_names contains "Music" and musiccaps_names contains "Sonar"

✎ 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
Ratchet and clank (Soundtrack): Veldin In Peril This game music starts off with the sound of something that sounds like the fading sound of a giant's footsteps. An orchestral sound plays as well and the sounds take a pause while electronic percussion is played. This song can be played in a game lobby. 2008-10-16T20:49:30Z flamekeepr I don't own this music. The rights to the game and its music all belong to the its makers. Yep this is the last one i'm doing for the first game. If you can't find a specific song while looking throguh my videos.... chances are i couldn't make one for that song. It is unavailable to me and you'll have to find it elsewhere. Now time for me to move onto music from the second game! ["Music", "Sonar"] ["game song", "electronic music", "no voice", "slow tempo", "build up to climax", "orchestral music"] 0 oZrMoZeJ8Ng 4644

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;