musiccaps_details (view)

2 rows where musiccaps_aspects contains "foreign language", musiccaps_aspects contains "keyboard harmony", musiccaps_aspects contains "steady drumming" and musiccaps_names contains "Folk 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
tsehay yohannes - Old music A male vocalist sings this lilting melody. The tempo is medium with keyboard harmony, groovy bass line, steady drumming and mandolin harmony. The song is emotional, romantic, soulful, sentimental and soothing. This song is Regional Pop, 2012-06-02T11:28:06Z Banchi Avera This song taking me back to my past ......... ["Folk music", "Music", "Tender music"] ["male singer", "medium tempo", "foreign language", "romantic", "soulful", "mandolin", "steady drumming", "soulfulromantic", "soulfu", "soothing", "calm", "soulful", "emotional", "love song", "folk song", "world music", "funky bass line", "keyboard harmony", "acoustic guitar"] 7 c9h4p6325Xo 3684
Gezuar 2016: Shyhrete Behluli - N'daq nafaka me t'ba lum A female vocalist sings this captivating melody. The tempo is medium with enthusiastic drumming, soft keyboard harmony, steady bass lines and a middle eastern instrument. The song is rhythmic, catchy, peppy, vivacious and has a dance groove. This song is a Regional Pop song. 2015-12-08T19:33:06Z VizioniLibonia Onair Media - https://smarturl.it/Onair.Media Follow VizioniLibonia on… FB: https://smarturl.it/VizioniLiboniaFB IG: https://smarturl.it/VizioniLiboniaIG Subscribe: https://smarturl.it/VizioniLiboniaSub © & ℗ VizioniLibonia & Onair Media. All Rights Reserved ["Singing", "Folk music", "Music"] ["female singer", "medium tempo", "foreign language", "regional pop", "world music", "tambourine", "unique instrument", "captivating", "steady drumming", "percussion instrument", "simple bass lines", "keyboard harmony", "arabic music", "middle eastern music"] 7 sZwZ2fOWWSg 4962

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;