musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "exciting", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- exciting · 4 ✖
- male singer · 4 ✖
- passionate · 4 ✖
- poor audio quality 3
- adrenaline rush 2
- energetic 2
- groovy rhythm 2
- guitar accompaniment 2
- latin percussions 2
- medium fast tempo 2
- percussive bass line 2
- adventurous 1
- arena 1
- backup singers 1
- barking tones 1
- bass guitar solo 1
- brass band 1
- break the tension 1
- building anticipation 1
- buzz 1
- crowds cheering 1
- cymbals crashing 1
- distorted amplified guitar 1
- drum roll 1
- drum rolls 1
- electrostatic sounds 1
- emotional 1
- enthusiastic 1
- enthusiastic drumming 1
- excitement in the air 1
- …
musiccaps_names (array) 7 ✖
- Music 4
- Exciting music 1
- Grunge 1
- Independent music 1
- Jazz 1
- Pop music 1
- Salsa music 1
youtube_published (date) 4 ✖
- 2009-10-27 1
- 2010-11-03 1
- 2013-02-17 1
- 2016-07-13 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 | |
Zwan - Lyric (Video Version) | A male and female singer sing this vocal duet. The song is medium fast tempo with a guitar accompaniment, steady drumming rhythm with exciting drum rolls, cymbals crashes and a percussive bass line. The song is romantic and exciting. The song is retro pop with a bad audio quality. | 2009-10-27T01:54:19Z | Warner Records Vault | © 2005 WMG Lyric (Video Version) | ["Music", "Independent music", "Pop music", "Grunge"] | ["male singer", "female singer", "guitar accompaniment", "keyboard accompaniment", "vocal duet", "retro pop hits", "medium fast tempo", "poor audio quality", "groovy rhythm", "steady drumming rhythm", "percussive bass line", "keyboard accompaniment", "drum rolls", "cymbals crashing", "romantic", "exciting", "emotional", "adventurous", "passionate", "retro pop hits"] | 1 | CwmUMySSNQc | 1417 | |
LG톤플러스 CF 국카스텐 하현우 'Sound change music video' 편 | A male singer sings this youthful k-pop song. The tempo is fast with a heartbeat rhythm, electro static sounds, electric buzz, followed by a fast paced drum rhythm, guitar accompaniment and a groovy bass line. The song is groovy and very youthful. | 2016-07-13T23:02:19Z | LG전자 Library | 복면가왕 음악대장 국카스텐 하현우가 들려주는 톤플러스의 블루투스 세계최초 24비트 놀라운 사운드를 뮤직비디오형식으로 표현 | ["Music", "Exciting music"] | ["heart beat melody", "male singer", "k-pop", "storm cloud noises", "electrostatic sounds", "buzz", "signal tempo", "drum roll", "enthusiastic drumming", "guitar strumming", "distorted amplified guitar", "percussive bass line", "pop", "pop dance rhythm", "pop dance song", "get tones", "korean rock band", "exciting", "building anticipation", "break the tension", "youthful", "exciting", "teen spirit", "enthusiastic", "spirited", "passionate"] | 1 | OhZmxS5DUKU | 2458 | |
𝐒𝐀𝐋𝐒𝐀 - 𝐛𝐚𝐢𝐥𝐚 𝐂𝐮𝐛𝐚𝐧 𝐬𝐭𝐲𝐥𝐞 - 𝐄𝐱𝐜𝐢𝐭𝐢𝐧𝐠 𝐒𝐚𝐥𝐬𝐚 ! | 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;