musiccaps_details (view)
3 rows where musiccaps_aspects contains "male voice", musiccaps_aspects contains "pop song" and musiccaps_aspects contains "simple percussion"
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 |
---|---|---|---|---|---|---|---|---|---|---|
NEWSONG - Christmas Shoes | This song features a male voice singing the main melody. The first two lines are sung using the same melody and it culminates in the third line. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. The keyboard plays arpeggiated chords in the background. Another synth plays a windy pad voice throughout the song sounding like strings. This song has a holiday mood. This song can be played in a holiday movie. | 2007-12-24T11:51:57Z | Lee O. | This was made by me for my wonderful friend Rhena! A really special girl who is so nice to everyone, and truly deserves something really special done for her too! She has always wanted to see a video to this touching song, so Rhena... I hope this doesn't disappoint! The Song: Christmas Shoes The Artist: Newsong | ["Christian music", "Music"] | ["low quality audio", "pop song", "holiday mood", "male voice", "synth", "synth pads", "simple percussion", "keyboard", "bass", "slow tempo"] | 0 | KfAq7kxHjPk | 2104 | |
Musica Romantica | This pop song features a male voice singing the main melody. This is accompanied by percussion playing a simple beat. The hi-hat is played in eighth notes. The bass is played on a tuba. The root notes of the chords are played. Trumpets play a staccato note at every alternate beat. A brass instrument plays a fill after the first two bars. The mood of this song is romantic. This song can be played in a romantic movie. | 2012-10-15T23:45:23Z | El Guapo | Musica Romantica | ["Swing music", "Music", "Music of Latin America"] | ["slow song", "pop song", "romantic mood", "male voice", "slow tempo", "tuba", "trumpets", "simple percussion"] | 0 | MeA8CSKAuvw | 2285 | |
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 |
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;