musiccaps_details (view)
10 rows where musiccaps_aspects contains "live performance", musiccaps_author = 4 and musiccaps_names contains "Orchestra"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Omar Faruk Tekbilek Ensemble ~ "LAZ" | The low quality recording features a live performance of a folk song and it consists of a metallic percussive melody, wooden percussions, acoustic guitar melody and flute melody. It sounds soulful, upbeat and passionate and the recording is noisy. | 2010-03-19T23:48:08Z | Anthony Mazzella | Omar Faruk Tekbilek Ensemble featuring Anthony Mazzella, River Guerguerian, Bahadir Sener, Murat Tekbilek, Yannis Dimitriadis. Recorded on March 16, 2010in Trento Italy. | ["Orchestra"] | ["low quality", "folk", "noisy", "live performance", "metallic percussive melody", "wooden percussions", "acoustic guitar melody", "flute melody", "soulful", "upbeat", "passionate"] | 4 | 8kx5ST65Fog | 941 | |
| Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 | |
| Vaughan Williams Tuba Concerto Part 3 | The low quality recording features a live performance that consists of a tuba solo melody and some loud impact in the background. The recording is noisy, loud and distorted. | 2008-06-17T12:09:48Z | sersvet | National Filarmonica, Chisinau,R.V. Williams - Tuba Concerto, Part 3. Solist Serghei Svet | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Orchestra"] | ["low quality", "loud", "distorted", "loud impact", "tuba solo melody", "noisy", "live performance"] | 4 | KB4e9v_5uTE | 2062 | |
| Russian Sailor's Dance, CHS Symphony Orchestra | The low quality recording features a live performance of an orchestra that consists of staccato strings melody and sustained woodwinds melody at least. The recording is very noisy, to the point that it is distorting, and in mono - as it was probably recorded with a poor quality microphone. | 2008-05-22T11:27:06Z | CHSBandBooster | Russian Sailor's Dance, CHS Symphony Orchestra Russian Sailor's Dance by R. Gliere preformed by the Coronado High School Symphony Orchestra. Ida Stedman, Orchestra director. The Symphony Orchestra is composed of students from Band and the String Orchestra. The EPISD Festival for Orchestra was held on Thursday May 15, 2008 at the "Ross Capshaw Auditorium" Coronado High School in El Paso Texas. | ["Orchestra"] | ["low quality", "noisy", "live performance", "mono", "orchestra", "distorted", "staccato strings melody", "sustained woodwinds melody"] | 4 | O6xMQnKJROc | 2400 | |
| 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 | |
| The Silkroad Ensemble: Canal by Ljova | SILKROAD | The low quality recording features a live performance of a classical song that consists of sustained strings, woodwinds melody, aggressive strings lick, wooden percussion and repetitive violin melody. It sounds suspenseful and intense. | 2014-01-06T20:07:45Z | SILKROAD | For more information about the Silkroad Ensemble and Silkroad, visit http://silkroad.org This first reading of "Canal" by Lev Zhurbin (Ljova) was shared as a new work in progress during a Silkroad Ensemble residency at Harvard University in December 2013. Silkroad commissioned the piece as part of an ongoing multidisciplinary exploration of rivers. Learn more: http://www.silkroad.org/ Follow Silkroad here: https://www.facebook.com/silkroadproject https://twitter.com/silkroadproject https://www.instagram.com/silkroadproject See Silkroad Live: http://www.silkroad.org/calendar | ["Orchestra"] | ["low quality", "live performance", "classical", "sustained strings", "woodwinds melody", "aggressive strings lick", "wooden percussion", "repetitive violin melody", "suspenseful", "intense"] | 4 | YAYp2E5vMNw | 3261 | |
| 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 | |
| Johann Sebastian Bach concierto para clave en fa menor | The low quality recording features a live performance of a classical song that consists of a woodwinds melody, sustained strings melody and double bass melody. It sounds passionate and the recording is in mono and noisy. | 2009-03-31T03:44:15Z | Gisela Gregori - Clave y Piano | Johann Sebastian Bach 1685-1750 concierto para clave en fa menor BWV 1056 2do movimiento: Largo 3er movimiento: Presto Solista: Gisela Gregori 22 12 2009 Santa Rosa, La Pampa, Argentina | ["Cello", "Double bass", "Orchestra", "Violin, fiddle", "Bowed string instrument"] | ["low quality", "live performance", "noisy", "classical", "woodwinds melody", "sustained strings melody", "double bass melody", "passionate"] | 4 | mlrarQ5nVlU | 4491 | |
| Renegades Steel Orchestra | The low quality recording features a live performance of steel drums, followed by energetic drums in the background. It sounds exotic, passionate, energetic and the recording is noisy and in mono. | 2008-02-16T07:33:29Z | panjumbie | Highest-profile ambassadors for the steel pan music, the Renegades Steel Orchestra from Trinidad & Tobago on European Tour 2007. The Panyard Bern (Switzerland) hosted 3 concerts (10 - 12 July 2007) at http://www.thepanyard.ch These 3 concerts have been sponsored by: pan-jumbie.com, panmusic.ch, panch.ch, funlandserenaders.ch, Richardson Steeldrums, and brewery Feldschlösschen Video production by VJ Peter Krüsi | ["Drum", "Drum kit", "Music", "Musical instrument", "Orchestra", "Percussion", "Steelpan"] | ["low quality", "live performance", "steel drums melody", "energetic drums", "energetic", "exotic", "passionate", "mono", "noisy"] | 4 | x22NHqwKSNE | 5302 |
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;