musiccaps_details (view)
3 rows where musiccaps_aspects contains "guitar rhythm", musiccaps_aspects contains "passionate" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- guitar rhythm · 3 ✖
- passionate · 3 ✖
- bad audio quality 2
- love song 2
- male singer 2
- medium tempo 2
- romantic 2
- spirited 2
- adrenaline rush 1
- african rhythms 1
- ambient crowd noises 1
- average audio quality 1
- backup singers 1
- bollywood dance music 1
- crowds cheering 1
- cymbals crashing 1
- dance hits 1
- emotional 1
- energetic 1
- enthusiastic 1
- excitement 1
- female singers 1
- g]adrenaline rush 1
- groovy bass line 1
- groovy dance rhythm 1
- groovy drumming rhythm 1
- groovy music 1
- high pitched singing 1
- hindi pop music 1
- hindi pop song 1
- indian percussions 1
- keyboard accompaniment 1
- lifetime experience 1
- live audience 1
- live performance 1
- percussive bass line 1
- poor audio quality 1
- pop hits 1
- retro rock hits 1
- rock drumming rhythm 1
- rock music 1
- rock singer 1
- singing long notes 1
- strong bass line 1
- tambourine percussions 1
- telephone ringing 1
- various percussion hits 1
- vocal harmony 1
- xylophone 1
musiccaps_names (array) 8 ✖
- Music 3
- Singing · 3 ✖
- Hip hop music 1
- Maraca 1
- Pop music 1
- Rock music 1
- Telephone bell ringing 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Aye Hip Hopper - ishQ Bector ft Sunidhi Chauhan | Amruta Khanvilkar [OFFICIAL VIDEO] | A female singer sings this passionate melody. The song is a medium tempo with a groovy bass line , steady drumming, keyboard accompaniment, Indian percussion and tambourine accompaniment. The song is playful and romantic. The song is a modern Bollywood pop song with average quality audio. | 2009-12-26T23:05:57Z | ishQ Bector | Starring: IshQ Bector & Amruta Khanvilkar Produced by Sykz Total Fitness Directed by: WildKumar Music: Hanif Shaikh + Chirantan Bhatt Song Produced by IshQ Bector, Chirantan Bhatt & Hanif Shaikh Lyrics: IshQ Bector, Nitin Gupta, Amitabh Bhattachariya, Chirantan Bhatt, & Hanif Shaikh Recorded at the House of IshQ "Aye Hip-Hopper"(Album- Dakku Daddy), is an epic love story between a star Hip-Hopper and his bai (maid)! Will this hot bai be able to sweep IshQ off his feet? ---------------------------------------- ---- Naashta tayaar hai sir. Aur kuch chahiye? Bolo to mein? Yeah. Just gimme some Hip-Hop! Aye Hip-Hopper mujhe pyar to kar Aye Hip-Hopper Mere pyar ke dariya mein, mere laoo (love) ke dariya mein Ek dubki lo na sir! Aye Hip-Hopper! Kya tu bak rahi hai? Aise tak rahi hai Khopdi pak rahi hai Ruk Ruk Ruk Ruk Bakshish bhi diya aur, Bonus bhi diya aur, Chahiye tujko kya? Chal! Phut. Phut. Phut. Phut. Tere ghar me bartan shartan maanjti hun mein barabar. Tu kabhie tho mere dil ke ghar mein pocha kar de aa kar. God she thinks she's hot like Rekha, Maybe but she's not my flavour. Loving her is too much labour. Labour. L-Labour. How can I? I'm a star Hip-Hopper. She's my bai just a part time naukar. Aye aye bhai gotta be high to rock her. Rock her. Rock her. Just gimme some Hip-Hop! Aye Hip-Hopper mujhe pyar to kar Aye Hip-Hopper Mere pyar ke rickshaw ko, mere love ke rickshaw ko. Ek dhakaa do na sir! Aye Hip-Hopper! Ish! Sir.. lo na.. phone.. Meri girlfriend aa rahi hai. Tu kab jah rahi hai? Kyun sataa rahi hai? Ruk Ruk Ruk Ruk Us ko pata joh. Chale to hoga voh. Socha na hoga joh. Phut. Phut. Phut. Phut. Tujko har din khana-vana main khilaati hun pakaa kar. Aaj mere dil ke tave pe, rotiyan tu sekle aa kar. There's no bai I know quite like her. If my girl finds out she'll strike her. But she's the bomb! Dam I wanna light her. Light her. L- Light her. Lock the door bend down lets do it. Mop the floor turn around lets do it. All the bais cook it up get to it. To it. To it. Just gimme some … | ["Singing", "Music", "Telephone bell ringing", "Hip hop music"] | ["telephone ringing", "hindi pop music", "medium tempo", "indian percussions", "tambourine percussions", "female singers", "romantic", "love song", "hindi pop song", "guitar rhythm", "strong bass line", "energetic", "passionate", "bollywood dance music", "average audio quality", "keyboard accompaniment"] | 1 | DCFrCX4HPO8 | 1452 | |
Kwabena Kwabena - Odo Nkoa (Feat. Kofi B) | A male singer sings this passionately with backup singers in vocal harmony. The song is medium tempo with a steady drumming rhythm, various percussion, percussive bass line, guitar rhythm and keyboard harmony . The song is passionate and romantic with a cool dance groove. The song has poor audio quality. | 2011-04-03T16:51:56Z | NaaKwame | Kwabena Kwabena - Odo Nkoa (Feat. Kofi B) Album: Dabi | ["Singing", "Music", "Pop music", "Maraca"] | ["male singer", "backup singers", "african rhythms", "poor audio quality", "guitar rhythm", "xylophone", "vocal harmony", "groovy drumming rhythm", "percussive bass line", "various percussion hits", "medium tempo", "groovy dance rhythm", "pop hits", "dance hits", "love song", "passionate", "emotional", "spirited", "bad audio quality", "high pitched singing", "romantic"] | 1 | IPO79GrOYjg | 1904 | |
Los Mejores Gritos de Axl Rose/Best Cries Of Axl Rose [El Mejor Grito De La Historia] | A male rock singer sings this climatic solo with a long sustained note. The tempo is medium with strong rock drumming, guitar rhythm; guitar lead and a percussive bass line. The song is hard rock with a lot of spirit and excitement. The audio quality is bad with a lot of ambient crowd noises. | 2013-01-27T02:36:43Z | M. Adonis Ortiz | Like Please: http://www.facebook.com/ILoveGunsNRoses1 Únete/Me Gusta Por Favor: http://www.facebook.com/ILoveGunsNRoses1 Lista de gritos de Axl Rose LIVE. Una maravilla de 4 octavas: Axl Rose. Un bajo-barítono que se empuja hacia la 5ª octava. Algunos dicen que Axl suena como una guitarra, y tiene razón! No es un cantante melódico pero hace el trabajo! 01.El pasaje grave hacia el final de ¨Sweet child o' mine¨, la nota más baja es F#2. 02.La armonía grave en el comienzo de ¨Paradise City¨, también F#2. 03.Un sólido D#2 en ¨You ain´t the first¨. 04.La versión en vivo tiene dos D#2 :s. 05.C#2 desde ¨Shackler´s revenge¨ en Chinese Democracy (Que bueno que Axl Por fin lo terminó). 06.Puede Axl bajar más? El está hablando en la parte inferior de su segunda octava acá y canta un C#2 (una vez más) al final del Rockumental de MTV. 07.Axl se desliza hacia abajo para un C2 tambaleante, pero sostenido, al final de ¨Ain´t going down¨ (demo). 08.Un lindo B1 de ¨Don´t cry¨. 09.El B1 también está en esta conocida canción, ¨November rain¨ (¿Voz de fritura?) 10.Esto también suena como B1, una armonía baja (separada de la voz principal) de ¨There was a time¨. 11.La nota más baja de Axl, A1, de ¨Get in the ring con un A2¨. La armonia tiene una línea en B1, una línea en D2, una en A1 y una línea más en B1, luego las repite. 12.Hora de ir hacia arriba. Un C#5 de ¨Paradise City¨. 13.El final clásico de ¨Sweet Child o' mine¨ donde Axl toca D#5 varias veces :s y también un corto E5. 14.D#5 con trinos de ¨Welcome to the jungle¨. 15.Un D#5 de ¨Anything goes¨. 16.F5 de ¨You could be mine¨. 17.Misma nota, pero en vivo. 18.Cantando hasta F#5! y luego manteniendo esa nota, en ¨There was a time¨. Su nota más alta cantada, esto debe ser duro para él en los conciertos. 19.Gran F#5 de ¨I.R.S¨. 20.Un G5 de una versión en vivo de ¨Welcome to the jungle¨. 21.G5 en ¨Chinese democracy¨. 22.Linda cadenza hasta G#5 de ¨Scraped¨ con una armonía de C#2 abajo. 23.Manteniendo un G#5 junto con Sebastian Bach (que tenía y tiene excelent… | ["Singing", "Music", "Rock music", "Yell"] | ["live performance", "bad audio quality", "singing long notes", "rock singer", "male singer", "crowds cheering", "rock music", "rock drumming rhythm", "cymbals crashing", "live audience", "ambient crowd noises", "groovy bass line", "guitar rhythm", "g]adrenaline rush", "lifetime experience", "groovy music", "excitement", "enthusiastic", "adrenaline rush", "passionate", "spirited", "retro rock hits"] | 1 | pHC25Ia8Dxo | 4694 |
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;