musiccaps_details (view)
3 rows where musiccaps_aspects contains "cheerful" and musiccaps_aspects contains "electronic drums"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- cheerful · 3 ✖
- electronic drums · 3 ✖
- playful 2
- bass 1
- bass guitar 1
- bells 1
- christmas 1
- female vocal 1
- female vocals 1
- festive 1
- hip-hop 1
- instrumental 1
- keyboard 1
- kids song 1
- melodic singing 1
- no singer 1
- original pilipino music 1
- percussion 1
- rap-like singing 1
- remix 1
- strings 1
- trumpets 1
- upbeat 1
- urban 1
- wind band 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Learn with Little Baby Bum | Pet a Cake | Nursery Rhymes for Babies | ABCs and 123s | This is a kids music piece in the style of hip-hop. There is a female vocalist singing in a rap-like manner in the lead. The keyboard is playing the melody while there is a simple bass line in the background. A hip-hop electronic drum beat provides the rhythm. The atmosphere is playful. This piece can be used in the soundtrack of a kids TV show. | 2015-04-24T07:55:02Z | Little Baby Bum - Nursery Rhymes & Kids Songs | We're available on Spotify! https://open.spotify.com/playlist/05tdW3fw1NDaqVELGgYuWm?si=Z-alZcFWQGWFsJ1TX1TpSw 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 0:04 Pat A Cake 1:04 Wheels On The Bus - part 5 2:57 The Grand Old Duke Of York 4:14 Row Row Row Your Boat - part 2 6:55 Hickory Dickory Dock 8:12 Mr Sun 9:56 Numbers Song 1-20 12:06 The Bear Went Over The Mountain 13:56 One Potato, Two Potato 15:53 Days Of The Week 17:31 Hey Diddle Diddle 19:46 Baa Baa Black Sheep - part 1 20:38 Twinkle Twinkle Little Star 22:46 Brush Teeth Song 24:29 Shapes Song 26:27 Wheels On The Bus - part 6 28:24 Head, Shoulders, Knees & Toes 30:25 Five Little Monkeys - part 2 32:39 BINGO 34:36 Old MacDonald Had A Farm - part 1 35:51 Old MacDonald Had A Farm - part 2 38:06 ABC Phonics 39:35 Baa Baa Black Sheep - part 2 40:50 Wash Hands Song 42:31 Mary Had A Little Lamb 44:12 Ten In The Bed 46:41 Three Little Kittens 48:57 Potty Song 50:19 Rainbow Colors Song 51:50 Ten Little Animals 53:10 Row Row Row Your Boat - part 1 #nurseryrhymes #littlebabybum | ["Music", "Music for children"] | ["kids song", "hip-hop", "female vocal", "rap-like singing", "keyboard", "bass", "electronic drums", "playful", "cheerful", "urban"] | 9 | SMjYheNdAzg | 2763 | |
Mum and the Trumpet Girls (Bugler's Holiday) | This is an instrumental wind band music piece. There are three trumpets playing the main melody while a wind instrument sound is playing a supporting tune. There is a bass guitar playing in the background. The rhythm consists of a simple electronic drum beat. The atmosphere is playful and cheerful. This piece could be used in the soundtrack of a kids TV show. | 2010-10-26T09:13:56Z | krystalstawarz95 | ["Brass instrument", "Trumpet"] | ["no singer", "instrumental", "wind band", "trumpets", "bass guitar", "electronic drums", "playful", "upbeat", "cheerful"] | 9 | Z0O2r0Dl2T4 | 3334 | ||
opm christmas song (megamix) ft.dj klu - part 2 | This is the remix of an Original Pilipino Music (OPM) Christmas song. The female vocalist is singing melodically and in a festive manner. The melody is being played by a strings section while the rhythm consists of an electronic drum beat with heavy usage of percussive elements. The atmosphere is cheerful. This piece could be played at Christmas events in the Philippines. | 2009-09-11T06:15:35Z | edwell143 | wala lang trip lang to.ramdam ko kasi pasko na..advance merry christmas sa inyong lahat... | ["Christmas music", "Music of Asia", "Christian music", "Music"] | ["original pilipino music", "christmas", "remix", "female vocals", "melodic singing", "electronic drums", "percussion", "bells", "strings", "festive", "cheerful"] | 9 | lZavPVn7O4Q | 4409 |
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;