musiccaps_details (view)
2 rows where musiccaps_aspects contains "digital drums", musiccaps_aspects contains "synth bass" and musiccaps_names contains "Dubstep"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- digital drums · 2 ✖
- synth bass · 2 ✖
- aggressive 1
- drum&bass 1
- dubstep 1
- energetic 1
- fast tempo 1
- female voice singing 1
- male voice rapping 1
- male voice sample 1
- synth riser sound and lead 1
- uptempo 1
musiccaps_names (array) 5 ✖
- Dubstep · 2 ✖
- Music 2
- Drum and bass 1
- Electronic music 1
- Hip hop music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Sound of Dubstep (Ministry of Sound) Mega Mix | This song contains digital drums playing along with a raw synth bass sound playing a melody while a male voice is rapping in a higher key. Then a female voice takes over singing a melody along to the bass. This song may be playing loud when at home alone. | 2010-04-21T11:05:23Z | Ministry of Sound | BUY NOW @ HMV - http://bit.ly/cCxAaE BUY NOW @ ITUNES - http://bit.ly/cjeguR Ministry of Sound brings you the latest buzz genre to emerge from the underground club scene. Over the last couple of years Dubstep has risen to prominence with mass exposure across national radio, being championed by the likes of Annie Mac & Zane Lowe on Radio 1 as well as massive club nights surfacing all over the world. Having been the first to bring out a collection of Bassline as it hit its peak, The Sound of Dubstep is now the freshest sound in dance music and makes this an essential purchase for all people that like their raw bass. The Sound of Dubstep is the first TV album to bring together all the biggest tunes, allowing you to experience the low bass frequencies bought to you by the pioneers of the scene including Skream, Benga, Caspa, Rusko & Doorly. With massive remixes of The Prodigy, MJ Cole, Dizzee Rascal, Calvin Harris and loads more. This is the ultimate collection of over 40 classic and exclusive heavy hitting tracks that is destined cause some serious damage! http://bit.ly/MoStv | ["Music", "Dubstep", "Hip hop music"] | ["dubstep", "digital drums", "synth bass", "male voice rapping", "female voice singing", "uptempo", "energetic"] | 6 | BgTB_xt11bA | 1274 | |
Disturbia - Mass Effect | This song contains a synth riser sound than a male voice sample that was pitched very low and starts to say a phrase before the beat hits in with a fast digital drum and bass groove along with an aggressive synth bass sound. A synth lead sound is playing a melody creating a countermelody to the bass. This song may be playing while doing extreme sports. | 2010-10-08T14:12:16Z | milenko33 | Darkstep (dnb) tune from Disturbia. Disturbia's channel: http://www.youtube.com/user/micthegod | ["Drum and bass", "Electronic music", "Music", "Dubstep"] | ["drum&bass", "synth bass", "synth riser sound and lead", "male voice sample", "digital drums", "aggressive", "fast tempo"] | 6 | DRU-IFx-7yQ | 1477 |
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;