musiccaps_details (view)
1 row where musiccaps_aspects contains "amateur drumming", musiccaps_aspects contains "dance music", musiccaps_aspects contains "funky" and musiccaps_names contains "Electronica"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Mix Musica Electronica 2013 (Electro House) VOL 14 | This song is an energetic electronic instrumental. The song is medium fast tempo with an insistent synthesiser rhythm, dissonant tambourine funky bass and basic , amateur drumming, recurring vocal riff and vocal backup . The song is youthful, spirited, punchy and catchy with a dance groove. This song is an Electro Pop song. | 2013-08-16T21:54:34Z | leonel ybarra | Dj L30- Electro House 2013 , Mix de los mejores temas de electro: VOL 14 (Mix agosto 2013) Tracklist: 1-MACKLEMORE RYAN LEWIS THRIFT SHOP (DFM MIX) 2-Michael Woods Clanga (Original Mix) 3-Will Moore Super Jam (Original Mix) 4-Carnage Borgore Incredible (Original Mix) Seguime en SOUNDCLOUD: https://soundcloud.com/leonel-ybarra ----------------------------------------------------------------------------- DESCARGÁ el Mix: http://www.mediafire.com/download/6d61k3dtdz1onws/14- Si te gusto click en Mg.. :D Y SUSCRIBITE.... Best Electro & House 2014 New Years Party Mix Best Dance Music 2014 New Electro House House 2014 (Winter Love #5) Dj D3evice & MindOneBG The Best Electro House -- Dance Mix 2014 Sexy Girl ( FreeYoutube ) Electro House 2014 ! THE Best Dance Music New Electro House Hand UP 2014 #49 New Best of electro progressive House Music ( Club Mix Remix 2014 ) Electro House Mix 2014 Electro & House Club Mix 2014 | Bangerbeatz Ep.49 (PeeTee vs Merk & Kremont) New Techno & Electro House Hands Up 2014 { Sexy DIRTY House Music } #32 Electro & House 2014 Dance Mix #57 New Best Electro House Techno 2014 #28 NEW BEST ELECTRO HOUSE MUSİC MIX 2013/2014 CLUB MİX NEW DANCE MUSİC ELECTRO HOUSE MUSIC MIX 2013 NEW ELECTRONIC DUBSTEP MUSIC 2013 [EP.2] BEST ELECTRO HOUSE MIX OF 2012 / SPECIAL ELECTRO MIX / [EP.24] - By Dj Epsilon BEST OF 2013 ELECTRO HOUSE MIX - NEW #23 BEST DAMN ELECTRO HOUSE MIX OF 2013 / SPECIAL ELECTRO DANCE MIX / [EP.47] - By Dj Epsilon Dirty Electro House Music Mix 2014 The best Mix Electro House MUSIC 2014 #27 Electro & House Club Mix 2014 | Bangerbeatz Ep.49 (PeeTee vs Merk & Kremont) THE BEST ELECTRO HOUSE MUSIC HAPPY NEW YEAR MIX 2014 Best Dance Music 2014 New Electro House House 2014 (Winter Love #5) Dj D3evice & MindOneBG Electro House New Best Club Mix Remix Radio Edit 2014 Music { Sexy Hot Girl } BEST Electro & House Dance Charts Party Mix 2014 #53 BEST ELECTRO HOUSE & CLUB PROGRESSIVE DANCE MUSIC MEGAMIX 2013 [100 MIN] | DJ Adi-G Musica Electronica 2014 2013 NEW The Best Of The Ele… | ["Disco", "House music", "Music", "Electronic dance music", "Dance music", "Electronica"] | ["instrumental", "fast tempo", "electro pop", "amateur drumming", "house", "dj", "dance music", "punchy", "funky", "youthful", "buoyant", "synthesiser arrangement", "tambourine", "punchy bass lines", "straight drumming", "recurring vocal riff", "dance music", "synth pop", "pop", "pop hits", "vocal backup"] | 7 | UUJ1DNycpiQ | 2919 |
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;