musiccaps_details (view)
2 rows where musiccaps_aspects contains "female vocal", musiccaps_aspects contains "xylophone" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- female vocal · 2 ✖
- xylophone · 2 ✖
- acoustic drums 1
- christian 1
- church 1
- educational 1
- electric guitar 1
- gospel 1
- joyful 1
- kids song 1
- piano 1
- playful singing 1
- religious 1
- tambourine dance 1
musiccaps_names (array) 5 ✖
- Music 2
- Music for children 1
- Salsa music 1
- Speech 1
- Tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Good Morning, Mr. Rooster | Super Simple Songs | This is an educational kids song. There is a female vocalist singing playfully. The piano and the xylophone are playing a simple melody. The rhythm is a basic acoustic drum beat. The atmosphere is joyful. This piece can be used in the soundtrack of a kids TV show. | 2012-05-11T22:39:22Z | Super Simple Songs - Kids Songs | More great Super Simple videos in the Super Simple App for iOS ► http://apple.co/2nW5hPd Time to wake up! Playing this song after a good night's sleep or an afternoon nap will help young children get up bright-eyed and ready to go! 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 ****** Good … | ["Music", "Music for children", "Speech"] | ["educational", "kids song", "female vocal", "playful singing", "piano", "xylophone", "acoustic drums", "joyful"] | 9 | 1Ziku4FLka4 | 288 | |
Tambourine Dance "God is Awesome" (Eksilah Dance Team) | This is a gospel piece used as an accompaniment to a tambourine dance. There is a female vocalist singing. There is an electric guitar and a xylophone playing the melody. The tune is not very clear due to the quality of the recording. The atmosphere is religious. Samples could be lifted from this recording to be used in a beat. | 2013-07-07T13:03:26Z | Eksilah Danceteam | Tambourine Dance Presentation by Eksilah Dance Team during the 70th Anniversary Celebration of Chinese Christian Church Hatyai. July 6, 2013 | ["Music", "Tambourine", "Salsa music"] | ["tambourine dance", "gospel", "electric guitar", "xylophone", "female vocal", "religious", "christian", "church"] | 9 | tRA-5inwlMI | 5036 |
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;