musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording", musiccaps_names contains "Music of Latin America" and musiccaps_names contains "Salsa music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- amateur recording · 2 ✖
- acoustic guitar 1
- bass 1
- congas 1
- cowbell 1
- crowd cheering/whistling 1
- crowd voice 1
- folk dance music 1
- folk music 1
- mixed voices singing 1
- no percussion moderate tempo 1
- piano 1
- salsa 1
- trumpet/trombone 1
- violin music 1
- whistles 1
musiccaps_names (array) 4 ✖
- Music 2
- Music of Latin America · 2 ✖
- Salsa music · 2 ✖
- /t/dd00032 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Folk Dance-House Music - Hungary (38) | This amateur recording features folk music being played on violins. There are multiple violins playing in harmony. The tempo is moderate. There is no percussion in this song. Crowd voices and whistles can be heard during the performance. This song is played for a folk dance. | 2011-02-15T08:59:13Z | HUNGARIAN and other TRADITIONS | Táncház a XVI. Bakony Néptáncfesztiválon. Játszik a Heveder zenekar ( Sepsiszentgyörgy ), Ajka 2010.11.05. | ["Music", "Music of Latin America", "Salsa music", "/t/dd00032"] | ["amateur recording", "violin music", "acoustic guitar", "crowd voice", "whistles", "folk music", "folk dance music", "no percussion moderate tempo"] | 0 | NNeEzTVATHg | 2333 | |
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;