musiccaps_details (view)
1 row where musiccaps_aspects contains "scary atmosphere" and musiccaps_names contains "House music" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 4 ✖
- scary atmosphere · 1 ✖
- synth drone/pad 1
- water dropping 1
- whispering voice 1
musiccaps_names (array) 3 ✖
- House music · 1 ✖
- Music 1
- Scary music 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Scary Halloween Music for Haunted House | Horror Sounds & Creepy Dark Music | Synthesizers are playing pads/drones in the mid-range. You can hear water tripping sounds with a lot of reverb. A creepy voice is whispering. This song may be playing in a horror movie-scene. | 2014-10-28T23:30:01Z | MeditationRelaxClub - Sleep Music & Mindfulness | ► Get more Scary Music album on iTunes: https://itunes.apple.com/us/album/halloween-halloween-haunted-house-party-music-scary/id1164431772 ► Join my website http://meditationrelaxclub.com/ Ready for Halloween 31st October 2014? Are you planning a Spooky Halloween Party? This is the perfect soundtrack to frighten all your friends: Vampires, Monsters, Ghosts and Zombie, Creepy Sounds, Dark Halloween Music, Cemetery Steps and Suspense ► Visit our social medias: Facebook: https://www.facebook.com/MeditationRelaxClub Twitter: https://twitter.com/MeditationRClub, Pinterest: http://www.pinterest.com/meditationrelax/, Google+: http://plus.google.com/+meditationrelaxclub/ MeditationRelaxClub, the world of free relaxation and music provides your free relaxing music and intrumental music video with sleep music, spa music, study music, yoga music for your yoga poses, pilates music for breathing exercises. Find out more soft music to help you relax and maybe sleep, too if you have some sleep disorders. It provides you background ambient music and radio lounge and chill out music to relax or for cocktail lounge parties. Have fun and begin your relaxation. | ["House music", "Music", "Scary music"] | ["scary atmosphere", "water dropping", "whispering voice", "synth drone/pad"] | 6 | smU92Nu0FmY | 4978 |
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;