musiccaps_details (view)

7 rows where musiccaps_aspects contains "happy" and musiccaps_names contains "Music of Latin America"

✎ View and edit SQL

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
Shira Choir Rocking it away with Pinky Weber Music by Pinny Ostreicher A male vocalist sings this spirited song. The tempo is fast with trumpets, keyboard harmony, steady drumming and simple bass lines along with vocal backup. The song is happy, energetic, enthusiastic, popular, peppy, vivacious and celebratory. There are sounds in the background of people talking, hooting, cheering and scuttling and rustling. This is a popular Folk/Regional song. 2015-09-04T19:04:46Z Go Jewish Music At a Siyem in Upstate! ["Singing", "Music", "Ska", "Music of Latin America"] ["male singer", "fast tempo", "vocal backup", "popular songs", "hooting", "rustling", "home video", "amateur recording", "party songs", "foreign language", "lively trumpets", "keyboard harmony", "steady drumming", "straight bass lines", "vocal backup", "people talking", "cheering", "energetic", "happy", "enthusiastic", "home video", "inferior audio quality", "folk song", "regional music", "happy", "peppy", "chirpy"] 7 1hABzqBHh7w 297
Lluvia - Gilberto Sta Rosa, Charlie Aponte, Jerry Rivas by www.latarimadelasalsa.tk A male vocalist sings this spirited Latin song. The tempo is fast with a syncopated piano harmony, spanish guitar accompaniment ,Congas and bongos percussion, pandeira beats , keyboard harmony and vocal backup. The music is a lively, energetic, enthusiastic, passionate, spirited and vital Latin Pop with a dance groove. 2009-09-27T16:38:48Z latarimadelasalsa Saludos Salseros y Salseras del Perú y del mundo este es un espacio dedicado a la Salsa, donde podras encontrar ultimas noticias, musica, videos y todo lo relacionado con el genero que nos apasiona. La Tarima de la Salsa - Perú www.latarimadelasalsa.tk ["Music", "Music of Latin America", "Salsa music"] ["male vocalist", "fast tempo", "latin pop", "world music", "happy", "celebration", "enthusiastic vocals", "syncopated piano", "congas rhythm", "bongos beat", "spanish guitar", "steady bass lines", "vocal backup", "lively", "spirited", "energetic", "enthusiastic", "passionate", "lain pop", "latin dance music", "salsa", "rumba", "bachata", "latin percussion", "pandeireta beats"] 7 68XchGI6H-4 730
Banda San miguel " volvere" The low quality recording features a regional Mexican song that consists of a flat male vocal singing over groovy trombone, shimmering shakers, short brass melody and wooden percussive elements. It sounds emotional, passionate and happy. 2009-04-07T03:20:06Z HEAD SHOOT ["Music", "Music of Latin America"] ["low quality", "short brass melody", "groovy trombone", "shimmering shakers", "regional mexican", "wooden percussive elements", "happy", "emotional", "passionate", "flat male vocal"] 4 LYO7_GxyaZc 2197
Chango - Henry Fiol The Regional Mexican song features a passionate male vocal singing over guiro percussion, followed by wooden percussion, shimmering cymbals, acoustic rhythm guitar in the left channel of the stereo image and bright brass melody in the right channel. It sounds joyful, happy and passionate. 2009-09-17T01:58:57Z Pedro Velazco   ["Music", "Music of Latin America", "Salsa music"] ["regional mexican", "passionate male vocal", "guiro percussion", "wooden percussions", "shimmering cymbals", "bright brass melody", "groovy bass", "acoustic rhythm guitar", "passionate", "happy", "joyful"] 4 UJA5AWbt6HM 2905
Jodłowanie w Maurzycach k. Łowicza. 2003 r. The low quality recording features a mono recording located only in the right channel of the stereo image. It consists of at least brass section melody, shimmering cymbals and melodic female vocals. There are some crowd chattering noises too, but it sounds fun and happy. 2009-03-18T20:56:59Z Łowiczak123 Występ kapeli po zakończeniu przemówienia prezydenta Kwaśniewskiego.Sorry za złą jakość dźwięku-mono. ["Yodeling", "Music", "Music of Latin America"] ["low quality", "mono", "noisy", "brass section", "melodic female vocal", "happy", "fun", "crowd chattering"] 4 _n9boKzVRhs 3491
Hoy yo te pido perdon salsa The low quality recording features a regional Mexican song that consists of a passionate male vocal singing over brass melody, wooden percussions, tinny metallic percussions, groovy piano melody and groovy bass. It sounds joyful, happy and energetic. 2009-04-08T06:41:41Z Edgarcet17 Salsa romantica hoy yo te pido perdon los chicos de la salsa ["Music", "Music of Latin America", "Salsa music"] ["low quality", "regional mexican", "brass melody", "wooden percussions", "tinny metallic percussions", "groovy piano melody", "groovy bass", "passionate male vocal", "joyful", "happy", "energetic"] 4 c3T1gWSVp6c 3676
Roda de Choro | Chorinho pra Você (Severino Araujo) | Instrumental SESC Brasil This music is a lively instrumental. The tempo is fast with an animated clarinet lead, lively spanish guitar rhythm, ukulele accompaniment and bright tambourine /pandeireta beats. The music is upbeat, buoyant, peppy, cheerful, happy, playful and fun Latin Clarinet Instrumental. 2010-10-07T06:57:12Z Instrumental Sesc Brasil A Roda de Choro nasceu na Virada Cultural de 2007, no Auditório Ibirapuera, sob organização de Danilo Brito. Desde sua criação, já aconteceu em diversos teatros e recebeu convidados como Carlos Malta, Laércio de Freitas, Toninho Ferragutti, Ricardo Herz, Danilo Brito, Alessandro Penezzi, Nelson Ayres, Oswaldinho do Acordeon e Gabriel Grossi, entre outros. No repertório, choros clássicos, passando por Pixinguinha, Jacob do Bandolim e algumas composições próprias. Formação: Alexandre Ribeiro - clarinete Léo Rodrigues - pandeiro Milton Mori - cavaquinho Luizinho 7 Cordas - violão 7 cordas Nelson Ayres - piano Toninho Ferragutii - acordeon Gênero: Choro Show que ocorreu no Teatro do Sesc Paulista dia 13/09/2010 • site oficial: https://www.instrumentalsescbrasil.org.br/ • assista aos shows ao vivo pelo https://www.youtube.com/instrumentalsescbrasil Inscreva-se no canal http://www.youtube.com/sescsp e fique por dentro de toda a programação que acontece nas unidades do Sesc no estado de São Paulo. Basta ter uma conta gratuita no Google. ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument", "Music of Latin America"] ["instrumental", "fast tempo", "spirited", "clarinet", "ukele", "cheerful", "light", "perky", "happy", "playful", "latin instrumental music", "live performance", "concert", "wind instrument", "spanish guitar", "cheerful", "upbeat", "latin pop", "lively tambourine beats", "rhythmic acoustic guitar"] 7 c5NGOcNyF4g 3678

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;