musiccaps_details (view)

1 row where musiccaps_aspects contains "relaxing music", musiccaps_aspects contains "soothing", musiccaps_names contains "Ambient 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
"Christmas Music 2014": BABY SONGS, lullabies for children to go to sleep on xmas holidays The song feels relaxing, soothing and gentle. It feels like the kind of music that you would play if you wanted to fall asleep. It features a gentle and dainty electric piano with a flanger, as well as a sustained synth pad. 2013-12-19T01:00:00Z Relax River - Relaxation Flows in You ► please sub http://www.youtube.com/subscription_center?add_user=relaxriverofficial What is the best time to enjoy family and be together? The Christmas holidays, which can be enlivened with the best music for holidays. We wish you a merry (and relaxing) Christmas. ...more great relaxing music to come! Relaxriver provides you music for relaxation, study and meditation. We are a collective of musicians who compose calming music for passion, everyday. We hope that what we like is exactly what you like: using music to free our minds, reach a state of peaceful joy and soothingness. With our relaxing music you can afford mental and physical relief, motivate yourself, sleep better, chill, free yourself from fears and anxiety, and restore selfconfidence. Relaxriver: your daily stream of wellness. Are you feeling comfy now? You can find us also on twitter: http://twitter.com/relax_river ["New-age music", "Music", "Ambient music"] ["soothing", "calming", "gentle", "meditation music", "sleeping music", "relaxing music", "lullaby music", "atmospheric angelic synth", "high pitched wobbly synth", "flanger"] 3 YlV45uBUVBc 3309

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;