musiccaps_details (view)
2 rows where musiccaps_aspects contains "fast tempo", musiccaps_names contains "Disco" and musiccaps_names contains "Dubstep"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- fast tempo · 2 ✖
- ambient music 1
- backing vocals 1
- club music 1
- dance music 1
- dance pop 1
- digital drumming 1
- digital drums 1
- dj 1
- dj mixer 1
- edm 1
- electronic music 1
- electronica 1
- hardcore 1
- high energy 1
- house music 1
- hypnotic 1
- instrumental 1
- male voice singing/rapping 1
- organ 1
- pad sounds 1
- progressive trance 1
- psychedelic 1
- psytrance 1
- repetitive beats 1
- synth lead 1
- synthesiser arrangement 1
- tech trance 1
- techno 1
- techno pop 1
- …
musiccaps_names (array) 8 ✖
- Dance music 2
- Disco · 2 ✖
- Dubstep · 2 ✖
- Music 2
- Electronic dance music 1
- Hip hop music 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 |
---|---|---|---|---|---|---|---|---|---|---|
Snap Crackle Pop (Tankypookins Remix) | The kick is playing on every beat along with a fast paced high hat and a snare sound. The digital bass is adding some spice and sounds overdriven. Pad sounds can be heard in the background while a synth lead sound is playing a simple repetitive melody. A male voice is rapping/singing. A lot of backing vocals with delay are adding energy to the mix. This song may be playing in a car. | 2011-12-02T03:59:40Z | Logan Smith | Ice Ice Ice Ice Cream Soda Pop, Let Me See Them Chains Drop! Trip to Norway, Dance team, and I decided to do a little Dubstep remix of the song they were using. The song is, though silly, about the Lord Jesus breaking chains off of our lives. Lemme hear an Amen if you've experienced THAT! You can download this track at http://tank2.bandcamp.com/track/snap-crackle-pop-tankypookins-remix. Thanks all! | ["Disco", "Music", "Techno", "Trance music", "Dubstep", "Dance music", "Hip hop music"] | ["techno/pop", "digital drums", "synth lead", "organ", "pad sounds", "male voice singing/rapping", "backing vocals", "fast tempo"] | 6 | -qcTD2o6I9s | 89 | |
TECKTONIK vs SHUFFLE.. | This music is an electronic instrumental. The tempo is fast with synthesiser arrangements, electronic beats , Dj mixer and a repetitive vocal riff. The music is incessant, psychedelic, hypnotic, trippy and trance like with a dance groove. This music is Techno Pop/EDM. | 2010-05-01T19:39:05Z | cireduard | hermano vs hermano familia TELLO | ["Disco", "Music", "Dubstep", "Electronic dance music", "Dance music"] | ["instrumental", "fast tempo", "electronic music", "house music", "progressive trance", "repetitive beats", "high energy", "tech trance", "ambient music", "hardcore", "psytrance", "edm", "electronica", "techno", "techno pop", "trippy", "trance droning", "dance pop", "psychedelic", "vocal riff", "dance music", "club music", "dj", "dj mixer", "digital drumming", "synthesiser arrangement", "hypnotic", "trance music", "trippy", "youthful"] | 7 | ITg9o6Gwsbo | 1910 |
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;