musiccaps_details (view)
2 rows where musiccaps_aspects contains "interactive" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- fast tempo 2
- interactive · 2 ✖
- active learning 1
- alternative hip-hop 1
- buoyant 1
- catchy 1
- cheerful acoustic guitar 1
- children’s songs 1
- chirpy 1
- clapping 1
- club music 1
- dance groove 1
- dance music 1
- dance pop 1
- dj 1
- dj mixer 1
- education songs 1
- energetic coordination 1
- engaging 1
- female vocalist 1
- funky 1
- groovy 1
- happy 1
- hip-hop 1
- hip-hop hits 1
- infectious drumming 1
- keyboard harmony 1
- kindergarten songs 1
- learning is fun 1
- lively backup vocals 1
- lively mandolin 1
- male singer 1
- minimal instrumentation 1
- minimalist instrumentation 1
- nursery rhymes 1
- peppy 1
- perky 1
- popular kids songs 1
- punchy 1
- rap 1
- reggae fusion 1
- simple lyrics 1
- simple tune 1
- upbeat 1
- vocalisation 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
K'Naan ABC's | Male vocalist sings this upbeat Hip-Hop song. The tempo is fast with minimal instrumentation of a lively infectious, punchy drumming and enthusiastic vocal backup and incessant, vigorous vocalisation. The song is buoyant, catchy, punchy, funky, youthful,groovy, engaging, vibrant and vivacious. This song is contemporary Hip-Hop/Rap. | 2009-01-23T20:28:16Z | K'naan Warsame | The new video for "ABC's" from K'NAAN's upcoming release "Troubador"; featuring Chubb Rock | ["Afrobeat", "Music of Africa", "Music", "Exciting music"] | ["male singer", "lively backup vocals", "alternative hip-hop", "reggae fusion", "interactive", "vocalisation", "fast tempo", "infectious drumming", "keyboard harmony", "hip-hop", "rap", "hip-hop hits", "minimalist instrumentation", "upbeat", "catchy", "buoyant", "punchy", "peppy", "perky", "dj", "dj mixer", "dance pop", "dance music", "dance groove", "club music", "groovy", "funky"] | 7 | Ovk5EfFj7Ws | 2482 |
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;