musiccaps_details (view)
2 rows where musiccaps_aspects contains "cymbals crashing" and musiccaps_aspects contains "inspiring"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- cheerful 2
- cymbals crashing · 2 ✖
- groovy bass line 2
- inspiring · 2 ✖
- male singer 2
- accordion accompaniment 1
- amateur music mix 1
- animated vocals 1
- backups singers 1
- cartoon show music theme 1
- children’s education program 1
- children’s favourites 1
- choppy music 1
- choral harmony 1
- crooning 1
- cumbria rhythm 1
- dance rhythm 1
- disconcerting music 1
- dj 1
- emotional 1
- funny 1
- groovy 1
- groovy bas slime 1
- latin percussions 1
- latin rhythm 1
- medium tempo 1
- mismatched tempos 1
- motivational 1
- movie soundtrack 1
- passionate 1
- percussion bells 1
- poor audio quality 1
- pop song 1
- pop superhit 1
- quacking vocals 1
- remix 1
- retro pop songs 1
- steady drumming rhythm 1
- steady marching rhythm 1
- stylish singing voice 1
- various percussion hits 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
🎉Quack, Quack, Quack, Donald Duck🎈 | A male singer sings this cool retro melody with duck quacking sounds. The song is medium tempo with a steady drumming rhythm with various funny percussion hits, accordion accompaniment and a groovy bass line. The song is inspiring and nostalgic. The song has an average audio quality. | 2016-06-09T22:21:22Z | House of Mizfitz | It's Donald Duck's Birthday Today and We Misfits Want To Celebrate and Show How Much We Appreciate and Love Our Misfit Duck, Because Donald Has Been There For Me Even Before Ralphie Reformed, When He Was The Villain Ralphscoe, That's Right Donald was like Ralphie's Mr. Smee, Le'Fou, Fidget, Iago and You Get The Idea Now That They're Both Reform They're Still A Great Duo, Donald is A True Friend and Member of The Misfits and We Want to Wish Him A Happy Birthday Reality Talk: Donald Duck is seriously my first favorite cartoon, hard to believe but I actually do learn a lot from this duck and he always manage to make me smile no matter what when I was a baby and even now, thanks Donald :D | ["Music", "Quack", "Duck"] | ["male singer", "stylish singing voice", "groovy bass line", "quacking vocals", "medium tempo", "cymbals crashing", "percussion bells", "various percussion hits", "funny", "cheerful", "animated vocals", "dance rhythm", "accordion accompaniment", "cartoon show music theme", "inspiring", "motivational", "children’s education program", "movie soundtrack", "retro pop songs", "children’s favourites", "steady marching rhythm"] | 1 | C0sSgrr5xrQ | 1318 | |
Happy Version cumbia - Pharrell Williams (Tato Dj) | A male singer sings this pop melody with back up singers in choral harmony. The song is medium tempo with a superimposed Latin Cumbia rhythm, which creates a discombobulated rhythm structure. The song audio quality is very poor. | 2014-03-14T22:04:39Z | Viktor Radchenko | Tato DJ Twitter: https://twitter.com/Tatoarata Original song by Pharrell Williams | ["Music", "Maraca"] | ["cumbria rhythm", "pop song", "choppy music", "latin rhythm", "disconcerting music", "cheerful", "pop superhit", "emotional", "inspiring", "groovy", "passionate", "male singer", "backups singers", "crooning", "choral harmony", "groovy bas slime", "steady drumming rhythm", "poor audio quality", "remix", "dj", "cymbals crashing", "groovy bass line", "latin percussions", "mismatched tempos", "amateur music mix"] | 1 | C6roSYqchkk | 1331 |
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;