musiccaps_details (view)
3 rows where musiccaps_aspects contains "brass section" and musiccaps_aspects contains "passionate" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- brass section · 3 ✖
- passionate · 3 ✖
- philharmonic orchestra 3
- building anticipation 2
- conductor 2
- energetic 2
- horn section 2
- instrumental music 2
- medium tempo 2
- poor audio quality 2
- spirited 2
- western classical music 2
- bassoons 1
- clarinet player 1
- clarinets 1
- composer 1
- composers 1
- concert hall 1
- creating fear 1
- drums playing furiously 1
- eerie 1
- emotional 1
- exciting 1
- grand 1
- high pitched melody 1
- humour 1
- life changing moments 1
- live audience 1
- live performance 1
- loud drumming 1
- majestic 1
- male bravado 1
- male opera singer 1
- ominous 1
- opera hall 1
- pomp 1
- scary 1
- steady marching rhythm 1
- string orchestra 1
- string section 1
- syncopated rhythms 1
- tense 1
- timpani percussions 1
- timpani playing 1
- trumpets 1
- trumpets blaring 1
- tubas 1
- utmost importance 1
- victory march 1
musiccaps_names (array) 7 ✖
- Music 2
- Brass instrument 1
- Clarinet 1
- Soundtrack music 1
- Theme music 1
- Timpani 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Immer Kleiner Philips Harmonie | The song is an instrumental. The tempo is medium with a clarinet playing lead supported by a wind section, horn section, brass section and other percussion. The song is exciting and energetic. The song is a western classic tune with bad audio quality issues. | 2010-02-08T15:01:49Z | juudruud | Guido van de Ven speelt 'Immer Kleiner' tijdens het nieuwjaarsconcert 2010 van de Philips Harmonie. dirigent: Matty Cilissen special guest star: Jos de Wit Guido van de Ven plays 'Always Smaller'. Newyearconcert 2010 Philips Harmonie Eindhoven. conductor: Matty Cilissen special guest star: Jos de Wit Bekijk ook het officiële Philips Harmonie Youtube-kanaal https://www.youtube.com/channel/UCD7B2SzauFUtJ58DHheWy4w | ["Brass instrument", "Clarinet", "Trumpet"] | ["clarinet player", "horn section", "brass section", "philharmonic orchestra", "instrumental music", "trumpets", "conductor", "medium tempo", "instrumental music", "concert hall", "high pitched melody", "syncopated rhythms", "grand", "exciting", "pomp", "humour", "energetic", "passionate", "composers", "conductor", "live audience", "live performance", "poor audio quality", "spirited", "tubas", "clarinets", "bassoons"] | 1 | Z-Vb1Ay-zNA | 3333 | |
Ultramarines Soundtrack Track 1 - Steel and Doom | A male opera singer sings this majestic operatic song with a philharmonic orchestra accompaniment, trumpets blaring, string section accompaniment and a strong rhythm section with loud timpani playing. The song is energetic and dramatic. The song is a movie soundtrack and western classic song with poor audio quality. | 2011-09-15T17:18:20Z | Geisto | Track 1 Steel and Doom, Sign up for Warhammer 40k, Eternal Crusade!! https://www.eternalcrusade.com/account/sign-up/?ref_code=EC-4R9LMSPIXVVW9 The amazing soundtrack from the Ultramarines Movie, Performed by Adam Harvey. http://ultramarinesthemovie.com/shop | ["Timpani", "Music", "Soundtrack music"] | ["poor audio quality", "male opera singer", "building anticipation", "philharmonic orchestra", "string orchestra", "passionate", "energetic", "steady marching rhythm", "medium tempo", "loud drumming", "majestic", "victory march", "western classical music", "male bravado", "instrumental music", "timpani playing", "trumpets blaring", "brass section"] | 1 | Pf9AaTV4-yw | 2555 | |
Goat Farming in Hyderabad Livestock and Farms (HLSF), Andhra Pradesh, India | The song is an instrumental piece. The song is medium tempo with a furiously playing timpani percussion, string section playing, horns playing and low pitched harmony that evokes danger and suspense. The song is a modern western classical instrumental. | 2013-01-03T13:24:59Z | HydLiveStock | Goat Farming in Hyderabad Livestock and Farms, Andhra Pradesh, India www.HyderabadLivestock.com Phone:+91 939 488 7040 | ["Theme music", "Music"] | ["western classical music", "tense", "ominous", "utmost importance", "life changing moments", "eerie", "spirited", "passionate", "opera hall", "creating fear", "timpani percussions", "drums playing furiously", "string section", "conductor", "composer", "horn section", "brass section", "emotional", "scary", "building anticipation", "philharmonic orchestra"] | 1 | whZygh228yw | 5284 |
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;