musiccaps_details (view)
3 rows where musiccaps_aspects contains "march" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- march · 3 ✖
- brass 2
- classical music 2
- epic 2
- orchestra 2
- tuba 2
- anthem 1
- brass instrument 1
- cheerful 1
- french horn 1
- important 1
- instrumental 1
- king 1
- live performance 1
- melancholic 1
- momentous 1
- movie music 1
- orchestral 1
- presence 1
- queen 1
- regal 1
- slow tempo 1
- solemn 1
- timpani 1
- trombone 1
- trombones 1
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 | |
Mnozil Brass and Band of Flight -- Florentiner March | This is a live classical music performance. The piece is being performed by a brass orchestra. There is a trombone playing the lead melody while other trombones and a tuba play the bass backing. The atmosphere is epic. This piece could be playing in the soundtrack of a historical drama movie during the scenes of an army marching towards the enemy territory. | 2010-03-22T14:42:36Z | Michael Mench | UPDATE: The full version is finally up!! http://www.youtube.com/watch?v=UYohC-M22GA The Mnozil Brass joined the USAF Band of Flight on stage at the National Museum of the USAF 20 March 2010 for a concert. Florentiner closed the first half. | ["Brass instrument", "Trombone", "Trumpet"] | ["classical music", "live performance", "orchestra", "brass", "trombone", "tuba", "march", "epic", "cheerful"] | 9 | L9GXrmmlYhE | 2154 | |
Indian Kings Maharajahs and Queens Maharani in 1900s | This clip is regal, momentous, big, impressive. We hear a loud bang on the timpani percussion instrument, followed by a motif on the french horn. This is the type of piece that would be played for the arrival of a king, or the return of an epic war hero. | 2011-10-27T22:06:43Z | KoSh Films | Mahārāja (also spelled maharajah) is a Sanskrit title for a "great king" or "high king". The female equivalent title Maharani (or Maharanee, Mahārāñī ) denotes either the wife of a Maharaja or, in states where that was customary, a woman ruling in her own right. The widow of a Maharaja is known as a Rajamata. On the eve of independence in 1947, India (including present day Pakistan & Bangladesh) contained more than 600 princely states, each with its own ruler, often styled Raja or Thakur (if the ruler were Hindu) or Nawab (if he were Muslim), with a host of less current titles as well. Despite its literal meaning, unlike many other titles meaning Great King, neither Maharaja nor Rajadhiraja ('King of Kings'), nor even its equivalent amongst Maharajas, 'Maharajadhiraja', ever reached the standing required for imperial rank, as each was soon the object of title inflation. Instead, the only Hindu title which is commonly rendered as Emperor is Samraat or Samraj(a), a personal distinction achieved by a few rulers of ancient dynasties such as the Mauryas and Guptas. Another word for emperor is sārvabhaumā. As many Indonesian states started out when the archipelago was still predominantly Hindu (Bali still is) or Buddhist, some have been ruled by a maharaja, such as Srivijaya, Majapahit and Kutai Karta Negara (until that kingdom converted to Islam in 1565, when the Muslim title of sultan was adopted). Traditional titles remain in use for the other members of this dynasty, such as Pangeran Ratu for the heir. | ["Brass instrument", "Trumpet"] | ["regal", "important", "presence", "brass instrument", "french horn", "timpani", "orchestral", "momentous", "king", "queen", "march"] | 3 | kmmK69N3Om0 | 4357 |
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;