musiccaps_details (view)
1 row where musiccaps_aspects contains "helicopter starting engine" and musiccaps_names contains "Helicopter"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Learning Vehicles Names and Sounds for Kids Part 2 | Trucks, Helicopter and More | A helicopter engine is starting with a song playing in the background. The song contains acoustic guitars, a keyboard melody and a drumset. This song may be playing in an advertisement. | 2015-10-15T16:37:07Z | Brain Candy TV | Download our videos for ad-free, offline viewing at: http://www.braincandytv.ca/shop/ Learn about the names and sounds of various vehicles for children using fun toy versions of each vehicle, including monster and transport trucks, construction vehicles, a helicopter and more in this fun 3D cartoon for kids. Stay tuned for the fun stunt with the monster truck at the end. Featuring the following vehicles: a red monster truck, an animated flying helicopter, a city bus, a big transport truck, and a sturdy bulldozer. We'll also learn a little bit about the utility of each vehicle and how they work. Stay tuned for more exciting content coming soon including some nursery rhymes, math lessons and more fun vehicle videos! Brain Candy TV is dedicated to producing fun and engaging educational videos that your kids will love. You can view our channel here: https://www.youtube.com/user/braincandytelevision or subscribe using the following link: http://www.youtube.com/subscription_center?add_user=braincandytelevision You can also follow us on: Facebook: https://www.facebook.com/braincandytv Twitter: https://twitter.com/braincandytv This video is transcribed for the hearing impaired and for translation into any language - perfect for learning English and for ESL students. Rendered with help from http://GarageFarm.NET render farm | ["Music", "Helicopter"] | ["backgroundmusic", "helicopter starting engine", "happy vibes"] | 6 | Y-qOOR0izlE | 3247 |
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;