musiccaps_details (view)
2 rows where musiccaps_aspects contains "danceable", musiccaps_aspects contains "electronic dance music" and musiccaps_aspects contains "strong bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- danceable · 2 ✖
- electronic dance music · 2 ✖
- energetic 2
- strong bass · 2 ✖
- aggressive 1
- club music 1
- drum & bass 1
- fast-tempo electronic drums 1
- female voice sample 1
- groovy 1
- house music 1
- loud electronic drums 1
- male voice sample 1
- melodic pad 1
- modern sounding 1
- repeated theme 1
- synth 1
- upbeat 1
- urban 1
musiccaps_names (array) 7 ✖
- Music 2
- Disco 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- Electronic music 1
- House music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dub Motion - Infected | This is a drum & bass music piece. There is a very fast-tempo, high energy electronic drum beat in the rhythmic background. There is a strong and fuzzy bass sound playing a loud bass line while a synth can be heard adding texture. The piece is upbeat and has an aggressive atmosphere. This music is perfect for nightclubs and DJ sets. It could also work well in the soundtrack of a car racing video game. | 2014-10-03T19:05:35Z | Yes Just Jump Up | Drum & Bass | ➢ Yes Just Jump Up - Bringing you the latest in Jump Up Drum & Bass ★ Buy: http://btprt.dj/1rINylD ★ Dub Motion: https://soundcloud.com/dub-motion ★ CYN Music: https://soundcloud.com/cynmusic ♚ Subscribe: http://bit.ly/1sis8Nn ♚ Facebook: http://bit.ly/yjjudnb ♚ SoundCloud: http://bit.ly/fbjjudnb ➢ Follow | Dub Motion Twitter: http://twitter.com/Jamesdubmotion Facebook: https://www.facebook.com/pages/Dub-Motion/317271701654004?ref=hl Soundcloud: hhttps://soundcloud.com/dub-motion ➢ Follow | CYN Music Home: http://www.cyn-music.com/ Twitter: http://www.twitter.com/cyantificmusic Releases: http://www.beatport.com/label/cyn-music/16903 Facebook: https://www.facebook.com/CyantificMusic SoundCloud: https://soundcloud.com/cynmusic ➢ Subscribe to Yes Just Jump Up ★ Home: http://justbassmusic.com ★ Twitter: https://twitter.com/JustJumpUp ★ Facebook: http://www.facebook.com/JustJumpUpDrumAndBass ★ SoundCloud: https://soundcloud.com/yesjustjumpup ➢ Original Background: Unknown. ✄ Download: http://i.imgur.com/oeGLN2H.png | ["Drum and bass", "Music", "Dubstep", "Electronic dance music"] | ["drum & bass", "electronic dance music", "fast-tempo electronic drums", "synth", "strong bass", "groovy", "urban", "danceable", "modern sounding", "aggressive", "energetic", "upbeat"] | 9 | BZyf8LPltYs | 1259 | |
House Music Dugem ~ Dj Devi | This is an electronic house music piece. There is a melodic pad playing a repeated tune for the melody. The strong bass and the loud electronic drums are playing as the essential backbone of the house music genre. There is a male voice sample that repeats the same word. There is a female voice sample that speaks occasionally. The atmosphere is energetic. This piece could be playing at nightclubs or dance clubs. | 2013-02-18T22:52:17Z | devi aZ | R.E.M.I.X Final Countdown Vs Anastasia | ["Disco", "Electronic music", "House music", "Music"] | ["electronic dance music", "house music", "melodic pad", "repeated theme", "strong bass", "loud electronic drums", "male voice sample", "female voice sample", "energetic", "danceable", "club music"] | 9 | fpbtmY9VfCw | 3980 |
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;