musiccaps_details (view)

3 rows where musiccaps_aspects contains "acoustic guitar solo melody"

✎ 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
50 guitar building tools anyone can make The low quality recording features a flat male vocal talking over an acoustic guitar solo melody playing in the background. It sounds like a tutorial and the recording is in mono. 2009-10-20T18:40:43Z Jamie Boss You can learn more about my guitar building, banjo and mandolin DVDs at http://www.hotstringsguitar.com. You can purchase the entire 30 minute DVD by going to http://stores.ebay.com/Hot-Strings-Guitar-Shop or http://www.hotstringsguitar.com/dvd-guitar-building-tools.php. This is my latest DVD "50 guitar building tools anyone can make". The 30 minute video highlights 50 tools that I have built in my workshop for guitar building and repair. Easy to make and well thought out, these tools will inspire a lot of guitar making tools in your guitar shop. Designed for the beginning guitar builder and luthier alike, this DVD can be purchased on my website, www.hotstringsguitar.com. Background guitar by Jamie Boss. Copyright®2009 Jamie Boss ["Bass guitar", "Guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] ["low quality", "flat male vocal", "acoustic guitar solo melody", "tutorial", "mono"] 4 4LZSSya3ZZQ 558
Kjarkas - Mi gran amor The low quality recording features a passionate, reverberant male vocal singing over a wide arpeggiated acoustic guitar melody and acoustic guitar solo melody, followed by a simple bass. It sounds emotional and passionate. 2012-11-07T23:29:37Z Erick Salazar Mi amor, mi gran amor, mi mas bella ilusión, mejor canción, los ojos de mi alma a quien cuide, la tierna ilusión que alimente... ["Folk music", "Music"] ["low quality", "passionate reverberant male vocal", "acoustic guitar solo melody", "wide arpeggiated acoustic guitar melody", "simple bass", "emotional", "passionate"] 4 TWV3YLscSaw 2839
Willow & Lee - Foggy Mountain Breakdown The low quality recording features a live performance of a folk song and it consists of acoustic guitar solo melody, followed by banjo melody. The recording is noisy, there are some natural sounds - since it was performed outdoors and the stereo image is unbalanced due to the fact that the instruments are leaning towards the right channel of the stereo image. It still sounds passionate and upbeat. 2014-06-01T14:36:03Z WillowOsborne 13-year Old Willow Osborne & Lee Marcus performs "Foggy Mountain Breakdown" at Dollywood, Pigeon Forge, TN. (May 2014) ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] ["low quality", "noisy", "live perforamnce", "unbalanced stereo", "nature sounds", "acoustic guitar solo melody", "upbeat", "banjo melody", "folk", "passionate"] 4 qyCea2TuUV4 4840

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;