musiccaps_details (view)

3 rows where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "instrumental", musiccaps_aspects contains "vibrato" and musiccaps_author = 7

✎ 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
eruption tapping This clip is an electronic guitar instrumental. The tempo is fast with a vigorous, lively electric guitar lead without any instrumentation. The music is rapid,controlled, intense and vigorous with immense control and dexterity with the instrument. 2006-08-04T21:03:38Z mymindwasblank tapping from van halen's eruption ["Tapping (guitar technique)", "Music"] ["instrumental", "electric guitar", "stringed instrument", "vibrato", "sonic power", "amplified guitar", "fast tempo", "rapid", "vigorous", "dexterous", "skilled", "practice", "intense", "rock", "hard rock", "home recording"] 7 -ByoSbgzr4M 25
Amanaz - Green Apple. This song is an electric guitar instrumental. The tempo is medium with two amplified guitars playing the lead and harmony respectively with steady drumming. The music is a simple, rhythmic, smooth and engaging Rock instrumental; 2008-06-18T11:08:30Z Mindfuckedproject Awesome beat music from Zambia. Artist : Amanaz Song Title : Green Apple Album : Africa "Amanaz was formed in 1973. Three songs are in the native language Bemba, and 9 songs in English, recorded in Kitwe, the 3rd biggest city in Zambia up north. Musically, it goes in the same direction as Blo, The Witch and Question Mark, but this album is way cooler and stoned with amazing fuzz guitar all over which sounds like an African version of early Cream. The cover makes it look very traditional but after a few spins, you are aware that this one is very special. It's so cool, so tightly-produced and easily compares with UK underground albums with a touch of African beats." ["Music", "Harmonic"] ["electric guitar", "instrumental", "instrumental duet", "medium tempo", "distortion", "vibrato", "electric guitar lead", "electric guitar harmony", "steady drumming", "vibrations", "amplified guitars", "sonic power", "rock"] 7 I368EWBLIs4 1868
Electro-Harmonix Small Clone Chorus (HD) This music is an electric guitar instrumental. The tempo is medium with an amplified guitar lead harmony and synthesiser articulation. The music is not very clear as the recording quality is inferior, but the harmony is catchy, spirited and youthful. 2012-10-12T14:39:36Z brandon672008 HD Electro-Harmonix Small Clone Chorus demo. This is my updated Small Clone demo, made because now I have higher quality sound recording equipment. The Small Clone Chorus is an analog guitar pedal, and in my opinion it is amazing. A Boss DS-2 Turbo Distortion is added towards to end. Feel free to ask me any questions in the comments. ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Distortion"] ["instrumental", "electric guitar", "string instrument", "amplified guitar", "electronic music", "synthesiser articulation", "muffled audio", "inferior quality recording", "catchy riff", "melodious harmony", "reverb", "resonating sound", "vibrato", "sonic power", "electric guitar feedback", "youthful", "animated", "dance music"] 7 LP1yZRsRllQ 2183

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;