musiccaps_details (view)
1 row where musiccaps_aspects contains "afrobeats", musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "uplifting" and musiccaps_names contains "Music of Africa"
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 |
---|---|---|---|---|---|---|---|---|---|---|
BUSY SIGNAL - REAL GENERAL (JUICY RIDDIM) SUPA HYPE 007-UPT [MARCH 2012] | The Afrobeats song features a flat male vocal, supported by male ad libs in the right channel of the stereo image, rapping over punchy kicks, muffled claps, syncopated snare hits and pulsating synth pad chords. At the very end of the loop there is a short snippet of groovy synth bass, as the section changes. It sounds lower in quality mainly because of the bad sound selection, as the instruments are too thin and too digital. | 2012-02-26T03:48:03Z | Krymefamily2 | BUSY SIGNAL - REAL GENERAL (JUICY RIDDIM) SUPA HYPE 007-UPT REMEMBER TO SUBSCRIBE FOR MORE GREAT MUSIC FB FAN PAGE http://www.facebook.com/pages/Latest-Dancehallreggae/286210691403190 FB FAN PAGE JAMAICALOVE876 http://www.facebook.com/jamaicalove876 POINTS TO NOTE: THIS VIDEO WAS NOT MADE COPYRIGHT INTENDED, IT WAS MADE TO PROMOTE MY CHANNEL AND THE ARTIST. SUBSCRIBE FOR MORE GREAT MUSIC FROM: MAVADO, CHASE CROSS, FLEXX, KIBAKI, AIDONIA, NAVINO, BOUNTY KILLER, IYARA, PATEXX, VYBZ KARTEL, MERITAL FAMILY, POPCAAN, BEENIE MAN, DOTTA COPPA, SHAWN STORM, DOZA MEDICINE, GAZA SLIM, GAZA INDU, SHEBA, KRYME FAMILY, TOMMY LEE AKA MOBAY "GAZA SPARTA", MAXWELL, DEVIN DI DAKTA, BOOKIE, KRYME FAMILY, CHRIS MARTIN, BLASS, LISA HYPER, SCHOOL BOY, DOGINAL, DEABLO, MILLA 9, LYRICAL MACHINE, NOTNICE, BADDA DAN, DJ NOTNICE, LEE MILLA, SINGER BLINGER, LISA HYPE, 21 BAD GYAL, BLAK RYNO, SHAWN STORM JAH VINCI J.O.P, AIDONIA, ALLIANCE, BOUNTY KILLER, MAVADO, GULLY, LIL WAYNE, SIZZLA, BIRD MAN, YOUNG MONEY, KHAGO, DJ KHALED, BENCIL, ACE HOOD, I-OCTANE, DRAKE, LISA HYPE, YOUNG JEZZY, TOMMY LEE, RICK ROSS, BABY TASH, USHER, KIPRICH, MERCILESS, TWIN OF TWINS, TONY MATTERHORN, MASIKA, BABY CHAM, ASSASSIN, NOTNICE RECORDS, CASHFLOW RECORDS, BIG SHIP RECORDS, UIM RECORDS, Sounique Records, blackspyda rec, PAYDAYMUSIC, Future World Production, STARKUTT RECORDS, ROMAIN VIRGO AND MORE. | ["Afrobeat", "Music of Africa", "Music", "Rapping", "Hip hop music"] | ["afrobeats", "flat male vocal", "male ad libs", "muffled claps", "punchy kick", "pulsating synth pad chords", "low quality", "uplifting", "synth bass", "syncopated snare"] | 4 | 8MKemM0h5mE | 916 |
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;