musiccaps_details (view)
1 row where musiccaps_aspects contains "male vocalist", musiccaps_aspects contains "male voice superimposed over song" and musiccaps_aspects contains "pop hit"
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
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;