musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "orchestra", musiccaps_author = 9 and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ロンドンの小景(Ⅰ.Ⅴ.Ⅵ.ending) | This is a classical music piece that resembles the style of a march. It is an instrumental piece performed by a brass orchestra. The main theme is being played by the trombones while a bass line is played by the tuba. The tempo of the piece is slow and this creates an epic but solemn atmosphere. This piece would work perfectly as a movie music piece. It could be playing during the scenes of an important character dying. | 2011-05-05T04:37:45Z | hiroka2011 | アンサンブル発表会より。 | ["Brass instrument", "Foghorn", "Music"] | ["classical music", "march", "instrumental", "orchestra", "brass", "trombones", "tuba", "anthem", "epic", "solemn", "melancholic", "slow tempo", "movie music"] | 9 | Di7Rs4QmYKI | 1506 | |
Sibelius 7 Sounds - 3. Winds | This is a classical music piece played with the virtual sounds of a wind orchestra. The orchestra is composed of the oboe, the clarinet, the basset horn, the bassoon and the contrabass. The piece is in major key which gives the piece a more positive aura in general, but the virtual sounds make it feel inauthentic. | 2011-11-26T01:00:19Z | OrchestrationOnline | Third in a series of reviews of the new sound set from Sibelius 7. Please watch full-screen with high fidelity sound. Many thanks to special guest Justus Rozemond, contrabass clarinetist. | ["Brass instrument", "Clarinet", "Keyboard (musical)", "Piano", "Wind instrument, woodwind instrument"] | ["classical music", "no singer", "instrumental", "virtual sounds", "orchestra", "winds", "oboe", "clarinet", "basset horn", "bassoon", "contrabass", "major key", "positive", "inauthentic"] | 9 | GMFWnMRtfNI | 1711 | |
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 |
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;