musiccaps_details (view)
4 rows where musiccaps_aspects contains "chirpy", musiccaps_aspects contains "happy" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 77 ✖
- chirpy · 4 ✖
- happy · 4 ✖
- cheerful 2
- cheering 2
- fast tempo 2
- instrumental 2
- keyboard harmony 2
- people talking 2
- 8 stringed instrument 1
- acoustic guitar accompaniment 1
- active learning 1
- amateur recording 1
- ambient nature sounds 1
- animated 1
- background sounds 1
- bright 1
- catchy 1
- cheerful acoustic guitar 1
- children’s songs 1
- clapping 1
- dance music 1
- education songs 1
- energetic 1
- energetic coordination 1
- energetic drumming 1
- engaging 1
- enthusiastic 1
- female vocalist 1
- folk music 1
- folk song 1
- foreign language 1
- high notes 1
- home video 1
- hooting 1
- inferior audio quality 1
- interactive 1
- kindergarten songs 1
- learning is fun 1
- lively 1
- lively beat 1
- lively mandolin 1
- lively trumpets 1
- lute family 1
- male singer 1
- mandolin 1
- mandolin harmony 1
- medium tempo 1
- merry 1
- minimal instrumentation 1
- muffled audio 1
- nursery rhymes 1
- party songs 1
- peppy 1
- plucking 1
- pop song 1
- popular 1
- popular kids songs 1
- popular songs 1
- regional music 1
- rhythmic acoustic guitar 1
- rhythmic beat 1
- rustling 1
- simple 1
- simple lyrics 1
- simple tune 1
- soprano string instrument 1
- sound of laughter 1
- spirited 1
- steady drumming 1
- straight bass lines 1
- string harmony 1
- stringed instruments 1
- sunny 1
- tapping 1
- vocal backup 1
- xylophone harmony 1
- ’ enjoyable 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shira Choir Rocking it away with Pinky Weber Music by Pinny Ostreicher | A male vocalist sings this spirited song. The tempo is fast with trumpets, keyboard harmony, steady drumming and simple bass lines along with vocal backup. The song is happy, energetic, enthusiastic, popular, peppy, vivacious and celebratory. There are sounds in the background of people talking, hooting, cheering and scuttling and rustling. This is a popular Folk/Regional song. | 2015-09-04T19:04:46Z | Go Jewish Music | At a Siyem in Upstate! | ["Singing", "Music", "Ska", "Music of Latin America"] | ["male singer", "fast tempo", "vocal backup", "popular songs", "hooting", "rustling", "home video", "amateur recording", "party songs", "foreign language", "lively trumpets", "keyboard harmony", "steady drumming", "straight bass lines", "vocal backup", "people talking", "cheering", "energetic", "happy", "enthusiastic", "home video", "inferior audio quality", "folk song", "regional music", "happy", "peppy", "chirpy"] | 7 | 1hABzqBHh7w | 297 | |
If You're Happy and You Know It! | Barefoot Books Singalong | A female vocalist sings this lively Children’s Song. The tempo is fast with a cheerful acoustic guitar and ukulele accompaniment along with clapping. The song is lively, upbeat, engaging, energetic, simple and enthusiastic. The song is a children’s nursery rhyme with the catchy , simple tune and lyrics meant to make learning fun. It is engaging, interactive, instructional, educational teaching coordination. | 2010-05-13T19:52:28Z | Barefoot Books | If You're Happy and You Know It! | Barefoot Books Singalong Want more? (Click SHOW MORE below 👇) ⭐ Our favorite video: https://www.youtube.com/watch?v=C6ljGXMMB-g 🛒 Buy this book: https://www.barefootbooks.com/if-youre-happy-and-you-know-it 👣 Find out more: https://www.barefootbooks.com Stay in Touch! 🔔 Don't forget to subscribe! 👍🏽 Join our community: https://www.facebook.com/barefootbooks 🎁 FREE AT-HOME RESOURCES for KIDS🎁 https://bit.ly/358Fog6 ▶️ Check out this playlist! https://www.youtube.com/watch?v=ynlmvWAdCug&list=PL0maGUp7cdUn5uuLnjsk1NvV2u5Yg5LAV Clap your hands and sing along to this fresh take on a traditional singalong. The multicultural version of this early learner encourages action and imagination. 🎥 Recommended Videos to Watch: The Wheels on the Bus Singalong https://www.youtube.com/watch?v=9siyDPch-6c Knick Knack Paddy Whack Singalong https://www.youtube.com/watch?v=9--t3zl4NkY Over in the Meadow Singalong https://www.youtube.com/watch?v=C6ljGXMMB-g 👇 DOWNLOAD our WORLD ATLAS APP for KIDS 👇 https://apps.apple.com/us/app/barefoot-world-atlas/id489221652 ★☆★ CONNECT WITH US ON SOCIAL MEDIA ★☆★ FACEBOOK: https://www.facebook.com/barefootbooks/ INSTAGRAM: https://www.instagram.com/barefootbooks TWITTER: https://twitter.com/BarefootBooks #nurseryrhymes #kidssongs #singalong | ["Singing", "Music", "Clapping"] | ["female vocalist", "fast tempo", "cheerful acoustic guitar", "simple lyrics", "simple tune", "interactive", "learning is fun", "energetic coordination", "clapping", "lively mandolin", "minimal instrumentation", "children’s songs", "nursery rhymes", "popular kids songs", "education songs", "kindergarten songs", "happy", "chirpy", "engaging", "interactive", "active learning"] | 7 | 71hqRT9U0wg | 804 | |
Old Joe Clark - Mandolins | This music is instrumental . The tempo is fast with mandolins playing a lively, spirited rhythmic harmony with acoustic guitar accompaniment. The instrumentation is minimal with emphasis on the mandolin melody. The music is chirpy, perky, cheerful, happy, animated and spirited. | 2011-09-09T13:52:59Z | pstewart0831 | Bluegrass Mandolin Class impromptu jam Lyrics: 1. Old Joe Clark, the preacher's son Preached all over the plain The only text he ever knew Was high low jack and the game [Chorus] Fare thee well Old Joe Clark Fare thee well I'm bound Fare thee well Old Joe Clark Goodbye Betsy Brown 2. Old Joe Clark had a mule His name was Morgan Brown And every tooth in that mule's head Was sixteen inches round Chorus 3. Old Joe Clark had a yellow cat She would neither sing nor pray Stuck her head in a buttermilk jar And washed her sins away Chorus 4. Old joe clark had a house Fifteen stories high And every story in that house Was filled with chicken pie Chorus 5. I went down to Old Joe's house He invited me to supper I stumped my toe on the table leg And stuck my nose in the butter Chorus | ["Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["instrumental", "mandolin", "mandolin harmony", "stringed instruments", "8 stringed instrument", "string harmony", "lute family", "soprano string instrument", "high notes", "plucking", "lively", "cheerful", "happy", "sunny", "chirpy", "bright", "animated", "spirited", "dance music", "folk music", "acoustic guitar accompaniment"] | 7 | D-p9s8y2z_U | 1427 | |
Stand By Me (steel pan) | This music is a cheerful instrumental. The tempo is medium with the lead harmony on a Xylophone, energetic drumming, keyboard accompaniment and rhythmic acoustic guitar. The audio quality is inferior and the music is muffled and muddy. There are background sounds like people talking, laughing and ambient nature sounds like a breeze. The music is fun, youthful, simple, enjoyable, chirpy and vivacious. | 2008-02-13T06:13:56Z | svart3n | Steel Pan band at the 30th anniversary Flatbush Frolic in Brooklyn, NY, 2007. See the video in better quality @ http://youtu.be/LlCS3ZVutuk | ["Music", "Steelpan"] | ["instrumental", "medium tempo", "rhythmic acoustic guitar", "background sounds", "ambient nature sounds", "people talking", "sound of laughter", "cheering", "tapping", "merry", "happy", "chirpy", "cheerful", "’ enjoyable", "xylophone harmony", "energetic drumming", "muffled audio", "keyboard harmony", "lively beat", "catchy", "rhythmic beat", "pop song", "popular", "simple"] | 7 | tV3rvUSlVnY | 5043 |
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;