musiccaps_details (view)

2 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "steeldrums" and musiccaps_names contains "Music"

✎ 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
Sounds of Steel ~ Don't Stop 'til You Get Enough A lot of people are playing different parts of a funk song on steel-drums. An acoustic drum is playing a faster funk groove together with congas and shakers. This song may be playing outside at a live show. 2010-08-02T10:55:36Z SteeldrumTrust Sounds of Steel play "Don't Stop 'til You Get Enough" by Michael Jackson at the Blockorama in Trafalgar Square August 1st 2010 Video © Steel Drum Trust ["Music", "Steelpan"] ["funk", "steeldrums", "acoustic drums", "congas", "shaker", "uptempo", "amateur recording"] 6 Db0c4aAwUbY 1499
Steel Drum Players | Caribbean Music in Atlanta, Georgia Someone is playing a loud melody on a steeldrum along to a backing track with a lot of percussion and an upright bass. This song may be playing at a beach concert. 2011-09-12T21:03:18Z PartyPOP http://www.partypop.com/vendor.htm/4114102 Paul Vogler - Steel Drum Players www.paulvogler.com Paul Vogler's musican days began in 1967 as drummer in rock & roll garage band, Jynx. In the mid 1970's Paul backed up magician Steven Calder & played parties & coffee houses in Washington, DC. In 1977 Paul came home to Atlanta joining Possum Trot, an eclectic/electric bluegrass band. Possum Trot played Burt Reynolds club & cast parties for both Kristy McNichol & Jody Foster. They also played on the sets of Don Knox & Tim Conway's 1979 movie: The Prize Fighter & and at the famed Alex Cooley's: Electric Ballroom. Possum Trot were regulars on River Street in Savannah, GA. Possum Trot opened/appeared with The Nitty Gritty Dirt Band, Elvin Bishop & others. In the 1980's, Paul did a short stint playing New Wave venues, including Athens GA's 40 watt Club & a host of colleges and clubs throughout the Southeast. Returning to college to finish his degrees in music , Paul began playing jazz. As a jazz musician, Paul Vogler has appeared on the bill with Thelonius Monk Jr., Dr. Billy Taylor & The New York Voices. Paul Vogler was pecussionist in the 90's band "Radio Kings", catering to the swing dance craze of the time. Also, during that time, Paul assisted in the creation of The Bessie Bus", a mobile jazz and blues education program, winner of the 1997 Dorothy Mullen National Arts Award. He also helped produce "When the Spirit Moves", a traveling exhibit of the National Afro-American Museum, exhibited in the United States (including the Smithsonian Institution in Washington, DC) and traveling internationally through the US State Department. "Our Minds Are On Georgia" a grant-funded program incorporating writing blues lyrics and producing a CD; designed to meet 3rd grade curriculum requirements for the Georgia unit of study was co-created by Paul. Paul continued composing, arranging and producing music and video for museums, educational programs and institutions including: Georgia Music Hall of Fame, Tennessee Aquari… ["Drum", "Music", "Musical instrument", "Steelpan", "Inside, small room"] ["caribbean", "steeldrums", "backing track", "amateur recording"] 6 xJYBA7VTkHA 5316

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;