musiccaps_details (view)
3 rows where musiccaps_aspects contains "engaging", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "synthesiser arrangements"
This data as json, CSV (advanced)
musiccaps_aspects (array) 58 ✖
- engaging · 3 ✖
- passionate · 3 ✖
- synthesiser arrangements · 3 ✖
- youthful 3
- compelling 2
- disco rap 2
- hip-hop 2
- hip-hop hits 2
- male vocalist 2
- persuasive 2
- rap 2
- vocal backup 2
- amplified guitar 1
- animated 1
- brass band 1
- brass instruments 1
- bright 1
- buoyant 1
- catchy 1
- chanting 1
- club music 1
- dance floor 1
- dance music 1
- dance pop 1
- digital drum 1
- digital drums 1
- dj 1
- drum machine 1
- electrifying music 1
- electronic music 1
- emotional 1
- enthusiastic 1
- fast tempo 1
- funk pop 1
- funky bass lines 1
- groovy saxophone 1
- intense drumming 1
- keyboard harmony 1
- lively trumpet 1
- male singer 1
- medium tempo 1
- pop rap 1
- rap hits 1
- recurring beat 1
- rhythmic 1
- rhythmic patter 1
- rhythmic speech 1
- slangy lyrics 1
- slick drumming 1
- slow tempo 1
- story telling 1
- street rapper 1
- street vernacular 1
- synth pop 1
- vital 1
- vivacious 1
- wind instrument 1
- woodwind 1
musiccaps_names (array) 4 ✖
- Music 3
- Burst, pop 1
- Rhythm and blues 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lately (Official Music Video) | A male vocalist sings this mellow rap. The tempo is medium with a groovy bass line, keyboard harmony , slick drumming and vocal backup. The song is youthful, story telling, passionate, impactful, compelling and engaging. This song is contemporary Hip-Hop/Rap. | 2016-04-16T18:42:59Z | Official Lobo | Song: Lately Artist: Lobo Directed/Produced/Edited by: Lobo Shot by: CHRIS Kai Bordenave Lobo | ["Music", "Tender music"] | ["male singer", "slow tempo", "funky bass lines", "intense drumming", "synthesiser arrangements", "vocal backup", "hip-hop", "rap", "pop rap", "hip-hop hits", "disco rap", "rhythmic speech", "story telling", "passionate", "emotional", "persuasive", "compelling", "engaging", "persuasive", "youthful"] | 7 | 0Ubu4BqSWmU | 174 | |
Novo Smartphone Alcatel POP 4 | A male vocalist sings this lively pop. The tempo is fast and peppy with animated trumpets, groovy saxophone, slick drumming, funky bass line, keyboard harmony, synthesiser arrangements and electronic sounds. The song is upbeat, energetic, enthusiastic, youthful, vibrant, effervescent; passionate and electrifying. This song is Synth Pop. | 2016-08-16T22:34:36Z | Alcatel Brasil | Conheça o novo Smartphone Alcatel POP 4. Com tela de de 5", Memória de 40GB, câmera de 13MP e Selfie de 8MP, 4G e ainda vem com 3 Capinhas diferentes. Para mais informações, acesse nosso site oficial: https://www.alcatelshop.com.br/detalhe-produto/smartphone-alcatel-pop4-5-premium-memoria-40gb8mais32-sd-3-capas-camera-13mp-selfie-8mp-flash4g/493310 | ["Music", "Burst, pop"] | ["male vocalist", "fast tempo", "lively trumpet", "synth pop", "funk pop", "electrifying music", "passionate", "vital", "catchy", "engaging", "buoyant", "groovy saxophone", "keyboard harmony", "slick drumming", "synthesiser arrangements", "digital drums", "brass instruments", "wind instrument", "woodwind", "brass band", "rhythmic", "animated", "youthful", "dance music", "club music", "dj", "dance floor", "dance pop", "enthusiastic", "vivacious", "bright"] | 7 | 1pR0SgbqP3M | 313 | |
Pete Kolo Feat Chop Chop - "Help Wanted" | A male vocalist sings this spirited rap. The tempo is medium with keyboard accompaniment, digital drums,electric guitar riff and synthesiser arrangements with vocal backup. The song is passionate, compelling, strong telling, chanting, persuasive and youthful. This song is Contemporary Rap-Hip-Hop. | 2012-09-11T19:47:40Z | 2beyond1 | #Theanbm Pete Kolo releases single "Help wanted" ft. Chop Chop #SOB Anbm.inc@gmail.com @Theanbm @PeteGotBeats @ChopChop_SOB Director: @Stedy4dog , 2DCProductions | ["Music", "Rhythm and blues"] | ["male vocalist", "medium tempo", "rap", "rap hits", "digital drum", "youthful", "street rapper", "disco rap", "hip-hop", "hip-hop hits", "rhythmic patter", "electronic music", "drum machine", "synthesiser arrangements", "vocal backup", "passionate", "engaging", "compelling", "persuasive", "street vernacular", "slangy lyrics", "chanting", "recurring beat", "amplified guitar"] | 7 | SxYnb9_qDtk | 2800 |
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;