musiccaps_details (view)
11 rows where musiccaps_aspects contains "raga" and musiccaps_author = 7
This data as json
musiccaps_aspects (array) 149 ✖
- raga · 11 ✖
- indian classical 9
- fast tempo 6
- instrumental 6
- chanting 4
- engaging 4
- sruti 4
- taal 4
- alap 3
- classical music 3
- acoustic guitar 2
- captivating 2
- carnatic music 2
- concert 2
- hindustani classical 2
- hindustani music 2
- indian music 2
- indian string instrument 2
- live performance 2
- lively sitar 2
- male singer 2
- medium tempo 2
- puja 2
- slow tempo 2
- south indian classical music 2
- south indian music 2
- vigorous 2
- vivacious 2
- vocalisation 2
- ambient sounds 1
- ancient music 1
- atmospheric synthesiser 1
- bells 1
- bhakti 1
- calm 1
- carnatic 1
- classical 1
- classical duet 1
- classical song 1
- contemplative 1
- controlled singing 1
- devotional 1
- dexterity 1
- dexterous 1
- drone layer 1
- emotional 1
- energetic dholak 1
- enigmatic 1
- ensemble of vocalists 1
- enthralling 1
- fervent 1
- ghatam 1
- ghungaroos sound 1
- guitar 1
- harmonium accompaniment 1
- harmonium melody 1
- hindu mythology 1
- hindustan classical music 1
- hindustani 1
- hindustani instrumental 1
- indian bowed string instrument 1
- indian classical instruments 1
- indian classical music 1
- indian devotional song 1
- indian mythology 1
- indian percussion 1
- indian percussion instrument 1
- indian percussions 1
- indian wind instrument 1
- instrument of goddess saraswati 1
- keyboard harmony 1
- khartal 1
- kriti 1
- live audience 1
- lively 1
- lively tabla rhythm 1
- lively veena harmony 1
- low quality sound 1
- lucid 1
- lucid vocals 1
- lute 1
- lute family 1
- male vocalist 1
- mandira taal 1
- mandira taal percussion 1
- mantras 1
- meditation 1
- meditative 1
- melancholic 1
- mellifluous 1
- melodic 1
- melodic flute harmony 1
- melodic layer 1
- melodious 1
- mesmerising 1
- minimalist music 1
- mridangam 1
- mridangam rhythm 1
- musical notes 1
- no lyrics 1
- north indian classical music 1
- oud 1
- pakistani music 1
- peaceful 1
- pensive 1
- people talking 1
- percussion layer 1
- perfection 1
- poignant 1
- raaga 1
- ragas 1
- rhythmic beat 1
- sad 1
- sandhya raag 1
- sarangi 1
- sarod harmony 1
- sing introduction 1
- sitar 1
- skilful musicians 1
- skill 1
- skilled 1
- sliding pitches 1
- slows down to a rhythmic melody 1
- soloist 1
- song interlude 1
- soothing 1
- sound of chatter 1
- south india 1
- spirited 1
- spirited tabla 1
- stringed instrument 1
- subtle keyboard harmony 1
- swar 1
- sympathetic strings 1
- tabla 1
- tabla rhythm 1
- tala 1
- tanpura 1
- tanpura accompaniment 1
- tanpura rhythm 1
- tapping 1
- temple bells 1
- vibrant 1
- vigorous at the onset 1
- vigorous tabla introduction 1
- violin accompaniment 1
- vocal backup 1
- voice control 1
- wistful 1
musiccaps_names (array) 13 ✖
- Music 9
- Carnatic music 4
- Sitar 4
- Folk music 3
- Musical instrument 3
- Percussion 3
- Tabla 3
- Classical music 2
- Drum 2
- Mantra 2
- Guitar 1
- Plucked string instrument 1
- Traditional 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;