musiccaps_details (view)
4 rows where musiccaps_aspects contains "medium tempo", musiccaps_names = "["Music", "Rapping", "Hip hop music"]" and musiccaps_names contains "Hip hop 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 |
---|---|---|---|---|---|---|---|---|---|---|
R.A The Rugged Man - Midnight Thud | A male vocalist sings this passionate Rap. The tempo is medium with steady drumming, keyboard harmony, amplified piano accompaniment, and groovy bass lines . The song is emotional, intense, persuasive, intense and has a catchy groove. This song is contemporary Rap/Hip-Hop. | 2008-09-10T09:04:15Z | Markus Priebe Jakobsson | The song Midnight Thud by the rugged man, with lyrics. | ["Music", "Rapping", "Hip hop music"] | ["male vocalist", "medium tempo", "hip-hop", "rap", "rhythmic patter", "rhythmic speech", "slang", "objectionable lyrics", "passionate", "emotional", "intense", "emphatic", "persuasive", "catchy", "youthful", "steady drumming", "melody keyboard", "amplified piano", "groovy bass lines"] | 7 | CrbZHPkHeV4 | 1407 | |
Hurricane Chris "FREESTYLE" *51/50 RATCHET IN STORES NOW* | A male vocalist sings this passionate rap. The tempo is medium with keyboard harmony, slick drumming, funky bass lines , sound of chimes and synthesiser arrangements. The song is emotional, passionate, emphatic, persuasive, youthful, impactful and rhythmic chanting. The song is a contemporary Hip-Hop/RAo. | 2007-11-01T00:16:48Z | Hurricane Chris | CHECK OUT HURRICANE CHRIS KILL THE "WHITE GIRL" TRACK!!! MAKE SURE YOU POST THIS ON YOUR PAGE AND SEND IT TO FRIENDS!! 51/50 RATCHET IN STORES NOW!! | ["Music", "Rapping", "Hip hop music"] | ["male singer", "medium tempo", "synthesiser arrangements", "rhythmic chanting", "disco rap", "pop rap", "hip-hop", "rap", "punk rap", "gangsta rap", "electronic instruments", "steady drumming", "punchy bass", "intense", "amplified organ", "intense organ music", "sound of picture being clicked", "chimes", "digital drum rhythm", "persuasive", "emotional", "passionate", "story telling", "rhythmic patter"] | 7 | IEVVHo9nr7g | 1883 | |
Gunshot - ROCMA ( Feat. XEptional ) | A male rapper sings this groovy melody. The song is medium tempo with a steady drumming rhythm, groovy bass line, a melancholic flute countermelody, keyboard harmony and guitar accompaniment. The song is exciting and passionate. The song is a modern Russian rap song with a story telling nature. | 2014-04-05T21:46:22Z | Mehdi Rafale | Produced and Mixed by XEptional https://www.facebook.com/Gunshot.officiel https://www.facebook.com/thexeptionalpage | ["Music", "Rapping", "Hip hop music"] | ["male rapper", "russian rap music", "medium tempo", "purposeful", "inspiring", "underground music", "youthful", "discotheque", "hardship", "flute countermelody", "guitar accompaniment", "groovy bass line", "steady drumming rhythm", "steady drumming rhythm", "keyboard harmony", "poignant", "melancholic", "emotional", "russian hit songs", "euro pop", "groovy music", "dance music", "dance mix", "dance club", "people dancing", "passionate", "story telling"] | 1 | TakkuFZJsis | 2849 | |
Young Lex ft Iwa k - Ini Gaya Gue - Hip hop Indonesia 2013 | This song contains digital drums with percussive elements such as a cowbell and synth sounds used as short percussion in a higher pitch and also a high pitched voice sample. A male voice is rapping in a higher pitch. This song may be playing while driving in your car. | 2013-11-12T02:46:43Z | HiphopIndo TV | The first Indonesian Hiphop Movie - King of Rock City - Film Indonesia 2013 in BLITZ Megaplex 27 November 2013 single pertama untuk OST Film Hiphop Indonesia 2013 The First Single - Original Soundtrack for The First Indonesian Hiphop Movie title: Tak Sempurna International Title : King of Rock City More info: www.hiphopindo.net www.kingofrockcity.com Hiphopindo first Movie Indonesian Media info: Yahoo OMG http://t.co/BDq1ezro4T Hai Online http://t.co/pDqS45S8os Berita Satu http://t.co/QQcdDrbtMT Tribune News http://t.co/xVn76vRUqe Tabloid Bintang http://t.co/ZxD80glSMa Liputan 6 http://t.co/CpSPjRoxCV Cek n Ricek http://t.co/iQOyDln5Jz Lovely Today http://t.co/7Thsat4W27 Seleb BUzz http://t.co/AFwrftlkkA wowkeren http://t.co/b9LUK1bopu Plaza MSN http://t.co/Dw1fiX65xO Kapan Lagi.com http://t.co/buR5rxhbFK Merdeka.com http://t.co/wmDwMD93Nm Detik.com http://t.co/HQuK3FzaL8 Surabaya Post http://t.co/MhNEgKiVD3 Mens Journey http://t.co/TZdxDADJCD MovieGoers http://t.co/xi2kg5Pev7 Detik Hot http://t.co/oEU7T8BFHZ | ["Music", "Rapping", "Hip hop music"] | ["rap", "digital drums", "cowbell", "male voice rapping", "higher pitch", "voice sample", "high pitched", "melodic percussive sound", "medium tempo"] | 6 | nv1hWkBbG0g | 4589 |
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;