musiccaps_details (view)

2 rows where musiccaps_aspects contains "folk music", musiccaps_aspects contains "regional music" and musiccaps_aspects contains "string instrument"

✎ 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
Kabul Afghanistan 1978-79 - Rabab & Tabla (Rubab) This music is instrumental. The tempo is medium with a lilting middle eastern kind of melody on a string instrument that sounds like a santoor along with a classical tabla accompaniment. The music is traditional, classical, captivating, romantic and nostalgic. This music is an Eastern Classical instrumental. 2011-06-18T23:13:06Z Noor Khan 'Nastaran' - Recorded one snowy night in Kabul, February 1978 Rabab - Mir Mohammad, Tabla - Jan Mohammad *** More photos plus samples of a new completely different book about Pakistan (Khyber Pukhtunkhwa-NWFP) at http://www.pbase.com/noorkhan ["Tabla", "Drum", "Percussion"] ["instrumental", "medium tempo", "middle eastern music", "eastern classical", "santoor", "nostalgic", "romantic", "beautiful", "traditional", "regional music", "folk music", "captivating", "string instrument", "classical music", "oud", "arabic music", "pleasant", "mesmerising", "romantic", "santoor harmony", "tabla accompaniment", "hand percussion"] 7 KJHqQ5aKu8U 2073
Baraha Jewellery, Jordan, Hong Kong This music is instrumental. The tempo is slow with a harmonious melody of string instruments, percussion and wind instruments which sound like the Indian Sarangi, dhol or madal , shakers and a flute. The music is classical, simple, enchanting and melodic. This song is a Folk song Instrumental. 2012-09-06T16:53:26Z DigitalEyeHK Baraha Jewellery, Jordan, Hong Kong. www.barahajewellery.com. FOR MORE VIDEO http://www.jpthk.com ["Traditional music", "Music"] ["instrumental", "medium tempo", "flute", "string instrument", "cheerful", "charming", "classical", "melodic", "sarangi", "madal", "folk music", "country music", "regional music", "folk song", "shakers", "hand percussion"] 7 otVPTo72q4w 4662

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;