musiccaps_details (view)
1 row where musiccaps_aspects contains "no voices", musiccaps_names contains "New-age music" and "youtube_published" is on date 2014-10-25
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Fungal Planet Ambient Late (Track 18) - Sid Meier's Civilization: Beyond Earth | This ambient song features synth pads playing in the background. Synth sounds are layered to give a wave-like feel. There is no percussion in this song. Bells are played at intervals. Toward the end, a mid-range flute sound is played. The sound of rattles are played in the background. This song has an ethereal feel. This song is meditative and can be used in a meditation or yoga session. | 2014-10-25T13:23:32Z | Sora | The eighteenth track for the Official Civilization: Beyond Earth Soundtrack! All tracks from Civilization: Beyond Earth were composed and designed by: Geoff Knorr, Griffin Cohen, Michael Curran and Grant Kirkhope. Please support the game's official release, where you can also get this Soundtrack for free included with the game. If you are unable to purchase the game, you can also purchase the entire soundtrack on iTunes! If you liked this track, you can check out the entire soundtrack playlist here: https://www.youtube.com/playlist?list=PLPsUoyxhXuMn0nUN5NDVJ8e42hX1heCDs | ["New-age music", "Music", "Ambient music"] | ["ambient song", "meditative music", "flute", "no percussion", "instrumental music", "synth sounds", "no voices", "bells", "pads"] | 0 | uUNlJ4KZTPE | 5118 |
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;