musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "mono", musiccaps_aspects contains "wooden percussions" 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 |
---|---|---|---|---|---|---|---|---|---|---|
`` Da Hujrey Mijlas `` | The low quality recording features a live performance of a traditional song that consists of harmonizing male vocals singing over plucked strings melody and wooden percussion. It sounds passionate and soulful, but the recording is very noisy and in mono. | 2009-12-19T20:50:04Z | alijk81 | `` Da Hujrey Mijlas `` | ["Music", "Middle Eastern music"] | ["low quality", "live performance", "traditional", "mono", "noisy", "wooden percussions", "plucked strings melody", "harmonizing male vocals", "passionate", "soulful"] | 4 | 8ZK1ajW598M | 930 | |
Traditional Berber Music | The low quality recording features a live performance of a traditional song and it contains wooden percussion, violin melody and flute melody. It sounds soulful, passionate and the recording is noisy and in mono. | 2008-05-22T17:53:23Z | culturexchangeteam | We had the good fortune to attend a concert of Moroccan Berber Music in Marrakesh | ["Traditional music", "Music"] | ["low quality", "live performance", "traditional", "wooden percussions", "violin melody", "flute melody", "soulful", "passionate", "noisy", "mono"] | 4 | W8Xv3Q2kGRA | 3070 | |
Blasting Mridangam Thani Avartanam By Shri Umayalpuram K Sivaraman & Shri G Harishankar | The low quality recording features repetitive buzzy strings and wooden percussion performing live. There is an unwanted male cough at one point in the loop. The recording is very noisy and in mono. | 2014-03-14T16:31:25Z | Kalakendra Music & Dance | A Brilliant thani Avartanam Excerpt from the concert of the legend Sangita Kalanidhi Shri M Balamuralikrishna | ["Carnatic music", "Music", "Musical instrument", "Classical music"] | ["low quality", "buzzy strings", "wooden percussions", "male cough", "noisy", "mono", "repetitive", "live performance"] | 4 | pejDm3j4Y-I | 4730 |
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;