musiccaps_details (view)

3 rows where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "soloist", musiccaps_names contains "Effects unit" and musiccaps_names contains "Plucked string instrument"

✎ 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
ジャズコーラスの音色とマーシャルガバナーの威力 The song is an instrumental. The song is medium tempo with an electric guitar playing chords and strumming rhythm with no other instrumentation. The song is emotional and interesting. The song is probably a demo of a guitar or guitar amplifier. The audio is average quality. 2011-10-24T16:02:01Z yskpai81 ガバナー大好き。 http://mixi.jp/view_diary.pl?id=1786483877&owner_id=11016145 ↑これです。昔は四角い形だったのに、今は流線型のボディになってます。 音は昔の方が良かったような気がします。 ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] ["electric guitar", "strumming chords", "virtuoso", "guitar lessons online", "guitar strumming rhythm", "guitar amplifiers", "guitar demonstration", "live performance", "youtube music video", "average audio quality", "medium tempo", "instrumental music", "emotional", "spirited", "soloist", "ambient room noises"] 1 2xATintzaj4 420
ZCAT Q-MOD Pedal The song is an instrumental. The song is medium tempo with an electric guitar playing a pleasant solo with a pedal affecting its tone. The song is a guitar effects demo. The song audio quality is poor. 2010-09-13T19:45:04Z ZCAT Pedals http://zcatpedals.com/?dir=view&id=20090818194445xiVC Q-Mod is a digital multi-effects processor featuring Chorus, Flanger, Phaser, Tremolo and Reverb. ["Reverberation", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] ["amplifier", "pedal", "guitar solo", "slow tempo", "poor audio quality", "echoes", "relaxing", "guitar instrumental", "background music", "music demo", "guitar pedal test", "electric guitar", "guitar lead", "distortion tones", "pleasant", "instrumental music", "slow tempo", "guitar pedal tones", "soloist"] 1 W58kioYp1Ms 3062
Randall Kirk Hammett Signature Amp The song is an instrumental. The tempo is slow with an electric guitar playing lead and a strong bass line in a rhythmic manner. The song is strong and mysterious like a secret agent movie theme. The song is recorded at home and has an average sound quality. The song is a music demo. 2008-07-09T15:06:58Z Guitar World Guitar World's gear editor Paul Riario demonstrates the features of the Randall Kirk Hammett Signature Head and Cabinet. For more gear reviews, lessons, interviews and more check out guitarworld.com! (more) ["Bass guitar", "Reverberation", "Silence", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] ["instrumental music", "slow tempo", "electric guitar", "music demo", "song fade", "reverb tones", "guitar lead", "guitar accompaniment", "strong bass line", "electric guitar demo", "guitar amplifier", "suspense", "no other instrumentation", "soloist", "guitar solo artist", "home music video", "averts sound quality", "emotional passionate", "positive", "mysterious", "secret agent man"] 1 kKihNQ44dDQ 4309

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;