musiccaps_details (view)

1 row where musiccaps_aspects contains "ambient background", musiccaps_aspects contains "meditation song" and musiccaps_aspects contains "slow tempo"

✎ 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
Chinese New Age Music, 二胡 (Erhu), Madrigal, 严洁敏(Yan Jiemin), This instrumental song features a Chinese fiddle. The song has an oriental feel. The fiddle is accompanied by a bass playing the root notes of the chords. Another medium pitched instrument plays chords in the background. Bells and chimes are played to add more melody to this song. There is no percussion in this song. There are no voices in this song. This song can be played in a meditation center. 2010-05-30T12:38:35Z moonbaby1962 Composer and musician Yan Jiemin is is an associate professor at China's Central Conservatory of Music. Known globally, she is a highly respected musician performing many genres of music. This production combines traditional Chinese theme and composition with a New Age production style, therefore I refer to this recording as being Chinese New Age Cross-Over Music. I highly recommend listening to any of Yan Jiemin's work. She is amazing. I do not own any content within this video. ["New-age music", "Music"] ["chinese fiddle", "oriental song", "no voice", "instrumental", "meditation song", "bells and chimes", "dreamy song", "bass", "no percussion", "ambient background", "slow tempo"] 0 0sPVAP17w2U 216

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;