musiccaps_details (view)
6 rows where musiccaps_aspects contains "sruti" and musiccaps_author = 7
This data as json
musiccaps_aspects (array) 92 ✖
- sruti · 6 ✖
- concert 4
- fast tempo 4
- indian classical 4
- raga 4
- carnatic music 3
- instrumental 3
- taal 3
- classical music 2
- devotional 2
- kriti 2
- live performance 2
- lively 2
- male vocalist 2
- mridangam 2
- ragas 2
- south indian classical 2
- south indian classical music 2
- violin 2
- ambient sounds 1
- ancient music 1
- bhakti 1
- bowed string instrument 1
- carnatic 1
- chanting 1
- clapping 1
- classical 1
- classical duet 1
- classical ensemble 1
- classical song 1
- drone layer 1
- duel 1
- engaging 1
- ensemble of vocalists 1
- enthralling 1
- flute harmony 1
- gadam rhythm 1
- ghatak 1
- ghatam 1
- ghungaroos sound 1
- happy 1
- harmonium melody 1
- hindu deities 1
- hindustani 1
- hindustani instrumental 1
- impactful 1
- indian clasical 1
- indian classical music 1
- indian classical violin 1
- indian percussion 1
- indian percussion instrument 1
- indian percussion instruments 1
- indian string instrument 1
- indian wind instrument 1
- jugalbandi 1
- live audience 1
- lively tabla rhythm 1
- lively veena harmony 1
- medium fast tempo 1
- melodic 1
- melodic flute harmony 1
- melodic layer 1
- melodious 1
- minimalist music 1
- mridangam rhythm 1
- muffled audio 1
- musical notes 1
- north indian classical music 1
- people cheering 1
- people talking 1
- percussion layer 1
- sandhya raag 1
- sing introduction 1
- skilled 1
- soloist 1
- song interlude 1
- south indian music 1
- south indian traditional music 1
- spirited 1
- stage performance 1
- string instrument 1
- tabla 1
- tabla rhythm 1
- tala 1
- tanpura 1
- tanpura rhythm 1
- tapping 1
- traditional indian music 1
- violin accompaniment 1
- vocal backup 1
- vocal duel 1
- wind instrument 1
musiccaps_names (array) 10 ✖
- Music 4
- Carnatic music 3
- Classical music 2
- Drum 2
- Folk music 2
- Musical instrument 2
- Percussion 2
- Sitar 2
- Tabla 2
- Middle Eastern music 1
0 records
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;