musiccaps_details (view)
6 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "moderate tempo" and musiccaps_aspects contains "pop song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- bass · 6 ✖
- moderate tempo · 6 ✖
- pop song · 6 ✖
- male voice 4
- happy mood 3
- percussion 3
- backing voices 2
- dance song 2
- piano 2
- bollywood song 1
- children's voices 1
- choir backing 1
- christmas song 1
- club song 1
- duet 1
- female backing voice 1
- female voice 1
- guitar 1
- happy song 1
- holiday theme 1
- instrumental 1
- jazzy song 1
- keyboard music 1
- low quality audio 1
- male backing voice 1
- no voices 1
- programmed percussion 1
- relaxing song 1
- repetitive melody 1
- ride cymbal 1
- romantic theme 1
- simple percussion 1
- slow rock song 1
- strings 1
- synth 1
- synth music 1
- synth sounds 1
- tabla 1
- trumpet 1
musiccaps_names (array) 10 ✖
- Music 5
- Singing 2
- Christian music 1
- Christmas music 1
- Funk 1
- Happy music 1
- Jingle (music) 1
- Music of Asia 1
- Rhythm and blues 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SUPERSCI - Get! (Feat. Remedeeh) (Official Video) | This pop song features a female voice singing the main melody. This is accompanied by male and female backing voices. The voices sing a repetitive melody. This is accompanied by percussion playing a simple beat. Trumpets play a backing melody. The bass plays a groovy descending bassline. The mood of this song is happy. This song can be played at a club. | 2006-06-07T17:33:35Z | Supersci Flyphonic | Swedish hip hop at its finest with a sweet summer vibe. Supersci's first video from the 2006 album "Pinetrees on the Pavement". Shot around the Sundsvall area using super-8 film. Video directed by Måns Berthas. Music produced by Flyphonic Beats. Lyrics by Mr Noun, Arka and Remedeeh. www.flyphonic.com/supersci | ["Funk", "Music"] | ["pop song", "female voice", "male backing voice", "female backing voice", "percussion", "trumpet", "bass", "moderate tempo", "dance song", "repetitive melody", "happy mood"] | 0 | EtmKuWPpjG0 | 1598 | |
Lucy & Sam// Strawberry fields forever | This low quality audio features a male voice singing the main melody. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. Strings play staccato notes in the background and at the end of the bar, the notes are allowed to ring. A synth plays chords using an organ voice. This voice plays chords in the background. At the end, the synth plays the sound of two bells playing a descending sequence. This song can be played in a romantic movie. | 2010-05-19T16:57:04Z | DakotaDuff92 | ["Rhythm and blues", "Zing"] | ["low quality audio", "percussion", "bass", "male voice", "pop song", "strings", "synth sounds", "moderate tempo", "romantic theme"] | 0 | HkCYA4ax4jI | 1830 | ||
This Is Christmas (Christmas 2013 ) Paul Martin Feat Shauna Gallon | This pop song features a male and female voice singing the main melody. There are backing voices singing fills in between lines. Children sing in the background. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. A synth plays a pedal chord in staccato. This song can be played at the end credits of a holiday movie. | 2009-10-07T15:44:15Z | Chris tmasMusic | One of the Finest Christmas songs still yet to Make It. Please Share this song written & performed by one of worlds finest Christmas Crooners Paul Martin aka Mr Success featuring future star Shauna Gallon & a cast of family & friends shot in Newcastle upon Tyne in 2009. www.franksinatratributesinger.co.uk | ["Christmas music", "Singing", "Christian music", "Music"] | ["pop song", "holiday theme", "duet", "male voice", "children's voices", "christmas song", "percussion", "bass", "synth", "happy mood", "moderate tempo", "backing voices"] | 0 | ODOrls3MuZI | 2411 | |
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 | |
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 | |
Koi Kahe Kehta Rahe Full Song | Dil Chahta Hai | Aamir Khan, Akshaye Khanna, Saif Ali Khan | This pop song features a male voice singing the main melody. Other voices sing backing vocals using the same melody. This is accompanied by programmed percussion playing a dance beat. A wave synth plays a repetitive melody. The bass plays the root notes of the chords. Toward the end of the song, a tabla is played. The mood of this song is happy. This song can be played in a club as a dance song. | 2011-05-25T01:24:21Z | T-Series | Song - Koi Kahe Kehta Rahe Film - Dil Chahta Hai Singer - Shankar Mahadevan, Shaan, K K Lyricist - Javed Akhtar Music Director - Shanker, Ehsaan, Loy Artist - Aamir Khan, Akshaye Khanna, Saif Ali Khan Music On - T-Series | ["Singing", "Music of Asia", "Music"] | ["pop song", "bollywood song", "male voice", "backing voices", "dance song", "synth music", "programmed percussion", "bass", "club song", "tabla", "moderate tempo", "happy mood"] | 0 | ctJI7pCbxAo | 3751 |
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;