musiccaps_details (view)
3 rows where musiccaps_aspects contains "strings" and musiccaps_names contains "Violin, fiddle" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- strings · 3 ✖
- bass trombone 1
- brass 1
- brass section 1
- cinematic 1
- classical/orchestra 1
- flutes 1
- horn section 1
- instrumental 1
- medium to uptempo 1
- no percussion 1
- no voices 1
- orchestra 1
- orchestral ballade 1
- symphonic song 1
- tension building 1
- theme of impending danger 1
- timpani 1
- uplifting mood 1
musiccaps_names (array) 12 ✖
- Brass instrument 3
- Violin, fiddle · 3 ✖
- Bowed string instrument 2
- Orchestra 2
- Cello 1
- Classical music 1
- Double bass 1
- French horn 1
- Music 1
- Musical instrument 1
- Timpani 1
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mahler Symphony No 5, horn solos 3rd mov- Abel Pereira | This symphonic song features an orchestra. At the beginning, a French horn plays a melody. This is followed by a harmony played by the string section and brass section. There is no percussion in this song. This song is uplifting. The mood of this song is suspenseful. This song can be played in a movie where a dangerous scene is taking place. | 2012-05-01T15:03:06Z | brassgang2 | Mahler Symphony No 5, horn solos 3rd mov - Abel Pereira, Porto Symphony Orchestra, Casa da Música, Orquestra Sinfónica do Porto | ["Brass instrument", "Cello", "Double bass", "French horn", "Orchestra", "Violin, fiddle", "Bowed string instrument"] | ["symphonic song", "orchestra", "horn section", "no percussion", "strings", "brass section", "instrumental", "no voices", "uplifting mood", "theme of impending danger"] | 0 | v4sANJkuwP4 | 5151 | |
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 | |
Ballade for Bass Trombone, Harp and Strings | A bass trombone is playing a melody while violas and violins support with a long melody in the mid and higher register. This song may be playing live. | 2009-04-23T16:43:29Z | KarlWiederwohl | Composed by Eric Ewazen; Karl Wiederwohl, bass trombone. Live recital performance April 7, 2009. Videography by Krishna Bhamidipati. Due to YouTube's time limitations the video has been cut short. | ["Brass instrument", "Trombone", "Violin, fiddle", "Bowed string instrument"] | ["orchestral ballade", "bass trombone", "strings"] | 6 | nY4tpb8O_Rg | 4549 |
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;