musiccaps_details (view)
4 rows where musiccaps_aspects contains "excitement" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 64 ✖
- excitement · 4 ✖
- passionate · 4 ✖
- bad audio quality 3
- adrenaline rush 2
- fast tempo 2
- groovy music 2
- male singer 2
- percussive bass line 2
- poor audio quality 2
- spirited 2
- abrupt ending 1
- ambient crowd noises 1
- arabic music 1
- arabic percussions 1
- arabic pop hits 1
- arabic retro hits 1
- arabic superstar 1
- beeping tones 1
- belly dancing 1
- crowds cheering 1
- cymbals crashing 1
- dance groove 1
- dance rhythm 1
- dance song 1
- death metal 1
- distorted guitar playing rhythm 1
- emo teens 1
- energetic 1
- enthusiastic 1
- fast metal drumming 1
- fats tempo 1
- g]adrenaline rush 1
- groovy bass line 1
- grunge keyboard tones 1
- guitar rhythm 1
- happiness 1
- head banging 1
- lifetime experience 1
- live audience 1
- live performance 1
- love songs 1
- male rapper 1
- male vocals 1
- medium tempo 1
- mosh pit 1
- movie soundtrack 1
- pain 1
- people dancing 1
- rap hits 1
- retro death metal 1
- retro rap hits 1
- retro rock hits 1
- rock drumming rhythm 1
- rock music 1
- rock singer 1
- romantic 1
- singing long notes 1
- song ending 1
- story telling 1
- stringed instruments 1
- strong drumming rhythm 1
- tambourine percussions 1
- traditional music 1
- youthful 1
musiccaps_names (array) 8 ✖
- Music 4
- Singing 2
- Angry music 1
- Middle Eastern music 1
- Music of Africa 1
- Rapping 1
- Rock music 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kai - Grind Low | A male rapper sings this exciting melody. The tempo is fast with a groovy bass line, grunge keyboard tones, strong drumming rhythm, various percussion hits and beeping tones. The song is pulsating and energetic. The audio quality is very poor. | 2008-03-06T13:46:34Z | kilickai | ["Music", "Rapping"] | ["male rapper", "poor audio quality", "beeping tones", "fast tempo", "people dancing", "retro rap hits", "tambourine percussions", "strong drumming rhythm", "percussive bass line", "story telling", "adrenaline rush", "passionate", "energetic", "excitement", "dance rhythm", "dance groove", "fats tempo", "poor audio quality", "rap hits", "grunge keyboard tones"] | 1 | 9STauy5DsC8 | 1009 | ||
COBHC = Omituisten Otusten Kerho | A male singer sings this death metal melody with screaming vocals. The tempo is fast, with fast metal drumming, percussive bass line, rhythmic distorted guitar play and various percussion hits. The song is exciting and high on adrenaline. The audio quality is poor. | 2007-04-02T23:01:04Z | Zooperstar | Fanvid about the weird guys from the band Children of Bodom... Yeah, I was bored! Music: Rölli - Omituisten Otusten Kerho, CoB - Hate Crew Deathroll Videoclips taken from the official Bodom EPs and DVDs | ["Music", "Angry music"] | ["death metal", "male vocals", "fast tempo", "mosh pit", "head banging", "poor audio quality", "song ending", "abrupt ending", "passionate", "youthful", "pain", "excitement", "happiness", "retro death metal", "bad audio quality", "emo teens", "fast metal drumming", "percussive bass line", "distorted guitar playing rhythm"] | 1 | OM04OFjNPGw | 2430 | |
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 | |
Chab Khaled " Had el Aïne âliha jite " ( 1er festival Raï Oran 1985 ) | A male Arab singer sings this cool melody. The tempo is medium with Arabic percussion instruments and various stringed instruments. The song is passionate and romantic. The song has bad audio quality. | 2008-12-18T19:26:24Z | Old Raï - Le Raï d'antan | Old Raï | ["Singing", "Music of Africa", "Music", "Middle Eastern music"] | ["male singer", "arabic music", "arabic percussions", "medium tempo", "groovy music", "dance song", "belly dancing", "traditional music", "arabic superstar", "movie soundtrack", "bad audio quality", "stringed instruments", "romantic", "passionate", "arabic retro hits", "arabic pop hits", "spirited", "excitement", "love songs"] | 1 | qIxpfaeZ-zs | 4775 |
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;