musiccaps_details (view)

1 row where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "psychedelic music", musiccaps_aspects contains "trippy music", musiccaps_aspects contains "vocalisation" 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
Contagious Yawning Empathy Test This music is an electronic instrumental.the tempo is slow and monotone with synthesiser arrangements. The harmony is monotone with sounds of an ambulance siren, sighing or yawning in the background. The music is trippy, trance like, hallucinatory and psychedelic. 2012-04-07T18:03:57Z sonicdriftuk It has long been known that yawning is contagious among humans. Scientific studies have started to link contagious yawning with the emotional response known as empathy. Try watching this short video and count how many times you yawn. For more information about what this could mean, visit our website at www.whydoweyawn.co.uk ["Background music", "Music", "Ambient music"] ["instrumental", "slow tempo", "synthesiser articulation", "hallucinatory", "single note", "keyboard", "monotone harmony", "sound of ambulance", "sound of sighing", "yawning", "vocalisation", "trippy music", "trance music", "psychedelic music", "sound of gunshot"] 7 dLUobee5JEs 3776

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;