musiccaps_details (view)
12 rows where musiccaps_aspects contains "cymbals crashing" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 141 ✖
- cymbals crashing · 12 ✖
- passionate · 12 ✖
- spirited 7
- emotional 6
- romantic 6
- bad audio quality 5
- instrumental music 5
- percussive bass line 5
- exciting 4
- groovy rhythm 4
- guitar rhythm 4
- male singer 4
- adrenaline rush 3
- fast tempo 3
- groovy bass line 3
- keyboard accompaniment 3
- medium tempo 3
- poor audio quality 3
- rock band 3
- steady drumming rhythm 3
- adventurous 2
- backup singers 2
- distorted guitar rhythm 2
- drum rolls 2
- energetic 2
- female singer 2
- guitar playing lead 2
- love song 2
- retro hits 2
- retro pop hits 2
- retro rock hits 2
- tambourine percussions 2
- vocal harmony 2
- youthful 2
- amateur music mix 1
- ambient crowd noise 1
- ambient crowd noises 1
- amplifier 1
- average audio quality 1
- backing track 1
- backups singers 1
- bass master class 1
- brass instruments harmony 1
- cheerful 1
- child singer 1
- choppy music 1
- choral harmony 1
- church organ 1
- classic rock band 1
- country music 1
- couples slow dancing 1
- cowboys 1
- crooning 1
- crowds cheering 1
- cumbria rhythm 1
- dance music 1
- death metal music 1
- disco music 1
- disco romance hits 1
- disconcerting music 1
- distorted guitar 1
- dj 1
- drum track 1
- enthusiastic 1
- excitement 1
- experimental 1
- falsetto 1
- fast metal drumming 1
- funk rock 1
- g]adrenaline rush 1
- gain issues 1
- great adventure 1
- groovy 1
- groovy bas slime 1
- groovy music 1
- guitar accompaniment 1
- guitar demo 1
- guitar effects pedal 1
- guitar lead 1
- guitar playing rhythm 1
- head banging 1
- heavy metal music 1
- high in adrenaline 1
- improvisational 1
- inspiring 1
- latin brass band 1
- latin country music 1
- latin folk music 1
- latin music 1
- latin percussions 1
- latin rhythm 1
- lifetime experience 1
- live audience 1
- live performance 1
- make singer 1
- marry me 1
- medium fast tempo 1
- mismatched tempos 1
- mosh pit 1
- movie themes 1
- organ accompaniment 1
- people dancing 1
- people talking 1
- piano accompaniment 1
- pop song 1
- pop superhit 1
- quick slap bass inquest 1
- rebellious 1
- remix 1
- retro classics 1
- retro death metal hits 1
- retro pop song 1
- retro rock and roll 1
- rock and roll music 1
- rock drumming 1
- rock drumming rhythm 1
- rock music 1
- rock singer 1
- school concert 1
- singing long notes 1
- slap bass 1
- slow tempo 1
- slowing down 1
- song ending 1
- song fade 1
- song retarding 1
- steady bass line 1
- steady drumming 1
- steady rock drumming 1
- strong rock drumming 1
- swing music 1
- tambourine percussion 1
- technique video 1
- together forever 1
- traditional 1
- trumpets blaring 1
- vintage hits 1
- vintage pop 1
- vocal duet 1
- yodelling music 1
- youtube music video 1
musiccaps_names (array) 27 ✖
- Music 11
- Rock music 6
- Independent music 3
- Singing 3
- Angry music 2
- Grunge 2
- Heavy metal 2
- Musical instrument 2
- Bass guitar 1
- Electric piano 1
- Electronic organ 1
- Guitar 1
- Hammond organ 1
- Keyboard (musical) 1
- Maraca 1
- Organ 1
- Piano 1
- Plucked string instrument 1
- Pop music 1
- Progressive rock 1
- Psychedelic rock 1
- Punk rock 1
- Rock and roll 1
- Roll 1
- Soul music 1
- Vocal 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 |
---|---|---|---|---|---|---|---|---|---|---|
Sebastien De La Cruz, EL CHARRO DE ORO, EL PASTOR | A child singer sings this passionate Latin melody. The song is slow tempo with steady drumming, tambourine percussions, a strong bass line and brass instruments playing countermelody. The song is spirited and passionate. The song has poor audio quality and has ambient crowd noises. | 2009-12-04T04:56:07Z | Juan De La Cruz | MARIACHI VARGAS EXTRAVAGANZA 2009 EL PASTOR, 7YR OLD WOW, THIRD PLACE VOCAL FINALIST | ["Singing", "Music", "Musical instrument", "Vocal music"] | ["child singer", "latin music", "ambient crowd noise", "steady bass line", "cymbals crashing", "people talking", "trumpets blaring", "school concert", "latin folk music", "latin folk music", "traditional", "cowboys", "latin country music", "yodelling music", "spirited", "passionate", "romantic", "emotional", "brass instruments harmony", "slow tempo", "latin brass band"] | 1 | 6C0HoQe4Y-Y | 734 | |
d85 yamaha organ solo one man band | The song is an instrumental. The tempo is medium with a church organ playing melody, steady drumming rhythm, cymbals crashing, tambourine percussion, steady bass, and guitar playing rhythm. The song is exciting and retro nostalgia. The audio quality is poor. | 2009-02-01T04:39:30Z | fathau | one man band | ["Organ", "Electric piano", "Hammond organ", "Electronic organ", "Keyboard (musical)", "Piano"] | ["church organ", "country music", "backing track", "medium tempo", "instrumental music", "tambourine percussion", "cymbals crashing", "guitar rhythm", "organ accompaniment", "vintage hits", "bad audio quality", "gain issues", "exciting", "adventurous", "retro classics", "passionate", "great adventure", "romantic", "movie themes", "vintage pop"] | 1 | A_Yd5huF2Pg | 1136 | |
Happy Version cumbia - Pharrell Williams (Tato Dj) | A male singer sings this pop melody with back up singers in choral harmony. The song is medium tempo with a superimposed Latin Cumbia rhythm, which creates a discombobulated rhythm structure. The song audio quality is very poor. | 2014-03-14T22:04:39Z | Viktor Radchenko | Tato DJ Twitter: https://twitter.com/Tatoarata Original song by Pharrell Williams | ["Music", "Maraca"] | ["cumbria rhythm", "pop song", "choppy music", "latin rhythm", "disconcerting music", "cheerful", "pop superhit", "emotional", "inspiring", "groovy", "passionate", "male singer", "backups singers", "crooning", "choral harmony", "groovy bas slime", "steady drumming rhythm", "poor audio quality", "remix", "dj", "cymbals crashing", "groovy bass line", "latin percussions", "mismatched tempos", "amateur music mix"] | 1 | C6roSYqchkk | 1331 | |
Zwan - Lyric (Video Version) | A male and female singer sing this vocal duet. The song is medium fast tempo with a guitar accompaniment, steady drumming rhythm with exciting drum rolls, cymbals crashes and a percussive bass line. The song is romantic and exciting. The song is retro pop with a bad audio quality. | 2009-10-27T01:54:19Z | Warner Records Vault | © 2005 WMG Lyric (Video Version) | ["Music", "Independent music", "Pop music", "Grunge"] | ["male singer", "female singer", "guitar accompaniment", "keyboard accompaniment", "vocal duet", "retro pop hits", "medium fast tempo", "poor audio quality", "groovy rhythm", "steady drumming rhythm", "percussive bass line", "keyboard accompaniment", "drum rolls", "cymbals crashing", "romantic", "exciting", "emotional", "adventurous", "passionate", "retro pop hits"] | 1 | CwmUMySSNQc | 1417 | |
Experimental Funk Rock Slap Bass | The song is an instrumental. The tempo is medium with a bass guitar using innovative improvisation skills along with a drum track with heavy cymbal crashes. The song is energetic and passionate. | 2011-12-02T00:42:41Z | Remco's Groove Lab | Jam-based freefunk with an EBS bass iq, multidrive and octabass. I also used a digitech whammy pedal to bend the harmonic. Thanks for watching! Get this track on iTunes: https://music.apple.com/album/groove-a-holic-vol-2/1505339451 Bandcamp: http://remcohendriks.bandcamp.com/album/groove-a-holic-vol-2 Spotify: https://open.spotify.com/album/0CHNzopWXpDPskk3VUldxm?si=ammyhHEXRqKXiDvMSX20eQ Facebook: https://www.facebook.com/Gr00veLab Instagram: https://www.instagram.com/groove_a_holic Cheers! On request, here's the tab for the slap part on the first riff: h= hammer-on x= muted slap G ----------4--2--------2----44- D ----------------2h4x---xx----- A ---0h2x--x--------------------- | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Rock music", "Plucked string instrument"] | ["funk rock", "slap bass", "instrumental music", "youtube music video", "experimental", "improvisational", "drum track", "cymbals crashing", "guitar effects pedal", "amplifier", "distorted guitar", "exciting", "passionate", "spirited", "quick slap bass inquest", "guitar demo", "technique video", "bass master class"] | 1 | T8U3ihbHh9A | 2815 | |
Etiqueta Rock and Roll Yo estare aqui.wmv | The song is an instrumental. The tempo is medium with a guitar playing a romantic lead, steady drumming, rock drumming, percussive bass line, cymbals crashing and guitar strumming rhythm. The song is exciting and youthful. The song has a bad audio quality. | 2011-06-08T22:05:27Z | TheMugriento25 | ["Music", "Psychedelic rock", "Rock music", "Roll", "Rock and roll"] | ["rock and roll music", "medium tempo", "steady rock drumming", "guitar playing lead", "cymbals crashing", "drum rolls", "swing music", "percussive bass line", "rock band", "romantic", "exciting", "retro rock and roll", "dance music", "people dancing", "couples slow dancing", "passionate", "spirited", "retro hits", "instrumental music", "bad audio quality"] | 1 | YDBxdZchOuM | 3265 | ||
The Scissors - You Can Make It Dangerous - Out 3.20.10 | A male singer sings this rock melody with backup singers in vocal harmony. The song is fast tempo with a strong drumming rhythm , percussive bass line, amplified guitar playing lead. The song is energetic and romantic. The song is a retro rock song with average audio quality. | 2010-01-21T00:22:10Z | TheScissors | http://www.thescissors.com - http://facebook.com/thescissors Scissors - You Can Make It Dangerous - Out 3.20.10 | ["Singing", "Heavy metal", "Music", "Punk rock", "Independent music", "Rock music", "Progressive rock", "Grunge"] | ["make singer", "fast tempo", "rock band", "backup singers", "vocal harmony", "strong rock drumming", "distorted guitar rhythm", "guitar playing lead", "tambourine percussions", "cymbals crashing", "emotional", "romantic", "groovy rhythm", "high in adrenaline", "passionate", "spirited", "retro rock hits", "average audio quality"] | 1 | Ztlcnd14Kn4 | 3426 | |
Crematory - Tick Tack | The song is an instrumental. The tempo is medium fast with strong metal drumming, groovy bass line, distorted guitar playing rhythm and cymbals crashing. The song is high on adrenaline and exciting. The audio quality is poor. | 2009-05-09T13:45:07Z | pavenpaul | Artist: Crematory Song: Tick Tack Album: Revolution Genre: Gothic metal Track # 6 | ["Music", "Rock music", "Angry music"] | ["instrumental music", "death metal music", "retro death metal hits", "poor audio quality", "cymbals crashing", "fast tempo", "groovy rhythm", "guitar playing rhythm", "rock drumming", "energetic", "adrenaline rush", "passionate", "head banging", "mosh pit", "spirited", "percussive bass line"] | 1 | gCSShNsw-_A | 4013 | |
PACHUCO ROLAS VOL 1 | A female singer sings this passionate melody with backup singers in vocal harmony. The tempo is medium and gradually slows down towards the end. The drumming rhythm is steady and retards to the end with a percussive bass line and keyboard accompaniment. The song is a retro disco or R&B love song. The song has poor audio quality. | 2009-03-23T07:20:30Z | pachucojae | PACHUCO MEMORIES.... | ["Music", "Soul music"] | ["female singer", "disco music", "song retarding", "bad audio quality", "slowing down", "backup singers", "falsetto", "vocal harmony", "steady drumming", "groovy bass line", "piano accompaniment", "guitar rhythm", "tambourine percussions", "cymbals crashing", "retro pop song", "retro hits", "emotional", "love song", "passionate", "together forever", "disco romance hits", "marry me"] | 1 | iS-iTbHndw8 | 4185 | |
Missing from YouTube | A male singer sings this rock melody. The tempo is medium with a groovy bass line, guitar rhythm , keyboard accompaniment, and heavy rock drumming with cymbals crashing. The song is energetic and passionate. The song is a retro pop-rock song. | ["Music", "Independent music"] | ["male singer", "classic rock band", "cymbals crashing", "rock band", "emotional", "steady drumming rhythm", "medium tempo", "guitar rhythm", "keyboard accompaniment", "romantic", "emotional", "love song", "energetic", "youthful", "passionate", "retro pop hits", "percussive bass line"] | 1 | 4437 | |||||
W.A.S.P. - My Tortured Eyes LYRICS | The song is an instrumental. The tempo is fast with a fast metal drumming rhythm, complete with cymbal crashes, distorted guitar lead, guitar playing rhythm, and percussive bass line. The song is a death metal song ending with a bad audio quality. | 2011-08-19T16:13:10Z | nagito11 | ["Heavy metal", "Music", "Rock music", "Angry music"] | ["heavy metal music", "instrumental music", "fast metal drumming", "distorted guitar rhythm", "keyboard accompaniment", "instrumental music", "fast tempo", "groovy rhythm", "cymbals crashing", "song fade", "song ending", "passionate", "adrenaline rush", "spirited", "youthful", "rebellious", "bad audio quality", "guitar lead", "percussive bass line"] | 1 | nbb8vmfjHJs | 4563 | ||
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;