musiccaps_details (view)
1 row where musiccaps_aspects contains "emotional", musiccaps_aspects contains "muffled instrumental", musiccaps_aspects contains "passionate" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Dosti All Songs Jukebox (HD) | Evergreen Bollywood Songs | Classic Old Hindi Songs | The low quality recording features a muffled echoing male vocal singing over a muffled instrumental. It sounds noisy, but also passionate and emotional. | 2015-09-16T04:00:32Z | Rajshri | Relish all the evergreen songs of Dosti (1964) now in HD only on Rajshri! Song List : 00:16 - Chahoonga Main Tujhe Saanj Savere 04:44 - Rahi Manwa Dukh Ki Chinta 09:01 - Jaanewalo Zara 14:38 - Meri Dosti Mera Pyar 18:30 - Mera To Jo Bhi Kadam 22:44 - Gudiya Kab Tak Na Hasogi Music that was a landmark in the glory of Indian cinema, emerged as a blockbuster hit and fetched the musical duo, Laxmikant-Pyarelal their first Filmfare award, songs of Dosti have moved people in every aspect and still continues to do so. Share on Facebook: https://goo.gl/p62Fvl Tweet it: https://goo.gl/8BtHDD Share on G+: https://goo.gl/Iajnvj Subscribe To Our Channel : http://bit.ly/SubscribeToRajshri Follow us on G+ http://plus.google.com/+rajshri Like us on Facebook - https://www.facebook.com/rajshri Follow us on Twitter - https://twitter.com/Rajshri Follow us on Pinterest - http://www.pinterest.com/rajshrivideos Visit Rajshri's Website - http://www.rajshri.com | ["Music", "Middle Eastern music", "Music of Bollywood"] | ["low quality", "muffled echoing male vocal", "muffled instrumental", "noisy", "passionate", "emotional"] | 4 | AVVfOYSmexM | 1126 |
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;