musiccaps_details (view)
4 rows where musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "trumpets blaring"
This data as json, CSV (advanced)
musiccaps_aspects (array) 64 ✖
- medium tempo · 4 ✖
- trumpets blaring · 4 ✖
- instrumental music 3
- brass band 2
- passionate 2
- philharmonic orchestra 2
- poor audio quality 2
- steady drumming rhythm 2
- triumphant 2
- western classical music 2
- beachside party 1
- brass band harmony 1
- brass section 1
- building anticipation 1
- caribbean music style 1
- caribbean percussions rhythm 1
- cinco de mayo 1
- classic reverse hits 1
- composer 1
- conductor 1
- dance groove 1
- dancing rhythm 1
- emotional 1
- energetic 1
- enjoy life 1
- fanfare and pomp 1
- female singer 1
- groovy 1
- groovy bass line 1
- guitar accompaniment 1
- inspiring 1
- latin brass band 1
- latin dance band 1
- latin percussions 1
- life is a dance 1
- life is good 1
- live audience 1
- live concert 1
- lively 1
- loud drumming 1
- majestic 1
- male bravado 1
- male opera singer 1
- marching rhythm 1
- movie soundtrack 1
- people dancing 1
- reggae groove 1
- reggae hits 1
- respect the dead 1
- song ending 1
- song fade 1
- spirited 1
- spirited singing 1
- steady marching rhythm 1
- string orchestra 1
- timpani playing 1
- trombones 1
- tropical dance hit 1
- trumpets 1
- trumpets playing 1
- tuba 1
- tubas playing lower harmony 1
- victory march 1
- vintage marching bands 1
musiccaps_names (array) 9 ✖
- Music 3
- /t/dd00003 1
- Bass drum 1
- Brass instrument 1
- French horn 1
- Maraca 1
- Soundtrack 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
singing sandra crying | A female singer sings this passionate melody. The song is medium tempo with steady drumming rhythm, groovy bass line, Caribbean percussion, guitar accompaniment and a brass band playing percussively. The song is emotional and spirited. The song is a classic renege hit. | 2008-09-26T00:01:17Z | ANDY WONG KEE | music | ["Music", "/t/dd00003"] | ["female singer", "spirited singing", "reggae hits", "tropical dance hit", "caribbean music style", "trumpets blaring", "caribbean percussions rhythm", "medium tempo", "guitar accompaniment", "groovy bass line", "steady drumming rhythm", "brass band harmony", "emotional", "passionate", "reggae groove", "classic reverse hits", "spirited", "dance groove", "beachside party", "people dancing", "inspiring", "life is good", "enjoy life", "life is a dance"] | 1 | XXBVsNt2Qr8 | 3192 | |
Chicago Brass Festival 2009 | The song is an instrumental. The tempo is medium with a brass section including trumpets, trombones and tubas playing in an instrumental harmony. The song is emotional and spirited. The song is western classical music piece. | 2009-08-21T18:56:24Z | Chicagobrassfestival | The next Chicago Brass Festival will be held March 19 - 21, 2010. www.chicagobrassfestival.com for more information | ["Brass instrument", "French horn", "Trumpet"] | ["brass band", "trumpets", "tuba", "trombones", "western classical music", "philharmonic orchestra", "song fade", "song ending", "triumphant", "trumpets blaring", "instrumental music", "groovy", "movie soundtrack", "live concert", "live audience", "conductor", "composer", "medium tempo"] | 1 | _MjbdUaJcik | 3466 | |
Bombo Y Maracas (Gaita) | The song is an instrumental. The tempo is medium with a brass band playing, trumpets blaring, tubas and trombones playing percussively, Latin percussions playing along with drum hits. The song is lively and exciting. The song is a brass band marching with a poor audio quality. | 2008-12-13T17:22:41Z | lealm79 | Saludos para todos mis cuates y les dedico este tema con sabor a colombia!!! | ["Music", "Bass drum", "Maraca"] | ["trumpets playing", "brass band", "cinco de mayo", "respect the dead", "medium tempo", "lively", "instrumental music", "vintage marching bands", "dancing rhythm", "latin dance band", "fanfare and pomp", "trumpets blaring", "latin percussions", "poor audio quality", "steady drumming rhythm", "tubas playing lower harmony", "triumphant", "marching rhythm", "latin brass band"] | 1 | tGUWSgewh0A | 5021 |
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;