musiccaps_details (view)

1 row where musiccaps_aspects contains "wide arpeggiated electric guitar melody", musiccaps_names contains "Electric guitar" and "youtube_published" is on date 2009-07-30

✎ 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
Mayones Guitar Demo 2 by Ben Randall - Mayones Regius PRO 6 The low quality recording features a wide arpeggiated electric guitar melody. It sounds clean, passionate and the recording is a bit noisy. 2009-07-30T18:48:06Z BenRandallGuitar Mayones Guitar Demo 2 by Ben Randall - Mayones Regius PRO 6 Regius PRO 6 with Schaller Floyd Rose PRO for dive-bombing, fluttering, vibratoing and whatever else you like with the reliability of 11-pieces neck-thru construction. Standard 25,4" scale only. Ergonomic contoured body perfectly shaped for easy access to the upper frets. Swamp Ash body for modern sound with quick attack or Mahogany for more warm and round tones. Artist-grade Flamed Maple 'radiused' top. Strings-thru-body fixed bridge for the wood vibration enhancement. Equipped with Sperzel locking tuners and Seymour Duncan, EMG or DiMarzio pickups. Several colour options and hardcase included. http://www.mayones.com http://www.blackhawkmusic.co.uk http://www.myspace.com/benrandallguitar For more information, contact Ben Hawker: Call +44 (0)7990 828779 or Email ben@blackhawkmusic.co.uk ["Echo", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] ["low quality", "noisy", "wide arpeggiated electric guitar melody", "clean", "passionate"] 4 IIK0EuHyb6w 1890

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;