musiccaps_details (view)
1 row where musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "glockenspiel" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Fill Your Bucket - Children's Song by The Learning Station | The music features male and female voices singing the same melody in unison. An electric guitar accompanies the singers with strummed chords. The bass guitar and drums drive the pulse of the music forward. At one point a glockenspiel can be heard playing three notes. The overall atmosphere is happy and uplifting. | 2012-04-02T16:28:02Z | TheLearningStation - Kids Songs and Nursery Rhymes | FILL YOUR BUCKET SONG by The Learning Station Fill Your Bucket, from the award-winning CD, #1 Best Kid's Songs! CD Download: http://store.learningstationmusic.com/1bestkidssongscddow... CD: http://store.learningstationmusic.com/bestkidssongs.aspx Visit The Learning Station: https://www.learningstationmusic.com/ Visit our store! CD's, CD Downloads, DVD's, Tee shirts & more: https://www.learningstationmusic.com/shop/ STAY IN TOUCH WITH US Facebook: http://www.facebook.com/pages/The-Learning-Station/115732872904 Twitter: http://twitter.com/#!/LearningStation Sign-up for our FREE newsletter: http://learningstationmusic.com/newsletter.html FREE printable activities: https://www.learningstationmusic.com/shop/ FREE curriculum - Kindness Counts: Exploring Random Acts of Kindness: http://www.tonychestnut.com/BookAboutTonyCurriculum.pdf Bucket fillers' are those who help without being asked, give hugs and compliments, and generally spread their love and good feelings to others. Why teach kindness? There have been numerous studies which demonstrate the positive effects of kindness on health and well-being. The kindness giver, receiver and even those observing the kind act immediately experience an increase in happiness, a blissful sense of euphoria, increase in energy, more optimism and a general feeling of being healthy. Children who learn about compassion, respect, empathy and how to express acts of kindness in both words and actions, can have a positive impact on the world they live in. It is proven that young children raised to understand the value of kindness are less likely to bully or even become violent. Remember you can make a difference each time you brighten someone's life through small efforts like a smile, kind word, saying thank you or showing you care. LYRICS Fill Your Bucket From the CD, #1 Best Kid's Songs © Monopoli/The Learning Station Words for your word wall: "Friendship" "Kindness" "Helpful" "Polite" "Caring" "Respect" "Empathy" "Compassion" "Sympathy" "Concern" "Sharing" Hold the… | ["Jingle (music)", "Music"] | ["male and female voices", "unison", "electric guitar", "drums", "bass guitar", "glockenspiel", "happy vibes"] | 2 | WaddbqEQ1NE | 3109 |
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;