musiccaps_details (view)
3 rows where musiccaps_aspects contains "soulful" and musiccaps_names contains "Percussion" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- low quality 3
- mono 3
- noisy 3
- passionate 3
- soulful · 3 ✖
- live performance 2
- passionate male vocal 2
- traditional 2
- dynamic 1
- emotional 1
- harmonizing male vocals 1
- mystical 1
- shimmering shakers 1
- strings melody 1
- suspenseful 1
- sustained suspenseful strings melody 1
- wooden percussion 1
- wooden percussions 1
- wooden percussive elements 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
OTIGBA UMUNOHA 2 | The low quality recording features a passionate male vocal chant, followed by harmonizing male vocals chants, after which a shimmering shaker and wooden percussion start playing. It sounds soulful, passionate and dynamic. The recording is mono and noisy. | 2012-12-22T07:55:13Z | nwaOkechi Nwafo Nnoha | ["Wood block", "Percussion"] | ["low quality", "wooden percussions", "passionate male vocal", "harmonizing male vocals", "dynamic", "passionate", "soulful", "shimmering shakers", "noisy", "mono"] | 4 | UxT3KG4AHAI | 2960 | ||
Great Ghazal Singer Ahmad Wali with Siar Hashimi on Tabla | The low quality recording features a live performance of a traditional song that consists of wooden percussive elements, sustained suspenseful strings melody and passionate male vocal singing over it. It sounds passionate, mystical, soulful and suspenseful, even though the recording is a bit noisy and in mono. | 2009-03-05T15:38:49Z | TaalPanchamSawari | Ghazal Tabla: Siar Hashimi Taal: Kehrwa | ["Tabla", "Percussion"] | ["mono", "noisy", "low quality", "traditional", "live performance", "wooden percussive elements", "sustained suspenseful strings melody", "passionate male vocal", "soulful", "passionate", "mystical", "suspenseful"] | 4 | yx7BZ_djE-U | 5449 |
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;