musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "happy" and musiccaps_names contains "Clapping" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- clapping 2
- fast tempo 2
- happy · 2 ✖
- acoustic guitar accompaniment 1
- active learning 1
- amateur home recording 1
- cheerful 1
- cheerful acoustic guitar 1
- children’s songs 1
- chirpy 1
- education songs 1
- emphatic vocals 1
- energetic coordination 1
- engaging 1
- entertaining 1
- enthusiastic 1
- female vocalist 1
- interactive 1
- joyful 1
- kindergarten songs 1
- learning is fun 1
- lively 1
- lively mandolin 1
- male vocalist 1
- minimal instrumentation 1
- nursery rhymes 1
- party song 1
- people talking 1
- popular kids songs 1
- popular song 1
- simple lyrics 1
- simple tune 1
- singing along 1
- spanish guitar 1
- spanish song 1
- youthful 1
musiccaps_names (array) 4 ✖
- Clapping · 2 ✖
- Music 2
- Singing 2
- Musical instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sergio el duende ( y yo le canto al amor...) | A male vocalist sings this energetic song. The tempo is fast emphatic vocals, bright acoustic guitar accompaniment and clap beat. The song is youthful, energetic, popular, cheerful, engaging and happy. The music is minimal with ambient sounds of people clapping, cheering, singing along and keeping beat with claps. The audio is distorted and muffled as it is an amateur home recording. | 2013-07-09T13:09:10Z | Maria Luisa Asencio | ["Singing", "Music", "Musical instrument", "Clapping"] | ["male vocalist", "fast tempo", "acoustic guitar accompaniment", "spanish guitar", "lively", "entertaining", "enthusiastic", "party song", "happy", "joyful", "cheerful", "youthful", "clapping", "singing along", "people talking", "emphatic vocals", "amateur home recording", "spanish song", "popular song"] | 7 | PN3Lx8RutmI | 2529 | ||
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;