musiccaps_details (view)

5 rows where musiccaps_aspects contains "flamenco", musiccaps_author = 6 and musiccaps_names contains "Music"

✎ 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
Flamenco belly dance fusion music Two acoustic guitars are strumming flamenco chords being panned to the left and right side of the speakers. A soft bass is playing subnotes. Percussive instruments are building up tension at the end. 2013-03-16T08:30:44Z Lily Vahid ["Traditional music", "Flamenco", "Music", "Music of Latin America", "Dance music"] ["flamenco", "acoustic guitars", "upright/e-bass", "percussion's", "medium tempo"] 6 9EUXyEQZqLo 985
Flamenco Rumba in E Major Improvisation Stefan Schyga This audio contains various acoustic guitars playing a lead melody, a countermelody and strumming chords. An acoustic drum is holding a simple bossa nova groove along with shaker and percussion. This song may be played live outside by a busker. 2010-03-01T03:37:32Z guitarlessons Spotify: https://open.spotify.com/album/2YGyrJdCPMjhol3ZcwZ0Pi?si=5PC6HAKvTSixB6tcFwikSA Pandora: https://pandora.app.link/pgX82c2qX7 Apple Music: https://geo.music.apple.com/us/artist/stefan/19320100?mt=1&app=music Here's a melodic improvisation on a nice chord progression in the key of E Major. The tabs for the solo, scales chords etc are available for free on my site: LearnHowToPlayGuitar.com The guitar is a Flamenca Negra by my friend Francisco Navarro. ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument", "Classical music"] ["flamenco", "acoustic guitars", "shaker", "acoustic drums", "percussion", "medium tempo"] 6 Mhvgz5AjV3U 2289
BOLEROS CON GUITARRA FLAMENCA Someone is playing an acoustic guitar flamenco style finger-picking while a female voice sings loud and emotionally. This song may be playing live in a restaurant. This is an amateur recording. 2012-10-31T16:51:52Z Olga Chito NANI CANTANDO, Y JONI A LA GUITARRA ["Guitar", "Music", "Musical instrument", "Opera", "Strum", "Plucked string instrument"] ["flamenco", "acoustic guitar", "female voice singing", "sensual", "emotional"] 6 OjoDuBkPDM8 2463
Guitar Rumba Flamenco Latin Jazz John Gilliat Someone is playing an acoustic guitar with flamenco techniques and melodies. In the background you can hear someone playing shakers. This recording contains a little bit of reverb on the instruments. This song may be playing as a live performance. 2007-10-18T07:29:08Z John Gilliat Would you like to learn HOW TO PLAY GUITAR WITHOUT AT GUITAR? Go to https://www.yourguitarschool.com for a FREE course!v For more information about John visit: https://www.johngilliat.com For Skype Guitar Lessons with John visit: https://www.johngilliat.com/lessons Performance Live, Solo Guitar with a Roland RC50 loop station. The song is Titled Nachos from John's cd Freedom. A special thanks to everyone at Spotlight: Pat Rogers, Janet Law, Alecis MacPherson & Kevin Adlem at Delta Cable. ["Flamenco", "Guitar", "Jazz", "Music", "Musical instrument"] ["flamenco", "acoustic guitar", "shakers", "medium tempo"] 6 Wgf7UYPVoAo 3123
Flamenco Duo, Bulerías Someone is playing a melody on an acoustic guitar and someone another melody on a oud. The two melodies complement each other. This song may be playing in a live presentation. 2011-05-29T08:10:47Z Mundo Flamenco Mariano Martin and Amir John Haddad played this "Bulerías" in may 2011, during a recording session for the website of Mundo Flamenco. Mariano plays a Francisco Barba Caviuna guitar with top of spruce and Amir plays an old arabian lute (Ud) from his father. ["Flamenco", "Guitar", "Music", "Mandolin", "Musical instrument"] ["flamenco", "acoustic guitar", "oud", "medium to uptempo"] 6 t6jlx6jAb-Q 5007

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;