musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance floor", musiccaps_aspects contains "keyboard harmony" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- dance floor · 2 ✖
- dj 2
- keyboard harmony · 2 ✖
- youthful · 2 ✖
- animated 1
- brass band 1
- brass instruments 1
- bright 1
- buoyant 1
- catchy 1
- club music 1
- cymbals crashing loud 1
- dance club 1
- dance hits 1
- dance music 1
- dance party 1
- dance pop 1
- digital drums 1
- electrifying music 1
- electronic dance music 1
- energetic 1
- engaging 1
- enthusiastic 1
- fast tempo 1
- funk pop 1
- groovy bass line 1
- groovy saxophone 1
- keybiard harmony 1
- lively trumpet 1
- male vocalist 1
- medium tempo 1
- night party 1
- passionate 1
- people dancing 1
- percussion hits 1
- rhythmic 1
- slick drumming 1
- steady rhythm 1
- synth pop 1
- synthesiser arrangements 1
- techno dance music 1
- teenage romance 1
- vital 1
- vivacious 1
- wind instrument 1
- woodwind 1
musiccaps_names (array) 7 ✖
- Music 2
- Burst, pop 1
- Dance music 1
- Disco 1
- Dubstep 1
- Electronic dance music 1
- Techno 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 | |
Invisible Sounds vs Daniel Licht - Dexter | The song is instrumental. The song is medium tempo with a groovy bass line, keyboard harmony, various percussion hits and a steady drumming rhythm. The song has a dance rhythm and is exciting. | 2009-01-05T17:53:42Z | Perry12344 | Bootleg remix on one of track from OST "Dexter" from Showtime... original track produced by Daniel Licht | ["Disco", "Music", "Techno", "Dubstep", "Electronic dance music", "Dance music"] | ["techno dance music", "electronic dance music", "cymbals crashing loud", "percussion hits", "keyboard harmony", "dance party", "dance club", "dance floor", "electronic dance music", "youthful", "energetic", "teenage romance", "dance hits", "steady rhythm", "medium tempo", "keybiard harmony", "groovy bass line", "people dancing", "dj", "night party"] | 1 | ClK_qf_Twm8 | 1399 |
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;