musiccaps_details (view)
1 row where musiccaps_aspects contains "enigmatic", musiccaps_names contains "Music" and musiccaps_names contains "Zing"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;