musiccaps_details (view)
1 row where musiccaps_aspects contains "controlled singing", musiccaps_aspects contains "engaging" and musiccaps_aspects contains "perfection"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- alap 1
- carnatic music 1
- chanting 1
- controlled singing · 1 ✖
- engaging · 1 ✖
- indian classical 1
- low quality sound 1
- lucid 1
- male singer 1
- medium tempo 1
- mridangam rhythm 1
- no lyrics 1
- perfection · 1 ✖
- raga 1
- ragas 1
- rhythmic beat 1
- sound of chatter 1
- south india 1
- south indian music 1
- vocalisation 1
- voice control 1
musiccaps_names (array) 3 ✖
- Carnatic music 1
- Folk music 1
- Music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;