musiccaps_details (view)
3 rows where musiccaps_aspects contains "bass", musiccaps_author = 6 and musiccaps_names contains "Salsa music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- bass · 3 ✖
- amateur recording 2
- congas 1
- cowbell 1
- crowd cheering/whistling 1
- dancemusic 1
- digital trumpet/guitar sound 1
- electronic drums 1
- male rapping/singing voice 1
- male voices singing 1
- mixed voices singing 1
- organ 1
- percussions 1
- piano 1
- ragga/drum&bass 1
- salsa 1
- shakers 1
- slower tempo 1
- synthesizer lead 1
- trumpet/trombone 1
musiccaps_names (array) 6 ✖
- Music 3
- Salsa music · 3 ✖
- Jingle (music) 1
- Music of Africa 1
- Music of Latin America 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Ebenezer Obey- Ota Mi Dehin Lehin Mi | This audio contains a lot of percussion such as shakers panned to both sides of the speakers. An organ is playing a melody panned to the left side and a digital trumpet/guitar sound is playing a melody panned to the right side of the speakers. A soft percussion sound is creating a bassline while male voices are singing as a choir and a main singer in the foreground. This song may be playing as a live performance in an african country. | 2012-09-26T13:03:04Z | Olatokunbo Daramola, Jr. | Evergreen Songs Original 1, Track 6 | ["Music of Africa", "Music", "Song", "Salsa music"] | ["dancemusic", "percussions", "shakers", "male voices singing", "bass", "organ", "digital trumpet/guitar sound", "slower tempo"] | 6 | vQ09gQBt1IU | 5181 | |
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;