musiccaps_details (view)
3 rows where musiccaps_aspects contains "digital drums", musiccaps_names contains "Drum and bass" and musiccaps_names contains "Trance music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- digital drums · 3 ✖
- fast tempo 2
- amateur recording 1
- ambient 1
- amplified 1
- club music 1
- dance groove 1
- digital bass 1
- dj 1
- edm 1
- electronic instrumental 1
- electronic music 1
- electronic tech 1
- electronically 1
- futuristic 1
- goth rock 1
- high pitched voice sample 1
- instrumental 1
- loud 1
- new-age 1
- new-wave 1
- progressive 1
- psychedelic 1
- riser 1
- syncopated 1
- synth pop 1
- synth sound 1
- synthesiser articulation 1
- techno/hardstyle 1
- techno/minimal 1
- trippy 1
- two different songs 1
- upbeat 1
- voice samples 1
musiccaps_names (array) 12 ✖
- Drum and bass · 3 ✖
- Electronic dance music 3
- Music 3
- Trance music · 3 ✖
- Dance music 2
- Dubstep 2
- House music 2
- Techno 2
- Disco 1
- Electronica 1
- Sampler 1
- Shuffle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
[HSD] Practise Toniic, ChrizZ, Feybi (Melbourne Shuffle Hamburg) | A digital drum is playing a monotone beat with a kick on every beat along with a repeating voice sample. In the next song a wide synth pad is playing a string sound while a female voice sample is singing a melody. These songs may be playing in a techno club. | 2010-07-16T10:24:57Z | Feybi11 | Pls comment and rate =) and sub for more ;) Edit: Sony Vegas 9.0 pro (Feybi) Songlist: Intro: Spor - 103 Degrees Dj Neo - In my mind Karpe DM - Jackin' my style Deepforces - Play it loud Walt Jensen - Ctrl walt del Ziggy X - Explode | ["Drum and bass", "House music", "Music", "Techno", "Trance music", "Shuffle", "Dubstep", "Electronic dance music", "Dance music"] | ["techno/hardstyle", "digital drums", "voice samples", "two different songs", "synth sound", "fast tempo", "amateur recording"] | 6 | 4X2aUZFZlzc | 582 | |
Skrillex - Cat Rats | This music is an electronic instrumental. The tempo is fast with synthesiser articulation, digital drumming and circuitry based technology. The music is loud, futuristic, contemporary, psychedelic, trippy ,hypnotic and youthful with a dance groove. This music is EDM. | 2010-12-18T14:02:03Z | SubExplosion | ["Drum and bass", "Music", "Trance music", "Dubstep", "Electronic dance music"] | ["instrumental", "fast tempo", "electronic music", "synthesiser articulation", "digital drums", "electronic instrumental", "loud", "amplified", "syncopated", "psychedelic", "trippy", "progressive", "futuristic", "edm", "new-age", "new-wave", "electronically", "ambient", "club music", "dance groove", "dj", "electronic tech", "synth pop", "goth rock"] | 7 | UhwJrftWAFg | 2935 | ||
MULDER - CANT STAND THE SUN [BLA BLA SUMMER SAMPLER VOLUME 1] | A digital drum is playing a techno groove with a half open hihat sound on the offbeat and a pregnant snare. A shaker and other little rhythmic elements are spicing up the drums. A simple digital bass is playing a melody while a very short voice sample comes in along with white noise rising. The elements are slightly panned across the speakers. This song may be playing in a techno club. | 2010-06-01T18:43:50Z | Bla Bla Music | MULDER - CANT STAND THE SUN [BLA BLA SUMMER SAMPLER VOLUME 1] Bla Bla Summer sampler is released june 9 | ["Sampler", "Disco", "Drum and bass", "House music", "Music", "Techno", "Trance music", "Electronic dance music", "Dance music", "Electronica"] | ["techno/minimal", "digital drums", "digital bass", "riser", "high pitched voice sample", "upbeat"] | 6 | p20KE0LhL68 | 4678 |
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;