musiccaps_details (view)

1 row where musiccaps_aspects contains "brass section", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "wide strings section"

✎ 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
Classical Music 101: Fast, Frenetic, Chase Scene Music The low quality recording features an orchestra that contains a wide string section, aggressive triangle cymbal and woodwind section dynamically playing an addictive melody. It is very noisy, uptempo, energetic and dynamic. 2009-06-21T01:12:05Z Joe Baker Thirty to Sixty second clips of the twelve most popular classical music pieces used in film for fast action sequences. Contents 1. William Tell Overture The overture to the opera William Tell, its high-energy finale Theme song for The Lone Ranger. Gioachino Antonio Rossini Italy 1792 - 1868 2. Flight of the Bumblebee "Flight of the Bumblebee" is an orchestral interlude written by Nikolai Rimsky-Korsakov for his opera The Tale of Tsar Saltan, composed in 18991900. Nikolai Rimsky-Korsakov Russia 1844 - 1908 3. Sabre Dance The Sabre Dance is a movement in the final act of the Armenian composer Aram Khachaturian's ballet Gayane, completed in 1942. It evokes a whirling war dance in an Armenian dance, where the dancers display their skill with sabres. Aram Khachaturian Soviet-Armenian 1903-1978 4. Hungarian Dance No. 5 Johannes Brahms Germany 1833 - 1897 5. The Rite of Spring Dances of the Young Girls The Rite of Spring, commonly referred to by its original French title, Le Sacre du Printemps is a ballet with music by the Russian composer Igor Stravinsky. Igor Stravinsky Russia 1882 1971 6. Egmont Egmont, opus 84, by Ludwig van Beethoven, is a set of incidental music pieces for the 1787 play of the same name by Johann Wolfgang von Goethe. Ludwig van Beethoven 7. Dance of the Hours from La Giaconda Dance of the Hours is a ballet from the opera La Gioconda composed by Amilcare Ponchielli (Used in Disneys Fantasia) Amilcare Ponchielli Italy 1834 1886 8. Hungarian Rhapsody No. 2 arranged for orchestra Franz Liszt Hungary 1811 - 1886 9. Romeo and Juliet, Op.64 - Act 1 - 6/7. The fight - The duke's command From Sergei Prokofievs Ballet Sergei Prokofiev Russia 1891 - 1953 10. The Overture to The Barber of Seville by Gioachino Rossini (Used in Many Cartoons) Gioachino Rossini Italy 1792 - 1868 11. Overture to the Thieving Magpie La gazza ladra (The Thieving Magpie) is a melodramma or opera semiseria in two acts by Gioachino Rossini. The libretto w… ["Music", "Opera"] ["orchestra", "low quality", "noisy", "energetic", "dynamic", "wide strings section", "aggressive triangle cymbal", "uptempo", "brass section", "woodwind section"] 4 4S4NDnNTptY 570

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;