musiccaps_details (view)
2 rows where musiccaps_aspects contains "latin percussions" and musiccaps_aspects contains "steady drumming rhythm" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- latin percussions · 2 ✖
- poor audio quality 2
- steady drumming rhythm · 2 ✖
- amateur music mix 1
- backups singers 1
- brass band 1
- cheerful 1
- choppy music 1
- choral harmony 1
- cinco de mayo 1
- crooning 1
- cumbria rhythm 1
- cymbals crashing 1
- dancing rhythm 1
- disconcerting music 1
- dj 1
- emotional 1
- fanfare and pomp 1
- groovy 1
- groovy bas slime 1
- groovy bass line 1
- inspiring 1
- instrumental music 1
- latin brass band 1
- latin dance band 1
- latin rhythm 1
- lively 1
- male singer 1
- marching rhythm 1
- medium tempo 1
- mismatched tempos 1
- passionate 1
- pop song 1
- pop superhit 1
- remix 1
- respect the dead 1
- triumphant 1
- trumpets blaring 1
- trumpets playing 1
- tubas playing lower harmony 1
- vintage marching bands 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bombo Y Maracas (Gaita) | The song is an instrumental. The tempo is medium with a brass band playing, trumpets blaring, tubas and trombones playing percussively, Latin percussions playing along with drum hits. The song is lively and exciting. The song is a brass band marching with a poor audio quality. | 2008-12-13T17:22:41Z | lealm79 | Saludos para todos mis cuates y les dedico este tema con sabor a colombia!!! | ["Music", "Bass drum", "Maraca"] | ["trumpets playing", "brass band", "cinco de mayo", "respect the dead", "medium tempo", "lively", "instrumental music", "vintage marching bands", "dancing rhythm", "latin dance band", "fanfare and pomp", "trumpets blaring", "latin percussions", "poor audio quality", "steady drumming rhythm", "tubas playing lower harmony", "triumphant", "marching rhythm", "latin brass band"] | 1 | tGUWSgewh0A | 5021 | |
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 |
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;