musiccaps_details (view)
1 row where musiccaps_aspects contains "lullaby", musiccaps_aspects contains "medium to uptempo" and musiccaps_aspects contains "ride cymbal"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Twinkle Twinkle Little Star | Lullabies for Babies And More | HooplaKidz | This song contains a female kid's voice singing with a little reverb and delay in her voice. An e-bass is playing a simple line along with a piano playing major chords. Panned to both sides of the speakers you can hear different percussive elements such as ride cymbal hits, shaker and bongos. Another keyboard sound is playing the main melody taking turns with the singer. Some twinkling sound adds single notes on top to round up the lullaby. This song may be playing for a kids tv-show. | 2015-08-22T13:48:48Z | HooplaKidz - Official Nursery Rhymes Channel | HooplaKidz presents it's latest compilation video, including one of our most recent songs, "Twinkle Twinkle Little Star". So come along kids and let's have some "hoopla-fun"! Subscribe to HooplaKidz for new videos every week: https://www.youtube.com/c/HooplaKidz?sub_confirmation=1 To download the HooplaKidz Plus App: https://applk.io/hooplakidz_plus Watch our playlists: Latest Compilations https://www.youtube.com/watch?v=_Iw03i1ZdII&list=PLV3Gd8vEgOrg8cCPaWjXRTyz1PFSoHdNS Baby Songs & Lullabies https://www.youtube.com/watch?v=7zSCza_2Eok&list=PLV3Gd8vEgOrg3TVrZML9IbCiW5OmmVJo7 About HooplaKidz: HooplaKidz is one of the most popular YouTube channels for preschoolers featuring the cutest and coolest characters in town Annie, Ben and Mango singing and dancing to many popular nursery rhymes and original songs as well as super fun learning videos. Thanks for watching :) Twinkle Twinkle Little Star Song + Much More Nursery Rhymes & Kids Songs - Hooplakidz https://www.youtube.com/watch?v=cJD5JFWnxNo HooplaKidz: https://www.youtube.com/hooplakidz Copyright YoBoHo. All Rights Reserved. | ["Music", "Vocal music"] | ["lullaby", "e-bass", "bongos", "piano", "female kids voice", "keyboard", "shaker", "ride cymbal", "medium to uptempo"] | 6 | cJD5JFWnxNo | 3698 |
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;