musiccaps_details (view)

3 rows where musiccaps_aspects contains "vibrant", musiccaps_author = 9 and musiccaps_names contains "Flamenco"

✎ 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
LEGENDARY MUSICIANS OF OLD HAVANA Pt 3 This is an afro-cuban folk music compilation. There are male vocals singing in an energetic manner. There are acoustic guitars playing the main themes while upright bass is used for the lower range. The rhythmic background is provided by a variety of latin percussive instruments. There is a vibrant atmosphere. Parts of this recording can be used in latin dance courses as accompaniment pieces. 2007-08-30T02:04:47Z chak bay Grande MORE of Alma de Cuba with Angel Abreu singing Meneame la cuna and El Manisero ["Flamenco", "Music"] ["afro-cuban", "folk", "latin dance", "male vocals", "acoustic guitar", "upright bass", "latin percussion", "dance", "vibrant", "energetic", "lively"] 9 6AC84nr6ckM 732
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

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;