musiccaps_details (view)
4 rows where musiccaps_author = 0, musiccaps_names contains "Music" and musiccaps_names contains "Music of Asia"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 29 ✖
- bass 2
- bollywood song 2
- male voice 2
- moderate tempo 2
- romantic mood 2
- tabla 2
- acoustic guitar 1
- backing voices 1
- chinese fiddle 1
- club song 1
- dance song 1
- female voice 1
- finger snaps 1
- flute 1
- guitar 1
- happy mood 1
- high pitched voice 1
- keyboard 1
- oriental folk song 1
- oriental percussion 1
- piano 1
- pop song 1
- programmed percussion 1
- shaker 1
- slow jazz song 1
- slow tempo 1
- synth music 1
- tremulous voice 1
- young female voice 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Happy happy - (Ost.You are my destiny) | This slow jazz song features a female voice. This is accompanied by an acoustic guitar playing chords. A keyboard plays a fills using a xylophone-like tone. The bass plays the root notes of the chords. Finger snaps are played in some spaces between lines. A shaker provides the percussion for this song. The song features a jazz chord progression providing some complexity to this song. The mood of this song is romantic. This song can be played in a romantic movie. | 2009-10-22T16:51:15Z | Supitcha Kh | i'm sone!! i know the picture on video is YoonA because she acted YAMD "Yuri" i mean "Sung Yuri" because she sung this song my title is ambiguous :: sorry to make you misunderstanding :) thanks for watch my video ---------------------------------------------- Ost.You are my destiny Artist : Sung yu ri Title: 너는 내 운명 / Neoneun Nae Unmyeong Also known as: You Are My Destiny / You Are My Life Genre: Romance, family Episodes: 178 Broadcast network: KBS1 Broadcast period: 2008-May-05 to 2009-Jan-09 Air time: Monday to Friday 8:25 PM Im Yoon Ah as Jang Sae Byuk Park Jae Jung as Kang Ho Se | ["Music of Asia", "Music", "Song"] | ["slow jazz song", "young female voice", "acoustic guitar", "finger snaps", "keyboard", "shaker", "romantic mood"] | 0 | CgK0DU3KFBc | 1392 | |
Missing from YouTube | This song is an oriental folk song featuring a male voice singing at a high pitch. The voice is tremulous. This is accompanied by the Chinese fiddle playing a melody similar to the main voice. A flute also plays the same melody as the voice. The percussion plays random beats leaving a lot of room in between. This song can be played in an Asian movie where a man is trying to woo a girl in a village. | ["Music of Asia", "Folk music", "Music"] | ["oriental folk song", "male voice", "high pitched voice", "chinese fiddle", "oriental percussion", "flute", "slow tempo", "tremulous voice"] | 0 | 2328 | |||||
Koi Kahe Kehta Rahe Full Song | Dil Chahta Hai | Aamir Khan, Akshaye Khanna, Saif Ali Khan | This pop song features a male voice singing the main melody. Other voices sing backing vocals using the same melody. This is accompanied by programmed percussion playing a dance beat. A wave synth plays a repetitive melody. The bass plays the root notes of the chords. Toward the end of the song, a tabla is played. The mood of this song is happy. This song can be played in a club as a dance song. | 2011-05-25T01:24:21Z | T-Series | Song - Koi Kahe Kehta Rahe Film - Dil Chahta Hai Singer - Shankar Mahadevan, Shaan, K K Lyricist - Javed Akhtar Music Director - Shanker, Ehsaan, Loy Artist - Aamir Khan, Akshaye Khanna, Saif Ali Khan Music On - T-Series | ["Singing", "Music of Asia", "Music"] | ["pop song", "bollywood song", "male voice", "backing voices", "dance song", "synth music", "programmed percussion", "bass", "club song", "tabla", "moderate tempo", "happy mood"] | 0 | ctJI7pCbxAo | 3751 | |
The Best Of Bollywood At The Royal Stag Mirchi Music Awards | Radio Mirchi | This bollywood song features a female voice singing the main melody. This is accompanied by a tabla and other percussion playing a staccato beat. A guitar strums chords in staccato following the percussion in the breaks. Another guitar plays arpeggiated chords. A piano plays in the background. The bass walks down playing a descending bassline. The mood of this song is romantic. This song can be played in a romantic movie. | 2016-03-13T15:25:38Z | Mirchi Plus | Watch the rockstars sing the super duper hits at The Royal Stag Mirchi Music Awards. Just wow! Drop in your feedback in the comment box below. For more details, 'Like' us on Facebook: https://www.facebook.com/mirchi983fm 'Follow' us on Twitter: http://twitter.com/mirchi983fm 'Subscribe' to the New Exclusive Murga Channel: http://bit.ly/148F8xe Add us to your circle on Google+: https://plus.google.com/+Mirchi983Fm | ["Music of Asia", "Music"] | ["bollywood song", "female voice", "guitar", "tabla", "bass", "piano", "romantic mood", "moderate tempo"] | 0 | n_boIyhZqWc | 4557 |
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;