musiccaps_details (view)

1 row where musiccaps_aspects contains "indie", musiccaps_aspects contains "instrumental", musiccaps_aspects contains "no singer" and musiccaps_names contains "Guitar"

✎ View and edit SQL

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

CSV options: 

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;