musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "enthusiastic" and musiccaps_aspects contains "rock music" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 37 ✖
- enthusiastic · 2 ✖
- passionate 2
- rock music · 2 ✖
- adrenaline rush 1
- ambient crowd noises 1
- bad audio quality 1
- boisterous 1
- crowds cheering 1
- cymbals crashing 1
- electric bass guitar 1
- electric guitar lead and harmony 1
- energetic 1
- energetic drumming 1
- enthusiastic vocal backup 1
- excitement 1
- g]adrenaline rush 1
- groovy bass line 1
- groovy music 1
- guitar rhythm 1
- hard rock 1
- heavy metal 1
- intense 1
- lifetime experience 1
- live audience 1
- live performance 1
- loud electric guitar feedback 1
- male singer 1
- male vocalist 1
- metal 1
- retro rock hits 1
- rock drumming rhythm 1
- rock singer 1
- singing long notes 1
- spirited 1
- vibrant 1
- voracious 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 2
- /t/dd00032 1
- Progressive rock 1
- Punk rock 1
- Rock music 1
- Singing 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Truth Be Told "Let It Go" Official Music Video | A male vocalist sings this vigorous Rock song. The tempo is fast with enthusiastic electric guitar lead and harmonies, electric bass guitar and hard hitting drumming with cymbal rides. The song is passionate, youthful, enthusiastic, intense, compelling, boisterous and vigorous. This song is a Hard Rock/Heavy Metal song. | 2012-10-04T18:11:26Z | TruthBeToldProject | Produced by: FlareSoul Entertainment Group Directed by Norberto Peña (http://www.npenaphoto.com) Truth Be Told www.Facebook.com/TruthBeToldProject Twitter: @TruthBeToldProj Official Release on iTunes, Spotify, AmazonMp3 on 10/25/12 Lyrics: A total change of mind A total change of life Its necessary to achieve these goals to reach, the desires of our heart. So much sacrifice Wasting money and time Left so many things behind Hope this is, Hope this is worth our while NO! We won't lose our faith, no we won't! So we let it go, let it go Fearless and committed Cause we gotta, go gotta go Find that place where we belong Losing all, winning all Find the purpose, of our, lives Hope this is worth our while Maybe loosing some friends so far from our loved ones Working hard Can't be left behind Using all, using all our might Giving what we are We put together all our strength Hope this is, Hope this is worth our while Be strong and courageous. Do not be frightened; do not be dismayed, for the Lord your God will be with you wherever you go So we let it go, let it go Cause we gotta, go gotta go Losing all, winning all Losing all, winning all All Rights Reserved by Truth Be Told --------------------------------------------------------------------- Additional Tags: Victory Records, Facedown Records, Tooth And Nail, Come & Live, Universal, Lyrics, Metal Blade, Road Runners, Indie, Post Punk, Post Hardcore | ["Music", "Punk rock", "Progressive rock", "/t/dd00032"] | ["male vocalist", "energetic drumming", "loud electric guitar feedback", "electric guitar lead and harmony", "enthusiastic vocal backup", "youthful", "enthusiastic", "energetic", "vibrant", "boisterous", "voracious", "intense", "passionate", "metal", "hard rock", "rock music", "heavy metal", "electric bass guitar"] | 7 | 3nbB3F-OdSM | 501 | |
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;