musiccaps_details (view)
2 rows where musiccaps_aspects contains "chirpy", musiccaps_aspects contains "fast tempo" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- chirpy · 2 ✖
- fast tempo · 2 ✖
- happy 2
- active learning 1
- amateur recording 1
- cheerful acoustic guitar 1
- cheering 1
- children’s songs 1
- clapping 1
- education songs 1
- energetic 1
- energetic coordination 1
- engaging 1
- enthusiastic 1
- female vocalist 1
- folk song 1
- foreign language 1
- home video 1
- hooting 1
- inferior audio quality 1
- interactive 1
- keyboard harmony 1
- kindergarten songs 1
- learning is fun 1
- lively mandolin 1
- lively trumpets 1
- male singer 1
- minimal instrumentation 1
- nursery rhymes 1
- party songs 1
- …
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shira Choir Rocking it away with Pinky Weber Music by Pinny Ostreicher | A male vocalist sings this spirited song. The tempo is fast with trumpets, keyboard harmony, steady drumming and simple bass lines along with vocal backup. The song is happy, energetic, enthusiastic, popular, peppy, vivacious and celebratory. There are sounds in the background of people talking, hooting, cheering and scuttling and rustling. This is a popular Folk/Regional song. | 2015-09-04T19:04:46Z | Go Jewish Music | At a Siyem in Upstate! | ["Singing", "Music", "Ska", "Music of Latin America"] | ["male singer", "fast tempo", "vocal backup", "popular songs", "hooting", "rustling", "home video", "amateur recording", "party songs", "foreign language", "lively trumpets", "keyboard harmony", "steady drumming", "straight bass lines", "vocal backup", "people talking", "cheering", "energetic", "happy", "enthusiastic", "home video", "inferior audio quality", "folk song", "regional music", "happy", "peppy", "chirpy"] | 7 | 1hABzqBHh7w | 297 | |
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;