musiccaps_details (view)
4 rows where musiccaps_aspects contains "love song", musiccaps_aspects contains "male vocalist" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 59 ✖
- emotional 4
- love song · 4 ✖
- male vocalist · 4 ✖
- passionate · 4 ✖
- alternative rock 2
- keyboard accompaniment 2
- romantic 2
- sentimental 2
- acoustic guitar accompaniment 1
- alternative dance 1
- alternative metal 1
- ambient sounds 1
- auditorium acoustics 1
- breakup 1
- bright electric guitar 1
- buoyant 1
- calm 1
- classic rock 1
- contrast song fade 1
- energetic drumming 1
- engaging 1
- enthusiastic 1
- enthusiastic vocals 1
- funk rock 1
- funky bass lines 1
- groovy electric guitar lead 1
- heart break 1
- incessant 1
- infectious drumming 1
- k-pop 1
- k-pop hits 1
- korean pop 1
- live performance 1
- lonely 1
- medium fast tempo 1
- medium tempo 1
- melancholic 1
- mellow 1
- mellow guitar 1
- melodious acoustic guitar rhythm 1
- minimalist 1
- pleasant 1
- pop hit 1
- quirky music 1
- repetitive 1
- rhythmic 1
- rock 1
- sad 1
- slow tempo 1
- soft 1
- soft acoustic guitar accompaniment 1
- soft rock 1
- song fade 1
- synthesiser arrangements 1
- teen pop 1
- vigorous introduction 1
- vocal backup 1
- youthful 1
- youtube video 1
musiccaps_names (array) 7 ✖
- Music 4
- Blues 1
- Funk 1
- Independent music 1
- Punk rock 1
- Song 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kim Jaejoong MUSIC QUIZ | A male vocalist sings this mellow pop. The tempo is slow in contrast to the enthusiastic introductory bit in this section. The song is soft, mellow, emotional, repetitive, melancholic, nostalgic and passionate with a soft acoustic guitar accompaniment. This could be a song fade. This song is a Korean Pop/K-Pop song. | 2016-03-30T01:17:32Z | JaejoongArabFansC3 | Website: http://jaejoongarabfans.com/ Facebook: https://www.facebook.com/JaejoongArabFans Twitter: https://twitter.com/JaejoongArabFan | ["Music", "Tender music"] | ["male vocalist", "slow tempo", "vigorous introduction", "synthesiser arrangements", "contrast song fade", "soft acoustic guitar accompaniment", "korean pop", "k-pop", "k-pop hits", "mellow guitar", "song fade", "love song", "romantic", "emotional", "passionate", "mellow", "soft", "calm"] | 7 | 4i1aizhCnfg | 596 | |
Breaking Benjamin Burnley GIVE ME A SIGN House of Blues Atlantic City, NJ 7/10/10 | A male vocalist sings this passionate song. The tempo is slow with emphatic vocals and an acoustic guitar accompaniment. The song is melodic, emotional,sentimental, passionate,pensive, reflective and deep. This song is Alternative Rock. | 2010-07-11T17:28:56Z | Christopher Kline | Ben Burnley of Breaking Benjamin performed a solo acoustic show at The House of Blues in Atlantic City, NJ on July 10th. Joining him onstage playing guitar and providing backup vocals was Aaron Bruch of Ourafter. | ["Blues", "Music"] | ["male vocalist", "medium tempo", "rock", "alternative rock", "alternative metal", "acoustic guitar accompaniment", "minimalist", "live performance", "ambient sounds", "auditorium acoustics", "romantic", "love song", "passionate", "emotional", "sentimental"] | 7 | 9ogEGxsJcSY | 1043 | |
CAKE - Never There (Official HD Video) | A male vocalist sings this quirky Rock melody. The tempo is medium fast with groovy electric guitar harmony, funky, intense bass lines, infectious drumming, keyboard accompaniment and vocal backup. The song is catchy, rhythmic, emotional, incessant, sentimental, melancholic, lonely, romantic , unconventional, quirky and upbeat. This song is classic rock. | 2011-03-18T00:20:30Z | CakeVEVO | ”Never There” by CAKE in HD Listen to CAKE: https://Cake.lnk.to/listenYD Watch more videos by CAKE: https://Cake.lnk.to/listenYD/youtube Subscribe to the official CAKE YouTube channel: https://Cake.lnk.to/subscribeYD Follow CAKE Facebook: https://Cake.lnk.to/followFI Instagram: https://Cake.lnk.to/followII Twitter: https://Cake.lnk.to/followTI Website: https://Cake.lnk.to/followWI Spotify: https://Cake.lnk.to/followSI YouTube: https://Cake.lnk.to/subscribeYD Ask your voice device to play CAKE! Lyrics: Never there You're never there You're never ever, ever, ever there Hey! #CAKE #NeverThere #OfficialHDVideo #HD #Remastered #ProlongingTheMagic #Rock | ["Funk", "Music"] | ["male vocalist", "medium fast tempo", "vocal backup", "funky bass lines", "groovy electric guitar lead", "keyboard accompaniment", "infectious drumming", "passionate", "emotional", "sentimental", "love song", "alternative rock", "funk rock", "alternative dance", "rhythmic", "melancholic", "sad", "lonely", "repetitive", "incessant", "breakup", "heart break", "classic rock", "quirky music", "engaging", "youthful", "enthusiastic"] | 7 | FRZzUh9hcTo | 1642 | |
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 |
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;