musiccaps_details (view)

3 rows where musiccaps_aspects contains "festive" and musiccaps_names contains "Christmas music"

✎ View and edit SQL

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
Best Christmas song ever!!! This is an amateur acoustic rock performance of a Christmas song. There are three male voices singing the song. Two acoustic guitars and an electric guitar provide the melodic background. The players are stepping their foot on the ground for an added percussive effect to keep the rhythm. 2014-11-27T01:28:54Z seth keehn Here is me and a couple of my best buds excited for Christmas haha ["Christmas music", "Singing", "Guitar", "Music", "Song"] ["rock", "acoustic", "jingle", "christmas", "male vocals", "acoustic guitar", "electric guitar", "footsteps", "festive"] 9 SLdVSirZMSI 2761
opm christmas song (megamix) ft.dj klu - part 2 This is the remix of an Original Pilipino Music (OPM) Christmas song. The female vocalist is singing melodically and in a festive manner. The melody is being played by a strings section while the rhythm consists of an electronic drum beat with heavy usage of percussive elements. The atmosphere is cheerful. This piece could be played at Christmas events in the Philippines. 2009-09-11T06:15:35Z edwell143 wala lang trip lang to.ramdam ko kasi pasko na..advance merry christmas sa inyong lahat... ["Christmas music", "Music of Asia", "Christian music", "Music"] ["original pilipino music", "christmas", "remix", "female vocals", "melodic singing", "electronic drums", "percussion", "bells", "strings", "festive", "cheerful"] 9 lZavPVn7O4Q 4409
Mag-ambahan This is a Christmas music piece. There is a male voice and a female voice singing melodically in the Cebuano language. The electric piano is playing the main melody while the electric guitar and the bass guitar are playing in the background. The rhythm is provided by a simple and upbeat acoustic drum beat. The atmosphere is festive and cheerful. This piece could be the opening theme of a Christmas movie that takes place in the southern Philippines. 2010-12-10T09:35:04Z ryahnz Mag-ambahan ta ning pasko sa kalipay Ang kagul-anan ta ato nga isalikway Ug duyog ning awit sa malipayong dughan Issignit ta ang kalipay'g hudyaka Kay pasko karon sa pagmaya Wad-on ta ang mga kayugot Isalikway ta ang pagdumot Ang pagpasaylo mao'y angay buhaton ta Ning adlaw sa manunubos (Repeat Mag-ambahan stanza) Issignit ta ang kalipay'g hudyaka Kay pasko karon sa pagmaya ["Christmas music", "Christian music", "Jingle (music)", "Music"] ["christmas music", "male voice", "female voice", "melodic singing", "cebuano language", "electric piano", "electric guitar", "bass guitar", "acoustic drums", "festive", "cheerful"] 9 tDZPGf8WYmI 5016

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;