musiccaps_details (view)
5 rows where musiccaps_aspects contains "bad audio quality", musiccaps_aspects contains "live audience" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 72 ✖
- bad audio quality · 5 ✖
- live audience · 5 ✖
- passionate · 5 ✖
- exciting 4
- live performance 4
- enthusiastic 3
- instrumental music 3
- crowds cheering 2
- energetic 2
- groovy music 2
- medium tempo 2
- spirited 2
- adrenaline rush 1
- ambient crowd noise 1
- ambient crowd noises 1
- ambient room noises 1
- bach 1
- bagpipes playing 1
- baroque music 1
- carnatic music 1
- carnatic vocals 1
- celtic music 1
- concerto 1
- conductors 1
- crowds clapping 1
- cymbals crashing 1
- dance music 1
- disc scratching tones 1
- dj 1
- dj face off 1
- dj maestro 1
- drum playing percussively 1
- eerie tones 1
- engaging 1
- excitement 1
- exciting solo 1
- exorcism sounds 1
- female bagpiper 1
- g]adrenaline rush 1
- great composers 1
- groovy bass 1
- groovy bass line 1
- guitar rhythm 1
- harpsichord harmony 1
- indian classical music 1
- lifetime experience 1
- live elector 1
- mace 1
- male singer 1
- male vocalist 1
- medium fast tempo 1
- mridangam percussion 1
- no harmonies 1
- no other instrumentation 1
- no percussions 1
- opera hall 1
- performer 1
- retro dj music 1
- retro rock hits 1
- rhythm section 1
- rock drumming rhythm 1
- rock music 1
- rock singer 1
- royal dance 1
- singing long notes 1
- syncopated music 1
- tabla 1
- techno dance music 1
- two harpsichords 1
- victory march 1
- war cry 1
- western classical music 1
musiccaps_names (array) 14 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Julie Fowlis playing Bagpipe - Live | The song is an instrumental. The song is fast in tempo, with a bagpiper playing a Solo melody accompanied by a drum rhythm and people cheering and clapping wildly. The song is rousing in spirit and fervour. The song has a bad audio quality. | 2009-09-05T09:48:05Z | smartotrams | Live at Lüdenscheid, Germany 4th Sept 2009 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["female bagpiper", "bagpipes playing", "live performance", "live audience", "crowds clapping", "crowds cheering", "drum playing percussively", "exciting solo", "passionate", "celtic music", "war cry", "victory march", "bad audio quality", "ambient crowd noise", "performer", "instrumental music", "exciting", "energetic", "enthusiastic", "groovy bass", "rhythm section", "medium fast tempo"] | 1 | 0NTzOtVmoiU | 154 | |
DR.M.BALAMURALIKRISHNA - THILLANA | A male vocalist sings this traditional Carnatic vocals. The song is medium tempo with a violin accompaniment, tabla and mridangam playing percussion. The song is energetic and passionate and highlights the traditional Carnatic music art form. The audio quality is bad. | 2007-04-17T07:21:47Z | Musique4ever | Dr.M.Balamuralikrishna sings a thillana in Ahir Bhairav. | ["Singing", "Carnatic music", "Music", "Musical instrument", "Classical music", "Percussion"] | ["carnatic music", "male vocalist", "medium tempo", "tabla", "energetic", "passionate", "indian classical music", "bad audio quality", "live performance", "live audience", "passionate", "spirited", "exciting", "mridangam percussion", "carnatic vocals"] | 1 | Emc18GpAeRY | 1588 | |
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 | |
Bach: Concerto for 2 Harpsichords in C major, BWV 1061 (3/3) | The song is an instrumental. The tempo is medium fast with two harpsichordists playing an instrument harmony with no other instrumentation. The song is exciting like a dance but has a bad audio quality. | 2007-04-26T01:52:16Z | Ty Chan | J.S. Bach: Concerto for Two Harpsichords in C major, BWV 1061: 3. Fuga vivace Stephen Gamboa and Tyrone Chan, soloists U.C. Berkeley University Baroque Ensemble Spring 2007 Concert April 24, 2007 125 Morrison Hall | ["Harpsichord", "Keyboard (musical)", "Piano"] | ["two harpsichords", "bach", "concerto", "harpsichord harmony", "bad audio quality", "ambient room noises", "instrumental music", "western classical music", "opera hall", "great composers", "conductors", "live audience", "live elector", "mace", "engaging", "exciting", "passionate", "passionate", "baroque music", "instrumental music", "medium tempo", "royal dance", "no other instrumentation"] | 1 | spyBrs3relU | 4982 | |
1997 World ITF DJ Finals - Scratching Final - DJ Babu vs Tony Vegas | The song is an instrumental. The song is medium with a DJ creating scratchy tones by scratching vinyl on a turntable. The DJ creates an eerie and syncopated rhythm. The audio is bad quality. | 2012-12-14T20:20:54Z | DJ_Fobtronics | Babu as always, great on the cut. Tony Vegas, some nice stuff, but errors cost him. Mis calc'd the encode slightly, chopped the last 4 seconds. Classic Beat Juggling Final here: https://www.youtube.com/watch?v=ZYWhurwQajU | ["Scratching (performance technique)", "Music"] | ["disc scratching tones", "dj", "dance music", "retro dj music", "no harmonies", "exorcism sounds", "no percussions", "eerie tones", "dj maestro", "techno dance music", "instrumental music", "bad audio quality", "groovy music", "live performance", "exciting", "enthusiastic", "passionate", "dj face off", "live audience", "syncopated music"] | 1 | y4vtzCAPv84 | 5378 |
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;