musiccaps_details (view)
1 row where musiccaps_aspects contains "no voices", musiccaps_aspects contains "truck sounds" and "youtube_published" is on date 2015-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 |
---|---|---|---|---|---|---|---|---|---|---|
Leo the truck - The car transporter. Kids' cartoons. | This children's song features truck sounds. This is accompanied by a keyboard playing a melody using a flute-like sound. A twinkling melody is played in the background. The percussion is programmed. The percussion plays a simple beat. The bass plays the root and fifth notes of the chords. The mood of the song is happy. There are no voices in this song. This song can be used in a children's animated movie. | 2015-05-29T06:54:51Z | KidsFirstTV | What car can transport cars for kids? A car transporter! Build new kids' vehicles with Leo the Truck and play with trucks for kids on our KidsFirstTV channel for children! Play fun kids' games and watch kids' cartoons & animations for kids with cars and trucks! Build a new car every episode! Leo the Truck English learning video. Join Leo’s games! Appstore or Google Play: https://l.projectfirst.tv/Games Buy Watch the best cartoons & videos in our app https://l.projectfirst.tv/KKapp Buy Leo the truck & toys http://l.projectfirst.tv/LeoToysUS Sing with Leo! https://distrokid.com/hyperfollow/leothetruck/leos-favourite-nursery-rhymes-2 Funny kids' songs with Leo https://distrokid.com/hyperfollow/leothetruck/sing-with-leo Build cars 🚗 and trucks 🚚 with Leo the Truck https://www.youtube.com/watch?v=EvPF5upenRQ&list=PLdqtsRz9B9qd19PGLcFQjHkXdQAw6U2kr ⚙️ Repair cars with doctor McWheelie 🔧 https://www.youtube.com/watch?v=P987mDsp0xI&list=PLdqtsRz9B9qdmX0udNwnsRIZYA04ZOaIB Play & learn 🚒 vehicles 🏎️ with Excavator Max https://www.youtube.com/watch?v=vHKVE6hV2nI&list=PLdqtsRz9B9qfwOBUqFQZNzSsU3HJk_e7w Find us in VK https://vk.com/kidsfirsttv Facebook https://www.facebook.com/KidsFirstTV Subscribe KidsFirstTV channel here https://www.youtube.com/user/KidsFirstTV?sub_confirmation=1 | ["Music", "Tire squeal"] | ["children's music", "twinkling sounds", "truck sounds", "keyboard song", "no voices", "programmed percussion", "moderate tempo", "happy feel"] | 0 | tWseBEYhE1M | 5047 |
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;