musiccaps_details (view)
2 rows where musiccaps_aspects contains "young love", musiccaps_aspects contains "youthful" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- emotional 2
- love song 2
- young love · 2 ✖
- youthful · 2 ✖
- acoustic guitar 1
- ambient 1
- atmospheric synthesiser 1
- bollywood 1
- bollywood retro 1
- bongos 1
- boy band 1
- chimes 1
- duet 1
- dulcet 1
- electric guitar 1
- fast tempo 1
- foreign language 1
- hindi song 1
- k-pop 1
- k-pop hips 1
- keyboard accompaniment 1
- korean song 1
- lively 1
- male vocalist 1
- medium tempo 1
- melodic 1
- minimalist 1
- passionate 1
- playful 1
- pleasant 1
- pop 1
- romantic 1
- romantic piano 1
- sentimental 1
- soft pop 1
- soft soothing 1
- speech like singing 1
- sprechstimme 1
- steady drumming 1
- straightforward bass lines 1
- vocal backup 1
- world music 1
musiccaps_names (array) 5 ✖
- Music 2
- Music of Bollywood 1
- Pop music 1
- Singing 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
BEAST/B2ST - Clenching A Fist Tight | A male vocalist sings this soft Korean Melody. The tempo is medium with a romantic piano accompaniment, steady drumming, simple bass lines, chimes, synthesiser arrangements and male vocal backup. The song is a soft, mellow, romantic, emotional, sentimental, dulcet, melodic love song. This song is a Korean Soft Pop/K-pop song. | 2010-09-17T04:03:08Z | megcapati | BEAST's 3rd Mini Album MASTERMIND. SUPPORT BEAST BUY BUYING THEIR 3RD MINI ALBUM MASTERMIND! :D :D :D ~~ Another awesome ballad. Perfect song to listen to if you want to cry. ~~ CHECK OUT MY OTHER VIDEOS :D Twitter: http://www.twitter.com/meggiewegsss Tumblr: http://www.meggiewegsss.tumblr.com Facebook: http://www.facebook.com/meggiewegsss B2STLYB2UTIES website coming soon~♥ Twitter: http://www.twitter.com/B2STLYB2UTIES Facebook: http://www.facebook.com/pages/B2stlyb2uties/144520828909598 Every 2 weeks is the birth of a new parody made by EMDEE Parodies ^_^v Twitter: http://www.twitter.com/EMDEEparodies YouTube: http://www.youtube.com/user/EMDEEparodies | ["Music", "Pop music", "Soul music"] | ["male vocalist", "medium tempo", "dulcet", "sentimental", "emotional", "love song", "melodic", "world music", "k-pop hips", "youthful", "young love", "soft soothing", "romantic piano", "steady drumming", "straightforward bass lines", "chimes", "atmospheric synthesiser", "boy band", "vocal backup", "ambient", "pop", "soft pop", "romantic", "pleasant", "emotional", "melodic", "foreign language", "korean song", "k-pop"] | 7 | 0F-Z0zF1504 | 138 | |
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;