musiccaps_details (view)
3 rows where musiccaps_aspects contains "aggressive", musiccaps_author = 9 and musiccaps_names contains "Drum and bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- aggressive · 3 ✖
- electronic drums 2
- energetic 2
- repeated theme 2
- choir sample 1
- dance 1
- danceable 1
- drum & bass 1
- dubstep 1
- electronic dance music 1
- fast-tempo electronic drums 1
- groovy 1
- high-pitched synth 1
- industrial sounding 1
- instructive recording 1
- loud 1
- modern sounding 1
- no singer 1
- russian hardbass 1
- scissor sharpener 1
- strong bass 1
- synth 1
- synth bass 1
- techno 1
- upbeat 1
- urban 1
musiccaps_names (array) 8 ✖
- Drum and bass · 3 ✖
- Dubstep 3
- Music 3
- Electronic dance music 2
- Techno 2
- Trance music 2
- Dance music 1
- Electronica 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 | |
HooNose - Cacophony [DUBSTEP, Techstep?] | This is a dubstep piece. The rhythmic background consists of a hard-hitting electronic drum beat. A high-pitched synth is playing the main melody while a choir sample is played in the background for the chords. There is a high energy atmosphere in the piece. It could be played at nightclubs. This piece could also take place in DJ setlists. | 2011-04-27T19:40:43Z | HooNose2009 | Took me 5 minutes to figure out how to make a wub wub with 3xOsc. Then I decided to add a handsup/ techno rhythm to it in the 2nd half of the song. Ta-da. I'll only make this genre a few times; Dub's a fad, techno and hardstyle are FOREVER. | ["Drum and bass", "Music", "Techno", "Trance music", "Dubstep", "Electronic dance music", "Dance music", "Electronica"] | ["dubstep", "techno", "electronic drums", "choir sample", "high-pitched synth", "energetic", "loud", "aggressive", "repeated theme", "dance"] | 9 | _GxqvILlmAw | 3457 | |
1. Кутикульные ножницы. Предварительная обработка | This is a Russian hardbass piece played in the background of a scissor sharpening video. The piece has a repeated theme being played by a synth bass while an electronic drum beat holds the rhythmic background. The atmosphere of the piece in the background is aggressive with industrial characteristics. | 2012-02-01T19:18:10Z | Виталий Бородин | Перед тем, как затачивать ножницы для кутикулы, их нужно подготовить - придать нужную форму полотнам. Этому и посвящено видео. | ["Drum and bass", "Music", "Techno", "Trance music", "Dubstep"] | ["instructive recording", "scissor sharpener", "no singer", "russian hardbass", "synth bass", "electronic drums", "repeated theme", "aggressive", "industrial sounding"] | 9 | dIPW9gLGSx8 | 3774 |
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;