musiccaps_details (view)
4 rows where musiccaps_aspects contains "fast tempo", musiccaps_author = 6 and musiccaps_names contains "Electronic music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- fast tempo · 4 ✖
- digital drums 2
- acoustic drum 1
- aggressive 1
- amateur recording 1
- complex 1
- dancing 1
- drum&bass 1
- e-bass 1
- electric horn sample 1
- latin 1
- male voice sample 1
- male voice speaking 1
- percussion's 1
- psy trance 1
- synth arpeggios 1
- synth bass 1
- synth riser sound and lead 1
- uplifting mood 1
musiccaps_names (array) 15 ✖
- Electronic music · 4 ✖
- Music 4
- Drum and bass 2
- Bass drum 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Dubstep 1
- Hi-hat 1
- Musical instrument 1
- Percussion 1
- Rattle (instrument) 1
- Snare drum 1
- Techno 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Psy trance | This audio contains a digital drum playing a four on the flor groove with a kick on every beat and building up kicks to doubletime and triplets. Synth bass sounds and synth sounds in the midrange are playing arpeggiated melodies. This song may be playing with headphones while playing video-games. | 2007-09-16T07:20:51Z | Italo Lopes | Oxys - Zumbination : www.oxys.palcomp3.com.br Visitem nossa comunidade no orkut : http://www.orkut.com.br/Main#Community.aspx?cmm=76612689 | ["Electronic music", "Music", "Techno", "Trance music"] | ["psy trance", "digital drums", "synth arpeggios", "fast tempo"] | 6 | I_kUf7vgVNM | 1919 | |
RS punta mix 2011 | This song mainly contains rhythmic instruments with a monotone bassline giving the percussion's some low end. The male voice is speaking over the instrumental. The whole song sounds motivation and animates to dance. This song may be playing at a latin festival. | 2011-02-14T22:27:20Z | kraze fernandez | for more music follow me http://soundcloud.com/krazeoowop | ["Electronic music", "Music", "Rattle (instrument)"] | ["latin", "percussion's", "e-bass", "electric horn sample", "male voice speaking", "fast tempo", "uplifting mood", "dancing"] | 6 | TbYahEEj_B4 | 2851 | |
KJ Sawka in his Basement | This audio contains someone playing an acoustic drum with a fast paced and complex rhythm. This is an amateur recording. | 2006-11-20T22:00:36Z | briandewaide | Buy KJ Sawka's music at kjsawka.com or www.waxorchard.com Hi. My name is Kevin Sawka, and I play jungle and drum'n'bass beats. | ["Cymbal", "Drum", "Drum and bass", "Drum kit", "Electronic music", "Hi-hat", "Music", "Musical instrument", "Snare drum", "Bass drum", "Percussion"] | ["amateur recording", "acoustic drum", "fast tempo", "complex"] | 6 | b98BJ36K1wo | 3605 |
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;