musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance music" and musiccaps_aspects contains "marimba"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- dance music · 2 ✖
- marimba · 2 ✖
- bad sound quality 1
- bass 1
- brass band 1
- caribbean music 1
- groovy rhythm 1
- happy mood 1
- home music video 1
- instrumental squid 1
- latin dance hits 1
- latin dance music 1
- latin percussions 1
- male backing voices 1
- male singer 1
- male voice 1
- medium tempo 1
- moderate tempo 1
- people dancing 1
- programmed percussion 1
- reggae feel 1
- saxophone harmony 1
- saxophones 1
- syncopated rhythms 1
- traditional latin dance 1
- trumpets 1
- wooden xylophone 1
musiccaps_names (array) 5 ✖
- Afrobeat 1
- Brass instrument 1
- Music 1
- Music of Africa 1
- Saxophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mabermuda-Vuthu Marabenta (mocambique musica) | This song features a male voice singing the main melody. Other male voices sing fills in between lines as backing voices. A repetitive melody is played on the marimba. The percussion is programmed and the focus is on the continuous hi-hat strokes. The bass plays the root notes of the chords. The mood of this song is happy. This song can be played at a dance party. | 2012-07-18T16:56:33Z | DOPEITSDAZ MUSIC | ["Afrobeat", "Music of Africa", "Music"] | ["caribbean music", "dance music", "reggae feel", "programmed percussion", "bass", "male voice", "male backing voices", "marimba", "moderate tempo", "happy mood"] | 0 | G9gsCU85c8k | 1695 | ||
Marimba Perla de Chiapas 2010 abeja miope | The song is an instrumental. The tempo is medium with a brass including trumpets and saxophones playing in harmony, wooden xylophones and Latin percussions play accompaniment to the band along with a male singer. The song is exciting and groovy. The audio quality is poor and probably a home recording. | 2010-01-15T12:34:08Z | Jawar TresCeros | Marimba Perla de Chiapas 2010 abeja miope | ["Brass instrument", "Saxophone"] | ["marimba", "latin dance music", "saxophones", "medium tempo", "instrumental squid", "traditional latin dance", "brass band", "trumpets", "groovy rhythm", "syncopated rhythms", "dance music", "people dancing", "male singer", "saxophone harmony", "wooden xylophone", "bad sound quality", "home music video", "latin dance hits", "latin percussions", "medium tempo"] | 1 | gb8PG-5i5YI | 4040 |
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;