musiccaps_details (view)
2 rows where search matches "guitar" and "youtube_published" is on date 2012-06-04
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- passionate 2
- acoustic guitar 1
- acoustic guitar strumming 1
- bollywood 1
- bollywood retro 1
- bongos 1
- cello 1
- cheerful 1
- composer 1
- dance music 1
- duet 1
- electric guitar 1
- emotional 1
- enthusiastic 1
- exciting 1
- fast tempo 1
- hindi song 1
- instrumental music 1
- keyboard accompaniment 1
- live performance 1
- lively 1
- love song 1
- medium tempo 1
- minimalist 1
- party music 1
- playful 1
- poor audio quality 1
- speech like singing 1
- sprechstimme 1
- string harmony 1
- string quartet 1
- string trio 1
- studio performance 1
- viola 1
- violin 1
- wedding music 1
- western classical music 1
- young love 1
- youthful 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
J.Mouret - Rondeau String Quartet | The song is an instrumental. The song is medium tempo with a violin, viola, cello playing a string harmony accompanied by an acoustic guitar strumming chords. The song is a western classical music piece. | 2012-06-04T17:03:48Z | cellony | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["violin", "viola", "cello", "acoustic guitar strumming", "poor audio quality", "wedding music", "party music", "string quartet", "string trio", "string harmony", "instrumental music", "western classical music", "live performance", "studio performance", "medium tempo", "exciting", "cheerful", "dance music", "composer", "enthusiastic", "passionate", "exciting"] | 1 | fxznho_kNPY | 3995 | ||
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 |
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;