musiccaps_details (view)
2 rows where musiccaps_aspects contains "keyboard", musiccaps_aspects contains "moderate tempo" and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- bass 2
- keyboard · 2 ✖
- moderate tempo · 2 ✖
- percussion 2
- backing voices 1
- children's song 1
- dance song for children 1
- groovy bass 1
- guitar 1
- happy mood 1
- happy song 1
- instrumental 1
- male voice 1
- no voices 1
- simple beat 1
- simple song 1
- ska song 1
- trumpets 1
- upbeat 1
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 | |
LADRON-MASKATESTA | This ska song features a trumpet playing the main melody. The trumpet plays one staccato note followed by a six note pattern and then plays the same sequence starting on a different root note. This is accompanied by percussion playing a simple beat. A keyboard plays chords in the background. The bass plays a groovy bassline. There are no voices in this song. This is an instrumental song. The mood of this song is happy. This song can be played in a comedy movie. | 2009-03-06T22:39:59Z | Hector Israel Reyes Leal | VERSION ORIGINAL | ["Music", "Ska"] | ["ska song", "keyboard", "trumpets", "bass", "percussion", "no voices", "instrumental", "moderate tempo", "upbeat", "happy mood", "groovy bass", "simple beat", "simple song"] | 0 | AH6Xnyj6Ykc | 1097 |
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;