musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance music", musiccaps_aspects contains "instrumental", musiccaps_aspects contains "punchy bass lines" and musiccaps_author = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|
BASS ADDIKT SATURDAYS | GRAVITY SOUND BAR | MARCH 2014 | This song is an electronic instrumental. The tempo is fast with booming bass lines, synthesiser arrangement, table turner and digital drums. The music is vibrant, upbeat, pulsating, loud, punchy, buoyant, youthful and has a dance groove. This music is EDM. | 2014-02-06T19:40:28Z | GRAVITY SOUNDBAR | BASS ADDIKT SATURDAYS A NEW TORONTO EXPERIENCE COMING SOON GRAVITY SOUND BAR 296 RICHMOND STREET COMING IN MARCH OF 2014 THIS NEW SATURDAY NIGHT EXPERIENCE GIVES AN ENORMOUS SOUND & LIGHTING SHOW WITH SPACE HOLDING OVER 1000 PEOPLE DIVERSE PIECES OF TALENT AWAIT TO BE ANNOUNCED JOIN US THIS UPCOMING SPRING AS WE UNLEASH A NEW BEGINNING MORE INFO COMING SOON!!! TAKE A LOOK AT THE BASS ADDIKT EVENT PAGE ON FACEBOOK: https://www.facebook.com/events/1420561224855249/ THANK YOU, GRAVITY SOUND BAR | ["Music", "Clatter"] | ["instrumental", "fast tempo", "electronic music", "dj", "punchy", "vibrant", "youthful", "buoyant", "spirited", "dance music", "vibrant", "perky", "club music", "punchy bass lines", "synthesiser articulation", "pulsating", "sonic power", "dance music", "edm", "table turner", "drum machine"] | 7 | 2xtOqrNKH5s | 423 | |
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;