musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance music" and musiccaps_aspects contains "trumpets"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- dance music · 3 ✖
- trumpets · 3 ✖
- latin dance music 2
- medium tempo 2
- bachata 1
- bad sound quality 1
- bongos 1
- brass band 1
- cheering 1
- clinking 1
- congas 1
- dance hits 1
- groovy rhythm 1
- home music video 1
- instrumental squid 1
- keyboard 1
- latin dance hits 1
- latin percussions 1
- latin song 1
- low audio quality 1
- low quality audio 1
- male singer 1
- male vocalist 1
- male voice 1
- marimba 1
- mexican 1
- muddled audio 1
- people dancing 1
- people talking 1
- percussion 1
- salsa 1
- salsa song 1
- saxophone harmony 1
- saxophones 1
- scuffling 1
- spanish 1
- steady beat 1
- super imposing background 1
- syncopated rhythms 1
- tapping sound 1
- traditional latin dance 1
- wooden xylophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Salsa at Mango's Tropical Cafe, Miami South Beach, FL | This low quality audio features a salsa song. A male voice sings the main melody. The audio starts off with a solo being played on a trumpet. This is accompanied by percussion playing a salsa beat. A keyboard plays chords in salsa style. Other instruments are not heard clearly due to the low quality of the audio. | 2009-08-16T21:50:59Z | Alex Kronenberg | Salsa at Mango's Tropical Cafe, Miami South Beach, FL 11.08.2009 | ["Flamenco", "Music of Latin America"] | ["low quality audio", "salsa song", "male voice", "trumpets", "dance music", "keyboard", "percussion"] | 0 | 72_Hk1cdoxk | 805 | |
Marimba Perla de Chiapas 2010 abeja miope | The song is an instrumental. The tempo is medium with a brass including trumpets and saxophones playing in harmony, wooden xylophones and Latin percussions play accompaniment to the band along with a male singer. The song is exciting and groovy. The audio quality is poor and probably a home recording. | 2010-01-15T12:34:08Z | Jawar TresCeros | Marimba Perla de Chiapas 2010 abeja miope | ["Brass instrument", "Saxophone"] | ["marimba", "latin dance music", "saxophones", "medium tempo", "instrumental squid", "traditional latin dance", "brass band", "trumpets", "groovy rhythm", "syncopated rhythms", "dance music", "people dancing", "male singer", "saxophone harmony", "wooden xylophone", "bad sound quality", "home music video", "latin dance hits", "latin percussions", "medium tempo"] | 1 | gb8PG-5i5YI | 4040 | |
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;