musiccaps_details (view)

1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "relaxing song", musiccaps_names contains "Acoustic guitar" and musiccaps_names contains "Harmonic"

✎ 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
Bell’s Harmonic This instrumental pop song features an acoustic guitar being played fingerstyle. The notes are being plucked. Guitar harmonics are played in between the plucked notes. This song is played at a moderate tempo. There is no percussion in this song. There are no other instruments in this song. The mood of this song is relaxing. This song can be played in a coffee shop. 2015-12-10T22:08:52Z Alan Gogoll Become a Supporter: https://www.youtube.com/channel/UC8NhGqX78q_bsuYtP-K9Oig/join Bell's Harmonic by Alan Gogoll 💿 Stream/Support → https://open.spotify.com/playlist/37i9dQZF1DZ06evO4C2uGb 🌅 Website → https://www.alangogoll.com Seahorse Bells is the fifth studio album from Australian Solo Acoustic Guitarist Alan Gogoll. Each of the five original compositions showcases Alan's original 'Bell Harmonics' technique and guitar tunings that have become his signature sound and featuring for the first time his signature Paul Mineur guitar. ["Guitar", "Acoustic guitar", "Music", "Strum", "Harmonic", "Plucked string instrument"] ["pop song", "acoustic guitar", "fingerstyle", "harmonics", "moderate tempo", "no percussion", "no other instruments", "no voices", "easy listening", "relaxing song"] 0 9xV0nmojVeg 1051

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;