musiccaps_details (view)
2 rows where musiccaps_aspects contains "bells" and musiccaps_aspects contains "no percussion" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- bells · 2 ✖
- no percussion · 2 ✖
- no voices 2
- ambient song 1
- chiming sounds 1
- flute 1
- instrumental 1
- instrumental music 1
- meditative music 1
- pads 1
- spooky feel 1
- synth sounds 1
- theremin song 1
- vibrato 1
musiccaps_names (array) 4 ✖
- Music 2
- Ambient music 1
- New-age music 1
- Theremin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Ghost Sonata" Original Theremin Composition Scott Marshall | This instrumental song features a melody played using bells. There are chiming sounds played in the background like clockwork. A theremin plays a vibrato note. There is no percussion in this song. This song has a spooky theme and can be used in a children's scary movie. There is a lot of white noise that can be heard in this low quality recording. There are no voices in this song. | 2007-08-22T03:25:59Z | MisterScott99 | Original theremin composition Copyright 2003 by Scott Marshall, All Rights Reserved. Downloadable recording of this song can be accessed here: http://thereminvox.com/filemanager/list/6/index.html | ["Music", "Theremin"] | ["theremin song", "instrumental", "bells", "chiming sounds", "vibrato", "no voices", "no percussion", "spooky feel"] | 0 | B3lq6U4PDZo | 1200 | |
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;