musiccaps_details (view)
1 row where musiccaps_aspects contains "female singer", musiccaps_aspects contains "song fade" and musiccaps_author = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|
Pancaked Bun of Braids | Cute Girls Hairstyles | A female singer sings this song. This section is probably a song fade as only the last bit of the word a can be heard with a mellow ukelele riff. This is followed with some sounds of something hitting a hard surface and then silence. | 2014-07-21T00:12:21Z | Mindy McKnight | If any of you would like to follow this daughter, Kamri, on Instagram {a parent-run account} you can do so at http://www.instagram.com/kamrinoel! * ~ * ~ * ~ * ~ * ~ * You've all loved our Rope Twisted Bun from a few months back {http://youtu.be/jeMFXP6BCiQ}, so we thought it would be fun to show you another of our adorable bun hairstyles! This one is called a Pancaked Bun of Braids! This updo uses a bun maker over a ponytail, and is exactly what the name states... a bun full of pancaked braids! There is a trick to getting this bun just right, and in the video I show you several tips on how to do this. To see your recreation featured below this video in our CGH App, feel free to tag your own photos of this hairstyle on Instagram with: #CGHBunOfBraids Enjoy! 😘 - Mindy Items Needed: Brush, rat-tail comb, spray bottle, bun maker, 1 small hair elastic, 6-8 hair pins, hairspray and accessory {if desired}. Time Requirement: 10-12 minutes Skill Level: Medium To see step-by-step instructions and more photos of this style, please visit... http://www.cutegirlshairstyles.com * ~ * ~ * ~ * ~ * We post a new hairstyle tutorial every Sunday night {7pm CST}! So, please don't forget to subscribe to our YouTube channel... http://bit.ly/VovoC9 Follow CGH on Facebook: http://www.facebook.com/CuteGirlsHairstyles Follow CGH on Twitter: http://www.twitter.com/CuteGirlHair Follow CGH on Pinterest, and see my "Try" board... http://www.pinterest.com/CGHairstyles Follow CGH on Instagram and see unpublished photos of our family: http://www.instagram.com/MindyMcKnight * ~ * ~ * ~ * ~ * Music: "I Adore" by Mindy Gledhill {http://youtube.com/MindyGledhill} iTunes Link: https://itunes.apple.com/us/album/anchor/id384576597?uo=4&at=1l3v7Rs License: Personal emailed permission from Mindy, herself, and her management. | ["Music", "Ukulele"] | ["female singer", "ukele melody", "silence", "no percussion", "song fade", "dissonant sound", "something hard hitting a surface"] | 7 | TyMZJqYmrwE | 2878 |
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;