musiccaps_details (view)
1 row where musiccaps_aspects contains "background sfx", musiccaps_aspects contains "horror", musiccaps_author = 5 and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Hell - Halloween Horror - Scary Sounds and Music - Halloween Sound Effects | This is an ambience track that features a burning flame sound effect. The atmosphere is scary and horror-like. You could hear this track as a background on a halloween event. | 2014-09-10T17:03:35Z | Halloween Sounds | Stream the full Halloween album here!! ⬇⬇⬇ Apple Music: http://bit.ly/ultimate-horror Spotify: http://bit.ly/halloween-spot Amazon: http://bit.ly/halloween-am Official Website - http://halloween-sounds.com Our Halloween productions have been featured on BBC Radio 4, BBC World service, and is regularly used at theme parks and horror installations around the world. Wild flames crackle as poor souls yell and cry. The beast roars and breaths fire upon these tormented souls in this big horror soundscape. Another useful party background ambiance. #halloween #scary #halloweensounds | ["Music", "Trickle, dribble", "Scary music"] | ["scary", "ambience", "background sfx", "burning flame", "horror"] | 5 | GAohd8KvONo | 1697 |
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;