musiccaps_details (view)

1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "gear" and musiccaps_aspects contains "rhythm machine"

✎ 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
KR Mini: Energize your practices and performances with diverse rhythm patterns! This is an advertisement video for a rhythm machine. Firstly, it is shown playing behind a bass guitar jam. Then, it is shown playing behind an acoustic guitar jam. A male voice is describing the benefits and functions of the rhythm machine. The parts where the instruments can be heard without the interruption of the voice can be sampled for use in beat-making. 2013-09-05T01:01:42Z Korg Designed for guitarists, bassists, pianists or any musician looking for easy rhythm accompaniment, the KR mini features nostalgic looks and a simple design focused on easy, push-button control. The KR mini is also lightweight, can run on batteries and has a built-in speaker, allowing it to provide a backing rhythm pattern anywhere at any time. With a total of 60 diverse rhythm patterns across the genres, the compact KR Mini is ready to accompany any performance. For more information on the KR Mini Rhythm Machine, head over to http://www.Korg.com/KRmini. "Like" us -- https://www.facebook.com/KORGusa "Follow" us -- https://www.twitter.com/KorgUSA ["Guitar", "Musical instrument", "Drum machine", "Plucked string instrument"] ["jam", "gear", "rhythm machine", "electronic drum beat", "bass guitar", "acoustic guitar", "male voice", "advertising"] 9 rS8oECcQBCk 4877

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;