musiccaps_details (view)
22 rows where musiccaps_aspects contains "electronic drums" and musiccaps_aspects contains "instrumental"
This data as json
musiccaps_aspects (array) 113 ✖
- electronic drums · 22 ✖
- instrumental · 22 ✖
- no singer 13
- danceable 6
- energetic 5
- electric guitar 4
- electronic 4
- electronic music 4
- repeated theme 4
- sound effects 4
- synth 4
- synth bass 4
- trippy 4
- groovy 3
- jam 3
- keyboard 3
- medium tempo 3
- strings 3
- techno 3
- ambient synth 2
- bass guitar 2
- chill 2
- crisp 2
- dance 2
- downtempo 2
- drum machine 2
- eccentric 2
- electronic dance music 2
- funk 2
- generic 2
- guitar solo 2
- melodic 2
- melodic pad 2
- movie music 2
- pad 2
- piano 2
- upbeat 2
- urban 2
- action-filled 1
- aggressive 1
- airy 1
- amateur sounding 1
- ambient house 1
- bass 1
- bells 1
- booming 1
- brass 1
- brass section 1
- breakbeat 1
- car sounds 1
- cheerful 1
- chopped-up sounds 1
- classical influence 1
- comedy 1
- common 1
- cover 1
- deep house 1
- eerie 1
- effect pedal 1
- electric guitar sound 1
- electro swing 1
- electronic percussion 1
- engine 1
- exhaust 1
- fast tempo 1
- finger tapping 1
- goofy 1
- haunting 1
- high-pitched synth 1
- hip 1
- horrifying 1
- industrial dance 1
- interesting 1
- intriguing 1
- j-pop 1
- jingle 1
- laughing track 1
- live performance 1
- loud 1
- lounge 1
- medium-pitched synth 1
- medium-to-high pitch pad 1
- minimal 1
- modern sounding 1
- neo-soul 1
- outer space 1
- percussive elements 1
- piano sound 1
- ping sound effect 1
- playful 1
- pop 1
- progressive rock 1
- psychedelic 1
- remix 1
- resonating 1
- reverberating 1
- saxophone 1
- strong bass 1
- synth brass 1
- synth keyboard 1
- techno trance 1
- tense 1
- theremin 1
- trumpets 1
- tuba 1
- tv series theme 1
- unique 1
- unnerving 1
- vibrant 1
- vocal sample 1
- weird 1
- wind band 1
- wobbly bass 1
musiccaps_names (array) 36 ✖
- Music 18
- New-age music 4
- Ambient music 3
- Electronica 3
- Electric piano 2
- Electronic music 2
- Keyboard (musical) 2
- Piano 2
- Swing music 2
- Synthesizer 2
- Background music 1
- Brass instrument 1
- Clatter 1
- Computer keyboard 1
- Disco 1
- Drum machine 1
- Dubstep 1
- Electric guitar 1
- Electronic dance music 1
- Guitar 1
- Independent music 1
- Musical instrument 1
- Progressive rock 1
- Rapping 1
- Rattle (instrument) 1
- Rock music 1
- Sampler 1
- Scary music 1
- Scratch 1
- Soul music 1
- Techno 1
- Theme music 1
- Theremin 1
- Tire squeal 1
- Trumpet 1
- Zipper (clothing) 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;