musiccaps_details (view)
2 rows where musiccaps_aspects contains "bright piano", musiccaps_author = 5 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- bright piano · 2 ✖
- positive 2
- appealing female vocals 1
- atmosphere 1
- cinematic 1
- earthquake effects 1
- easygoing 1
- fun 1
- jazzy drums 1
- kids music 1
- mid-tempo 1
- special effects 1
- subtle trumpets 1
- waves 1
musiccaps_names (array) 3 ✖
- Music · 2 ✖
- Eruption 1
- Happy music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dumb (Minecraft) ways to Die | The track is a Kids Music song. A female voice with appealing vocals sings an easygoing melody. A piano with a bright sound plays a jazzy melody. A jazz drum kit plays a smooth beat. In the background there are trumpets playing a melody that matches the positive and fun atmosphere of the track. | 2012-12-09T11:55:51Z | Christopher Gutteridge | There are lots of dumb ways to die in Minecraft. This video was created 100% in survival mode, anything less would be cheating. That said, since then there have been some amazingly talented videos made which put this one to shame. | ["Music", "Happy music"] | ["kids music", "positive", "fun", "bright piano", "subtle trumpets", "appealing female vocals", "easygoing", "mid-tempo", "jazzy drums"] | 5 | 4PNPgaLKFlc | 565 | |
SimCity 2013 All Disasters | The track features a cinematic ambience with different sound effects like waves or earthquake sounds. In the foreground there's a bright piano playing a melody with a positive vibe. The track sounds like an extract from a video game, | 2014-03-24T15:36:12Z | GaminGHD | SimCity 2013 Disasters - Earthquake,Tornado,Meteor Strike,UFO Encounter,Zombie Attack,Big Lizard. If you like this Video don't Hesitate to Press the Like Button and Share with your Friends ! Oh, and if you want more videos HIT the Red Subscribe Button Use this code GREENM-ANGAME-R20OFF Here : http://bit.ly/1OTOgEP for 20% Discount ! Use this link to buy Games http://bit.ly/21XSkRh (G2A) Thanks ! Use this link to buy Games http://bit.ly/1QK8xyP (Kinguin) Thanks ! --------------------------------------------------------------------------------------- ★ Join GaminGHD http://www.gaminghd.ro ★ ★ Forum http://www.gaminghd.ro/forum ★ --------------------------------------------------------------------------------------- If you like our work and want to support us, you can make a Donation. https://www.tipeeestream.com/free%20enigma/donation --------------------------------------------------------------------------------------- ♥♥♥♥♥♥♥♥Fii sociabil!♥♥♥♥♥♥♥♥ ▶Facebook http://facebook.com/gaminghd.ro ▶Youtube http://youtube.com/HDGamingHD ▶Steam http://steamcommunity.com/groups/GaminGHDro ▶Twitter: http://twitter.com/GamingHDinfo ▶Google+ : http://Google.com/+GaminghdRo --------------------------------------------------------------------------------------- Contact: http://www.gaminghd.ro/contact --------------------------------------------------------------------------------------- Toate drepturile rezervate. Copyright © GaminGHD.ro | ["Music", "Eruption"] | ["cinematic", "bright piano", "atmosphere", "special effects", "earthquake effects", "waves", "positive"] | 5 | nvuxMnSHHtg | 4594 |
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;