musiccaps_details (view)

3 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "nostalgia" and musiccaps_aspects contains "western classical music"

✎ 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
Richard Strauss: Horn Concerto No.1 in Eb major, Op.11, I The song is an instrumental. The tempo is medium with a horn playing melody accompanied, by a string section, horn section and a rhythm section and led by a conductor. The song is exciting and regal. The song is a classical western tune. 2008-04-20T12:01:14Z musicvideoing Timothy Brown (Horn) / Evergreen Symphony Orchestra (長榮交響樂團) Lim Kek-Tjiang (林克昌) ["Brass instrument", "French horn"] ["philharmonic orchestra", "horn player", "horn melody", "string section", "brass section", "horn section", "conductor", "composer", "western classical music", "instrumental music", "victory march", "timpani’s", "violins", "exciting", "enthusiastic", "nostalgia", "great memories", "victories", "emotional", "splendour", "clarinets", "pomp and glory", "medium tempo"] 1 4CkJjhuYRmY 546
Rowland by William Byrd on virginal The song is an instrumental. The tempo is medium with a harpsichord being played expertly with no other instrumentation. The song is melancholic and exciting. The song is western classical baroque piece that evokes a sense of grandeur. 2012-03-01T07:57:04Z My Years With Early Music also know as Lord Willoughby's Welcome home, from the Fitzwilliam Virginal Book. http://en.wikipedia.org/wiki/Fitzwilliam_Virginal_Book edition by Dover: http://store.doverpublications.com/0486210693.html ernst stolz ["Harpsichord", "Keyboard (musical)", "Piano"] ["harpsichord", "instrumental player", "william byrd", "rowland", "grandeur", "great composers", "sight reading", "western classical music", "baroque music", "traditional stringed instrument", "royal music", "instrumental music", "soloist", "kings and queens", "medium tempo", "western classical music", "greta composers", "dance music", "people dancing", "nostalgia", "emotional", "entertaining", "positive", "cheerful comforting", "relaxing music", "the kings court"] 1 YOG_PPvTvW0 3284
The Legend Of Zelda - MEDLEY - Piano and Violin cover The song is an instrumental. The song is medium tempo with a violin playing a solo with a piano accompaniment. The song is emotional and positive. The song is a classic western hit and has poor audio quality in general. 2010-07-23T16:32:17Z Furyxx Violin ZELDA MEDLEY on Piano and violin ! Hey guys ! Thx you everybody for your support ! Don't forget to share and suscribe if you liked it :) Here is our new video after a long time !! (this time it's the real one !) Music from Zelda, koji Kondo Enjoy! ;) ps: We know that we need a little hair cut :p ["Music", "Musical instrument", "Piano", "Violin, fiddle", "Classical music"] ["piano accompaniment", "violin solo", "instrumental music", "music rehearsal", "classical duet", "medium tempo", "western classical music", "studio chamber echo", "instrumental music", "memdium tempo", "emotional", "dance groove", "cheerful", "spirited", "nostalgia", "good day", "poor audio quality", "home video quality", "entertaining", "classical dance", "composers"] 1 hkWcUtga1lw 4135

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;