musiccaps_details (view)
4 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2013-11-18
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- acoustic drums 1
- bass guitar 1
- congas 1
- drums 1
- e-bass 1
- e-guitar 1
- easygoing 1
- echoing male vocal 1
- electric guitar 1
- euphoric 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
- offbeat sot piano chords 1
- relaxing 1
- rock genre 1
- scratching 1
- slow tempo 1
- smooth 1
- smooth double bass 1
- swing 1
- tutorial 1
- warm 1
- wide sustained string melody 1
musiccaps_names (array) 14 ✖
- Music · 4 ✖
- Speech 2
- Bass guitar 1
- Electronic music 1
- Electronic tuner 1
- Guitar 1
- Independent music 1
- Inside, large room or hall 1
- Musical instrument 1
- Plucked string instrument 1
- Pop music 1
- Progressive rock 1
- Scratch 1
- Swing music 1
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 | |
Robbie Williams ft. Rufus Wainwright | Swing Both Ways (Official Audio) | The Swing song features an echoing male vocal singing over smooth double bass, offbeat soft piano chords and widely spread sustained strings melody. It sounds easygoing, relaxing, smooth, warm and euphoric as it reminds of Christmas. | 2013-11-18T09:21:38Z | Robbie Williams | Connect with Robbie Williams: Website – https://RobbieWilliams.com Newsletter – https://RobbieWilliams.lnk.to/signupID Official Robbie Williams App – https://RobbieWilliams.lnk.to/appID Apple Music – https://RobbieWilliams.lnk.to/AppleMusicID Spotify – https://RobbieWilliams.lnk.to/SpotifyID Facebook – https://www.facebook.com/robbiewilliams Instagram – https://www.instagram.com/robbiewilliams Twitter – https://twitter.com/robbiewilliams | ["Swing music", "Music"] | ["swing", "smooth double bass", "offbeat sot piano chords", "wide sustained string melody", "echoing male vocal", "easygoing", "relaxing", "smooth", "euphoric", "warm"] | 4 | L1s7KZgWXGc | 2145 | |
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;