musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "spirited" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 58 ✖
- groovy bass line · 3 ✖
- spirited · 3 ✖
- male singer 2
- passionate 2
- adrenaline rush 1
- ambient crowd noises 1
- animated 1
- animated piano 1
- average audio quality 1
- backup singers 1
- bad audio quality 1
- bongos 1
- buoyant 1
- cheerful 1
- clapping percussions 1
- congas 1
- crowds cheering 1
- cymbals crashing 1
- dance rhythm 1
- enthusiastic 1
- excitement 1
- female singer 1
- female singers 1
- g]adrenaline rush 1
- groovy music 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar rhythm 1
- hissing vocals 1
- home studio 1
- inspiring 1
- keybiard accompaniment 1
- latin folk 1
- latin music 1
- latin pop 1
- life lessons 1
- lifetime experience 1
- live audience 1
- live performance 1
- lively trumpet 1
- medium fast tempo 1
- medium tempo 1
- motivational 1
- peppy 1
- perky 1
- regional music 1
- retro pop hits 1
- retro rock hits 1
- rock drumming rhythm 1
- rock music 1
- rock singer 1
- singing long notes 1
- song cover 1
- vibrant 1
- vic latin dance 1
- vivacious 1
- vocal backup 1
- world music 1
musiccaps_names (array) 9 ✖
- Music 3
- Singing · 3 ✖
- Song 2
- Independent music 1
- Jazz 1
- Pop music 1
- Rock music 1
- Salsa 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 |
---|---|---|---|---|---|---|---|---|---|---|
Perfume De Salsa - Dame Un Traguito (Music Video Latin Jazz/Salsa) | A female vocalist sings this spirited latin song.the tempo is medium fast with an animated piano accompaniment, rhythmic congas and bongos, funky bass line and bright trumpet harmony. The song is lively, spirited, upbeat, catchy, vivacious;vibrant and peppy with a salsa dance groove. This song is Latin Pop. | 2015-10-21T16:12:43Z | Sam Sam Music | Fabulous all women Latin Jazz / Salsa band Perfume de Salsa: On disc and download: http://www.samsammusic.com/Perfume-De-Salsa https://itunes.apple.com/us/album/solo-ella/id369866081 https://play.spotify.com/album/4Uhhl8qh5YiIibzNku0wpf http://www.amazon.com/Solo-Ella-Perfume-Salsa/dp/B003JJUJWS https://play.google.com/store/music/album/Perfume_de_Salsa_Solo_Ella?id=Bmu4rc6lk6hmr4ohcqoufeqbooa&hl=en http://www.rdio.com/artist/Perfume_De_Salsa/album/Solo_Ella/ http://www.deezer.com/album/543046 Subscribe to Sam Sam Music ➤https://bit.ly/34fRMti Great New Music Videos ➤ https://bit.ly/34fXevV Rock’n Roll Sixties ➤ http://bit.ly/RocknRollSixties Follow us on Social Media: Website ► https://bit.ly/2NGpfHJ Facebook ► http://bit.ly/2NJztas Twitter► http://bit.ly/32KMt3A Instagram► http://bit.ly/2NKdUXh #latin #salsa #jazzmusic | ["Singing", "Jazz", "Music", "Song", "Salsa music"] | ["female singer", "medium fast tempo", "vivacious", "animated", "spirited", "buoyant", "perky", "peppy", "cheerful", "vibrant", "latin music", "latin pop", "vic latin dance", "latin folk", "regional music", "world music", "animated piano", "lively trumpet", "groovy bass line", "bongos", "congas", "vocal backup"] | 7 | fPYeqTFc3IQ | 3944 | |
Jakes List Jun 2012 Top 10 Independent Music Video Uploads | Male and female singers sing this vocal harmony. The song is medium tempo with a groovy bass-line, keyboard accompaniment, guitar rhythm and a steady drumming rhythm with clapping percussions. The song is exciting and groovy. The song is a classic pop hit cover with an average quality sound. | 2012-06-30T22:34:02Z | Jake Niall Foster | The top 10 music video uploads for the month of June 2012 (with a cut-off date of 22 Jun) for Independent and Unsigned artists. | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["male singer", "backup singers", "female singers", "clapping percussions", "groovy bass line", "medium tempo", "guitar accompaniment", "keybiard accompaniment", "song cover", "home studio", "average audio quality", "hissing vocals", "spirited", "passionate", "dance rhythm", "groovy rhythm", "life lessons", "motivational", "inspiring", "retro pop hits"] | 1 | lR8am4rK7qQ | 4395 | |
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;