musiccaps_details (view)

4 rows where musiccaps_aspects contains "classical" and musiccaps_names contains "Saxophone"

✎ 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
GoPro on Trombone: Crescent Moon The low quality recording features a live performance of a classical song and it contains trombone melody playing over shimmering hi hats and sustained strings. It sounds muffled, but also passionate and emotional. 2014-09-22T18:25:32Z Manuel Nägeli Crescent Moon von Jan Van der Roost. Gespielt vom Symphonischen Blasorchester des Schweizer Armeespiels, dirigiert von Major Philippe Monnerat. ["Brass instrument", "Orchestra", "Saxophone"] ["low quality", "classical", "live perfomrance", "shimmering hi hats", "trombone melody", "sustained strings", "muffled", "passionate", "emotional"] 4 9K8EePrEDdo 994
Ana Maria Tarantus Sandu The low quality recording features a cover of a classical song and it consists of a saxophone solo melody playing over a groovy piano melody. At the very end of the loop, there is an applause. It sounds easygoing, passionate and the recording is noisy and in mono. 2010-11-27T18:22:17Z Emanoil Tarantus Hora Lautareasca si Piesa de Concert ["Brass instrument", "Saxophone", "Wind instrument, woodwind instrument"] ["low quality", "mono", "noisy", "applause", "saxophone melody", "groovy piano melody", "classical", "cover"] 4 LaeRCg-NdeY 2204
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
Introduction et variations sur une ronde populaire, Henri Pierné This audio contains people playing saxophones in all ranges and with a fast melody. This song may be playing as part of an orchestral performance. 2011-02-27T00:37:25Z MichiganSaxStudio Introduction et variations sur une ronde populaire, Henri Pierné Performance by Echo Saxophone Quartet: Spring 2010 Students of Donald Sinta Dan Graser (2nd year Doctoral at time of recording) Katherine Weintraub (Senior at time of recording) Chris Bartz (2nd year Masters at time of recording) Andy Hall (1st year Masters at time of recording) ["Brass instrument", "Clarinet", "Saxophone"] ["amateur recording", "orchestral", "saxophones", "fast tempo", "classical"] 6 v5SsASLy2c8 5154

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;