musiccaps_details (view)
2 rows where musiccaps_aspects contains "spirited drumming" and musiccaps_aspects contains "vocalisation" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- fast tempo 2
- spirited drumming · 2 ✖
- vocalisation · 2 ✖
- ambient nature sounds 1
- animated trumpets 1
- breeze 1
- cheerful 1
- cheerful drumming 1
- cheering 1
- congas 1
- dance groove 1
- dance music 1
- dobro 1
- energetic 1
- energetic vocals 1
- enthusiastic 1
- falsetto 1
- female vocalist 1
- festivities 1
- fiddle 1
- funky bass lines 1
- funky basslines 1
- happy 1
- harmonica 1
- high notes 1
- joyful 1
- lively keyboard harmony 1
- male vocals 1
- mandolin 1
- merry 1
- normal voice to falsetto 1
- party song 1
- party whistle 1
- people clapping 1
- plethora of instruments 1
- portugal 1
- rapid change in pitch 1
- rapid singing 1
- resonator 1
- salsa 1
- spirited 1
- tambourine beat 1
- trumpets animated trumpet 1
- vigorous banjo accompaniment 1
- vocal backup 1
musiccaps_names (array) 6 ✖
- Music 2
- Music of Africa 1
- Rattle (instrument) 1
- Singing 1
- Song 1
- Yodeling 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hora Quente com Vencedores Conc. Inter. Kizomba Angola 2012 | A male vocalist sings this high spirited Portugal song. The tempo is fast with keyboard harmony, punchy drumming, groovy bass lines, animated trumpets, backed with harmonica, party whistles, lively vocalisation and vocal backup, tambourine beats and congas. This song is a sonic treat with a plethora of instruments in perfect sync and harmony. It is happy, joyful and merry with a dance groove. | 2012-04-21T00:28:34Z | Samir Gomes | Hora Quente | ["Music of Africa", "Music", "Rattle (instrument)"] | ["male vocals", "fast tempo", "cheerful", "cheerful drumming", "funky basslines", "animated trumpets", "harmonica", "plethora of instruments", "congas", "dance groove", "party song", "festivities", "happy", "joyful", "merry", "tambourine beat", "congas", "party whistle", "trumpets animated trumpet", "vocalisation", "vocal backup", "portugal", "dance music", "salsa", "spirited drumming", "funky bass lines", "lively keyboard harmony"] | 7 | FDO5BekX478 | 1624 | |
Lydia 5 yrs.old wins the Taylor Ware Yodel On Contest!! | A female vocalist sings this rather vigorous country song. The tempo is fast with vocalisation. The vocalist is yodelling vigorously and rhythmically to the accompaniment of an animated banjo, fiddle, resonator and mandolin harmony, vibrant drumming and. | 2008-08-12T02:50:34Z | Epps Music | Lydia yodeling Cowboy Sweetheart at Taylor Ware's Yodel On Contest in Tenn. | ["Singing", "Yodeling", "Music", "Song"] | ["female vocalist", "fast tempo", "falsetto", "high notes", "resonator", "people clapping", "cheering", "breeze", "ambient nature sounds", "energetic vocals", "spirited drumming", "vigorous banjo accompaniment", "mandolin", "fiddle", "dobro", "rapid singing", "energetic", "vocalisation", "spirited", "enthusiastic", "normal voice to falsetto", "rapid change in pitch"] | 7 | GuQFhmGqdog | 1760 |
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;