musiccaps_details (view)

3 rows where musiccaps_aspects contains "piano" and musiccaps_names contains "Guitar"

✎ 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
C minor rock power ballad guitar backing track Here we have a powerful rock ballad instrumental in a minor key. The guitar is grungy and overdriven, and the piano is clean and plays the same chords as the guitar at the same time. 2012-05-13T21:33:38Z Iain MacLeod Hey guys! Sorry I haven't uploaded any tracks in a while. I made this one today and I hope you enjoy playing over it as much as I did :) Thanks for all the amazing support so far! Happy shreddin'! ["Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] ["rock music", "piano", "electric guitar strumming", "minor key", "rock power ballad", "ballad", "grungy electric guitar strumming", "overdrive"] 3 4M0njWKFsME 560
Epiphone Les Paul Blues in G This is an instrumental rock music piece recording in the style of blues. There is an electric guitar playing a solo using the shredding technique. The backing track consists of a piano, a bass guitar and acoustic drums. There is a groovy feel to it. Parts of this recording could be sampled for use in beat-making. 2006-02-22T07:39:48Z Raúl Cabezalí Download my tunes for free from http://www.jamendo.com/en/artist/353294/raulin-de-los-bosques Raulin de los Bosques plays some blues licks over a g-blues backing track on a Epiphone 'Les Paul' Standard through his Behringer V-amp2. ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] ["rock music", "jam", "no singer", "instrumental", "electric guitar", "guitar solo", "shredding", "backing track", "piano", "bass guitar", "acoustic drums", "groovy", "blues"] 9 hVVrl9FkKnY 4113
Jazzed Blues Solo This slow blues song features a solo played on a guitar. The tempo of this song is slow. This is accompanied by percussion playing a simple beat. The bass follows the 12 bar blues pattern. The piano plays chords in the background. The mood of this song is romantic and the pattern played on the guitar is similar to a call-response theme. This song can be played in a bar. 2006-07-17T14:30:15Z looptruefire My favorite solo from TrueFire's Jazz ed Blues course with Mark Stefani. ["Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument"] ["slow blues song", "instrumental", "guitar solo", "bass", "simple percussion", "12 bar blues", "piano", "slow tempo", "no voices"] 0 qAgZ__fk9LY 4760

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;