musiccaps_details (view)
5 rows where musiccaps_aspects contains "buoyant", musiccaps_aspects contains "dj", musiccaps_author = 7 and musiccaps_names contains "Dance 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Sandra Lyng - Electric City (Official Music Video) | A female vocalist sings this spirited pop. The tempo is fast with a spirited, upbeat acoustic guitar accompaniment, synthesiser arrangements, slick drumming, digital drum rhythm, boomy bass drop , added reverb and auto tune for better effects.The song is young, fresh, upbeat, bouncy, punchy, and has a dance groove.this song is a synth pop. | 2014-08-15T16:57:07Z | Sandra Lyng | Offisiell musikkvideo til "Electric City", den nye singelen til Sandra Lyng. Electric City er tilgjengelig på alle digitale plattformer, last ned og stream singelen her: - iTunes: https://itunes.apple.com/no/album/electric-city-single/id893197707?l=nb - Spotify: http://open.spotify.com/album/27Axz7vCZGIw1w1bQgqtIP - Wimp: http://wimp.no/album/31787918 - SoundCloud: https://soundcloud.com/sandra-lyng/sandra-lyng-electric-city | ["Jazz", "Music", "Dance music"] | ["female singer", "fast tempo", "auto tune", "boomy bass drops", "slick drumming", "digital drumming", "dj", "dance hits", "dance music", "club music", "dance groove", "groovy acoustic guitar accompaniment", "atmospheric synthesiser", "synthesised vocals", "vocal backup", "heavy reverb", "punchy", "bouncy", "youthful", "buoyant", "boomy bass drops", "spirited"] | 7 | 33dCbb1MyYU | 439 | |
| TAIWAN Melbourne Shuffle · 曳步舞 · 鬼步舞 【T.N.S 貓少] | This music is an Electronic instrumental. The tempo is fast with punchy, synthesised music and thumping drum beats on the drum machine. The music is youthful, energetic, enthusiastic,loud, buoyant, punchy, pulsating and electrifying. The sound quality is of inferior quality and there is a bit of static. | 2013-03-15T14:55:39Z | 魑魅鳳 | ["House music", "Music", "Shuffle", "Dubstep", "Electronic dance music", "Dance music"] | ["instrumental", "fast tempo", "electronic music", "buoyant", "youthful", "pulsating", "electrifying", "static", "inferior audio quality", "amateur recording", "edm", "punchy drumming", "synthesiser articulation", "dj", "dj mixer", "dance floor", "freestyle dance", "drum machine", "digital drumming", "digital music", "distorted sounds"] | 7 | JqmOqYtQqB8 | 2038 | ||
| D.White - Follow Me (Extended Mix Dj Manuel Rios) | This music is an Electronic dance instrumental. The tempo is medium fast with punchy drum beats and groovy electronic arrangements.The music is buoyant, energetic, electric, pulsating, youthful and vigorous. The thumpy, rhythmic bass and drumming gives it a groovy dance beat. | 2015-02-25T20:08:23Z | Kati G | D.White - Follow Me (Extended Mix Dj Manuel Rios) | ["Disco", "Funk", "Music", "Dance music"] | ["instrumental", "electronic music", "edm", "punchy", "trance", "psychedelic", "hypnotic", "bouncy", "thumping beat", "buoyant", "energetic", "youthful", "vigorous", "dj", "club music", "dj mixer", "drum machine", "dance beats", "dance groove", "dance floor", "pulsating", "electric", "percussive electronic music", "club music", "ambient", "youthful"] | 7 | LB0u0PrlDHU | 2160 | |
| DJ HumNoy Maraca YouTube | A male vocalist sings this energetic song. The tempo is fast with synthesiser arrangements, punchy digital drumming, tambourine beats and keyboard harmony. The music is upbeat, punchy, groovy, youthful, buoyant and exciting. This song is Synth Pop. | 2013-12-03T12:25:16Z | ณ๊องจุ้น คนเดิม | ["Music", "Song", "Dance music", "Maraca"] | ["male vocalist", "fast tempo", "energetic drums", "synth pop", "buoyant", "tambourine beats", "digital drum", "synthesiser arrangements", "keyboard harmony", "energetic vocal backup", "dj", "dj mixer", "dance pop", "dance music", "club music", "youthful", "enthusiastic", "vivacious"] | 7 | S7rP6coeLTY | 2742 | ||
| 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;