musiccaps_details (view)
2 rows where musiccaps_aspects contains "haunting music" and musiccaps_author = 3
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- haunting music · 2 ✖
- cinematic music 1
- door knocking 1
- high pitched humming instrument 1
- high pitched sound 1
- horror 1
- live recording 1
- mysterious music 1
- ominous music 1
- piano melody 1
- poor audio quality 1
- siren 1
- sombre tone 1
musiccaps_names (array) 3 ✖
- Music 1
- Scary music 1
- Singing bowl 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Red Road | This is a live recording with low audio quality. It seems like the kind of music that would feature in a sombre, mysterious, and perhaps haunting movie. The instruments are layers of sustained, high-pitched synths. | 2007-03-30T03:06:50Z | Joey B | An atmospheric and intense thriller about pain and retribution which finds Jackie, a Glasgow CCTV (surveillance) operator watching over a small part of the world, protecting the people living their lives under her gaze. One day a man appears on her monitor, a man she thought she would never see again, a man she never wanted to see again. Now she has no choice, she is compelled to confront him. MySpace.com/RedRoadFilm | ["Singing bowl"] | ["haunting music", "cinematic music", "high pitched sound", "live recording", "poor audio quality", "high pitched humming instrument", "sombre tone"] | 3 | 577NM64YL18 | 634 | |
Mine Nights at Freddy's Factory Teaser Trailer [FNAF Minecraft Roleplay] | This is an ominous, haunting, mysterious track which would do well in a horror movie or game. There's a chilling piano motif, some knocking sounds and a low sustained synth that almost sounds like orchestral cello. | 2015-09-12T22:08:17Z | CavemanFilms | Coming soon to a factory near you. MAJOR THANKS TO THE IRON COMMANDER FOR WORKING WITH ME AND ANT ON THIS MAP! HE'S AMAZING AND YOU SHOULD CHECK HIM OUT http://www.minecraftforum.net/members/TheIronCommander • Subscribe and become a Dweller! : http://bit.ly/1eHHPKa • Check me out on Twitter! : http://www.twitter.com/CavemanFilms • I'm on Instagram also! : http://instagram.com/cavemanfilmsyt • If you'd like to send fanmail or something send it to: CavemanFilms/ Dan PO Box 134 Fletcher, North Carolina 28732 • Beautiful Dweller Merchandise! US: http://cavemanfilms.spreadshirt.com/ EU: http://cavemanfilms.spreadshirt.eu/ If you enjoyed the video please feel free to like, favorite and subscribe! | ["Music", "Scary music"] | ["ominous music", "haunting music", "mysterious music", "door knocking", "piano melody", "siren", "horror"] | 3 | dakJh2CdT9Q | 3797 |
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;