musiccaps_details (view)
2 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "mono" and musiccaps_aspects contains "strings melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- live performance · 2 ✖
- low quality 2
- mono · 2 ✖
- noisy 2
- strings melody · 2 ✖
- addictive 1
- crackling 1
- emotional 1
- energetic 1
- energetic drums 1
- flute melody 1
- folk 1
- passionate 1
- soulful 1
- traditional 1
- wooden percussion 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Zdop si Zdup - Dj Vasile | The low quality recording features a live performance of folk songs played by flute, strings and energetic drums. The recording is noisy and in mono, as the audio is crackling and it sounds energetic and kind of addictive thanks to that flute and strings melody. | 2010-10-15T16:42:09Z | Ciprian BT | Zdop si Zdup - Dj Vasile | ["Jazz", "Music"] | ["low quality", "folk", "noisy", "mono", "flute melody", "strings melody", "energetic drums", "crackling", "live performance", "energetic", "addictive"] | 4 | 4mtfOkzOvBI | 606 | |
Rag Rageshri - Part 1 | The low quality recording features a live performance of a traditional song that consists of a strings melody played over wooden percussion. The recording is in mono, a bit noisy and it sounds passionate, emotional and soulful. | 2008-10-19T15:54:46Z | bsathien | This is a tabla & sitar recital in rag Rageshri. It is a compilation of two compositions, starting with a piece composed by Pandit Nayan Ghosh, moving on to a piece composed by Ustad Vilayat Khan, and ending with a jhala. On sitar is Dr Debipriya Das, and on tabla is Janan Sathiendran (a student of Sukhdeep Singh Dhanjal). Live recording at Ananthalayas 'Naatha Vinotham'. | ["Tabla", "Drum", "Pizzicato", "Percussion"] | ["low quality", "mono", "noisy", "live performance", "wooden percussion", "strings melody", "passionate", "emotional", "soulful", "traditional"] | 4 | 5ZX1-GAb7IM | 667 |
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;