musiccaps_details (view)
2 rows where musiccaps_aspects contains "cheerful" and musiccaps_aspects contains "dance song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- cheerful · 2 ✖
- dance song · 2 ✖
- car horn playing percussively 1
- clapping hands 1
- duet 1
- energetic 1
- exciting 1
- female backup singers 1
- four on the floor drum beat 1
- fun 1
- groovy dance rhythm 1
- happy 1
- hip hop dance hits 1
- hip hop music 1
- hissing noise 1
- keyboard accompaniment 1
- male and female vocalists 1
- male singer 1
- medium-fast tempo 1
- poor audio quality 1
- portuguese pop r&b music 1
- positive 1
- r&b vocals 1
- retro dance hits 1
- steady drumming rhythm 1
- strong bass line 1
- vocal harmony 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Slam Trumpet - Quad City DJs vs. Skull Trumpet | A male singer sings this exciting melody with female backup singers in vocal harmony. The song is medium fast tempo with a strong bass line, steady drumming rhythm, keyboard accompaniment and a car horn playing percussively. The song has pretty bad audio quality. The song is a retro hip hop dance tune. | 2011-11-28T10:38:09Z | GravityGames | Is this the best Slam Jam Remix? | ["Brass instrument", "Trumpet"] | ["male singer", "hip hop music", "car horn playing percussively", "female backup singers", "groovy dance rhythm", "vocal harmony", "poor audio quality", "energetic", "exciting", "cheerful", "dance song", "retro dance hits", "hip hop dance hits", "steady drumming rhythm", "strong bass line", "keyboard accompaniment", "hissing noise", "medium-fast tempo"] | 1 | f4jW2H6V7gk | 3919 | |
Música de Natal Unitel (video Clip) | This is a pop R&B song in Portuguese. The song has a cheerful and fun effect to it, and the four on the floor style helps in creating the feeling of dancing. The singers are a man and woman with smooth vocals, singing a duet - harmonically. | 2014-11-20T08:31:22Z | tvUNITEL | Música de Natal Unitel 2014. "Mais próximo do meu coração” de Anselmo Ralph e Anna Joyce Unitel. O próximo mais próximo. ====================================== "Mais próximo do meu coração” Eu trago embrulhado numa caixa, Forrado com papel azul e laranja, E quando toca a meia noite, tu... Podes abrir, vá lá, vem ver o que eu escolhi para ti, É para ti com muito amor, Eu dei o meu melhor, Para o próximo, mais próximo do meu coração. (Refrão x2) Pois neste Natal Eu posso não te dar de tudo Mas o meu pouco é muito No Natal, vai ser dado com amor. Família reunida numa mesa, De fora fica a mágoa e a tristeza, No meu peito eu trago a prenda mais preciosa, Nas mãos eu trago algo que eu escolhi para ti. É para ti com muito amor, Eu dei o meu melhor, Para o próximo mais próximo do meu coração. | ["Christmas music", "Singing", "Christian music", "Music", "Rhythm and blues"] | ["portuguese pop r&b music", "dance song", "four on the floor drum beat", "duet", "male and female vocalists", "r&b vocals", "cheerful", "positive", "happy", "clapping hands", "fun"] | 3 | yqb4GenP8gs | 5443 |
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;