musiccaps_details (view)

1 row where musiccaps_aspects contains "snappy rimshots", musiccaps_names contains "Boing" and musiccaps_names contains "Music"

✎ View and edit SQL

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

CSV options: 

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;