musiccaps_details (view)
2 rows where musiccaps_aspects contains "noisy", musiccaps_author = 4, musiccaps_names contains "Carnatic music" and musiccaps_names contains "Classical 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 |
---|---|---|---|---|---|---|---|---|---|---|
Raag Bhopali | The low quality recording features a cover of traditional folk song and it consists of reverberant, passionate female vocal singing over repetitive percussive instrument and plucked strings melody. It sounds passionate, cultural and emotional. | 2011-01-20T17:29:46Z | aradhanakarhade | Raag Bhupali tutorial for beginners - Raag Bhopali has five notes, and is thus a raag of the "audhav jaati". Follow the instructions and practice this raag. Here, it is sung in the scale of B major. The corresponding notes in B scale are B, C#, D#, F#, G# PLEASE SUBSCRIBE TO OUR NEW CHANNEL: https://www.youtube.com/channel/UCezyky1nT-IVvKAEZagViUA | ["Singing", "Carnatic music", "Music", "Classical music", "/t/dd00004"] | ["low quality", "noisy", "cover", "reverberant passionate female vocal", "traditional folk", "repetitive percussive element", "plucked strings melody", "passionate", "emotional", "cultural"] | 4 | VV-DgnPPhSo | 3006 | |
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;