musiccaps_details (view)
1 row where musiccaps_aspects contains "animated", musiccaps_aspects contains "children music", musiccaps_aspects contains "nursery rhyme" and musiccaps_aspects contains "scissors paper"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Rock Scissors Paper #1 | Finger Play Song | Super Simple Songs | This song is an animated duo in a male and female volume. The tempo is slow with a Pisano harmony, synthesiser arrangement and a small hand percussion. The song is a lively, simple, expressive,animated, rhythmic and informational children’s song/ nursery rhyme . | 2015-05-30T11:56:05Z | Super Simple Songs - Kids Songs | More great Super Simple videos in the Super Simple App for iOS ► http://apple.co/2nW5hPd Rock Scissors Paper, Rock Scissors Paper, 1,2,3...play with me! Put your hands together for a fun and creative fingerplay song for kids. What is it? Listen to Super Simple Songs on Spotify: https://spoti.fi/2ofnaZg Listen to Super Simple Songs on Apple Music: https://apple.co/2pBcg0j Or, just ask your smart speaker to play Super Simple Songs! PARENTS AND TEACHERS: Thank you so much for watching Super Simple Songs with your families and/or students. If your young ones are watching without supervision, we recommend some of the following viewing options: ► SUPER SIMPLE APP -- http://bit.ly/SuperSimpleApp Be the first to watch new Super Simple videos in the Super Simple App! Ad-free and designed for young learners. ► DOWNLOAD -- http://bit.ly/SuperSimpleShop Videos from all Super Simple channels are available for purchase at the Super Simple online shop. You can also find some DVDs there. ► YOUTUBE KIDS -- http://bit.ly/You-Tube-Kids Designed to make it safer and simpler for young ones to watch online video, YouTube Kids includes a suite of parental controls so you can tailor the experience to suit your family’s needs. ► AMAZON VIDEO Are you an Amazon Prime member? Watch Super Simple videos ad-free on Amazon Prime Video. Just search for “Super Simple.” ► KHAN ACADEMY KIDS -- http://bit.ly/KhanKids-App Super Simple has partnered with Khan Academy on their latest app designed for preschoolers. You’ll find Super Simple Songs worked into the curriculum throughout the app. ► PLAYKIDS -- http://bit.ly/Play-Kids Do you have the PlayKids app? You can find many of our Super Simple Songs and programs in the app! FREE SUPER SIMPLE TEACHING RESOURCES: http://bit.ly/SSFree-Resources SOCIAL MEDIA: Super Simple Newsletter Sign Up: http://bit.ly/SuperSimpleSignUp Facebook: http://bit.ly/SuperSimpleFacebook Instagram: http://bit.ly/SuperSimpleInsta Twitter: http://bit.ly/SuperSimpleTwitter Pinterest: http://bit.ly/SuperSimplePinterest *****… | ["Music", "Music for children"] | ["duet", "slow tempo", "piano harmony", "vocal backup", "expressive", "receptive language", "rhyming", "descriptive words", "listening and learning", "chimes", "synthesiser arrangement", "children music", "nursery rhyme", "rock", "scissors paper", "simple", "catchy", "learning for kids", "animated", "hand percussion"] | 7 | P65yE_EXLd8 | 2508 |
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;