musiccaps_details (view)
6 rows where musiccaps_aspects contains "e-bass", musiccaps_aspects contains "male voice singing" and musiccaps_aspects contains "pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- e-bass · 6 ✖
- male voice singing · 6 ✖
- pop · 6 ✖
- acoustic drums 5
- acoustic guitar 4
- medium tempo 3
- e-piano 2
- higher pitch 2
- medium to uptempo 2
- amateur recording 1
- dance vibe 1
- drums 1
- e-guitar 1
- fast tempo 1
- funky 1
- happy 1
- higher key 1
- higher mid-register 1
- lagging video 1
- male backing vocals 1
- mandolin 1
- mid range 1
- mid-range 1
- piano 1
- saxophone 1
- synth sounds 1
- synth string sound 1
musiccaps_names (array) 6 ✖
- Music 6
- Independent music 2
- Christian music 1
- Music of Africa 1
- Ska 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jason Mraz - Sleep All Day | This song contains an acoustic drum and an e-bass playing along to someone strumming chords on an acoustic guitar. Panned to the right side of the speaker you can hear a mandolin playing a melody in a higher register. An e-piano is playing chords that are panned to the left side of the speakers. A male voice is singing at a higher pitch. This song may be playing when feeling happy. | 2008-07-28T11:41:46Z | Izabella Bella | (Lyrics) Jason Mraz - Sleep All Day His after moan though cries oh no He's building up a shine but he take it slow And he knows it's time to make a change here and time to get away And he knows it's time for all the wrong reasons and time to end the pain But he sleep all, sleep all day, sleep all, we sleep all day over Why don't we sleep all, sleep all day, sleep all, we sleep all day over She said what would your mother think and how would your father react Would he take it all back what they've done No way they said take it, take it and he said make it with your own two hands That was my old man and he said If all is grounded you should go make a mountain out of it Oh what a lovely day to have a slice of humble pie Oh Recalling of the while we used to drive and drive here and there Going nowhere but for us, nowhere but the two of us And we knew it was time to take a chance here And time to compromise our lives just a little while And it was time for all the wrong and lonely, lonesome reasons But time is often on my side but I give it to you tonight And we sleep all, sleep all day, sleep all, we sleep all day over Why don't we, sleep all, sleep all day, we sleep all day, we sleep all day over and over and over and over again And as time goes by we get a little bit tired waking and baked another Marlboro mile wide It's sending the boys on the run in the time in the hot summer sun To swim beneath or over outside till they're reading between the lines But they read none of the part in the hallmark card where they read about the dreams And reaching for the stars to hold on a little bit closer to Who said it was time, time to take, take love Time to take a chance here Time to compromise to occupy the lies And it was time for all the wrong reasons but time is often on my side but I give it to you, oh boy Sleep all, we sleep all day, sleep all, we sleep all day over so why don't we, sleep all, we sleep all day, sleep all, we sleep all day over and over She said what did … | ["Music", "Independent music"] | ["pop", "acoustic guitar", "mandolin", "e-piano", "acoustic drums", "e-bass", "male voice singing", "higher key", "medium tempo", "happy"] | 6 | 95ThRxhl-ug | 976 | |
Splendid - You Don't Understand | This song contains acoustic drums with a fat kick drum and a funky bassline. The acoustic guitar is strumming chords in the background being panned to the left side of the speaker while a e-guitar panned to the right side of the speaker is playing the lead melody strumming chords with a wah-wah pedal. A male backing voice is singing the same melody in a loop. The male lead voice is singing over the backing vocals. This song may be playing on a road trip. | 2007-10-23T20:56:12Z | splendidmusic | The long awaited all in the family happy happy sunshine videoclip for the Splendid track "You Don't Understand", taken from the 2006 album "Rebirth". iTunes: http://itunes.apple.com/nl/album/rebirth/id320728481 http://www.splendidmusic.nl Bookings: http://www.agentsafterall.nl | ["Music", "Ska"] | ["pop", "acoustic guitar", "e-guitar", "e-bass", "acoustic drums", "male voice singing", "mid-range", "male backing vocals", "medium tempo", "funky"] | 6 | Aw2ctwyhe28 | 1185 | |
"Crashing In Love" // The Cloud Room // Zither (2012) | Someone is playing a steady groove on the drums along with a simple bassline playing the footnote while a e-piano is playing minor chords panned to the right side of the speakers. Another distorted e-piano sound is playing a countermelody in a lower register panned more to the left side. A male voice is singing in the midrange. This song may be playing late night at a bar having a drink by yourself. | 2012-04-20T17:32:29Z | MrBrautigan | Seven years after "Hey Now Now," a song Rolling Stone picked as best of the year & Pitchfork featured for a week, The Cloud Room returns with the beautifully odd Zither. "Crashing In Love" is the first single. | ["Music", "Soul music"] | ["pop", "e-piano", "acoustic drums", "e-bass", "male voice singing", "higher mid-register", "medium to uptempo"] | 6 | IC_Wpalzzm8 | 1878 | |
Clear Static - Don't Say Forever | This song contains two different e-pianos playing melodies panned to the left and right side of the speakers. Two synthesizers are playing a tone that sounds like pulsating electricity and the other one a pad sound in a higher key. A e-bassline is playing together with the acoustic drum that is holding a steady groove without many changes. On top of that a male voice is singing in a higher key. This song may be playing while dancing. | 2012-11-13T03:26:31Z | *L.A.*KKXX* | ["Music", "Independent music"] | ["pop", "piano", "synth sounds", "e-bass", "male voice singing", "higher pitch", "acoustic drums", "fast tempo", "dance vibe"] | 6 | VzHL56yq8bI | 3050 | ||
Abrish Zegeyt - Idmaeyaen Bemulu | This song contains a male voice singing in the midrange while percussion instruments such a triangle and drums are playing a rhythm along with an e-bass. A baritone saxophone is playing a melody and someone is strumming chords and a melody on an acoustic guitar. This is an amateur recording. You can hear a high frequency tone from the recording and the sound is lagging. This song may be playing on the radio in a small village. | 2007-10-31T17:13:22Z | ahnd | ethiopian music | ["Music of Africa", "Music"] | ["pop", "amateur recording", "lagging video", "male voice singing", "mid range", "e-bass", "acoustic guitar", "saxophone", "drums", "medium tempo"] | 6 | pzpg2-jYu6k | 4748 | |
Shane & Shane - When I Think About The Lord | Someone is playing a kick on every beat along with little fill-ins on toms, cymbals and hihat. An e-bass is playing long notes along with an acoustic guitar finger picking chords while another guitar is playing higher pitched notes in a tremolo. A male voice is singing in a higher pitch sounding grateful. An atmospheric synth pad sound is rising in the background processed with a lot of reverb. This song may be playing with headphones enjoying a beautiful day. | 2008-05-08T21:47:53Z | monkeypop24 | another video, this time with the song when i think about the Lord by shane & shane... not ALL the pictures are repeated, like my other two vids, but some pics are the same as filled with Your glory and such... but thats cuz my movie maker thing or whatever kept freezing..piece of junk. anyway, if u see a pic that u saw in the other one, that's too bad for you~~!(jk) All pictures are found off Google Search. No copyright intended. LYRICS : When I think about the Lord How He saved me, How He raised me How He filled me With the Holy Ghost How He healed me To the uttermost. When I think about the Lord How He picked me up, Turned me around, How He set my feet On solid ground It makes me want to shout: Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! It makes me want to shout: Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! When I think about the Lord How He saved me, How He raised me How He filled me With the Holy Ghost How He healed me To the uttermost. When I think about the Lord How He picked me up, Turned me around, How He set my feet On solid ground And it makes me want to shout: Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! It makes me want to shout: Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! Hallelujah Thank You, Jesus Lord, You're worthy Of all the glory, And all the honor And all the praise... Yeahh Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! And all the praise! And all the praise! Yeahh | ["Christian music", "Music"] | ["pop", "acoustic guitar", "e-bass", "acoustic drums", "synth string sound", "male voice singing", "higher pitch", "medium to uptempo"] | 6 | tdTT6rmkk9M | 5054 |
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;