musiccaps_details (view)

1 row where musiccaps_aspects contains "loud", musiccaps_names contains "Banjo", musiccaps_names contains "Bluegrass" 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
Andean Folk Music; Pan Flute on Madrid Subway 3 November 2012 The low quality recording features harmonized male vocals singing over shimmering shakers, repetitive cowbell hits and acoustic rhythm guitar chord progressions. It is a bit noisy and loud, as it was probably recorded with the phone. 2012-11-22T14:03:42Z D3Services While on the Madrid subway with my daughter on 3rd November of 2012, these musicians were playing what many know as Simon and Garfunkel's "If I Could". While I like Simon and Garfunkel, this music is ancient from the Andes Mountains in Peru (think Machu Picchu) and it is so very beautiful. This was filmed using the video feature of the new Apple iPhone 5 and I was resting the phone on one of the vertical hand rails that you can see in the video. We each gave them one Euro. I did not catch their name. Their music indigenous to that wonderful, mysterious part of the World. Please also see El Condor Pasa, an Inca Dance: http://gogeometry.com/incas/video_condor_pasa_music.htm And now go back and listen to Simon and Garfunkel's If I Could. ["Banjo", "Music", "Bluegrass"] ["low quality", "harmonizing male vocals", "shimmering shakers", "cowbell hits", "acoustic rhythm guitar chords progression", "traditional", "noisy", "loud"] 4 5xIBQGMjiX4 708

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;