musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "keyboard harmony" and musiccaps_aspects contains "male singer"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional · 5 ✖
- keyboard harmony · 5 ✖
- male singer · 5 ✖
- acoustic guitar 3
- medium tempo 3
- mellow 3
- steady drumming 3
- groovy bass line 2
- r&b 2
- romantic 2
- sentimental 2
- slow tempo 2
- soft 2
- soul 2
- alternative rap 1
- amateur recording 1
- amateur singer 1
- auto harp 1
- backup harmony 1
- backup singers 1
- boomy bass lines 1
- clapping percussions 1
- cymbals crashing 1
- dulcet 1
- engaging 1
- fingers snapping 1
- fog horn 1
- foreign language 1
- forgive me 1
- guitar lead 1
- …
musiccaps_names (array) 7 ✖
- Music 5
- Reggae 2
- Song 2
- Blues 1
- Christmas music 1
- Happy music 1
- Rapping 1
youtube_published (date) 4 ✖
- 2007-11-02 1
- 2008-06-12 1
- 2009-11-23 1
- 2013-12-06 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
One Republic - Apologize (Lyrics) | A male singer sings this beautiful melody with backup singers in vocal harmony. The song is medium tempo with a percussive string section, strong bass line, guitar lead, steady drumming rhythm , keyboard accompaniment and various percussion clicks. The song is emotional and romantic. The song is of poor audio quality. | 2013-12-06T06:01:44Z | Giz Ruar | "Apologize" belongs to One Republic. From the "Dreaming Out Loud" album, 2006. http://onerepublic.com/ Please, suscribe to my channel. TY! My Facebook Official Page: https://www.facebook.com/GizelleSixxJ If you want a special lyric video, just let me know in a comment below the video and I'll try to make it. Thanks for watching. | ["Music", "Happy music"] | ["male singer", "backup singers", "guitar lead", "medium tempo", "steady drumming rhythm", "string section playing rhythmically", "cymbals crashing", "slick percussion clicks", "strong bass line", "keyboard harmony", "modern pop hits", "emotional", "romantic", "together for ever", "i’m sorry", "forgive me", "love song", "poor audio quality", "heartfelt", "vocal harmony", "clapping percussions"] | 1 | -wymN80CiYU | 105 | |
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 | |
Missing from YouTube | A male vocalist sings this soft melody. The tempo is medium with smooth guitar, keyboard harmony, steady bass slide and synthesiser arrangements. The song is mellow, romantic, emotional, soothing; ambient. There is a hooting sound like a fog horn with a male voice talking over the song. This song is a R&B/Soul song. | ["Music", "Reggae", "Song"] | ["male singer", "slow tempo", "sound of horn", "fog horn", "super imposed male voice", "romantic", "emotional", "soothing", "pleasant", "r&b", "soul", "acoustic guitar", "keyboard harmony", "synthesiser articulation", "fingers snapping", "groovy bass line", "male voice speaking", "reggae", "soft melodious"] | 7 | 4427 |
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;