musiccaps_details (view)
3 rows where musiccaps_aspects contains "techno drumming rhythm" and musiccaps_names contains "Dubstep" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- dj 3
- electronic dance music 3
- techno drumming rhythm · 3 ✖
- medium tempo 2
- techno dance music 2
- dance club 1
- dance floor 1
- dance music 1
- dance tune 1
- distorted tones 1
- drum machines 1
- dubstep music 1
- electronic music 1
- enthusiastic 1
- exciting 1
- groovy bas slime 1
- groovy bass line 1
- groovy dance rhythm 1
- grunge keyboard tones 1
- hissing tones 1
- home studio 1
- instrumental music 1
- instrumentals music 1
- keybiard accompaniment 1
- overdriven keyboard harmony 1
- passionate 1
- people dancing 1
- percussion hits 1
- poor audio quality 1
- poor audio quality hissing tones 1
- rhythm mismatch 1
- rubbing tones 1
- sonic effects 1
- steady drumming rhythm 1
- synth horn melody 1
- synth modules 1
- synth string pad section 1
- synthesisers 1
- trance dance music 1
- trance music 1
- turntables 1
- youthful 1
musiccaps_names (array) 6 ✖
- Dubstep · 3 ✖
- Music 3
- Drum and bass 2
- Electronic music 2
- Electronic dance music 1
- Reggae 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Baile de Dubstep | The song is an instrumental. The song is medium tempo with a slick drumming rhythm, grunge keyboard tones, overdriven synth tones and string pad section. The song is groovy and exciting. The audio quality is poor in general. | 2013-03-08T02:22:05Z | Rafael Chávez | Mira mi nuevo video y aprende 3 pasos sencillos https://www.youtube.com/watch?v=nhlQRS4vDYo | ["Electronic music", "Music", "Dubstep"] | ["instrumentals music", "dubstep music", "overdriven keyboard harmony", "poor audio quality", "dj", "electronic music", "grunge keyboard tones", "steady drumming rhythm", "distorted tones", "synth string pad section", "electronic dance music", "techno drumming rhythm", "techno dance music", "rubbing tones"] | 1 | MP7KPlqoQW0 | 2262 | |
Moskvin - ragga dub & enei - deep dnb "use your fingers" live looping mix (Drum pads 24 & korg kp3) | The song is an instrumental. The song is medium with a strong bass line, steady techno drumming rhythm, various percussion hits and a synth horn melody. The song has mismatched tempos and is amateurish in production. The audio quality is poor. | 2015-04-01T21:14:12Z | Moskvin | Moskvin - ragga dub & enei - deep dnb "use your fingers" live looping mix (Drum pads 24 & korg kp3) Download Drum Pads 24: Windows Phone Store: http://bit.ly/DrumPads24WP Google Play: https://play.google.com/store/apps/details?id=com.paullipnyagov.drumpads24 App Store: https://itunes.apple.com/app/id667945907 ------------------------------------------------------------------------------ Drum Pads 24: https://www.facebook.com/Drumpads | ["Drum and bass", "Music", "Reggae", "Dubstep"] | ["home studio", "dj", "turntables", "synthesisers", "poor audio quality hissing tones", "medium tempo", "synth modules", "drum machines", "rhythm mismatch", "dance music", "electronic dance music", "synth horn melody", "groovy bass line", "techno drumming rhythm", "dance tune", "hissing tones", "instrumental music"] | 1 | 8XBsesSEbbU | 925 | |
Mt Eden - Gambler | The song is an instrumental. The tempo is medium with a groovy drumming rhythm, percussive bass line, keyboard accompaniment and various percussive and sonic effects. The song is youthful and exciting with a trance element. The song is a modern tench pop dance tune. | 2010-12-02T12:18:30Z | Mt Eden Official | VIP version coming very soon FREE DOWNLOAD: Track 3 off our debut EP - "MEDS" Sample: (New Zealand) P-Money - Gamble. From the album "Big Things". Cover art by Craig Plant: craigplantartworks@hotmail.co.nz http://www.facebook.com/pages/Craig-Plant-Artworks/116296581769040?v=wall Support us!! Download and rate these tracks on itunes!! http://itunes.apple.com/nz/album/meds-ep-1/id409192438 OR Download the full EP for FREE here: http://www.mediafire.com/?itcp3vi40p7pmmw | ["Drum and bass", "Electronic music", "Music", "Dubstep", "Electronic dance music"] | ["techno dance music", "electronic dance music", "trance dance music", "medium tempo", "groovy bas slime", "techno drumming rhythm", "keybiard accompaniment", "percussion hits", "sonic effects", "dj", "dance floor", "dance club", "people dancing", "groovy dance rhythm", "trance music", "enthusiastic", "passionate", "youthful", "exciting"] | 1 | 66B46E_hrrk | 725 |
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;