musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "keyboard harmony", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "mellow"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional 3
- keyboard harmony · 3 ✖
- male singer · 3 ✖
- mellow · 3 ✖
- steady drumming 3
- acoustic guitar 2
- medium tempo 2
- sentimental 2
- soft 2
- alternative rap 1
- amateur recording 1
- amateur singer 1
- auto harp 1
- backup harmony 1
- boomy bass lines 1
- dulcet 1
- engaging 1
- foreign language 1
- groovy bass line 1
- hip-hop 1
- karaoke 1
- melodic 1
- nostalgia 1
- poignant 1
- pop 1
- r&b 1
- resonator 1
- reverb 1
- rhythmic electric guitar 1
- shakers 1
- …
youtube_published (date) 3 ✖
- 2007-11-02 1
- 2008-06-12 1
- 2009-11-23 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Thien kong nyit cie jiu ko ho ( Hakka song ) | A male vocalist sings this soft melody. The song is medium tempo, with violin harmony, steady drumming, straight bass lines, acoustic guitar and keyboard accompaniment with vocal backup. The song is in a foreign language. It is slow, and has a mellow, soft, emotional , sentimental and romantic vibe. This is a regional Pop song. | 2007-11-02T14:18:16Z | HakkaNyinXmantan | hakka love song | ["Christmas music", "Music", "Song"] | ["male singer", "medium tempo", "foreign language", "steady drumming", "keyboard harmony", "straight bass lines", "acoustic guitar", "vocal backup", "violin harmony", "violin symphony", "emotional", "sentimental", "mellow", "soft", "reverb", "backup harmony", "karaoke", "amateur recording", "amateur singer", "soft", "mellow", "emotional", "sentimental", "pop"] | 7 | MZhaDGgULtc | 2281 | |
South Central Cartel - It's A S.C.C. Thang ft. The Chi-Lites | A male vocalist sings this groovy R&B. The tempo is medium with a funky bass guitar, steady guitar, bright electric guitar and keyboard harmony. The song is mellow, emotional, soft, smooth and engaging. This song is an R&B. | 2009-11-23T18:52:26Z | SthCentralCartelVEVO | Music video by South Central Cartel performing It's A S.C.C. Thang. (C) 1994 RAL/Def Jam | ["Music", "Rapping", "Reggae"] | ["male singer", "medium tempo", "groovy bass line", "mellow", "smooth", "emotional", "engaging", "steady drumming", "keyboard harmony", "hip-hop", "r&b", "soul", "alternative rap", "rhythmic electric guitar"] | 7 | S7R3NMq3MKk | 2739 | |
Bob Seger - Like a Rock ( Music Video ) | A male vocalist sings this soft country song. The tempo is slow with a gentle acoustic guitar and resonator rhythm, subtle keyboard, soft drumming, tambourine beats and soft auto harp strains. The vocals are mellow, gentle, sentimental, emotional, poignant, melancholic and nostalgic. This song is a Classic Country song. | 2008-06-12T21:36:18Z | jonny1214 | from Like a Rock 1986 & Greatest Hits 1994 ( Words and music by bob seger ) Stood there boldly Sweating in the sun Felt like a million Felt like number one The height of summer I'd never felt that strong Like a rock I was eighteen Did'nt have a care Working for peanuts Not a dime to spare But I was lean and Solid everywhere Like a rock My hands were steady My eyes were clear and bright My walk had purpose My steps were quick and light And I held firmly To what I felt was right Like a rock Like a rock, I was strong as I could be Like a rock, nothin ever got to me Like a rock, I was something to see Like a rock And I stood arrow straight Unencumbered by the weight Of all these hustlers and their schemes I stood proud, I stood tall High above it all I still believed in my dreams Twenty years now Whered they go? Twenty years I dont know Sit and I wonder sometimes Where theyve gone And sometimes late at night When Im bathed in the firelight The moon comes callin a ghostly white And I recall Recall Like a rock. standin arrow straight Like a rock, chargin from the gate Like a rock, carryin the weight Like a rock Lihe a rock, the sun upon my skin Like a rock, hard against the wind Like a rock, I see myself again Like a rock | ["Blues", "Music"] | ["male singer", "slow tempo", "mellow", "soft", "dulcet", "melodic", "acoustic guitar", "auto harp", "resonator", "tambourine", "shakers", "keyboard harmony", "sentimental", "emotional", "nostalgia", "poignant", "boomy bass lines", "steady drumming", "sentimental"] | 7 | keIvA2wSPZc | 4339 |
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;