musiccaps_details (view)
3 rows where musiccaps_aspects contains "congas" and musiccaps_aspects contains "piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- congas · 3 ✖
- piano · 3 ✖
- amateur recording 1
- bass 1
- cowbell 1
- crowd cheering/whistling 1
- dance music 1
- drums 1
- electronic sound 1
- female voice 1
- instrumental 1
- latin music 1
- low quality recording 1
- mixed voices singing 1
- moderate tempo 1
- no voice 1
- salsa 1
- salsa song 1
- saxophone 1
- saxophones 1
- seductive rhythm 1
- trombones 1
- trumpet 1
- trumpet/trombone 1
- trumpets 1
- upright bass 1
musiccaps_names (array) 3 ✖
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 | |
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 | |
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;