musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance music" and musiccaps_names contains "Salsa music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- congas 3
- dance music · 3 ✖
- latin dance music 2
- animated piano 1
- bachata 1
- bongos 1
- bouncy 1
- brass band 1
- brass instruments 1
- bright trumpet 1
- buoyant 1
- cheering 1
- clinking 1
- dance hits 1
- energetic 1
- enthusiastic 1
- enthusiastic drumming 1
- fast tempo 1
- female voice 1
- groovy bass lines 1
- keyboard harmony 1
- latin folk 1
- latin music 1
- latin pop 1
- latin song 1
- lively piano 1
- low audio quality 1
- low quality recording 1
- male singer 1
- male vocalist 1
- medium tempo 1
- mexican 1
- moderate tempo 1
- muddled audio 1
- people talking 1
- piano 1
- salsa 1
- salsa song 1
- saxophone 1
- scuffling 1
- seductive rhythm 1
- spanish 1
- spanish guitar 1
- steady beat 1
- super imposing background 1
- tapping sound 1
- trumpet 1
- trumpets 1
- upbeat 1
- vibrant 1
- vigorous 1
- world music 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 3
- Salsa music · 3 ✖
- Music of Latin America 2
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Midtown Music Traditional Salsa | This salsa song features a female voice singing the main melody. This is accompanied by the congas. The beat is a dance beat. Trumpets and a saxophone play fills in between lines. A piano plays a melody at the end of the song. The song starts with the voice singing a melody at a moderate tempo. After the piano plays, the tempo of the song increases. Other instruments cannot be heard as the quality of the recording is low. This song can be played in a Latin dance sequence in a movie. | 2011-10-27T17:36:40Z | MidtownMusicUK | http://www.midtownmusic.co.uk Midtown Music Agency is a bespoke music service based in Midtown London, Supplying the top event acts in the country. | ["Music", "Salsa music"] | ["low quality recording", "salsa song", "congas", "saxophone", "trumpet", "piano", "female voice", "moderate tempo", "dance music", "seductive rhythm"] | 0 | CN2QSmhP-HI | 1358 | |
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 | |
Toño Rosario-El Hot Dog | A male vocalist sings this lively Latino song. The tempo is fast with an animated piano accompaniment, bright trumpets, energetic and rhythmic drumming, groovy bass and keyboard. The song is energetic, lively, buoyant, bouncy, vibrant and vivacious with a dance groove. This song is Latin Pop. | 2011-09-18T02:16:01Z | TheBombers27 | ["Music", "Music of Latin America", "Salsa music"] | ["male singer", "fast tempo", "brass band", "brass instruments", "vibrant", "animated piano", "youthful", "buoyant", "bouncy", "enthusiastic", "energetic", "vigorous", "latin music", "bright trumpet", "groovy bass lines", "keyboard harmony", "enthusiastic drumming", "spanish guitar", "upbeat", "latin pop", "latin dance music", "latin folk", "lively piano", "world music", "congas", "dance music", "latin pop"] | 7 | vMU7ZKY2Eso | 5174 |
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;