musiccaps_details (view)
4 rows where musiccaps_author = 4, musiccaps_names = "["Music of Africa", "Music"]" and musiccaps_names contains "Music of Africa"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Movado- Last Night | The low quality recording features a reggae song that consists of a fruity male vocal singing over shimmering hi hats, groovy bass, organ keys, chords, claps and male vocal chants. It sounds addictive, groovy and muddy, due to the poor quality of the mix. | 2007-07-18T18:57:07Z | Andone111 | Movado's Last Night on the Show Off Riddim. | ["Music of Africa", "Music"] | ["reggae", "male chants", "fruity male vocal", "shimmering hi hats", "groovy bass", "organ keys chords", "claps", "low quality", "muddy", "poor mix", "addictive", "groovy"] | 4 | 7pYavsK9sPg | 884 | |
Machel Montano - Congo Man - Trinidad Soca Music | The low quality recording features a Soca song that features repetitive flat male vocal singing over wide male background grunts, repetitive buzzy synth, punchy kick, syncopated snare and wooden percussion. It sounds energetic and uptempo. | 2008-02-11T04:33:47Z | rasadam | Download this MP3: https://amzn.to/2XJFxUy Artist: Machel Montano Title: Congo Man Album: Flame On Year: 2008 Genre: Soca Origin: Trinidad and Tobago | ["Music of Africa", "Music"] | ["low quality", "soca", "wooden percussions", "wide male grunts", "repetitive flat male vocal", "laughing", "repetitive buzzy synth", "punchy kick", "syncopated snare", "uptempo", "energetic"] | 4 | _GjHL0FkYoY | 3456 | |
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 | |
Nuego - xanw ton elegxo | The Urban Latin song features a harmonizing male vocals singing over "4 on the floor" kick pattern, shimmering hi hats, syncopated snare hits layered with simple synth lead melody and buzzy synth bass. It sounds energetic and addictive, like something you would hear in clubs. | 2008-09-23T13:47:11Z | Tony D | xanw ton elegxo - Nuego | ["Music of Africa", "Music"] | ["urban latin", "syncopated snare hits", "buzzy synth bass", "\"4 on the floor\" kick pattern", "simple synth lead melody", "shimmering hi hats", "energetic", "addictive", "harmonizing male vocals"] | 4 | w8c7JFU6by4 | 5243 |
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;