musiccaps_details (view)
2 rows where musiccaps_aspects contains "male voice", musiccaps_aspects contains "piano" and musiccaps_aspects contains "simple percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- bass 2
- male voice · 2 ✖
- moderate tempo 2
- piano · 2 ✖
- simple percussion · 2 ✖
- backing voice 1
- choir backing 1
- guitar 1
- happy mood 1
- happy song 1
- jazzy song 1
- keyboard music 1
- pop rock song 1
- pop song 1
- upbeat song 1
musiccaps_names (array) 9 ✖
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Jingle (music) 1
- Music 1
- Percussion 1
- Rimshot 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Toy Story - You've got a friend in me - Randy Newman - Lyrics | This pop song features a male voice singing the main melody. This is accompanied by percussion playing a simple beat in common time. A choir sings vocables in the background. A piano plays fills in between lines using jazz sequences. A bass plays the root notes of the chords. Strings and flutes can be heard playing along with the voice on the second bar in an ascending run. This song has an upbeat mood. The theme of this song is about friendship. This song can be played in a drama movie about friends. | 2010-10-12T12:59:35Z | Giorgio Magliano | Lyrics, info and other stuff here! Have a request, complaint or compliment? Leave a comment! Links: http://www.randynewman.com/ http://www.toystory.com/ http://www.disney.com/ http://www.pixar.com/ The audio used in this video is and will always be owned by it's original writer, Randy Newman. I do not claim to own this song in any possible way, and am only uploading it for entertainment purposes. Lyrics: You've got a friend in me You've got a friend in me When the road looks rough ahead And you're miles and miles from your nice warm bed You just remember what your old pal said Boy, you've got a friend in me Yeah, you've got a friend in me You've got a friend in me You've got a friend in me You got troubles Then I got them too There isn't anything I wouldn't do for you We stick together, we can see it through Cause you've got a friend in me You've got a friend in me Some other folks might be a little bit smarter than I am Bigger and stronger too Maybe But none of them Will ever love you The way I do It's me and you, boy And as the years go by Our friendship will never die You're gonna see it's our destiny You've got a friend in me You've got a friend in me You've got a friend in me | ["Jingle (music)", "Music"] | ["pop song", "jazzy song", "male voice", "piano", "bass", "simple percussion", "moderate tempo", "happy song", "choir backing", "keyboard music"] | 0 | Zy4uiiy0qgA | 3430 | |
Hanson Returns! | This pop rock song features a male voice singing the main melody. A backing male voice sings the last part of the line in harmony. This is accompanied by a piano playing staccato chords. There is a momentary silence of instruments except the percussion after the chords are struck. An acoustic guitar plays chords in the background. A bass guitar plays the root notes of the chords. The percussion plays a simple beat in common time and finishes the bar with a roll. Then the drum plays with the beat with an open hi-hat. The mood of this song is happy. This song can be played in a coming of age movie. | 2008-09-06T22:44:23Z | CBS | It may be hard to believe that all three of these brothers are now married and have children, but the hit 90's pop group Hanson still knows how to rock. The trio perform live on the Second Cup Café. | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["pop rock song", "male voice", "simple percussion", "guitar", "piano", "bass", "backing voice", "upbeat song", "happy mood", "moderate tempo"] | 0 | pwX5SArqGKU | 4743 |
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;