musiccaps_details (view)
3 rows where musiccaps_aspects contains "piano", musiccaps_aspects contains "trumpets" and musiccaps_names contains "Salsa music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- piano · 3 ✖
- trumpets · 3 ✖
- cowbell 2
- bass 1
- congas 1
- congo 1
- dance song 1
- drums 1
- e-bass 1
- electronic sound 1
- female voice 1
- instrumental 1
- latin music 1
- medium to uptempo 1
- moderate tempo 1
- no voice 1
- organ 1
- percussion 1
- percussions 1
- salsa 1
- salsa song 1
- saxophone 1
- saxophones 1
- steeldrum 1
- trombone 1
- trombones 1
- upright bass 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Beginners Salsa Steps with Music - Cross Body Lead with Turns | Various percussive instruments are being played. In the foreground stays the cowbell. A trumpet is playing the lead melody while other trumpets are supporting along with a piano playing chords together with an organ sound. A steeldrum is ending the phrase of a melody with his own melody. An e-bass is playing a complex salsa groove. This song may be playing dancing salsa. | 2010-11-08T12:01:58Z | SalsaMish | Salsa Mish & Aiste demonstrating beginners to intermediates salsa steps to a beautiful slow Salsa song from Palenke. By far the best way to learn these moves is to come along to Salsa Mish's classes at Greenwood Park, St Albans - every Friday night. You will have a great time, meet lots of friendly people, hear some fantastic music and lose any inhibitions you may have in no time. See www.salsamish.co.uk for details. | ["Country", "Music", "Music of Latin America", "Bluegrass", "Salsa music"] | ["salsa", "trumpets", "cowbell", "percussions", "steeldrum", "piano", "organ", "e-bass", "medium to uptempo"] | 6 | 9ZinCW4jTeE | 1026 | |
Ain't Nobody (Salsa Version)-Alex Wilson | This salsa song features a female voice singing the main melody. This is accompanied by percussion on a drum kit as well as on a congo. The congo gives this song the salsa feel. The drum kit plays the cowbell and high pitched snare drum to add more of the salsa vibe. The bass plays groovy fills. Trumpets, trombones and saxophones play fills in between lines. They play in harmony. A piano plays jazzy chords in the background. This song can be played in a dance club for a salsa night. | 2010-05-06T09:50:53Z | tsiostini | ["Music", "Music of Latin America", "Salsa music"] | ["salsa song", "female voice", "percussion", "trumpets", "congo", "cowbell", "trombone", "saxophone", "dance song", "bass", "piano", "moderate tempo"] | 0 | gMgN50wSnNc | 4025 | ||
Jerry rivera Para ti | The instrumental latin music features a big band. The trumpets, saxophones and trombones play the same melody but on different pitches. The percussion section includes a drum kit played in the latin style and a pair of congas. A piano accompanies the brass section and blends in with the rest of the band. An electronic sound can be heard playing the same note throughout the music excerpt. | 2007-09-10T07:54:12Z | Donabboy | para ti | ["Music", "Salsa music"] | ["latin music", "trumpets", "trombones", "saxophones", "congas", "piano", "upright bass", "electronic sound", "instrumental", "no voice", "drums"] | 2 | nH_lVl3a3Uw | 4529 |
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;