musiccaps_details (view)

1 row where musiccaps_aspects contains "dance rock", musiccaps_aspects contains "digital music", musiccaps_aspects contains "electrifying" and musiccaps_aspects contains "synthesiser articulation"

✎ 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
Michael Jackson - Thriller (Lyrics in Description) A male voice speaks in a menacing voice over a pop song in the background. The song is fast tempo with synthesiser articulation , digital arrangements and electronic sounds with subtle male vocals. The music is upbeat, energetic, enthusiastic, youthful, chilling, vibrating, exciting and pulsating. This song is a hit by Dance Pop. 2009-07-12T15:28:18Z Grace Walton Michael Jackson's Thriller with some pictures R.I.P Michael Lyrics: Its close to midnight and something evils lurking in the dark Under the moonlight you see a sight that almost stops your heart You try to scream but terror takes the sound before you make it You start to freeze as horror looks you right between the eyes, Youre paralyzed Chorus cause this is thriller, thriller night And no ones gonna save you from the beast about strike You know its thriller, thriller night Youre fighting for your life inside a killer, thriller tonight 2nd verse You hear the door slam and realize theres nowhere left to run You feel the cold hand and wonder if youll ever see the sun You close your eyes and hope that this is just imagination But all the while you hear the creature creepin up behind Youre out of time Chorus cause this is thriller, thriller night There aint no second chance against the thing with forty eyes You know its thriller, thriller night Youre fighting for your life inside of killer, thriller tonight Bridge Night creatures call And the dead start to walk in their masquerade Theres no escapin the jaws of the alien this time (theyre open wide) This is the end of your life 3rd verse Theyre out to get you, theres demons closing in on every side They will possess you unless you change the number on your dial Now is the time for you and I to cuddle close together All thru the night Ill save you from the terror on the screen, Ill make you see Chorus That this is thriller, thriller night cause I can thrill you more than any ghost would dare to try Girl, this is thriller, thriller night So let me hold you tight and share a killer, diller, chiller Thriller here tonight (rap performed by vincent price) Darkness falls across the land The midnite hour is close at hand Creatures crawl in search of blood To terrorize yawls neighbourhood And whosoever shall be found Without the soul for getting down Must stand and face the hounds of hell And rot inside a corpse… ["Disco"] ["male vocalist", "fast tempo", "famous song", "thrilling", "vibrating", "pulsating", "electrifying", "youthful", "chilling", "super hit song", "male voice superimposed over song", "rock", "classic rock", "dance pop", "dance rock", "disco pop", "funk", "pop soul", "synth funk", "terror", "horror", "hit", "king of pop", "synthesiser articulation", "digital music", "electronic music", "pulsating", "electrifying", "pop hit"] 7 j8z9a9A8LV4 4238

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;