musiccaps_details (view)
2 rows where musiccaps_aspects contains "birds" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- birds · 2 ✖
- environmental noises 1
- naturesounds/kalimba 1
- ocean waves 1
- relaxing atmosphere 1
- reverbed kalimba 1
- slow tempo 1
- synth pad 1
- train passing 1
- water 1
- wind 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DJ Tatana - Spring breeze | This audio contains environmental noises as ocean waves sounds; seabirds singing; a train passing by and a synth pad playing a short rising sound. This song may be playing in an advertisement. | 2010-10-15T04:48:33Z | Timelesswarp | "Daffodils" (1804) I WANDER'D lonely as a cloud That floats on high o'er vales and hills, When all at once I saw a crowd, A host, of golden daffodils; Beside the lake, beneath the trees, Fluttering and dancing in the breeze. Continuous as the stars that shine And twinkle on the Milky Way, They stretch'd in never-ending line Along the margin of a bay: Ten thousand saw I at a glance, Tossing their heads in sprightly dance. The waves beside them danced; but they Out-did the sparkling waves in glee: A poet could not but be gay, In such a jocund company: I gazed -- and gazed -- but little thought What wealth the show to me had brought: For oft, when on my couch I lie In vacant or in pensive mood, They flash upon that inward eye Which is the bliss of solitude; And then my heart with pleasure fills, And dances with the daffodils. By William Wordsworth (1770-1850). | ["Music", "Caw", "Outside, rural or natural"] | ["environmental noises", "ocean waves", "birds", "train passing", "synth pad", "slow tempo"] | 6 | J1-Qvl7u2TI | 1961 | |
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;