musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_names contains "Music" and "youtube_published" is on date 2016-08-17
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
100 Kickflips (360 Flip Edition) In The Vans X Nintendo Authentic Shoes | This song is a Jazz instrumental . The tempo is slow with a lively saxophone harmony, groovy bass line, syncopated piano and slick drumming along with the sound of breeze, some clicking and super mario theme. The song in the background is classic Jazz. | 2016-08-17T00:58:27Z | CCS | Mario holds a special place in our hearts. So does Cameron Harper. We decided to strap up Cameron, Team Rider Preston Harper's older brother, in some Vans X Nintendo Authentics to see how these shoes from another world would hold up to 100 360 Flips. Well, they survived, but not without an epic battle between flips and evil. Watch as Cameron 360 Flips into another world in this installment of The 100 Kickflip Challenge. The Consouls: https://www.youtube.com/c/theconsoulsband SUBSCRIBE to CCS YouTube: http://tinyurl.com/lmje4o6 Like CCS on FACEBOOK: https://www.facebook.com/ccs.skate Follow CCS on INSTAGRAM: https://instagram.com/ccs_skate/ Follow CCS on TWITTER: http://twitter.com/CCS_skate Check the WEBSITE: http://ccs.com/ Don't Forget SNAPCHAT : CCSskate | ["Music", "Skateboard"] | ["jazz music", "instrumental", "enthusiastic saxophone", "super mario theme", "jazz", "blues", "wind instrument", "ambient", "syncopated piano", "improvisations", "super mario tune", "sound of wave board", "breeze", "background chatter", "groovy bass guitar", "slick drumming"] | 7 | 9QwaP-cvdeU | 1007 | |
FINGERS Mitchell Cullen OZORA Festival Hungary 2016 Freedom Rides | This song features a song being played on a didgeridoo. This features a droning sound. A shaker is played through the song and is doubled in tempo at the end of the song. An acoustic guitar strums chords. This song can be played at a club. | 2016-08-17T06:39:12Z | FINGERS Mitchell Cullen | Thanks for watching my vid. My latest album Through the Storm has just been released (September 2020)! You can buy it (digital download or CD) from my website: https://fingersmitchellcullen.com.au/shop/ OZORA Europe’s Second Biggest Psychedelic Trance Festival Hungary August 2016 Freedom Rides opening song at the DRAGON NEST .............. | ["Didgeridoo", "Guitar", "Music", "Musical instrument"] | ["didgeridoo song", "shaker", "moderate tempo", "acoustic guitar", "dance style music", "no voices", "instrumental"] | 0 | Dx58W7opw5A | 1521 |
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;