musiccaps_details (view)
2 rows where musiccaps_aspects contains "acid house"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Smack Boom - Hitchcock | A dark, sexy techno or acid house beat; with a repetitive synthesizer sequence with a squelchy resonant filter. The kick pattern is four on the floor with swung hi-hats and a syncopated synth bass. There is a big clap on the backbeat with a long reverb tail. The tempo is medium and the singer is male, singing in a high chest voice. | 2009-02-20T22:46:41Z | Hitchcockmusic | Music video for UK based electro/electronica band, Hitchcock To keep up with all our news, live dates, new releases etc. join our Facebook page...http://www.facebook.com/pages/HITCHCOCK/7854523132 | ["Music", "Zing"] | ["synthesizer sequence", "resonant filter", "techno", "acid house", "four on the floor kick", "swung hi-hat", "long reverb", "syncopated synth bass", "male singer", "high chest voice", "dark", "sexy", "big clap"] | 8 | aUXKK9AmrPU | 3545 | |
| 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;