musiccaps_details (view)
3 rows where musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Music of Latin America"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| recuerdos la arrolladora | This Regional Mexican song features a live recording of a male voice singing the main melody. The song starts with the cymbal played once and held so that it does not ring. Then the male voice sings one line with the crowd. The crowd shouts out in joy after a line is sung. The bass is played on a tuba. This is followed by trumpets playing a high pitched melody. This song is at a slow tempo. Apart from the initial cymbal sound, no other percussion is played. This song can be played in a romantic movie. | 2009-09-24T06:59:11Z | Luck Jimenez | ["Swing music", "Music", "Music of Latin America"] | ["regional mexican", "male voice", "crowd sound", "tuba", "trumpets", "cymbal", "slow tempo", "no string instruments", "romantic mood"] | 0 | JbWaSZPOh18 | 2023 | ||
| Musica Romantica | This pop song features a male voice singing the main melody. This is accompanied by percussion playing a simple beat. The hi-hat is played in eighth notes. The bass is played on a tuba. The root notes of the chords are played. Trumpets play a staccato note at every alternate beat. A brass instrument plays a fill after the first two bars. The mood of this song is romantic. This song can be played in a romantic movie. | 2012-10-15T23:45:23Z | El Guapo | Musica Romantica | ["Swing music", "Music", "Music of Latin America"] | ["slow song", "pop song", "romantic mood", "male voice", "slow tempo", "tuba", "trumpets", "simple percussion"] | 0 | MeA8CSKAuvw | 2285 | |
| 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;