musiccaps_details (view)
3 rows where musiccaps_aspects contains "jazz", musiccaps_aspects contains "noisy", musiccaps_aspects contains "shimmering hi hats" and musiccaps_names contains "Brass 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 |
---|---|---|---|---|---|---|---|---|---|---|
Ben Webster - For All We Know | The low quality recording features a jazz song that consists of a saxophone solo melody played over groovy piano, groovy double bass, shimmering hi hats and punchy snare. It sounds passionate and soulful, even though the recording is noisy and in mono. | 2010-03-07T16:01:07Z | IrishDutchman | A great tune played in an uncharacteristically upbeat tempo by the master of ballads, Ben Webster. It sounds like the band is having a great time and if you listen closely you can overhear a few snippets of conversation between the players. Sadly I don't know who he recorded this track with. If you happen to know, feel free to send me a message. Hope you like it! | ["Brass instrument", "Saxophone"] | ["low quality", "noisy", "mono", "jazz", "saxophone solo melody", "shimmering hi hats", "groovy piano", "groovy double bass", "passionate", "soulful", "punchy snare"] | 4 | 8sSV_vqOlS4 | 957 | |
BOBBY HACKETT THE GREATEST CORNETIST | The low quality recording features a jazz song that consists of a passionate trumpet melody in the left channel of the stereo image and mellow piano chords in the right channel, followed by smooth double bass and shimmering hi hats. It sounds soft, mellow, passionate and relaxing. The recording is a bit noisy. | 2009-02-20T18:31:54Z | TheMurphyFamily | Bobby Hackett, the cornetist whose mellow tone and graceful style made him a favorite of both jazz and pop music audiences. Whitney Balliett described Bobby Hackett in The New Yorker as "a unique and extremely successful alloy of Beiderbecke and Armstrong." "His tone." Mr. Balliett wrote "which is quiet and shining, resembles Beiderbecke's and so does his three-steps-up, two steps down method of improvising. But his sustained notes and way of playing just behind the beat and of occasionally slipping into double time are straight out of Louis Armstrong." Born in Providence, R.I. Bobby Hackett began his music career by studying the violin but switched to the trumpet and later to the cornet. He began playing professionally while in his teens and was soon appearing with some of the best known names of the "Big Band Era." Bobby Hackett appeared with Benny Goodman, Louis Armstrong, Glenn Miller and Paul Whiteman among others. "Music should be pretty," he said. "You should hear and recognize the melody. And real greatness is in the simplicity. Simple things are the hardest to play and the easiest to listen to." | ["Brass instrument", "Saxophone"] | ["low quality", "noisy", "jazz", "passionate trumpet melody", "shimmering hi hats", "mellow piano chords", "smooth double bass", "soft", "mellow", "passionate", "relaxing"] | 4 | TIAj-fi_R7c | 2828 | |
Jazz Cimbasso - Donna Lee, WDR Big Band featuring Mattis Cederberg | The low quality recording features a live performance of a jazz song and it consists of groovy double bass, trombone solo and shimmering hi-hats. The recording is a bit noisy and it sounds warm, intimate and passionate. | 2012-01-20T22:52:27Z | cimbassonista | Here's an arrangement of Donna Lee by Michael Philip Mossman. The WDR Big Band featuring me on cimbasso. As always, I play the HAAG cimbasso. | ["Brass instrument", "Trombone"] | ["low quality", "noisy", "intimate", "live performance", "jazz", "trombone solo", "groovy double bass", "shimmering hi hats", "passionate", "warm"] | 4 | p1DNl8BF49U | 4677 |
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;