musiccaps_details (view)

5 rows where musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Tapping (guitar technique)"

✎ 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
Protest The Hero - Sequoia Throne [2] Someone is strumming chords on a distorted e-guitar while someone is playing a fast solo up the fretboard with another e-guitar. This song may be playing practicing solos at home. 2010-01-14T03:52:09Z kamikaz1k Tim's Axe - Caparison Dellinger Luke's Axe - Ibanez S5470 ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] ["amateur recording", "rock", "e-guitars", "slow tempo"] 6 L1fxVVl_1bM 2143
Tortuga Effects Martini Vs. Analog.Man Chorus This music is instrumental. The tempo is slow with a lush guitar harmony with the sound of switches being turned on and off. The sound is rich, deep, intense and dense. This is a review audio between a Tortuga Martini vs an Analog Martini. 2011-02-22T22:39:23Z Tortuga Television I get asked all the time how the Martini compares to the Analog.Man chorus. Well, here you go. Both pedals are running fresh Duracell 9v batteries and have not been modded. Please let me know what you think. Gear used: Don Grosh Retro Classic (on neck/middle pickups) Swart Atomic Space Tone (set flat with no verb or trem) Solid Cables www.tortugaeffects.com ["Tapping (guitar technique)", "Echo", "Effects unit", "Guitar", "Music", "Chorus effect", "Plucked string instrument"] ["instrumental", "slow tempo", "analog chorus", "reverb", "dense", "rich", "sound of switches", "review video", "comparison", "tortuga martini review", "chorus guitar effect", "lush"] 7 L8zjEoQFws8 2153
Fender Deluxe Reverb '65 Reissue Cranked up a bit! This amateur recording features an overdriven guitar playing the main melody. This is a low quality recording and the volumes of the instruments are not professionally mixed. The overdriven guitar is loud. A piano plays a couple of notes in the beginning. The guitar is accompanied by percussion playing a simple beat in the background. The bass plays a blues style bassline. The tempo of this song is slow. The song is based on blues style. 2012-08-01T12:50:32Z Sam Rhodes Just using my Gibson 339 into a Fender Deluxe Reverb Reissue turned up to 7 with a Dr Z Brake Lite on 4. ["Reverberation", "Tapping (guitar technique)", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] ["amateur recording", "blues melody", "overdriven guitar", "vibrato", "blues bassline", "simple percussion", "slow tempo", "no voice", "instrumental", "piano notes"] 0 Qe71m678qEU 2632
Disturbing The Peace 2.3 ThanksGiving Special This song features an acoustic guitar playing chords using only down strokes. There are only two chords being played. The rhythm is played on a 6/8 time signature. A male voice sings vocables in falsetto. Toward the end, the voice produces a belching sound. There are no lyrics in this song. There are no other instruments in this song. This song can be played at a quirky party. 2014-11-27T22:16:35Z StevenJoTV ThanksGiving Special! Follow Me on Twitter And IG - @StevenJoTV Follow me on instagram! - @StevenjoTV Follow Me On Twitter - http://twitter.com/#!/StevenJoTV Like My Facebook Page - http://www.facebook.com/StevenJoTV ["Tapping (guitar technique)", "Guitar", "Plucked string instrument"] ["amateur recording", "male voice singing vocables", "falsetto voice", "acoustic guitar", "two chords", "quirky sounds", "slow tempo", "no other instruments"] 0 YlgCFc3OvmI 3310
Marshall JTM-45 Bluesbreaker + Gibson SG + Slide This music is an electric guitar instrumental. The tempo is slow with an electric guitar harmony and a subdued, incoherent background score. This music is classic Rock. 2007-01-13T11:30:16Z Claudio Crotti JTM-45 Bluesbreaker and Gibson SG Slide ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] ["instrumental", "slow tempo", "electric guitar harmony", "classic rock", "incoherent backup music", "background music", "subdued background music", "ambient sounds", "loud feedback", "amplified guitar", "sonic power", "stringed instrument", "rock", "heavy rock", "metal"] 7 wLQiZ-0VW4c 5258

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;