musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "percussion" and musiccaps_names contains "Salsa music" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- bass guitar 2
- percussion · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- brass 1
- brazilian 1
- chill 1
- dance 1
- easygoing 1
- energetic 1
- haiti dance 1
- jingle 1
- keyboard 1
- male vocal 1
- male vocals 1
- melodic singing 1
- samba 1
- uplifting 1
musiccaps_names (array) 5 ✖
- Music 2
- Salsa music · 2 ✖
- Afrobeat 1
- Middle Eastern music 1
- Music of Africa 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jingle Ademir Lucas +45 | This is a Brazilian samba piece used as a jingle. The male vocals are singing in a shouting-like manner, repeating a slogan. There is a heavy use of syncopated latin percussion in the rhythmic background. The acoustic guitar and the bass guitar in the background support the melodic structure of the vocals. | 2012-07-22T02:21:22Z | AdemirMais45 | ["Music", "Middle Eastern music", "Salsa music"] | ["samba", "male vocals", "jingle", "percussion", "acoustic guitar", "bass guitar", "brazilian", "energetic", "uplifting"] | 9 | mqyeBqaUeN8 | 4496 | ||
Habri bo brasa ku mini sound band | This is a Haiti dance music piece. There is a male vocalist singing melodically in the Creole language. The brass, the keyboard and the bass guitar are the melodic elements of this piece. In the rhythmic background, the acoustic drums and percussive elements are playing a latin type beat. The atmosphere of the piece is chill and easygoing. This piece could be played at Caribbean bars and dance clubs. It could also be used as an accompaniment piece for dancing courses. | 2009-04-01T15:45:12Z | 3Kin3kin3 | ["Afrobeat", "Music of Africa", "Music", "Salsa music"] | ["haiti dance", "male vocal", "melodic singing", "brass", "keyboard", "bass guitar", "acoustic drums", "percussion", "chill", "dance", "easygoing"] | 9 | qrY7PW5guxk | 4827 |
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;