musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic music", musiccaps_aspects contains "female vocalist", musiccaps_author = 7 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 | |
Multifemales│I am woman {Collab w/ thegurlfrom12} | A female vocalist sings this enthusiastic song. The tempo is fast with keyboard harmony, infectious drumming, turntable effects, digital drumming, electronic music arrangements, boomy bass lines, vocal backup, vocalisation and synthesiser articulation. The song is passionate, emotional, powerful, impactful, engaging and inspiring with a punchy and youthful dance groove. This song is a powerful Synth Pop. | 2014-08-27T14:21:07Z | Divergent Nephilim | ► My first collab! :D And I'm really happy, she's an amazing editor and even more amazing person, thank you so so so much hunnie and hope we'll do more collabs :) And, of course, don't forget to subscribe to her, she's awesome: https://www.youtube.com/channel/UCqXPViM5obueUWuKar1OJCQ ► Fandoms: Teen Wolf Kick Ass 2 Vampire Diaries Vampire Academy The Originals TMI: City of Bones Divergent The Avengers The Hunger Games & Catching Fire Pretty Little Liars Lucy Harry Potter Brave silver linings playbook Anacondas X Men Miss Congeniality ► Song: I am woman, by Jordin Sparks THANKS FOR WATCHING! ♥ Like, comment and subscribe for more videos ☺ | ["Music", "Zing"] | ["female vocalist", "fast tempo", "distorted audio", "syth pop", "youthful", "inspiring", "powerful", "passionate", "emotional", "vocal backup", "vocalisation", "feminist", "feminism", "female power", "girl power", "turn table effects", "boomy bass drops", "keyboard harmony", "static", "electroni music", "boomy", "thumping beats", "inferior audio quality", "muddled audio", "muffled", "synthesiser articulation", "electronic music", "digital instrumentation"] | 7 | HFH9tcIK_PM | 1784 |
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;