musiccaps_details (view)
1 row where musiccaps_aspects contains "relaxing atmosphere" and musiccaps_aspects contains "wind"
This data as json, CSV (advanced)
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Glowworms in Motion - A Time-lapse of NZ's Glowworm Caves in 4K | This recording is full of environmental sounds. Birds singing, wind going, someone walking through water and water-dripping sounds. At the end a strongly reverbed kalimba starts playing a melody. The whole thing sounds relaxing and would fit good into a documentary or a meditation session guided by sounds of nature. | 2015-07-08T18:02:52Z | Stoked for Saturday | A Time-lapse of New Zealand’s Glowworm caves as they have never been seen before. Filming this involved sleeping in caves for multiple days in complete darkness with just the sounds of the cave to keep us company (and the occasional eel). Read the full story of how we pulled this off on our blog: http://bit.ly/GlowwormTimeLapse UPDATE: This video won New Zealand Geographic's 2015 Photographer of the Year award in the Time-lapse category About the Series: Living a Kiwi Life is about a Canadian couple (me and Jenna) who have lived in Canada all our lives and made the decision to move to New Zealand having never gone there before. We quit our jobs, sold our houses and cars and left everything we knew to explore an unknown. Stoked for Saturday Links: Blog: http://www.stokedforsaturday.com Instagram: https://www.instagram.com/stokedforsaturday Facebook: https://www.facebook.com/stokedforsaturday Twitter: https://www.twitter.com/Stoked4Saturday Snapchat: @stoked4saturday Music: Light Bridges - Dexter Britain Shot with: Canon 5D Mark III http://bit.ly/Canon5DMarkIIICamera Canon 16-35mm F/2.8L lens http://bit.ly/Canon16-35mm Canon 70-200mm F/4L lens http://bit.ly/Canon70-200mmLens Glidecam HD-2000 http://bit.ly/GlideCam2000 For business inquiries and licensing email info@stokedforsaturday.com | ["Music", "Environmental noise", "Outside, rural or natural"] | ["naturesounds/kalimba", "birds", "wind", "water", "reverbed kalimba", "relaxing atmosphere"] | 6 | JC41M7RPSec | 1976 |
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;