musiccaps_details (view)
1 row where musiccaps_aspects contains "psychedelic music", musiccaps_aspects contains "single note", musiccaps_aspects contains "trance music" and musiccaps_aspects contains "vocalisation"
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
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;