musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "energetic", musiccaps_aspects contains "groovy", musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Electric guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- energetic · 2 ✖
- groovy · 2 ✖
- medium tempo · 2 ✖
- blues giants 1
- blues guitar lessons 1
- blues guitar licks 1
- blues guitar tutorial 1
- blues hits 1
- blues legends 1
- electric guitar blues 1
- electric guitar lead 1
- emotional 1
- excellent audio quality 1
- guitar a 1
- guitar technique 1
- home video 1
- instrumental music 1
- legendary licks 1
- massive drum roll 1
- new orleans blues 1
- no other instrumentation 1
- no percussions 1
- note bending 1
- passionate 1
- playing rhythm guitar 1
- plification 1
- poor quality video 1
- relaxing music 1
- romantic 1
- solid intro 1
- …
musiccaps_names (array) 8 ✖
- Electric guitar · 2 ✖
- Guitar 2
- Music 2
- Blues 1
- Distortion 1
- Musical instrument 1
- Plucked string instrument 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ギター レスポールを弾いてみた | The song is an instrumental guitar solo. The song tempo is medium with a racy electric guitar solo with a show of technique of note bending, tremolo and playing rhythmically. The song is home video and an average quality recording. | 2013-05-08T08:11:45Z | RDRGuitarBass | エレキギター RDRを弾いてみた | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Distortion"] | ["electric guitar lead", "note bending", "playing rhythm guitar", "solo guitarist", "soloist", "no other instrumentation", "no percussions", "home video", "poor quality video", "guitar technique", "guitar a", "plification", "medium tempo", "spirited", "emotional", "youthful", "groovy", "energetic"] | 1 | 7V0G65FK2VQ | 850 | |
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 |
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;