musiccaps_details (view)
3 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "boomy 808 bass" and musiccaps_aspects contains "hip hop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- addictive · 3 ✖
- boomy 808 bass · 3 ✖
- hip hop · 3 ✖
- groovy 2
- low quality 2
- addictive synth lead melody 1
- autotune male vocal 1
- background male vocal 1
- claps 1
- club 1
- energetic 1
- exciting 1
- harmonizing background vocals 1
- harmonizing male vocals 1
- punchy kick 1
- rough repetitive male vocal 1
- shimmering hi hats 1
- siren sound effect 1
- snappy rimshots 1
- snaps 1
- snare roll 1
- straight synth piano chords 1
- synth lead melody 1
- synth organ keys chords 1
- synth pad chords 1
- tinny hi hats 1
- wide reverberant flat male vocal 1
musiccaps_names (array) 5 ✖
- Music 3
- Exciting music 1
- Hip hop music 1
- Music of Africa 1
- Rapping 1
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 | |
Roy Jones Jr - I Smoke I Drank | The low quality recording features a hip hop song that consists of a wide reverberant flat male vocal rapping over synth lead melody, sire sound effects, punchy kick, boomy 808 bass, claps and shimmering hi hats. It sounds exciting, energetic and addictive - like something you would hear in clubs. | 2008-10-03T14:48:46Z | Body Head Entertainment Films | Roy Jones Jr, Youngbloods and Body Head Bangerz | ["Music", "Rapping", "Hip hop music"] | ["low quality", "hip hop", "synth lead melody", "siren sound effect", "punchy kick", "boomy 808 bass", "claps", "shimmering hi hats", "wide reverberant flat male vocal", "energetic", "exciting", "addictive"] | 4 | RmDfwz0OG8E | 2723 | |
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;