musiccaps_details (view)
3 rows where musiccaps_aspects contains "anthem" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- anthem · 3 ✖
- epic 2
- animal sounds 1
- brass 1
- chant 1
- choir 1
- classical music 1
- comedy 1
- female vocals 1
- french 1
- high-pitched singing 1
- instrumental 1
- male voices 1
- march 1
- melancholic 1
- militaristic 1
- movie music 1
- orchestra 1
- parody 1
- perseverance 1
- slow tempo 1
- solemn 1
- trombones 1
- tuba 1
musiccaps_names (array) 7 ✖
youtube_published (date) 3 ✖
- 2010-08-25 1
- 2011-05-05 1
- 2014-02-04 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Klingon, Dolphin, and more Rejected Coke Ad Languages [Garlic Jackson Comedy] | This piece is a parody of an ad theme. There are female vocals singing at a high-pitch in the major scale, resulting in an epic atmosphere resembling an anthem. The resolution is interrupted by an implied bear attack, breaking the seriousness of the piece. | 2014-02-04T17:54:12Z | GarlicJacksonComedy | Which other languages did they miss? Subscribe! http://bit.ly/garlicjacksonsub Like us! http://facebook.com/GarlicJacksonComedy Check us out! http://GarlicJackson.com Follow us! https://twitter.com/garlicjackson Reach us! GarlicJackson@Gmail.com We are in no way affiliated with Coca Cola. In no way do the views expressed in this video reflect the views of the Coca Cola Company. This video was made for entertainment purposes only. No copyright infringement intended. | ["Humming", "Music", "Inside, large room or hall", "Outside, rural or natural"] | ["female vocals", "high-pitched singing", "anthem", "comedy", "parody", "animal sounds"] | 9 | 18mS4cLPOb8 | 240 | |
Chant Militaire - "J'avais un camarade" [paroles] | This is a military anthem sung by male voices in the French language. The choir sings in a grave but determined manner, implying a feeling of perseverance. There are no instruments. This piece could be used in parades or historical content related to the French army. | 2010-08-25T10:37:02Z | Citoyen | Chant militaire de la Légion Étrangère Française accompagné de photos de la Légion et des paroles. Pour ceux qui se demandent si ce chant est d'origine SS ou non, voici mon point de vue : Et bien oui et non ! C'est à l'origine un chant militaire allemand nommé "Der gute Kamerad" (Le Bon Compagnon) écrit par Ludwig Uhland, poète allemand, au début du 19ème siècle. Il est plus connu sous le nom de Ich Hatt' Einen Kameraden (première phrase du premier couplet). C'est devenu et reste un chant allemand de référence très populaire même en dehors de l'armée, aussi connu que l'hymne allemand (à l'instar du chant des partisans en France). Il a donc été interprété par les armées allemandes, y compris les SS. De là, à l'identifier comme un chant SS", non. Il n'a rien de SS. Il a été créé bien avant eux, n'y fait référence en rien, et n'a aucun caractère "nazi". C'est un beau chant sur la perte d'un camarade au combat. Je trouve donc dommage que certains le dénigrent car il a été chanté par des SS. Par équivalence, cela reviendrai à cracher sur l'Allemagne car elle a été un jour nazie. Il en va de même pour bons nombres de chants militaires allemands dont la France a héritée. | ["Mantra", "Music"] | ["chant", "anthem", "choir", "male voices", "militaristic", "perseverance", "epic", "french"] | 9 | 6c1vNidtVTc | 770 | |
ロンドンの小景(Ⅰ.Ⅴ.Ⅵ.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 |
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;