musiccaps_details (view)
5 rows where musiccaps_aspects contains "electric guitar lick"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Lee Seung Gi singing Because You're My Girl on Love Letter | The Romance song features an electric guitar lick, low toms roll and soft crash cymbal, followed by emotional piano chord progression and wide background crowd screams, as the passionate male vocal sings over it. Judging by the crowd sound effect, it seems that this is a live performance. Sounds emotional, passionate, heartfelt and romantic. | 2007-09-24T20:10:21Z | adams1030 | This is Lee Seung Gi (my favorite singer) singing his first hit song, Because You're My Girl (which isn't an exact translation, but whatever, that's what everyone else seems to think) on Yoon Do Hyun's Love Letter. LSG's mentor and fellow singer, Lee Sun Hee, comes out to sing with him at the end chorus... | ["Music", "/t/dd00003"] | ["romance", "wide background crowd screaming", "electric guitar lick", "emotional piano chord progression", "passionate male vocal", "low tom roll", "soft crash cymbal", "heartfelt", "romantic", "emotional", "passionate"] | 4 | -r2-9oyIzkQ | 90 | |
| Lady Cab Driver (Video) | The song has a laid-back, unfussy feel to it. There are various instruments layered to form a smooth, groovy, yet mellow song. The song would be categorized as pop rock, owing to the electric guitar lick and prominent electric guitar chord plucking. There's also an organ and an electric piano. The singer sounds soulful but relaxed. | 2012-11-16T14:08:25Z | johnny j rivera | Lady Cab Driver (Video) | ["Music", "Happy music"] | ["electric guitar lick", "pop rock", "electric guitar chord plucking", "mellow", "laid-back jazzy rock", "simple jazzy rock drumming", "organ chords", "smooth"] | 3 | 4Bc9OoagYmo | 545 | |
| Dr. Rockzo. "I'm a Rock n Roll Clown" | This is a recording of a live show performance by a rock band. We hear some cheering fans and then the song starts with an electric guitar lick and a bass guitar, and a kick on the drums. The audio quality is muffled and poor. | 2009-04-11T20:25:15Z | starz7007 | Brenden Small and the School of Rock all stars at the Starland Ballroom. 4-4-09. Dr. Rockzo. "I'm a Rock n Roll Clown" from metalocalypse | ["Drum kit", "Music", "Musical instrument", "Rock music", "Shout", "Rock and roll", "Speech"] | ["live recording", "cheering fans", "live performance", "rock", "poor audio quality", "electric guitar lick", "alternative rock", "blues rock"] | 3 | XHczpbtBhk4 | 3171 | |
| Country Swing Dancing - Moves Tricks Lifts Aerials Dips Flips | The song is a country rock song with a charged up, potent sound. The guitar is grungry, and gives punchy and gritty energy. The singer has a smooth voice and sings with charisma and suave charm. | 2011-06-06T20:49:56Z | ForeverCountryDancing | Check out more dance clips and country swing dance instruction on our YouTube channel and https://forevercountry.intelivideo.com/. Purchase your Forever Country t-shirt at https://www.redbubble.com/people/forevercountry3/explore?asc=u&page=1&sortOrder=recent | ["Country", "Music", "Rock and roll"] | ["country rock", "banjos", "grungy electric guitar", "simple rock drumming", "electric guitar lick", "charged up", "high octane", "rock"] | 3 | ewI4q7_4TBQ | 3910 | |
| The PowerPipes | The low quality recording features a bagpipe melody, layered with an electric guitar lick and followed by punchy kick hits. In the background there are some crowd talking noises and claps. It sounds exciting and the recording is noisy and in mono. | 2009-08-26T10:25:54Z | fVZD | TPP featuring at pan ulica fest špancirfest :D | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["low quality", "bagpipe melody", "clapping", "punchy kick", "crowd talking", "mono", "noisy", "electric guitar lick", "exciting"] | 4 | yAvqiPL-ssU | 5390 |
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;