musiccaps_details (view)
1 row where musiccaps_aspects contains "brass band", musiccaps_aspects contains "dholak", musiccaps_aspects contains "drums" and musiccaps_author = 7
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Band Baaja Baaraat | Title Song | Ranveer Singh | Anushka Sharma | Salim Merchant | Shraddha Pandit | This song is a lively Indian instrumental. The tempo is fast with lively brass bands playing harmony, energetic drums ,Nagpada and dhol and other Indian percussion and synthesiser with digital arrangements. There is a dialogue of a man and woman superimposed over the music, with sighing and giggling in the background. The music is typical Indian Baarat music. It is happy, cheerful, vivacious, energetic, youthful, vigorous and upbeat. | 2012-01-20T12:10:46Z | YRF | Get into the celebratory mode with the high on energy title track of ‘Band Baaja Baaraat’. ► Subscribe Now: https://goo.gl/xs3mrY 🔔 Stay updated! ► YRF New Releases: https://www.youtube.com/playlist?list=PLCB05E03DA939D484 🎧 Song Credits: Song: Band Baaja Baaraat - Title Song Singers: Salim Merchant, Shraddha Pandit Music: Salim-Sulaiman Lyrics: Amitabh Bhattacharya 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: Band Baaja Baaraat Starring: Ranveer Singh, Anushka Sharma Director: Maneesh Sharma Producer: Aditya Chopra Music: Salim-Sulaiman Lyrics: Amitabh Bhattacharya Director of Photography: Aseem Mishra Release Date: 10 December 2010 Watch all videos from the film ‘Band Baaja Baaraat’: https://www.youtube.com/watch?v=k67ErU7SeIE&list=PL3137530AC0F0E2FC&index=2&t=0s Synopsis: Shruti (Anushka Sharma) is a 20-something no-nonsense girl from a middle class Delhi household. Focused and determined with preplanned ambitions, her goals in life are well laid out by the time she reaches her final year of college. Bittoo (Ranveer Singh), on the other hand, has no real aim in life. As a final year college student of Delhi University, he whiles away his life having fun with his buddies, barely scraping through his exams. A chance and inopportune meeting (or as you would call it, fate) brings the two of them together on a tumultuous journey where they become partners in their very own, “Wedding planning ka bijness”. The rules however, are clear: “Jisse vyapaar karo, usse kabhi na pyaar karo” (Don’t mix business with pleasure). Together, their friendship and business, enters the ups and downs of the lavish Delhi weddings. And while trying to find themselves, Shruti and Bittoo discover each other and realize that in the course of their journey, unke khud ke rules ki bajegi band. #YRFnewreleases #BandBaajaBaaraat #YRF #YRF50 #Yashraj #YashrajFilms #YRFmovies #YRFmusic #Yash… | ["Music", "Sigh"] | ["instrumental", "trumpets", "brass band", "brass band", "energetic", "lively", "enthusiastic", "vigorous", "peppy", "buoyant", "digital drums", "indian percussions", "drums", "nagpada", "lively trumpet", "dholak", "indian music", "indian wedding", "contemporary indian music", "digital drums", "electronic music", "synth arrangements", "male voice talking", "female voice talking", "sighing", "laughing", "vocalising", "superimposed speech", "baarat music", "indian wedding", "north indian wedding music", "indian ceremonial band"] | 7 | 3kXukXBvDQQ | 496 |
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;