musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "playful" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Music and Movement Songs for Children: "Jump High" by Music with Miss Merry | This is a song for children. The song is in major key as is usual with almost all kids songs. There is a female vocalist in the lead. The melody is being played by an acoustic guitar while a bass guitar plays a simple bass line. The electric guitar is playing delayed notes for texture. The acoustic drums are playing a basic medium tempo beat in the rhythmic background. The atmosphere is easygoing. This piece could be used during activities in a kindergarten. | 2008-12-28T14:57:25Z | Meredith LeVande | Please visit https://musicwithmissmerry.com, plus stream this and more Music with Miss Merry children's music videos at https://musicwithmissmerry.vhx.tv. "Jump High" is a preschool music and movement children's music video by Monkey Monkey Music. This you tube music video along with other songs for children and nursery rhymes such as "Old MacDonald Had a Farm," "Twinkle Twinkle Little Star" and "abc songs" for kids are both fun and educational. Monkey Monkey Music videos are seen on public television before and after iconic PBS Kids shows like "Sid The Science Kid," "Sesame Street," "Curious George," "Barney," and "Dinosaur Train." Looking to throw a great New York birthday party? Also, please visit Music with Miss Merry's YouTube channel at https://www.youtube.com/@musicwithmissmerry. Copyright 2008. Monkey Monkey Music, LLC. All Rights Reserved. | ["Jazz", "Music", "Dance music"] | ["children's song", "female vocal", "acoustic guitar", "electric guitar", "bass guitar", "acoustic guitar", "repeated theme", "acoustic drums", "simple", "easygoing", "playful", "medium tempo"] | 9 | 0RcMzUdXDRQ | 166 |
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;