musiccaps_details (view)
2 rows where musiccaps_aspects contains "male vocalist", musiccaps_aspects contains "scuffling" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- male vocalist · 2 ✖
- scuffling · 2 ✖
- amateur recording 1
- bachata 1
- bongos 1
- bubbles 1
- cheering 1
- clinking 1
- congas 1
- dance hits 1
- dance music 1
- energetic drumming 1
- female voice talking 1
- home recording 1
- latin dance music 1
- latin song 1
- low audio quality 1
- medium tempo 1
- medium tempo 1
- mexican 1
- muddled audio 1
- muffled sound 1
- people talking 1
- person talking 1
- rock 1
- salsa 1
- sound of water 1
- spanish 1
- spirited 1
- static 1
- steady beat 1
- super imposing background 1
- superimposed sounds over song 1
- tapping sound 1
- trumpets 1
musiccaps_names (array) 5 ✖
- Music 2
- Gurgling 1
- Music of Latin America 1
- Salsa music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Palladium Salsa Social | 13 Marzo | Music by Dj Rumbero | A male vocalist sings this peppy Latin pop song.the tempo is medium with animated trumpets, keyboard harmony and percussions rhythms of bongos, congas and subtle drums. The song is muffled and there are sounds in the background of people talking, cheering, the sound of clinking, scuffling and tapping. The song is super imposed by the background sounds. This song is a latin pop song. | 2015-03-14T07:40:22Z | Jorge Rodriguez | Palladium Salsa Social music by Dj Rumbero a través de YouTube Capture | ["Singing", "Music", "Music of Latin America", "Salsa music"] | ["male vocalist", "medium tempo", "latin song", "super imposing background", "mexican", "cheering", "dance music", "latin dance music", "dance hits", "spanish", "dance music", "congas", "bongos", "trumpets", "steady beat", "salsa", "bachata", "people talking", "clinking", "tapping sound", "scuffling", "low audio quality", "muddled audio"] | 7 | sOyHkcK_lOA | 4947 | |
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;