musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate" and musiccaps_aspects contains "song fade"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- passionate · 3 ✖
- song fade · 3 ✖
- keyboard accompaniment 2
- adrenaline rush 1
- bad audio quality 1
- calm 1
- contrast song fade 1
- cymbals crashing 1
- distorted guitar rhythm 1
- electric rhythm guitar plays 1
- emotional 1
- energetic 1
- enthusiastic 1
- fast metal drumming 1
- fast tempo 1
- groovy music 1
- groovy rhythm 1
- guitar lead 1
- heavy metal music 1
- hip hop music 1
- instrumental music 1
- k-pop 1
- k-pop hits 1
- keyboard beep tones 1
- korean pop 1
- love song 1
- male singer 1
- male vocalist 1
- medium tempo 1
- mellow 1
- mellow guitar 1
- percussive bass line 1
- poor audio quality 1
- rapping vocals 1
- rebellious 1
- romantic 1
- rough male vocals 1
- slick drumming rhythm 1
- slow tempo 1
- soft 1
- soft acoustic guitar accompaniment 1
- song ending 1
- song stops playing 1
- spirited 1
- story telling 1
- synthesiser arrangements 1
- telephone ringing 1
- vigorous introduction 1
- youthful 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 | |
W.A.S.P. - My Tortured Eyes LYRICS | The song is an instrumental. The tempo is fast with a fast metal drumming rhythm, complete with cymbal crashes, distorted guitar lead, guitar playing rhythm, and percussive bass line. The song is a death metal song ending with a bad audio quality. | 2011-08-19T16:13:10Z | nagito11 | ["Heavy metal", "Music", "Rock music", "Angry music"] | ["heavy metal music", "instrumental music", "fast metal drumming", "distorted guitar rhythm", "keyboard accompaniment", "instrumental music", "fast tempo", "groovy rhythm", "cymbals crashing", "song fade", "song ending", "passionate", "adrenaline rush", "spirited", "youthful", "rebellious", "bad audio quality", "guitar lead", "percussive bass line"] | 1 | nbb8vmfjHJs | 4563 | ||
'For Little Jimmy' (Official Music Video) - Ron Killings aka WWE Superstar "R-Truth" | A male singer with a rough voice sings this hip hop dance song. The song is medium tempo with a distorted electric guitar playing rhythm, keyboard accompaniment, slick drumming rhythm, telephone ring tones and various percussion hits. The song ends with a fade . The song has poor audio quality. | 2013-02-10T14:09:09Z | RonKillingsTV | 'For Little Jimmy' official music video from Ron Killings aka WWE Superstar "R-Truth" #RTruth #WWE #ForLittleJimmy #RonKillings #LittleJimmy Subscribe to RonKillingsTV: https://www.youtube.com/channel/UCkK8dn3G5IxAigWgRbdJmyw Website: https://www.theofficialronkillings.com Merchandise: https://www.ronkillings.com Facebook: https://www.facebook.com/ronkillings Twitter: https://www.twitter.com/ronkillings Tik Tok: https://www.tiktok.com/ronkillings1 Youtube: https://www.youtube.com/ronkillingstv IG: https://www.instagram.com/ronkillings1 Booking info: ronkillingsbooking1@gmail.com https://www.textrke.com (fan text line) (310) 406-7100 Director IG handle(s): @shotbyreginald | ["Music", "Telephone bell ringing", "Inside, small room", "Inside, large room or hall"] | ["male singer", "rapping vocals", "hip hop music", "telephone ringing", "slick drumming rhythm", "song stops playing", "keyboard beep tones", "keyboard accompaniment", "story telling", "enthusiastic", "medium tempo", "rough male vocals", "energetic", "passionate", "poor audio quality", "groovy music", "electric rhythm guitar plays", "song fade"] | 1 | sgJT5lIFttM | 4970 |
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;