musiccaps_details (view)
4 rows where musiccaps_aspects contains "e-piano" and musiccaps_aspects contains "male voice singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- e-piano · 4 ✖
- male voice singing · 4 ✖
- e-bass 3
- acoustic drums 2
- pop 2
- acoustic guitar 1
- amateur recording 1
- atmospheric 1
- giggling 1
- happy 1
- higher key 1
- higher mid-register 1
- keyboard sounds 1
- kids voices singing 1
- kidssong 1
- mandolin 1
- medium tempo 1
- medium to uptempo 1
- r&b/disco 1
- slow tempo 1
- synthesizer pads 1
- uptempo 1
musiccaps_names (array) 5 ✖
- Music 4
- Giggle 1
- Independent music 1
- Sidetone 1
- Soul music 1
youtube_published (date) 4 ✖
- 2008-07-28 1
- 2012-04-20 1
- 2012-09-21 1
- 2014-08-03 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Barney:Top 20 Countdown:Sound Number 2:Giggle Gaggle Wiggle | This song contains a male voice singing together with kids singing and giggling. A piano is playing a melody along with other keyboard sounds. This song may be playing in a kids tv-show. | 2014-08-03T17:55:12Z | amy arlington | ["Music", "Giggle"] | ["kidssong", "keyboard sounds", "e-piano", "kids voices singing", "e-bass", "male voice singing", "giggling", "amateur recording", "uptempo"] | 6 | 6UJhTZgnVro | 762 | ||
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 | |
"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 | |
Baby Prince feat. Lonely C - Nobody (Miguel Campbell Club Mix) | An e-piano is playing a melody and chords with a lot of tremolo while thin, airy synth pads are playing long evolving sounds. A male voice is singing in a higher register with effects on his voice. It sounds like a voice sample. This song may be playing in a club. | 2012-09-21T22:40:37Z | TheIoLoSo8 | Label: Somethinksounds (http://www.somethinksounds.com/) Release Date - 2012-09-24 Album "Nobody EP" available on: A1 Nobody ft Lonely C A2 He Doesn't Say It To Me B1 Nobody ft Lonely C (Miguel Cambell Club Mix) B1 Nobody ft Lonely C (Lucky Paul Remix) B3 Lucky Paul - Demon Spawn (Lonely C & Baby Prince Remix) - DIGITAL BONUS TRACK Buy Digital at - (http://somethinksounds.bandcamp.com/album/nobody-ep) (http://www.beatport.com/release/nobody/961739) Buy Vinyl at - (http://somethinksounds.bigcartel.com/product/nobody-ep) Stepping outside the realms of talent hothouse Wolf + Lamb and engaging in a rare bit of extraterritorial chemistry with bold boutique label somethinksounds, Gadi Mizrahi delivers his long-awaited solo material under the alias Baby Prince. The 'Nobody EP',featuring Lonely C and hot property Miguel Campbell and Lucky Paul on remix duty, carries the unmistakable hallmarks of Mizrahi's unique and kinky productions. Title track 'Nobody', co-produced with Lonely C (aka Efunk ambassador Charlie Levine of Soul Clap) is mellow and heavy with skittering cosmic beams and a deep distorted bassline under naked drums. Absorbed in a sound bed of fluid epic melodies, warm gliding synths and shimmering vocal cuts, 'Nobody' is a sonic bath for the senses. Stripping it back, solo track 'He Doesn't Say It To Me' soothes and thrills in equal measure as darkly seductive David Lynch-esque chords and steamy vocals burn through shuddering bass and dissonant FX. Miguel Campbell is the undisputed new prince of French touch disco house and has had the world at his feet since dancefloor gold 'Something Special' dropped last year. On the b-side, the Leeds wonder boy gives 'Nobody' a smoother, down-tempo disco sheen bringing more bounce to the bassline amidst sublime spaced out keys. Delivering a whole new interpretation with his 'Nobody' remix, New Zealand musician and label favourite Lucky Paul's lush percussive soundscape expands into an uplifting ceremony of subaquatic beats. Lucky Paul's 'Demon… | ["Music", "Sidetone"] | ["r&b/disco", "synthesizer pads", "e-piano", "male voice singing", "atmospheric", "slow tempo"] | 6 | jx27p7k2lSw | 4288 |
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;