musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy music" and musiccaps_names contains "Steel guitar, slide guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- emotional 2
- groovy music · 2 ✖
- acoustic guitar lead 1
- adrenaline rush 1
- bad audio quality 1
- blues dance music 1
- blues guitar 1
- blues legends 1
- country blues band 1
- country blues hits 1
- country blues music 1
- d]steady drumming rhythm 1
- dreamy 1
- enthusiastic 1
- exciting 1
- guitar skills 1
- guitar solo 1
- high on adrenaline 1
- instrumental hits 1
- instrumental music 1
- keybiard harmony 1
- keyboard harmony 1
- live audience 1
- live in concert 1
- live performance 1
- medium tempo 1
- poor audio quality 1
- retro blues 1
- retro blues hits 1
- retro guitar hits 1
- rock guitar solo 1
- rock guitarist 1
- soloist 1
- steady percussion rhythm 1
- steady rock drumming 1
- string section accompaniment 1
- strong walking bass 1
- tremolo 1
- vibrato 1
- whammy bar 1
musiccaps_names (array) 6 ✖
- Guitar 2
- Music 2
- Steel guitar, slide guitar · 2 ✖
- Blues 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Whammy Bar Phrasing Solo | The song is an instrumental. The tempo is medium with an electric guitar playing a dreamy solo with a keyboard accompaniment , string section harmony and rhythmic percussion rhythm. The song is passionate and emotional. The song is a rock guitar instrumental. | 2011-02-03T00:16:18Z | gmcguitar | Breathtaking solo by Piotr Kaczor with tabs and slow illustrations, more: http://www.guitarmasterclass.net/s/youtube-piotr-whammy-bar-2/ls/Whammy-Bar-Phrasing-II/ More Piotr lessons: http://www.guitarmasterclass.net/s/youtube-piotr-whammy-bar-2/instructor/Piotr-Kaczor/ | ["Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["guitar solo", "whammy bar", "keyboard harmony", "steady percussion rhythm", "tremolo", "vibrato", "guitar skills", "rock guitar solo", "dreamy", "emotional", "adrenaline rush", "retro guitar hits", "instrumental hits", "high on adrenaline", "string section accompaniment", "rock guitarist", "soloist", "keybiard harmony", "steady percussion rhythm", "d]steady drumming rhythm", "groovy music", "medium tempo"] | 1 | BqIZipifARo | 1294 | |
Roy Rogers (slide guitar) - Look Over Yonders Wall | The song is an instrumental. The song is medium tempo, with an acoustic guitar playing blues, strong drumming rhythm, walking bass line and keyboard harmony. The song is exciting and has a dance rhythm. The audio quality is poor. | 2007-11-22T23:21:53Z | Vladimir BluesJammer | Roy Rogers (slide guitar) - performance from his video "Slide Guitar For Rock & Blues" http://www.homespuntapes.com | ["Blues", "Guitar", "Music", "Steel guitar, slide guitar"] | ["acoustic guitar lead", "country blues music", "poor audio quality", "instrumental music", "blues legends", "blues legends", "live performance", "live audience", "live in concert", "country blues band", "retro blues hits", "bad audio quality", "strong walking bass", "blues guitar", "steady rock drumming", "exciting", "enthusiastic", "retro blues", "country blues hits", "emotional", "enthusiastic", "groovy music", "blues dance music"] | 1 | hzznbzry5R8 | 4156 |
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;