musiccaps_details (view)
3 rows where search matches "guitar" and "youtube_published" is on date 2013-11-18
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic drums 1
- bass guitar 1
- congas 1
- drums 1
- e-bass 1
- e-guitar 1
- electric guitar 1
- female voice 1
- flat male vocal 1
- groovy bass guitar 1
- hiphop 1
- low quality 1
- male voice sample 1
- mono 1
- noisy 1
- rock genre 1
- scratching 1
- slow tempo 1
- tutorial 1
musiccaps_names (array) 13 ✖
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 | |
2007 - DJ Miya Jima (Japan) - DMC World DJ Final | This song contains someone scratching over a Hip-Hop track. The track contains acoustic drums with a rim-shot as snare and congas playing along. The e-bass and an e-guitar are playing the same lines in the lower register. This song may be playing live at a scratching contest. | 2013-11-18T10:27:09Z | DMC World Championships | DJ Miya Jima (Japan) DMC World DJ Finals 2007 Indig02, The 02, London. www.dmcworld.com www.dmcdjchamps.com www.facebook.com/dmcdjchamps www.twitter.com/dmc_dj_champs | ["Electronic music", "Music", "Scratch", "Speech", "Inside, large room or hall"] | ["hiphop", "scratching", "e-guitar", "acoustic drums", "congas", "e-bass", "male voice sample", "slow tempo"] | 6 | 8oTTgXIO0-I | 946 | |
ruido rosa- persona en vivo | The rock music features a female voice singing a melody. The band that accompanies her consists of drums, bass guitar and electric guitar. The drums play a repetitive rhythm, the bass guitar also incorporates slides into its playing and the electric guitar plays a simple melody that's composed of repetitive notes. | 2013-11-18T01:49:39Z | PIC AZO | ["Music", "Independent music", "Pop music", "Progressive rock"] | ["female voice", "bass guitar", "drums", "electric guitar", "rock genre"] | 2 | RIpfb9LSFe8 | 2691 |
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;