musiccaps_details (view)
1 row where musiccaps_names contains "Bass guitar", musiccaps_names contains "Electronic tuner", musiccaps_names contains "Plucked string instrument" and "youtube_published" is on date 2013-11-18
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 |
---|---|---|---|---|---|---|---|---|---|---|
Mixolydian Scales for Bass + "All Blues" and "The Chicken" | The low quality recording features a tutorial where a flat male vocalist is talking, after which a groovy bass guitar is playing. The recording is noisy and in mono. | 2013-11-18T22:00:00Z | Josh Fossgreen | MIXOLYDIAN IN ALL 12 KEYS: http://joshfossgreen.com/books/ FREE PDF FOR THIS LESSON: http://joshfossgreen.com/?p=553 Mixolydian Scales for Bass + "All Blues" and "The Chicken" Another installment in our scale series, this week we're learning the mixolydian scale! From blues to funk to classical V7 chords, this is another really useful scale to know. We'll learn a few different shapes you can use to play the mixolydian mode, and then apply it to two most excellent bass lines. A sidenote on "The Chicken": My favorite recording is from Jaco's "Birthday Concert" album, which is a killer album overall. The Hal Leonard transcription book that you see in the background has the version of the bass line from the "Invitation" album, however. Oh, musical trivia, how we adore you. And yeah, that's a banana on my arm. http://patreon.com/joshfossgreen http://joshfossgreen.com/ | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"] | ["low quality", "groovy bass guitar", "flat male vocal", "noisy", "mono", "tutorial"] | 4 | 4Gow6qZcNZI | 551 |
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;