home / musiccaps

musiccaps_details (view)

3 rows where musiccaps_aspects contains "rock music" and musiccaps_names contains "Blues"

✎ 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
Canoe Verdon, Kayak Castellane,...Canoe-Kayak Raft dans les Gorges du Verdon (Castellane) The song is an instrumental. The tempo is medium with a strong drumming rhythm, keyboard harmony, string synth harmony, guitar lead and a bass guitar shadowing the melody line in harmony. The song has rock music influences with a sense of mystery and adventure. The song is a soundtrack for an adventure sports documentary. 2012-01-12T08:54:25Z Base Sport et Nature Canoe Verdon, Kayak Gorges du Verdon, Castellane. Le Cano-Raft et le Kaya-Raft est un savoureux mélange entre le rafting et le canoë connu de tous. Le Verdon est une merveilleuse rivière aux eaux émeraude dessinant à travers la Provence, au Nord des plages de la Côte d'Azur, le plus grand canyon d'Europe. www.basesportnature.com ["Blues", "Electric guitar", "Heavy metal", "Music", "Rock music", "Progressive rock"] ["instrumental musical", "mysterious", "medium tempo", "string section harmony", "keyboard harmony", "guitar playing", "shadow guitar bass line", "steady drumming rhythm", "rock music", "amateur band", "adventure", "suspense", "adrenaline rush", "passionate", "spirited", "home video soundtrack", "adventure sports documentary", "documentary soundtrack", "unexpected"] 1 GYx6HNQbP1w 1735
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
Journey - "Lights" guitar solo This is an amateur recording of a guitar solo for a rock music piece. The solo is being played on an overdriven electric guitar while the piano and the bass guitar in the backing track play the main tune. There is a 6/8 rock beat played on the acoustic drums for the rhythm section. There is a raw feel to it. The piece can be used to gather electric guitar samples to be used in beat-making. 2009-08-16T15:44:28Z ChuckieVeee Journey - "Lights" guitar solo played on an Epiphone Prophecy GX through a Roland Micro Cube ["Blues", "Music"] ["amateur recording", "rock music", "instrumental", "electric guitar", "guitar solo", "bass guitar", "piano", "acoustic drums", "groovy", "hard", "raw"] 9 s2GctT6NuyQ 4917

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;
Powered by Datasette · Queries took 745.078ms · About: simonw/musiccaps-datasette