musiccaps_details (view)
4 rows where musiccaps_aspects contains "uptempo" and musiccaps_names contains "Double bass" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- uptempo · 4 ✖
- classical 3
- upright bass 3
- orchestra 2
- celli 1
- classical/experimental 1
- elevating energy 1
- foot stomping 1
- string section 1
- tension building 1
- tension creating 1
- uplifting mood 1
- violins/violas 1
musiccaps_names (array) 7 ✖
- Bowed string instrument 4
- Double bass · 4 ✖
- Cello 3
- Violin, fiddle 2
- Keyboard (musical) 1
- Piano 1
- String section 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
George Banos - Haydn Violin concerto No.2 | This composition contains a small orchestra playing melodies on violas and violins in the higher mid range to the higher register. The celli and the upright bass being stroked with a bow are playing a rhythmic melody part that gives the foundation of the song. This song may be playing live as a classical concert. | 2010-07-05T18:59:50Z | Chronis Banos | Haydn Violin concerto No.2 1st movement George Banos, violin, age 10 Camerata of Athens 2010, Athens Megaron Music Hall Professor Dimitris Semsis-Musical Horizons Conservatory | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["classical", "orchestra", "upright bass", "celli", "violins/violas", "uptempo", "uplifting mood"] | 6 | VB82vMSTYK0 | 2980 | |
Hiccupping | This audio contains an orchestral classical composition played by string instruments. violins/violas are playing the main melody in a higher key. The piece sounds fast paced and elevating. This song may be playing live sitting in an orchestra performance. | 2009-03-13T02:22:08Z | Nathan Baker | My first project in my film class. Enjoy | ["Cello", "Double bass", "String section", "Keyboard (musical)", "Piano", "Violin, fiddle", "Bowed string instrument"] | ["classical", "orchestra", "string section", "uptempo", "elevating energy"] | 6 | UkTWmyy7ia8 | 2939 |
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;