musiccaps_details (view)
3 rows where musiccaps_aspects contains "carnatic music", musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Carnatic music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- carnatic music · 3 ✖
- medium tempo · 3 ✖
- indian classical music 2
- live performance 2
- passionate 2
- spirited 2
- alap 1
- amateur quality recording 1
- ambient noise 1
- bad audio quality 1
- carnatic vocals 1
- chanting 1
- controlled singing 1
- double reed instruments 1
- drone harmony tones 1
- emotional music 1
- energetic 1
- engaging 1
- exciting 1
- indian classical 1
- indian wind instrument 1
- live audience 1
- low quality sound 1
- lucid 1
- lyrical melody 1
- male singer 1
- male vocalist 1
- mridangam percussion 1
- mridangam rhythm 1
- nadaswaram playing 1
- no lyrics 1
- perfection 1
- raga 1
- ragas 1
- rhythmic beat 1
- sound of chatter 1
- south india 1
- south indian music 1
- tabla 1
- vocalisation 1
- voice control 1
musiccaps_names (array) 7 ✖
- Carnatic music · 3 ✖
- Music 3
- Classical music 2
- Musical instrument 2
- Folk music 1
- Percussion 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Natheswaram Thavil Kachcheri SMT 2015 | The song is an instrumental Indian classical tune. The song is medium tempo with two Indian double reed instruments called nadaswaram playing in a duet. The song is emotional and highly lyrical . The song is amateur quality recording and a classic Carnatic music tune. | 2015-02-11T08:27:22Z | Rasiah Sriravindrarajah | Srilankan Natheswaram and Thavil vidwans played famous songs at an Inisai Kachcheri at the Sydney Murugan Cultural Hall on 10th Feb. 2015. Listed to three songs at the end of the Kachceri. | ["Carnatic music", "Music", "Musical instrument", "Classical music"] | ["carnatic music", "live performance", "nadaswaram playing", "medium tempo", "indian wind instrument", "double reed instruments", "emotional music", "lyrical melody", "ambient noise", "amateur quality recording", "indian classical music", "spirited", "passionate", "drone harmony tones"] | 1 | AjLX_1rBDPM | 1159 | |
DR.M.BALAMURALIKRISHNA - THILLANA | A male vocalist sings this traditional Carnatic vocals. The song is medium tempo with a violin accompaniment, tabla and mridangam playing percussion. The song is energetic and passionate and highlights the traditional Carnatic music art form. The audio quality is bad. | 2007-04-17T07:21:47Z | Musique4ever | Dr.M.Balamuralikrishna sings a thillana in Ahir Bhairav. | ["Singing", "Carnatic music", "Music", "Musical instrument", "Classical music", "Percussion"] | ["carnatic music", "male vocalist", "medium tempo", "tabla", "energetic", "passionate", "indian classical music", "bad audio quality", "live performance", "live audience", "passionate", "spirited", "exciting", "mridangam percussion", "carnatic vocals"] | 1 | Emc18GpAeRY | 1588 | |
Carnatic music at Sri kothandaramar temple, India | A male vocalist sings this alap or raga. The tempo is medium with a rhythmic mridangam accompaniment. The song is vocalised with the vocalist singing a melody using notes not lyrics. It is engaging, energetic and controlled. This song is a Carnatic Classical. | 2007-03-25T03:49:47Z | Anush Narayanan | Sriramanavmi Celebartions | ["Carnatic music", "Folk music", "Music"] | ["male singer", "medium tempo", "vocalisation", "alap", "raga", "controlled singing", "engaging", "no lyrics", "ragas", "carnatic music", "mridangam rhythm", "chanting", "indian classical", "south india", "south indian music", "sound of chatter", "lucid", "perfection", "voice control", "low quality sound", "rhythmic beat"] | 7 | e7WPFeDPFB4 | 3845 |
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;