musiccaps_details (view)

1 row where musiccaps_aspects contains "eerie", musiccaps_aspects contains "electronic music" and musiccaps_aspects contains "violin"

✎ 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
The Best Relaxing Sounds For Your Android This is an electronic music piece. There is a repeated piano theme in the melody. There are various eerie sound effects. Then, a violin starts playing. The atmosphere is unsettling. This piece would fit well in the soundtrack of a mystery video game. 2013-03-04T13:23:40Z Milan Jankovic Download App at http://bit.ly/relaxingsoundsapp If you have any unwanted stress in your life, take a deep breath and relax now, we have some self-help audios in the form of relax ringtones that will help you detach from your busy life. Whether you`re at home, at the office, resting or studying, you will forget all your worries and refresh your mood. If you want a good drug-free alternative, chill-out music will help you create soothing atmosphere. Chillout is relaxing, motivational, inspirational, perfect for home listening as background music. If you prefer subtle instruments that create peaceful state of mind, ambient music is the right choice. If you want soothing and calming experience and need something to fill in the silence, mood music will elevate your mood. ["Background music", "Electronic music", "Music", "Ambient music"] ["electronic music", "instrumental", "piano", "repeated theme", "sound effects", "violin", "unsettling", "eerie", "bizarre"] 9 XgLUXNAC7b8 3210

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;