musiccaps_details (view)

1 row where musiccaps_aspects contains "call and response", musiccaps_aspects contains "children's song" and musiccaps_names contains "Music"

✎ 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
Down by the Bay with Lyrics - Nursery Rhymes - Children’s Songs by The Learning Station This children's song features a male voice singing the main melody. This is accompanied by male and female voices singing backing vocals in harmony. This has a call and response technique where the main voice sings a line followed by the response by the choir. This is accompanied by percussion playing a simple beat. After two bars, the instruments pause. The bass plays the root notes of the chords and sliding to a pause at the end of the bar. During the pause, the voices continue to sing. The main voice sings two lines and the choir sings the third line with the main voice in harmony. The mood of this song is happy. After the pause, the singers return to singing the same melody. This song can be played in an educational movie for children. 2015-02-27T18:29:42Z TheLearningStation - Kids Songs and Nursery Rhymes Down by the Bay, enjoy our delightfully animated version of this popular nursery rhyme. From the CD, Nursery Rhymes with The Learning Station. Nursery Rhymes with The Learning Station CD Download: http://store.learningstationmusic.com/nurseryrhymeswiththelearningstationcddownload.aspx LIKE us on Facebook and participate in FREE giveaways galore: http://www.facebook.com/LearningStationMusic SUBSCRIBE to our YouTube channel: https://www.youtube.com/user/TheLearningStation Down by the Bay - Nursery Rhymes with Lyrics - Children’s Songs by The Learning Station Children will love this delightfully animated nursery rhyme. These traditional skill building songs have proven the test of time being enjoyed by children for centuries. Singing nursery rhymes enhances vocabulary and language development. Nursery rhymes accelerate phonemic awareness improving children’s word comprehension, reading and writing skills. Also, nursery rhymes with actions teach children basic skill, boosts memory, listening skills and following directions. This song is great for brain breaks, morning meeting, indoor recess and literacy awareness. Toddlers, preschoolers and kindergarten age children will giggle with joy as they participate in this super simple, easy to learn, nursery rhyme song that makes learning fun and exciting. Visit The Learning Station: http://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/LearningStationMusic Twitter: https://twitter.com/LearningStation Pinterest: http://pinterest.com/kidssong/ Blog: http://www.learningstationmusic.com/blog/ Google+: https://plus.google.com/+Learningstationmusic * FREE STUFF * Sign-up for our FREE newsletter: http://learningstationmusic.com/newsletter.html FREE printable activities: http://learningstationmusic.com/printablehandouts.html Illustrations and animation by Corbett Vanoni: https://www.facebook.com/CorbettVanoniArt OTHER POPULAR… ["Funk", "Music", "Rhythm and blues"] ["children's song", "male voice", "male backing voices", "call and response", "female backing voices", "percussion", "bass", "rhyming song"] 0 Yt1czlnCUCg 3318

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;