musiccaps_details (view)
1 row where musiccaps_aspects contains "steel guitar melody" and musiccaps_names contains "Music for children"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Animal Sounds Song | English nursery rhyme | Baby Song for children | The low quality recording features a children's song that features a flat male vocal, alongside wide harmonizing children vocals, singing over acoustic rhythm guitar, steel guitar melody, happy bells melody, soft kick hits, mellow snare hits, shimmering hi hats and groovy bass. It sounds joyful, happy and exciting. | 2015-05-01T09:58:23Z | Kids Baby Club - children songs and nursery rhymes | Fun video of animals and how they soundWe have a nursery rhyme, song, video or game for every occasion here at Kids Baby Club. With home to many cartoon 2D and 3D characters, we are a preschooler's best friend. A school away from school we make our videos not just to please the toddler but also to educate him/her with new concepts, skills, and ideas. We take kindergarten a step further with an in-depth understanding of a preschoolers comprehension, cognitive development, motor skills, language acquisition, executive functions, self-concept, identity development and moral values. 🌈 Hello toddlers, Bob The Train is here to make your learning time easy and fun with these playful toys. Click on the link to explore the toys now! - https://amzn.to/2PCeSDS We hope you liked our videos SUBSCRIBE to our channel to get a notification whenever we upload a new one. Home to ‘Ben the train’ and ‘the Crayons Club’ Kids Baby Club welcomes all toddlers to the land of fun learning! Like & Follow us on: Facebook: https://www.facebook.com/pages/Kids-Baby-Club/996037217074197 G+: https://plus.google.com/u/0/+KidsBabyClub Twitter: https://twitter.com/kidsbabyclub Visit us on our official website: https://www.uspstudios.co/creation/channel/kids-baby-club/9/ ============================================ Music and Lyrics: Copyright USP Studios™ Video: Copyright USP Studios™ ============================================ | ["Singing", "Music", "Music for children", "Song"] | ["low quality", "children song", "flat male vocal", "wide harmonizing children vocals", "groovy bass", "acoustic rhythm guitar", "steel guitar melody", "shimmering hi hats", "happy bells melody", "soft kick hits", "mellow snare hits", "joyful", "happy", "exciting"] | 4 | BfUoopDpmmY | 1273 |
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;