musiccaps_details (view)
2 rows where musiccaps_aspects contains "cymbals", musiccaps_aspects contains "groovy", musiccaps_aspects contains "male vocalist" and musiccaps_author = 7
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Three Little Birds -Bob Marley- with lyrics HD | A male vocalist sings this light melody. The tempo is medium with a funky bass line, keyboards accompaniment; slick drumming, groovy electric guitar and acoustic guitar riff with female vocal backup. The song is light, punchy, buoyant, groovy, funky,insightful, reflective and melodic. This song is a spirited Reggae song. | 2013-08-27T16:58:35Z | musicaprayer | Bob Marley & The Wailers Three Little Birds with a original animation. If you like this video, give it a thumbs up! Contact me on Facebook! https://www.facebook.com/shohei.yamatsu | ["Funk"] | ["male vocalist", "medium fast tempo", "reflective", "melodic", "keyboard harmony", "groovy", "funky", "youthful", "buoyant", "reflective", "organ", "electric guitar", "acoustic guitar", "steady drumming", "funky bass line", "bass drum", "pipe organ", "light", "playful", "affecting", "insightful", "cymbals", "female vocal backup", "reggae", "jazz"] | 7 | HCCGZh-TxK0 | 1779 | |
Big Mac Chant挑战 – FS Fuying & Sam 流行曲风 | This song is a vocal duet of male singers in a foreign language . The tempo is medium fast with an animated electric guitar melody, boomy bass drops, digital drums and synthesiser arrangements. The music is buoyant, youthful,punchy, groovy and emphatic with mellow vocals. This song is contemporary Pop. | 2016-10-13T01:58:19Z | McDonaldsMalaysia | 快来学唱FS Fuying&Sam版本的Big Mac Chant挑战歌曲,之后到Smule与他们合唱,再将影片上传到Facebook或Instagram,最后到www.mcdonalds.com.my/mybigmacchant报名参加,就有机会赢取高达RM10,000现金奖,以及与他们见面的机会!马上行动! | ["Music", "Vocal music"] | ["male vocalist", "duet", "medium fast tempo", "foreign language", "electric guitar lead", "boomy bass drops", "synthesiser arrangements", "cymbals", "electronic sounds", "digital drums", "youthful", "energetic", "enthusiastic", "groovy", "punchy music", "mellow vocals", "electro pop"] | 7 | XaqVAF-ADWU | 3201 |
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;