musiccaps_details (view)
5 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "male voice" and musiccaps_aspects contains "piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- bass · 5 ✖
- male voice · 5 ✖
- piano · 5 ✖
- moderate tempo 4
- percussion 2
- simple percussion 2
- backing voice 1
- backing voices 1
- brass section 1
- choir backing 1
- claves 1
- cover song 1
- dance song 1
- guitar 1
- happy mood 1
- happy song 1
- jazzy song 1
- keyboard music 1
- latin pop 1
- low quality audio 1
- pop rock song 1
- pop song 1
- romantic mood 1
- salsa song 1
- simple melody 1
- slow dance song 1
- slow rock 1
- synth sounds 1
- upbeat song 1
musiccaps_names (array) 14 ✖
- Music 4
- Salsa music 2
- Bass drum 1
- Country 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Jingle (music) 1
- Music of Africa 1
- Music of Latin America 1
- Percussion 1
- Rimshot 1
- Singing 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 |
---|---|---|---|---|---|---|---|---|---|---|
Orq. Bronco - Duena De Mi Cuerpo | This Latin pop song features a male voice singing the main melody. The voice sings at a high pitch. This is accompanied by Latin style percussion. A variety of percussion is used including the claves and cowbell. The bass plays a groovy bassline. The piano plays chords with a Latin feel. The brass section plays fills in between lines. This song has a romantic mood. This song can be played in a party for a slow dance. | 2010-03-26T03:09:29Z | EdwardMulenze | gran orquesta venezolana de finales de los 80.. se caracteriza por la finura y la cuerda de sus trombones disfrutenlo... | ["Music", "Music of Latin America", "Salsa music"] | ["latin pop", "male voice", "slow dance song", "bass", "percussion", "piano", "brass section", "romantic mood", "claves"] | 0 | 92QYLjfo68Q | 972 | |
Hotel California , Marc Anthony - Salsa Version | This salsa song features a male voice singing the main melody. This is accompanied by percussion playing a salsa beat. The piano plays a typical salsa rhythm using the main chords for the song. The bass plays the root note and fifth of the chord. Due to the low quality of the audio, other instruments are not audible. This is a cover song of another famous song. This song can be played for a salsa dance. | 2011-05-31T22:04:34Z | Saleh AL-Enizi - EL SENYOUR | On a dark desert highway, cool wind in my hair Warm smell of colitas, rising up through the air Up ahead in the distance, I saw a shimmering light My head grew heavy and my sight grew dim I had to stop for the night There she stood in the doorway; I heard the mission bell And I was thinking to myself, this could be heaven or this could be hell Then she lit up a candle and she showed me the way There were voices down the corridor, I thought I heard them say... Welcome to the hotel california Such a lovely place Such a lovely face Plenty of room at the hotel california Any time of year, you can find it here Her mind is tiffany-twisted, she got the mercedes bends She got a lot of pretty, pretty boys, that she calls friends How they dance in the courtyard, sweet summer sweat. Some dance to remember, some dance to forget So I called up the captain, please bring me my wine He said, we haven't had that spirit here since nineteen sixty nine And still those voices are calling from far away, Wake you up in the middle of the night Just to hear them say... Welcome to the hotel california Such a lovely place Such a lovely face They livin' it up at the hotel california What a nice surprise, bring your alibis Mirrors on the ceiling, The pink champagne on ice And she said 'we are all just prisoners here, of our own device' And in the master's chambers, They gathered for the feast The stab it with their steely knives, But they just can't kill the beast Last thing I remember, I was Running for the door I had to find the passage back To the place I was before 'relax,' said the night man, We are programmed to receive. You can checkout any time you like, But you can never leave! | ["Singing", "Music of Africa", "Music", "Salsa music"] | ["salsa song", "male voice", "piano", "bass", "low quality audio", "moderate tempo", "cover song", "dance song"] | 0 | D7z2Q-hH25s | 1441 | |
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 | |
Snow Patrol vs The Police - Every Car You Chase (Party Ben mash-up edit) | This slow rock song features a male voice singing the main melody. This is accompanied by other voices singing vocables in the background. The percussion plays a simple beat in common time. The bass plays the root notes of the chords. A synth plays a repetitive chord in staccato. A piano plays some high pitched notes in between lines. This song can be played in a movie scene at a harbour at night. | 2010-02-01T16:23:24Z | Mark Dale | Mash up mix featuring Snow Patrol's Chasing Cars and The Police classic Every Breath You Take. I did not mix this or take any credit for this track. Rights belong to the artists involved. Edit - Party Ben is the one who did this mash-up. You can download the full original mash-up (this version is an edit) directly from www.partyben.com | ["Country", "Music"] | ["slow rock", "male voice", "backing voices", "bass", "piano", "percussion", "simple melody", "moderate tempo", "synth sounds"] | 0 | mGU4ZRstxpY | 4458 | |
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;