musiccaps_details (view)
4 rows where musiccaps_author = 6 and youtube_channel = "Berliner Philharmoniker"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Stravinsky: Le Sacre du printemps / Rattle · Berliner Philharmoniker | This piece is full of orchestra instruments playing a sequence full of rapid changes with a little darker emotions. Sounding gigantic, dangerous and heroic. This song may be playing at a live concert or for a scene in a movie. | 2013-03-06T10:22:40Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/3401/?a=youtube&c=true Igor Stravinsky: Le Sacre du printemps (revised version from 1947) / Sir Simon Rattle, conductor · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 9 November 2012 The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Timpani", "Music", "Musical instrument", "Orchestra", "Classical music"] | ["orchestral", "brass-section", "flutes", "strings", "timpanis", "upright basses", "oboes", "cinematic", "medium tempo"] | 6 | 6F8qv0JBWkE | 737 | |
Holliger: Preludio e Fuga / Edicson Ruiz | This audio contains someone playing an upright bass with a bow creating a dissonant melody and tension. This song may be playing at a live concert. | 2010-06-07T08:55:02Z | Berliner Philharmoniker | Edicson Ruiz, double-bass player of the Berliner Philharmoniker, performs Heinz Holliger's Preludio e Fuga for solo double bass in Viennese tuning. The work is dedicated to Edicson Ruiz and was premiered by him on 16 March 2010 in the Chamber Music Hall of the Berlin Philharmonie. Edicson Ruiz's official website: http://www.edicsonruiz.com The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Double bass", "Bowed string instrument"] | ["classical/experimental", "upright bass", "foot stomping", "tension creating", "uptempo"] | 6 | Kkqbi6c_40k | 2114 | |
Berliner Philharmoniker Master Class - Double Bass | This audio contains someone playing an upright bass with a bow. The melody sounds a little bit dangerous and tension building. This song may be playing in a movie scene where someone is being followed. | 2010-10-19T07:18:59Z | Berliner Philharmoniker | Klaus Stoll gives a master class for the YouTube Symphony Orchestra 2011 introducing the double bass part in Beethoven's Symphony No. 5. Learn more at http://www.youtube.com/symphony Working with young musicians and making classical music available to a worldwide audience on the Internet are main objectives of the Berliner Philharmoniker. The orchestra is therefore delighted to support the unique project of a YouTube Symphony Orchestra. The Berliner Philharmoniker's Digital Concert Hall: http://www.digital-concert-hall.com Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter | ["Cello", "Double bass", "Bowed string instrument"] | ["classical", "upright bass", "tension building", "uptempo"] | 6 | OyouRYAq-tE | 2487 | |
Mahler: Symphony No. 7 / Rattle · Berliner Philharmoniker | In this piece a timpani takes a strong loud position before other orchestral instruments are entering the musical composition. Brasses, flutes and strings are playing a rising rhythmical melody creating tension. This song may be playing in a classical chamber concert or in a scene of a superhero movie. | 2012-02-24T10:23:03Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/2424/?a=youtube&c=true Gustav Mahler: Symphony No. 7 / Sir Simon Rattle, conductor · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 26 August 2011 The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Timpani", "Brass instrument", "Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music"] | ["classical/orchestra", "cinematic", "tension building", "timpani", "brass", "flutes", "strings", "medium to uptempo"] | 6 | _IkLUOsNHAA | 3461 |
Advanced export
JSON shape: default, array, newline-delimited
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;