musiccaps_details (view)
1 row where musiccaps_aspects contains ""4 on the floor" kick pattern", musiccaps_aspects contains "folk", musiccaps_aspects contains "strings melody" and musiccaps_names contains "Music of Asia"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Kachchi Kaliyaan Song | Laaga Chunari Mein Daag | Rani Mukerji, Konkona | Sonu, Shreya, KK, Sunidhi | The low quality recording features a folk song that consists of flat male vocals, alongside harmonizing female vocals, singing over groovy bass, strings melody, shimmering hi hats, and "4 on the floor" kick pattern. It sounds energetic, happy and fun. | 2009-04-11T02:28:01Z | YRF | ► Subscribe Now: https://goo.gl/xs3mrY 🔔 Stay updated! #YRFnewreleases - https://www.youtube.com/playlist?list=PLCB05E03DA939D484 🎧 Song Credits: Song: Kachchi Kaliyaan Singers: Sonu Nigam, KK, Sunidhi Chauhan, Shreya Ghoshal Music: Shantanu Moitra Lyrics: Swanand Kirkire 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: Laaga Chunari Mein Daag - Journey Of A Woman Starring: Jaya Bachchan, Rani Mukerji, Konkona Sen Sharma, Kunal Kapoor, Anupam Kher, Abhishek Bachchan Special Appearance: Hema Malini Director: Pradeep Sarkar Producer: Aditya Chopra & Pradeep Sarkar Music: Shantanu Moitra Lyrics: Swanand Kirkire Director Of Photography: Sushil Rajpal Release Date: 12 October 2007 Watch all videos from the film 'Laaga Chunari Mein Daag - Journey Of A Woman': https://www.youtube.com/watch?v=luu39msPZrs&list=PL5E5D630D859255EC Synopsis: When a small town girl Badki (Rani Mukerji) from Banaras lands in the big bad city of Mumbai to earn an honest living for her family back home - things don’t go exactly as she hoped. When her kid sister Chutki (Konkona Sen Sharma) comes face to face and her double life is revealed the 2 sisters are in a confrontation that none of them expected or would have dreamt of in their wildest dreams - the whole family is thrown in to a tumultuous storm. Everything threatens to explode in their faces leaving a trail of destruction. #YRFnewreleases #LaagaChunariMeinDaag #YRF #AbhishekBachchan #RaniMukerji #KonkanaSenSharma #KunalKapoor #KK #ShreyaGoshal #SonuNigam #SunidhiChauhan #SwanandKirkire #ShantanuMoitra #YRF #YRF50 #Yashraj #YashrajFilms #YRFmovies #YRFSongs #YRFmusic #YashChopra #AdityaChopra © Yash Raj Films Pvt. Ltd. | ["Music of Asia", "Music"] | ["low quality", "folk", "flat male vocal", "harmonizing female vocals", "groovy bass", "\"4 on the floor\" kick pattern", "shimmering hi hats", "strings melody", "energetic", "happy", "fun"] | 4 | xe9vDoF8TQM | 5343 |
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;