musiccaps_details (view)
2 rows where musiccaps_aspects contains "french horn", musiccaps_aspects contains "regal" and musiccaps_names contains "French horn"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- french horn · 2 ✖
- regal · 2 ✖
- ascending melody 1
- classical style piece 1
- descending melody 1
- grand parade 1
- live recording 1
- marching 1
- parade 1
- sextet 1
- staccato bass notes 1
musiccaps_names (array) 2 ✖
- Brass instrument 2
- French horn · 2 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
YouTube Symphony 2011 , Asen Angelov - French Horn.MP4- BRASIL | This is a live recording of a section on the french horn, played in classical style. The piece ascends rapidly and then descends rapidly. The piece has a regal and important feel to it. | 2010-11-28T07:25:49Z | miramazon | 1. W.A.Mozart - Horn Concerto KV 495 , 1 movement, mm.36 - 87. 2. R.Strauss - Til Eulenspiegel , beginning to 1. 3. R.Strauss - Don Juan , 4 bars befor Y to Z. 4. Beethoven - Simphony No. 9 , 3rt movement, 4th horn- 83 to 98 5. Mendelsson - Midsummer Night,s Dream - Nocturne - beginning to measure 35. | ["Brass instrument", "French horn"] | ["french horn", "classical style piece", "ascending melody", "descending melody", "live recording", "regal"] | 3 | Lwvf17xUxhE | 2230 | |
📯A Night at the Movies // French Horn Medley | This piece involves multiple french horns. The piece sounds regal and like something you would hear if the king of a country was moving in his chariot through his kingdom along with a grand parade. The staccato bassline helps add to the sense of marching forward. | 2016-05-06T12:05:02Z | FhornPatrick | MY STUFF: SHEET MUSIC: https://hornsandstuff.bigcartel.com HORN’S I USE: CONN 8D: http://amzn.to/2mW3Ezn HOLTON 179: http://amzn.to/2nrmMRP YAMAHA 567: http://amzn.to/2mW3cAU YAMAHA 688: http://amzn.to/2nIbCLd MUTE: http://amzn.to/2nnqsn1 MIC’S I USE: SM 57: http://amzn.to/2nrkZMH SM 7B: http://amzn.to/2nrdgOO CASE I USE: http://amzn.to/2nrrUpl CAMERA I USE: http://amzn.to/2ojDiY6 ALTERNATIVE CAMERA: http://amzn.to/2nnqQSp LENS I USE: http://amzn.to/2nrlEOb ON CAMERA MIC: http://amzn.to/2oH8sFf PENCIL CLIP: http://amzn.to/2nrgvpw CLEANING KIT: http://amzn.to/2nrmGd1 OIL: http://amzn.to/2nrdtBD HEADPHONES: http://amzn.to/2opQCY6 BOOKS YOU NEED TO BUY: http://amzn.to/2ojr95D http://amzn.to/2nngaDq http://amzn.to/2nrmGd1 http://amzn.to/2nniASl http://amzn.to/2nnq08g SnapChat: FhornPatrick Facebook: https://www.facebook.com/FhornPatrick Twitter: https://twitter.com/fhornpatrick Instagram: http://instagram.com/fhornpatrick | ["Brass instrument", "French horn"] | ["french horn", "sextet", "parade", "marching", "regal", "grand parade", "staccato bass notes"] | 3 | SwdhfGXkMCo | 2798 |
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;