musiccaps_details (view)

1 row where musiccaps_aspects contains "dance rhythm", musiccaps_aspects contains "inspiring" 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

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;