musiccaps_details (view)
1 row where musiccaps_aspects contains "duet", musiccaps_aspects contains "soft", musiccaps_aspects contains "strong" 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 |
---|---|---|---|---|---|---|---|---|---|---|
♪ 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 |
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;