musiccaps_details (view)
2 rows where musiccaps_aspects contains "boomy 808 bass", musiccaps_aspects contains "groovy" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pacificadores- Eu Sem Vc | The low quality recording features a hip hop song that consists of harmonizing male vocals, alongside background male vocals in the left channel and rough, repetitive male vocals in the right channel of the stereo image, singing over addictive synth lead melody, straight synth piano chords, boomy 808 bass and snaps. Right before the bass drops, there is a short snare roll. It sounds groovy and addictive, like something you would hear in clubs a lot. | 2008-10-07T11:53:27Z | BruuhBeyotch | Enjoy | ["Music", "Exciting music"] | ["hip hop", "harmonizing male vocals", "background male vocal", "rough repetitive male vocal", "addictive synth lead melody", "boomy 808 bass", "snaps", "snare roll", "straight synth piano chords", "groovy", "addictive", "club", "low quality"] | 4 | K-zkbbliQcI | 2051 | |
T-Pain - 5 O'Clock ft. Wiz Khalifa, Lily Allen | The Hip Hip song features an autotune male vocal, alongside harmonizing background vocals, singing over boomy 808 bass, snappy rimshots, synth pad chords, synth organ keys chords and tinny hi hats. It sounds groovy and addictive. | 2011-09-29T20:34:40Z | TPainVEVO | T-Pain's official music video for '5 O'Clock' ft. Lily Allen & Wiz Khalifa. Click to listen to T-Pain on Spotify: http://smarturl.it/TPainSpotify?IQid=TPain5clock As featured on T-Pain Presents Happy Hour: The Greatest Hits. Click to buy the track or album via iTunes: http://smarturl.it/TPainGHiTunes?IQid=TPain5clock Google Play: http://smarturl.it/TPain5Clockplay?IQid=TPain5clock Amazon: http://smarturl.it/TPainGHAmz?IQid=TPain5clock More from T-Pain I'm N Luv (Wit A Stripper): https://youtu.be/QjgZZGo881E I'm Sprung: https://youtu.be/rxRvDpF2FDA Take Your Shirt Off: https://youtu.be/eqSq2vz7CJI Follow T-Pain Website: http://www.t-pain.net/ Facebook: https://www.facebook.com/t-pain Twitter: https://twitter.com/tpain Instagram: https://instagram.com/tpain/ Subscribe to T-Pain on YouTube: http://smarturl.it/TPainSub?IQid=TPain5clock More great Hip Hop/Urban videos here: http://smarturl.it/HipHopUrban?IQid=TPain5clock --------- Lyrics: It's 5 o'clock in the morning Conversation got boring You said you're going to bed soon So I snuck off to your bedroom And I thought I'd just wait there (uh) Until I heard you come up the stairs (uhh) And I pretended I was sleeping (uhh) And I was hoping... It's 5 o'clock in the morning, and I want ya And you want me, don't ya? I can see it Cause you've been waiting on me since I said that I was hittin' the club Something coming up on me And I know you be getting so horny Cause you be sending me texts saying Like boy just get your ass up in that car And come get all of this love | ["Music of Africa", "Music"] | ["autotune male vocal", "harmonizing background vocals", "boomy 808 bass", "snappy rimshots", "synth pad chords", "synth organ keys chords", "hip hop", "groovy", "tinny hi hats", "addictive"] | 4 | noLrCDzAp5M | 4579 |
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;