musiccaps_details (view)
1 row where musiccaps_aspects contains "fast", musiccaps_aspects contains "repetitive driving bass" and musiccaps_author = 8
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 |
---|---|---|---|---|---|---|---|---|---|---|
Tristan Live Set @ Sunshine Festival 2014 | A fast techno four on the floor beat with a repetitive driving bass, wild synthesizer sounds processed with delay. An energetic feeling that might be considered acid house. | 2014-09-17T17:01:47Z | Tristan | Subscribe: http://bit.ly/SubscribeDJTristan Tristan Live Set @ Sunshine Festival 2014 with Grasshopper Records; Dj's Hatta, Dala, Taku, Cylon, Helber Gun and many more. One of the best events I have ever been to in Japan.... Amazing! Track: Tristan & Aardvarkk - Probability Space Follow Tristan: Facebook: https://www.facebook.com/djtristanfanpage Soundcloud: https://soundcloud.com/djtristan Twitter: https://twitter.com/djtristancooke Instagram: https://www.instagram.com/djtristanofficial/ With a career as long as psy-trance has history and playing at some of the most important festivals such as Boom, Ozora, Antaris, Universo Parallelo, Sonica, Psyfi, Neverland, Indian Spirit & many more, Tristan and his music have a massive following of dedicated fans who love his full-on journeys of deep gurgling psychedelia. Tristan’s innate sense of the dancefloor and full power psychedelic moments place him in a league of only the very highest calibre of producer. Having collaborated with the likes of Raja Ram, Astrix, Vini Vici, Hallucinogen, Ace Ventura, Dickster, Pogo, GMS, Burn In Noise, Outsiders, Manmademan, & Mandala, and releasing with Twisted, Tip, Matsuri & Iboga, he is now fully onboard with the NANO Records family. Tristan is also part of the projects Killerwatts (with Avalon) and Fearsome Engine (with Laughing Buddha). This channel is powered by Trancentral. http://bit.ly/TrancentralSubscribe | ["Music", "Trance music"] | ["techno", "four on the floor kick pattern", "acid house", "repetitive driving bass", "wild synthesizer sounds with delay", "instrumental", "fast", "energetic tempo"] | 8 | cd5BIQoHyPI | 3725 |
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;