musiccaps_details (view)
3 rows where musiccaps_aspects contains "male vocalist" and musiccaps_aspects contains "pop hit"
This data as json, CSV (advanced)
musiccaps_aspects (array) 58 ✖
- male vocalist · 3 ✖
- pop hit · 3 ✖
- electrifying 2
- pulsating 2
- 90’s hit song 1
- ambient concert sounds 1
- back street boys 1
- boy band 1
- bright electric guitar 1
- buoyant 1
- chilling 1
- classic rock 1
- concert 1
- dance pop 1
- dance rock 1
- digital music 1
- disco pop 1
- electronic music 1
- emotional 1
- energetic 1
- energetic drumming 1
- enthusiastic vocals 1
- famous song 1
- fans screaming 1
- fast tempo 1
- funk 1
- hit 1
- horror 1
- hysteria 1
- inferior audio quality 1
- keyboard accompaniment 1
- king of pop 1
- live audience 1
- live performance 1
- love song 1
- male voice superimposed over song 1
- medium fast tempo 1
- melodious acoustic guitar rhythm 1
- muffled audio 1
- muffled instrumentation 1
- passionate 1
- pleasant 1
- pop 1
- pop soul 1
- rock 1
- soft rock 1
- super hit song 1
- synth funk 1
- synthesiser articulation 1
- teen pop 1
- terror 1
- thrilling 1
- thumping beats 1
- vibrant 1
- vibrating 1
- vivacious 1
- youthful 1
- youtube video 1
musiccaps_names (array) 9 ✖
- Music 2
- Bang 1
- Crowd 1
- Disco 1
- Independent music 1
- Punk rock 1
- Rock music 1
- Shout 1
- Song 1
youtube_published (date) 3 ✖
- 2009-07-12 1
- 2009-12-18 1
- 2010-02-07 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pig Rock - อ่าง (SD Version) | A male singer sings this melodic pop song. The tempo is fast with an acoustic guitar accompaniment, keyboard harmony, enthusiastic electric guitar melody and intense drumming. The vocals are emphatic and the song is pleasant, catchy, melodious, youthful, buoyant and fresh. This song is Soft Rock/ Pop. | 2010-02-07T21:32:43Z | PigRockBand | PIG ROCK - Arng : The first official music video of new Thais rock band named PIG ROCK. Their first album will be launched in March, 2010. For more info please visit www.sabarnrecords.com Music Video Director / Cinematographer : Sornpat Prakaranunt | ["Music", "Punk rock", "Independent music", "Song"] | ["male vocalist", "bright electric guitar", "buoyant", "soft rock", "teen pop", "pop hit", "youtube video", "melodious acoustic guitar rhythm", "keyboard accompaniment", "pleasant", "teen pop", "love song", "passionate", "emotional", "enthusiastic vocals", "energetic drumming"] | 7 | QutCXtWmzIs | 2649 | |
BACKSTREET BOYS - BANG @ DUBAI.MPG | A male vocalist sings this Popular 90’s song. The tempo is medium fast with thumping drum beats, keyboard harmony, boomy bass and vocal backup.The song is a live performance at a concert with ambient sounds of fans screaming, clapping and singing along and responding. The audio is incoherent as it is an amateur recording. This song is a Hit 90’s Pop. | 2009-12-18T20:10:01Z | imthiazdxb | Backstreet Boys- Live @ Dubai ON 17th Dec 2009-The Curtain Raiser | ["Crowd", "Music", "Rock music", "Shout", "Bang"] | ["male vocalist", "medium fast tempo", "boy band", "90’s hit song", "pop", "live performance", "live audience", "concert", "back street boys", "ambient concert sounds", "fans screaming", "hysteria", "thumping beats", "inferior audio quality", "muffled audio", "muffled instrumentation", "energetic", "electrifying", "pulsating", "vibrant", "vivacious", "pop hit"] | 7 | ab8V7MYQVyg | 3556 | |
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;