musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur recording" and musiccaps_names contains "Salsa music" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- amateur recording · 3 ✖
- bass 2
- acoustic guitar 1
- congas 1
- cowbell 1
- crowd cheering/whistling 1
- crowd voice 1
- electronic drums 1
- folk dance music 1
- folk music 1
- male rapping/singing voice 1
- mixed voices singing 1
- no percussion moderate tempo 1
- piano 1
- ragga/drum&bass 1
- salsa 1
- synthesizer lead 1
- trumpet/trombone 1
- violin music 1
- whistles 1
musiccaps_names (array) 5 ✖
- Music 3
- Salsa music · 3 ✖
- Music of Latin America 2
- /t/dd00032 1
- Jingle (music) 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Big Up Kemp Europe 2013. Workshop by Fatou Tera. Busy Signal - Life goes on | The drums sound complex and fast paced going into the direction of drum&bass. Full of hihat and snare hits. Barely noticeable a synthetic bass is playing along with the drums giving this song a ragga feeling. A very simple synthesizer pad is playing a high pitched melody. The male voice sounds lower and energetic. This recording is of poor audio quality. This song may be playing at a dancing event or while working out. | 2013-09-11T14:25:26Z | BIG UP PRODUCTION | Big Up Kemp is the first international dancehall camp in the world organized by Big Up Production. It was first organized in 2011 and became the biggest dancehall camp in the world. In 2013 Big Up Kemp will again take place in Russia and France! TWO camps, more teachers, more dancehall!!... Join us!! WWW.BIGUPKEMP.COM | ["Jingle (music)", "Music", "Salsa music"] | ["ragga/drum&bass", "amateur recording", "electronic drums", "synthesizer lead", "male rapping/singing voice", "bass"] | 6 | FsCQmTluSDw | 1667 | |
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 |
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;