musiccaps_details (view)
2 rows where musiccaps_aspects contains "bells" and musiccaps_aspects contains "flute" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- bells · 2 ✖
- flute · 2 ✖
- amateur recording 1
- ambient song 1
- chimes 1
- indian/traditional 1
- instrumental music 1
- meditative music 1
- medium tempo 1
- no percussion 1
- no voices 1
- pads 1
- synth sounds 1
- tabla 1
- tambourine 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 |
---|---|---|---|---|---|---|---|---|---|---|
Vathapi Fusion | A flute is playing a loud melody in the higher register while someone is playing a rhythm on a tabla. Percussive tambourinelike instruments serve as percussive addition along with some single bell or chime hits. This is an amateur recording and it sounds like it was recorded in a big room due to a lot of reverb. This song may be played at a live concert with people sitting in chairs being comfortable. | 2010-07-20T06:55:36Z | Sai Narasimhan | Sai Narasimhan playing Vathapi Ganapathim on Flute with Keyboard, Tabla, Drums & Rythym Pad for a Wedding Reception Concert - Fusion | ["Carnatic music", "Music"] | ["indian/traditional", "flute", "tambourine", "bells", "chimes", "tabla", "amateur recording", "medium tempo"] | 6 | z_aUtjxgCNk | 5493 | |
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;