musiccaps_details (view)
4 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "piano" and musiccaps_names contains "Salsa music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- bass · 4 ✖
- piano · 4 ✖
- cowbell 2
- dance song 2
- male voice 2
- moderate tempo 2
- percussion 2
- salsa song 2
- amateur recording 1
- brass section 1
- claves 1
- congas 1
- congo 1
- cover song 1
- crowd cheering/whistling 1
- female voice 1
- latin pop 1
- low quality audio 1
- mixed voices singing 1
- romantic mood 1
- salsa 1
- saxophone 1
- slow dance song 1
- trombone 1
- trumpet/trombone 1
- trumpets 1
musiccaps_names (array) 5 ✖
- Music 4
- Salsa music · 4 ✖
- Music of Latin America 3
- Music of Africa 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Orq. Bronco - Duena De Mi Cuerpo | This Latin pop song features a male voice singing the main melody. The voice sings at a high pitch. This is accompanied by Latin style percussion. A variety of percussion is used including the claves and cowbell. The bass plays a groovy bassline. The piano plays chords with a Latin feel. The brass section plays fills in between lines. This song has a romantic mood. This song can be played in a party for a slow dance. | 2010-03-26T03:09:29Z | EdwardMulenze | gran orquesta venezolana de finales de los 80.. se caracteriza por la finura y la cuerda de sus trombones disfrutenlo... | ["Music", "Music of Latin America", "Salsa music"] | ["latin pop", "male voice", "slow dance song", "bass", "percussion", "piano", "brass section", "romantic mood", "claves"] | 0 | 92QYLjfo68Q | 972 | |
Hotel California , Marc Anthony - Salsa Version | This salsa song features a male voice singing the main melody. This is accompanied by percussion playing a salsa beat. The piano plays a typical salsa rhythm using the main chords for the song. The bass plays the root note and fifth of the chord. Due to the low quality of the audio, other instruments are not audible. This is a cover song of another famous song. This song can be played for a salsa dance. | 2011-05-31T22:04:34Z | Saleh AL-Enizi - EL SENYOUR | On a dark desert highway, cool wind in my hair Warm smell of colitas, rising up through the air Up ahead in the distance, I saw a shimmering light My head grew heavy and my sight grew dim I had to stop for the night There she stood in the doorway; I heard the mission bell And I was thinking to myself, this could be heaven or this could be hell Then she lit up a candle and she showed me the way There were voices down the corridor, I thought I heard them say... Welcome to the hotel california Such a lovely place Such a lovely face Plenty of room at the hotel california Any time of year, you can find it here Her mind is tiffany-twisted, she got the mercedes bends She got a lot of pretty, pretty boys, that she calls friends How they dance in the courtyard, sweet summer sweat. Some dance to remember, some dance to forget So I called up the captain, please bring me my wine He said, we haven't had that spirit here since nineteen sixty nine And still those voices are calling from far away, Wake you up in the middle of the night Just to hear them say... Welcome to the hotel california Such a lovely place Such a lovely face They livin' it up at the hotel california What a nice surprise, bring your alibis Mirrors on the ceiling, The pink champagne on ice And she said 'we are all just prisoners here, of our own device' And in the master's chambers, They gathered for the feast The stab it with their steely knives, But they just can't kill the beast Last thing I remember, I was Running for the door I had to find the passage back To the place I was before 'relax,' said the night man, We are programmed to receive. You can checkout any time you like, But you can never leave! | ["Singing", "Music of Africa", "Music", "Salsa music"] | ["salsa song", "male voice", "piano", "bass", "low quality audio", "moderate tempo", "cover song", "dance song"] | 0 | D7z2Q-hH25s | 1441 | |
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 | ||
Alexei Ramos, Anderson Mendes e Paulo Burracha - Ave Maria Que Calor | Someone is playing a cowbell along with other percussion such as congas along to a pumping bassline. A piano and a brass section are playing a countermelody to the female and male voices singing. In the background you can hear people cheering and whistling. This is an amateur recording and of poor audio-quality. This song may be playing on a dancefloor. | 2011-10-01T15:30:51Z | Emília Pedra | Aniversario Dj Zé do Lago | ["Music", "Music of Latin America", "Salsa music"] | ["salsa", "amateur recording", "bass", "cowbell", "congas", "mixed voices singing", "piano", "trumpet/trombone", "crowd cheering/whistling"] | 6 | wsJ5ZLKiPzs | 5289 |
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;