musiccaps_details (view)
2 rows where musiccaps_aspects contains "latin dance rhythm", musiccaps_aspects contains "passionate" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- latin dance rhythm · 2 ✖
- passionate · 2 ✖
- backing track 1
- backup singers 1
- bass drum 1
- brass band 1
- dance rhythm 1
- drum sticks 1
- drums demonstration 1
- energetic 1
- enthusiastic 1
- exciting 1
- fast drumming rhythm 1
- fast tempo 1
- groovy 1
- groovy music 1
- laitin dance hits 1
- latin dancers 1
- latin percussions 1
- love performance 1
- male latin singer 1
- male singer 1
- male singer chants 1
- medium tempo 1
- percussion practice 1
- percussive bass line 1
- piano accompaniment 1
- poor audio quality 1
- rapping vocals 1
- romantic 1
- screaming vocals 1
- steady rhythm 1
- street music 1
- trumpets blaring 1
- vocal chants 1
- youthful 1
- youtube music video 1
musiccaps_names (array) 8 ✖
- Music · 2 ✖
- Drum 1
- Maraca 1
- Musical instrument 1
- Percussion 1
- Rattle (instrument) 1
- Salsa music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
tema:ni tu ni yo,art: la barra (cuarteto) fctambora. | The song is an instrumental. The song is medium tempo with a percussionist practising Latin bass drums with a drum stick to a music track with male vocals, trumpet harmony and other percussion. The audio quality is poor and boomy. | 2012-09-12T01:14:54Z | fernando castro | ["Drum", "Music", "Musical instrument", "Rattle (instrument)", "Percussion"] | ["percussion practice", "male singer", "backing track", "vocal chants", "exciting", "dance rhythm", "enthusiastic", "passionate", "drums demonstration", "steady rhythm", "latin dance rhythm", "male singer chants", "laitin dance hits", "bass drum", "drum sticks", "youtube music video", "groovy music", "medium tempo"] | 1 | CHo8wKj9J1w | 1347 | ||
La Maraca | A male Latin singer sings this energetic vocal with male backup singers in vocal harmony. The song is fast tempo with quick Latin percussions, groovy bass line, keyboard accompaniment and trumpets blaring. The song is energetic and passionate. The song has poor audio quality. | 2008-04-10T19:01:41Z | adonismasgozadera | AdonisGozadera.com | ["Music", "Song", "Salsa music", "Maraca"] | ["male latin singer", "backup singers", "screaming vocals", "rapping vocals", "street music", "fast tempo", "poor audio quality", "piano accompaniment", "latin percussions", "percussive bass line", "fast drumming rhythm", "energetic", "youthful", "romantic", "love performance", "brass band", "trumpets blaring", "groovy", "passionate", "latin dancers", "latin dance rhythm"] | 1 | zNSV9GkpRfM | 5468 |
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;