musiccaps_details (view)
2 rows where musiccaps_aspects contains "ambient song" and musiccaps_aspects contains "flute" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- ambient song · 2 ✖
- flute · 2 ✖
- meditative music 2
- no voices 2
- bass drum 1
- bells 1
- birds chirping 1
- instrumental 1
- instrumental music 1
- no percussion 1
- pads 1
- slow tempo 1
- sounds of nature 1
- synth layers 1
- synth sounds 1
- tambourine 1
- yoga music 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Buddha Bar - Meditative Music - (albanian culture )by eugene | This ambient song features a main melody played on a flute. It is accompanied by percussion playing beats on the bass drum only. A tambourine is played on one count in every bar. There are the sounds of chirping birds in the background. This song also has layers of synth playing tribal-style instruments. The mood is meditative. This song can be used in meditation or in a yoga session. | 2008-05-03T20:03:06Z | Juxhin Korbeci | Buddha Bar - Meditative Music - Mother Earth's Tartaruga Song - Dream-Oliver Shanti albanian beauty and culture | ["Traditional music", "Music", "Soundtrack music"] | ["ambient song", "flute", "synth layers", "birds chirping", "tambourine", "sounds of nature", "bass drum", "slow tempo", "instrumental", "no voices", "meditative music", "yoga music"] | 0 | 5blPLHS0Cko | 674 | |
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;