musiccaps_details (view)
3 rows where musiccaps_aspects contains "children's song" and musiccaps_aspects contains "happy song" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- children's song · 3 ✖
- happy song · 3 ✖
- children laughing 2
- clarinet 2
- backing voices 1
- bass 1
- brass instruments 1
- cheerful upbeat song 1
- cheery female vocalist 1
- child cheering 1
- child singing 1
- children singing 1
- dance song for children 1
- electric bass guitar 1
- guitar 1
- keyboard 1
- male voice 1
- moderate tempo 1
- percussion 1
- playful 1
- slow tempo 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Diez Clan at Peppa Pig's World | This is a children's song that includes a clarinet melody that follows the vocal melody. There are children laughing and a child singing the main vocal melody. There's a child exclaiming joy. There's a subtle bassline. | 2012-08-11T18:26:55Z | JOSE DIEZ | As it says on the tin | ["Music", "Oink"] | ["clarinet", "children laughing", "child singing", "happy song", "slow tempo", "child cheering", "electric bass guitar", "children's song"] | 3 | SKt_3Nv2DHo | 2759 | |
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 | |
Madeline and the Dinosaur Bone 1 | The song is fun, playful and cheerful. It involves child vocalists who sing in unison, and various sound effects of children laughing, and a child exclaiming. The song features an intricate clarinet melody which follows the vocal in note selection. | 2010-01-27T07:42:27Z | littlemissmadeline28 | From the New Adventures of Madeline. No copyright infringement intended; for fan purposes only. | ["Jazz", "Music"] | ["children's song", "children singing", "cheery female vocalist", "children laughing", "cheerful upbeat song", "happy song", "clarinet", "brass instruments", "playful"] | 3 | UOAv5b6MGxw | 2911 |
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;