musiccaps_details (view)
1 row where musiccaps_aspects contains "electric guitar lead", musiccaps_aspects contains "melancholic", musiccaps_names contains "Music" and musiccaps_names contains "Reverberation"
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
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;