musiccaps_details (view)
3 rows where musiccaps_aspects contains "club music", musiccaps_aspects contains "synthesiser arrangements" and musiccaps_aspects contains "vivacious"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- club music · 3 ✖
- dance music 3
- fast tempo 3
- keyboard harmony 3
- synthesiser arrangements · 3 ✖
- vivacious · 3 ✖
- youthful 3
- animated 2
- buoyant 2
- dance pop 2
- dj 2
- enthusiastic 2
- male vocalist 2
- synth pop 2
- brass band 1
- brass instruments 1
- bright 1
- busy music 1
- catchy 1
- dance floor 1
- dance hits 1
- digital drum 1
- digital drums 1
- dj mixer 1
- electrifying music 1
- electro pop 1
- electronic instrumentation 1
- emphatic vocals 1
- energetic drums 1
- energetic vocal backup 1
- engaging 1
- female singer 1
- foreign language 1
- funk pop 1
- groovy bass line 1
- groovy saxophone 1
- lively trumpet 1
- passionate 1
- rhythmic 1
- slick drumming 1
- spirited 1
- spirited drumming 1
- tambourine beats 1
- upbeat electronic riff 1
- vibrant 1
- vital 1
- wind instrument 1
- woodwind 1
musiccaps_names (array) 6 ✖
- Music 3
- Burst, pop 1
- Dance music 1
- Maraca 1
- Song 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
I Say Yes (Zero no Tsukaima - Futatsuki no Kishi) | A female vocalist sings this energetic song. The tempo is fast with enthusiastic drumming, funky bass line, keyboard harmony and synthesiser arrangements. The song is youthful, vibrant, vivacious, hyper, spirited, passionate, bright and has a dance groove. This song is an Electro Pop song. | 2008-07-11T15:03:54Z | Aiath86 | Album: Exit Trance Presents Speed Anime Trance Best 4 | ["Music", "Trance music"] | ["female singer", "fast tempo", "foreign language", "dance music", "dance hits", "club music", "dance music", "electronic instrumentation", "synthesiser arrangements", "spirited drumming", "keyboard harmony", "groovy bass line", "busy music", "electro pop", "animated", "spirited", "emphatic vocals", "youthful", "upbeat electronic riff", "vibrant", "vivacious"] | 7 | BkoCi-IZccI | 1287 | |
DJ HumNoy Maraca YouTube | A male vocalist sings this energetic song. The tempo is fast with synthesiser arrangements, punchy digital drumming, tambourine beats and keyboard harmony. The music is upbeat, punchy, groovy, youthful, buoyant and exciting. This song is Synth Pop. | 2013-12-03T12:25:16Z | ณ๊องจุ้น คนเดิม | ["Music", "Song", "Dance music", "Maraca"] | ["male vocalist", "fast tempo", "energetic drums", "synth pop", "buoyant", "tambourine beats", "digital drum", "synthesiser arrangements", "keyboard harmony", "energetic vocal backup", "dj", "dj mixer", "dance pop", "dance music", "club music", "youthful", "enthusiastic", "vivacious"] | 7 | S7rP6coeLTY | 2742 |
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;