musiccaps_details (view)
4 rows where musiccaps_aspects contains "string section" and musiccaps_names contains "French horn"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- string section · 4 ✖
- slow tempo 3
- horn 2
- orchestral 2
- soothing 2
- bells 1
- brass section 1
- clarinets 1
- classical 1
- classical music 1
- composer 1
- conductor 1
- emotional 1
- enthusiastic 1
- exciting 1
- great memories 1
- horn melody 1
- horn player 1
- horn section 1
- instrumental 1
- instrumental music 1
- medium tempo 1
- no voices 1
- nostalgia 1
- oboes/flutes 1
- philharmonic orchestra 1
- pomp and glory 1
- relaxing song 1
- splendour 1
- timpani’s 1
- trumpets 1
- victories 1
- victory march 1
- violins 1
- western classical music 1
- xylophone 1
musiccaps_names (array) 2 ✖
- Brass instrument 4
- French horn · 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Richard Strauss: Horn Concerto No.1 in Eb major, Op.11, I | The song is an instrumental. The tempo is medium with a horn playing melody accompanied, by a string section, horn section and a rhythm section and led by a conductor. The song is exciting and regal. The song is a classical western tune. | 2008-04-20T12:01:14Z | musicvideoing | Timothy Brown (Horn) / Evergreen Symphony Orchestra (長榮交響樂團) Lim Kek-Tjiang (林克昌) | ["Brass instrument", "French horn"] | ["philharmonic orchestra", "horn player", "horn melody", "string section", "brass section", "horn section", "conductor", "composer", "western classical music", "instrumental music", "victory march", "timpani’s", "violins", "exciting", "enthusiastic", "nostalgia", "great memories", "victories", "emotional", "splendour", "clarinets", "pomp and glory", "medium tempo"] | 1 | 4CkJjhuYRmY | 546 | |
The Elder Scrolls Online - Heavy Armor Preview (All Races) | This composition contains a horn playing a melody with reverb on it. Then a string section comes in playing a soothing melody rising and falling in pitch. You can hear some digital clicking sounds that seem not to belong to the musical composition. This song may be playing in a fantasy adventure video-game. | 2014-02-15T20:53:40Z | Birds | The Elder Scrolls Online Beta Armor Preview. All Races! Medium Armor: http://www.youtube.com/watch?v=yUVXHEYBeBk Light Armor: http://www.youtube.com/watch?v=M32D9Ai5uKk | ["Brass instrument", "French horn"] | ["orchestral", "string section", "horn", "soothing", "slow tempo"] | 6 | WKL40jfQD3g | 3086 | |
The hills are alive ( Julie Andrews-The Sound of Music) | This classical song features the main melody played by trumpets. This is accompanied by violins playing two note trills. A xylophone plays notes in the background. Church bells are played in the background. There is no percussion in this song. This is an instrumental song. There are no voices in this song. The mood of this song is relaxing. This song can be played in a magical scene in a movie. | 2012-05-04T04:18:50Z | scarletttarleton | Premier chant de Maria dans "The Sound of Music" (La Mélodie du bonheur) The hills are alive with the sound of music With songs they have sung for a thousand years The hills fill my heart with the sound of music My heart wants to sing every song it heard My heart wants to beat like the wings of the birds that rise from the lake to the trees My heart wants to sigh like the chime that flies from a church on a breeze To laugh like a brook when it trips and falls over stones on its way To sing through the night like a lark who is learning to pray I go to the hills when my heart is lonely I know I will hear what I've heard before My heart will be blessed with the sound of music And I'll sing once more. | ["Brass instrument", "French horn"] | ["classical music", "no voices", "string section", "bells", "trumpets", "instrumental", "relaxing song", "slow tempo", "xylophone"] | 0 | p_-lKpxLK3g | 4722 | |
R Strauss Horn Concerto No 1 - 2 Barry Tuckwell 1987 | This composition contains someone playing a solo melody on a horn in the mid to higher register. A string section, flutes and oboes are supported with a short rising harmony. This song may be playing live while listening to an orchestra. | 2009-05-24T20:19:57Z | hkakita | With NHK Symphony Orchestra, Japan | ["Brass instrument", "French horn"] | ["classical", "orchestral", "horn", "string section", "oboes/flutes", "soothing", "slow tempo"] | 6 | t3-xANiQrho | 4999 |
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;