musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance", musiccaps_author = 9 and musiccaps_names contains "Saxophone"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- instrumental 3
- live performance · 3 ✖
- no singer 3
- saxophone solo 2
- acoustic drums 1
- bass guitar 1
- classical 1
- classical music 1
- complex 1
- eccentric 1
- emotional 1
- improvisation 1
- jazz 1
- lively 1
- movie music 1
- organ 1
- piano 1
- poor quality 1
- romantic 1
- saxophone 1
- saxophone quartet 1
- tango 1
- tranquil 1
- unique 1
- vibrant 1
musiccaps_names (array) 5 ✖
- Saxophone · 3 ✖
- Brass instrument 2
- Clarinet 1
- Music 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joey DeFrancesco & George Coleman - Ceora | This is the live performance of a jazz music piece. There is an organ playing the chords in the background. There is a complex and improvised saxophone solo in the lead. The acoustic drums are playing a mellow jazz beat. The atmosphere is rather tranquil. This piece could be playing in the background at a coffee shop or a classy restaurant. | 2011-02-05T19:16:50Z | Peter W. Bosse | Joey DeFrancesco (Hammond B-3 organ) George Coleman (saxophone) Jake Langley (guitar) Byron Landham (drums). rec. 2006 | ["Brass instrument", "Saxophone"] | ["jazz", "live performance", "no singer", "instrumental", "organ", "saxophone solo", "bass guitar", "acoustic drums", "tranquil", "complex", "improvisation"] | 9 | CYuYfvQv4eo | 1376 | |
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 | |
Beauty and the Beast - Saxophone Wedding Song | This is a live performance of a movie music piece. The recording has a very poor quality. The saxophone is playing the main tune while the piano can be heard providing a melodic background. The atmosphere is romantic and it is probably a wedding setting. | 2008-04-27T14:01:36Z | saxophonedaniel | Beauty and the Beast - Saxophone Wedding Song | ["Music", "Wedding music", "Saxophone"] | ["movie music", "classical", "live performance", "no singer", "instrumental", "saxophone", "saxophone solo", "piano", "romantic", "emotional", "poor quality"] | 9 | as7MhTe961k | 3581 |
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;