musiccaps_details (view)
2 rows where musiccaps_aspects contains "female vocalist" and musiccaps_aspects contains "male vocalist" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- female vocalist · 2 ✖
- male vocalist · 2 ✖
- synthesiser arrangement 2
- children’s song 1
- contemporary hip-hop 1
- digital drum 1
- digital drum beat 1
- drum machine 1
- duet 1
- electric guitar rhythm 1
- melodic amplified piano 1
- melodious 1
- soft 1
- steady drumming 1
- story telling 1
- strong 1
- turkish 1
- turkish artists 1
- turkish hip hop hits 1
- turkish hip-hop 1
- turkish rappers 1
- turkish song 1
- two artists 1
- two separate tracks 1
musiccaps_names (array) 4 ✖
- Music 2
- Christmas music 1
- Hip hop music 1
- Rapping 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
karşılıklı dissler | This music is two separate tracks of two Turkish Rap/Hip-Hop artists. The male and female artists sing a fast tempo, energetic, enthusiastic, spirited and youthful Rap. This is contemporary Turkish Hip-Hop. | 2007-08-11T10:51:38Z | unspoken120 | dissler türkçe rap turkish rap sagopa kajmer ceza kolera ayben fuat ergin hemsta alaturka mazer kuvvetmira kadiköy acil batı berlin | ["Music", "Rapping", "Hip hop music"] | ["male vocalist", "female vocalist", "turkish artists", "turkish rappers", "contemporary hip-hop", "turkish song", "two separate tracks", "two artists", "turkish hip-hop", "turkish hip hop hits", "turkish", "drum machine", "digital drum", "synthesiser arrangement"] | 7 | sYJiHxmQWjo | 4959 | |
♪ 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;