musiccaps_details (view)
2 rows where musiccaps_aspects contains "chimes", musiccaps_aspects contains "synthesiser arrangement" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- catchy 2
- chimes · 2 ✖
- synthesiser arrangement · 2 ✖
- animated 1
- ardent 1
- boomy bass lines 1
- children music 1
- descriptive words 1
- duet 1
- edm 1
- electronic music 1
- electronic sound arrangements 1
- energetic digital drum 1
- expressive 1
- fast tempo 1
- groovy 1
- hand percussion 1
- instrumental 1
- intense 1
- learning for kids 1
- listening and learning 1
- nursery rhyme 1
- perky 1
- piano harmony 1
- punch bass line 1
- receptive language 1
- rhyming 1
- rock 1
- scissors paper 1
- simple 1
- slow tempo 1
- surround sound 1
- synth pop instrumental 1
- vivacious 1
- vocal backup 1
musiccaps_names (array) 5 ✖
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 | |
PP,PE film crushing washing drying pelleting.mpg | This music is an instrumental. The tempo is fast with a keyboard harmony, boomy bass lines, chimes and electronic arrangements. The music is catchy, perky, vivacious, groovy, intense and ardent. This music is a Synth pop instrumental. | 2012-02-17T13:03:33Z | droway86 | We are manufacturer of waste plastic processing machines, If you have any questions ,Please contact us: www.recycle-way.com,mail:sales@recycle-way.com,TEL:008613794959740 | ["Background music", "Music", "Ambient music", "Electronica"] | ["instrumental", "fast tempo", "groovy", "synth pop instrumental", "catchy", "perky", "intense", "ardent", "surround sound", "boomy bass lines", "vivacious", "synthesiser arrangement", "chimes", "punch bass line", "edm", "electronic music", "electronic sound arrangements", "energetic digital drum"] | 7 | TcJ7rdYMHiQ | 2852 |
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;