musiccaps_details (view)
1 row where musiccaps_aspects contains "educational", musiccaps_aspects contains "upright bass" and musiccaps_names contains "Tick"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;