musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "romantic mood" and musiccaps_names contains "Music of Asia" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- romantic mood · 2 ✖
- acoustic guitar 1
- bass 1
- bollywood song 1
- female voice 1
- finger snaps 1
- guitar 1
- keyboard 1
- moderate tempo 1
- piano 1
- shaker 1
- slow jazz song 1
- tabla 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 | |
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;