musiccaps_details (view)

2 rows where musiccaps_aspects contains "home music video", musiccaps_author = 1 and musiccaps_names contains "Blues"

✎ 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
My Grandfather's Clock with tabs The song is an instrumental. The song is medium tempo with an electric guitar playing lead and distorted guitar rhythm, along with groovy bass line and rock drumming rhythm. The song is exciting and spirited. The song is a classic rock instrumental with poor quality audio. 2007-08-16T21:36:56Z Rockaholick1 This video got mirrored when I recordet it! I do not play a left-handed guitar in this video!! Sponsored by Dean Markley inc.: http://www.deanmarkley.com/ If you like what you hear then SUBSCRIBE, as I probably will be releasing more material soon! For tabs and backing track, go here: http://kabudono01.s344.xrea.com/download_ookina/ A SPECIAL THANKS TO ALL WHO LEAVE A COMMENT AND RATING! A pure Rock N' Roll song for all the Rockaholics out there! Played with the amazing Gibson Custom EDS-1275! ["Blues", "Heavy metal", "Music", "Punk rock", "Rock music", "Progressive rock"] ["instrumental music", "guitar lead", "spirited", "song cover", "passionate", "home music video", "high spirits", "never give up", "adventurous", "classic rock playlist", "relaxing", "driving song", "distortion guitar accompaniment", "rhythm guitar", "classic rock instrumental", "memdium tempo", "groovy bass line", "steady rock drumming", "high on adrenaline", "poor audio quality"] 1 Lrhy2auO6hY 2226
Owen Barry , Vertex Effects Landau stereo chorus, Victoria The song is an instrumental. The song is medium tempo with an amplified guitar solo lead, complete with knob flicking tones. The song is loud and energetic. The audio quality is poor and recorded live at home. 2014-06-11T21:10:50Z owen barry   ["Blues", "Echo", "Effects unit", "Electric guitar", "Music", "Distortion"] ["electric guitar lead", "poor audio quality", "rock solo", "guitar amplifier", "home music video", "guitar tone test demo", "medium tempo", "rock guitar lead", "tremolo tones", "echo tones", "amplifier knob flicks", "loud music", "emotional", "passionate", "exciting", "medium tempo", "guitar licks"] 1 R4b_-IT43P4 2663

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;