musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "techno", musiccaps_names contains "Electronica" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Lidless Sound - Simbala Mix2010.12.18. | The Techno track features a punchy "4 on the floor" kick pattern, punchy snare, groovy bass, alongside echoing synth keys, short haunting synth lead and weird percussive sound effects. It is groovy and energetic. | 2011-03-20T11:04:51Z | Lidless Sound | SIMBALA is a Deep Dub and Deep Techno label - Our label is for us a platform for beauty, dance, experimental, and every nuances that the spectrum of music has to offer.For this first EP, we want to share with you who we are, what we love and what we will do. The name of the flight that marked the beginnings of Lidless Sound was naturally chosen. He travels through music to Detroit, Chicago, Berlin and many other places in the world. He wanted to share this ubiquity by choosing artists from around the planet. Naturally, one the main references in the world of deep house and techno was chosen. He created an inspiring abstract dubby remix. Banfield Audio as friends and music lovers were exactly in the vein of the artistic direction of the mix: Deep, deep, deep. Experimented and sensitive, they gave to /Surround me/ an abyssal atmosphere that fits perfectly with the whole . Underground quality was searched we hope we found it. Now, listen, share and enjoy. Mixed by Lidless Sound. | ["Music", "Techno", "Drum machine", "Electronica"] | ["techno", "punchy \"4 on the floor\" kick", "punchy snare", "groovy bass", "echoing synth keys", "short haunting synth lead", "weird percussive sound effects", "groovy", "energetic"] | 4 | X7LrhZX4rdU | 3162 | |
HooNose - Cacophony [DUBSTEP, Techstep?] | This is a dubstep piece. The rhythmic background consists of a hard-hitting electronic drum beat. A high-pitched synth is playing the main melody while a choir sample is played in the background for the chords. There is a high energy atmosphere in the piece. It could be played at nightclubs. This piece could also take place in DJ setlists. | 2011-04-27T19:40:43Z | HooNose2009 | Took me 5 minutes to figure out how to make a wub wub with 3xOsc. Then I decided to add a handsup/ techno rhythm to it in the 2nd half of the song. Ta-da. I'll only make this genre a few times; Dub's a fad, techno and hardstyle are FOREVER. | ["Drum and bass", "Music", "Techno", "Trance music", "Dubstep", "Electronic dance music", "Dance music", "Electronica"] | ["dubstep", "techno", "electronic drums", "choir sample", "high-pitched synth", "energetic", "loud", "aggressive", "repeated theme", "dance"] | 9 | _GxqvILlmAw | 3457 |
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;