musiccaps_details (view)
2 rows where musiccaps_aspects contains "happy", musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- happy · 2 ✖
- joyful 2
- low quality 2
- punchy kick · 2 ✖
- brass stabs 1
- children song 1
- electric guitar melody 1
- energetic crash 1
- exciting 1
- fruity male vocal 1
- fun 1
- groovy bass 1
- groovy piano 1
- mellow 1
- mellow bells melody 1
- mellow female vocal 1
- punchy snare 1
- shimmering hi hats 1
- shimmering shakers 1
- soft 1
- steel drums melody 1
- sustained organ keys chord 1
musiccaps_names (array) 4 ✖
- Music 2
- Singing · 2 ✖
- Funk 1
- Music for children 1
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 | |
Boom Boom Room-J Paul Jr. | The low quality recording features a fruity male vocal singing over steel drums melody, electric guitar melody, brass stabs, punchy kick and snare hits, energetic crash cymbal, groovy bass, shimmering shakers and sustained organ keys chord. It sounds joyful, happy and exciting. | 2011-07-14T03:42:01Z | Bigzydecohal21 | Let Tha Rebel take u to the Boom Boom Room | ["Singing", "Funk", "Music"] | ["low quality", "steel drums melody", "electric guitar melody", "brass stabs", "sustained organ keys chord", "punchy snare", "punchy kick", "groovy bass", "energetic crash", "fruity male vocal", "shimmering shakers", "joyful", "happy", "exciting"] | 4 | d61plJ66vE8 | 3762 |
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;