musiccaps_details (view)
3 rows where musiccaps_aspects contains "timpani", musiccaps_author = 3 and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- timpani · 3 ✖
- big 1
- brass instrument 1
- brass instruments 1
- build-up 1
- clarinets 1
- classical music 1
- cymbals 1
- epic 1
- exciting 1
- french horn 1
- french horns 1
- grand 1
- important 1
- important moment 1
- impressive 1
- king 1
- march 1
- momentous 1
- orchestra 1
- orchestral 1
- presence 1
- queen 1
- regal 1
- thrilling 1
- trumpet 1
- trumpets 1
- tuba 1
- uplifting 1
musiccaps_names (array) 7 ✖
- Brass instrument · 3 ✖
- Classical music 2
- Music 2
- Orchestra 2
- Timpani 2
- Musical instrument 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Richard Strauss - Also Sprach Zarathustra (das Ziege) [Opening of 2001: A Space Goat Odyssey] | This is a classical orchestral piece. The melody played on the trumpets feels like a prelude to an important, impressive moment. This music would suit any momentous occasion - like the countdown to a rocket launch. | 2013-02-28T09:51:34Z | switchmodthree | Wait for it... :) --------------------- Source: http://www.youtube.com/watch?v=Y9QxaJLt7EA | ["Timpani", "Brass instrument", "Music", "Musical instrument", "Orchestra", "Classical music"] | ["classical music", "brass instruments", "trumpets", "timpani", "build-up", "epic", "uplifting", "impressive"] | 3 | LSaLPObrnZw | 2190 | |
Shostakovich: Symphony No. 12 / Dudamel · Berliner Philharmoniker | This is a symphonic orchestra playing a piece that's riveting, thrilling and exciting. The peace would be suitable in a movie when something grand and impressive happens. There are clarinets, tubas, trumpets and french horns being played. The brass instruments help create that sense of a momentous occasion. The percussion is done on timpanis and a cymbal. | 2009-12-29T09:21:58Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/248/?a=youtube&c=true Dmitri Shostakovich: Symphony No. 12 "The Year 1917" / Gustavo Dudamel, conductor · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 19 September 2009. The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Timpani", "Brass instrument", "Music", "Orchestra", "Classical music"] | ["timpani", "orchestra", "grand", "big", "french horns", "tuba", "trumpet", "clarinets", "cymbals", "thrilling", "exciting", "important moment"] | 3 | XM4hxyK-Ddo | 3178 | |
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;