musiccaps_details (view)
1 row where musiccaps_aspects contains "piano" and "youtube_published" is on date 2008-08-31
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 |
---|---|---|---|---|---|---|---|---|---|---|
Whale song serenade (soothing relaxing original music) | This song contains whales singing and then a piano starts playing a composition along. This may be playing in a documentary. | 2008-08-31T22:35:31Z | Floresound | The Whales are known to repeatedly produce sounds at variable frequencies. So that, this modulation of sounds is well known as the whale song. As a musician, I can say that these sounds seem to follow our musical scale very accurately. Using sounds of blue whale, captured by advanced hydrophone, and wonderful underwater images filmed in Moorea island (French Polynesia), I had the opportunity to compose another original song around the amazing world of whales. So, give power to your speakers and relax yourself. Credits: A special thanks to Gael Laporte, which I met in Moorea two years ago, for giving me the opportunity to use his spectacular footage. I want to thanks the NOAA Acoustic Monitoring Program (www.pmel.noaa.gov ) for monitoring ocean noise and consequently giving people the possibility to listen to it. The music "Whale song serenade" has been composed and played by me. (c) Floresound 2008. | ["Whale vocalization", "Music"] | ["whale sounds", "piano", "atmospheric"] | 6 | p_o6NQX7lmE | 4724 |
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;