musiccaps_details (view)
1 row where musiccaps_aspects contains "bass", musiccaps_author = 0, musiccaps_names contains "Music" and "youtube_published" is on date 2012-04-13
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 |
---|---|---|---|---|---|---|---|---|---|---|
Here We Go Loopy Loo - Children's Song - Kids Songs by THE LEARNING STATION | This children's song features a male voice singing the main melody. There are other voices singing backing vocals. This is accompanied by percussion playing a simple beat. A guitar strums the chords accenting the strums in between lines. The bass plays the root notes of the chords with a reggae feel. The keyboards play chords in the background. This song can be played at a children's party. | 2012-04-13T21:08:00Z | TheLearningStation - Kids Songs and Nursery Rhymes | HERE WE GO LOOPTY LOO Song by THE LEARNING STATION "Here We Go Loopty Loo", from the award-winning DVD, "Movin' & Groovin' Vids for Kids" Award-winning CD, "Here We Go Loopty Loo". "Movin' & Groovin' Vids for Kids" DVD: http://store.learningstationmusic.com/movinandgroovin.aspx. Here We Go Loopty Loo CD Download: http://store.learningstationmusic.com/herewegolooptyloodownload.aspx "Here We Go Loopty Loo" CD: http://store.learningstationmusic.com/herewegolooptyloo.aspx Visit The Learning Station: https://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/pages/The-Learning-Station/115732872904 Twitter: http://twitter.com/#!/LearningStation * FREE STUFF * Sign-up for our FREE newsletter: http://learningstationmusic.com/newsletter.html FREE printable activities: http://learningstationmusic.com/printablehandouts.html Tony Chestnut official website: http://tonychestnut.com/ Tony Chestnut Tee Shirts:http://store.learningstationmusic.com/tonychestnutt-shirt.aspx Tony Chestnut printable lyrics, movements and activities:http://learningstationmusic.com/docs/Tony-Chestnut.pdf This song is part of our campaign that supports, Healthy Music for a Child's Heart, Body & Mind! Young children naturally love to sing, dance and move. "Here We Go Loopty Loo" is one of the most popular rhyming dance songs of all time and it invites children to actively participate as they learn the names of body parts. Songs that call for movement, participation and dance are also great for teaching coordination, balance and are filled with healthy fitness. And songs, chants, and action rhymes are a fun English-learning resource for ESL/EFL teachers and students. Here We Go Loopty Loo From the DVD, Movin' & Groovin' Vids for Kids (Online Video Design Production) From the CD, "Here We Go Loopty Loo" By The Learning Station ©Monopoli/The Learning Station HERE WE GO LOOPTY LOO (Activity: Have the chil… | ["Singing", "Music", "Ska"] | ["children's song", "male voice", "guitar", "percussion", "bass", "happy song", "keyboard", "backing voices", "dance song for children", "moderate tempo"] | 0 | 00M9FhCet6s | 109 |
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;