musiccaps_details (view)
2 rows where musiccaps_aspects contains "bongos", musiccaps_author = 7, musiccaps_names contains "Drum" and musiccaps_names contains "Musical instrument"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Brazil | This song is an instrumental. The tempo is medium fast with melodious steel pan, rhythmic percussion like bongos and congas, guitar sound, steady bass line and keyboard harmony. The sound of the breeze in the background indicates that music is being played outdoors. The music is invigorating, playful, light, pleasant, mellifluous and warm. | 2009-04-26T18:16:34Z | Steel Drum Music | Now on iTunes ♫ → click the 'Show More' button for info ↓ ↓ ↓ Caribbean classics played on steel drums from Trinidad. This song is featured on the 'Steel Drum Gold' album. You can get it at: iTunes - http://bit.ly/aE3djW Amazon - http://bit.ly/cgT7rA or directly from Bob Lyons' web site: http://www.SteelDrumMusic.net The very popular samba 'Brazil' performed at ER Bradley's in West Palm Beach on 4/25/09 | ["Drum", "Drum kit", "Music", "Musical instrument", "Bass drum", "Percussion", "Steelpan"] | ["instrumental", "medium fast tempo", "lively", "steel pan", "sound of bike starting", "sound of breeze", "windy", "guiero rhythm", "recycled instrument", "discarded oil drums", "keyboard harmony", "steady bass line", "people talking", "guider sound of breeze", "guiro rhythm", "simple music", "catchy", "upbeat", "rhythmic congas", "bongos"] | 7 | NtM3gudMBCQ | 2375 | |
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
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;