musiccaps_details (view)

1 row where musiccaps_aspects contains "percussion instruments", musiccaps_names contains "Drum" and musiccaps_names contains "Steelpan"

✎ 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
Andy Narell & Relator- University of Calypso This music is instrumental. The tempo is fast with lively percussion rhythms of the drums, cymbal riffs, congas, bongos, steel pan and piano accompaniment. The music is lively, spirited, engaging, funky, groovy and buoyant. This music is a percussive instrumental. 2009-08-18T15:01:50Z HeadsUpRecords Featuring Dario Eskenazi, Pedro Martinez, Gregory Jones, Mark Walker, and Special Guest Paquito DRivera With Andy Narell—whos been playing calypso music from Trinidad since he was barely tall enough to reach the pan—its always been about expanding the role of the steelpan in jazz. Now, with the June 23, 2009 release of University of Calypso (HUCD3168) on Heads Up International, a division of Concord Music Group, Narell joins forces with calypso legend Relator to explore the role of jazz in vintage calypso. Together, they perform 15 classic compositions by Lord Kitchener, Lord Melody, Mighty Terror, Roaring Lion, Spider, and Relator, supported by a group of world-class Latin-jazz cats who can swing the calypso and blow le jazz hot. Its been over 50 years since a major calypsonian went into the studio with a bunch of jazz players. This CD is cause for serious celebration! In many ways this project was inspired by Lord Kitcheners forays into jazz in the 1950s. Kitchener (real name Aldwyn Roberts; now respectfully nicknamed Grandmaster) was arguably the greatest songwriter in the history of calypso. Born in Trinidad in 1922 (where he passed away in 2000) he was largely responsible for calypsos evolution into a melodically and harmonically sophisticated music. He was a fabulous lyricist as well, and a great commentator and humorist on a wide array of subjects. He emigrated from Trinidad to London in 1948, where he discovered jazz—and wrote a very hip composition called "Bebop Calypso" praising Charlie Parker and Dizzy Gillespie. He stayed in London throughout the 50s, playing with jazz musicians and making numerous recordings that revolutionized calypso music. Along with Trinidadian musicians like Rupert Nurse, Fitzroy Coleman, and Russ Henderson, Kitchener created a new jazz-influenced big band sound that suited calypso perfectly—and when he returned to Trinidad, 17 years later, it was as a hugely successful entertainer with scores of hit records to his credit. Nearly half this album is drawn from his songbook. "Od… ["Drum", "Jazz", "Music", "Musical instrument", "Steelpan"] ["instrumental", "fast tempo", "intense drumming", "infectious drumming", "percussive instrumental", "piano accompaniment", "congas", "bongos", "steel pan", "percussion instruments", "cymbals", "upbeat", "lively catchy", "energetic", "enthusiastic", "hand percussions", "piano accompaniment"] 7 WCl93HBuj60 3075

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;