musiccaps_details (view)
1 row where musiccaps_aspects contains "brass instruments", musiccaps_aspects contains "clapping rhythm", musiccaps_aspects contains "new orleans" and musiccaps_aspects contains "retro jazz hits"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Dapper Day Meet & Greet with Charisma Star! | Charisma Star | A woman talks before the beginning of the music track. The song is instrumental with a trumpet playing a swing melody accompanied by a brass band and jazz orchestra. The tempo is medium with a walking bass line, piano accompaniment, steady rhythm and clapping percussion. The song is a classic swing jazz tune. | 2013-09-11T07:16:05Z | Charisma Star | SUBSCRIBE to my channel for the latest videos ⇒ http://bit.ly/1nSa52f. Hey my beautiful shining stars! Last week, Jacob and I attended our second Dapper Day at Disneyland! Dapper Day is a bi-annual event put on by fans where everyone dresses "to the 9's", whether vintage or contemporary chic, it's a fun way to enjoy our favorite place! I had a meet and greet in the evening so thank you to everyone who came out! It was fun to introduce a few of my friends to you! Hope you guys enjoyed this quick look at our festivities! Love you! Want to know me more? Come hang out with me: FACEBOOK: http://www.facebook.com/CharismaStarTV TWITTER: http://www.twitter.com/CharismaStarTV Charis' INSTAGRAM: "CharismaStar" Jacob's INSTAGRAM: "jacobelijahlincoln" KEEK: "CharismaStarTv" Some of my friends who were featured in this video: Special thanks to my friend Cassie Wanda for my beautiful Snow White dress! www.glimmerwood.com Andrew and Hali Ducote youtube.com/TheGrandSupreme Jenny Rae youtube.com/JennyRaeTV Jasmine Ladjevardi Instagram: jasmineladjevardi Lili Belle youtube.com/BelleCandyTV Music by Louis Armstrong "Heigh-Ho (The Dwarf's Marching Song)" "Whistle While You Work" Royalty Free Music by http://www.audiomicro.com/royalty-free-music Sound Effects by http://www.audiomicro.com/sound-effects Camera: Canon 5D Mark II Editor: Final Cut Pro. About Charisma Star Welcome to Charisma Star TV! Surrounded by beautiful colors and showers of glitter! Come see where true beauty lies... God has made you beautiful; time to open your eyes and see! Here you will find fun, inspiring, and quality makeup tutorials created here at my home in North Pole, Alaska, JUST FOR YOU! I also do product reviews, hauls, inspirational stories, and much more. COMING SOON: Nail tutorials, Outfit-of-the-Day, Beauty/Self-image, and collaborations with some of my beautiful friends! Thank you so much for supporting Charisma Star TV! - Charis Lincoln | ["Brass instrument", "Saxophone"] | ["woman talks", "trumpet melody", "jazz music", "walking bass line", "new orleans", "video soundtrack", "big band orchestra", "brass instruments", "piano accompaniment", "trombones", "jazz music", "vintage jazz", "retro jazz hits", "swing music", "steady drumming rhythm", "clapping rhythm", "jazz classics", "swing era", "instrumental music"] | 1 | 8zcogfmAD_o | 967 |
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;