musiccaps_details (view)

1 row where musiccaps_aspects contains "dubstep/jazz", musiccaps_names contains "Dubstep" and musiccaps_names contains "Music"

✎ View and edit SQL

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
Dubstep Jazz - Herbie Hancock "Rockit/Nobu" (Darryl Reeves remix) This song contains a complex digital drum groove with a loud snare sound and fast sharp hihats. A synth stab sound is running through a fast arpeggiator. A lower arpeggiated synth sound is provided by the bassline along with a sub bass panning to both sides of the speakers. This song is full of electronic effects and noises. This song may be playing in an arcade video-game. 2013-01-01T09:06:01Z Darryl Reeves http://www.youtube.com/watch?v=AwcuLXAPFDs Dubstep/Mashup of Herbie Hancock's "Rockit/Nobu" by saxophonist Darryl Reeves. Made in tribute to the 30-year anniversary of "Rockit", a composition which was the first recognized popular single to feature scratching and other turntablist techniques, performed by GrandMixer D.ST - an influential DJ in the early years of turntablism. Check out Reeves' New Album: Mercury http://darrylreeves.bandcamp.com/album/mercury Facebook http://facebook.com/darrylreevesmusic Twitter http://twitter.com/darrylreeves Official Site http://www.darrylreeves.com Dubstep Jazz - Herbie Hancock "Rockit/Nobu" (Darryl Reeves remix) http://www.youtube.com/watch?v=AwcuLXAPFDs ------------------------------------------------- About Darryl Hailing from Atlanta, GA, Darryl Reeves is a saxophonist that effortlessly merges the lines between funk, soul & hip-hop, expressed from a platform rooted in jazz. Growing up in a musical family, Reeves attended the Northwestern Performing & Visual Arts Center in Miami. Moved by hip-hop samples originating from jazz, Reeves was led to being influenced by greats such as Charlie Parker and John Coltrane. Reeves studied music at Jackson State University. He subsequently completed his Masters of Music at the University of New Orleans, where he studied with Terence Blanchard and performed on the scene with Delfeayo Marsalis. In 2004, Reeves released the funky and playful Diary of a Bandstand, to ample acclaim. It featured Robert Glasper, Russell Gunn & Quamon Fowler and cemented Reeves' reputation for presenting a new outlook on the sound, style and production of jazz music. Reeves has kept a steady hand in not being limited to any specific genre. Some know him just as well for his production in hip-hop. Reeves caught Ahmir "?uestlove" Thompson's attention with his ingenious jazz-funk remixes of Jay-Z's Black Album, which was spun upon many of the drummer's dj sets. Recently in Atlanta, he has been the music director of many highly acclaimed live sets with… ["Electronic music", "Jazz", "Music", "Dubstep"] ["dubstep/jazz", "digital drums", "synth stabs", "synth arpeggios", "uptempo"] 6 AwcuLXAPFDs 1186

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;