musiccaps_details (view)

1 row where musiccaps_aspects contains "sound effects", musiccaps_aspects contains "tick tock" and musiccaps_names contains "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
The Swisscom S5 Pulse Challenge This is the background track of a challenge video. Many sound effects can be heard in procession such as the blood pulse, a metallic impact and clock ticking. Then the piece starts playing with loud synth bass and an electronic drum beat. The aura of the track is unnerving and violent which was the reaction expected in the challenge. Some parts of this track can be used to lift samples for a beat. 2014-06-16T19:52:59Z Swisscom On the 23. May 2014 in Zurich it happened. We choose 30 participants out of more than 1000 visitors, to take a seat on our chair. 150 nervous fingers and one challenge: keep your heartbeat below 100bpm to win a Samsung Galaxy S5. We did our best not to let it happen. Am 23.Mai 2014 in Zürich war es soweit. Wir wählten aus über 1.000 Zuschauern, 30 Teilnehmer aus, die auf unserem Stuhl Platz nehmen durften. 150 nervöse Finger und die einzige Aufgabe: Halte deinen Puls unter 100bpm um ein Samsung Galaxy S5 zu gewinnen. Wir haben unser bestes getan, dies zu verhindern… ["Explosion", "Music"] ["sound effects", "pulse", "impact", "synth bass", "electronic drums", "tick tock", "unnerving", "uneasy", "violent"] 9 HplcVmJhuIc 1838

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;