musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "orchestra" and musiccaps_names contains "French horn"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- brass section 2
- instrumental · 2 ✖
- orchestra · 2 ✖
- classical 1
- festive 1
- french horn 1
- horn section 1
- joyful 1
- live performance 1
- no percussion 1
- no voices 1
- strings 1
- symphonic song 1
- theme of impending danger 1
- tubular bells 1
- uplifting mood 1
- vibrant 1
musiccaps_names (array) 7 ✖
- Brass instrument 2
- French horn · 2 ✖
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Orchestra 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cape Horn - Otto M. Schwarz - WK Laufen Gmunden-Engelhof | This is a classical music piece performed by an orchestra. There is a wide ranging brass section that has the french horn as the lead playing the melody. In the percussive background there are the tubular bells which give the piece a festive feel. The atmosphere is vibrant. This piece would fit perfectly in the soundtrack of a Christmas movie either as the opening theme or during the scenes where there is a preparation going on. | 2010-04-03T09:24:48Z | Franz Schindlauer | Livevideo vom Jahreskonzert 2010 der WK Laufen Gmunden Engelhof aus Toscana Congress Gmunden Solist: Christoph Wiesenberger - Horn Dirigent: Franz Schindlauer Ton: FS-Produktionen - Franz Schindlauer Video: Hörak-Film, Leopold Hörak | ["Brass instrument", "French horn"] | ["classical", "instrumental", "orchestra", "live performance", "brass section", "french horn", "tubular bells", "vibrant", "festive", "joyful"] | 9 | kMNL4Y4XMhc | 4311 | |
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 |
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;