musiccaps_details (view)
2 rows where musiccaps_aspects contains "catchy vocal riff" and musiccaps_aspects contains "dj mixer" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- catchy vocal riff · 2 ✖
- dj 2
- dj mixer · 2 ✖
- fast tempo 2
- instrumental 2
- amateur recording 1
- ambient sounds 1
- catchy riff 1
- clapping 1
- club music 1
- disco 1
- electro pop 1
- fans cheering 1
- fourth world music 1
- futuristic 1
- heavily synthesised music 1
- hypnotic 1
- hysteria 1
- live audience 1
- live performance 1
- muffled audio 1
- outdoor performance 1
- people singing 1
- phonograph record 1
- psychedelic 1
- repetitive 1
- rotating platform 1
- scratching 1
- synth pop 1
- techno music 1
- thumping beats 1
- trance 1
- turn table 1
- vinyl disc 1
- vocalisation 1
musiccaps_names (array) 4 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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;