musiccaps_details (view)
8 rows where musiccaps_aspects contains "electronic music" and musiccaps_aspects contains "sinister"
This data as json
musiccaps_aspects (array) 108 ✖
- electronic music · 8 ✖
- sinister · 8 ✖
- instrumental 7
- intense 6
- scary 5
- eerie 4
- medium tempo 4
- spooky 4
- dark 3
- futuristic 3
- synthesiser arrangements 3
- synthesiser articulation 3
- ambient 2
- booming 2
- dangerous 2
- electro pop 2
- horror 2
- mysterious 2
- psychedelic 2
- slow tempo 2
- suspenseful 2
- techno 2
- video game music 2
- alien 1
- alternative rock 1
- amateur music 1
- ambient scary sounds 1
- ambient sounds 1
- angry voice 1
- anticipation 1
- anticipatory 1
- atmospheric synthesiser 1
- backup vocal harmony 1
- bell 1
- boomy 1
- burgeoning 1
- buzzing 1
- buzzing electric circuit 1
- cello 1
- child’s voice 1
- chilling 1
- collapsing 1
- creepy 1
- cymbal ride 1
- danger 1
- dark night 1
- didgeridoo harmony 1
- droning 1
- droning harmony 1
- dungeon 1
- echoes 1
- elecronica 1
- electricity 1
- electronic sounds 1
- electronic techniques 1
- enigmatic 1
- ethereal 1
- fading 1
- falling 1
- foreign language 1
- fourth world music 1
- gentle breeze 1
- german 1
- goth 1
- gothic ambience 1
- grim 1
- hair-raising 1
- heavy rain 1
- horror film music 1
- hypnotic 1
- industrial rock 1
- intimidating 1
- lightening 1
- loud 1
- menacing sounds 1
- metal clanging 1
- metal clanging rhythmically 1
- metal swiping 1
- multiple layers 1
- rain storm 1
- roaring 1
- slow footsteps 1
- sound of rain 1
- sound of whirring engine 1
- storm 1
- stringed instrument riff 1
- suspense 1
- swiping sound 1
- synth pop 1
- synthesised sounds 1
- techno pop 1
- tense 1
- thrilling 1
- thunder 1
- thunder storm 1
- trance 1
- trance music 1
- trap 1
- trippy 1
- two tracks 1
- unnerving 1
- unrelated 1
- vocalisation 1
- water flowing 1
- whistling 1
- whooshing sound 1
- wind howling 1
- xbox 1
musiccaps_names (array) 15 ✖
- Music 8
- Scary music 3
- Rumble 2
- Boom 1
- Buzz 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- Electronica 1
- Inside, small room 1
- Silence 1
- Soundtrack music 1
- Speech 1
- Techno 1
- Theremin 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;