musiccaps_details (view)
1 row where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "indie", musiccaps_aspects contains "single instrument" and musiccaps_names contains "Distortion"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Valentin The Mad - Hypnosis (Indie\Prog Rock Instrumental) | This is an instrumental progressive rock piece. The only instrument being played in the piece is a clean sounding electric guitar. There is a gently played guitar solo that gives a mellow aura. The atmosphere is dreamy. This piece could be used in the soundtrack of a movie or a TV show at a dream/flashback sequence. It could be playing in the background at a rock bar. | 2014-09-10T23:23:49Z | Valentin The Mad | Buy this track at: https://valentinbk.bandcamp.com/track/hypnosis Check out my other solo tracks at https://www.youtube.com/playlist?list=PLgrDAPIq_KbvO_kfrm7XSLIhEZHKKduOZ& Hypnosis is an Indie\Prog Rock track from my solo project. It will probably be the finishing track of the upcoming solo album (I have more writing to do, so everything is still open!). And like all of my other solo tracks this one was written and recorded entirely by me. See if you can spot Kelly (my cat) on this one :D Have a listen, and dont forget to share the video if you dig the music! Feel free to like my FB page: https://www.facebook.com/valentinthemad Or tweet me at: https://twitter.com/ValentinTheMad Equipment I used on this one: Guitar: Gibson Flying V Amptweaker TightRock Distortion Pedal MXR Six Band EQ Pedal TC Electronics Flashback for Delay Bugera V5 Amp Shure SM-58 microphone was used to record the guitar Bass: Traben Neo bass guitar Audio recorded using Edirol UA-25. Audio edited using Cubase 7 Elements. Guitar VST - Guitar Rig 4 Drums VST - Addictive Drums Video recorded using Sony HDR-CX290E Video edited in Vegas Movie Studio HD 13 | ["Bass guitar", "Effects unit", "Electric guitar", "Guitar", "Heavy metal", "Music", "Musical instrument", "Rock music", "Progressive rock", "Plucked string instrument", "Distortion"] | ["progressive rock", "indie", "no singer", "single instrument", "instrumental", "electric guitar", "clean sound", "guitar solo", "gentle playing", "mellow", "dreamy", "hypnotic"] | 9 | bkzGHRpx5MM | 3647 |
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;