musiccaps_details (view)
3 rows where musiccaps_aspects contains "catchy vocal riff", musiccaps_aspects contains "dj" and musiccaps_aspects contains "instrumental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 50 ✖
- catchy vocal riff · 3 ✖
- dj · 3 ✖
- instrumental · 3 ✖
- club music 2
- dj mixer 2
- electro pop 2
- fast tempo 2
- amateur recording 1
- ambient sounds 1
- boomy bass drops 1
- buoyant 1
- catchy riff 1
- clapping 1
- dance groove 1
- dance music 1
- disco 1
- distorted music 1
- distorted sound 1
- edm 1
- electro rock 1
- fans cheering 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
- phonograph record 1
- psychedelic 1
- punchy youthful 1
- repetitive 1
- rotating platform 1
- scratching 1
- synth pop 1
- synthesiser arrangements 1
- techno music 1
- thumping beats 1
- trance 1
- turn table 1
- vibrant 1
- vinyl disc 1
- vocalisation 1
musiccaps_names (array) 11 ✖
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 | |
DJ Sara - Scratch Practice 【2015】 | This music is a youthful instrumental. The tempo is fast with a DJ using a turntable to manipulate sounds and music on a turntable using vinyl records. The music has a repetitive, catchy vocal riff , thumping beats and scratching sounds. | 2015-07-30T05:03:51Z | djsararyusei scratch | Sara (16 years old) | ["Scratching (performance technique)", "Beatboxing", "Music"] | ["instrumental", "fast tempo", "turn table", "thumping beats", "catchy vocal riff", "repetitive", "rotating platform", "phonograph record", "vinyl disc", "disco", "club music", "catchy riff", "dj", "dj mixer", "scratching"] | 7 | Cd7JefC6-Zw | 1384 | |
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;