musiccaps_details (view)

2 rows where musiccaps_aspects contains "dramatic" and musiccaps_names contains "Orchestra"

✎ 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
"Breathtaking Sights" - Erik Zilliacus (Piano, Orchestral) This is a contemporary classical music piece. It is an instrumental piece. There is a strings section playing the chords while the violin in the lead is playing a dramatic tune. The piano is playing accentuated notes. There is a percussion line in the rhythmic background. There is a dramatic atmosphere that is full of suspense. This piece could be used in the soundtrack of a sci-fi drama movie, especially during the scenes where a big revelation is about to take place. 2014-06-26T09:56:05Z TheMusicFlowChannel This was composed by Erik Zilliacus. For more music by the composer: https://youtube.com/user/drunkensailorful SoundCloud: https://soundcloud.com/erik-zilliacus TheMusicFlowChannel on Facebook: https://facebook.com/TheMusicFlowChannel Wallpaper: http://mediafire.com/convkey/73fa/mr0n5n56236eea4fg.jpg?size_id=a * TMFC has the permission to promote "Breathtaking Sights" by Erik Zilliacus. * ["Orchestra"] ["contemporary classical", "no singer", "instrumental", "violin", "strings", "piano", "percussion", "repeated theme", "dramatic", "suspense"] 9 7JE2eBK1f9M 828
March for Military Band, WoO 20. (Beethoven). Tokyo Kosei Wind Orchestra This is a classical music piece in the style of a military march. There is a wind orchestra playing the melody. In the rhythmic background, marching band elements such as the snare drum, the bass drum, the cymbal and the triangle can be heard. There is an epic atmosphere. This piece would fit perfectly in the soundtrack of a war video game. 2014-09-01T03:59:09Z Pablo Leal Recording of the Tokyo Kosei Wind Orchestra. When, in 1822, the publisher C. F. Peters requested music from Beethoven, the composer wrote out new scores of old works, including the Marches, WoO. 18-20, to which he added trios (the one for WoO 20 is in F major). Also, Beethoven renamed each march "Zapfenstreich" (tattoo). Peters found the works inferior and did not publish them. The March in C major, WoO. 20, was first printed in 1888 as part of the Complete Edition of Beethoven's Works, published in Leipzig by Breitkopf & Härtel. The March may have been first performed on August 25, 1810 at a tournament honoring the Empress Maria Ludovika, held in Laxenburg. The March in C major, WoO. 20, is for military band, including two each of oboe, clarinet, horn, trumpet, bassoon, tambourine and one each of piccolo, contrabassoon and triangle and a pair of cymbals. Like all marches, Beethoven's March in C major is similar to a minuet in form. The first theme is eight measures long and repeated exactly, closing on the dominant, G major. Although the theme is very narrow in range it is rhythmically active with a propulsive dotted-rhythm feel, accompanied incessantly by the triangle. Beethoven expands the traditional formal parameters of the second half of the march, modulating to D major and taking his time to reach the expected return to the main theme, after which he continues with developmental fragmentation before the repeat. The trio, in F major, is organized in a traditional fashion with the second half rounded out by the return to the first theme. The fluidity of the first part contrasts with the fortissimo chords of the second, which dissolves into a quieter dynamic for the reprise of the first theme. Considering the limits placed upon him by the genre, Beethoven's March in C major is quite imaginative and well written. ["Orchestra"] ["classical music", "military march", "wind orchestra", "snare drum", "bass drum", "cymbal", "triangle", "epic", "dramatic"] 9 g2H8i_TuhgI 4004

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;