musiccaps_details (view)
4 rows where musiccaps_aspects contains "passionate" and musiccaps_aspects contains "victory march" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 62 ✖
- instrumental music 4
- passionate · 4 ✖
- victory march · 4 ✖
- medium tempo 3
- ambient crowd noise 2
- crowds cheering 2
- energetic 2
- majestic 2
- spirited 2
- army band 1
- bad audio quality 1
- bagpipe harmony 1
- bagpipers playing 1
- bagpipes playing 1
- brass section 1
- building anticipation 1
- celtic music 1
- crowds clapping 1
- distorted sounds 1
- drum playing percussively 1
- drummer solo 1
- emotional 1
- enthusiastic 1
- exciting 1
- exciting solo 1
- female bagpiper 1
- game play 1
- game soundtrack 1
- groovy 1
- groovy bass 1
- high gain noise 1
- interactive game music 1
- live audience 1
- live performance 1
- loud drumming 1
- male bravado 1
- male opera singer 1
- march rhythm 1
- marching rhythm 1
- marching sounds 1
- medium fast tempo 1
- music game 1
- ominous 1
- patriotic music 1
- percussive play 1
- performer 1
- philharmonic orchestra 1
- poor audio quality 1
- rhythm section 1
- room echoes 1
- royal entry 1
- sense of duty 1
- serious business 1
- soldiers match 1
- steady marching rhythm 1
- string orchestra 1
- timpani playing 1
- timpani playing percussively 1
- trumpets blaring 1
- very poor audio quality 1
- war cry 1
- western classical music 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Julie Fowlis playing Bagpipe - Live | The song is an instrumental. The song is fast in tempo, with a bagpiper playing a Solo melody accompanied by a drum rhythm and people cheering and clapping wildly. The song is rousing in spirit and fervour. The song has a bad audio quality. | 2009-09-05T09:48:05Z | smartotrams | Live at Lüdenscheid, Germany 4th Sept 2009 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["female bagpiper", "bagpipes playing", "live performance", "live audience", "crowds clapping", "crowds cheering", "drum playing percussively", "exciting solo", "passionate", "celtic music", "war cry", "victory march", "bad audio quality", "ambient crowd noise", "performer", "instrumental music", "exciting", "energetic", "enthusiastic", "groovy bass", "rhythm section", "medium fast tempo"] | 1 | 0NTzOtVmoiU | 154 | |
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 | |
Air Corps Pipe Band Ireland - Cornemuse à Lourdes | The song is an instrumental. The bagpipes play together in unison and march to the sounds of crowds cheering and other ambient sounds. The song is patriotic like a victory march. The song has very bad audio quality. | 2012-05-15T21:34:02Z | gpainblanc | Chaque année une délégation irlandaise participe au pélérinage militaire international à Lourdes. S'il est une musique militaire fidèle au PMI, il s'agit bien de ce Pipe band. Voici quelques enregistrements effectués lors du 54ème PMI, en mai 2012 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["bagpipers playing", "army band", "marching sounds", "instrumental music", "crowds cheering", "ambient crowd noise", "very poor audio quality", "distorted sounds", "high gain noise", "medium tempo", "spirited", "passionate", "victory march", "army band", "bagpipe harmony", "emotional", "patriotic music", "march rhythm"] | 1 | qBe_D8Gg5lA | 4762 | |
PSO2 ルームグッズ 楽器 トライアングル トランペット ヴォーカルマイク サイドギター ティンパニ コントラバス | The song is instrumental. The tempo is medium with timpani’s playing in a marching rhythm with room echoes. The song is energetic and has a sense of duty like a battle march. The song is an interactive game play soundtrack. | 2013-07-17T22:08:26Z | Tom Kannaduki | (C)SEGA 『PHANTASY STAR ONLINE 2』公式サイト http://pso2.jp/ | ["Timpani", "Music"] | ["instrumental music", "interactive game music", "percussive play", "drummer solo", "music game", "game play", "timpani playing percussively", "room echoes", "ominous", "medium tempo", "groovy", "victory march", "majestic", "royal entry", "serious business", "game soundtrack", "passionate", "spirited", "sense of duty", "soldiers match", "marching rhythm"] | 1 | GU782ddSBvk | 1726 |
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;