musiccaps_details (view)

1 row where musiccaps_aspects contains "acoustic drums" and "youtube_published" is on date 2008-12-28

✎ View and edit SQL

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

CSV options: 

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;