musiccaps_details (view)

1 row where musiccaps_aspects contains "game song", musiccaps_aspects contains "suspenseful mood", musiccaps_names contains "Scary music" and musiccaps_names contains "Theme music"

✎ 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
Resident Evil Outbreak Music 2 Character Select Screen This instrumental song features a deep bass sound that is playing continuously in the background. A piano sequence is played which gives this song an eerie and suspenseful feel. A layer of synth swells are played when the piano sequence is played. At the end, high pitch sounds are played in the background at a low volume as if the sound source is far away from the mic. The mood of this song is suspenseful as if there is impending danger. This song can be played in the lounge of a video game. 2008-10-16T19:04:30Z ResidentEvilOB From the soundtrack ["Theme music", "Music", "Scary music"] ["ambient song", "synth layers", "piano sound", "game song", "no voices", "instrumental", "suspenseful mood", "slow tempo", "no percussion"] 0 zPMiMXCazAI 5472

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;