musiccaps_details (view)
2 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "electronic drums" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- bass · 2 ✖
- electronic drums · 2 ✖
- amateur recording 1
- clubmusic 1
- hardstyle/trance 1
- male rapping/singing voice 1
- pulsating pad sounds 1
- ragga/drum&bass 1
- synthesizer lead 1
- synthesizer plucks 1
- uptempo 1
musiccaps_names (array) 7 ✖
- Music 2
- Drum and bass 1
- Dubstep 1
- Jingle (music) 1
- Salsa music 1
- Techno 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jarrad - HARD TRANCE SHUFFLING 2012 #2 - Rage | The drums are playing a four on the floor techno rhythm with hihats and a strong kick. A synthetic bass follows the kick with almost just a single note playing. Panned to the left and right side of the speakers you can hear a monotone, repeating synth melody. This song may be playing in a technoclub. | 2012-04-25T20:48:13Z | 1am Films | WEEK #2 This is my Second Video for hardstyle/hard trance rocking, going to put together a new quick video every week :) TAGS : shuffling hardstyle reverse bass len we dance hard NR newcalste rockers LMFAO running man 2011 HD how to best dancing moves hat boy jarrad alalmbie sydney music qdance defqon cars loud new amazing magic slide DC break techno shuffle rocking melbourne old school how to running man new HD best compilation len wedancehard newcastle rockers brenton hiltzy pae sarah LMFAO party rock anthem every day im shuffling facebook twitter qdance scantraxx bass controll powerhouse jarrad peters hardstylestudio dance music australia NR GR german justin | ["Drum and bass", "Music", "Techno", "Trance music", "Dubstep"] | ["hardstyle/trance", "electronic drums", "bass", "synthesizer plucks", "pulsating pad sounds", "clubmusic", "uptempo"] | 6 | D7pjR9cQChM | 1440 | |
Big Up Kemp Europe 2013. Workshop by Fatou Tera. Busy Signal - Life goes on | The drums sound complex and fast paced going into the direction of drum&bass. Full of hihat and snare hits. Barely noticeable a synthetic bass is playing along with the drums giving this song a ragga feeling. A very simple synthesizer pad is playing a high pitched melody. The male voice sounds lower and energetic. This recording is of poor audio quality. This song may be playing at a dancing event or while working out. | 2013-09-11T14:25:26Z | BIG UP PRODUCTION | Big Up Kemp is the first international dancehall camp in the world organized by Big Up Production. It was first organized in 2011 and became the biggest dancehall camp in the world. In 2013 Big Up Kemp will again take place in Russia and France! TWO camps, more teachers, more dancehall!!... Join us!! WWW.BIGUPKEMP.COM | ["Jingle (music)", "Music", "Salsa music"] | ["ragga/drum&bass", "amateur recording", "electronic drums", "synthesizer lead", "male rapping/singing voice", "bass"] | 6 | FsCQmTluSDw | 1667 |
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;