musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic drumming" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- energetic drumming · 2 ✖
- male vocalist 2
- spirited · 2 ✖
- amateur recording 1
- animated 1
- bass kazoo 1
- bubbles 1
- energetic 1
- engaging 1
- fast tempo 1
- female voice talking 1
- funky bass 1
- galloping rhtyhm 1
- groovy bass 1
- home recording 1
- kazoo lead 1
- keyboard accompaniment 1
- lively 1
- medium tempo 1
- muffled sound 1
- person talking 1
- rock 1
- scuffling 1
- sound of water 1
- static 1
- superimposed instrumental 1
- superimposed sounds over song 1
- vibrations 1
- vivacious 1
- vivacious electric guitar harmony 1
musiccaps_names (array) 3 ✖
- Music 2
- Gurgling 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 |
---|---|---|---|---|---|---|---|---|---|---|
Kazoo bass slap | a male vocalist sings this enthusiastic swing pop. The tempo is fast with an enthusiastic electric guitar harmony, energetic drumming, funky bass lines, keyboard harmony, emphatic vocals superimposed by an infectious Bass kazoo melody. The song is energetic, enthusiastic, youthful, fun , groovy, vivacious and chirpy. | 2011-02-26T17:39:54Z | Magublican TV | http://fraserdaley.com | ["Music", "Salsa music"] | ["male vocalist", "fast tempo", "energetic drumming", "keyboard accompaniment", "vivacious electric guitar harmony", "groovy bass", "galloping rhtyhm", "funky bass", "kazoo lead", "bass kazoo", "vibrations", "superimposed instrumental", "lively", "spirited", "animated", "vivacious", "engaging", "energetic"] | 7 | ZFimyfPWltk | 3354 | |
HZO Water Blocking Technology Demo | A male vocalist sings this energetic song. The tempo is fast with enthusiastic drumming , rhythmic electric and keyboard harmony. The song is muffled because of poor audio quality and several sounds that are superimposed on it. There are sounds of water, static, bubbles, scuffling and a female voice speaking. The song is incoherent but from what can be heard it sounds like Pop Rock. | 2011-08-18T19:44:40Z | ZAGGTV | HzO introduces its new WaterBlock technologies. HzO coatings enhance and protect devices from smartphones to textiles to important documents. HzO prevents damage caused by water; electronic devices remain fully functional after exposure. This video demonstrates the power of one of its WaterBlocking technologies. | ["Music", "Gurgling"] | ["male vocalist", "medium tempo", "spirited", "scuffling", "bubbles", "sound of water", "static", "person talking", "superimposed sounds over song", "muffled sound", "home recording", "amateur recording", "rock", "energetic drumming", "female voice talking"] | 7 | zjsWFvUkh7M | 5508 |
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;