musiccaps_details (view)
21 rows where musiccaps_aspects contains "eerie" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 110 ✖
- eerie · 21 ✖
- instrumental 10
- bizarre 6
- sound effects 6
- electronic drums 5
- synth 5
- piano 4
- electronic 3
- noise 3
- repeated theme 3
- theremin 3
- uneasy 3
- weird 3
- contemporary 2
- eccentric 2
- electronic music 2
- electronic percussion 2
- glitch 2
- loud 2
- mysterious 2
- no singer 2
- robotic 2
- unsettling 2
- upbeat 2
- acapella 1
- acoustic drums 1
- ad-libs 1
- ambient synth 1
- analog sounding 1
- bass 1
- bass guitar 1
- beep 1
- bells 1
- bleak 1
- breathing 1
- brush 1
- cartoon 1
- cheerful 1
- classical 1
- classical music 1
- computer 1
- computer sounds 1
- dissonant 1
- door creaking 1
- downtempo 1
- drum & bass 1
- electronic dance music 1
- electronic sounding 1
- energetic 1
- enigmatic 1
- experimental rock 1
- female synth vocal 1
- female voice 1
- finger click 1
- flow 1
- gear sounds 1
- gentle playing 1
- glass 1
- granular 1
- harmony singing 1
- haunting 1
- high pitch melody 1
- high pitched sounds 1
- hip-hop 1
- hollering sample 1
- indie rock 1
- instructive 1
- intriguing 1
- irritating 1
- jam 1
- jingle 1
- male vocal 1
- male voice 1
- medium tempo 1
- melodic pad 1
- menacing 1
- mini theremin 1
- minimal techno 1
- movie music 1
- music box 1
- ominous 1
- outer space 1
- pad 1
- peculiar beat 1
- rapping 1
- rising pattern 1
- rising-and-falling 1
- sci-fi 1
- scratching 1
- single instrument 1
- sleigh bells 1
- snare drum 1
- soap opera soundtrack 1
- sound effect 1
- strings 1
- strong bass 1
- swing jazz 1
- synth bass 1
- synth keyboard 1
- tense 1
- toy 1
- transition effect 1
- unique 1
- unnerving 1
- urban 1
- violent 1
- violin 1
- vocaloid 1
- vocoder 1
- water 1
musiccaps_names (array) 37 ✖
- Music 19
- Theremin 4
- Background music 3
- Ambient music 2
- Electronica 2
- Sonar 2
- Vocal music 2
- A capella 1
- Bass drum 1
- Beep, bleep 1
- Bell 1
- Cash register 1
- Chink, clink 1
- Cymbal 1
- Drum 1
- Drum and bass 1
- Drum kit 1
- Dubstep 1
- Electronic music 1
- Fill (with liquid) 1
- Happy music 1
- Hi-hat 1
- Hip hop music 1
- Musical instrument 1
- New-age music 1
- Percussion 1
- Rimshot 1
- Sampler 1
- Scary music 1
- Scratch 1
- Scratching (performance technique) 1
- Snare drum 1
- Speech 1
- Synthesizer 1
- Techno 1
- Tick 1
- Trance music 1
0 records
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;