musiccaps_details (view)
4 rows where musiccaps_aspects contains "piano", musiccaps_names = "["Music", "Happy music"]" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Barenaked Ladies - Pollywog In A Bog (Short Version) [Official Music Video] | The male voice is singing while male backing voices are underlining some phrases. They are adding harmonies to his singing. An acoustic drum and e-bass are holding the groove while a piano and e-guitar are playing the same chords. Another e-guitar is playing a melody, almost repeating the singer's melody as a response. The e-guitar is running through an effect. The guitars are panned to the left and right side of the speakers. This song may be playing at a scene of a rom-com movie. | 2008-07-03T23:36:42Z | Barenaked Ladies (official) | "Pollywog In A Bog" by Barenaked Ladies from their collection of original children's music Snacktime!, available now. Download on iTunes: http://smarturl.it/zggin5 Links: http://www.facebook.com/barenakedladies http://twitter.com/BARENAKEDLADIES "Pollywog In A Bog" Lyrics: In the puddle by the trail it flips its tiny tail Just like a great big whale but smaller than a snail It's a pollywog in a bog Swims under soggy logs One day he'll be a frog Pollywog in a bog Overhead a cedar tree gives the shade he needs Munching while he feeds on lily pads and weeds Knows not where he's from Or how his life had begun He's not the only one And soon he'll breathe through lungs It's hard to believe With the arms you'll receive You'll life your head above the water and breathe Gills shrink away and may there come a day When you reach the shore with a whole world to explore Ribbit ribbit a tadpole exhibit It's a transformation no one can inhibit Amphibian change may seem strange Take them gills and the tail and they all rearrange Out come the legs for the jump! jump! Hope to the top of the stump! stump! Out come the legs for the jump! jump! Hope to the top of the stump! stump! Where the mud is deep frost will soon creep And without a peep a frog is fast asleep It was a pollywog in a bog Swam under soggy logs In the morning fog Pollywog in a bog. Visit http://www.bnlmusic.com Subscribe to Nettwerk's YouTube channel: http://smarturl.it/nettwerkyoutube | ["Music", "Happy music"] | ["pop/rock", "e-bass", "piano", "e-guitars", "male singer", "mid range", "backing vocals", "acoustic drums", "light positive and melancholic atmosphere"] | 6 | N_Wx35sNqdM | 2350 | |
Hlub Teev Kua Muag Fan MV | This instrumental slow rock song features a guitar playing arpeggiated chords. This is accompanied by a piano playing passing chords. The percussion consists of only the ride cymbal being struck in a set of two strokes followed by a set of four strokes. This pattern continues throughout the song. The bass plays the root notes and filler notes at the start of each bar. There are no voices in this song. This song can be played in a coffee shop. | 2009-04-12T01:49:39Z | leemyis | Fan MV of Wu Chun & Aff Taksaorn... Song: Koj nyob rawv hauv siab by Nkauj Hli Vwj | ["Music", "Happy music"] | ["slow rock song", "pop song", "guitar", "piano", "ride cymbal", "bass", "no voices", "instrumental", "moderate tempo", "relaxing song"] | 0 | TFLt7mn57ZI | 2824 | |
I Can Hear the Bells | The music features a female voice that sings in a theatrical style, similar to Broadway musicals. The bass guitar and drums blend together and play a light accompaniment. A piano can also be heard contributing to the overall accompaniment. A string section plays a long note melody that transitions into playing in unison with the singer's melody. | 2011-01-05T13:59:15Z | Hairsprayhome | "I Can Hear the Bells" - Nikki Blonsky From the movie "Hairspray" from 2007 See the other songs from the movie at my chanel Pleas note: I OWNS NO RIGHTS FOR THE PICTURS OR THE SOUNDTRACK OF THE VIDEO! | ["Music", "Happy music"] | ["theatrical female voice", "strings", "bass guitar", "drums", "piano", "broadway musical vibes"] | 2 | ZbdmiykoJm8 | 3396 | |
Doraemon Opening Theme Song (Japanese Version) | This is the theme of a cartoon. There is a female vocalist singing merrily at a medium-to-high pitch in the Japanese language. The melody is being played on the strings and the piano while a simple on-beat bass line can be heard being played in the background. There is a simple 4/4 acoustic drum beat for the rhythm. The piece has an uplifting atmosphere. This piece could be used in the soundtrack of a children's movie. It could also be used in anime soundtracks. | 2012-04-28T03:24:44Z | Jennifer Nguyen | Doraemon Opening Theme Song (Japanese Version) | ["Music", "Happy music"] | ["cartoon theme", "female vocal", "merrily singing", "strings", "piano", "bass guitar", "acoustic drums", "playful", "uplifting", "positive", "childlike", "japanese"] | 9 | wBozBh7BR6k | 5247 |
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;