musiccaps_details (view)
2 rows where musiccaps_aspects contains "pop song" and musiccaps_aspects contains "tuba"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- pop song · 2 ✖
- tuba · 2 ✖
- bells 1
- children's voices 1
- church bells 1
- holiday feel 1
- male voice 1
- moderate tempo 1
- romantic mood 1
- scheming music 1
- simple percussion 1
- slow song 1
- slow tempo 1
- string section 1
- trumpet 1
- trumpets 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 | |
Musica Romantica | This pop song features a male voice singing the main melody. This is accompanied by percussion playing a simple beat. The hi-hat is played in eighth notes. The bass is played on a tuba. The root notes of the chords are played. Trumpets play a staccato note at every alternate beat. A brass instrument plays a fill after the first two bars. The mood of this song is romantic. This song can be played in a romantic movie. | 2012-10-15T23:45:23Z | El Guapo | Musica Romantica | ["Swing music", "Music", "Music of Latin America"] | ["slow song", "pop song", "romantic mood", "male voice", "slow tempo", "tuba", "trumpets", "simple percussion"] | 0 | MeA8CSKAuvw | 2285 |
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;