musiccaps_details (view)

5 rows where musiccaps_aspects contains "muffled", musiccaps_author = 4 and musiccaps_names contains "Orchestra"

✎ 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
orchestra jamal The low quality recording features a traditional song that consists of a repetitive and addictive string melody, wooden percussion and shimmering cymbals. It sounds really energetic and addictive - almost like a pop song would. The recording is a bit noisy and the left channel of the stereo image is occasionally muffled. 2012-09-30T12:52:43Z jamal chaouad orchestra jamal.wmv ["Traditional music", "Music", "Orchestra"] ["low quality", "traditional", "upbeat", "repetitive addictive strings melody", "wooden percussions", "shimmering cymbals", "energetic", "addictive", "muffled", "noisy"] 4 CeaWlENtRio 1389
Cantor Helfgot @ Lincoln Center The low quality recording features a live performance of a classical song that consists of a fruity male opera singer over a piano melody. In the background there are coughing and telephone ring sounds. The recording is noisy, muffled and it sounds emotional and passionate. 2008-01-02T17:40:24Z yessory Helfgot sings Vlirusholayim Ircha, Avery Fisher Hall, Dec. 02, 2007. At the concert while this selection was sung, rare footage of how Moshe koussevitsky masterfully sang this selection were shown. The recorded audio appears with a slideshow of pictures, from previous Helfgot Performances. ["Singing", "Mantra", "Music", "Opera", "Orchestra", "Classical music"] ["low quality", "live performance", "reverberant", "noisy", "muffled", "coughing", "classical", "opera", "fruity male vocal", "piano melody", "emotional", "passionate", "telephone ring"] 4 PFa1XVCgPgM 2522
Star Trek Suite The low quality recording features a live performance of an orchestra playing sustained brass melody, shimmering cymbals and sustained strings melody. It sounds muddy and muffled, as it was probably recorded with a poor quality microphone, but also passionate. The recording is noisy and in mono. 2007-11-18T07:49:15Z George Yefchak "Star Trek Through the Years" (excerpts). Nova Vista Symphony conducted by George Yefchak while wearing a Starfleet Commander uniform (sciences division, circa 2373). ["Orchestra"] ["live performance", "low quality", "orchestra", "muffled", "muddy", "mono", "noisy", "sustained brass melody", "shimmering cymbals", "sustained strings melody", "passionate"] 4 Y8plCTF8xsY 3258
Ennio Morricone Vienna 12.12.2007 (part 4) The low quality recording features a live performance of an orchestra and it consists of loud brass melody, mellow woodwinds melody, suspenseful violin melody and muffled percussion. It sounds epic, powerful and passionate. The recording is in mono, a bit noisy and it is reverberant as it was performed in a large concert hall. 2008-08-12T15:10:07Z Tomáš Vlček Ennio Morricone conducts his own music at Vienna Stadthalle - Ecstasy of gold (reprise). ["String section", "Orchestra"] ["low quality", "live performance", "noisy", "mono", "reverberant", "orchestra", "muffled", "epic", "powerful", "passionate", "suspenseful violin melody", "muffled percussion", "loud brass section melody", "mellow woodwinds melody"] 4 cJ80eZY03Yg 3697

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;