musiccaps_details (view)

1 row where musiccaps_aspects = "["amateur recording", "clean e-guitar", "soothing melody", "medium to uptempo"]", musiccaps_author = 6 and musiccaps_names contains "Music"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Gibson PAF Burstbuckers vs Bare Knuckle Nailbombs, by Richard Norton Guitar This audio contains someone playing a clean e-guitar melody that sounds soothing. This song may be playing at a little living room concert. 2013-03-01T13:31:31Z richardnortonsession This video A/Bs the standard Gibson PAF Burstbuckers, from the USA-made Gibson Standards / Customs, with the UK made Bare Knuckle Pickups "Nailbomb". We run through two core tones in this video - clean on all pickup selections, and high gain on the bridge pickups - with the BKP immediately following its Gibson counterpart. The Nailbombs are notorious for their high gain applications, but don't think they're just for metal! The cleans feel much more 'open' and breathy than the PAFs, allowing for additional clarity across the spectrum. Obviously, you have to take into account that the PAFs are closed, and the BKPs are open, but that doesn't have too much of an impact. For more info on Bare Knuckle Pickups, head over to www.bareknucklepickups.co.uk Thanks for watching and remember to Subscribe for more demos, tutorials and reviews. http://www.richardnortonguitar.com/ http://www.facebook.com/richardnortonguitar http://instagram.com/richsession ["Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] ["amateur recording", "clean e-guitar", "soothing melody", "medium to uptempo"] 6 xMCLKME4hAY 5324

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;