musiccaps_details (view)
3 rows where musiccaps_aspects contains "bongos", musiccaps_author = 7, musiccaps_names contains "Jazz" and musiccaps_names contains "Music"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Moray Naina | Zara Madani | Season 6 | Coke Studio Pakistan | This music is an electric guitar solo. The tempo is medium fast with rhythmic bongo , atmospheric synthesiser, soft drumming with Cymbal rides, oud riff and keyboard harmony. The music is densely layered. It is soothing, engaging, compelling, mesmerising and building up gradually. This music is Contemporary Indian Pop. | 2014-01-04T18:56:21Z | Rohail Hyatt | Produced by Rohail Hyatt https://www.facebook.com/rohail.hyatt.public | ["Jazz", "Music"] | ["instrumental", "electric guitar solo", "oud riff", "indian music", "contemporary indian pop", "coke studio", "oud", "congas", "bongos", "cymbal ride", "synthesiser arrangements", "atmospheric synthesiser", "pulsating", "rising tempo", "layers building gradually", "intense", "dense layers", "rich", "sonic delight", "percusssion", "lively", "engaging", "compelling"] | 7 | OjEG808MfF4 | 2462 | |
| 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 | |
| Perfume De Salsa - Dame Un Traguito (Music Video Latin Jazz/Salsa) | A female vocalist sings this spirited latin song.the tempo is medium fast with an animated piano accompaniment, rhythmic congas and bongos, funky bass line and bright trumpet harmony. The song is lively, spirited, upbeat, catchy, vivacious;vibrant and peppy with a salsa dance groove. This song is Latin Pop. | 2015-10-21T16:12:43Z | Sam Sam Music | Fabulous all women Latin Jazz / Salsa band Perfume de Salsa: On disc and download: http://www.samsammusic.com/Perfume-De-Salsa https://itunes.apple.com/us/album/solo-ella/id369866081 https://play.spotify.com/album/4Uhhl8qh5YiIibzNku0wpf http://www.amazon.com/Solo-Ella-Perfume-Salsa/dp/B003JJUJWS https://play.google.com/store/music/album/Perfume_de_Salsa_Solo_Ella?id=Bmu4rc6lk6hmr4ohcqoufeqbooa&hl=en http://www.rdio.com/artist/Perfume_De_Salsa/album/Solo_Ella/ http://www.deezer.com/album/543046 Subscribe to Sam Sam Music ➤https://bit.ly/34fRMti Great New Music Videos ➤ https://bit.ly/34fXevV Rock’n Roll Sixties ➤ http://bit.ly/RocknRollSixties Follow us on Social Media: Website ► https://bit.ly/2NGpfHJ Facebook ► http://bit.ly/2NJztas Twitter► http://bit.ly/32KMt3A Instagram► http://bit.ly/2NKdUXh #latin #salsa #jazzmusic | ["Singing", "Jazz", "Music", "Song", "Salsa music"] | ["female singer", "medium fast tempo", "vivacious", "animated", "spirited", "buoyant", "perky", "peppy", "cheerful", "vibrant", "latin music", "latin pop", "vic latin dance", "latin folk", "regional music", "world music", "animated piano", "lively trumpet", "groovy bass line", "bongos", "congas", "vocal backup"] | 7 | fPYeqTFc3IQ | 3944 |
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;