musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "blues legends" and musiccaps_names contains "Guitar" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 41 ✖
- blues legends · 2 ✖
- instrumental music 2
- acoustic guitar lead 1
- bad audio quality 1
- blues dance music 1
- blues giants 1
- blues guitar 1
- blues guitar lessons 1
- blues guitar licks 1
- blues guitar tutorial 1
- blues hits 1
- country blues band 1
- country blues hits 1
- country blues music 1
- electric guitar blues 1
- emotional 1
- energetic 1
- enthusiastic 1
- excellent audio quality 1
- exciting 1
- groovy 1
- groovy music 1
- legendary licks 1
- live audience 1
- live in concert 1
- live performance 1
- massive drum roll 1
- medium tempo 1
- new orleans blues 1
- passionate 1
- poor audio quality 1
- relaxing music 1
- retro blues 1
- retro blues hits 1
- romantic 1
- solid intro 1
- sophisticated 1
- steady rock drumming 1
- strong walking bass 1
- the blues 1
- the lush life 1
musiccaps_names (array) 7 ✖
- Blues 2
- Guitar · 2 ✖
- Music 2
- Electric guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Steel guitar, slide guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
4 Albert King Style Blues Licks (Slow Blues Guitar Lesson) | The song is an instrumental. The tempo is medium with a slick drumming rhythm starting with a solid drum introduction, strong bass line and a blues guitar solo. The song is energetic and passionate. The audio quality is excellent. | 2011-05-20T21:29:49Z | Texas Blues Alley | * Join The TXBA Locals: https://texasbluesalley.com/locals * TXBA Email List: https://texasbluesalley.com/email * Lesson page: https://texasbluesalley.com/woodshed/free/4-albert-king-style-licks * Insta: https://instagram.com/texasbluesalley * Twitter: https://twitter.com/texasbluesalley In this free lesson, you'll learn 4 licks from the Albert's Influence course. If you like this video, you'll love the course. Join the TXBA Locals today for unlimited access to our huge library of Texas Blues guitar courses. | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["electric guitar blues", "instrumental music", "blues guitar lessons", "legendary licks", "excellent audio quality", "the blues", "blues guitar tutorial", "romantic", "the lush life", "blues legends", "sophisticated", "blues guitar licks", "new orleans blues", "blues hits", "relaxing music", "energetic", "passionate", "groovy", "solid intro", "blues giants", "romantic", "massive drum roll", "medium tempo"] | 1 | JLYb7DwCaQU | 1994 | |
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;