musiccaps_details (view)
1 row where musiccaps_aspects contains "arpeggiated harp", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "traditional"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dance Music - Instrumental | Chandni | Sridevi | Shiv-Hari | The low quality recording features a shimmering tambourine, wooden percussive elements, followed by arpeggiated harp which serves as a transition to the second part of the loop where plucked string melody appears. It sounds groovy and traditional. | 2009-04-22T18:33:43Z | YRF | Sridevi's dance moves on the instrumental dance tack from the film 'Chandni' will leave you awe struck! Each move radiates grace & elegance. ► Subscribe Now: https://goo.gl/xs3mrY 🔔 Stay updated! ► YRF New Releases: https://www.youtube.com/playlist?list=PLCB05E03DA939D484 Stay in the filmy loop: ► Like us on Facebook: Facebook/yrf ► Follow us on Twitter: Twitter/yrf ► Follow us on Instagram: Instagram/yrf ► Visit us on: yashrajfilms.com 🎬 Movie Credits: Movie: Chandni Starring: Sridevi, Rishi Kapoor, Vinod Khanna, Waheeda Rehman Director: Yash Chopra Producer: Yash Chopra Music: Shiv-Hari Lyrics: Anand Bakshi Release Date: 14 September 1989 Watch all videos from the film ‘Chandni’: https://www.youtube.com/watch?v=KmPvEh4O4tE&list=PLcVfz1-_0rj_joQI3NySMiNZj4E38b5RJ&index=2&t=0s Synopsis: In one cruel stroke of fate, Chandni (Sridevi) faces life alone, her heart and her dreams shattered as Rohit (Rishi Kapoor) disappears from her life. When she meets Lalit (Vinod Khanna) who is fighting the demons of tragic memories, they both find solace in this new friendship. Lalits affection gives a new direction to Chandnis life, but Lalit is falling for her and Chandni resigns to destiny, till one day, Rohit knocks on her door. Chandni is a classic Yash Chopra love story, softly lyrical, throbbingly beautiful and filled with exquisite locales, lilting melodies and the sound of three hearts hopelessly in love. #YRFnewreleases #Chandni #YRF #YRF50 #Yashraj #YashrajFilms #YRFmovies #YRFmusic #YashChopra #AdityaChopra #RishiKapoor #Sridevi #VinodKhanna #WaheedaRehman #ShivHari #AnandBakshi © Yash Raj Films Pvt. Ltd. | ["Folk music", "Music", "Dance music"] | ["low quality", "arpeggiated harp", "shimmering tambourine", "wooden percussive elements", "plucked strings melody", "traditional", "groovy"] | 4 | awax48X8YlU | 3587 |
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;