musiccaps_details (view)

1 row where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "oriental dance" and musiccaps_aspects contains "sensual"

✎ 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
Snake Dance This is an Oriental dance music piece. It is an instrumental piece. There is an oud and a new flute playing the melody. The rhythmic background is composed of percussive elements such as the def and the tambourine. The atmosphere is exotic and sensual. This piece could be used in the soundtrack of movies that take place in the Middle East region. 2010-10-03T09:53:01Z Myss Foss The Snake Dance which is part of Belly Dancing has always been liked by people of many cultures . The song is composed by Mohamed Abdel Wahab - Zeina Zeina is a great song to listening to. This Video is a tribute to all past/present women who fell in the love with the art of Belly Dancing over the ages. Hope you all enjoy... @myssfoss I would like to thank Mozar Zaryabe for telling me the name of the song and it's composer. The last seven years it's been called Snake Dance because that was the only information given to me. Now we know... "Zeina Zeina" thanks Mozar. ["Folk music", "Music"] ["oriental dance", "instrumental", "ney flute", "oud", "tambourine", "def", "exotic", "sensual", "vibrant"] 9 uRA5Ue30fsY 5113

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;