musiccaps_details (view)

3 rows where musiccaps_aspects contains "no voice", musiccaps_names contains "Bass drum" and musiccaps_names contains "Drum kit"

✎ 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
Space Truckin' - Deep Purple This classic rock song features a hammond organ playing the main melody. This is backed by the percussion playing a simple beat. The percussion plays the hi-hat at every count and ends with a roll at the end of every bar. The bass plays the same melody as the hammond. There are no voices in this song. This is an instrumental song. This song can be played in a bank robbery scene in a movie. 2011-09-27T10:46:15Z RetroTVCentral Compilation of scenes from several scifi movies and television shows accompanied by the classic rock song Space Truckin'(1972) by Deep Purple. Movie and television scenes include: Star Wars Armageddon When Worlds Collide Lost in Space(1998) Queen of Outer Space Battlestar Galactica(1978) Total Recall Missle to the Moon The Fifth Element Planet of the Apes (1968) Mission to Mars Austin Powers: The Spy Who Shagged Me 2001: A Space Odyssey Close Encounters of the Third Kind 2001: A Space Travesty Return of the Jedi Superman 2 Space Truckers Star Trek 2: The Wrath of Khan Aliens Galaxy Quest Spaceballs Farscape This Island Earth Starship Troopers First Spaceship on Venus Forbidden Planet ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] ["classic rock", "simple percussion", "hammond organ", "bass", "minimal instruments", "no voice", "instrumental", "moderate tempo", "happy mood"] 0 8zGJ9N7c6pE 966
How to build a Zep-style Drum Kit This clip features a drum solo being played. The first beat in the clip is played by striking the hi-hat and kick twice and then the snare once. This pattern is repeated three times followed by a roll. The snare is played four times followed by the toms. This pattern is played twice. This is followed by a pattern where the snare and toms are struck in a sequence of four strokes, five strokes and six strokes all fitting within the counts of the bar. This song is a demo of the percussion instrument being used. 2015-12-29T15:54:04Z Sweetwater Check out the latest drum assembly video here: "How to Assemble a Drum Kit " https://www.youtube.com/watch?v=MbB1PfrbYBY Hey everybody, for this video we're putting together a modern take on the drum kit of a legendary drummer, John Bonham from Led Zeppelin. The Zep Set shell pack is made from an amber acrylic that matches Bonham's kit from Led Zeppelin's film The Song Remains the Same. Ludwig's Vistalite acrylic is famous for its huge attack and attention-grabbing looks. These drums are great for hard rock and metal due to their loud and present tone. The Paiste 2002 Bonham 5-piece cymbal set re-creates John Bonham's most popular cymbal setup. Shop everything drums here: https://www.sweetwater.com/shop/drums-percussion/?utm_source=YouTube&utm_medium=Referral&utm_campaign=GWcMqKYOJR4 #Sweetwater #HowToBuildADrumKit ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] ["drum solo", "instrumental", "no other instruments", "no voice"] 0 GWcMqKYOJR4 1729
6 Stroke Roll Drum Instructional This clip features a drum solo being played on a rock drum kit. The snare, kick, toms, hi-hat and splash are being struck. A pattern is played on this percussion. There are no other instruments in this song. There are no voices in this song. This song can be played in a drum instruction video. 2010-05-02T21:49:45Z Brian Czach Las Vegas drummer (currently living in Nashville) Brian Czach gives a demonstration of the 6 stroke roll and breaks it down into parts, creating new vocabulary on the drum set. Created for www.thedrumdungeon.com and www.brianczach.com Please like & subscribe! www.brianczach.com Add me on: Instagram @brianczach Facebook https://www.facebook.com/nashvilleses... Twitter @brianczach ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] ["drum solo", "no other instruments", "no voice", "instrumental", "moderate tempo", "instructional song"] 0 h-3DrDQC62k 4073

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;