musiccaps_details (view)

1 row where musiccaps_aspects contains "engaging", musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "home video" and musiccaps_names contains "Steelpan"

✎ 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
"Fanfare" - Hang Drum Solo by Dante Bucci This song is an instrumental. The tempo is fast with a lively keyboard harmony and rhythmic steel pan . It is minimal and rhythmic. The harmony is simple , straight and the steel pan adds an interesting layer to it. The music is engaging, interesting, energetic, spirited and melodic. 2008-08-13T16:11:38Z Dante Bucci This is a solo acoustic version of "Fanfare" performed on the HandPan (PANArt Hang). Dm Pentatonic Scale: (D) A C D F G A C F major Pentatonic Scale: (F) A Bb C E F A Bb C Copyright 2008 Dante Bucci UFOTunes/ASCAP. http://itunes.dantebucci.com http://facebook.dantebucci.com ~~~~~~~~~~~~~~~~~~~~~~~ If you want a HandPan: The makers of the "Hang" are no longer creating a musical instrument. PANArt is now focusing on creating a tool for meditation that does not follow the conventions of traditional musical notes. If you would like to purchase a hand-pan, I would suggest you look into one of the several other instrument makers who are creating very high-quality instruments. Websites for other Hand-Pan makers: www.spacedrum.fr www.bellart.es www.pantheonsteel.com www.balisteelpan.com www.caisa-music.com ["Music", "Steelpan"] ["instrumental", "fast tempo", "pleasant sounds", "simple harmony", "energetic", "spirited", "vibrant", "engaging", "steel drums", "steel pan", "rhythmic", "resounding melody", "african percussion", "pannist", "lively keyboard accompaniment", "home video", "stainless steel instrument", "recycled instrument", "acoustic steel drum"] 7 UNJswfXKJ3s 2909

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;