musiccaps_details (view)
1 row where musiccaps_aspects contains "groovy piano" and "youtube_published" is on date 2014-07-30
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 |
---|---|---|---|---|---|---|---|---|---|---|
Finger Family - Cat Family | Learn with Little Baby Bum | Nursery Rhymes for Babies | ABCs and 123s | The low quality recording features a children's song that consists of a groovy piano, mellow bells melody, punchy kick and shimmering hi hats, after which a mellow female vocal starts singing. It sounds happy, fun, soft, mellow and joyful. | 2014-07-30T07:34:45Z | Little Baby Bum - Nursery Rhymes & Kids Songs | We're available on Spotify! https://open.spotify.com/playlist/05tdW3fw1NDaqVELGgYuWm?si=Z-alZcFWQGWFsJ1TX1TpSw Download this video now! https://wayokids.com/p/finger-family-cat-family-from-little-baby-bum-official-release-13344 SUBSCRIBE for new videos every week! ►https://goo.gl/59WdSj Watch More Little Baby Bum ► Songs About Numbers, ABC's and shapes: https://www.youtube.com/watch?v=wwdqK_XNBNM&list=PL0VE_cI7-AYRotjbI1cGFg8zscyzgFClS LBB TV: https://www.youtube.com/watch?v=fQTDpa_c-nk&list=PL0VE_cI7-AYRx9Qbz5C0oQix0AO6YdCtw LBB and friends: https://www.youtube.com/watch?v=J3htU652mBY&list=PL0VE_cI7-AYSuxGdfT5N15Aks-y_HbNg7 Ten little animals | Counting for kids: https://www.youtube.com/watch?v=lX2NvIQS8iM ABC song: https://www.youtube.com/watch?v=ezdzxieXJvc Lyric: Daddy finger, daddy finger, where are you? Here I am, here I am. How do you do? Mommy finger, Mommy finger, where are you? Here I am, here I am. How do you do? Brother finger, Brother finger, where are you? Here I am, here I am. How do you do? Sister finger, Sister finger, where are you? Here I am, here I am. How do you do? Baby finger, Baby finger, where are you? Here I am, here I am. How do you do? #nurseryrhymes #littlebabybum | ["Singing", "Music", "Music for children"] | ["low quality", "children song", "groovy piano", "mellow bells melody", "punchy kick", "shimmering hi hats", "mellow female vocal", "happy", "fun", "soft", "mellow", "joyful"] | 4 | UVY68vFiApA | 2921 |
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;