musiccaps_details (view)
7 rows where musiccaps_aspects contains "acoustic piano" and musiccaps_aspects contains "pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- acoustic piano · 7 ✖
- pop · 7 ✖
- female voice singing 4
- acoustic guitar 2
- e-bass 2
- male voice singing 2
- medium to uptempo 2
- melancholic 2
- string section 2
- uptempo 2
- acoustic drums 1
- amateur recording 1
- background noises 1
- cajon 1
- crowd sheering 1
- deep 1
- electric piano 1
- flute 1
- horn 1
- low percussive hit 1
- mid-range voice 1
- reverb 1
- saxophone 1
- sensitive 1
- sensual 1
- slow tempo 1
- slower to medium tempo 1
- string-section 1
- strings 1
- tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kate Nauta "Photograph" Music Video | This song contains an acoustic piano playing a minor chord composition with some soft strings in the background playing in a higher key. An e-bass is playing the footnote of the piano. A female voice is singing loud and clear with a voice that sounds melancholic/sad. This song may be playing with headphones while feeling sad. | 2009-09-05T22:17:30Z | mduriandp1 | Kate Nauta - "Photograph" Music Video, Director: Marcos Durian, Video Producer: Cynthia Shreves | ["Music", "Sad music"] | ["pop", "acoustic piano", "strings", "e-bass", "female voice singing", "melancholic", "slower to medium tempo"] | 6 | 16F5fdORzSo | 237 | |
Coldplay - Hurts like Heaven (cover) | This audio contains someone playing an acoustic piano along with an acoustic guitar strumming chords. Someone is playing a cajon with a fast paced groove and a tambourine. A horn takes the main melody in the midrange along with a male voice singing in a higher key. This song may be playing on the streets performed by buskers. | 2012-02-10T14:22:31Z | Retalianist | Here's our latest cover, this time it's Hurts like Heaven by Coldplay and we brought the brass! It was rehearsed and shot in a couple of hours. Singing is too low but... enjoy anyway! Sheet Music : http://on.fb.me/13Y9f2G Shot and directed by Charlotte Audureau http://www.shuud.book.fr/ With Romain Olivieri, Nicolas Molac, Edward Vizard, Clément Charpentier-Leroy, Gautier Demollière and Pierre Lesmarie http://www.weareelessar.com http://www.myspace.com/astrazz | ["Brass instrument", "French horn"] | ["pop", "acoustic piano", "cajon", "horn", "acoustic guitar", "male voice singing", "tambourine", "uptempo"] | 6 | QDTCAxyXt80 | 2605 | |
Lana Del Rey - Terrence Loves You (Official Audio) | The song sounds orchestrated. There is a string section playing swells and rising tremolos along to an acoustic piano playing minor chords. A cello is playing long low notes on top of that a saxophone is playing two notes to end the phrase. A deep and far percussive hit comes in every fourth count. The female singer's voice sounds sensitive and melancholic. There are female backing voices singing along. The whole composition is full of big reverb. This song may be playing at the end of a sad movie. | 2015-08-21T07:00:00Z | LanaDelReyVEVO | Lana Del Rey - Terrence Loves You (Official Audio) Sign up for updates: http://smarturl.it/LanaDelRey.News Follow Lana Del Rey: http://www.instagram.com/lanadelrey http://www.facebook.com/lanadelrey http://www.twitter.com/lanadelrey http://lanadelrey.tumblr.com http://www.lanadelrey.com Lana Del Rey - Terrence Loves You (Lyrics) You are what you are I don't matter to anyone But Hollywood legends Will never grow old And all of what's hidden Well, it will never grow cold But I lost myself when I lost you But I still got jazz when I've got those blues And I lost myself when I lost you And I still get trashed, darling, when I hear your tunes But you are who you are I won't change you for anything For when you are crazy I'll let you be bad I'll never dare change thee To what you are not But I lost myself when I lost you But I still got jazz when I've got those blues I lost myself and I lost you too And I still get trashed, baby, when I hear your tunes I put the radio on, hold you tight in my mind Isn’t strange that you’re not here with me I’m putting all the lights on and the television Trying to transmit, can you hear me? Ground control to Major Tom Can you hear me all night long? Ground control to Major Tom Well, I lost myself when I lost you But I still got jazz when I've got the blues I lost myself and I lost you too And I still get trashed, honey, when I hear your tunes Mmmm-mmm-mmm-mmm Mmmm-mmm-mmm-mmm Mmmm Mmmm-mmm-mmm-mmm Mmmm | ["Music", "Synthetic singing"] | ["pop", "string section", "female voice singing", "reverb", "acoustic piano", "deep", "low percussive hit", "saxophone", "slow tempo", "melancholic"] | 6 | emDU4QvdwVk | 3896 | |
Mlp lullaby for a princess { PMV } | A female voice is singing, sounding sensual while an acoustic piano is playing a ballad with a change in keys and strings being played with long strokes. The song sounds sensual and dramatic. You can hear some clicking sounds in the recording. This song may be played at a karaoke bar. This song seems to be an amateur recording. | 2013-06-12T17:32:53Z | Mlp MultiLanguage | Music is not by Me | ["Music", "Lullaby"] | ["pop", "acoustic piano", "female voice singing", "sensual", "string-section"] | 6 | f3l6KnC8930 | 3918 | |
Lady Gaga - Telephone (Piano Cover) Music Video | This audio contains someone playing a modern piece of music on an acoustic piano. This song may be playing live in a bar with a piano. | 2010-01-16T22:32:30Z | Iwillbot | telephone lady gaga music video / telephone lady gaga piano cover / telephone lady gaga acoustic version / me playing telephone lady gaga / telephone lady gaga official music video / telephone lady gaga official lyrics / telephone lady gaga mp3 download link / telephone lady gaga studio version / telephone lady gaga live performance / telephone lady gaga chipmunk version / telephone lady gaga played by Iwillbot / telephone lady gaga piano tutorial / how to play telephone lady gaga / Not sure you can find sheet music for this Mp3 also! http://iwillbot.blogspot.com/ Personal Account + Piano Lessons http://www.youtube.com/WillTingMusic Sheet Music Links on Blog+Myspace http://iwillbot.blogspot.com/ http://www.myspace.com/iwillbot http://www.twitter.com/iwillbot | ["Blues", "Music"] | ["amateur recording", "pop", "acoustic piano", "uptempo"] | 6 | jBmP7xTI_TA | 4241 | |
Teri Aahatein-Full Original Video Song-Ek Mein Aur Ekk Tu ft Imran Khan Kareena Kapoor | An acoustic piano is playing a melody along with a flute-sound and an acoustic guitar picking two notes repeatedly. Then the song breaks softly into a new part as the acoustic guitar and piano are fading out. In the background you can hear some insects chirping. Now an electric piano sound is playing a melody along with a male voice singing. His voice sounds sensitive. This song may be playing for a movie scene. | 2012-01-14T08:17:35Z | rfication rakesh | Ek Mein Aur Ekk Tu songs 2012 Teri Aahatein kareena Kapoor Imran Khan new bollywood songs 2012 2011 movies trailers karan johar | ["Singing", "Music", "Sad music"] | ["pop", "acoustic piano", "flute", "acoustic guitar", "electric piano", "male voice singing", "mid-range voice", "sensitive", "medium to uptempo", "background noises"] | 6 | lmrzR9cSMRY | 4419 | |
[HQ] TELEPHONE live! by Lady Gaga & Beyonce feat. Sarah Geronimo | An e-bass and strings are playing a simple melody to elevate the atmosphere. In the background an acoustic piano is playing a melody along with the drums. Then a female voice starts singing while the crowd starts cheering. This song may be playing live during a tv-show. | 2010-07-19T13:18:56Z | jsv07 | [HQ] TELEPHONE live! by Lady Gaga & Beyonce performed by: Sarah Geronimo | ["Music of Asia", "Music", "Pop music", "Rock and roll"] | ["pop", "string section", "acoustic piano", "e-bass", "acoustic drums", "female voice singing", "crowd sheering", "medium to uptempo"] | 6 | vYP60jdTupc | 5190 |
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;