musiccaps_details (view)
2 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2010-09-08
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- american 1
- banjo 1
- bass guitar playing 1
- bass lick 1
- bass riff 1
- bluesy 1
- easygoing 1
- folk 1
- fret slide 1
- groovy 1
- instrumental 1
- melodic 1
- solo bass guitar 1
- violin 1
musiccaps_names (array) 8 ✖
- Music · 2 ✖
- Banjo 1
- Bass guitar 1
- Bluegrass 1
- Electronic tuner 1
- Guitar 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 |
---|---|---|---|---|---|---|---|---|---|---|
Bass Guitar Lessons - Fretboard Fitness - #3 Modes & Scales - Stu Hamm | This is a clip which sees a solo bass guitarist play a series of motifs in a bluesy style. The playing oscillates between a low phrase and high notes to which the player slides down. | 2010-09-08T19:42:36Z | TrueFire | FULL COURSE, TAB, JAM TRACKS: http://bit.ly/FretboardFitness MORE STU HAMM BASS LESSONS: http://bit.ly/StuHammU JOIN TRUEFIRE FOR FREE: http://bit.ly/TrueFire Stu Hamm's Fretboard Fitness digs deep into bass guitar fretboard navigation, finger agility and the theoretical knowledge necessary to play all styles of music. If you consider yourself an intermediate bass guitar player, Stu Hamm's Fretboard Fitness is the bass boot camp you need to take your skills to the next level. Stu Hamm first came to prominence after playing on Steve Vai's Flex-Able disc. Going on to become the bassist of choice to lay down the low-end for virtuoso guitarists like Frank Gambale, Joe Satriani and many others on the stage and in the studio. Fortunately for students of bass guitar, Stu's teaching skills match his musicianship providing a rare opportunity to learn bass guitar from one of the very best on the planet. "These are the bass guitar lessons I wish I had when I was coming up. I've distilled the curriculum in Fretboard Fitness to the essential nuts and bolts of playing bass guitar; navigating the fretboard, building hand strength, and understanding the essential principles of music theory and harmony. All of the video bass guitar lessons, exercises and workouts that I've included in Fretboard Fitness are designed to form a strong bond between your hands, ears and mind." The best quality of this course is how you work with it; you'll play your way through Fretboard Fitness. No tedious, boring routines or theoretical math here. Stu designed each workout to provide equal measures of applied theory, fretboard navigation and hand strength. This 3-in-1 approach gives you more of a musical perspective and makes working out more fun. | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] | ["bass guitar playing", "solo bass guitar", "bass lick", "bass riff", "bluesy", "groovy", "fret slide"] | 3 | bsz_enSJSVk | 3662 | |
Cluck Old Hen. This time with song and fretless mountain banjo. | This is an instrumental folk song with the melody played both by a banjo and a violin at the same time. The combination of these instruments creates a very American, western-movie type of atmosphere. It could be used in opening sequences of movies/shows taking place in rural USA. | 2010-09-08T22:41:56Z | Jesper Deleuran | Tobias Enevoldsen and I playing Cluck Old Hen tonight. I play on a fretless mountain banjo build by John Peterson. Look him up here: http://www.youtube.com/user/frailingbanjo | ["Banjo", "Music", "Bluegrass"] | ["banjo", "violin", "folk", "easygoing", "melodic", "instrumental", "american"] | 9 | flLjMZMydXc | 3975 |
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;