musiccaps_details (view)

2 rows where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "movie soundtrack" and musiccaps_names contains "Quack"

✎ View and edit SQL

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
🎉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
Donald Duck: Straigt Shooters 1947 The song is background audio of an animated tv show. The song is idyllic and performed by an orchestra with organ playing lead, flutes and rhythm section. The song is of average audio quality. The audio track is animated and cartoon-like. 2009-08-18T08:18:37Z donaldduckforever Part of The Chronological Donald Volume 3 1947-1950 Made by: Disney I wish to share my child hood memory's with every one! I grew up with this cartoon, and wish for every one else to watch them to! Please sit down and watch my child hood cartoon :D Enjoy ["Music", "Quack"] ["ducky quack sounds", "animated show", "distorted vocals", "funny", "animated show", "children’s show", "average quality audio", "people", "chattering", "ambient street noises", "tv show", "cartoony vocals", "happy", "cheerful", "orchestra playing", "organ accompaniment", "flutes playing", "medium tempo", "idyllic music", "show tune", "movie soundtrack"] 1 d352jaSSiFw 3760

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;