musiccaps_details (view)
3 rows where musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "raga" and musiccaps_aspects contains "sruti"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- fast tempo · 3 ✖
- raga · 3 ✖
- sruti · 3 ✖
- classical music 2
- concert 2
- indian classical 2
- instrumental 2
- live performance 2
- taal 2
- ambient sounds 1
- bhakti 1
- carnatic music 1
- classical 1
- devotional 1
- drone layer 1
- ghatam 1
- ghungaroos sound 1
- harmonium melody 1
- hindustani 1
- hindustani instrumental 1
- indian classical music 1
- indian percussion 1
- indian percussion instrument 1
- indian string instrument 1
- indian wind instrument 1
- live audience 1
- lively 1
- lively tabla rhythm 1
- lively veena harmony 1
- male vocalist 1
- melodic flute harmony 1
- melodic layer 1
- minimalist music 1
- mridangam 1
- north indian classical music 1
- people talking 1
- percussion layer 1
- sandhya raag 1
- sing introduction 1
- soloist 1
- song interlude 1
- south indian classical music 1
- south indian music 1
- spirited 1
- tabla 1
- tabla rhythm 1
- tanpura 1
- violin accompaniment 1
musiccaps_names (array) 6 ✖
- Drum 2
- Percussion 2
- Tabla 2
- Folk music 1
- Music 1
- Sitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ravi Shankar Playing Sandhya Raag And Asaad Khaan On Veena | This music is a lively instrumental of the Indian Classical instruments. The tempo is fast with a lead Veena harmony, spirited tabla and tanpura rhythm and melodic flute accompaniment. The music is euphoric, mellifluous, dulcet, lively, high spirited and rich. This music is a Indian Classical Veena instrumental. | 2008-07-09T03:07:28Z | shreend | enjoy ppl | ["Folk music", "Music", "Sitar"] | ["instrumental", "fast tempo", "lively veena harmony", "raga", "indian classical", "hindustani instrumental", "concert", "north indian classical music", "indian string instrument", "indian wind instrument", "sandhya raag", "classical music", "hindustani", "taal", "sruti", "melodic flute harmony", "tanpura", "tabla rhythm", "indian percussion"] | 7 | 4Yc71_dU3m4 | 584 | |
Rashid Jahangir (zamanai poak na hum dum) | This music is an instrumental.the tempo is fast with a harmonium melody and tabla accompaniment. The performance is live with ambient sounds of people talking, sound of glass bangles and a woman’s voice. This music is Indian Classical. | 2008-10-30T22:02:58Z | u297777 | Rashid Jahangir from doda city (J&K) | ["Tabla", "Drum", "Percussion"] | ["instrumental", "fast tempo", "harmonium melody", "indian classical", "raga", "sruti", "classical", "indian percussion instrument", "lively tabla rhythm", "live performance", "live audience", "ambient sounds", "people talking", "ghungaroos sound", "people talking", "lively", "spirited", "song interlude", "sing introduction"] | 7 | EnewI6fNhVA | 1590 | |
Malakkuda 2012 - Kacheri By Thrikkodithanam Sachithanandan / Aalayal Thara Venam | A male vocalist sings this Classical song. The tempo is fast with animated ghatam, mridangam and tabla accompaniment and violin harmony. The vocals are classical notes and lyrics in a South Indian language. The song has three layers, the melody, percussion and drone. This song is a devotional Carnatic Classical song. | 2013-03-11T04:02:09Z | Poruvazhy Peruviruthy Malanada Temple | Poruvazhy Peruviruthy Malanada - The one and only Duryodhana Temple in South India | ["Tabla", "Drum", "Percussion"] | ["male vocalist", "fast tempo", "carnatic music", "soloist", "classical music", "indian classical music", "south indian music", "south indian classical music", "ghatam", "mridangam", "violin accompaniment", "tabla", "raga", "sruti", "taal", "concert", "live performance", "melodic layer", "percussion layer", "drone layer", "minimalist music", "bhakti", "devotional"] | 7 | mx7kjFY7ALs | 4505 |
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;