musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental music" and "youtube_published" is on date 2014-10-25
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- instrumental music · 2 ✖
- ambient song 1
- animated show 1
- bells 1
- building suspense 1
- cartoon show soundtrack 1
- drumming rolls 1
- flute 1
- horns playing to a crescendo 1
- low bass thumps 1
- meditative music 1
- medium tempo 1
- mystery 1
- no percussion 1
- no voices 1
- pads 1
- poor audio quality 1
- story telling 1
- string section harmony 1
- suspense 1
- synth sounds 1
- tense harmony 1
musiccaps_names (array) 4 ✖
- Music 2
- Ambient music 1
- New-age music 1
- Scary music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
[Growtopia] Why Noobs Can't Spell | The song is an instrumental. The song is medium tempo, with a horn and string section and a drum section playing to a crescendo, followed by a low frequency thumping rhythm. The song is an instrumental soundtrack for an animated show. The audio quality is poor. | 2014-10-25T21:20:40Z | CookieRickey | 100% Illuminati. Where is the world going into? ------------------------------------------------------------------------------------------------------------------------------------- CocoaCookieP Channel►https://www.youtube.com/user/CocoaCookieP Fesliyan Studios►https://www.youtube.com/watch?v=NWaNW-aYhVY Wanna Play Growtopia? Links Below... PC►http://growtopiagame.com/GrowtopiaIns... Mac►http://growtopia.org/Growtopia.dmg iOS►http://bit.ly/1fP8dvP Android►http://bit.ly/1ciiWhv | ["Music", "Scary music"] | ["building suspense", "cartoon show soundtrack", "story telling", "tense harmony", "drumming rolls", "poor audio quality", "instrumental music", "medium tempo", "suspense", "mystery", "string section harmony", "animated show", "horns playing to a crescendo", "poor audio quality", "low bass thumps"] | 1 | -FlvaZQOr2I | 32 | |
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;