musiccaps_details (view)

4 rows where musiccaps_aspects contains "mellow" and musiccaps_names contains "Happy 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
Lady Cab Driver (Video) The song has a laid-back, unfussy feel to it. There are various instruments layered to form a smooth, groovy, yet mellow song. The song would be categorized as pop rock, owing to the electric guitar lick and prominent electric guitar chord plucking. There's also an organ and an electric piano. The singer sounds soulful but relaxed. 2012-11-16T14:08:25Z johnny j rivera Lady Cab Driver (Video) ["Music", "Happy music"] ["electric guitar lick", "pop rock", "electric guitar chord plucking", "mellow", "laid-back jazzy rock", "simple jazzy rock drumming", "organ chords", "smooth"] 3 4Bc9OoagYmo 545
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
Donkey Kong Country Piano Water Theme Music The low quality recording features an arpeggiated synth melody, followed by synth pad chords. It sounds mellow, soft and relaxing, while the recording is noisy. 2007-10-17T11:35:19Z jcondkc Water theme from DKC. (abridged) ["Music", "Happy music"] ["low quality", "noisy", "arpeggiated synth melody", "synth pad chords", "mellow", "soft", "relaxing"] 4 PQXYWc3JHhU 2534
insomnia female version (acoustic) This is a pop music piece. There is a female vocalist singing melodically in the lead. The acoustic guitar is playing the main tune while the bass guitar is playing in the background. The rhythm is provided by a slow tempo acoustic drum beat. The atmosphere is emotional. This piece could be used in the soundtrack of a romance movie where the characters are missing each other at night. 2010-01-21T06:26:22Z drauf insomnia female version ["Music", "Happy music"] ["pop music", "ballad", "female vocal", "melodic singing", "acoustic guitar", "bass guitar", "acoustic drums", "slow tempo", "mellow", "emotional"] 9 bxF2vxTzlvo 3666

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;