musiccaps_details (view)
2 rows where musiccaps_aspects contains "youthful" and musiccaps_names contains "Maraca" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- fast tempo 2
- youthful · 2 ✖
- backup singers 1
- brass band 1
- buoyant 1
- club music 1
- dance music 1
- dance pop 1
- digital drum 1
- dj 1
- dj mixer 1
- energetic 1
- energetic drums 1
- energetic vocal backup 1
- enthusiastic 1
- fast drumming rhythm 1
- groovy 1
- keyboard harmony 1
- latin dance rhythm 1
- latin dancers 1
- latin percussions 1
- love performance 1
- male latin singer 1
- male vocalist 1
- passionate 1
- percussive bass line 1
- piano accompaniment 1
- poor audio quality 1
- rapping vocals 1
- romantic 1
- screaming vocals 1
- street music 1
- synth pop 1
- synthesiser arrangements 1
- tambourine beats 1
- trumpets blaring 1
- vivacious 1
musiccaps_names (array) 5 ✖
- Maraca · 2 ✖
- Music 2
- Song 2
- Dance music 1
- Salsa music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
DJ HumNoy Maraca YouTube | A male vocalist sings this energetic song. The tempo is fast with synthesiser arrangements, punchy digital drumming, tambourine beats and keyboard harmony. The music is upbeat, punchy, groovy, youthful, buoyant and exciting. This song is Synth Pop. | 2013-12-03T12:25:16Z | ณ๊องจุ้น คนเดิม | ["Music", "Song", "Dance music", "Maraca"] | ["male vocalist", "fast tempo", "energetic drums", "synth pop", "buoyant", "tambourine beats", "digital drum", "synthesiser arrangements", "keyboard harmony", "energetic vocal backup", "dj", "dj mixer", "dance pop", "dance music", "club music", "youthful", "enthusiastic", "vivacious"] | 7 | S7rP6coeLTY | 2742 |
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;