musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "salsa"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- medium tempo · 2 ✖
- salsa · 2 ✖
- bachata 1
- bongos 1
- cheering 1
- clinking 1
- congas 1
- couples dancing 1
- dance hits 1
- dance music 1
- emotional 1
- groovy bass line 1
- keyboard accompaniment 1
- keyboard harmony 1
- latin dance music 1
- latin folk music 1
- latin percussions 1
- latin romantic hits 1
- latin song 1
- love songs 1
- low audio quality 1
- male singer 1
- male vocalist 1
- mexican 1
- muddled audio 1
- mysterious 1
- passionate 1
- passionate song 1
- people talking 1
- poor audio quality 1
- romantic 1
- scuffling 1
- spanish 1
- spirited singing 1
- steady beat 1
- super imposing background 1
- tapping sound 1
- trumpets 1
- trumpets playing 1
- various percussion hits 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SALSA CLASICA ROMANTICA MIX RONNY MUSIC | A male singer sings this Latin melody. The song is medium tempo with a groovy Latin percussive rhythm, keyboard accompaniment, brass band harmony and a groovy bass line. The song is romantic and emotional. The song is a salsa dance hit, but has poor audio quality issues.. | 2011-09-30T01:08:54Z | ronnymusic01 | BY DJ RONNY MUSIC | ["Music", "Middle Eastern music", "Salsa music"] | ["salsa", "latin folk music", "male singer", "spirited singing", "emotional", "couples dancing", "passionate song", "mysterious", "latin percussions", "trumpets playing", "medium tempo", "various percussion hits", "keyboard harmony", "romantic", "love songs", "latin romantic hits", "keyboard accompaniment", "poor audio quality", "passionate", "groovy bass line"] | 1 | DKflAAykh6A | 1464 | |
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 |
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;