musiccaps_details (view)
2 rows where musiccaps_aspects contains "upbeat" and musiccaps_aspects contains "urban"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- upbeat · 2 ✖
- urban · 2 ✖
- aggressive 1
- dance 1
- danceable 1
- dj performance 1
- drum & bass 1
- electronic dance music 1
- electronic drums 1
- energetic 1
- fast-tempo electronic drums 1
- groovy 1
- hip-hop breakbeat 1
- kids performance 1
- live recording 1
- modern sound 1
- modern sounding 1
- scratching 1
- strong bass 1
- synth 1
- turntable 1
musiccaps_names (array) 5 ✖
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 | |
DJ Kids Scratching! | This is a DJ performance recording of two kids scratching a turntable. The turntable is being scratched over a hip-hop breakbeat that consists of a loud electronic drum beat. The atmosphere is danceable and there is an urban sound. This piece could be played at sports venues. It could also be sampled for use in beat-making. | 2007-09-14T19:58:53Z | valentinesday01 | this little dudes get down on the turntables!! Yeah they're bad asses. For those who continue to say it's fake check out their page: Sarahscratch. Their names are DJ Sara and DJ Ryusei. | ["Scratching (performance technique)", "Music"] | ["dj performance", "live recording", "kids performance", "turntable", "scratching", "hip-hop breakbeat", "electronic drums", "dance", "urban", "upbeat", "modern sound"] | 9 | WiAFUo2nxIk | 3129 |
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;