musiccaps_details (view)
4 rows where musiccaps_aspects contains "sentimental", musiccaps_author = 7 and musiccaps_names contains "Blues"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| Blues Guitar Lesson Larry Carlton @ Videoguitarlessons.com | This music is instrumental , the tempo is slow with an electric guitar lead and a strong bass guitar accompaniment. The music is assertive and emphatic but sounds sad, melancholic,nostalgic, romantic , wistful and sentimental. This music is Blues Harmony. | 2008-03-20T18:05:26Z | eikohtiek | This is a blues jam that Larry did for my favorite website. A little taste of what kinds of things you can learn from his course. Larry is a master of Blues, Jazz, and fusion. He's played on some of your favorite Rock and Roll tracks too such as Steely Dan's, "Kid Charlemagne," He has shared studios and stages with the like of The Crusaders, Joni Mitchell, Sammy Davis Jr., Quincy Jones, John Lennon, Jerry Garcia, Michael Jackson, Stanley Clark, Billy Cobham, Bobby Bland, and many more. He also plays in the group Fouplay with Nathan East, Bob James, and Harvey Macon. I have taken these lessons and they really show you how to phrase well and make every note count. | ["Blues", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "slow tempo", "electric guitar lead", "melancholic", "nostalgia", "sad", "wistful", "romantic", "sentimental", "emotional", "bass guitar accompaniment", "groovy", "blues", "r&b", "jazz", "dissonant harmony", "melancholic", "somber", "blues lessons", "electric guitar lesson", "simple melody"] | 7 | NlUf1ppoSG4 | 2359 | |
| 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 | |
| Richard Burton... pedal steel guitar... last date | This music is a Country song instrumental. The tempo is medium with a pedal steel guitar lead harmony with steady drumming and keyboard accompaniment. The music is a simple,minimalist, sweet, dulcet, sentimental, nostalgic, soothing, pleasant and mellifluous , classic Country music instrumental. | 2011-02-03T00:25:39Z | Bob Adams | Richard's rendition of Floyd Cramer's 'Last Date' A sweet sound from that ZB Richard! | ["Blues", "Music", "Steel guitar, slide guitar"] | ["instrumental", "medium tempo", "keyboard accompaniment", "minimalist", "dulcet", "auto harp", "steel guitar", "pedal steel guitar", "steady drumming", "country song", "country song instrumental", "country instrument", "bluegrass", "regional music", "folk music", "pleasant", "nostalgic", "sentimental", "soothing", "mellifluous"] | 7 | qVT6GX1KHUY | 4788 |
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;