musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "happy", musiccaps_aspects contains "world music" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- happy · 5 ✖
- world music · 5 ✖
- fast tempo 3
- celebration 2
- cheerful 2
- energetic 2
- enthusiastic 2
- foreign language 2
- latin pop 2
- lively 2
- male singer 2
- male vocalist 2
- medium tempo 2
- pleasant 2
- simple 2
- spanish guitar 2
- spirited 2
- vocal backup 2
- acordion melody 1
- acoustic guitar 1
- acoustic guitar accompaniment 1
- african music 1
- animated percussions 1
- bachata 1
- banjo 1
- bongos 1
- bongos beat 1
- brass band 1
- bright drumming 1
- bright violin 1
- …
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Θα κάνω φασαρία-Γιαννούλης Βαζαίος | A male vocalist sings this animated song in a foreign language. The tempo is fast with a bright applied violin accompaniment, lively drumming, groovy bass line, tambourine beats, rhythmic mandolin and acoustic guitar accompany net. The song is lively, energetic, vibrant, happy, vivacious and merry with a dance groove. This song is a Folk Pop/Regional Pop. | 2010-06-29T13:03:59Z | mike gr | από το cd ''να μαστε πάλι[πιτσιρίκα]'' | ["Jingle (music)", "Music"] | ["male singer", "fast tempo", "regional pop", "folk pop", "emphatic vocals", "foreign language", "bright violin", "energetic", "animated percussions", "lively mandolin", "acoustic guitar", "groovy bass line", "folk song", "folk music", "world music", "pop", "pop hits", "youthful", "dance music", "celebration", "merry", "happy"] | 7 | 40D4L5Ndi6k | 529 | |
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 | |
SOUL VIBRATION - Frequenza reggae | A male vocalist sings this vivacious latin pop song. The tempo is fast with rhythmic Spanish guitar,keyboard harmony, bright drumming, mandolin harmony, groovy bass line and lively pandeira beats. The song is melodic, simple, happy, cheerful, bouncy, peppy , warm and joyful. | 2010-08-30T17:45:36Z | AstonBarret | SOUL VIBRATION - Frequenza reggae - REGGAE MATERA | ["Music", "Soul music"] | ["male vocalist", "fast tempo", "latin pop", "latin song", "banjo", "spanish guitar", "keyboard harmony", "bright drumming", "world music", "regional music", "happy", "cheerful", "enthusiastic", "warm", "sunny", "upbeat", "pleasant", "funky bass lines", "pandeireta", "rhythmic acoustic guitar"] | 7 | CP3phqztym0 | 1360 | |
Israel Vibration African Unification | A male vocalist sings the Lord’s Prayer. The tempo is medium with Keyboard harmony, steady drumming, groovy basslines, rhythmic guitar,beat of shakers, vocal backup and a trumpet flourish. The music is simple, rhythmic, pleasant, catchy, soulful and punchy Reggae. There are sounds of people clapping and cheering in the background indicating that this is a live performance. | 2007-02-25T01:52:21Z | David Ruiz | Israel Vibration African Unification | ["Music", "Reggae", "Ska"] | ["male singer", "medium tempo", "reggae", "live performance", "stage performance", "concert", "rhythmic acousitc guitar", "clapping cheering", "vocal backup", "shakers", "pleasant", "punchy", "groovy", "happy", "simple", "pleasant", "reggae tones", "groovy bass lines", "trumpets", "brass band", "shakers", "steady drumming", "keyboard accompaniment", "the lord’s prayer", "carrie an music", "african music", "r&b", "world music", "catchy"] | 7 | blsYgo-B1k8 | 3650 | |
LLEGO DICIEMBRE CON SU ALEGRIA | A female vocalist sings this classic Spanish song. The tempo is medium with a lively accordion harmony, guiro , congas and bongos rhythm, steady bass line, and acoustic guitar accompaniment. The music is simple, light, happy, joyful, cheerful, celebratory and spirited with vocal backup.There are sounds of people cheering in the background. This is a Classic Latin Folk Song. | 2012-12-02T02:33:13Z | max pardo | LLEGO DICIEMBRE | ["Christmas music", "Christian music", "Music", "Rattle (instrument)"] | ["female singer", "medium tempo", "cheerful", "happy", "spirited", "celebratory", "simple", "classic latin songs", "lively", "latin folk songs", "latin percussions", "latin music", "spanish music", "guiro", "acordion melody", "foreign language", "world music", "congas", "bongos", "acoustic guitar accompaniment", "steady bass line", "male backup", "muddled audio"] | 7 | wQN7fRaPl2A | 5264 |
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;