musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "vibrant" and musiccaps_names contains "Saxophone"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Paganini on Saxophone (Audio) | This music is instrumental. The tempo is fast with a vigorous and rapid western classical saxophone harmony. It is spirited, vibrant,untiring, engaging, skillful and high-spirited. | 2009-04-11T15:06:22Z | hkams | Paganini Caprices No. 1 and 5 on alto saxophone by saxophonist Raaf Hekkema | ["Brass instrument", "Saxophone"] | ["instrumental", "fast tempo", "western classical", "vibrant", "untiring", "sax concerto", "dimuendo", "enthusiastic", "lively vigorous", "woodwind", "single reed instrument", "incessant"] | 7 | TsTdffJ9LHg | 2873 | |
| Donald Sinta Quartet- Escaich: Tango Virtuoso | This is a live performance of classical music with clear tango influences. The piece is being performed by four different ranges of saxophone: alto, baritone, tenor and soprano. The variety of range using similar characteristics of sound gives the piece a vibrant atmosphere. This piece could be used in the soundtrack of a movie that is about a culture clash situation between North American and Latin American characters. | 2013-12-04T20:39:04Z | ConcertArtistsGuild | Dan Graser, soprano saxophone Zach Stern, alto saxophone Joe Girard, tenor saxophone Danny Hawthorne-Foss, baritone saxophone The Donald Sinta Quartet, First Prize Winner of the 2013 CAG Victor Elmaleh Competition, has earned praise from audiences and critics alike for its committed performances, recordings, and distinctive repertoire. Other competition successes include the Alice Coleman Grand Prize at the 2013 Coleman Chamber Music Competition and First Prize in the 2012 North American Saxophone Alliance Quartet Competition. The DSQ was featured for the world premiere performance of Pulitzer Prize-winning composer William Bolcom's Concerto Grosso for Saxophone Quartet and Band, joining the University of Michigan Symphony Band as a soloist for a tour through China and Los Angeles. Performances took place at the National Center for the Performing Arts in Beijing, Walt Disney Concert Hall in Los Angeles, and the Shanghai Conservatory. The quartet's subsequent recording of the work garnered praise: Audiophile Audition declared them "superb musicians" and American Record Guide called it "the highlight of the album." Upcoming engagements include festival appearances at Music from Angel Fire and the Rockport Chamber Music Festival, recitals at St. Bonaventure University and Market Square Concerts, and a concerto performance with the Dallas Wind Symphony. Recent highlights abroad are recitals in St. Andrews, Scotland, where the group was featured at the 16th World Saxophone Congress, and in Paris, France and Thessaloniki, Greece. The Quartet's repertoire is diverse, ranging from commissions by today's emerging composers to standards from the saxophone quartet literature to transcriptions by master composers such as Dvorak, Schubert, and Shostakovich. As advocates of new music, the DSQ commissions and premieres new works regularly and runs the National Saxophone Quartet Composition Competition, which selects two new quartet works from up-and-coming composers annually. The group is named for its mentor, legend… | ["Brass instrument", "Clarinet", "Saxophone"] | ["classical music", "tango", "no singer", "instrumental", "live performance", "saxophone quartet", "vibrant", "lively", "eccentric", "unique"] | 9 | WWIT13tTW7c | 3101 | |
| Miles Davis Quintet - Doxy | This is a jazz music piece. There is a trumpet and a saxophone playing the lead melody. The piano is playing the chords of the piece while the upright bass is playing a groovy bass line. The acoustic drums are playing a swing type beat for the rhythmic background. The atmosphere is groovy. This piece could be playing in the background at a coffee shop. | 2014-06-22T16:09:17Z | 60otaku4 | Miles Davis Quintet - Doxy (1954) Personnel: Miles Davis (trumpet), Sonny Rollins (tenor sax), Horace Silver (piano), Percy Heath (bass), Kenny Clarke (drums) from the album 'BAGS' GROOVE' (Prestige Records) | ["Brass instrument", "Saxophone", "Trumpet"] | ["jazz", "instrumental", "trumpet", "saxophone", "upright bass", "piano", "acoustic drums", "groovy", "vibrant"] | 9 | XpueyrkcMyQ | 3228 |
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;