musiccaps_details (view)
4 rows where musiccaps_aspects contains "latin percussions", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 67 ✖
- latin percussions · 4 ✖
- male singer · 4 ✖
- passionate 4
- poor audio quality · 4 ✖
- adrenaline rush 2
- emotional 2
- energetic 2
- exciting 2
- groovy bass line 2
- salsa 2
- amateur music mix 1
- arena 1
- backup singers 1
- backups singers 1
- barking tones 1
- bass guitar solo 1
- brass band 1
- cheerful 1
- choppy music 1
- choral harmony 1
- couples dancing 1
- crooning 1
- crowds cheering 1
- cumbria rhythm 1
- cymbals crashing 1
- disconcerting music 1
- dj 1
- excitement in the air 1
- groovy 1
- groovy bas slime 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar rhythm 1
- inspiring 1
- keyboard accompaniment 1
- keyboard harmony 1
- latin dance 1
- latin dance music 1
- latin folk music 1
- latin pop hits 1
- latin rhythm 1
- latin romantic hits 1
- live audience 1
- live band performance 1
- live in concert 1
- live performance 1
- love songs 1
- medium fast tempo 1
- medium tempo 1
- mismatched tempos 1
- mysterious 1
- passionate song 1
- piano accompaniment 1
- pop song 1
- pop superhit 1
- remix 1
- retro latin hits 1
- romantic 1
- saxophone solo 1
- spirited singing 1
- steady drumming rhythm 1
- strong drumming rhythm 1
- trumpets blaring 1
- trumpets playing 1
- ttrumelts blaring 1
- various percussion hits 1
- vocal harmony 1
musiccaps_names (array) 5 ✖
- Music 4
- Salsa music 2
- Jazz 1
- Maraca 1
- Middle Eastern music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Los Autenticos Decadentes - Veni Raquel (Vivo Pepsi Music 2010) HD | A male singer sings this exciting Latin dance melody. The tempo is medium fast with a saxophone solo, percussive bass line, guitar accompaniment, latin percussion, steady drumming rhythm, and cymbal crashes. The song is exciting with the crowds going crazy. The audio quality is poor. | 2010-11-03T06:42:47Z | popartdiscosvivo | ARTISTA: LOS AUTENTICOS DECADENTES TEMA: VENI RAQUEL EN VIVO EN EL PEPSI MUSIC 2010 - COSTANERA SUR, BUENOS AIRES, ARGENTINA - 23/10/10 | ["Jazz", "Music"] | ["live audience", "saxophone solo", "bass guitar solo", "arena", "excitement in the air", "latin percussions", "strong drumming rhythm", "guitar accompaniment", "latin pop hits", "retro latin hits", "crowds cheering", "poor audio quality", "live in concert", "exciting", "energetic", "passionate", "adrenaline rush", "medium fast tempo", "male singer"] | 1 | 244y56-vLWE | 328 | |
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 | |
SALSA CLASICA ROMANTICA MIX RONNY MUSIC | A male singer sings this Latin melody. The song is medium tempo with a groovy Latin percussive rhythm, keyboard accompaniment, brass band harmony and a groovy bass line. The song is romantic and emotional. The song is a salsa dance hit, but has poor audio quality issues.. | 2011-09-30T01:08:54Z | ronnymusic01 | BY DJ RONNY MUSIC | ["Music", "Middle Eastern music", "Salsa music"] | ["salsa", "latin folk music", "male singer", "spirited singing", "emotional", "couples dancing", "passionate song", "mysterious", "latin percussions", "trumpets playing", "medium tempo", "various percussion hits", "keyboard harmony", "romantic", "love songs", "latin romantic hits", "keyboard accompaniment", "poor audio quality", "passionate", "groovy bass line"] | 1 | DKflAAykh6A | 1464 | |
𝐒𝐀𝐋𝐒𝐀 - 𝐛𝐚𝐢𝐥𝐚 𝐂𝐮𝐛𝐚𝐧 𝐬𝐭𝐲𝐥𝐞 - 𝐄𝐱𝐜𝐢𝐭𝐢𝐧𝐠 𝐒𝐚𝐥𝐬𝐚 ! | A male singer sings this Latin melody with backup singers in vocal harmony. The song is medium tempo with a brass band accompaniment, latin percussion and guitar accompaniment. The song is exciting and spirited. The song is perfect for Latin dancing. The song has a poor audio quality. | 2013-02-17T03:55:26Z | MrHaagsesjonny1 | 𝗱𝗮𝗻𝗰𝗲 𝘃𝗶𝗱𝗲𝗼: 𝘀𝗮𝗹𝘀𝗮 𝗱𝗮𝗻𝗰𝗶𝗻𝗴 - 𝘀𝗮𝗹𝘀𝗮 𝗰𝘂𝗯𝗮𝗻𝗮 - 𝗖𝗮𝘀𝗶𝗻𝗼 - 𝗮𝗻𝗱 𝗲𝘅𝗰𝗶𝘁𝗶𝗻𝗴 𝗱𝗮𝗻𝗰𝗲 𝘄𝗶𝘁𝗵 𝗖𝘂𝗯𝗮𝗻 𝗯𝗼𝗿𝗻 𝗠𝗮𝘆𝗸𝗲𝗹 𝗙𝗼𝗻𝘁𝘀 | ["Music", "Salsa music"] | ["latin dance music", "male singer", "live band performance", "trumpets blaring", "vocal harmony", "piano accompaniment", "exciting", "energetic", "passionate", "latin dance", "salsa", "passionate", "adrenaline rush", "groovy rhythm", "backup singers", "vocal harmony", "ttrumelts blaring", "brass band", "barking tones", "latin percussions", "guitar rhythm", "poor audio quality", "live performance"] | 1 | RlrNPBfOowg | 2722 |
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;