musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "duet" and musiccaps_aspects contains "male vocalist" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 28 ✖
- duet · 2 ✖
- male vocalist · 2 ✖
- boomy bass drops 1
- children’s song 1
- cymbals 1
- digital drum beat 1
- digital drums 1
- electric guitar lead 1
- electric guitar rhythm 1
- electro pop 1
- electronic sounds 1
- energetic 1
- enthusiastic 1
- female vocalist 1
- foreign language 1
- groovy 1
- medium fast tempo 1
- mellow vocals 1
- melodic amplified piano 1
- melodious 1
- punchy music 1
- soft 1
- steady drumming 1
- story telling 1
- strong 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- Christmas music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
♪ Does Santa Claus...? - Charity Christmas Song | This song is a sweet duet. The tempo is medium with a melodious, intense piano accompaniment , electric guitar rhythm, steady drumming and synthesiser arrangements. This song is melodic, story telling, spirited, emotional, passionate and sweet. The lyrics are simple and so this song could be a Children’s Song. | 2014-12-06T21:55:23Z | YOGSCAST Lewis & Simon | Here's our Christmas charity song! Zombie pigmen kids really need all the love and support they can get, especially at this time of year. All proceeds support our charity drive at https://www.humblebundle.com/yogscast Get it here: ♪ https://itunes.apple.com/gb/album/does-santa-claus-visit-zombie/id949560711 ♪ https://yogscaststudios.bandcamp.com/album/does-santa-claus ♥ Charity christmas jumper: http://yogsca.st/XmasJumper ♥ Buy games for charity: http://games.yogscast.com ► The Official Yogscast Store: http://store.yogscast.com/ ◄ ♥ Subscribe: http://yogsca.st/SUBSCRIBE ♥ Website: http://www.yogscast.com Facebook: https://www.facebook.com/yogscast Instagram: http://instagram.com/yogscast Reddit: http://www.reddit.com/r/yogscast Twitter: @simonhoneydew @yogscastlewis Yogscast FAQ: http://www.yogscast.com/about/faq/ Lyrics: It’s Christmas Eve and the snow’s coming down We fixed Christmas for some last time around But when you’re laying down, snug in your bed Spend a thought for some others this season instead Christmas is great but in our time of plenty But with all these gifts I still feel empty Who brings cheer to those in fear? Won’t anyone think of the children here? Does Santa Claus visit Zombie Pig-men kids in the Nether in Minecraft at Christmas Time? How do his reindeer manage to fly with the world covered in bedrock o’ so high? Does Santa Claus visit Zombie Pig-men kids in the Nether in Minecraft at Christmas Time? If he can’t do it then it’s up to you and I Zombie Pig-men kids in the Nether It’s not just Ghasts that are shedding a tear But we can help them together Or they’re not getting anything this year So open your wallets of leather Two gold bars a month for the rest of your days We need money to stop this forever We know you’re all stingy but change your ways Hey zombie pig kids yo listen up If you're looking for a gift son, you’re In Luck. Sloth man, G money, P Horny too, Hat films, onesies, rapping cheer for you! Rhymes go bang, dropping gifts any weather, Blowing up Treats like be… | ["Christmas music", "Music"] | ["duet", "male vocalist", "female vocalist", "children’s song", "strong", "electric guitar rhythm", "steady drumming", "digital drum beat", "synthesiser arrangement", "story telling", "soft", "melodious", "melodic amplified piano"] | 7 | DP2vmsftZHY | 1471 | |
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;