musiccaps_details (view)
2 rows where musiccaps_aspects contains "bass" and musiccaps_names contains "Music of Asia" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- bass · 2 ✖
- bollywood song 2
- moderate tempo 2
- tabla 2
- backing voices 1
- club song 1
- dance song 1
- female voice 1
- guitar 1
- happy mood 1
- male voice 1
- piano 1
- pop song 1
- programmed percussion 1
- romantic mood 1
- synth music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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;