musiccaps_details (view)
2 rows where musiccaps_aspects contains "ambient", musiccaps_author = 7 and musiccaps_names contains "Zing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- ambient · 2 ✖
- edm 2
- electronic music 2
- synthesiser articulation 2
- animated 1
- animated vocals 1
- beeping 1
- charming 1
- club music 1
- dance floor 1
- dance groove 1
- dance music 1
- dj 1
- dj mis 1
- dj mix 1
- dj mixer 1
- droning rhythm 1
- electro pop 1
- electronica 1
- enigmatic 1
- enthusiastic 1
- fast tempo 1
- female vocalist 1
- hypnotic 1
- incessant 1
- male singer 1
- meditative 1
- medium tempo 1
- minimalist 1
- psychedelic 1
- scratching sounds 1
- synth pop 1
- turn table 1
- video game like electronic beep 1
- vigorous 1
- vinyl records 1
- vital 1
- world music 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 2
- Zing · 2 ✖
- Drum and bass 1
- Electronic dance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
L Plus - Taking Me Higher | A female vocalist sings this enigmatic electro pop. The tempo is medium with synthesiser arrangements and electronic music layers. The vocals are monotone, incessant and droning like the music and have a hypnotic, trance like vibe. The song is youthful, ambient, enigmatic and meditative. | 2012-06-16T07:40:53Z | Liquicity | Next level freshness! Forthcoming on Technique Recordings: 24th June PreOrder the EP - iTunes: http://bit.ly/LPlusAzgiT Share on Facebook: http://tinyurl.com/d5gc8m2 Video: Special thanks to Jorge Jimenez, Stefan Wiesner & the Hubble telescope for providing material and letting me use it to make this video. Jorge Jimenez's profile on Vimeo: http://vimeo.com/iryoku Stefan Wiesners profile on Vimeo: http://vimeo.com/escanar Who is L Plus? Hailing from Bratislava in Slovakia, D&B producer L Plus has already forged an enviable career as a DJ and producer. Since signing exclusively to Technique Recordings in 2011, he's been honing his unique sound, with releases like his "Time Travel" EP, "Catastrophe", and remixes for scene luminaries like Crissy Criss and Tantrum Desire. L Plus: Become an Lplus fan: http://www.facebook.com/lplus Soundcloud: http://soundcloud.com/lplus Technique Recordings: http://www.techniquerecordings.co.uk Join Liquicity Records Soundcloud & Beatport! Beatport Page: http://beatport.com/label/liquicity-records/25942 Soundcloud Page: http://soundcloud.com/liquicityrecords Free Liquicity Wallpaper: http://tinyurl.com/cc6fy44 [Liquicity Merchandise:] EU: http://liquicity.spreadshirt.nl/ USA http://liquicity.spreadshirt.com Liquicity Social Media: Facebook:http://www.facebook.com/OfficialLiquicity Twitter: https://twitter.com/#!/Liquicity | ["Drum and bass", "Music", "Zing", "Electronic dance music"] | ["female vocalist", "medium tempo", "electronic music", "psychedelic", "incessant", "droning rhythm", "synthesiser articulation", "beeping", "video game like electronic beep", "minimalist", "ambient", "meditative", "hypnotic", "psychedelic", "incessant", "world music", "enigmatic", "charming", "electronica", "edm", "synth pop"] | 7 | Eop_sG9FVgA | 1592 | |
Voice Hands Machine - Take Your Hand | A male vocalist sings this spirited song. The tempo is fast with electronic instrumentation, synthesiser articulation and turn table. The song is spirited,youthful , enthusiastic, energetic, vigorous and vital. This song is an EDM/ Synth Pop song. | 2011-06-26T23:35:39Z | VoiceHandsMachine | Voice Hands Machine - Take Your Hand GET IT on ITUNES: http://bit.ly/tyhitu Website: http://bit.ly/vhm_www Facebook: http://on.fb.me/vhm_fb TAKE YOUR HAND is the new single from the fresh Paris talent, Voice Hands Machine. | ["Music", "Zing"] | ["male singer", "fast tempo", "edm", "electro pop", "dj mix", "youthful", "animated", "vigorous", "vital", "enthusiastic", "dance groove", "electronic music", "turn table", "dj", "animated vocals", "synthesiser articulation", "scratching sounds", "vinyl records", "dj mis", "dj mixer", "dance music", "dance floor", "club music", "ambient"] | 7 | X7qFgrAl3OU | 3163 |
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;