musiccaps_details (view)

1 row where musiccaps_aspects contains "danceable", musiccaps_aspects contains "steelpan" 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
Rihanna - Work (Steelpan Cover) The song features a steelpan that creates the main melody. The sounds are bright and have a positive atmosphere. The track fits the afrobeat genre. In the background there are drums that play a mix between hip-hop and afrobeat patterns. A percussion synth creates a counter melody that contrasts the whole instrumental. This is a song you would play at a beach party in the caribbean at night. 2016-03-26T01:45:08Z Keishaun Julien Keishaun Julien playing "Work" by Rihanna & Drake on the Steel Pan. LIKE,SHARE & SUBSCRIBE!! http://www.facebook.com/Keishaun.Julien http://www.twitter.com/keishaunjulien http://www.keishaunjulienmusic.com Instagram.com/keishaunjulien Credits: Audio recorded at 5000 Entertainment https://www.facebook.com/5000ENT/ Instrumental courtesy Karaoke Masterpieces https://www.youtube.com/channel/UCtP9... Video Shot & Edited by: Keishaun Julien MP3 Download https://soundcloud.com/keishaun-justin-julien http://bit.ly/2ttOelG Notes http://bit.ly/2ttruTd ["Music", "Steelpan"] ["steelpan", "afrobeat", "upbeat", "chill", "smooth", "bright", "positive", "no vocals", "fast tempo", "danceable", "percussion synth"] 5 E3iPiZlT6f8 1529

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;