musiccaps_details (view)
2 rows where musiccaps_aspects contains "pop song" and musiccaps_aspects contains "trumpet"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- moderate tempo 2
- pop song · 2 ✖
- trumpet · 2 ✖
- bass 1
- bells 1
- children's voices 1
- church bells 1
- dance song 1
- female backing voice 1
- female voice 1
- happy mood 1
- holiday feel 1
- male backing voice 1
- percussion 1
- repetitive melody 1
- scheming music 1
- string section 1
- tuba 1
musiccaps_names (array) 4 ✖
- Music 2
- Christian music 1
- Christmas music 1
- Funk 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Vidéo du Père Noël pour Alexandre - La danse des Elfes | This pop song starts with children's voices singing a melody. This is accompanied by a tuba playing the low registers. A string section plays a repetitive staccato phrase. This is followed by a phrase played on a trumpet and a descend run played on bells. The children's voice repeats the first melody once again. In between the sound of church bells is played. This song has a holiday feel. This song can be played in the intro credits of a holiday movie. | 2015-10-06T13:03:41Z | Elfi Santa | 👉 PERSONNALISEZ VOTRE VIDÉO ICI → https://www.elfisanta.fr -------------------------------------------------- RÉSEAUX SOCIAUX ELFI -------------------------------------------------- FACEBOOK: https://www.facebook.com/elfi.france INSTAGRAM: https://www.instagram.com/elfisanta PINTEREST: https://pl.pinterest.com/elfisantamagic 👉 ABONNEZ-VOUS et cliquez sur la cloche de NOTIFICATIONS: https://bit.ly/30feDnb 👉 Mettez un sourire sur le visage de vos proches grâce à l'un des messages vidéo personnalisés du Père Noël. 👉 Surprenez vos proches aves une vidéo personnalisée avec leurs prénoms et leurs photos. Le Père Noël s'adressera à eux par leurs prénoms dans la vidéo, il montrera les hotos envoyées par vos soins et invitera le(s) destinataire(s) de la vidéo dans sa maison magique. ✅ NOUVELLE vidéo 2015 ✅ Prête en seulement 2 heures ✅ Disponible en qualité 4K ✅ Jusqu'à 180 jours pour effectuer un retour https://www.elfisanta.fr | ["Christmas music", "Christian music", "Music"] | ["pop song", "trumpet", "tuba", "bells", "string section", "church bells", "holiday feel", "children's voices", "moderate tempo", "scheming music"] | 0 | 6zgvEiJJrM8 | 800 | |
SUPERSCI - Get! (Feat. Remedeeh) (Official Video) | This pop song features a female voice singing the main melody. This is accompanied by male and female backing voices. The voices sing a repetitive melody. This is accompanied by percussion playing a simple beat. Trumpets play a backing melody. The bass plays a groovy descending bassline. The mood of this song is happy. This song can be played at a club. | 2006-06-07T17:33:35Z | Supersci Flyphonic | Swedish hip hop at its finest with a sweet summer vibe. Supersci's first video from the 2006 album "Pinetrees on the Pavement". Shot around the Sundsvall area using super-8 film. Video directed by Måns Berthas. Music produced by Flyphonic Beats. Lyrics by Mr Noun, Arka and Remedeeh. www.flyphonic.com/supersci | ["Funk", "Music"] | ["pop song", "female voice", "male backing voice", "female backing voice", "percussion", "trumpet", "bass", "moderate tempo", "dance song", "repetitive melody", "happy mood"] | 0 | EtmKuWPpjG0 | 1598 |
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;