musiccaps_details (view)

1 row where musiccaps_aspects contains "applied guitar", musiccaps_aspects contains "sad", musiccaps_names contains "Electronic tuner" 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
RAMBO: FIRST BLOOD Theme ( 1 of 2 ) Guitar Lesson This music is instrumental. The tempo is slow with an electric guitar harmony. It is mellow, sad, sentimental,sombre, poignant and emotional. This music is a movie theme melody. 2010-01-30T17:12:46Z Guitar Lessons BobbyCrispy TABS FOR THIS LESSON AVAILABLE ON MY NEW GUITAR LESSON WEBSITE: https://guitarlessonvideoswithtabs.yolasite.com/RAMBO---FIRST-BLOOD.php How to play the theme from the movie Rambo: First Blood. Guitar lesson with step by step method with easy to follow tabs in the video. TABS for this lesson available on my guitar lesson website: http://bobsguitarlessons.yolasite.com/ Part 2 of 2 http://youtu.be/qBD6b3oouaw E-------------9----12------12--11--------------------- B----7--9------------------------------14---9----12--- G---------------------------------------------------------- D---------------------------------------------------------- A---------------------------------------------------------- E---------------------------------------------------------- E------------------------------------------------------------- B----14--12----12----7---9----10-----10--12----7--- G------------------------------------------------------------- D------------------------------------------------------------- A------------------------------------------------------------- E------------------------------------------------------------- E-------------9----12------12--11--------------------- B----7--9------------------------------14---9----12--- G---------------------------------------------------------- D---------------------------------------------------------- A---------------------------------------------------------- E---------------------------------------------------------- E---------------------------------------------------------------- B----9--12---12----7----7----9---10------5--7-----9---- G---------------------------------------------------------------- D---------------------------------------------------------------- A---------------------------------------------------------------- E---------------------------------------------------------------- E--------9---9--------------14--12---9--10---9------------------------- B----9-------------12---------------------------------12----7----5--7--- G---------------------------------… ["Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] ["instrumental", "slow tempo", "electric guitar melody", "sombre", "emotional", "pensive", "movie soundtrack", "movie theme music", "clear", "string instrument", "applied guitar", "sad", "melancholy", "poignant", "pensive"] 7 jjNxc9Zf9s8 4277

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;