musiccaps_details (view)
2 rows where musiccaps_aspects contains "slow tempo", musiccaps_author = 6 and musiccaps_names contains "Outside, rural or natural"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Fast and Light - Salomon Running TV S04 E08 | A synth pad is playing an evolving drone chord along with some glittering sounds. In the background of the recording you can hear wind, running and birds chirping. The whole scenario sounds calming and meditative. This song may be playing for a documentary. | 2015-10-20T13:56:09Z | SalomonTrailRunning | “Fast and Light” explores a tribe of runners who are motivated by pushing their limits in some of the world’s most extreme mountain environments. Told through the eyes of pioneers and heroes including Kilian Jornet, Marino Giacometti, Bruno Brunod and Fabio Meraldi – the film unpacks the sport of Skyrunning, a practice that started with a few individuals following their passion and has evolved over 2 decades to a worldwide discipline reaching thousands of people across the globe. A PRODUCTION BY THE AFRICAN ATTACHMENT SONGS: "Fever Dream" by Wild Eastern Arches "Footpaths Home" by Miles Sievwright "Your hand, my hand and the stars" by Will Bangs Additional Score by Signpost Sound ADDITIONAL FOOTAGE COURTESY: Transworld Sport International Skyrunning Federation Trans Gran Canaria: Mouss Productions UTMF: Mouss Productions Transvulcania : Kikazaru Producciones Zegama: Kikazaru Producciones Marathon du Mont Blanc/ Sky Running World Championships: Mouss Productions Ice Trail : Club des Sports de Val d’Isère and Mouss Productions The Rut : Sprout Films Limone Extreme : Simone Chiesa Trofeo Kima: Jordi Sargossa, Ian Corless and R Moiola Archive Photos: Lauri Van Houten | ["Music", "Run", "Outside, rural or natural"] | ["meditative", "evolving synth pads", "running sound", "birds chirping", "wind blowing", "slow tempo"] | 6 | YMq4wE6KxmQ | 3278 |
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;