musiccaps_details (view)
1 row where musiccaps_aspects contains "sounds of scribbling", musiccaps_author = 0 and "youtube_published" is on date 2012-05-29
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Coleman Chronicles- Ronnie Coleman: The Journey Of A Legend | Ronnie Coleman | This clip starts with the sound of scribbling on a piece of paper. This is followed by an epic orchestral song. This has a string section playing notes on a high register. The bass plays the root notes of the chords. The bass drum plays strokes. Male voices sing in baritone like a choir. | 2012-05-29T15:52:18Z | Ronnie Coleman | Hey Guys, be sure to check out my ronniecolemanstore.net site to get access to my entire line of supplements and apparel...Yeah Buddy Light Weight Baby Subscribe for more videos like this: http://bit.ly/RonnieColemanSubscribe Check out my TopVideos!: http://bit.ly/RonnieColemanTopVideos Check Out my Supps - https://www.ronniecoleman.net Follow me: http://facebook.com/RCSups http://twitter.com/BigRonColeman http://instagram.com/ronniecoleman8 Get all of my products here - https://goo.gl/rMxs3T #ColemanChronicles #Ronnie Coleman About Ronnie Coleman: Get a glimpse into the Life of Ronnie Coleman's Past, Present & Future on his Official YouTube Channel!! Subscribe for more insight on what it takes to be the best and what motivates Ronnie Coleman to keep on going. Don’t forget to listen to Ronnie Coleman’s opinions and story on the bodybuilding world and more on the “Nothin But A Podcast” podcast. Ronnie Coleman is a retired International Federation of BodyBuilding & Fitness (IFBB) Professional Body Builder and is a 8x Mr. Olympia title holder. He owns and operate his own Company, Ronnie Coleman Signature Series™. The Coleman Chronicles- Ronnie Coleman: The Journey Of A Legend | Ronnie Coleman https://www.youtube.com/watch?v=fAHYe-qmFnU Ronnie Coleman http://www.youtube.com/RCSSTV | ["Music", "Scary music"] | ["orchestral music", "sounds of scribbling", "victorious music", "bass drum"] | 0 | fAHYe-qmFnU | 3927 |
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;