musiccaps_details (view)
1 row where musiccaps_aspects contains "children's voices", musiccaps_aspects contains "tuba" and musiccaps_author = 0
This data as json, CSV (advanced)
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 |
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;