musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate" and musiccaps_aspects contains "wind instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- passionate · 2 ✖
- wind instrument · 2 ✖
- animated 1
- arabic dance hits 1
- arabic dance music 1
- arabic folk song 1
- arabic music 1
- arabic percussion instruments 1
- bad audio quality 1
- brass band 1
- brass instruments 1
- bright 1
- buoyant 1
- catchy 1
- club music 1
- dance floor 1
- dance music 1
- dance pop 1
- desert sands 1
- digital drums 1
- dj 1
- electrifying music 1
- engaging 1
- enthusiastic 1
- fast tempo 1
- folk music influences 1
- funk pop 1
- groovy music 1
- groovy saxophone 1
- hissing tones 1
- instrumental music 1
- keyboard harmony 1
- lively trumpet 1
- male vocalist 1
- people dancing 1
- percussive bass line 1
- rhythmic 1
- singing 1
- slick drumming 1
- synth pop 1
- synthesiser arrangements 1
- tambourine percussions 1
- traditional dance music 1
- vital 1
- vivacious 1
- woodwind 1
- youthful 1
musiccaps_names (array) 3 ✖
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 | |
Wahraïniate Cheikha Zalamite | The song is an instrumental. The tempo is medium with a percussive Arabic percussion groove, tambourine percussions, percussive bass line and a ethnic wind instrument playing an enthusiastic solo. The song has folk music influences and reminds us of a desert journey. The song audio quality is very poor. | 2013-03-02T12:47:47Z | WahranRai | Cheikha Zalamite, une belle voix Blues Raï de Saïda (Ouest algérien). Cheikha Zalamite me fait penser à cette grande dame du bédoui algérien Cheikha Djénia (Paix à son âme). Elle nous interprète ... Hanini ou n'hanik / Laisse moi tranquille et je te laisserai tranquille... La région de Saïda (Algérie) est connue par ses grands chanteurs, Chioukhs et cheikhates (Mami, Cheikha Djénia, Cheb Aïssa...). Zalamite est l'arabisation du mot Les allumettes. Hommage à Cheikha Zalamite et aux Chioukhs et Cheikhates de l' Ouest algérien. Wahran Raï / Oran Rai. | ["Music", "Rattle (instrument)"] | ["arabic music", "instrumental music", "people dancing", "folk music influences", "passionate", "traditional dance music", "arabic percussion instruments", "tambourine percussions", "groovy music", "percussive bass line", "hissing tones", "arabic folk song", "arabic dance music", "desert sands", "singing", "people dancing", "arabic dance hits", "wind instrument", "bad audio quality"] | 1 | eXrJL1VUQNE | 3876 |
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;