musiccaps_details (view)
3 rows where musiccaps_aspects contains "ambient crowd noises" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 58 ✖
- ambient crowd noises · 3 ✖
- live performance · 3 ✖
- bad audio quality 2
- live audience 2
- male singer 2
- passionate 2
- spirited 2
- accordion player 1
- adrenaline rush 1
- adventurous 1
- amateur music 1
- crowds cheering 1
- cymbals crashing 1
- diva 1
- electric rhythm guitar playing 1
- emotional 1
- enthusiastic 1
- euro pop 1
- european folk song 1
- excitement 1
- exciting 1
- family reunion 1
- female guitarist 1
- folk singer 1
- g]adrenaline rush 1
- groovy bass line 1
- groovy music 1
- group singing 1
- guitar rhythm 1
- guitar solo 1
- hard rock 1
- home video 1
- instrumental music 1
- lifetime experience 1
- live concert video 1
- march rhythm drumming 1
- medium fast tempo 1
- medium fats tempo 1
- medium tempo 1
- memories 1
- people cheering 1
- people screaming 1
- percussive bass line 1
- poor audio quality 1
- poor audio recording 1
- retro rock hits 1
- rock band 1
- rock drumming 1
- rock drumming rhythm 1
- rock guitar solo 1
- rock music 1
- rock singer 1
- rom 1
- sentimental 1
- singing long notes 1
- social gathering 1
- testosterone driven 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music 2
- Yell 2
- Accordion 1
- Guitar 1
- Inside, large room or hall 1
- Pop music 1
- Rock music 1
- Singing 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Orianthi - Guitar Solo [singfest 3/8/10] | The song is an instrumental. The tempo is medium fast with a strong guitar lead, rock drumming rhythm, percussive bass line and an electric guitar strumming rhythm. The song is high on adrenaline and exciting. The audio quality is very bad with ambient crowd screaming noises. | 2010-08-05T15:37:54Z | Zahara Sulaiman | Orianthi performance during singfest in Singapore. | ["Guitar", "Music", "Pop music", "Whoop", "Yell", "Inside, large room or hall"] | ["live performance", "ambient crowd noises", "medium fast tempo", "live concert video", "home video", "poor audio recording", "testosterone driven", "female guitarist", "exciting", "youthful", "diva", "rock guitar solo", "adventurous", "people screaming", "guitar solo", "rock band", "instrumental music", "people cheering", "bad audio quality", "hard rock", "rock band", "medium fats tempo", "rock drumming", "percussive bass line", "electric rhythm guitar playing"] | 1 | G8iTuTi8ywU | 1694 | |
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 | |
Heligonka archiv Setkání v Lošticích 2007 | A male singer sings this emotional melody. The song is medium tempo with a steady drumming rhythm, accordion accompaniment and people singing together in unison. The song is emotional and sentimental. The song audio quality is poor. | 2011-05-09T16:37:53Z | Vrana1935 | ["Accordion"] | ["male singer", "accordion player", "family reunion", "social gathering", "euro pop", "group singing", "european folk song", "folk singer", "medium tempo", "march rhythm drumming", "live audience", "live performance", "ambient crowd noises", "poor audio quality", "amateur music", "emotional", "sentimental", "rom", "passionate", "spirited", "memories"] | 1 | r4JRDHYukZ4 | 4848 |
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;