musiccaps_details (view)
2 rows where musiccaps_aspects contains "ambient", musiccaps_author = 7 and musiccaps_names contains "Drum and bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- ambient · 2 ✖
- edm 2
- electronic music 2
- psychedelic 2
- synth pop 2
- synthesiser articulation 2
- amplified 1
- beeping 1
- charming 1
- club music 1
- dance groove 1
- digital drums 1
- dj 1
- droning rhythm 1
- electronic instrumental 1
- electronic tech 1
- electronica 1
- electronically 1
- enigmatic 1
- fast tempo 1
- female vocalist 1
- futuristic 1
- goth rock 1
- hypnotic 1
- incessant 1
- instrumental 1
- loud 1
- meditative 1
- medium tempo 1
- minimalist 1
- new-age 1
- new-wave 1
- progressive 1
- syncopated 1
- trippy 1
- video game like electronic beep 1
- world music 1
musiccaps_names (array) 6 ✖
- Drum and bass · 2 ✖
- Electronic dance music 2
- Music 2
- Dubstep 1
- Trance music 1
- Zing 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 | |
Skrillex - Cat Rats | This music is an electronic instrumental. The tempo is fast with synthesiser articulation, digital drumming and circuitry based technology. The music is loud, futuristic, contemporary, psychedelic, trippy ,hypnotic and youthful with a dance groove. This music is EDM. | 2010-12-18T14:02:03Z | SubExplosion | ["Drum and bass", "Music", "Trance music", "Dubstep", "Electronic dance music"] | ["instrumental", "fast tempo", "electronic music", "synthesiser articulation", "digital drums", "electronic instrumental", "loud", "amplified", "syncopated", "psychedelic", "trippy", "progressive", "futuristic", "edm", "new-age", "new-wave", "electronically", "ambient", "club music", "dance groove", "dj", "electronic tech", "synth pop", "goth rock"] | 7 | UhwJrftWAFg | 2935 |
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;