musiccaps_details (view)
2 rows where musiccaps_author = 8 and musiccaps_names contains "Sitar"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 16 ✖
- bollywood 1
- drone 1
- exotic 1
- hypnotic 1
- meditative 1
- microtonal 1
- orchestral string melody 1
- pentatonic melody 1
- sitar 1
- solo sitar 1
- south asian 1
- string bending 1
- tape hiss 1
- tape warble 1
- vintage 1
- waltz 1
musiccaps_names (array) 5 ✖
- Music 2
- Sitar · 2 ✖
- Carnatic music 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
jan-e-bahar husn tera,wallah kamal hai_ShammiKapoor&Saroja_Rafi_ Shakeel_Ravi_tribute to singing GOD | Vintage south Asian Bollywood music featuring sitar and an orchestral string melody which uses a pentatonic scale. The song follows a waltz rhythm, using three beats to the measure. | 2012-04-18T06:13:45Z | 9431885 MK | Song :Jaane bahaar husn tera bemisal hai.. Movie :Pyaar Kiya To Darna Kya (1963), Singer: Mohammad Rafi, Lyricist : Shakeel Badayuni, Music Director : Ravi, Cast : Shammi Kapoor,B.Saroja Devi, Pran, Om Prakash, Agha and Prithviraj Kapoor, Helen,Shobha Khote, Melancholy Director : B.S. Ranga Lyrics :- jaan-e-bahaar husn teraa bemisaal hai jaan-e-bahaar husn teraa bemisaal hai wallaah kamaal hai, arre wallaah kamaal hai jaan-e-bahaar husn teraa bemisaal hai aayi hai mere paas tu is aan-baan se aayi hai mere paas tu is aan-baan se utri ho jaise koyi pari aasmaan se main kyaa kahoon khushi se ajab meraa haal hai jaan-e-bahaar husn teraa bemisaal hai wallaah kamaal hai, arre wallaah kamaal hai haay jaan-e-bahaar husn teraa bemisaal hai haay ye teri mast adaayen ye baankpan haay ye teri mast adaayen ye baankpan kirnon ko bhi main chhoone na doongaa tera badan tujhse nazar milaaye ye kiski majaal hai jaan-e-bahaar husn teraa bemisaal hai wallaah kamaal hai, arre wallaah kamaal hai jaan-e-bahaar husn teraa bemisaal hai main khushnaseeb hoon ke tujhe maine paa liyaa main khushnaseeb hoon ke tujhe maine paa liyaa toone karam kiyaa mujhe apnaa banaa liyaa aise mile hain ham ke bichhdnaa muhaal hai jaan-e-bahaar husn teraa bemisaal hai wallaah kamaal hai, arre wallaah kamaal hai haay jaan-e-bahaar husn teraa bemisaal hai | ["Music", "Sitar"] | ["waltz", "orchestral string melody", "sitar", "vintage", "bollywood", "pentatonic melody", "exotic", "south asian"] | 8 | Q6dVti1YVwM | 2594 | |
Pt Budhaditya Mukherjee, Raga Naaki Kanada Live 1992 Pt 1 | Solo sitar using microtonality, droning and string bending. The music is hypnotic and meditative and there is the sound of tape hiss and warble in the recording. | 2011-12-02T10:59:27Z | tripmonk0 | First part of Raga Nayaki Kanada with Partha Sarathy Mukherjee on tabla.. Made from an old VHS tape so sound & picture a bit ropey!! Sorry!! | ["Carnatic music", "Music", "Musical instrument", "Plucked string instrument", "Sitar"] | ["solo sitar", "drone", "microtonal", "string bending", "meditative", "hypnotic", "tape warble", "tape hiss"] | 8 | feC0L9MtghM | 3966 |
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;