musiccaps_details (view)
3 rows where musiccaps_aspects contains "electronic drums", musiccaps_aspects contains "energetic", musiccaps_names contains "Music" and musiccaps_names contains "Trance music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
New Dance & Electro Mix || Best Electro House Mix 2014 - By Becko | This is a house music piece. It has a fuzzy synth lead playing the main melody while there is a medium-to-high pitch pad playing an arpeggio. There is a fuzzy synth bass in the background. A loud electronic drum beat provides the rhythmic background. There is a constant crowd cheering effect giving the impression of the piece being performed live. The atmosphere is energetic. This piece can be played at nightclubs and EDM venues. | 2014-11-21T13:21:44Z | Best Music | The Best Electro House Dance Mixes by Club Music!! Make sure to subscribe and like this video!! Free Download: http://bit.ly/1H4aF1M ▸Follow this Soundcloud for free downloads when it hits 10k: http://bit.ly/1Egulj1 ▸Follow CLUB MUSIC on Facebook: http://goo.gl/MSPI8q | ["Music", "Trance music", "Electronic dance music", "Dance music"] | ["dance", "electro", "house", "lead synth", "synth bass", "electronic drums", "pad", "sound effects", "repeated theme", "simple", "catchy", "energetic"] | 9 | IYtQfDsFVfA | 1916 | |
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 | |
Tumba Ping Pong Song (Dunderpatrullen vs. Tumba Ping Pong Show) | This song contains a fast drum&bass drum that gets supported by a bass and a synthlead sound on top of it. Both play the same melody. Some different samples get drowned in. They sound like dog-barks that have been processed with effects and a lower bitrate. In the background different sound-effects are rising up in pitch. This song sounds hectic and energetic. This song may be playing in a dance club. | 2014-03-16T17:39:41Z | Tumba Ping Pong Show | The official TUMBA PING PONG SONG made by our friends in Dunderpatrullen (http://bit.ly/dptube). WEBSITE ► www.waine.se INSTAGRAM ► @wainefilms (https://www.instagram.com/wainefilms/) ► @maxmarklund (http://www.instagram.com/maxmarklund) ► @hempak (https://www.instagram.com/hempak/) CONTACT US ► team@waine.se SUBSCRIBE FOR MORE https://www.youtube.com/user/tumbapingpongshow?sub_confirmation=1 Search Words (Ignore): #tumba ping pong show, #waine, #vfx, tumba ping pong show, ping pong, pingis, ping pong tricks, cgi, vfx, visual effects, digital effects, tricks, trickshot, trickshots, trick shots, waine, when awesome is not enough, short films, show, drama, comedy, epic, weird, ping pong ball, knives, pineapple, fruit, miss ping, tumba ping pong song, geometry dash, fake, real, max marklund, anders jacobsson, henrik koelman, dj coolman, slightly mad max, mad max, dr ders, table tennis, cucumber in mouth, miss ping, miss pong, epic win, behind the blue fur, behind the blue fur, tumba ping pong show, tumba ping pong show patiently, roy andersson, a pigeon sat on a branch reflecting on existence, phuket, tumba ping pong song | ["Music", "Techno", "Trance music", "Ping", "Dubstep", "Electronic dance music"] | ["drum&bass", "electronic drums", "digital bass", "dog barking sample", "synthesizer sounds", "fast tempo", "energetic"] | 6 | lymmNwQA0WA | 4433 |
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;