musiccaps_details (view)
1 row where musiccaps_aspects contains "loud", musiccaps_names contains "Banjo", musiccaps_names contains "Bluegrass" and musiccaps_names contains "Music"
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
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;