musiccaps_details (view)

1 row where musiccaps_aspects contains "ragga/drum&bass", musiccaps_aspects contains "synthesizer lead" and musiccaps_names contains "Salsa music"

✎ 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
Big Up Kemp Europe 2013. Workshop by Fatou Tera. Busy Signal - Life goes on The drums sound complex and fast paced going into the direction of drum&bass. Full of hihat and snare hits. Barely noticeable a synthetic bass is playing along with the drums giving this song a ragga feeling. A very simple synthesizer pad is playing a high pitched melody. The male voice sounds lower and energetic. This recording is of poor audio quality. This song may be playing at a dancing event or while working out. 2013-09-11T14:25:26Z BIG UP PRODUCTION Big Up Kemp is the first international dancehall camp in the world organized by Big Up Production. It was first organized in 2011 and became the biggest dancehall camp in the world. In 2013 Big Up Kemp will again take place in Russia and France! TWO camps, more teachers, more dancehall!!... Join us!! WWW.BIGUPKEMP.COM ["Jingle (music)", "Music", "Salsa music"] ["ragga/drum&bass", "amateur recording", "electronic drums", "synthesizer lead", "male rapping/singing voice", "bass"] 6 FsCQmTluSDw 1667

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;