musiccaps_details (view)

4 rows where musiccaps_aspects contains "noisy" and musiccaps_names contains "Heavy metal"

✎ 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
blues solo in A tokai les paul and marshall jcm900 dual reverb combo The low quality recording features a cover of a rock song that consists of an electric guitar solo melody played over playback instrumental. The instrumental features a punchy kick and snare hits, soft cymbals and smooth bass. It sounds passionate, even though the recording is muffled and noisy, as it was probably recorded with a phone. 2014-03-06T23:42:30Z Dave Hardy Dave does a blue in A from a tracker off youtube.The guitar is a modded tokai/gibbo love rock with seymor duncan sh5 and warman p90.The amp is a 1992 Marhall 100 watt dual reverb combo.The effects and pedals are named as he uses them. ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Heavy metal", "Music", "Distortion"] ["low quality", "noisy", "cover", "rock", "electric guitar solo melody", "playback instrumental", "punchy snare", "punchy kick", "smooth bass", "soft cymbals", "passionate", "muffled"] 4 -OAyRsvFGgc 41
Humor: That's how regular guitar sounds with Guitar Hero chords This music is instrumental. The tempo is medium with a loud , distorted electric guitar harmony. The audio is inferior quality and the sound is raw, loud , unpleasant , boisterous and harsh. There is some noise, like a subdued song playing in the background. 2009-01-21T04:02:38Z scooperfield Is it hard to play Guitar hero with normal guitar? ["Bass guitar", "Reverberation", "Effects unit", "Electric guitar", "Heavy metal", "Music", "Clatter", "Distortion"] ["instrumental", "fast tempo", "distorted sounds", "subdued song in background", "harsh", "raw", "inferior audio quality", "vigorous", "boisterous", "noisy", "unpleasant", "electronic music", "intense", "loud electric guitar feedback", "unpleasant", "sharp"] 7 c-8SLUH5pp4 3673
KISS - Psycho Circus (Live 1998) The low quality recording features a live performance of a rock song that features wide electric guitar chords, distorted bass, reverberant toms, punchy kick hits and energetic crash cymbals. There are a few electric guitar slides. The recording is very noisy and it sounds energetic. 2007-03-22T02:19:12Z reverendcuntbag KISS - Psycho Circus Live 1998 on Fox TV Halloween Party ["Heavy metal", "Music", "Angry music"] ["low quality", "rock", "wide electric guitar chords", "distorted bass guitar", "reverberant toms", "punchy kick", "energetic crash cymbal", "live perforamnce", "energetic", "noisy", "electric guitar slide"] 4 iCHskFoUvbw 4167
Solo Bass (fingerstyle, slap, tap) The low quality recording features a groovy bass guitar played over a muffled, barely audible, playback instrumental. It sounds groovy and funky, even though you can hear that the player is practicing. 2007-07-28T10:42:51Z peltbearer This is me playing a few riffs I came up with, or a song if you like. Oh and I threw in another little thing in the middle as well. ["Bass guitar", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Heavy metal", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] ["low quality", "noisy", "groovy bass guitar", "muffled playback instrumental", "groovy", "funky"] 4 tFVvupXoRoM 5019

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;