musiccaps_details (view)

1 row where musiccaps_aspects contains "calming", musiccaps_aspects contains "tinny wooden sounds", musiccaps_aspects contains "wide sustained strings melody" and musiccaps_names contains "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
AWAKEN TO LOVE by LIORA Harmonic Vocalist The low quality recording features an ambient song that consists of a wide sustained string melody going left and right through the stereo image. There are tinny wooden sounds in the background, as the recording is a bit noisy. Even though it is calming and relaxing, it is a bit disturbing too. 2008-01-11T05:54:33Z LIORA http://www.twinflame1111.com This beautiful video features the track "AWAKEN" off LIORA'S Galactic Harmonics cd.... for all of LIORA'S mp3 instant download cd's visit the website as above... The Teachings of the "Twin Flame Sacred Keys"....Collection !! Assisting Humanity's Ascension. VIBRATIONAL self Reunion = The SACRED Twin Flame Reunion....... ["Music", "Harmonic"] ["low quality", "noisy", "ambient", "wide sustained strings melody", "noisy", "tinny wooden sounds", "disturbing", "calming", "relaxing"] 4 o6ZQNr0Tpz4 4605

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;