musiccaps_details (view)

3 rows where musiccaps_aspects contains "mellow" and musiccaps_author = 8

✎ 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
ΠΑΡΕ ΜΕ ΑΠΟΨΕ ΑΓΚΑΛΙΑ Mellow rock with a slow drum beat, acoustic strumming guitar, male and female vocalists singing in octaves. 2009-01-19T13:00:52Z kreta1giouli1cagapaw Gia pragmatika erwteumenous pou 3anazoun to oneiro ap thn arxh.. ["Christian music", "Music"] ["acoustic guitar strumming", "slow rock", "male and female singing in octaves", "mellow"] 8 5rsQHo-6DI4 700
SOUND OF INSPIRATION - IMPIAN (LIVE AT UNPAD) Lush synth pads with reverb are accompanied by ambient static sounds which give way to a filtered male vocal over a simple, filtered electronic drum beat, giving a mellow ethereal feel to the music. 2014-05-11T03:46:42Z SoundOfInspiration http://soundcloud.com/soundofinspiration ["Music", "Psychedelic rock"] ["synth pad", "ambient static sounds", "ethereal", "reverb", "filtered male vocal", "filtered electronic drum beat", "lush", "simple beat", "mellow"] 8 AVG-Wmdd2yU 1123
Wedding Cakes modern folk rock or indie with fingerstyle acoustic guitar and smooth male vocals. The vocal production is loud. Drums are present with the ride cymbal playing a steady pattern and the snare being played with brushes. The mood is mellow. 2006-10-14T17:56:57Z jamesgrissel Cakes by Rachael ["Music", "Happy music"] ["smooth male vocals", "steady ride cymbal pattern", "fingerstyle acoustic guitar", "loud vocal production", "snare played with brushes", "mellow", "modern folk rock", "indie folk"] 8 EremEyLrdUY 1594

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;