musiccaps_details (view)
4 rows where musiccaps_aspects contains "orchestral" and musiccaps_names contains "French horn"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- orchestral · 4 ✖
- classical 2
- horn 2
- slow tempo 2
- soothing 2
- string section 2
- cymbal 1
- epic 1
- flat male vocal 1
- french horn solo 1
- glockenspiel 1
- jazz 1
- low quality 1
- oboes/flutes 1
- powerful 1
- sustained brass melody 1
- sustained strings 1
- wide huge percussions 1
- woodwinds 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 |
---|---|---|---|---|---|---|---|---|---|---|
World of Warships - 1:42 Scale: Cruiser Varyag | The low quality recording features a short snippet of flat male vocal talking, while in the background an orchestral music is playing. The music contains sustained brass melody, wide huge percussion and sustained strings melody. It sounds powerful and epic. | 2016-01-27T14:26:16Z | Wargaming Europe | They are small, only 1:42 in scale compared to their real-life counterparts, but they have great stories to tell. New video in our series focuses on Russian cruiser Varyag. To keep up to date with our latest development, contests and events visit http://worldofwarships.eu/ Follow us on Facebook: http://www.facebook.com/worldofwarships Instagram: https://instagram.com/Wargaming_EU/ Vine: https://vine.co/Wargaming_EU Twitter: https://twitter.com/Wargaming_netEN https://twitter.com/Wargaming_netCZ https://twitter.com/Wargaming_netDE https://twitter.com/Wargaming_netES https://twitter.com/Wargaming_netFR https://twitter.com/Wargaming_netPL https://twitter.com/Wargaming_netTR | ["Brass instrument", "French horn"] | ["low quality", "orchestral", "sustained brass melody", "wide huge percussions", "sustained strings", "flat male vocal", "epic", "powerful"] | 4 | W4eLgBYEEqA | 3060 | |
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 | |
Solo de trompa 2 - Adalto Soares - Orquestra de Sopros Brasileira (Tatuí) | French horn solo with orchestral accompaniment, woodwinds, glockenspiel and cymbals. The genre is jazz and classical. | 2011-12-17T15:16:44Z | Rafael Sobral | Quatro Peças Brasileiras para Trompa e Banda O Rei do Maracatu A Bandinha no Coreto Quando não se Sonha mais Frevando Sem Parar | ["Brass instrument", "French horn"] | ["french horn solo", "glockenspiel", "orchestral", "woodwinds", "jazz", "classical", "cymbal"] | 8 | p0oRrGDrQQw | 4675 | |
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;