musiccaps_details (view)
2 rows where musiccaps_aspects contains "creepy", musiccaps_aspects contains "haunting" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- creepy · 2 ✖
- haunting · 2 ✖
- low quality 2
- dark tinny bells melody 1
- echoing plucked strings melody 1
- echoing whispering male vocal 1
- haunting whispering female vocal 1
- horror 1
- hypnotic 1
- piano chords 1
- scary 1
- smooth bass guitar 1
- suspenseful 1
- synth pad chords 1
musiccaps_names (array) 5 ✖
- Music 2
- Background music 1
- Scary music 1
- Soul music 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Evil Ed The Haunted, Scary, Creepy, Music Box Clown | The low quality recording features a dark tinny bells melody played over synth pad chords, followed by echoing whispering male and haunting whispering female vocals. It sounds haunting, hypnotic, creepy, scary and like something that belongs to a horror movie. | 2010-06-06T04:27:44Z | Dave Holt D Dada | If you like my work, I really appreciate the support https://www.buymeacoffee.com/DDada Please also subscribe to my channel or share the video With enough pizza's or coffee, I can go out and make more creepy videos. Creepy, evil and scary short clown film. Music and effects by Dave Holt -copyright | ["Music", "Speech", "Scary music"] | ["dark tinny bells melody", "low quality", "echoing whispering male vocal", "haunting whispering female vocal", "synth pad chords", "haunting", "hypnotic", "creepy", "scary", "horror"] | 4 | A-7dmBdsFXc | 1056 | |
Coil with Throbbing Gristle - In My Blood | The low quality recording features piano chords, followed by echoing plucked strings melody and smooth bass guitar. It sounds creepy, haunting and suspenseful. | 2015-02-22T03:20:53Z | Virgil Pink | Dutch Suppliments, 2001 | ["Background music", "Music", "Soul music"] | ["low quality", "piano chords", "echoing plucked strings melody", "smooth bass guitar", "creepy", "haunting", "suspenseful"] | 4 | ZkGQhIbEDrs | 3407 |
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;