musiccaps_details (view)
2 rows where musiccaps_author = 7 and "youtube_published" is on date 2008-07-09
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- classical music 1
- concert 1
- emotional 1
- fast tempo 1
- female singer 1
- hindustani 1
- hindustani instrumental 1
- indian classical 1
- indian percussion 1
- indian string instrument 1
- indian wind instrument 1
- instrumental 1
- keyboard accompaniment 1
- lively veena harmony 1
- melancholic 1
- mellow 1
- mellow electric guitar 1
- melodic flute harmony 1
- minimal music 1
- north indian classical music 1
- nostalgic 1
- raga 1
- sandhya raag 1
- sentimental 1
- slow tempo 1
- soft lilting flute 1
- soft pop 1
- soothing 1
- sruti 1
- subtle bass lines 1
- taal 1
- tabla rhythm 1
- tanpura 1
- vocal emphasis 1
musiccaps_names (array) 4 ✖
- Music 2
- Folk music 1
- Sad 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 | |
"ANGEL OF BENGAL" - The Religion of Love, music video | A female vocalist sings this soft melody. The song is slow tempo with a mellow electric guitar harmony, soft keyboard accompaniment , a soft lilting flute melody and subtle bass line. There is no use of percussion. The song is soft, mellow, emotional, nostalgic and sentimental . This song is Soft pop. | 2008-07-09T03:19:08Z | Hassan Ali | Devotional music written, performed, and produced by Jaraneh Nova. Dedicated to our Spiritual Master, Mother Rytasha, The Angel of Bengal. A Razzaque Khan Production. http://thereligionoflove.net ,http://www.chela.net/rytasha ,-- love@chela.net | ["Music", "Sad music"] | ["female singer", "slow tempo", "mellow electric guitar", "soft lilting flute", "keyboard accompaniment", "subtle bass lines", "vocal emphasis", "minimal music", "soft pop", "mellow", "soothing", "emotional", "sentimental", "nostalgic", "melancholic"] | 7 | 9aE33JEIGOg | 1028 |
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;