musiccaps_details (view)
2 rows where musiccaps_aspects contains "cheerful" and musiccaps_aspects contains "dance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- cheerful · 2 ✖
- dance · 2 ✖
- bird chirping melody 1
- bright tinny synth melody 1
- bubblegum pop 1
- fun 1
- groovy rhythmic percussion 1
- group female vocals 1
- happy 1
- indian music 1
- light-hearted 1
- pop 1
- simple youthful pop drum beat 1
- sitar 1
- south asian music 1
- tamil music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Vamsam - Tamil Serial | Episode 556 | 02/05/2015 | This is a traditional south asian dance song with a cheerful affect. We have a group of female singers singing in unison - a melody that matches with the one being played on the sitar. | 2015-05-02T16:00:00Z | Vision Time Tamil | Will Madan succeed in brainwashing Supriya to get married to him and will Archana be able to stop this marriage in time by arresting Madan for killing Bhoomika? Is Bhoomika really dead or alive?? Keep watching this space for more updates on your favorite serial VAMSAM. Cast: Ramya Krishnan, Sai Kiran, Vijayakumar, Seema, Vadivukkarasi | ["Folk music"] | ["south asian music", "indian music", "tamil music", "dance", "group female vocals", "sitar", "groovy rhythmic percussion", "cheerful"] | 3 | 5aCDam9_Ps4 | 671 | |
Lily Allen - Alfie | This song would be classified as bubblegum pop. The music is more suitable for children, as it has a young and light-hearted style of production. There's a bright and tinny synth which is used to play a repeated motif, and at one point we hear a pair of birds mimicking the melody in their squeaky bird-like tones. | 2009-02-27T19:39:47Z | Parlophone Records | Lily Allen's brand new track "Hard Out Here" is available to download on iTunes now here: http://smarturl.it/HardOutHere?IQid=vevoyt Watch the video here: http://smarturl.it/HardOutHereVideo?IQid=vevoyt Also out now is "Somewhere Only We Know" as featured in the TV Advert here! http://smarturl.it/lilysowk?IQid=vevoyt Follow Lily online: http://www.lilyallenmusic.com https://twitter.com/LilyAllen https://www.facebook.com/lilyallen http://instagram.com/lilyallen http://lilyallenmusic.tumblr.com https://plus.google.com/+lilyallen | ["Funk", "Music"] | ["cheerful", "happy", "pop", "light-hearted", "bubblegum pop", "bright tinny synth melody", "bird chirping melody", "dance", "fun", "simple youthful pop drum beat"] | 3 | Sr2Grfi3lFg | 2791 |
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;