musiccaps_details (view)
2 rows where musiccaps_aspects contains "digital drums", musiccaps_aspects contains "fast tempo" and musiccaps_names contains "Electronic dance music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- digital drums · 2 ✖
- fast tempo · 2 ✖
- amateur recording 1
- ambient 1
- amplified 1
- club music 1
- dance groove 1
- dj 1
- edm 1
- electronic instrumental 1
- electronic music 1
- electronic tech 1
- electronically 1
- futuristic 1
- goth rock 1
- instrumental 1
- loud 1
- new-age 1
- new-wave 1
- progressive 1
- psychedelic 1
- syncopated 1
- synth pop 1
- synth sound 1
- synthesiser articulation 1
- techno/hardstyle 1
- trippy 1
- two different songs 1
- voice samples 1
musiccaps_names (array) 9 ✖
- Drum and bass 2
- Dubstep 2
- Electronic dance music · 2 ✖
- Music 2
- Trance music 2
- Dance music 1
- House music 1
- Shuffle 1
- Techno 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 |
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;