musiccaps_details (view)

1 row where musiccaps_aspects contains "chasing sou dsl", musiccaps_aspects contains "haunting", musiccaps_aspects contains "huffing and puffing" and musiccaps_aspects contains "string section playing"

✎ 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
Nike Running Commercial - Scary The song is an instrumental with sounds of a woman screaming and running with huffing and puffing sounds. A chainsaw buzzes ominously , with a string section playing a scary and tense accompaniment along with a cello building the tension with a poignant harmony. The music is a horror movie soundtrack or an ad jingle. The song audio quality is very poor. 2006-05-21T17:10:24Z Shadow tiger void killer Commercial for Nike running, why sport? you'll live longer! ["Music", "Run"] ["oman screaming", "running sounds", "chainsaw buzzing", "chase sequence sounds", "string section playing", "dangerous", "tense music", "cellos playing tense lower harmony", "female screaming sounds", "horror movie soundtrack", "ad jingle", "unsettling", "haunting", "murderous theme", "poor audio quality", "huffing and puffing", "drums playing furiously", "chasing sou dsl"] 1 GX-QhoihLeI 1732

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;