musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "male vocal", musiccaps_aspects contains "melodic singing" and musiccaps_names contains "Music of Latin America"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 19 ✖
- male vocal · 2 ✖
- melodic singing · 2 ✖
- acoustic drums 1
- acoustic guitar sample 1
- bass guitar 1
- electronic drums 1
- groovy 1
- latin percussion 1
- latin pop music 1
- minor key 1
- neo-soul 1
- piano 1
- salsa 1
- sensual 1
- slow tempo 1
- strong bass 1
- trumpet 1
- urban 1
- voices shouting 1
musiccaps_names (array) 5 ✖
- Music 2
- Music of Latin America · 2 ✖
- Hip hop music 1
- Salsa music 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Majid vs Mels { Show Yaa Best of the Best } Final Vol 1 | This is a neo-soul music piece playing under the background of a dance contest. There is a male vocalist singing melodically in the lead. There is a repeating acoustic guitar sample in the beat. A strong bass sound can be heard. The rhythm consists of an electronic drum beat. There are voices shouting over the music in the video. The atmosphere is groovy and urban. | 2014-06-29T08:39:46Z | Showyaa Bestofthebest | Majid Vs Mels Show Yaa Best Of The Best Final Best of the Best Battles Winner : Majid old future | ["Music", "Music of Latin America", "Hip hop music", "Steelpan"] | ["neo-soul", "male vocal", "melodic singing", "acoustic guitar sample", "strong bass", "electronic drums", "voices shouting", "groovy", "urban", "minor key"] | 9 | apA0IY_5-2g | 3575 | |
Cristian Gonzalez y Orquesta La Bohemia - Cuanto Daria (Official Music Video) | This is a latin pop music piece with a salsa beat. There is a male vocalist singing melodically in the lead. The melody is being played by an orchestra composed of the trumpet, the piano and the bass guitar. The rhythmic background is provided by a mild acoustic drum beat with heavy use of latin percussive elements. The piece has a sensual atmosphere. This music could go well in a Latin American soap opera soundtrack where there is a hopeless situation for one of the characters. | 2011-07-18T21:24:33Z | Cristian Gonzalez y Orquesta La Bohemia | Disfruta el vídeo oficial del éxito de la salsa romántica "Cuanto Daria" de Cristian Gonzalez y Orquesta La Bohemia, la mejor salsa romántica para bailar gozar y dedicar con amor. 🔔 Activa las notificaciones para mantenerte actualizado con nuevos videos y estrenos! Suscríbete a mi Canal de YouTube: http://Disetti.co/YTCristianGonzalezyOrquestalaBohemia 🎶 Escucha la mejor Playlists de Salsa Romántica y Sensual: http://Disetti.co/SalsaRomanticaySensual ❤️ 🎧 Escucha mi música en tu Plataforma Favorita: http://Disetti.co/CristianGonzalezyOrquestalaBohemia/ Spotify: http://Disetti.co/SpotifyCristianGonzalezyOrquestalaBohemia Apple Music: http://Disetti.co/AppleMusicCristianGonzalezyOrquestalaBohemia Deezer: http://Disetti.co/DeezerCristianGonzalezyOrquestalaBohemia 👉Sígueme en RRSS: https://www.instagram.com/CristianGonzalezyLaBohemia/ https://www.facebook.com/RickyLoveOficial https://www.twitter.com/orqlabohemia Visita: https://www.Disetti.com/ #CuantoDaria #CristianGonzalezyOrquestaLaBohemia #DisettiMusic (C) 2022 Cristian Gonzalez y Orquesta La Bohemia. Todos los derechos reservados | ["Music", "Music of Latin America", "Salsa music"] | ["latin pop music", "salsa", "male vocal", "melodic singing", "trumpet", "acoustic drums", "piano", "bass guitar", "latin percussion", "sensual", "slow tempo"] | 9 | hYy0na5oUzE | 4118 |
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;