musiccaps_details (view)
3 rows where musiccaps_aspects contains "guitar fills"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Son Little - "Doctor's In" (Full Album Stream) | This blues song features a male voice singing the main melody. This is accompanied by the percussion playing a simple beat. The percussion plays the tambourine as well. The bass plays the same licks played on the guitar. The guitar plays notes that are octaves apart. Toward the end of the song, an overdrive guitar plays a hammer on note. The mood of this song is comforting. This song can be played in a bar. | 2015-10-16T14:44:42Z | ANTI- Records | Listen to the full album: http://bit.ly/1hILGZr "Doctor's In" by Son Little from the self-titled debut album, available now Download on iTunes: http://found.ee/SonLittle Order on CD and vinyl: http://found.ee/SonLittlestore Listen on Spotify: http://bit.ly/1jEpzVR Facebook: https://www.facebook.com/SonLittleMusic Twitter: https://twitter.com/sonlittlemusic Tumblr: http://sonlittle.tumblr.com/ | ["Music", "Middle Eastern music"] | ["blues song", "male voice", "guitar fills", "guitar playing octaves", "simple percussion", "tambourine", "bass", "slow tempo", "comforting song"] | 0 | Ou7vteWmqfw | 2479 | |
| Two Pin Din - Screaming Blue Murder live - Nov 15th, 2008 | This amateur recording features two guitars being played. One guitar is playing a blues rhythm. The other guitar is strumming the main chord once and then playing fills on the higher register. This is accompanied by a tambourine as the percussion. There are no voices in this song. This is an instrumental blues rock song. The mood of this song is suspenseful. This song can be used in a detective movie. | 2008-11-18T20:01:48Z | twopindin | When in doubt, follow the advice of Nick Lowe. Namely, "bash it out then tart it up later". Where's Deja Voodoo when you need them? Yet another song offered up off of Two Pin Din's oh-so-fab-you-just-don't-know-it-yet album "In Case Of Fire Break Glass". | ["Heavy metal", "Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock", "Grunge"] | ["amateur recording", "blues guitar", "guitar fills", "tambourine backing", "minimal instruments", "no voice", "instrumental song", "suspenseful mood", "moderate tempo"] | 0 | gp7j9o2x9co | 4055 | |
| Kid Rock - American Badass (DIRTY) HQ | This heavy metal song features a male voice singing the main melody. The song starts with male voices singing 'hey, hey'. This is accompanied by aggressive percussion playing a rock beat. A distortion guitar is playing lead fills and another distortion guitar playing power chords. The bass plays the root notes of the chords. Another voice comes in and is screaming at a high pitch. This is accompanied by continuous snare hits for 8 bars. The main voice starts singing at this time and is accompanied by rock percussion. The bass plays the same root notes once again and the distortion guitar plays a riff in the background. The other guitar continues to play lead fills. The mood of this song is defiant. This song can be played in a rebel themed movie. | 2012-03-05T16:54:46Z | SickRockMusic | Wallpaper made by me. Song: American Badass Artist: Kid Rock Album: History of rock | ["Music", "Angry music"] | ["heavy metal song", "aggressive percussion", "male voices", "screaming vocals", "distortion guitar", "bassline", "guitar fills", "aggressive voice", "defiant mood"] | 0 | sHbGsZUsisE | 4938 |
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;