musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "lively" and musiccaps_names contains "Singing"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Are Kahe Ko Kahe Ko - Shashi Kapoor - Zeenat Aman - Chori Mera Kaam - Bollywood Songs - Asha Bhosle | This song is a Retro Hindi movie song. The tempo is fast with rhythmic guitar, vigorous guitar, keyboard harmony, congas and bongos. The music is minimalistic and simple with speech like singing. The song is playful, cheerful, upbeat, youthful and energetic. | 2012-06-04T11:06:50Z | Shemaroo Filmi Gaane | Movie : Chori Mera Kaam (1975) Music Director: Kalyanji Anandji Singers: Kishore Kumar and Asha Bhosle Director: Brij Lyrics: Verma Malik Enjoy this Hit song from the 1975 movie Chori Mera Kaam starring Ashok Kumar, Shashi Kapoor, Zeenat Aman and Pran. From the latest Bollywood songs to the oldest, SUBSCRIBE now to http://www.YouTube.com/FilmiGaane To see all the latest music playlists that we've created just for you, click here - http://www.youtube.com/user/filmigaane/videos?sort=dd&flow=list&view=1 Connect with us on :- Facebook - http://www.Facebook.com/FilmiGaane Twitter - http://Twitter.com/FilmiGaane Join us on Pinterest - http://pinterest.com/shemaroo Circle and follow us on Google+ - https://plus.google.com/+shemaroo . Download Filmi Gaane App - http://twd.bz/fg Sign up for Free and get daily updates on New Videos, exclusive Web Shows, contests & much more http://youtube.shemaroo.com/default.aspx Send us your feedback and suggestions at : connect@shemaroo.com | ["Singing", "Music", "Music of Bollywood"] | ["duet", "fast tempo", "hindi song", "bollywood", "bongos", "keyboard accompaniment", "lively", "youthful", "love song", "playful", "young love", "passionate", "minimalist", "emotional", "bollywood retro", "speech like singing", "acoustic guitar", "electric guitar", "sprechstimme"] | 7 | iEQwupwwp0s | 4171 | |
Klajdi Haruni - O bo bo (Kenga Magjike 2015) | This is an Albanian pop music piece. There are male vocals singing melodically in the Albanian language. The main theme is being played on the clarinet while there is a melodic backing composed of the acoustic guitar, the electric guitar and the bass guitar. The rhythm is provided by a laid-back acoustic drum beat. The atmosphere is lively. This piece could be used as an opening theme for an Albanian sit-com. | 2015-11-17T17:00:02Z | KlajdiHaruniVEVO | Music video for O bo bo (Kenga Magjike 2015) performed by Klajdi Haruni. Site: http://www.threedots.al Facebook: https://www.facebook.com/klajdiharunithreedots?fref=ts Copyright (C) 2015 Threedots Production. http://vevo.ly/fQQQYu | ["Singing", "Swing music", "Pop music"] | ["albanian pop music", "male vocals", "melodic singing", "clarinet", "acoustic guitar", "electric guitat", "bass guitar", "acoustic drums", "easygoing", "lively"] | 9 | t5fW1-6iXZY | 5004 |
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;