musiccaps_details (view)
5 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "engaging" and musiccaps_aspects contains "enthusiastic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 93 ✖
- energetic · 5 ✖
- engaging · 5 ✖
- enthusiastic · 5 ✖
- cheerful 2
- fast tempo 2
- instrumental 2
- male vocalist 2
- medium tempo 2
- spirited 2
- youthful 2
- animated 1
- anthem 1
- band 1
- booming drums 1
- bouncy 1
- boy band 1
- brass 1
- brass band 1
- bright 1
- bugle like sounding instrument 1
- chanting 1
- clarinet 1
- club music 1
- concert 1
- crowd cheering 1
- crowd screaming 1
- cymbals 1
- cymbals clashing 1
- dance groove 1
- dance music 1
- determination 1
- digital drum arrangement 1
- dj 1
- drum machine 1
- energy 1
- fans 1
- fans going berserk 1
- fans going crazy 1
- fervent 1
- foreign language 1
- fun 1
- funk rap 1
- groovy bass line 1
- hands clapping 1
- happy 1
- high spirited 1
- hip-hop 1
- hip-hop hits 1
- hit song 1
- horn instrument 1
- infectious drumming 1
- italian foot ball team 1
- italian music 1
- italian song 1
- k-pop 1
- keyboard harmony 1
- live audience 1
- live performance 1
- lively 1
- lively keyboard harmony 1
- lively piano 1
- loyalty 1
- male singer 1
- melodic spanish guitar 1
- melodious 1
- passionate 1
- peppy 1
- percussion instruments 1
- perky 1
- popularity 1
- punchy 1
- punk rap 1
- rap 1
- recurring beat 1
- rhythmi chanting 1
- rhythmic chanting 1
- rhythmic patter 1
- rhythmic speech 1
- sportsmanship 1
- steady drumming 1
- synth articulation 1
- synthesiser arrangements 1
- teen pop 1
- trombone 1
- trumpet 1
- tuba 1
- unity 1
- upbeat 1
- vibrant 1
- vibrant vivacious 1
- vigorous 1
- vocal backup 1
- wind instrument 1
musiccaps_names (array) 11 ✖
- Music 4
- Rapping 2
- Brass instrument 1
- Clarinet 1
- Funk 1
- Hip hop music 1
- Independent music 1
- Music of Africa 1
- Music of Asia 1
- Pop music 1
- Rattle (instrument) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Banda musicale dell'arma dei carabinieri.Italia.Москва.brass band | This music is a lively instrumental. The tempo is fast with an enthusiastic Brass and wind instrument harmony. The vigorous trumpets, trombone and tuba accompaniment, along with clanging cymbals and playful clarinet make for an upbeat, cheerful, happy, energetic and Perky Band Music. | 2012-09-04T16:25:29Z | umo61 | Спасская Башня.Кремль.Красная Площадь.Orchestra Carabineros.Militari orchestra Italia.оркестр Италии.духовые инструменты.winds. | ["Brass instrument", "Clarinet"] | ["instrumental", "fast tempo", "enthusiastic", "brass band", "cheerful", "happy", "bright", "fun", "engaging", "perky", "peppy", "bright", "energetic", "lively", "spirited", "cymbals", "clarinet", "trumpet", "tuba", "trombone", "wind instrument", "brass", "band", "engaging"] | 7 | Aak-VLHtFPM | 1142 | |
Hadiya Deville..Make it Ping Pong...mpg | A male vocalist sings this spirited hip-hop. The tempo is fast with synthesiser articulation, digital drum arrangements and vocal backup. The music is a youthful , enthusiastic, bouncy, punchy rhythmic patter with a dance groove. This song is contemporary Hip-Hop/ Rap. | 2011-11-26T16:20:24Z | Loc Deville | This is a Must See Video..2 Year old Hadiya Shaheed..aka Hadiya Deville..Rocks Out, to her Fathers New Single ''Make it Ping Pong''.. ---Talent is in the D.N.A..--SEE FOR YOUR SELF :) | ["Music", "Rapping", "Hip hop music"] | ["male vocalist", "fast tempo", "hip-hop", "rap", "bouncy", "punchy", "funk rap", "punk rap", "rhythmic patter", "rhythmic speech", "engaging", "passionate", "energetic", "enthusiastic", "vocal backup", "recurring beat", "youthful", "keyboard harmony", "digital drum arrangement", "drum machine", "synth articulation", "vocal backup", "dance groove", "dj", "club music", "dance music", "hip-hop hits"] | 7 | QBMM1ocXkhY | 2602 | |
BTOB - Beep Beep (Feb 20, 2014) | A male vocalist sings this melodious pop song. The tempo is medium with piano accompaniment, rhythmic acoustic guitar, groovy bass line ,steady drumming and energetic vocal backup. The song is spirited, youthful, vivacious, popular, bright and engaging. The song is a live performance and there are sounds of people cheering, hooting hysterically and singing along. This song is a hit in K-Pop. | 2014-02-21T07:07:36Z | Minhyuk ครับผม | 140220 BTOB - Beep Beep @ M Countdown Comeback Stage | ["Music of Asia", "Funk", "Music", "Independent music", "Pop music", "Rapping"] | ["male singer", "foreign language", "medium tempo", "youthful", "engaging", "energetic", "enthusiastic", "vibrant vivacious", "concert", "teen pop", "k-pop", "live performance", "concert", "live audience", "enthusiastic", "crowd cheering", "crowd screaming", "fans", "fans going crazy", "fans going berserk", "popularity", "hit song", "boy band", "melodious", "steady drumming", "lively piano", "groovy bass line"] | 7 | cADT8fUucLQ | 3686 | |
Inno Ufficiale Torino Calcio | This song is a Latin Football team anthem. The song is medium tempo with lively keyboard, flute harmony, synthesiser arrangements , shakers and infectious drumming. The song is youthful, energetic,encouraging, celebratory, cheerful and happy. | 2012-11-30T16:01:45Z | alexone97able | Questo è l'inno a parer mio piu bello del torino | ["Music of Africa", "Music"] | ["male vocalist", "medium tempo", "italian song", "cheerful", "upbeat", "engaging", "high spirited", "italian music", "italian foot ball team", "anthem", "energetic", "enthusiastic", "cheerful", "determination", "unity", "sportsmanship", "energy", "loyalty", "fervent", "melodic spanish guitar", "infectious drumming", "lively keyboard harmony", "synthesiser arrangements"] | 7 | p4T1pddBia0 | 4686 | |
Opening Ceremony of the 25th SEA Games (7) | This piece is an instrumental. The tempo is fast with hard hitting percussion, cymbals clanging, clapping, rhythmic chanting, and shakers. It is vigorous, spirited, vibrant, energetic,intense and engaging. | 2009-12-09T15:16:22Z | langvannavong | ["Music", "Rattle (instrument)"] | ["instrumental", "booming drums", "cymbals clashing", "rhythmi chanting", "percussion instruments", "vigorous", "spirited", "vibrant", "enthusiastic", "energetic", "engaging", "rhythmic chanting", "vigorous", "spirited", "animated", "bugle like sounding instrument", "horn instrument", "chanting", "hands clapping"] | 7 | ypg2ItQIc2c | 5442 |
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;