musiccaps_details (view)

1 row where musiccaps_aspects contains "eccentric", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "saxophone quartet"

✎ View and edit SQL

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
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;