musiccaps_details (view)

1 row where musiccaps_aspects contains "keyboard", musiccaps_author = 9 and "youtube_published" is on date 2008-12-08

✎ 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
ZOZO AFROBEAT "Country of Guns " This is an afrobeat music piece. The melody is being played by a vibrant orchestra of brass sections with a saxophone lead, a keyboard, an electric guitar and a bass guitar. In the rhythmic background, there is an afrobeat acoustic drum beat played with numerous percussion instruments. The atmosphere is playful. The piece could be used in the soundtrack of an action-filled movie or TV series. It could also be used in the soundtrack of an action video game. 2008-12-08T02:38:40Z Zozo Afrobeat Zozo Afrobeat // The Hottest Side of Afrobeat// zozoafrobeat.com Zozo, taken from the Goun and Fon word for something hot, truly keeps the Afrobeat fires burning. A 13-piece ensemble from New York City, Zozo Afrobeat features musicians from around the world and is led by African music luminary Kaleta. Born in the Republic of Benin and raised in Nigeria, Kaleta grew up recording and performing with legendary Nigerian musicians Fela Kuti and King Sunny Ade. After moving to the U.S., Kaleta toured with Femi Kuti and most recently with Lauryn Hill. With Zozo Afrobeat, Kaletas music pays homage to the greats, and yet has its own distinctive sound and energy. Like Fela Kuti, who used his music to challenge a corrupt Nigerian government, Kaleta has written songs that are socially and politically provocative. At the same time, his lyrics reflect a keen sense of humor and a message of hope. On Zozo Afrobeats 2007 release, Country of Guns, Kaleta scatters pop-culture references and marvels of a country with 250 million people and 250 billion guns. On other songs, Kaleta sings in Yoruba, Goan, Fon, and French. On stage, Kaleta displays remarkable energy singing, dancing, and playing guitar and percussion. The band responds accordingly, delivering cascades of horns, hypnotic Benino-Nigerian rhythms, and captivating solos. Zozo Afrobeat has played at the Lincoln Center Out of Doors Festival, the Brooklyn Museum, and various clubs in the New York area. Zozo is: Kaleta (Leon Ligan-Majek): composer, lead vocal, guitar, percussion, leader Rep. of Benin+Nigeria Benon Lipowski : guitars Poland Brett Leghorn: trombone, vocals USA David Aaron: tenor saxophone, vocals Canada Jeremy King: congas/percussion USA Dave Ahl: keyboards, band director USA Jeremy Kay: bass guitar USA Rodney Siau: trumpet, shekere, vocals USA Brett Gregory: baritone saxophone USA Gloria Osaghae: vocals, shekere, claves Nigeria Mai Lingani: vocals Burkina Faso ["Afrobeat", "Music"] ["afrobeat", "electric guitar", "bass guitar", "keyboard", "brass", "saxophone", "acoustic drums", "percussion", "vibrant", "colorful", "playful", "upbeat"] 9 IpYw4nKPx5o 1944

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;