musiccaps_details (view)
13 rows where musiccaps_aspects contains "electronic dance music" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 60 ✖
- electronic dance music · 13 ✖
- electronic drums 9
- energetic 7
- danceable 6
- synth 5
- dance 4
- loud 4
- repeated theme 4
- strong bass 4
- club music 3
- drum & bass 3
- upbeat 3
- urban 3
- female vocal sample 2
- groovy 2
- hollering sample 2
- house 2
- instrumental 2
- keyboard 2
- male vocal sample 2
- melodic pad 2
- modern sounding 2
- no singer 2
- pad 2
- rave 2
- synth bass 2
- aggressive 1
- ambient synth 1
- bass 1
- bells 1
- breakbeat 1
- chill 1
- deep house 1
- disco 1
- eerie 1
- electric guitar 1
- electronic percussion 1
- fast-tempo electronic drums 1
- female vocals 1
- female voice sample 1
- fuzzy bass 1
- hip 1
- house music 1
- hyperactive 1
- loud electronic drums 1
- male voice sample 1
- melbourne shuffle 1
- melodic singing 1
- melodic singing keyboard 1
- piano 1
- scratching 1
- shuffle 1
- sound effects electronic drums 1
- strings 1
- techno 1
- techno trance 1
- trippy 1
- very fast tempo 1
- vibrant 1
- vigorous 1
musiccaps_names (array) 18 ✖
- Music 12
- Drum and bass 4
- Disco 3
- Dubstep 3
- Electronic dance music 3
- Electronic music 2
- House music 2
- Shuffle 2
- Techno 2
- Electronica 1
- Happy music 1
- New-age music 1
- Rapping 1
- Scratch 1
- Scratching (performance technique) 1
- Skateboard 1
- Tire squeal 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;