musiccaps_details (view)
2 rows where musiccaps_aspects contains "punchy snare", musiccaps_names contains "Drum machine", musiccaps_names contains "Electronica" and musiccaps_names contains "Techno"
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 | |
funky electro house mix | The low quality recording features an electro song that consists stuttering "4 on the floor" kick pattern, punchy snare, shimmering hi hats and open hats, soft crash cymbal, repetitive synth melody, spacey, echoing synth lead melody, buzzy synth bass and fading out stuttering female vocal sound effects. It is reverberant, messy, crushed and thin, as the frequencies are clashing with each other, but it still sounds energetic. | 2008-01-30T20:17:13Z | soopa123 | track list dj delicious-same man Dvj bazuka- techno rock rio-rio bud brothers-feel like dancin funkerman &flg -3 minutes to explain please comment and rate, made by myself and im not a pro dj thouhg made with vir dj 5 rev6 | ["Funk", "House music", "Music", "Techno", "Drum machine", "Electronica"] | ["low quality", "electro", "fading out stuttering female vocal sound effect", "stuttering \"4 on the floor\" kick pattern", "punchy snare", "repetitive synth melody", "shimmering hi hats", "spacey synth melody", "buzzy synth bass", "reverberant", "energetic", "crushed", "messy", "thin", "shimmering open hat", "soft crash cymbal"] | 4 | h-2KO5ufrcw | 4072 |
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;