musiccaps_details (view)
16 rows where musiccaps_aspects contains "aggressive" and musiccaps_aspects contains "instrumental"
This data as json
musiccaps_aspects (array) 150 ✖
- aggressive · 16 ✖
- instrumental · 16 ✖
- heavy metal 6
- loud 6
- no singer 6
- electric guitar 5
- fast tempo 5
- acoustic drums 4
- electronic music 4
- bass guitar 3
- boisterous 3
- distorted electric guitar 3
- guitar solo 3
- hard-hitting 3
- intense 3
- video game music 3
- violent 3
- chaotic 2
- dangerous 2
- death metal 2
- energetic 2
- goth 2
- goth rock 2
- hard rock 2
- harsh 2
- keyboard harmony 2
- medium fast tempo 2
- pulsating 2
- shooting 2
- shredding 2
- sinister 2
- sonic power 2
- synthesiser arrangements 2
- vigorous drumming 2
- abrupt change 1
- amateur recording 1
- amplified 1
- amplified guitar 1
- amplified keyboard harmony 1
- anger 1
- animated 1
- background noises 1
- beeping 1
- beeping melody 1
- belligerent 1
- blasts 1
- bombing 1
- booming sounds 1
- bustling 1
- car sounds 1
- combative 1
- complex 1
- confusion 1
- contrasting aggressive sounds 1
- cover 1
- crunchy 1
- cunfusion 1
- cymbal rides 1
- danger 1
- death core 1
- death industrial 1
- deep growling 1
- destructive 1
- dissonant harmony 1
- distorted bass guitar 1
- distorted voice 1
- dj 1
- dj mixer 1
- dub 1
- eerie 1
- electrifying 1
- electro pop 1
- electro rock 1
- electronic drums 1
- electronic instrumentation 1
- electronica 1
- electropop 1
- empty shells falling 1
- engine 1
- exhaust 1
- extreme 1
- fast-paced 1
- groovy bass line 1
- guitar slide 1
- gunshots 1
- hard hitting drums 1
- hard style 1
- hardcore house 1
- hardcore techno 1
- heavy metalloud feed back 1
- hostile 1
- impactful 1
- jarring 1
- keyboard 1
- live recording 1
- loud acoustic drums 1
- loud electric guitar feedback 1
- loud feedback 1
- low quality 1
- menacing sounds 1
- metal 1
- passionate 1
- persistent 1
- pleasant music 1
- poor audio quality 1
- power electronics 1
- power metal 1
- powerful 1
- progressive metal 1
- punchy drums 1
- punchy snare 1
- punk rock 1
- repeated theme 1
- rhythmic beat 1
- rock 1
- scary 1
- scratching 1
- shimmering hi hats 1
- shimmering open hat 1
- single instrument 1
- siren 1
- smashing 1
- soft kick hit 1
- sound of crashing 1
- sound of guns 1
- spine chilling 1
- spirited 1
- spooky 1
- static 1
- steady drumming 1
- steel guitar 1
- stringed instrument 1
- suspenseful 1
- syncopated melody 1
- synth 1
- synth-pop 1
- synthesiser arrangement 1
- techno 1
- techno music 1
- techno pop 1
- threatening 1
- throbbing 1
- turn table 1
- urgency 1
- vibrations 1
- vigorous 1
- violence 1
- violent aggressive 1
- vital 1
- wide aggressive electric guitar chords 1
musiccaps_names (array) 33 ✖
- Music 15
- Angry music 4
- Cacophony 3
- Guitar 3
- Heavy metal 3
- Musical instrument 3
- Plucked string instrument 3
- Background music 1
- Bass drum 1
- Bass guitar 1
- Breaking 1
- Clatter 1
- Cymbal 1
- Distortion 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Dubstep 1
- Electric guitar 1
- Electronica 1
- Grunge 1
- Hi-hat 1
- Hip hop music 1
- Outside, urban or manmade 1
- Percussion 1
- Progressive rock 1
- Punk rock 1
- Rimshot 1
- Ringtone 1
- Rock music 1
- Snare drum 1
- Synthesizer 1
- Tapping (guitar technique) 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;