musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_names contains "Music" and "youtube_published" is on date 2009-09-27 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- acoustic drums 2
- energetic 2
- fast tempo 2
- aggressive 1
- alternative 1
- bachata 1
- bass guitar 1
- bongos beat 1
- celebration 1
- chaotic 1
- congas rhythm 1
- distorted electric guitar 1
- e-bass 1
- e-guitar 1
- electronic elements 1
- enthusiastic 1
- enthusiastic vocals 1
- happy 1
- harsh singing 1
- higher pitch 1
- indie7rock/pop 1
- lain pop 1
- latin dance music 1
- latin percussion 1
- latin pop 1
- lively 1
- loud 1
- male vocal 1
- male vocalist 1
- male voice singing 1
- …
musiccaps_names (array) 6 ✖
- Music · 3 ✖
- Angry music 1
- Independent music 1
- Music of Latin America 1
- Salsa music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lluvia - Gilberto Sta Rosa, Charlie Aponte, Jerry Rivas by www.latarimadelasalsa.tk | A male vocalist sings this spirited Latin song. The tempo is fast with a syncopated piano harmony, spanish guitar accompaniment ,Congas and bongos percussion, pandeira beats , keyboard harmony and vocal backup. The music is a lively, energetic, enthusiastic, passionate, spirited and vital Latin Pop with a dance groove. | 2009-09-27T16:38:48Z | latarimadelasalsa | Saludos Salseros y Salseras del Perú y del mundo este es un espacio dedicado a la Salsa, donde podras encontrar ultimas noticias, musica, videos y todo lo relacionado con el genero que nos apasiona. La Tarima de la Salsa - Perú www.latarimadelasalsa.tk | ["Music", "Music of Latin America", "Salsa music"] | ["male vocalist", "fast tempo", "latin pop", "world music", "happy", "celebration", "enthusiastic vocals", "syncopated piano", "congas rhythm", "bongos beat", "spanish guitar", "steady bass lines", "vocal backup", "lively", "spirited", "energetic", "enthusiastic", "passionate", "lain pop", "latin dance music", "salsa", "rumba", "bachata", "latin percussion", "pandeireta beats"] | 7 | 68XchGI6H-4 | 730 | |
Top 30 Indie Songs I Think You Should Listen To | This song contains someone playing acoustic drums along with an e-bass. They both sound in the foreground. A male voice is singing in the high mids and with reverb and a little delay on his voice. Then the song breaks into the next part and an e-guitar comes in with a strummed melody. This song may be playing with headphones lost in thoughts. | 2009-09-27T17:23:53Z | top30music | Follow me on twitter!: @Top30music 30 great indie songs from bands from 12 different countries!!... if you know a good indie song dont keep it to yourself... comment about it! If you're looking for new music, don't hesitate on clicking here: http://www.youtube.com/watch?v=1xXuKvtOlaw amazing artist! | ["Singing", "Music", "Independent music"] | ["indie7rock/pop", "male voice singing", "higher pitch", "acoustic drums", "e-bass", "e-guitar", "uptempo"] | 6 | atWaDoSyGgY | 3584 | |
slipknot pulse of the maggots | This is a nu-metal/alternative metal music piece. There is a male vocalist singing in a harsh, shout-like manner in the lead. The main melody is being played by a distorted electric guitar with a strong bass guitar backing. There are various electronic elements such as a crowd cheering sample and an evolving synth sound adding texture to the piece. The rhythmic background consisted of a loud metal acoustic drum beat and secondary percussive elements such as steel percussion. The atmosphere is energetic and violent. This piece could be used in the soundtrack of an action-filled/shootout video game. It could also be playing in the background at a metal bar. | 2009-09-27T06:17:51Z | slayer4728 | I have a good faith belief that the material was disabled as a result of a mistake or misidentification, and that I am not intentionally abusing this dispute process. I do NOT own this video. It was recorded by SlipKnot, I do NOT take part in this video. Enjoy! | ["Music", "Angry music"] | ["nu-metal", "alternative", "male vocal", "harsh singing", "distorted electric guitar", "bass guitar", "electronic elements", "acoustic drums", "percussive elements", "loud", "energetic", "aggressive", "chaotic", "violent", "fast tempo"] | 9 | cCyfADwHiWs | 3688 |
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;