musiccaps_details (view)
2 rows where musiccaps_aspects contains "educational", musiccaps_aspects contains "piano" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- educational · 2 ✖
- piano · 2 ✖
- acoustic drums 1
- eccentric 1
- electronic drums 1
- electronic percussion 1
- female vocal 1
- instructive 1
- joyful 1
- kids song 1
- male vocal 1
- playful singing 1
- quirky 1
- upright bass 1
- xylophone 1
musiccaps_names (array) 6 ✖
- Music 2
- Hip hop music 1
- Music for children 1
- Rapping 1
- Speech 1
- Tick 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Good Morning, Mr. Rooster | Super Simple Songs | This is an educational kids song. There is a female vocalist singing playfully. The piano and the xylophone are playing a simple melody. The rhythm is a basic acoustic drum beat. The atmosphere is joyful. This piece can be used in the soundtrack of a kids TV show. | 2012-05-11T22:39:22Z | Super Simple Songs - Kids Songs | More great Super Simple videos in the Super Simple App for iOS ► http://apple.co/2nW5hPd Time to wake up! Playing this song after a good night's sleep or an afternoon nap will help young children get up bright-eyed and ready to go! Listen to Super Simple Songs on Spotify: https://spoti.fi/2ofnaZg Listen to Super Simple Songs on Apple Music: https://apple.co/2pBcg0j Or, just ask your smart speaker to play Super Simple Songs! PARENTS AND TEACHERS: Thank you so much for watching Super Simple Songs with your families and/or students. If your young ones are watching without supervision, we recommend some of the following viewing options: ► SUPER SIMPLE APP -- http://bit.ly/SuperSimpleApp Be the first to watch new Super Simple videos in the Super Simple App! Ad-free and designed for young learners. ► DOWNLOAD -- http://bit.ly/SuperSimpleShop Videos from all Super Simple channels are available for purchase at the Super Simple online shop. You can also find some DVDs there. ► YOUTUBE KIDS -- http://bit.ly/You-Tube-Kids Designed to make it safer and simpler for young ones to watch online video, YouTube Kids includes a suite of parental controls so you can tailor the experience to suit your family’s needs. ► AMAZON VIDEO Are you an Amazon Prime member? Watch Super Simple videos ad-free on Amazon Prime Video. Just search for “Super Simple.” ► KHAN ACADEMY KIDS -- http://bit.ly/KhanKids-App Super Simple has partnered with Khan Academy on their latest app designed for preschoolers. You’ll find Super Simple Songs worked into the curriculum throughout the app. ► PLAYKIDS -- http://bit.ly/Play-Kids Do you have the PlayKids app? You can find many of our Super Simple Songs and programs in the app! FREE SUPER SIMPLE TEACHING RESOURCES: http://bit.ly/SSFree-Resources SOCIAL MEDIA: Super Simple Newsletter Sign Up: http://bit.ly/SuperSimpleSignUp Facebook: http://bit.ly/SuperSimpleFacebook Instagram: http://bit.ly/SuperSimpleInsta Twitter: http://bit.ly/SuperSimpleTwitter Pinterest: http://bit.ly/SuperSimplePinterest ****** Good … | ["Music", "Music for children", "Speech"] | ["educational", "kids song", "female vocal", "playful singing", "piano", "xylophone", "acoustic drums", "joyful"] | 9 | 1Ziku4FLka4 | 288 | |
Matter Chatter (song for kids about solids, liquids, and gases) | This is an educational music piece. The male vocalist is singing in an instructive manner asking questions directed at kids. There is a quirky piano sound joined by an upright bass. The rhythmic background consists of an electronic drum beat joined by electronic percussive sounds. There is an eccentric atmosphere to this piece. It could be used in an educational atmosphere such as an introductory physics class. | 2014-06-12T22:01:53Z | Harry Kindergarten Music | MATTER CHATTER! A song for kids about the 3 states of matter: solid, liquid, and gas To purchase this song in video format (.mp4) or audio format (.m4a), please visit www.harrykindergartenmusic.com! WWW.HARRYKINDERGARTENMUSIC.COM Hip songs & videos for the K-2 classroom! - Most videos on my website: $2.49 - All audio files on my website: $1.00 - Audio/video song packs for a discounted price also available! Check out the Harry Kindergarten Music FACEBOOK page! www.facebook.com/groups/harrykindergarten To contact Mr. Harry about a speaking engagement for teachers, or if you have any other questions/comments, please contact pete@harrykindergartenmusic.com. *Disclaimer: Videos produced and shared by Harry Kindergarten Music are intended to be shown on the official HARRY KINDERGARTEN MUSIC YouTube channel and are NOT to be uploaded anywhere else. Please do NOT rip videos off of my channel and put them on yours. If YouTube is blocked in your school district, I graciously ask you to purchase the video or audio files from my website shown above. Happy teaching! Q: Can my class perform a "Harry Kindergarten song" for an audience? A: If you desire to have your class or group of students perform one of my “Harry Kindergarten” songs for an audience, please note that there is a $6.00 PERFORMANCE FEE. Here are some hypothetical examples of performance groups: * Students perform a song for an audience during a graduation ceremony. * Students perform a song for an audience during a school or community talent show. * Students perform a song for an audience during a school assembly. If you are unsure if you need to purchase a performance license or not, please inquire at: pete@harrykindergartenmusic.com. If you want more details about using a song multiple years or multiple classes, etc., e-mail me for a detailed PDF file. $6.00 can be sent to: Harry Kindergarten Music, LLC 508 Stewart Street Bellwood, PA 16617 | ["Music", "Rapping", "Tick", "Hip hop music"] | ["educational", "instructive", "male vocal", "piano", "upright bass", "electronic drums", "electronic percussion", "quirky", "eccentric"] | 9 | C33WdI64FiY | 1321 |
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;