musiccaps_details (view)
2 rows where musiccaps_aspects contains "chirpy" and musiccaps_aspects contains "clapping"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- chirpy · 2 ✖
- clapping · 2 ✖
- fast tempo 2
- active learning 1
- ambient street sounds 1
- animated 1
- animated singing 1
- bouncy 1
- busker 1
- busking 1
- catchy riff 1
- catchy vocal riff 1
- cheerful acoustic guitar 1
- cheering 1
- children’s songs 1
- concert 1
- education songs 1
- energetic coordination 1
- engaging 1
- enthusiastic paino 1
- female vocalist 1
- gig 1
- happy 1
- inferior audio quality 1
- interactive 1
- kindergarten songs 1
- learning is fun 1
- live performance 1
- lively mandolin 1
- male vocalist 1
- minimal instrumentation 1
- mufffled audio 1
- nursery rhymes 1
- people talking 1
- piano harmony 1
- popular kids songs 1
- simple lyrics 1
- simple tune 1
- street performance 1
- vehicle sounds 1
- vivacious 1
- vivid 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bicycle Piano -Mickey Mouse March | A male vocalist sings this energetic song. The tempo is fast with a spirited piano accompaniment and ambient street noises like vehicles, people talking and breeze. There is a sound of clapping and cheering indicating that this is a live street performance. The audio quality is inferior causing static and muffled sounds.This song is a cheerful, animated, spirited, happy, chirpy and bouncy pop. | 2007-10-08T15:21:12Z | M K | Who the leader of the club that made for you and me! | ["Applause", "Music"] | ["male vocalist", "fast tempo", "piano harmony", "bouncy", "chirpy", "animated", "vivid", "vivacious", "ambient street sounds", "inferior audio quality", "mufffled audio", "catchy riff", "animated singing", "enthusiastic paino", "catchy vocal riff", "clapping", "people talking", "cheering", "vehicle sounds", "live performance", "gig", "concert", "street performance", "busking", "busker"] | 7 | 6ragcEJVErI | 792 | |
If You're Happy and You Know It! | Barefoot Books Singalong | A female vocalist sings this lively Children’s Song. The tempo is fast with a cheerful acoustic guitar and ukulele accompaniment along with clapping. The song is lively, upbeat, engaging, energetic, simple and enthusiastic. The song is a children’s nursery rhyme with the catchy , simple tune and lyrics meant to make learning fun. It is engaging, interactive, instructional, educational teaching coordination. | 2010-05-13T19:52:28Z | Barefoot Books | If You're Happy and You Know It! | Barefoot Books Singalong Want more? (Click SHOW MORE below 👇) ⭐ Our favorite video: https://www.youtube.com/watch?v=C6ljGXMMB-g 🛒 Buy this book: https://www.barefootbooks.com/if-youre-happy-and-you-know-it 👣 Find out more: https://www.barefootbooks.com Stay in Touch! 🔔 Don't forget to subscribe! 👍🏽 Join our community: https://www.facebook.com/barefootbooks 🎁 FREE AT-HOME RESOURCES for KIDS🎁 https://bit.ly/358Fog6 ▶️ Check out this playlist! https://www.youtube.com/watch?v=ynlmvWAdCug&list=PL0maGUp7cdUn5uuLnjsk1NvV2u5Yg5LAV Clap your hands and sing along to this fresh take on a traditional singalong. The multicultural version of this early learner encourages action and imagination. 🎥 Recommended Videos to Watch: The Wheels on the Bus Singalong https://www.youtube.com/watch?v=9siyDPch-6c Knick Knack Paddy Whack Singalong https://www.youtube.com/watch?v=9--t3zl4NkY Over in the Meadow Singalong https://www.youtube.com/watch?v=C6ljGXMMB-g 👇 DOWNLOAD our WORLD ATLAS APP for KIDS 👇 https://apps.apple.com/us/app/barefoot-world-atlas/id489221652 ★☆★ CONNECT WITH US ON SOCIAL MEDIA ★☆★ FACEBOOK: https://www.facebook.com/barefootbooks/ INSTAGRAM: https://www.instagram.com/barefootbooks TWITTER: https://twitter.com/BarefootBooks #nurseryrhymes #kidssongs #singalong | ["Singing", "Music", "Clapping"] | ["female vocalist", "fast tempo", "cheerful acoustic guitar", "simple lyrics", "simple tune", "interactive", "learning is fun", "energetic coordination", "clapping", "lively mandolin", "minimal instrumentation", "children’s songs", "nursery rhymes", "popular kids songs", "education songs", "kindergarten songs", "happy", "chirpy", "engaging", "interactive", "active learning"] | 7 | 71hqRT9U0wg | 804 |
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;