musiccaps_details (view)

1 row where musiccaps_aspects contains "spirited", musiccaps_author = 8 and musiccaps_names contains "Dance 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
JINGLE BELL ROCK Christmas Song with LYRICS merry XMAS! Chipettes Chipmunks HD Spirited Christmas music with a fast four on the floor dance beat. There is a high pitched 'chipmunk' style vocal singing a well-known tune accompanied by syncopated synth chord stabs, a drum machine and a drum fill. 2010-11-24T14:31:11Z EuroStarsMusic "Jingle Bell Rock" with Lyrics on screen LYRICS: Jingle bell, jingle bell, jingle bell rock Jingle bells swing and jingle bells ring Snowing and blowing up bushels of fun Now the jingle hop has begun Jingle bell, jingle bell, jingle bell rock Jingle bells chime in jingle bell time Dancing and prancing in Jingle Bell Square In the frosty air What a bright time, it's the right time To rock the night away Jingle bell time is a swell time To go gliding in a one-horse sleigh Giddy-up jingle horse, pick up your feet Jingle around the clock Mix and a-mingle in the jingling beat That's the jingle bell, That's the jingle bell, That's the jingle bell rock. The Chipmunks sing that Christmas classic...Jingle Bell Rock! Alvin and the Chipmunks Chipettes Christmas classic Xmas new X-mas Song with Lyrics on screen jinglebellrock modern POP version Jingle Bell Rock - Chipmunks Chipettes Christmas JINGLE BELL ROCK Alvin and the Chipmunks the best: Mean Girls - Jingle Bell Rock - Unedited VIDEO here: http://www.youtube.com/watch?v=7Dw7GE_BYjI ["Jingle (music)", "Music", "Dance music"] ["fast dance beat", "christmas music", "four on the floor kick pattern", "chipmunk vocal", "drum machine", "pitched up vocal", "drum fill", "syncopated synth chord stabs", "spirited"] 8 44sbWBFswUY 537

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;