musiccaps_details (view)
3 rows where musiccaps_aspects contains "noisy", musiccaps_aspects contains "shimmering shakers" and musiccaps_aspects contains "traditional"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- low quality 3
- noisy · 3 ✖
- shimmering shakers · 3 ✖
- traditional · 3 ✖
- mono 2
- passionate 2
- sustained strings melody 2
- acoustic rhythm guitar chords progression 1
- clapping 1
- cowbell hits 1
- emotional 1
- flat male vocal 1
- harmonizing male vocals 1
- loud 1
- monotone female vocal 1
- passionate female vocal 1
- soulful 1
- vintage 1
- wobble bass 1
- wooden percussions 1
- wooden percussive elements 1
musiccaps_names (array) 9 ✖
- Music 3
- Banjo 1
- Bluegrass 1
- Carnatic music 1
- Folk music 1
- Middle Eastern music 1
- Music of Bollywood 1
- Singing 1
- Song 1
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 | |
VERY POPULAR OLD PAKISTANI PUNJABI SONG SINGER MADAM NOOR JAHAN YouTube | The low quality recording features a traditional song that consists of passionate female vocal singing over sustained string melody, wobble bass, wooden percussive elements and shimmering shakers. It is a bit noisy, in mono and it sounds vintage, passionate, emotional and soulful. | 2013-06-19T20:26:26Z | KHALIQ Husson | ["Singing", "Carnatic music", "Music", "Middle Eastern music", "Song", "Music of Bollywood"] | ["wobble bass", "wooden percussive elements", "shimmering shakers", "passionate female vocal", "sustained strings melody", "traditional", "vintage", "noisy", "low quality", "passionate", "emotional", "soulful", "mono"] | 4 | 7_Sr2zv1sQc | 862 | ||
Ram Prasad Khanal's nepali folk song Tihar ko deusi bhailo-2 | The low quality recording features a traditional song that consists of a flat male vocal, alongside monotone female vocal, singing over sustained strings melody, wooden percussion, shimmering shakers and some claps. It sounds passionate and the recording is in mono and noisy. | 2007-09-26T01:04:39Z | Ram Prasad Khanal | Ram Prasad Khanal's nepali folk song Tihar ko deusi bhailo-2 | ["Folk music", "Music"] | ["low quality", "noisy", "mono", "clapping", "flat male vocal", "monotone female vocal", "wooden percussions", "shimmering shakers", "traditional", "sustained strings melody", "passionate"] | 4 | FKBryvLMTY4 | 1635 |
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;