musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium to uptempo" and musiccaps_names contains "Electronic music" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- medium to uptempo · 2 ✖
- acoustic drums 1
- digital drum 1
- dubstep 1
- e-bass 1
- e-guitar 1
- male voices singing 1
- rock 1
- sub bass 1
- synth sound 1
musiccaps_names (array) 8 ✖
- Electronic music · 2 ✖
- Music 2
- Dubstep 1
- Grunge 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Rock music 1
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 | |
The Sunshine Underground - Put You In Your Place | This song contains a male voice repeating the same melody in a loop while another male voice is singing on top in a higher register. An acoustic drum is holding a four on the floor groove with a kick on every beat. The e-bass and e-guitar are playing along to the loop, repeating themselves. This song may be playing at a live concert downtown. | 2006-04-17T19:07:34Z | TomasTurbado | Videoclip indie rock | ["Electronic music", "Guitar", "Music", "Musical instrument", "Rock music", "Grunge", "Plucked string instrument"] | ["rock", "e-guitar", "e-bass", "male voices singing", "acoustic drums", "medium to uptempo"] | 6 | x7tOPTm31tQ | 5305 |
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;