musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "playful" and musiccaps_aspects contains "upbeat"
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 | |
| A Griffon Day | This is a big band jazz music piece. It is an instrumental piece. The main melody is played by a wide variety of the winds section composed of the saxophone, the trumpet, the flute and the clarinet. The piano and the upright bass provide backing structures. The rhythmic background consists of a jazz acoustic drum beat. The atmosphere is playful. This piece could fit perfectly in the soundtrack of a Disney-type animation movie. | 2008-01-27T00:18:25Z | George Pfeiffer | Gus the Brussels Griffon documents a typical day in his life. If you like dogs...or monkeys...or Ewoks....then you'll love this little pooch! | ["Swing music", "Jazz", "Music"] | ["jazz", "big band", "instrumental", "winds section", "saxophone", "trumpet", "flute", "clarinet", "upright bass", "piano", "acoustic drums", "lively", "playful", "upbeat"] | 9 | JU6GUqRqbtI | 2011 |
Advanced export
JSON shape: default, array, newline-delimited
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;