musiccaps_details (view)
1 row where musiccaps_aspects contains "medium to uptempo", musiccaps_aspects contains "synth sound" and musiccaps_author = 6
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 |
---|---|---|---|---|---|---|---|---|---|---|
Charlie Sheen Bi-Winning Dubstep - Ephixa (Official) With MP3 Download Dubstep=Winning | This song contains digital drums playing a simple dubstep groove with a strong snare sound. A subbass along with an aggressive synth sound playing the same melody one octave higher. This song may be playing in a Dubstep/Drum&Bass club. | 2011-03-02T14:59:03Z | DjEphixa | Dubstep. Get the quotes on a shirt @ http://charliesheen.viralprints.com Dubstep remix of Charlie Sheens interview about his coke and hooker parties. Video by Going Quantum. Mp3: http://www.mediafire.com/?63lx43ifjcqgx0d Charlie Sheens Youtube: http://www.youtube.com/user/charliesheen Video Editing by Going Quantum. http://www.youtube.com/user/goingquantum *Important Links* Livestream: http://www.ephixalive.com Facebook: http://www.facebook.com/ephixamusic Twitter: http://www.twitter.com/ephixa Soundcloud: http://www.soundcloud.com/ephixa Youtube: http://www.youtube.com/djephixa Artwork http://www.monstercatdesign.com Go check out his channel if you're into quality mixes of dubstep, hard electro, trance, hardstyle. I put the track together in 3 hours for the lols. This is what I did instead of studying for an exam. Enjoy and tigerblood Website: http://www.ephixa.com Facebook: http://www.facebook.com/pages/Ephixa/137145782681 Twitter: http://www.twitter.com/ephixa Soundcloud: http://www.soundcloud.com/ephixa P.S. Charlie Sheen is a GOD | ["Electronic music", "Music", "Dubstep"] | ["dubstep", "digital drum", "synth sound", "sub bass", "medium to uptempo"] | 6 | c1hLduV1p88 | 3674 |
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;