musiccaps_details (view)
3 rows where musiccaps_aspects contains "epic", musiccaps_aspects contains "instrumental" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- epic · 3 ✖
- instrumental · 3 ✖
- classical music 2
- anthem 1
- baroque 1
- brass 1
- dramatic 1
- harpsichord 1
- intense 1
- live performance 1
- march 1
- medieval sounding 1
- melancholic 1
- military march 1
- movie music 1
- orchestra 1
- single instrument 1
- slow tempo 1
- solemn 1
- trombones 1
- tuba 1
- uilleann pipes 1
musiccaps_names (array) 7 ✖
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 | |
Mikie Smyth- Downfall of Paris | This is an instrumental military march music piece. The uilleann pipes are playing the piece at a medium-to-high range. The atmosphere is epic. This piece could be used in the soundtrack of a historical drama during the scenes of a victory parade. | 2006-11-10T23:30:03Z | snakei85 | Mikie Smyth performing the piece "The Downfall of Paris" in San Juan Capistrano, California in May of 2005. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["military march", "instrumental", "single instrument", "uilleann pipes", "epic"] | 9 | ZF8uHVu4Res | 3351 | |
G.F. Handel - Suite No. 7 in G minor, HWV 432 - Passacaille | This is a live performance of a classical music piece from the baroque era. The piece is being performed on a harpsichord. There is a medieval sound to the piece. The atmosphere is dramatic. This piece could be used in the soundtrack of a historical drama movie moments before a face-off or a battle. | 2013-03-16T19:51:17Z | Gabriella Di Laccio | Fernando Cordella - Harpsichord Crown Court Church London, Covent Garden march 2013 | ["Harpsichord", "Keyboard (musical)"] | ["classical music", "baroque", "live performance", "instrumental", "harpsichord", "medieval sounding", "dramatic", "epic", "intense"] | 9 | y5I5pq0bXmg | 5381 |
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;