musiccaps_details (view)

3 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "minimalist", musiccaps_aspects contains "nostalgic" and musiccaps_aspects contains "sentimental"

✎ 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
Kenny Rogers & Dolly Parton - Sometimes When We Touch This music is a soft instrumental. The tempo is slow with a beautiful keyboard harmony. The music is soft, mellow, sentimental, nostalgic, melancholic and romantic. This song is classic pop. 2009-06-23T23:40:32Z Kristin Tehvan One of the best love songs ever. ["Electric piano", "Keyboard (musical)", "Piano"] ["instrumental", "slow tempo", "keyboard harmony", "pop", "classic pop", "melancholic", "nostalgic", "minimalist", "song introduction", "soft", "mellow", "romantic", "melodic", "emotional", "sentimental", "love song"] 7 BMxgDBoPv_0 1233
ne-yo why does she stay A male vocalist sings this emotional R&B song. The tempo is slow with a melancholic piano accompaniment with drum machine arrangement. The song is an emotional , soulful, pensive, sentimental,melancholic, romantic love song. This song is a Soul/R&B. 2008-09-25T21:35:05Z X-tazi ne-yo why does she stay from the new album-Year Of The Gentleman ["Music", "Tender music"] ["male vocalist", "slow tempo", "soft", "mellow", "minimalist", "smooth jazz", "blues", "sad", "poignant", "ambient piano", "drum machine", "soul", "r&b", "love song", "pensive", "melancholy", "nostalgic", "emotional", "sentimental"] 7 C-1i2GlbiIY 1313
Very sad rabab music رباب by gulnoor parachinar This music is instrumental. The tempo is slow with an Oud solo. The music is minimalist, simple, melancholic, nostalgic, emotional, wistful, pensive; poignant and intense. This is Middle Eastern classical music. 2014-09-29T13:20:28Z Gulfam Hussain Noor Gulfam Hussain Noor Zeran Lalmay Parachinar Gulfam_12345@yahoo.com ["Music", "Middle Eastern music"] ["instrumental", "slow tempo", "oud melody", "classical music", "regional music", "arabic music", "middle eastern music", "stringed instrument", "melancholic", "lonely", "nostalgic", "sentimental", "emotional", "wistful", "minimalist"] 7 dSyue3RJllA 3788

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;