musiccaps_details (view)
2 rows where musiccaps_aspects contains "trumpet", musiccaps_author = 0 and musiccaps_names contains "Christian music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- trumpet · 2 ✖
- bells 1
- children's voices 1
- church bells 1
- funk song 1
- funky bass 1
- holiday feel 1
- male voice 1
- moderate tempo 1
- percussion 1
- pop song 1
- repetitive trumpet melody 1
- repetitive vocal melody 1
- scheming music 1
- string section 1
- tuba 1
musiccaps_names (array) 5 ✖
- Christian music · 2 ✖
- Music 2
- Christmas music 1
- Funk 1
- Gospel music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
FUNK GOSPEL 123 | This funk song features a male voice singing the main melody. The melody is repetitive. This is accompanied by percussion that does not play any cymbals. A trumpet plays a repetitive melody of staccato notes. There are other quirky instruments playing in the background adding to the percussion. The mood of this song is upbeat. This song can be played in a bank robbery movie. | 2009-02-16T12:04:24Z | andersoncoutinho123 | ["Gospel music", "Christian music", "Funk", "Music"] | ["funk song", "male voice", "percussion", "funky bass", "trumpet", "repetitive vocal melody", "repetitive trumpet melody"] | 0 | 3FJFcgaa0oE | 451 | ||
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;