musiccaps_details (view)
5 rows where musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "trumpets blaring" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 77 ✖
- poor audio quality · 5 ✖
- trumpets blaring · 5 ✖
- brass band 4
- energetic 3
- instrumental music 3
- latin percussions 3
- passionate 3
- backup singers 2
- medium tempo 2
- piano accompaniment 2
- adrenaline rush 1
- barking tones 1
- bhangra music 1
- brass instruments playing percussively 1
- brass section 1
- building anticipation 1
- cheerful 1
- cheering sounds 1
- cinco de mayo 1
- dancing rhythm 1
- dhol playing percussively 1
- exciting 1
- fanfare and pomp 1
- fast drumming rhythm 1
- fast tempo 1
- fun 1
- groovy 1
- groovy rhythm 1
- guitar rhythm 1
- indian dance music 1
- indian folk music 1
- indian music 1
- indian percussions 1
- indian wedding band 1
- latin brass band 1
- latin dance 1
- latin dance band 1
- latin dance music 1
- latin dance rhythm 1
- latin dancers 1
- live band performance 1
- live concert 1
- live performance 1
- lively 1
- loud drumming 1
- love performance 1
- majestic 1
- male bravado 1
- male latin singer 1
- male opera singer 1
- male singer 1
- marching rhythm 1
- medium fast tempo 1
- people cheering 1
- percussive bass line 1
- philharmonic orchestra 1
- rapping vocals 1
- respect the dead 1
- romantic 1
- salsa 1
- screaming vocals 1
- steady drumming rhythm 1
- steady marching rhythm 1
- street music 1
- string orchestra 1
- timpani playing 1
- trimmings playing 1
- triumphant 1
- trumpets playing 1
- ttrumelts blaring 1
- tubas playing lower harmony 1
- victory march 1
- vintage marching bands 1
- vocal harmony 1
- wedding band 1
- western classical music 1
- youthful 1
musiccaps_names (array) 8 ✖
- Music 5
- Maraca 2
- Salsa music 2
- Bass drum 1
- Song 1
- Soundtrack music 1
- Timpani 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Red Baraat: NPR Music Tiny Desk Concert | The song is an instrumental with male vocalists cheering enthusiastically . The tempo is medium fast with a trombone and trumpet playing percussively and an Indian dhol playing percussively. The song is cheerful and energetic. The song is a traditional Indian folk style called Punjabi Bhangra music. The song has poor audio quality. | 2012-02-14T16:24:13Z | NPR Music | One of the best party bands around, Red Baarat plays rollicking funk music steeped in Northern India's wedding celebrations, with a dash of D.C. go-go beats and hip-hop. The dance-friendly group performs a loud, high-energy set at the NPR Music offices. Set List: "Chaal Baby" "Shruggy Ji" "Dhol 'n' Brass" For more videos and to subscribe to the Tiny Desk Concerts podcast, visit npr.org/tinydeskconcerts. | ["Music", "Wedding music"] | ["brass band", "instrumental music", "bhangra music", "dhol playing percussively", "indian percussions", "indian wedding band", "brass instruments playing percussively", "cheering sounds", "fun", "cheerful", "medium fast tempo", "indian dance music", "indian folk music", "wedding band", "live concert", "poor audio quality", "trumpets blaring", "people cheering", "trimmings playing", "bhangra music", "indian music"] | 1 | 0kQD1P0_KUs | 203 | |
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 | |
𝐒𝐀𝐋𝐒𝐀 - 𝐛𝐚𝐢𝐥𝐚 𝐂𝐮𝐛𝐚𝐧 𝐬𝐭𝐲𝐥𝐞 - 𝐄𝐱𝐜𝐢𝐭𝐢𝐧𝐠 𝐒𝐚𝐥𝐬𝐚 ! | A male singer sings this Latin melody with backup singers in vocal harmony. The song is medium tempo with a brass band accompaniment, latin percussion and guitar accompaniment. The song is exciting and spirited. The song is perfect for Latin dancing. The song has a poor audio quality. | 2013-02-17T03:55:26Z | MrHaagsesjonny1 | 𝗱𝗮𝗻𝗰𝗲 𝘃𝗶𝗱𝗲𝗼: 𝘀𝗮𝗹𝘀𝗮 𝗱𝗮𝗻𝗰𝗶𝗻𝗴 - 𝘀𝗮𝗹𝘀𝗮 𝗰𝘂𝗯𝗮𝗻𝗮 - 𝗖𝗮𝘀𝗶𝗻𝗼 - 𝗮𝗻𝗱 𝗲𝘅𝗰𝗶𝘁𝗶𝗻𝗴 𝗱𝗮𝗻𝗰𝗲 𝘄𝗶𝘁𝗵 𝗖𝘂𝗯𝗮𝗻 𝗯𝗼𝗿𝗻 𝗠𝗮𝘆𝗸𝗲𝗹 𝗙𝗼𝗻𝘁𝘀 | ["Music", "Salsa music"] | ["latin dance music", "male singer", "live band performance", "trumpets blaring", "vocal harmony", "piano accompaniment", "exciting", "energetic", "passionate", "latin dance", "salsa", "passionate", "adrenaline rush", "groovy rhythm", "backup singers", "vocal harmony", "ttrumelts blaring", "brass band", "barking tones", "latin percussions", "guitar rhythm", "poor audio quality", "live performance"] | 1 | RlrNPBfOowg | 2722 | |
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 | |
La Maraca | A male Latin singer sings this energetic vocal with male backup singers in vocal harmony. The song is fast tempo with quick Latin percussions, groovy bass line, keyboard accompaniment and trumpets blaring. The song is energetic and passionate. The song has poor audio quality. | 2008-04-10T19:01:41Z | adonismasgozadera | AdonisGozadera.com | ["Music", "Song", "Salsa music", "Maraca"] | ["male latin singer", "backup singers", "screaming vocals", "rapping vocals", "street music", "fast tempo", "poor audio quality", "piano accompaniment", "latin percussions", "percussive bass line", "fast drumming rhythm", "energetic", "youthful", "romantic", "love performance", "brass band", "trumpets blaring", "groovy", "passionate", "latin dancers", "latin dance rhythm"] | 1 | zNSV9GkpRfM | 5468 |
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;