musiccaps_details (view)
1 row where musiccaps_aspects contains "synth sound effects" and musiccaps_names contains "Music for children"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Learn to Count Numbers with the Counting Song by Cubic Frog® Apps! | The low quality recording features a synth melody and a lot of synth sound effects, over which there is a funny boy vocal talking. The synth melody continues to play in the second part of the loop where shimmering bells, snaps layered with snappy rimshots and harmonizing kids' vocals singing over them, appear. It sounds happy, joyful and fun - like something kids would listen to. | 2016-03-08T08:06:37Z | Cubic Frog® Apps | Toddlers learn to count numbers with this fun kid’s sing along! The Number Song teaches children to count to 10 plus builds basic vocabulary. Simple lyrics make learning numbers for toddlers easy plus the colorful, silly graphics make education fun! Learn the numbers 1-10, counting, phonics, and vocabulary with Cubic Frog® Number Song for toddlers, preschoolers, and kids of all ages! Parents, get your toddler kindergarten ready by learning numbers. Teachers, use this sing along in the classroom to teach numbers 1-10. You can find Cubic Frog® mobile learning games here: Google Play: https://play.google.com/store/apps/de... iTunes: http://itunes.com/apps/cubicfrogapps Cubic Frog® is a team of childhood learning experts who have created the Number Song sing along to teach counting numbers 1-10 in an easy and exciting way for kids. Teaching numbers is as easy as 123 with the Number Song for toddlers, preschoolers, and kids of all ages! Learn the abc's, phonics, and vocabulary with Cubic Frog® Alphabet Song for toddlers, preschoolers, and kids of all ages. Click below and subscribe! https://www.youtube.com/user/cubicfrog Lyrics: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 Count, everybody count Count, count your numbers 1 through 10 1 Little umbrella 2 Little robot fellas 3 Green frogs and 4 red cars I see 5 blue stars 6 Green elephants walking 7 Little monkeys talking 8 Donkeys are honking 9 Little pigs plus 1 makes 10 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 Count, everybody count Count, count your numbers 1 through 10 1 Little umbrella 2 Little robot fellas 3 Green frogs and 4 red cars I see 5 blue stars 6 Green elephants walking 7 Little monkeys talking 8 Donkeys are honking 9 Little pigs plus 1 makes 10 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 Count, let’s count Let’s count backwards Let’s count backwards 10 to 1 10, 9, 8, 7, 6, 5, 4, 3, 2, 1 10, 9, 8, 7, 6, 5, 4, 3, 2, 1 Count, let’s count Let’s count backwards Let’s count backwards one more time 10, 9, 8, 7, 6, 5, 4, 3, 2, 1 10, 9, 8, 7, 6, 5, 4, 3, 2, 1 Count, everybody count Count, come o… | ["Music", "Music for children", "Ding", "Speech", "Boing"] | ["low quality", "synth melody", "synth sound effects", "funny boy vocal", "harmonizing kids vocals", "shimmering bells", "snaps", "snappy rimshots", "fun", "happy", "joyful"] | 4 | YtYjdkTK5oY | 3319 |
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;