musiccaps_details (view)

1 row where musiccaps_aspects contains "flute harmony", musiccaps_aspects contains "moderate tempo" and musiccaps_aspects contains "tambourine"

✎ 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
Performance Techniques for Tambourine by Daniel Smithiger This orchestral song features flutes playing the main melody. This is backed by bass played on the cello. The percussion is played on the tambourine. This song is in a compound time signature. Toward the end of the clip, the tambourine sound is played loud in a specific rhythm. 2010-08-04T16:57:45Z Black Swamp Percussion Daniel Smithiger, BSP Education Consultant, has developed a new series of educational reference materials exploring basic performance techniques for common accessory percussion instruments. The series is geared towards beginning percussion students, as well as music directors aspiring to expand their knowledge of percussion performance. This corresponding video demonstration of select tambourine techniques provides another level of tutorial with close up, over-the-shoulder and wide angle shots. - - - - [ Official Website ] www.blackswamp.com - - - - [ Get Social ] Newsletter: http://bit.ly/BSPFam Podcast: http://bit.ly/BlackSwampPod Facebook Group: https://www.facebook.com/groups/BSPFam/ Facebook: https://www.facebook.com/blackswampperc/ Instagram: https://www.instagram.com/blackswamppercussion/ Twitter: https://twitter.com/blackswamp - - - - #blackswamp #percussion #music #drums #percussionist #drummer #drumming #orchestra #band #tambourine ["Music", "Tambourine"] ["orchestral music", "no voices", "moderate tempo", "flute sounds", "tambourine", "flute harmony", "instrumental", "string section"] 0 aq3vov8-fw8 3576

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;