musiccaps_details (view)
2 rows where musiccaps_aspects contains "enthusiastic" and musiccaps_names contains "Electronic dance music" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- dj 2
- enthusiastic · 2 ✖
- youthful 2
- club music 1
- dance club 1
- dance floor 1
- dance hits 1
- dance music 1
- edm 1
- electronic dance music 1
- electronic instrumental 1
- electronic music 1
- electronic pop 1
- energetic 1
- enigmatic 1
- exciting 1
- fast tempo 1
- groovy bas slime 1
- groovy dance rhythm 1
- instrumental 1
- keybiard accompaniment 1
- medium tempo 1
- party hits 1
- passionate 1
- people dancing 1
- percussion hits 1
- pop 1
- psychedelic 1
- rapid tempo 1
- recurring vocal riff 1
- sonic effects 1
- synth pop 1
- synthesised vocal riff 1
- synthesiser arrangements 1
- techno dance music 1
- techno drumming rhythm 1
- trance 1
- trance dance music 1
- trance music 1
- trap 1
- vigorous drumming 1
musiccaps_names (array) 7 ✖
- Dubstep 2
- Electronic dance music · 2 ✖
- Music 2
- Drum and bass 1
- Electronic music 1
- Harmonic 1
- Techno 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Da Blitz - Moving On (mickey o'hare & dj harmonic remix) | This song is an electronic instrumental. The song is fast tempo with vigorous drumming and electronic instrumentation and synthesiser articulation with catchy synthesised vocal riff which. The song is upbeat, vibrant, vivacious, vigorous, psychedelic, enigmatic and youthful with a trance like dance vibe. This song is an EDM/Synth pop. | 2012-04-17T14:06:31Z | MakinaMuzika | www.facebook.com/makinamuzika | ["Music", "Techno", "Dubstep", "Electronic dance music", "Harmonic"] | ["edm", "instrumental", "fast tempo", "synth pop", "edm", "electronic pop", "electronic instrumental", "synth pop", "dance hits", "rapid tempo", "dance music", "trance", "trap", "psychedelic", "pop", "electronic music", "vigorous drumming", "synthesiser arrangements", "synthesised vocal riff", "recurring vocal riff", "club music", "dance hits", "party hits", "youthful", "energetic", "enigmatic", "enthusiastic", "dj"] | 7 | lGaA1dJQ0AQ | 4387 | |
Mt Eden - Gambler | The song is an instrumental. The tempo is medium with a groovy drumming rhythm, percussive bass line, keyboard accompaniment and various percussive and sonic effects. The song is youthful and exciting with a trance element. The song is a modern tench pop dance tune. | 2010-12-02T12:18:30Z | Mt Eden Official | VIP version coming very soon FREE DOWNLOAD: Track 3 off our debut EP - "MEDS" Sample: (New Zealand) P-Money - Gamble. From the album "Big Things". Cover art by Craig Plant: craigplantartworks@hotmail.co.nz http://www.facebook.com/pages/Craig-Plant-Artworks/116296581769040?v=wall Support us!! Download and rate these tracks on itunes!! http://itunes.apple.com/nz/album/meds-ep-1/id409192438 OR Download the full EP for FREE here: http://www.mediafire.com/?itcp3vi40p7pmmw | ["Drum and bass", "Electronic music", "Music", "Dubstep", "Electronic dance music"] | ["techno dance music", "electronic dance music", "trance dance music", "medium tempo", "groovy bas slime", "techno drumming rhythm", "keybiard accompaniment", "percussion hits", "sonic effects", "dj", "dance floor", "dance club", "people dancing", "groovy dance rhythm", "trance music", "enthusiastic", "passionate", "youthful", "exciting"] | 1 | 66B46E_hrrk | 725 |
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;