musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "spanish song" and musiccaps_author = 7 sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 50 ✖
- spanish song · 3 ✖
- folk song 2
- male vocalist 2
- medium tempo 2
- people talking 2
- regional music 2
- acoustic guitar accompaniment 1
- amateur home recording 1
- ambient sounds 1
- cheerful 1
- clapping 1
- dance groove 1
- emphatic vocals 1
- emphatic vocals 1
- entertaining 1
- enthusiastic 1
- fast tempo 1
- female vocalist 1
- groovy bass lines 1
- happy 1
- haunting melody 1
- joyful 1
- latin music 1
- latin song 1
- lilting 1
- live audience 1
- live performance 1
- lively 1
- lively spanish guitar 1
- mellifluous 1
- mellow 1
- minimalist 1
- mystic vibe 1
- pandeireta rhythm 1
- party song 1
- piano accompaniment 1
- popular folk music 1
- popular song 1
- powerful vocals 1
- regional pop 1
- romantic 1
- singing along 1
- slick drumming 1
- soothing 1
- spanish guitar 1
- spanish guitar harmony 1
- vocal backup 1
- vocals 1
- world music 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 3
- Flamenco 2
- Music of Latin America 2
- Singing 2
- Clapping 1
- Musical instrument 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Las Chuches - Amor, amor, amor | A female vocalist sings this romantic song in a foreign language that sounds like Spanish. The tempo is medium with a melodious guitar accompaniment, slick drumming, piano accompaniment, steady bass line and pandeireta rhythm. The song is soft, mellow, catchy, emotional and soothing. This song is a Folk Pop/Regional Pop song. | 2008-07-21T00:44:11Z | Faico90 | Las chuches como siempre derroxando arte | ["Flamenco", "Music", "Music of Latin America"] | ["female vocalist", "medium tempo", "regional pop", "regional music", "folk song", "spanish song", "latin song", "spanish guitar harmony", "groovy bass lines", "slick drumming", "latin music", "piano accompaniment", "pandeireta rhythm", "romantic", "mellifluous", "soothing", "mellow", "world music", "regional music", "dance groove", "vocal backup", "mystic vibe"] | 7 | 7_q36NyJtQY | 863 | |
Sergio el duende ( y yo le canto al amor...) | A male vocalist sings this energetic song. The tempo is fast emphatic vocals, bright acoustic guitar accompaniment and clap beat. The song is youthful, energetic, popular, cheerful, engaging and happy. The music is minimal with ambient sounds of people clapping, cheering, singing along and keeping beat with claps. The audio is distorted and muffled as it is an amateur home recording. | 2013-07-09T13:09:10Z | Maria Luisa Asencio | ["Singing", "Music", "Musical instrument", "Clapping"] | ["male vocalist", "fast tempo", "acoustic guitar accompaniment", "spanish guitar", "lively", "entertaining", "enthusiastic", "party song", "happy", "joyful", "cheerful", "youthful", "clapping", "singing along", "people talking", "emphatic vocals", "amateur home recording", "spanish song", "popular song"] | 7 | PN3Lx8RutmI | 2529 | ||
Juan Fernando canta fandangos de Huelva en Amsterdam | A male vocalist sings this powerful solo in a foreign language. The tempo is medium with a spanish guitar accompaniment. The song has minimalist music with captivating, lilting and almost haunting vocals. This is a live performance with ambient sounds of people talking. The audio quality is inferior as it is an amateur recording. This song is a Latin/Spanish Folk song. | 2010-08-06T14:25:01Z | coroflamenco | Juan Fernando en un concierta del cuadro de cante de la Peña Flamenca de Huelva y del coro flamenco Calle Real en Amsterdam. Toque Antonio Dovao, Ramón Jesús Díaz. Baile: Teresa Jaldón, Director de cine: Stijn van der Loo, studio BBH | ["Singing", "Yodeling", "Flamenco", "Music", "Music of Latin America"] | ["male vocalist", "medium tempo", "spanish song", "minimalist", "folk song", "regional music", "popular folk music", "lively spanish guitar", "emphatic vocals", "powerful vocals", "live performance", "live audience", "ambient sounds", "people talking", "lilting", "haunting melody", "vocals"] | 7 | _zQTlTCqMzs | 3508 |
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;