musiccaps_details (view)
10 rows where musiccaps_aspects contains "digital drums" and musiccaps_aspects contains "electronic music"
This data as json
musiccaps_aspects (array) 149 ✖
- digital drums · 10 ✖
- electronic music · 10 ✖
- buoyant 6
- club music 6
- edm 6
- youthful 6
- dance music 5
- fast tempo 5
- instrumental 5
- psychedelic 5
- electronica 4
- techno music 4
- trap 4
- trippy 4
- dj 3
- drum machine 3
- energetic 3
- lively 3
- male vocalist 3
- punchy 3
- synth pop 3
- synthesiser arrangement 3
- ambient 2
- dance groove 2
- dance pop 2
- digital music 2
- dj mixer 2
- enthusiastic 2
- futuristic 2
- happy 2
- hip-hop 2
- hypnotic 2
- medium tempo 2
- pop 2
- rap 2
- spirited 2
- synthesiser arrangements 2
- synthesiser articulation 2
- techno pop 2
- trance 2
- amplified 1
- animate 1
- animated 1
- animated instrumentation 1
- atmospheric synthesiser 1
- auto tune 1
- auto tuned voice 1
- baarat music 1
- boomy bass lines 1
- brass band 1
- burgeoning music 1
- camera roll sound 1
- cello drone 1
- chanting 1
- cheerful 1
- club 1
- contemporary indian music 1
- dance hits 1
- deep house 1
- dholak 1
- dissonant 1
- drum rhythm 1
- drums 1
- duet 1
- electrifying 1
- electro pop 1
- electro-hop 1
- electronic articulation 1
- electronic instrumental 1
- electronic instrumentation 1
- electronic tech 1
- electronically 1
- enigmatic 1
- female vocal backup 1
- female vocal riff 1
- female vocals 1
- female voice talking 1
- fourth world music 1
- garage 1
- goth rock 1
- groovy 1
- heavily synthesised 1
- high notes 1
- high pitched 1
- high-spirited 1
- house 1
- house music 1
- indian ceremonial band 1
- indian music 1
- indian percussions 1
- indian wedding 1
- insistent 1
- jungle bells 1
- keyboard accompaniment 1
- laughing 1
- lively singing 1
- lively trumpet 1
- loud 1
- male vocalists 1
- male voice talking 1
- medium fast tempo 1
- merry 1
- nagpada 1
- new age music 1
- new-age 1
- new-wave 1
- north indian wedding music 1
- oud cymbals 1
- party music 1
- passionate 1
- peppy 1
- pop rap 1
- pop rock 1
- progressive 1
- propulsive beats 1
- pulsating 1
- punchy beats 1
- raper 1
- rave 1
- remix 1
- repetitive 1
- reverb 1
- rhythmic 1
- rhythmic patter 1
- shakers 1
- sighing 1
- slick drumming 1
- slow beginning 1
- slow tempo 1
- soft paino 1
- song beginning 1
- southern hip hop 1
- steady rhythm 1
- superimposed speech 1
- syncopated 1
- syncopated background harmony 1
- synth arrangements 1
- techno hop 1
- techno remix 1
- trumpets 1
- unconventional 1
- upbeat 1
- vibrant 1
- vigorous 1
- vigorous drumming 1
- vocal backup 1
- vocal riff 1
- vocalising 1
- whirring sound 1
musiccaps_names (array) 16 ✖
- Music 10
- Electronic music 4
- Dubstep 2
- Hip hop music 2
- Techno 2
- Trance music 2
- Burst, pop 1
- Drum and bass 1
- Electronic dance music 1
- Electronica 1
- House music 1
- Jingle (music) 1
- Sigh 1
- Ska 1
- Soundtrack music 1
- Zing 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;