musiccaps_details (view)

4 rows where musiccaps_aspects contains "spanish", musiccaps_author = 9 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
MARIA TOLEDO- La loca (en directo desde el Teatro Lope de Vega de Sevilla) This is a flamenco music piece being performed live. There is a female vocalist singing passionately in the Spanish language. The acoustic guitar is playing the melodic background while the rhythmic background is played by the cajon percussion and a group of musicians clapping in a syncopated manner. The atmosphere is vibrant and agitated. This piece could be used in the soundtrack of a soap opera or a romance/drama movie. It could also be playing in the background at a Spanish/Latin American cuisine restaurant. 2011-11-18T17:11:15Z MARÍA TOLEDO Maria Toledo cantó en el teatro Lope de Vega de Sevilla el día 14-10-2011 junto a Jesús de Rosario a la guitarra, Lucky Losada al cajón y Amparo Lagares, Luis Carrasco Juan Diego y Juan Grande al compás. Vestida por Vicky Martín Berrocal Grabación video: Miguel Ángel Cárdaba. ["Singing", "Flamenco", "Music", "Music of Latin America"] ["flamenco", "live performance", "female vocal", "passionate singing", "acoustic guitar", "cajon", "claps", "vibrant", "emotional", "agitated", "spanish"] 9 C8VECv8kicU 1336
Antonio José canta por fandangos (Directo Málaga) This is the live performance of a flamenco music piece. There is a male vocalist singing passionately in the Spanish language. An acoustic guitar strums a characteristic flamenco tune. Sounds of the crowd cheering can be heard in the background. The atmosphere is vibrant. 2015-04-27T20:37:09Z Carmen SV Concierto sala Tenessee (Málaga) 26/04/2015 ["Singing", "Flamenco", "Guitar", "Music", "Speech", "Music of Latin America"] ["flamenco", "live performance", "spanish", "male vocal", "passionate singing", "acoustic guitar", "crowd cheering", "emotional", "vibrant"] 9 GUwBLItoJXk 1727
CON EL ( HOMERO ) SALSA VIEJA This is a Latin salsa dance music piece. There are male vocals singing loudly in the Spanish language. There is a groovy bass line. The rhythmic background is provided by the cowbell strokes. The atmosphere is lively. This piece could be used as an accompaniment piece for a Latin dance course. 2011-03-28T18:31:20Z noe montiel   ["Music", "Music of Latin America", "Salsa music"] ["latin dance music", "salsa", "male vocals", "loud singing", "spanish", "bass guitar", "latin percussion", "cowbell", "lively", "vibrant"] 9 LWLLN9INTII 2196
Joropo Maracas jamming #2 This is an amateur recording of a percussive jam over a backing track that has the acoustic guitar and hollering male vocals singing in the Spanish language, iconic features of latin folk music. Two pairs of maracas are being played to create the rhythm. 2013-05-22T02:59:20Z tonydven Twelve year old Edgar Sebastian Bermejo of Bogota, Colombia shows how to play joropo maracas with real style. Little Johan is learning too. ["Music", "Music of Latin America", "Maraca"] ["maracas", "latin percussion", "jam", "male vocals", "spanish", "acoustic guitar", "latin music"] 9 bpKbpKZB0Q0 3653

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;