musiccaps_details (view)

1 row where musiccaps_aspects contains "gentle wind", musiccaps_aspects contains "keyboard harmony", musiccaps_aspects contains "pensive" and musiccaps_aspects contains "poignant"

✎ 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
Strymon BigSky - Shimmer Reverb machine audio demo This music is an instrumental, the tempo is medium slow with an insistent keyboard /amplified organ harmony, gentle electric guitar lead and ambient nature sounds in the background. The music is soft, mellow , soothing, pensive, meditative, reflective, nostalgic and poignant with the chirping of birds, sound of waves and gentle breeze. 2013-10-13T02:19:04Z strymon BigSky Reverberator gives you twelve studio-class, musically inspirational reverb machines. The Shimmer Reverb features two tunable voices add pitch-shifted tones to the reverberated signal, for resplendent, unearthly ambience. The voices are carefully created from the reverberated signal itself to generate maximum radiance and beauty. The Amount and Mode parameters allow for a range of shimmer effects from laid-back and subtle to full-blown majestic splendor. More info on BigSky: http://strymon.net/bigsky More BigSky videos: http://youtube.com/strymon All sounds recorded direct using a Damage Control tube preamp. No additional effects were used. Sounds performed by Strymon's DSP engineer Pete Celi and Strymon's marketing guy Ethan Tufts. Thanks for listening! :) ["Reverberation", "Background music", "New-age music", "Music", "Ambient music"] ["instrumental", "slow tempo", "electric guitar lead", "breeze", "waves", "gentle wind", "mellow", "soothing", "melancholic", "pensive", "poignant", "reflective", "melodic", "simple", "keyboard harmony", "ambient sounds of nature", "birds chirping", "amplified organ"] 7 HrxfNVYirCo 1842

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;