musiccaps_details (view)
4 rows where musiccaps_aspects contains "mono" and musiccaps_names contains "Orchestra"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- live performance 4
- low quality 4
- mono · 4 ✖
- noisy 4
- orchestra 3
- passionate 3
- muffled 2
- distorted 1
- energetic 1
- energetic drums 1
- epic 1
- exotic 1
- loud brass section melody 1
- mellow woodwinds melody 1
- muddy 1
- muffled percussion 1
- powerful 1
- reverberant 1
- shimmering cymbals 1
- staccato strings melody 1
- steel drums melody 1
- suspenseful violin melody 1
- sustained brass melody 1
- sustained strings melody 1
- sustained woodwinds melody 1
musiccaps_names (array) 8 ✖
- Orchestra · 4 ✖
- Drum 1
- Drum kit 1
- Music 1
- Musical instrument 1
- Percussion 1
- Steelpan 1
- String section 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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;