musiccaps_details (view)

2 rows where musiccaps_aspects contains "enigmatic", musiccaps_aspects contains "mysterious", musiccaps_names contains "Music" and musiccaps_names contains "New-age 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
Enya - Evening Falls A female vocalist sings this delicate harmony. The tempo is slow with an organ accompaniment. It is soft, mellow, meditative, enigmatic, mysterious, melancholic and haunting. This song is a Modern Classical. 2006-11-01T15:54:46Z Servet Tonga Evening Falls video clip ["New-age music", "Music"] ["female singer", "opera", "organ accompaniment", "enigmatic", "mysterious", "soft", "mellow", "ethereal", "celestial", "new age", "meditative", "modern classical", "downtempo", "electronic", "melancholic", "celtic new age", "celtic folk music", "delicate", "haunting", "sublime", "soft", "mellow", "delicate"] 7 _nrz_BawPMY 3492
Wind Chimes in a Bakery - Episode 4: The Lost and the Found This is an instrumental movie music piece used in the background of a short film. There is a gentle melody being played by the strings and the piano. The atmosphere is eerie and enigmatic. This piece could suit well in the soundtrack of a mystery video game or a movie. 2013-08-02T16:13:52Z Samsung Malaysia Get the official soundtrack from the Wind Chimes in a Bakery mobile app, now available for download via Google Play! https://play.google.com/store/apps/details?id=com.vintedge.windchimes Adam rediscovers the plans Sue had for their dream bakery. Will he pursue the dream to keep their love alive? ["New-age music", "Music"] ["movie music", "instrumental", "strings", "piano", "gentle playing", "eerie", "mysterious", "enigmatic"] 9 z3UCnloQGPY 5455

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;