musiccaps_details (view)
2 rows where musiccaps_aspects contains "catchy vocal riff", musiccaps_aspects contains "electro pop" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- catchy vocal riff · 2 ✖
- dj 2
- electro pop · 2 ✖
- instrumental 2
- amateur recording 1
- ambient sounds 1
- boomy bass drops 1
- buoyant 1
- clapping 1
- club music 1
- dance groove 1
- dance music 1
- distorted music 1
- distorted sound 1
- dj mixer 1
- edm 1
- electro rock 1
- fans cheering 1
- fast tempo 1
- female vocals 1
- fourth world music 1
- futuristic 1
- heavily synthesised music 1
- high strung 1
- hypnotic 1
- hysteria 1
- inferior sound quality 1
- live audience 1
- live performance 1
- muffled audio 1
- outdoor performance 1
- party music 1
- people singing 1
- psychedelic 1
- punchy youthful 1
- synth pop 1
- synthesiser arrangements 1
- techno music 1
- trance 1
- vibrant 1
- vocalisation 1
musiccaps_names (array) 9 ✖
- Music 2
- Disco 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- House music 1
- Shuffle 1
- Techno 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dada Life - Just BLEEP Me | This music is an upbeat instrumental. The tempo is fast with vigorous digital drumming, synthesiser arrangements and DJ mixer effects. The music is electrifying, pulsating, buoyant, punchy, groovy, youthful and high-spirited. This music is an outdoor live performance with ambient sounds. There are sounds of hysterical fans cheering, clapping and singing along. This music is Futuritic Electronic Pop/ Techno Pop. | 2011-07-19T03:10:45Z | janjubear | Dada Life @ EBC 7.17.11 | ["Disco", "Music"] | ["instrumental", "fast tempo", "dj", "dj mixer", "futuristic", "fourth world music", "psychedelic", "hypnotic", "vocalisation", "catchy vocal riff", "techno music", "hysteria", "live performance", "live audience", "outdoor performance", "ambient sounds", "people singing", "fans cheering", "clapping", "muffled audio", "amateur recording", "heavily synthesised music", "electro pop", "synth pop", "trance"] | 7 | 3zT0aiN2E70 | 526 | |
endless squad SHUFFLE | A female vocalist sings this high energy pop song. The tempo is fast with vigorous drumming, synthesiser arrangements and boomy bass drops. The song is vibrant, lively, spirited, buoyant, punchy and youthful with a catchy vocal riff. The sound quality of this song is inferior and distorted. This song is an EDM/Synth Pop song. | 2011-08-12T07:05:36Z | omingendless | ["Drum and bass", "House music", "Music", "Techno", "Trance music", "Shuffle", "Dubstep", "Electronic dance music"] | ["instrumental", "vibrant", "high strung", "female vocals", "punchy youthful", "dance groove", "inferior sound quality", "distorted sound", "catchy vocal riff", "electro rock", "electro pop", "edm", "distorted music", "synthesiser arrangements", "dj", "dance music", "party music", "club music", "vibrant", "buoyant", "boomy bass drops"] | 7 | YWf3I4jKusI | 3291 |
Advanced export
JSON shape: default, array, newline-delimited
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;