musiccaps_details (view)
3 rows where musiccaps_aspects contains "hardcore", musiccaps_aspects contains "techno" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Miss K8 - No More Jokes | This is a hardcore techno music piece. There is an extremely strong, ear-piercing bass sound. The rhythmic background is a fast-paced and loud electronic drum beat. The atmosphere is violent. This piece could be played at rave sets. | 2012-05-07T14:23:35Z | Miss K8 | Official website: http://djmissk8.com Follow Miss K8 on: http://facebook.com/MissK8music http://youtube.com/MissK8music http://twitter.com/MissK8music http://soundcloud.com/MissK8 | ["Music", "Angry music"] | ["techno", "hardstyle", "hardcore", "extremely strong bass", "loud electronic drums", "aggressive", "violent", "excessive", "fast tempo"] | 9 | Xe59DpKa-O4 | 3205 | |
Swifty Incredible Warrior Tricks 3 (Part 1 of 4) | This is hardcore electronic music piece. The rhythmic background consists of a fast tempo electronic drum beat with a crisp sound. There is an aggressive fuzzy bass. The atmosphere is energetic. This piece could be used in the soundtrack of a mobile car racing game. | 2011-05-02T03:33:06Z | Павел Степанищев | Swifty is awesome! This is my favorite Incredible Warrior Tricks! | ["Music", "Angry music"] | ["hardcore", "techno", "crisp electronic drums", "strong bass", "aggressive", "loud", "violent", "energetic", "fast tempo"] | 9 | g-ZOluGhMoA | 3998 |
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;