musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental music" and musiccaps_names contains "Dubstep"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- dj 3
- instrumental music · 3 ✖
- medium tempo 3
- electronic dance music 2
- energetic 2
- groovy bass line 2
- spirited 2
- techno dance rhythm 2
- youthful 2
- average audio quality 1
- booming bass line 1
- dance club 1
- dance floor 1
- dance music 1
- dance tune 1
- drum machines 1
- exciting 1
- groovy dance music 1
- groovy rhythm 1
- grunge keyboard tones 1
- hissing tones 1
- home studio 1
- house mix 1
- keyboard harmony 1
- party all night 1
- party mix 1
- people dancing 1
- ping pong shot tones 1
- poor audio quality 1
- poor audio quality hissing tones 1
- rhythm mismatch 1
- sweeping keyboard harmony 1
- synth horn melody 1
- synth modules 1
- synth trumpet lead 1
- synthesisers 1
- techno drumming rhythm 1
- trance music 1
- turntables 1
- underground music scene 1
- various percussion hits 1
musiccaps_names (array) 10 ✖
- Dubstep · 3 ✖
- Music 3
- Drum and bass 2
- Electronic dance music 2
- Techno 2
- Cacophony 1
- Dance music 1
- Disco 1
- House 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 |
---|---|---|---|---|---|---|---|---|---|---|
Azzido Da Bass - Music For Bagpipes (TRASHLINE Remix) [HD] | The song is an instrumental. The song is medium tempo with a groovy bass line, grunge keyboard tones, synth trumpet lead and techno drumming rhythm. The song is entertaining and energetic. The song is an electronic dance song with average quality recording. | 2010-09-04T16:45:36Z | PapayaOficiallRP | Azzido Da Bass - Music For Bagpipes (TRASHLINE Remix) Watch in HD! Suscribe! ;) MSN: PAPAiiA-JEtAiiME@hotmail.fr By: PapayaOficiallRP | ["Music", "Techno", "Dubstep", "Cacophony", "Electronic dance music"] | ["average audio quality", "groovy rhythm", "electronic dance music", "instrumental music", "groovy bass line", "medium tempo", "synth trumpet lead", "people dancing", "dj", "techno dance rhythm", "dance club", "dance floor", "spirited", "energetic", "youthful", "grunge keyboard tones"] | 1 | 4Mm5mBgktG0 | 562 | |
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 | |
Polycarpus - Ping Pong | The song is an instrumental. The tempo is medium with a booming bass line, grooving drum rhythm, sweeping keyboard harmony, sonic sound effects, and pin pong ball sound effects. The song has trance vibes and is very groovy. The song has poor audio quality. | 2009-12-20T21:38:12Z | Harder_Stylezz89 | Polycarpus - Ping Pong | ["Disco", "Drum and bass", "House music", "Music", "Techno", "Dubstep", "Electronic dance music", "Dance music"] | ["techno dance rhythm", "keyboard harmony", "poor audio quality", "trance music", "dj", "house mix", "party mix", "medium tempo", "instrumental music", "ping pong shot tones", "booming bass line", "various percussion hits", "groovy dance music", "exciting", "youthful", "energetic", "spirited", "party all night", "underground music scene", "sweeping keyboard harmony"] | 1 | hgGCfJoYDUU | 4124 |
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;