musiccaps_details (view)
4 rows where musiccaps_aspects contains "noisy", musiccaps_aspects contains "shimmering hi hats" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- low quality 4
- noisy · 4 ✖
- passionate 4
- shimmering hi hats · 4 ✖
- jazz 3
- groovy double bass 2
- mono 2
- arpeggiated guitar melody 1
- emotional 1
- french horn melody 1
- groovy piano 1
- intimate 1
- live performance 1
- mellow 1
- mellow piano chords 1
- passionate trumpet melody 1
- playback 1
- punchy snare 1
- relaxing 1
- saxophone solo melody 1
- smooth double bass 1
- snappy rimshots 1
- soft 1
- soulful 1
- trombone solo 1
- warm 1
musiccaps_names (array) 4 ✖
- Brass instrument · 4 ✖
- Saxophone 2
- French horn 1
- Trombone 1
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 | |
What a wonderful world Bb Horn | The low quality recording features a french horn melody played over playback that consists of snappy rimshots, shimmering hi hats and arpeggiated guitar melody. It sounds emotional and passionate, even though the recording is in mono and noisy. | 2009-01-31T21:52:21Z | KamilToni | Playing what a wonderful world on a Berkeley Bb piccolo/ mini french horn with a strawberries and creme mouthpieces MDC from kelly mouthpieces. i wasn't feeling good and i just wanted to post something up with this instrument.. | ["Brass instrument", "French horn"] | ["low quality", "mono", "noisy", "playback", "arpeggiated guitar melody", "snappy rimshots", "shimmering hi hats", "french horn melody", "emotional", "passionate"] | 4 | MNlzpCwdh4g | 2261 | |
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;